TERMINOLOGY
This is the intersection of a row and a column.
What is a cell?
This function finds the total of a range.
What is SUM?
This organizes data A–Z or smallest to largest.
What is sorting?
This type of sheet tracks income and expenses.
What is a budget?
This stops users from changing formulas.
What is cell protection?
This saves your spreadsheet for general use.
What is an Excel file or workbook?
This is a collection of cells selected together.
What is a range?
This function finds the middle value of a dataset.
What is AVERAGE?
This finds a word, number, or value in a worksheet.
What is Find?
This spreadsheet calculates employee salaries.
What is payroll?
This changes cell color based on values.
What is conditional formatting?
This format removes formulas and formatting.
What is CSV?
This is a built-in formula like SUM or AVERAGE.
What is a function?
This function counts how many cells contain numbers.
What is COUNT?
This changes one value to another automatically.
What is Replace?
This spreadsheet shows statistics like totals and averages.
What is a statistical table?
This displays totals by category.
What are subtotals?
This keeps formulas safe from editing.
What is worksheet protection?
This file type stores data in plain text with commas separating values.
What is a CSV file?
This function finds the highest value in a range.
What is MAX?
This hides information that does not meet conditions.
What is filtering?
This shows information visually.
What is a chart / graph?
This places text anywhere on a worksheet.
What is a text box?
This sharing setting allows others to view but not edit.
What is view-only access?
This tool allows you to only view rows that meet a condition.
What is a filter?
This function returns TRUE only if all conditions are true.
What is AND?
This allows you to search a large table for related data.
What is a lookup function?
This personal spreadsheet records deposits and withdrawals.
What is a checkbook register?
This connects information between tables.
What is a lookup?
This file format is best for transferring raw data.
What is CSV?