Excel Skills: Charts and Functions Quiz

Which of the following is the correct term for the horizontal arrangements of cells in Microsoft Excel?

• Columns

• Rows

• Sheets

• Tables

In Microsoft Excel, which function is used to quickly add up a range of numbers?

• AUTOSUM

• AUTOFILL

• AUTOCALC

• AUTOFIT

Which chart type is best suited to show the proportion of different categories in a whole?

• Line chart

• Pie chart

• Scatter chart

• Area chart

If you want to compare the values of different categories side by side, which chart should you use in Excel?

• Pie chart

• Bar chart

• Line chart

• Doughnut chart

• 13

• 40

• 35

• 45

Which symbol is used for division in Excel formulas?

• +

• *

• /

• ^

• Multiplies the values in cells A1 to A5

• Adds the values in cells A1 to A5

• Divides the values in cells A1 to A5

• Subtracts the values in cells A1 to A5

Which of the following is NOT a valid way to perform multiplication in Excel?

• 3

• 16

• 8

• 48

Which of the following best describes a column in Excel?

• A vertical group of cells

• A horizontal group of cells

• A single cell

• A worksheet