Understanding Cell References and Functions

Which of the following is the correct way to write a cell reference in a spreadsheet?

• 3D

• D3

What is formatting in the context of spreadsheets?

• Changing the content of a cell

• Adjusting the appearance of data to make it clearer or more attractive

• Deleting data from a spreadsheet

• Adding new rows and columns

Why do we use formatting in spreadsheets?

• To make the data look messy

• To make the data easier to read and understand

• To hide information

• To delete data

Which of the following is an example of a formatting technique in spreadsheets?

• Adding up numbers

• Changing the font colour

• Writing a formula

• Inserting a chart

Which of these is NOT a formatting technique?

• Making text bold

• Using the SUM function

• Changing cell background colour

• Adjusting column width

What is a formula in a spreadsheet?

• A way to format text

• A mathematical equation used to calculate values

• A type of chart

• A cell reference

What is a function in a spreadsheet?

• A type of formatting

• A pre-set formula that performs a specific calculation

• A way to delete data

• A type of cell reference

What does the SUM function do in a spreadsheet?

• Subtracts numbers

• Adds numbers together

• Multiplies numbers

• Divides numbers

Which of the following is NOT a function commonly used in spreadsheets?

• SUM

• MAX

• MIN

• PRINT

Which function would you use to find the largest value in a range of cells?

• SUM

• MAX

• MIN

• AVERAGE