mid term Flashcards
SUM is a built-in formula that adds the values in a selected range (T/F)
true
The Formula bar displays the result of the formula and a cell displays the formula (T/F)
false
The Format Painter copies formatting attributes and styles from one cell to another cell or range (T/F)
true
range
a group of cells
fill handle tool
simplifies the process of entering the months of the year in a worksheet
To select non-adjacent cells, columns, or rows, which key must you press?
Ctrl
We should use cell addresses in formulas, rather than explicit numbers, because…
the formulas can automatically update if a number in a cell used by the formula is changed
argument(s)
the pieces of information within parentheses in functions that determine what value a function returns
Excel recognizes patterns and can complete most series with the ____.
fill handle
When you cut or copy data, where is it stored
on the Window’s clipboard
syntax
the required parts of a formula and the rules controlling the order of the parts
relative cell address
when copied the column and row references do change
range names
describe a cell or group of cells and make it easier to interpret a formula
how many arguments do the TODAY and NOW functions have?
zero
When the table array argument of the VLOOKUP function is named, we have to insert dollar signs ($) right before and right after the name to keep the table in a fixed location (T/F)
false
what does the F4 key do?
inserts dollar signs quickly to make a cell and absolute reference
COUNTA
counts the number of cells in a range that contain any data type, text, or numbers
COUNTIF
counts the number of cells in a range based on specified criteria
formula auditing
a group of editing options on the Formulas tab that you can use to review and correct errors in formulas
data series
Each group of data points or values used in a graph
a data series, in a pie chart
In a pie chart, a data series is the whole pie, a data point is a slice of a pie
sparklines
miniature charts in a cell or cell range that illustrate trends and patterns without adding a separate chart object or sheet
where is the data analysis command located
in the data tab
legend
explains the symbols, textures, or colors used to differentiate data series
how many data series can a pie chart graph?
a single data series
line chart
used to display trends over time or categories, when order is important
moving average
used to smooth out irregularities (peaks and valleys) to easily recognize trends
data analysis pack
required to create a moving average chart
category label
the text label that describes each data series
