Quiz 1 Flashcards
(26 cards)
When copying a cell, the term absolute cell reference indicates
cell reference will not change
The median function is used to find
middle number in the range of cells
If you wanted to determine how many cells in a range are not empty, you would use the
COUNTA function
=D5 is an example of an absolute cell value
False
$R$5 is an example of mixed cell reference
False
To tally a column you use the COUNT function
True
The today and Now functions return the same results
False
Average and Median are two functions used to determine central tendencies
True
The IF function is an example of a logical function
True
The PMT calculates the amount of mortgage
False
Range names are edited and deleted using the name manager
True
When cell C3 containing the formula =B6*C8 is copied to cell D2, the formula in cell D2 is
C5*D7
The name for a range can begin with a letter or
underscore
=D$3 is an example of a(n)
Mixed cell reference
Which Excel function displays the current date?
Today
The expression that implements the flow chart shown in the above figure is
IF(E2>B$2,B$3,0)
A range name can contain up to
255 characters`
A formula that refers to its own cell creates a(n)
circular reference
chart shows the proportion of individual parts to the whole.
A pie
Which of the following is NOT a chart element?
Data Series
is a small line or column that is displayed in a single cell.
Sparkline
By default, axes are displayed when a chart is created.
True
are used to show the exact value or the name of data points
Labels
determines which data series and categories are displayed in a chart.
A chart filter
