Spreadsheet Basics Quiz

What is a cell in a spreadsheet?

• A rectangular box where a row and column intersect

• A type of formula

• A chart element

• A type of font

Which of the following best describes a formula?

• A way to sort data

• A predefined function

• An equation used to perform calculations

• A type of data format

What does the function =SUM(A1:A5) do?

• Counts the cells in the range A1 to A5

• Adds the values in the range A1 to A5

• Multiplies the values in the range A1 to A5

• Finds the largest value in the range A1 to A5

What is the purpose of the IF function in a spreadsheet?

• To filter data

• To calculate averages

• To perform conditional operations

• To sort data

Which of the following is NOT a data type used in spreadsheets?

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

• =

• #

• @

• &

What is a range in a spreadsheet?

• A type of chart

• A group of adjacent cells

• A formatting style

• A single cell

Which feature allows you to repeat a formula across multiple cells?

• Autofill

• Find and Replace

• Sorting

• Freeze Panes

Which of the following functions returns the highest value in a range?

• =MAX(A1:A10)

• =MIN(A1:A10)

• =AVERAGE(A1:A10)

What is the purpose of a pie chart in a spreadsheet?

• To display trends over time

• To compare parts of a whole

• To display categories and values

• To sort data