Spreadsheet basics
This is an electronic document that organizes data into rows and columns.
What is a spreadsheet?
This symbol usually begins a spreadsheet formula.
What is the equals sign (=)?
This is the term for the address of a cell.
What is a cell reference?
This is the main purpose of a chart in a spreadsheet.
What is displaying data visually?
This is one common use of spreadsheets in everyday life.
What is budgeting, payrolls, or financial statements?
This is the name for a horizontal line of cells.
What is a row?
This function adds a group of numbers together.
What is SUM?
In cell B4, this character identifies the column.
What is column B?
This type of chart shows how categories make up a whole.
What is a pie chart?
This feature arranges data in alphabetical or numerical order.
What is sorting?
This is the name for a vertical line of cells.
What is a column?
This function calculates the mean of a group of numbers.
What is AVERAGE?
In cell B4, this character identifies the row.
What is row 4?
This type of chart is commonly used to show trends over time.
What is a line chart?
This feature displays only records that meet selected conditions.
What is filtering?
This is the box formed where a row and column intersect.
What is a cell?
This function identifies the largest value in a range.
What is MAX?
This range represents all cells from A1 through A5.
What is A1:A5?
This type of chart is useful for comparing values across categories.
What is a bar or column chart?
This is one major advantage of using spreadsheets instead of performing calculations manually.
What is saving time or reducing manual calculation errors?
This is the difference between a workbook and a worksheet.
What is the fact that a workbook contains one or more worksheets on a spreadsheet?
This is the formula used to add the values in cells A1 and B1.
What is =A1+B1?
This is what the formula =SUM(C2:C6) calculates.
What is the sum of the values in C2 through C6?
This spreadsheet feature changes the appearance of data using colours, borders, fonts, and number styles.
What is formatting?
When a value used in a formula changes, this should happen automatically.
What is automatic recalculation?