Spreadsheet Skills for Year 8

What is the shortcut key to save a spreadsheet in most spreadsheet software?

• Ctrl + P

• Ctrl + S

• Ctrl + C

• Ctrl + V

Which of the following is used to move to the next cell to the right in a spreadsheet?

• Tab

• Enter

• Shift

• Ctrl

How do you start a formula in a spreadsheet?

• With a plus sign (+)

• With an equals sign (=)

• With a minus sign (-)

• With an asterisk (*)

What is the function of the 'SUM' formula in a spreadsheet?

• To subtract numbers

• To add numbers

• To multiply numbers

• To divide numbers

Which of the following is a basic function to find the average of a range of cells?

• =SUM()

• =AVERAGE()

• =MIN()

• =MAX()

What is the purpose of the 'Format Cells' option in a spreadsheet?

• To delete cells

• To change the appearance of cells

• To move cells

• To copy cells

Which of the following is used to create a new spreadsheet?

• Ctrl + N

• Ctrl + O

• Ctrl + P

• Ctrl + Q

What does the 'Merge Cells' feature do in a spreadsheet?

• It splits a cell into multiple cells

• It combines multiple cells into one cell

• It deletes the contents of a cell

• It copies the contents of a cell

Which of the following is a correct way to reference cell A1 in a formula?

• A1

• "A1"

• (A1)

• {A1}

What is the result of the formula =5+3*2 in a spreadsheet?

• 11

• 16

• 13

• 10