mid term Flashcards
(29 cards)
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
