2 Flashcards
The value axis is known as what?
The y axis
What is not a part of accounting number format?
Three decimal places
All formulas begin with a what sign?
=
What displays the current cell mode, the page number, and he zoom buttons?
The status bar
What is not a default calculation displayed by autocalculate?
Maximum
A text value in excel is also referred to as what?
A label
When you type data in a cell and presenter what sell becomes active?
The cell below
Where is the fill handle located?
In the Lower right corner of a selected cell
In excel 2016 row headings re identified by what?
Numbers
When formatting a worksheet to be printed what shows where page breaks are located?
Dotted lines
What does a data bar in a cell represent?
The value of a cell relative to other cells
True or false A pie chart should be considered when you have just one data series to plot?
True
Authorities will fill a series when you establish a pattern when ?
You establish a pattern with two or more cells
True or false a % sign designates that a cell in a formula is an absolute
False
Which symbol represents that a cell is an absolute cell reference in a function formula?
$
You must select how many ranges on a worksheet to create a pie chart?
Two ranges
True or false, the chart elements allows you to add, remove or change chart elements?
True
What does a pie chart do?
It shows the relationship of each part to a whole
What is the first order of operation?
Expressions in parentheses
The default number format for cells is what?
General
What does the median function find?
The middle value on the range of cells
What symbol does excell use to indicate that a dell is not side enough to display a formula or function result
#
Cell c3 contains the formula =B3/$b$10 when you copy this formula down to c4 the formula will be what?
=B4/$b$10
What key has to be held down to select nonadjacent cells?
Ctrl
