Spreadsheet Knowledge Quiz

What is the term for an individual box in a spreadsheet where you can enter data?

• Row

• Column

• Cell

• Sheet

Answer explanation

The term for an individual box in a spreadsheet where you can enter data is 'Cell'. Rows and columns refer to the horizontal and vertical arrangements of cells, while a sheet is the entire spreadsheet.

Which function calculates the average of a range of numbers?

• SUM

• AVERAGE

• COUNT

• MAX

Answer explanation

The AVERAGE function calculates the mean of a range of numbers by summing them and dividing by the count. SUM adds numbers, COUNT counts them, and MAX finds the highest value, making AVERAGE the correct choice for this question.

True or False: A formula is the same as a function in Google Sheets.

• True

• False

Answer explanation

False is correct because a formula in Google Sheets is a specific expression that calculates values, while a function is a predefined operation that can be used within a formula. They are related but not the same.

What does the COUNT function do?

• Adds up all the numbers in a range

• Finds the highest number in a range

• Counts the number of cells containing numbers in a range

• Calculates the average of a range

Answer explanation

The COUNT function specifically counts the number of cells that contain numbers in a given range, making it useful for determining how many numeric entries exist, unlike the other options which perform different calculations.

Which of these is NOT a type of cell formatting?

• Bold

• Italic

• Underline

• Capitalize

Answer explanation

Capitalize is not a type of cell formatting like Bold, Italic, or Underline, which change the appearance of text. Capitalizing refers to changing the case of letters, not formatting.

True or False: Cell reference B3 refers to the cell in column B, row 3.

• True

• False

Answer explanation

True. In spreadsheet terminology, a cell reference like B3 indicates the cell located in column B and row 3.

Which feature allows you to keep certain rows or columns visible while scrolling?

• Lock panes

• Stick header

• Freeze panes

• Pin rows

Answer explanation

The correct choice is 'Freeze panes', which allows you to keep specific rows or columns visible while scrolling through a worksheet, making it easier to view data without losing context.

What is the unique address of a cell called?

• Cell name

• Cell reference

• Cell location

• Cell ID

Answer explanation

The unique address of a cell in a spreadsheet is called a 'cell reference'. It typically consists of the column letter and row number, such as A1, which identifies the specific location of the cell.

True or False: A spreadsheet is organized into rows and columns.

• True

• False

Answer explanation

True. A spreadsheet is indeed organized into rows and columns, allowing for the systematic arrangement of data.

Which function finds the highest value in a range?

• HIGHEST

• MAXIMUM

• TOP

• MAX

Answer explanation

The function that finds the highest value in a range is 'MAX'. Other options like 'HIGHEST', 'MAXIMUM', and 'TOP' are not valid functions in this context. 'MAX' is the correct choice.