Excel Project Chapter 9-12 Exam

Excel Project Chapter 9-12 Exam

Author: matthew stock


Chapter 9-12 Exam
Project Description:
For this project, you will update a workbook. You will format grouped worksheets, set up validation rules, and create functions. Additionally, you will import a text file and XML data and manipulate the imported text. Finally, you will modify the document properties, insert comments, and mart the workbook as final.
For the purpose of grading the project you are required to perform the following tasks:


Points Possible


Open wake-final-Exam1.xlsx and save the workbook asWake_LastName_FirstName.xlsx (Substituting your first and last name.)Make sure the Invoice sheet is active.



Unlock the following cells: E4, B14:E33, E35, E37



In cell E4 put in the date: 6/1/2018Then put in the following:B14: Insulation in walls and atticD14: TE14: 935.25B15: Labor for insulationE15: 210B16: Mud for wall textureD16: TE16: 57.84



Fix the subtotal in cell E34 to calculate sum the above cells (E14:E33)Set the tax rate to 6.5% in cell E35Have to total amount show up in cell D2Protect the worksheet so locked cells cannot be modified (Set the password to: Wak3Invoice), and make sure that “Select locked cells” and “Select unlocked cells” is checked.<hint> Please make sure you put in a THREE for the password.



Group the following worksheets (Qtr1, Qtr2, Qtr3, Qtr4).Fill the contents AND formats for cell A1 across the worksheets. While still grouped, AutoSum the Dept. Totals AND the Monthly Totals at the same time.Lastly, fill the formatting from A2:E8 across the worksheets and auto adjust the column A width.


See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.