Question: 21. (10 pts) Format all columns (even the ones that you didn't create formulas for!) on all hve worksheets so that your entire submission has

 21. (10 pts) Format all columns (even the ones that you

21. (10 pts) Format all columns (even the ones that you didn't create formulas for!) on all hve worksheets so that your entire submission has a consistent look and appearance per the following instructions (by the way these rules should apply for ALL assignments from here on out for the semester unless otherwise instructed): All columns on all sheets containing values that are currency, should - For the first row and any Totals/Summarization row at the bottom of the table be formatted as Currency with 0 decimal places and have the $ sign included - All succeeding rows in the table should be CArency with O decimal places WITHOUT the $ sign included All numbers that are not money-related should be formatted as Number with 0 decimal places and with commas. For example the Sales Volume column would qualify for this. If you ever see the formatting type of "Custom" or "Accounting" in any cells in this assignment, that is wrong and you will lose a few points. Columns that are percentage-based (Gross Profit Margin \& \% of Total Volume) should be formatted as percentage with the number of decimal places as indicated in the appropriate step above. All cells of all tables should have borders. This includes the table on the Summary page. All of the cells that either contain a zero or a formula that calculates a value of zero should be formatted consistently in that you shouldn't have some show as dashes and others with an actual zero. They should be consistently shown as either dashes or zeros but not a mixture of both. 22. Save and close the LastName FirstName Auto Sales.xlsx workbook. Submit this file here in this assignment "bucket" by clicking on the link at the top of this page. After you submit your file you will be given an icon that looks like this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!