Lesson 4

Question 1

• is the intersection between a row and a column on a spreadsheet that starts with
  cell A1.

Answer 1

Cell

Question 2

• A combination of a letter and a number that specifies the column and row in which a cell is located on a spreadsheet.

Answer 2

Cell address

Question 3

• it is the heavy border around the selected cell.

Answer 3

Cell pointer

Question 4

is a series of data banks laid out in a horizontal fashion in a spreadsheet.

Answer 4

Row

Question 5

is a vertical series of cells in a spreadsheet.

Answer 5

Column

Question 6

is an Excel file that contains one or more worksheets. It is another word for your Excel file.

Answer 6

Workbook

Question 7

is a collection of cells on a single “sheet” where you actually keep and manipulate the data.

Answer 7

Worksheet

Question 8

refers to the data in a spreadsheet. It can be in a form of text, dates, numbers and Boolean da

Answer 8

Values

Question 9

is a customizable toolbar that contains or holds frequently used commands.

Answer 9

Quick access toolbar

Question 10

It depicts all the features of Excel in easy to understand form. It is organized into a series of tabs - such as File, Home, and Formulas.

Answer 10

Ribbon

Question 11

located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.

Answer 11

Formula bar

Question 12

the current worksheet that is being displayed.

Answer 12

Sheet tab

Question 13

This shows the address of the current selection or active cell.

Answer 13

Name box

Question 14

-contains commands which are mostly related to file management such as opening new or existing worksheet files, saving
and printing.

Answer 14

File tab

Question 15

This tells us what is going on with Excel at any time

Answer 15

Status bar

Question 16

is any equation entered into a cell on a Microsoft Excel spreadsheet. It is an expression which calculates the value of a cell and always starts with an equal sign (=).

Answer 16

Formula

Question 17

are predefined formulas that perform a specific operation. Functions are typed alongside parenthesis, where in the arguments if any are listed in between.

Answer 17

Function

Question 18

❑+ ❑- ❑*
❑/
❑ SUM
❑ SUMIF
❑ COUNT
❑ COUNTIF
❑ RANK
❑ AVERAGE
❑ AVERAGEIF ❑ IF
❑ PIVOT

Answer 18

Commonly Used Excel Operators and Functions

Question 19

-use in a formula to add numbers.

Answer 19

+ (plus)

Question 20

Use in a formula to subtract numbers or to signify a negative number.

Answer 20

-(minus)

Question 21

Use in a formula to multiply number

Answer 21

• (asterisk; also called “star”)

Question 22

Use in a formula to divide one number by another

Answer 22

/(forward slash)

Question 23

-is a function used to compute for the summation of the number of a range.

Answer 23

Sum

Question 24

a numeric value that you wish to sum

Answer 24

Number

Question 25

the range of cells that you wish to sum.

Answer 25

Cell

Question 26

is a function to sum the values in a range that meet criteria that you specify.

Answer 26

SUMIF

Question 27

Required. The range of cells that you want to apply the criteria against.

Answer 27

Range

Question 28

Required. The criteria used to determine which cells to add.

Answer 28

Criteria

Question 29

Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the

Answer 29

Sum range

Question 30

is a function that returns the average (arithmetic mean) of the numbers provided.

Answer 30

Average

Question 31

The first number, cell reference, or range for which you want the average.

Answer 31

Number 1

Question 32

Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.

Answer 32

Number 2

Question 33

- is a function that returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

Answer 33

Average if

Question 34

it is a function used to count the cells with content in a range.

Answer 34

Count

Question 35

it is a function that counts the number of cells in a range, that meets a given criteria.

Answer 35

Count if

Question 36

it is a function that returns the rank of a number in a list of numbers.

Answer 36

Rank

Question 37

it is a function that returns one value if the condition is TRUE, or another value if the condition is FALSE

Answer 37

IF

Question 38

it is a function that returns one value if the condition is TRUE, or another value if the condition is FALSE

Answer 38

IF