ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 2 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 26 May 2017 My Price 9.00

SPREADSHEET PROJECTS

Hi, my friend has this site and recommended I ask you this question.

I don't have many tutor credits but I will give you $35 and $5 tip if you do good work. (Total $40)

I am behind on all of my courses and I need someone to do an Excel project because I don't have the time to read through the book on formulas for Excel.

Can you please read through the attached file and tell me if you could please do this Excel project for me Please?

I have two exams and I'm behind in my class work. I need serious help on this Excel project.

Please Please help if you can. Hope to hear from you. 

Thank you very much.

 

SPREADSHEET PROJECTSComplete these projects to see how well you’ve mastered basic spreadsheettechniques.For each one, type your name in cell A1, your class in cell A2, the project number incellF1, and the date in cell F2. Do not change column widths for these four labels, butallowthe longer labels to spill over into the next cell.Project 1Class Grades I:Create a class report with headings and columns ofproperwidth for STUDENT NAME, TEST 1, TEST 2, TEST 3, and AVERAGE. Type sixnames into the worksheet, with three test scores each. Have the spreadsheetautomaticallycalculate and display in the AVERAGE column the average of the three scores foreachstudent. Format all numbers to show no. Save the workbook as SHEET1 and print it.Project 2Class Grades II:Open SHEET1.Add four names to the list of six and threetest scores for each new name. Copy the average formula so that all students showaverages.Create a class average row along the bottom. Have the worksheet calculate anddisplaythe average for each test column and an overall average in the average column.Formatthe averagecolumn(notrow) to show one decimal. Save the workbook as SHEET2and print it.Project 3Class Grades III:Open SHEET2.Delete the second student row. Create abar chart that displays each student’s name and overall average. Add titles. Labelthesheet tabs appropriately. Save the workbook as SHEET3. Print the chart only.Project 4Expense Report I:Create a six-month expense report as follows:EXPENSE JAN FEB MAR APR MAY JUN TOTAL AVGRENT 400 400 400 420 420 420PHONE 68 75 50 48 55 65FOOD 125 145 175 170 150 120CLOTHES 200 75 150 50 75 100MISC 120 50 65 100 125 60Add a TOTAL row beneath all columns. Format all numbers to comma, zerodecimals. Add formulas for TOTAL (in the TOTAL column and row) and AVERAGE (inthe AVG column) to calculate results. Change column widths as needed to ±t thespreadsheeton one screen. Right-align the labels for month, TOTAL, and AVG to place themover their numbers. Save the workbook as SHEET4 and print it.

Attachments:

Answers

(11)
Status NEW Posted 26 May 2017 01:05 AM My Price 9.00

-----------

Not Rated(0)