E_CH08_EXPV2_IRCD_Instructions.docx Photography Specialists Revenue Comparison Project Description: As an accountant for the Photography Specialists of Springfield County, you have been asked to compare revenue totals between the years 2010 and 2011. To complete the project, you will create validation rules and messages, correct errors in the workbooks, create formulas and format data on grouped worksheets, and insert hyperlinks. Additionally, you will create 3 D formulas and link to data in other workbooks.
E_CH08_EXPV2_IRCD_Instructions.docx Photography Specialists Revenue Comparison Project Description: As an accountant for the Photography Specialists of Springfield County, you have been asked to compare revenue totals between the years 2010 and 2011. To complete the project, you will create validation rules and messages, correct errors in the workbooks, create formulas and format data on grouped worksheets, and insert hyperlinks. Additionally, you will create 3 D formulas and link to data in other workbooks. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the Excel workbook named Exploring_e08_Grader_IR.xlsx. Click OK to acknowledge the error. 0 2 On the Services worksheet, create a validation rule for the range B9:E9 so that only whole numbers that are greater than 0 are accepted. Create an input message using the text Sitting Fee as the title and Enter the total revenue generated from sitting fees. (including the period) as the message. Create an error alert using the stop style. Title the error alert Invalid Entry and enter Please enter a whole number. (including the period) as the message. 12 3 Circle the invalid data on the Services worksheet, and then change the invalid entry to 5975. 4 4 Group the Services and Products worksheets together. In cell B10, insert a formula to calculate the total revenue for Quarter 1. Copy the formula across through cell E10. 8 5 With the worksheets grouped together, apply the accounting number format with two decimal places to the range B5:E10. 4 6 With the worksheets still grouped together, indent the text in cell A10 one time. Ungroup the worksheets. 4 7 On the Services worksheet, in cell A12, enter the text 2011 Summary Details. In the same cell, create a hyperlink to the 2011 Summary worksheet. 6 8 Group the Services and Products worksheets. With the Services…
Attachments:
E CH08 EXPV2 ….zip