Simple Spreadsheets Quiz

What is the first step in creating a basic spreadsheet?

• Formatting cells

• Entering data

• Adding formulas

• Creating charts

Which of the following is a common file extension for spreadsheet files?

• .docx

• .xlsx

• .pptx

• .txt

How can you quickly select an entire row in a spreadsheet?

• Click on the row number

• Click on the column letter

• Press Ctrl + A

• Double-click any cell in the row

What is the purpose of formatting cells in a spreadsheet?

• To add data

• To make the spreadsheet look more organised and readable

• To create charts

• To add formulas

Which of the following is NOT a cell formatting option?

• Font size

• Cell colour

• Cell border

• Cell formula

How do you change the background colour of a cell?

• Right-click the cell and select "Insert"

• Use the "Fill Colour" option in the toolbar

• Press Ctrl + C

• Double-click the cell

What symbol is used to start a formula in a spreadsheet?

• $

• @

• =

• #

Which of the following is a correct formula to add the values in cells A1 and B1?

• =A1+B1

• =A1*B1

• =A1-B1

• =A1/B1

What function would you use to find the average of a range of cells?

• SUM

• AVERAGE

• MAX

• MIN

How do you apply a border to a cell?

• Use the "Border" option in the toolbar

• Press Ctrl + B

• Right-click the cell and select "Delete"

• Double-click the cell