excel project 2
judoka
ExcelProject2CheckFigures.docxExcel Project 2 Check Figures
Steps 1-2-3: As instructed
Step 4: Appropriate values to use indicated below – adjust column widths to include all data and notice the blank row between entries:
Steps 5-6: As instructed. Disregard the “Note” under Step 5b.
Steps 7-8-9-10: Example of banded rows table and check figures for first two rows with column widths adjusted so titles are not chopped off. Table sorted by year. Filters have been turned off, but not required. Dollar sign formatted as “currency leading”, no decimals, thousandths separator; and, NumCars has thousandths separator and no decimals.
Step 11: Read the instructions carefully as it tells you where the fields go. Once created, you will format the table from the Comments area. Your Pivot Table should have six columns and five rows. Make sure the columns are wide enough so words are not chopped off. Here are the check figures for the Grand Total row:
Step 12: The chart is placed below the Pivot Table. You will have two sets of four bars, for a total of eight bars. Make sure your title identifies what the chart is. Titles are formatted with all major words with uppercase letters. Words such as “for” and “by” would not be capitalized. Do not use any abbreviations in the title.
Step 13: Format your reply so it does not run any wider than the table above. Inserting a Text Box and type inside the Text Box is a good idea.
Step 14: Read the question. It is the “combination of CarClass and Location”. Inserting a Text Box is a good idea.
Step 15: Read where the new titles are placed. Excel will automatically format them to match the existing table. If you are using a table style that has white letters, that is OK to leave them white:
Steps 16-17: Read where the titles are placed. Do not adjust column widths. Format as required:
Step 18: Only write one formula using an IF statement and an absolute cell address. The only CarClass you can “test” is Hybrid. When you write the formula, Excel will automatically fill in the column. Format it as indicated in the Comments section.
Step 19: Read the instructions and use the formula indicated in Step 19a for Profit. When you type the one formula, Excel will automatically fill in the column. Follow the instructions for Step 19b. Use the formula indicated in that step. When you type the formula, Excel will automatically fill in the column. Follow the formatting requirements for each in the Comments.
Step 20: Read the instructions on where to place the Pivot Table. The steps tell you which fields you will use and how to format the data in the Pivot Table. The Comments also tell you how to format the data. You will have six columns and five rows. Check figures for the Pivot Table:
Step 21: Read the instructions on where to place the Pivot Table. The steps tell you which fields you will use and how to format the data in the Pivot Table. The Comments also tell you how to format the data. You will have six columns and five rows. Check figures for the Pivot Table:
