Excel Quiz 3
Write out the complete answer next to the appropriate number.
Use Excel Gradebook to answer the following.
- Which chart type would best express Daffy Duck's decline in quiz grades for this time period:
- Column
- Bar
- Line
- XY Scatter
- The teacher would like to see which student has the highest quiz average. Which chart type would best express a comparison of all the students' average grades in column G?:
- If the teacher wanted to create a line chart to show the class average scores through the time period, she would highlight at least:
- A13:G13
- B13:G13
- A13:F13
- G1:G11
You do not need the image for the last two questions.
- Which of the following is not necessary when creating charts:
- Choosing the correct chart type
- Highlighting the correct data
- Labeling the chart appropriately
- Interesting information
- To help you create charts, Excel includes:
- Chart Magic
- Chart Wizard
- Chart-O-Matic
- Chart Smart