NEW
Font size
WorksheetsSpreadsheet Knowledge Quiz
Total questions: 20
Worksheet time: 10mins
What is the term for an individual box in a spreadsheet where you can enter data?
Row
Column
Cell
Sheet
Which function calculates the average of a range of numbers?
SUM
AVERAGE
COUNT
MAX
True or False: A formula is the same as a function in Google Sheets.
True
False
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
Which of these is NOT a type of cell formatting?
Bold
Italic
Underline
Capitalize
True or False: Cell reference B3 refers to the cell in column B, row 3.
True
False
Which feature allows you to keep certain rows or columns visible while scrolling?
Lock panes
Stick header
Freeze panes
Pin rows
What is the unique address of a cell called?
Cell name
Cell reference
Cell location
Cell ID
True or False: A spreadsheet is organized into rows and columns.
True
False
Which function finds the highest value in a range?
HIGHEST
MAXIMUM
TOP
MAX
What is the term for the top row often used to label data categories?
Title row
Label row
Header
Category row
True or False: Conditional formatting changes the appearance of cells based on their content.
True
False
What type of chart uses rectangular bars to show comparisons between categories?
Pie chart
Line graph
Scatter plot
Bar graph
True or False: The SUM function multiplies a range of numbers.
True
False
What is the term for the process of inputting information into spreadsheet cells?
Data entry
Data input
Data insertion
Data filling
Which of the following is used to sort data in a spreadsheet?
Filter
Sort
Arrange
Order
True or False: You can merge multiple cells into one in a spreadsheet.
True
False
What is the function used to add up a range of numbers in a spreadsheet?
ADD
SUM
TOTAL
PLUS
Which feature allows you to apply a specific format to cells that meet certain criteria?
Data validation
Conditional formatting
Cell styling
Format painter
True or False: You can use the VLOOKUP function to search for a value in the first column of a table and return a value in the same row from a specified column.
True
False
