q6 Y10 Homework - BTEC DIT quiz on Component 2 Lesson 18-20

What function would you use to produce a total of a list of numbers?

• SUM
• COUNT
• AVERAGE
• TOTAL

What function would you use to count a list of names?

• SUM
• COUNT
• COUNTA
• COUNTBLANK

Which of the following are example uses of a departmental breakdown?

• Monitor progress over time towards achieving a sales goal.
• Analysing expenditure by department to identify wastage or who is going over budget.
• Analysing employee performance, such as amount of sick leave.
• Identify products that are selling well, or patterns in when they sell well.

True or False: we use dashboards to summarise data and make it easier to interpret.

• True
• False

What is the effect of using the “Table” feature in Excel?

• Automatically apply a range of formatting options to your data.
• Add filter options to your headings.
• All of the above.
• None of the above.

In what tab of the ribbon menu can you find tables, pivot tables, graphs and sparklines?

• Home
• Insert
• Data
• Developer

When creating a pivot table you need to add your fields to either filters, columns, rows or ...

• values
• cells
• references
• chocolate

What is the purpose of a pivot table?

• To rotate data onto its side.
• To summarise data in a table.
• All of the above.
• None of the above.

True or False: in Excel, the only types of graphs are bar charts, line graphs & pie charts.

• True
• False

Which of these form controls displays up and down arrows which will increase or decrease the value in a cell.

• Combo box
• Spinner
• Check box
• Option button