Question
In cell D4, use the SUBTOTAL function to calculate the average number of Halloween costumes sold. Format with 0 decimals. In cell D5, use the
| In cell D4, use the SUBTOTAL function to calculate the average number of Halloween costumes sold. Format with 0 decimals. |
| In cell D5, use the SUBTOTAL function to calculate the total number of Christmas costumes sold. Format with 0 decimals. |
| Insert a slicer for the Month field. Apply Light Blue, Slicer Style Dark 5. Format the slicer with 4 columns, and then resize and move the slicer so it covers range M2:R5 (set the slicer within the borders of these cells). In the slicer, select November. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Internal Auditing Handbook
Authors: K. H. Spencer Pickett
1st Edition
0471969117, 978-0471969112
