Spreadsheets – Using Microsoft Excel

Fill in the Blank

100

A __________ is an area where a row and column intersect and data can be entered.

cell

200

A __________ is a combination of numbers, mathematical symbols, cell references, and functions used to process data in a spreadsheet.

formula

300

A __________ is a group of cells in a spreadsheet, identified by naming the first and last cells in the group (e.g., A1:A5).

cell range

Complete the Sentence

100

All formulae in a spreadsheet must start with __________.

an equals sign (=)

200

A formula can be entered into an area of the spreadsheet called the __________.

formula bar

300

The letters and numbers along the top and side of the spreadsheet are used to identify a cell; this is known as a __________.

cell reference

Function and Usage

100

The function used to add up values in a range of cells is called __________.

SUM

200

The function used to calculate the mean of values in a range of cells is called __________.

AVERAGE

300

The formula =AVERAGE(C2:E2) calculates the __________ of values in the cells between columns C and E in the first row.

average