Practice Module 4 – Excel (Part 1)
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Time limit: 0
Practice Exercise Summary
0 of 7 Questions completed
Questions:
Information
You have already completed the practice exercise before. Hence you can not start it again.
Practice Exercise is loading…
You must sign in or sign up to start the practice exercise.
You must first complete the following:
Results
Practice Exercise complete. Results are being recorded.
Results
0 of 7 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- Review / Skip
- Answered
- Correct
- Incorrect
-
Question 1 of 7
1. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect -
Question 2 of 7
2. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect -
Question 3 of 7
3. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect -
Question 4 of 7
4. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect -
Question 5 of 7
5. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect -
Question 6 of 7
6. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect -
Question 7 of 7
7. Question
- Go to the Campus Store sheet.
- Autofill the rest of the months in row 4.
- With the table of sales for each item by month, create a chart that displays the monthly sales of Hats, Shirts, and Hoodies over time. Format the chart to have the following information:
- Chart title: Generic Merch Sales by Month
- Put the legend on the right side
- Sheet location: Same sheet
- Move and resize the chart in the range G13:L25.
- Format the Chart Area with Gradient fill (Top Spotlight, Accent 6).
- Format the Plot Area with Solid fill (White, Background 1).
- Display the units for the vertical axis in Thousands.
- Add Jerseys to the chart.
- Using the data in A14:E21, create a chart to display sales of each product by transaction type. Format the chart to have the following details:
- Chart title: Campus Store Sales by Transaction Type
- Put the legend on the left side
- Sheet location: Same sheet
- Move and resize the chart in the range A23:E35.
- Format the Chart Area with Solid fill (Orange, Accent 2, Lighter 60%).
- Format the Plot Area with Solid fill (Orange, Accent 6, Lighter 80%).
- Using the total sales for each product, create a chart that effectively displays the total sales by product. This chart should display the relative contributions of each product to the whole. Format it with the following details:
- Chart title: Total Sales by Product
- Sheet location: Create a new sheet called Campus Store Product Chart, placing this new sheet right after Campus Store
- Design the chart with “Style 3”.
- Format the Data Labels of the chart to include the name of each product.
- Save the file.
CorrectIncorrect