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
