Excel practice exam instructions

2 Pages
118 Views
Unlock Document

Department
Business Administration
Course
BUS 237
Professor
Zorana Svedic
Semester
Fall

Description
Office 2010 – myitlab:grader – Instructions GO! Excel Ch01 - EOC Sales Comparison Project Description: In this project, you will add data to a worksheet, format cells and numeric values, and create formulas and functions. You will also create and format a column chart and sparklines. Additionally, you will prepare the workbook for printing. Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Step Instructions Possible 1 Start Excel. Download and open the workbook named GO_e01_Grader_EOC.xlsx. 0 Merge and center the title over the range A1:H1 and then apply the Title cell style. Merge and 2 10 center the subtitle over the range A2:H2 and then apply the Heading 1 cell style. In cell F4, enter a function to sum the values in cells B4:E4. Copy the function down to cells 3 6 F5:F7. Format the ranges B4:F4 and B7:F7 with the Accounting Number Format. Format the range 4 B5:F6 with the Comma style. 8 Insert a new row between rows 5 and 6. Enter Dallas in cell A6, 105985.12 in cell B6, 5 98674.38 in cell C6, 100548.22 in D6, and 106222.17 in E6. Copy the function in cell F5 10 down to cell F6 to sum the values in the new row. In cell G4, enter a formula to divide the Total Sales for Austin (F4) by The Total Sales (F8). 6 Set F8 as an absolute cell reference in the formula. Copy the formula down to cells G5:G7. 8 Select the range H4:H7 and insert Line sparklines. Set the data range for the sparklines as 7
More Less

Related notes for BUS 237

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit