Spreadsheets [Small Data]

Question 1

Formula

Answer 1

A set of instructions that performs a specific calculation. A formula in a spreadsheet always begins with a = symbol.

Question 2

Operator

Answer 2

A symbol that names the type of operation or calculation to be performed. Examples include + for addition, - for subtraction, * for multiplication and / for division.

Question 3

Expressions

Answer 3

In a spreadsheet an expression or calculation always starts with a = sign.

Question 4

Cell Reference

Answer 4

A cell or range of cells in a worksheet that can be used in a formula. Cell references contain the letter of the column and the number of the row where the data is. Cell references are automatically updated when a formula is copied to a new cell.

Question 5

Range

Answer 5

A collection of two or more cells.

Question 6

Value Grouping

Answer 6

To group values in a formula uses parentheses ().

Question 7

Absolute Referencing

Answer 7

Absolute references marked by a $ sign before and/or after the cell values being referenced mean that the formula will not change relatively when copied to a different cell. The cell being referenced is always the same.

Question 8

Data Range

Answer 8

Clicking a formula will show the coloured ranges of the cells being used in your spreadsheet. There are different colours for each unique range in your formula. In a lot of spreadsheet applications pressing the “F2” on a selected formula will highlight the data referenced in said formula.

Question 9

COUNTIF ()

Answer 9

This is a formula and a function. This means that the function runs based on the criteria set by the formula. COUNT is the formula that will be executed IF the conditions you create are true.

Question 10

DIV/0!

Answer 10

This error occurs when a formula is trying to divide a value in a cell by 0 or by an empty cell. A resolution to this error is to use the formula (example reference cells); =IFERROR(B4/A4, “Not applicable”) and pressing enter. The cells are relative to your formula. This error checking formula can also be copied to other cells to check for errors.

Question 11

ERROR! (Google Sheets only)

Answer 11

A formula can’t be interpreted as input (also known as a parsing error). A “delimiter” such as a comma can be placed where needed to fix this error.

Question 12

N/A

Answer 12

Data in a formula can’t be found by a spreadsheet. Generally, this means the data doesn’t exist.

Question 13

NAME

Answer 13

A formula or function name isn’t recognised or understood. Correcting the typo will fix the error.

Question 14

NUM

Answer 14

A formula or function calculation can’t be performed as specified by the data.

Question 15

VALUE

Answer 15

A general error that could indicate a problem with a formula or referenced cells.

Question 16

REF

Answer 16

A formula is referencing a cell that is no longer valid or has been deleted.

Question 17

Conditional Formatting

Answer 17

Applicable to both MS Excel and Google Sheets, conditional formatting allows the user to highlight in different colours based on their contents. Using conditional formatting, you can for example, highlight in yellow all the cells that contain an error, and then work to fix them.