| Scorecard |
| Excel (chapters 1-4) |
| Appllication Prepared Exam |
| Name | Fireball Technology Company | Score: | 75 |
| Step | Description | Point Value | Points Deducted |
| a | Name of file should be e00_cumexam_LastFirst | 1 |
| b | Assign range name benefits to data on the Benefits sheet | 4 |
| c - e | Insert lookup functions for pension costs, insurance costs and daycare costs. | 7 |
| f | Insert If function to calculate Total Employee costs including daycare where daycare required. | 4 |
| h - i | Merge and center two titles, change font sizes and apply Orange, Accent 6, Darker 25% font color | 4 |
| j - k | Wrap text in column heading row, set all column widths to 11, apply currency number format to all monetary columns | 5 |
| l - m | Hide Benefits Code column and freeze panes | 4 |
| n | Apply Green Fill with Dark Green Text conditional formatting to values in the Total Employee Cost column below average | 4 |
| o - q | Insert correct formulas in the Summary Statistics section | 4 |
| r - s | Make a copy of the Employee data sheet, rename to Filtered Data, remove conditional formatting rule, convert the data range to a table, apply Table Style Medium 18, and unhide the Benefit Code column. | 6 |
| t | Sort the table by Benefit Code (smallest to largest)and then Total Employee Cost (largest to smallest). | 4 |
| u - v | Apply filter to Benefit Code 1, display a total row, and add totals to Salary and Total Employee Cost. | 7 |
| w | Create line sparklines in column F in the Earnings sheet to show trend by each division, show high point for each sparkline, apply Sparkline Style Colorful #5 style and Red, Accent 2 high point mark point marker color. | 7 |
| x - aa | Create a 3-D Clustered column chart from quarterly data for each division, move to new sheet Earnings Chart, apply Layout 3 chart layout, and add title | 7 |
| ab | Add footer to all sheets with name on left, sheet name in center and file name on right | 4 |
| ac | Apply Landscape orientation to Filtered Data and Earnings Chart sheets | 2 |
| ae | Save and close workbook and submit based on instructor directions | 1 |
| | | 75 | 0 |
kk11
e00_midterm_scorecard.xlsx
