Excel Test 2

In excel, all formulas must begin with what symbol?

=

Bar chart

Data in bar format

Line chart

Data in line format

Pie chart

Data in pie format

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

What does it mean to merge cells?

Selected cells become one

What is the argument in the function =AVERAGE

Take the average of the cells

Present Value (PV)

The market value of an asset

Why would you want to change the column width?

When the numbers or words will not fit and overlap

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

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

C4, Column C and Row 4

Number (#)

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

When` would you use conditional formatting on a cell?

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

Count

Function that counts the number of cells with numbers contained in them

Average

Function that takes the average amount in a range of cells

Maximum (max)

Function used to identify the largest amount in a range of cells

Minimum (min)

Function used to identify the smallest value in a group of cells