Spreadsheet Basics Quiz

What is the primary purpose of a spreadsheet?

• To create presentations

• To store and analyze data

• To write documents

• To browse the internet

In a spreadsheet, what does a cell refer to?

• A row of data

• A column of data

• The intersection of a row and a column

• A formula

Which of the following is NOT a common function in spreadsheets?

• SUM

• AVERAGE

• PRINT

• COUNT

What does conditional formatting allow you to do?

• Change the font style of the entire spreadsheet

• Automatically format cells based on their values

• Delete rows and columns

• Create charts

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

• @

• #

• $

• =

What is the effect of applying conditional formatting to a cell that contains a value greater than 100?

• The cell will be deleted

• The cell will change color based on the rule set

• The value will be halved

• The cell will be locked

Which of the following functions would you use to find the highest value in a range?

• MIN

• MAX

• AVERAGE

• COUNT

In a spreadsheet, which of the following refers to the vertical arrangement of data?

• Row

• Column

• Cell

• Range

What is a primary key in a database?

• A type of formula

• A unique identifier for a record

• A formatting option

• A method of data entry

What does the AVERAGE function calculate?

• The total of a range

• The middle value in a set

• The mean of a set of numbers

• The largest number in a range