Excel Review Part 2

Number

#### The cell is too small for the number in the cell. This lets the user know it needs to be resized to allow the numbers to be seen.

In Excel, all formulas must begin with what symbol?

=

What is the argument in this function?

=AVERAGE (F3:F26) This will take the average of the cells F3:F26

Average

=Average A function that takes the average amount in a range of cells

Count

=Count A function that counts the number of cells with numbers contained in them

Maximum

=max A function used to identify the largest amount in a range of cells

Minimum

=min A function used to identify the smallest value in a group of cells

You want to enter a series of dates down a column. What would be the best tool for the job?

In the corner of the cell when your mouse turns to the thin plus sign, drag down the column or row and it will put in dates.

Present Value

PV The market value of an asset

What does it mean to "merge" ceels?

Selected cells become one

Why would you want to change the column width?

When the numbers or words will not fit and overlap

Bar

a chart showing data in a bar format

Pie

a chart showing data in a circular format

Line

a chart showing data in a line format

What term refers to mathematical equation used in Excel to perform calculations?

Σ

What symbol is used to designate an absolute cell reference?

An absolute reference is a locked cell that maintains a constant reference when copied to another location. The symbol used is the $ sign. Example of the formula =E3/$E$13

How do you reference a cell? What would be the name of the cell in the 4th row and the 3rd column?

C4, Column C and Row 4

Wehn would you use conditional formatting on a cell?

Formatting that is set to appear a certain way if certain conditions, or rules, are met