BAT Study Guide ACTUAL UPDATED Exam Questions and CORRECT Answers

BAT Study Guide ACTUAL UPDATED
Exam Questions and CORRECT Answers
SUM is a built-in formula that adds the values in a selected range. - CORRECT
ANSWER - True


The Formula bar displays the result of the formula and a cell displays the formula. - CORRECT
ANSWER - False


To enter a number as a label in a cell, we should press the space bar before typing the number. -
CORRECT ANSWER - False



The address $C$15 is a relative cell address. - CORRECT ANSWER - False


The error message that alerts us that we are accidentally trying to divide a number by zero is
#VALUE! - CORRECT ANSWER - False



One of the components of the COUNTIF function is a criterion. - CORRECT ANSWER -
True


The Format Painter copies formatting attributes and styles from one cell to another cell or range.
- CORRECT ANSWER - True


We can copy a worksheet to create an exact duplicate of its data and formatting with the Move or
Copy dialog box. - CORRECT ANSWER - True


How should you save a file if you want it to be compatible with older versions of Microsoft
Excel? - CORRECT ANSWER - Excel 97-2003 Workbook

,Which of the following is the name used to describe a group of cells? - CORRECT
ANSWER - Range


Which of the following simplifies the process of entering the months of the year in a worksheet?
- CORRECT ANSWER - Fill Handle tool


To select non-adjacent cells, columns, or rows, which key must you press? - CORRECT
ANSWER - Ctrl


We should use cell addresses in formulas, rather than explicit numbers, because - CORRECT
ANSWER - the formulas can automatically update, if a number in a cell used by the
formula is changed


The Excel feature that allows us to determine what kind of information we re entering into a cell
is - CORRECT ANSWER - Data type


One of the most important reasons for using Excel as a tool for describing and modeling business
situations is that - CORRECT ANSWER - it is capable of automatic recalculation.


In a function, the information inside the parentheses after the function name is called its -
CORRECT ANSWER - argument(s)


Excel recognizes patterns and can complete most series with the ___________________. -
CORRECT ANSWER - Fill handle



When you cut or copy data, they are stored - CORRECT ANSWER - on the Windows
clipboard


When we want to apply several formatting commands to a cell or range, we can use the -
CORRECT ANSWER - Format Cells dialog box

, The ____________________ command displays a label on multiple lines within the cell,
splitting the label between words to fit the width of the column. - CORRECT ANSWER -
Wrap Text


Which of the following is a true statement?


A. There are three types of cell references you can use in a formula.
B. The type of cell references included in a formula determines the result of a formula when it is
copied.
C. Cells that contain absolute references do not change when copied.

D. All of the above. - CORRECT ANSWER - D. All of the above.


In the function =SUM(B2:B6), which part of the function is the argument? - CORRECT
ANSWER - B2:B6


Which of the following functions counts the number of cells in a range based on specified
criteria? - CORRECT ANSWER - COUNTIF


Which of the following functions counts the number of cells in a range that contain any data
type, text, or numbers? - CORRECT ANSWER - COUNTA


This type of cell reference does not change when copied and remains in a fixed position during
operations: - CORRECT ANSWER - Absolute


A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell
reference, adding the dollar sign ($) in front of the column and row addresses, is: - CORRECT
ANSWER - F4


This useful Excel function evaluates a specified condition or statement and returns one value if
the condition or statement is true and another value if it is false: - CORRECT ANSWER -
IF