BAT Final Exam Study Guide – Complete Review, Key Concepts & Practice
Questions
SUM is a built-in formula that adds the values in a selected range. - ✔✔true
The Formula bar displays the result of the formula and a cell displays the formula. - ✔✔False
The Format Painter copies formatting attributes and styles from one cell to another cell or
range. - ✔✔True
Which of the following is the name used to describe a group of cells? - ✔✔Range
Which of the following simplifies the process of entering the months of the year in a
worksheet? - ✔✔Fill Handle Tool
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
In a function, the information inside the parentheses after the function name is called its -
✔✔argument(s)
Excel recognizes patterns and can complete most series with the ___________________. -
✔✔Fill handle
When you cut or copy data, they are stored - ✔✔On the Windows clipboard
, The term syntax refers to the required parts of a formula and the rules controlling the order of
the parts. - ✔✔True
Column and row references do not change, when you copy a relative cell address. - ✔✔False
Range names describe a cell or group of cells and make it easier to interpret a formula. -
✔✔True
Arguments are the pieces of information within parentheses in functions that determine what
value a function returns. - ✔✔True
The TODAY and NOW functions have only one argument. - ✔✔False
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. - ✔✔False
Once you have selected a cell address, which of the following keys lets you insert dollar signs
quickly? - ✔✔F4
Which of the following functions counts the number of cells in a range that contain any data
type, text or numbers? - ✔✔COUNTA
Which of the following functions counts the number of cells in a range based on specified
criteria? - ✔✔COUNTIF
Which of the following refers to a group of editing options on the Formulas tab that you can use
to review and correct errors in formulas? - ✔✔Formula Auditing
Each group of data points or values used in a graph is a data series. - ✔✔True
Questions
SUM is a built-in formula that adds the values in a selected range. - ✔✔true
The Formula bar displays the result of the formula and a cell displays the formula. - ✔✔False
The Format Painter copies formatting attributes and styles from one cell to another cell or
range. - ✔✔True
Which of the following is the name used to describe a group of cells? - ✔✔Range
Which of the following simplifies the process of entering the months of the year in a
worksheet? - ✔✔Fill Handle Tool
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
In a function, the information inside the parentheses after the function name is called its -
✔✔argument(s)
Excel recognizes patterns and can complete most series with the ___________________. -
✔✔Fill handle
When you cut or copy data, they are stored - ✔✔On the Windows clipboard
, The term syntax refers to the required parts of a formula and the rules controlling the order of
the parts. - ✔✔True
Column and row references do not change, when you copy a relative cell address. - ✔✔False
Range names describe a cell or group of cells and make it easier to interpret a formula. -
✔✔True
Arguments are the pieces of information within parentheses in functions that determine what
value a function returns. - ✔✔True
The TODAY and NOW functions have only one argument. - ✔✔False
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. - ✔✔False
Once you have selected a cell address, which of the following keys lets you insert dollar signs
quickly? - ✔✔F4
Which of the following functions counts the number of cells in a range that contain any data
type, text or numbers? - ✔✔COUNTA
Which of the following functions counts the number of cells in a range based on specified
criteria? - ✔✔COUNTIF
Which of the following refers to a group of editing options on the Formulas tab that you can use
to review and correct errors in formulas? - ✔✔Formula Auditing
Each group of data points or values used in a graph is a data series. - ✔✔True
