S1 Spreadsheets Knowledge Check 1

What is the function used to add up a range of cells in Excel?

• AVERAGE

• SUM

• COUNT

• MAX

Which tool would you use to create a column graph in Excel?

• Pivot Table

• Conditional Formatting

• Insert Chart

• Data Validation

How can you make the text in a cell bold?

• Use the SUM function

• Click on the 'B' icon in the toolbar

• Use the COUNT function

• Click on the 'I' icon in the toolbar

What is the formula to calculate the average of numbers in cells A1 to A5?

• =SUM(A1:A5)

• =AVERAGE(A1:A5)

• =COUNT(A1:A5)

• =MAX(A1:A5)

Which of the following is a way to format a cell to display currency?

• Change the font size

• Use the 'Currency' option in the 'Number' format

• Use the 'Text' option in the 'Number' format

• Use the 'Percentage' option in the 'Number' format

What is the shortcut key to save a workbook in Excel?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + P

Which function would you use to add up all the numbers in a range?

• MIN

• MAX

• AVERAGE

• SUM

Which of the following is used to print a worksheet?

• Data Validation

• Page Layout

• Print Preview

• Conditional Formatting

Which of the following is a valid cell reference?

• 1A

• A1

• A-1

• 1-A

How can you adjust the width of a column to fit its content?

• Double-click the right border of the column header

• Use the 'Insert' menu

• Use the 'Data' menu

• Use the 'Review' menu