Preview Extract

Exploring Microsoft Office 365, Excel 2019 Comprehensive (Poatsy)
Chapter 3 Formulas and Functions
1) If you wanted to reference a cell in a formula and you did not want that cell to change when
copying and pasting you would use what kind of reference?
A) Fixed
B) Relative
C) Mixed
D) Absolute
Answer: D
Diff: 1
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
2) If a cell containing =B$14 is copied and pasted three columns over and two rows down, what
would the resultant cell reference become?
A) E$14
B) $E$14
C) B16
D) B$16
Answer: A
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
3) If the cell reference $A5 in a formula is copied and pasted over two columns and down two
rows from its original cell, what the cell reference become in the new cell?
A) $A5
B) $A7
C) $C5
D) $C7
Answer: B
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
4) What is the default method of referencing cells in formulas?
A) Absolute
B) Relative
C) Mixed
D) Default
Answer: B
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
1
Copyright ยฉ 2020 Pearson
5) Which of the following is not a valid logical test?
A) =>
B) <=
C)
D) >=
Answer: A
Diff: 2
Objective: E2.07 Use the IF Function
6) Which keyboard shortcut toggles through the types of reference options?
A) F2
B) F3
C) F4
D) F5
Answer: C
Diff: 3
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
7) What type of cell reference should be used when a value remains constant?
A) Absolute
B) Relative
C) Mixed
D) Constant
Answer: A
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
8) If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over
and four rows down, what would the resultant cell reference become?
A) =F18
B) =$F$18
C) =B14
D) =$B$14
Answer: D
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
9) Which Excel function changes the value to a desired number of decimal places?
A) truncate
B) Round
C) Decrease decimal
D) Increase decimal
Answer: B
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
2
Copyright ยฉ 2020 Pearson
10) What describes a function’s purpose?
A) Arguments
B) Name
C) Category
D) Variables
Answer: B
Diff: 2
Objective: E2.02 Insert a Function
11) Which of the following is not a category of functions?
A) Logical
B) Financial
C) Statistical
D) Graphing
Answer: D
Diff: 2
Objective: E2.02 Insert a Function
12) What punctuation is used to separate the two cell references in a range?
A) Period (.)
B) Semi-colon (;)
C) Comma (,)
D) Colon (:)
Answer: D
Diff: 1
Objective: E2.02 Insert a Function
13) Functions can be selected by using the ________.
A) Add Function dialog box
B) Format Function dialog box
C) Insert Function dialog box
D) Create Function dialog box
Answer: C
Diff: 2
Objective: E2.02 Insert a Function
14) What do you use to separate arguments in a function?
A) Period (.)
B) Semi-colon (;)
C) Comma (,)
D) Colon (:)
Answer: C
Diff: 1
Objective: E2.02 Insert a Function
3
Copyright ยฉ 2020 Pearson
15) What error will you get if you type a function name incorrectly?
A) #FUNCTION?
B) #VALUE?
C) #ERROR?
D) #NAME?
Answer: D
Diff: 3
Objective: E2.02 Insert a Function
16) What term refers to the necessity of following the rules when it comes to using functions?
A) syntax
B) formula
C) arguments
D) function logic
Answer: A
Diff: 1
Objective: E2.02 Insert a Function
17) What does Excel use to indicate optional arguments in a function?
A) Square brackets []
B) Parenthesis ()
C) Curly brackets {}
D) Quote marks “”
Answer: A
Diff: 2
Objective: E2.02 Insert a Function
18) Which function would you use if you wanted to count the number of values, but ignore cells
that have text or are empty?
A) COUNT
B) COUNTA
C) COUNTBLANK
D) COUNTVALUES
Answer: A
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
19) What two functions compute the central tendency of values?
A) AVERAGE and MODE
B) AVERAGE and MEDIAN
C) MIN and MAX
D) AVERAGE and CENTER
Answer: B
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
4
Copyright ยฉ 2020 Pearson
20) Where does Excel automatically display statistics like count, average, and sum when a range
of values is selected?
A) Formula bar
B) Name box
C) Status bar
D) Statistics bar
Answer: C
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
21) The ROUND function requires how many arguments?
A) 2
B) 3
C) 4
D) 1
Answer: A
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
22) What is the term for the inputs required in a function?
A) formulas
B) syntax
C) arguments
D) terms
Answer: C
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
23) If you wanted to count the number of entries in a list that contained numbers, text, and blank
cells, but ignore the text and blank cells, which function would you use?
A) COUNT
B) COUNTA
C) COUNTBLANK
D) COUNTIF
Answer: A
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
24) Which status bar statistic can you not enable?
A) SUM
B) MIN
C) Range Name
D) Page Number
Answer: C
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
5
Copyright ยฉ 2020 Pearson
25) What action changes the actual number of decimal places Excel stores instead of just
changing what is displayed?
A) Decrease decimal setting
B) Increase decimal setting
C) ROUND function
D) DECIMAL function
Answer: C
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
26) What does the AVERAGE function not ignore?
A) Text
B) Empty cells
C) Dates
D) Cells with N/A
Answer: C
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
27) What function computes the value in which one-half of the data is above and one-half is
below.
A) MIDDLE
B) MODE
C) AVERAGE
D) MEDIAN
Answer: D
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
28) Which of the following does not comply with the preferred way of using the SUM function?
A) =SUM(A4:A11)
B) =SUM(A4:A11, B9:E11)
C) =SUM(A4, B8, D14)
D) =SUM(A4/A11)
Answer: D
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
29) What will you see if you enter the TODAY function without the parenthesis?
A) #VALUE?
B) Nothing. It will fill in the parenthesis for you.
C) #FUNCTION?
D) #NAME?
Answer: D
Diff: 3
Objective: E2.04 Use Date Functions
6
Copyright ยฉ 2020 Pearson
30) Which function would you use to find the oldest date in a range?
A) MIN
B) MAX
C) OLDEST
D) MEDIAN
Answer: A
Diff: 1
Objective: E2.04 Use Date Functions
31) Which of the following will not return the system clock’s date?
A) NOW()
B) TODAY()
C) Ctrl+;
D) DATE()
Answer: D
Diff: 3
Objective: E2.04 Use Date Functions
32) What keyboard shortcut will automatically update any formulas using =TODAY() or
=NOW()?
A) F8
B) F9
C) F10
D) F11
Answer: B
Diff: 3
Objective: E2.04 Use Date Functions
33) Which of the following is not a valid test in an =IF statement?
A) A4-B4
B) A4A4
D) B414,”Greater”,IF(A7>20,”Much Greater”,”Not Greater than 20″))
B) =IF(A720,”Much Greater”,”Not Greater than 20″))
C) =IF(A720,”Much Greater”,”Not Greater than 20″))
D) =IF(A720,”Much Greater”,”Not Greater than 20″)
Answer: C
Diff: 3
Objective: E2.07 Use the IF Function
7
Copyright ยฉ 2020 Pearson
35) Which of the following is not an argument associated with the IF function?
A) Test
B) Value if true
C) Value if false
D) Value if neither true nor false
Answer: D
Diff: 2
Objective: E2.07 Use the IF Function
36) Which of the following is not a valid =IF statement?
A) =IF(A5>19,”Greater”,”Not Greater”)
B) =IF(A5>19,b7,b9)
C) =IF(A5>19,1,9)
D) =IF(A5>19,Greater,Not Greater)
Answer: D
Diff: 2
Objective: E2.07 Use the IF Function
37) Which of the following is not a valid lookup function?
A) HLOOKUP
B) VLOOKUP
C) LLOOKUP
D) LOOKUP
Answer: C
Diff: 2
Objective: E2.05 Use Lookup Functions
38) To look up an exact match, what should you enter in the range_lookup argument?
A) FALSE
B) TRUE
C) EXACT
D) Leave it blank
Answer: A
Diff: 3
Objective: E2.05 Use Lookup Functions
39) Which of the following would not produce the correct monthly payment on a loan of $13,000
which will be paid off in 5 years with an annual interest rate of 6%?
A) =PMT(6%,60,-13000)
B) =PMT(.5%,60,-13000)
C) =PMT(.5%,5*12,-13000)
D) =PMT(6%/12,60,-13000)
Answer: A
Diff: 2
Objective: E2.06 Use the PMT Function
8
Copyright ยฉ 2020 Pearson
40) If you will never copy and paste a formula you do not have to be concerned about absolute,
relative, or mixed references.
Answer: TRUE
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
41) In a mixed reference you can put the dollar sign ($) in front of the column or row indicator.
Answer: TRUE
Diff: 2
Objective: E2.01 Use Relative, Absolute, and Mixed Cell References in Formulas
42) A good practice when entering function names is to type them in lowercase and see if Excel
converts them to upper case.
Answer: TRUE
Diff: 3
Objective: E2.02 Insert a Function
43) When entering functions, the square brackets, [], indicate required values.
Answer: FALSE
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
44) The COUNTBLANK function will count cells that contain formulas that compute to a value
of zero (0).
Answer: FALSE
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
45) This is a valid way to use the MAX function: =MAX(a4:d11, f1:f2)
Answer: TRUE
Diff: 3
Objective: E2.03 Insert Basic Math and Statistics Functions
46) The COUNTA function only counts text entries. It does not count calculable values or blank
cells.
Answer: FALSE
Diff: 2
Objective: E2.03 Insert Basic Math and Statistics Functions
47) Excel assigns date number 1 to January 1, 1900.
Answer: TRUE
Diff: 2
Objective: E2.04 Use Date Functions
9
Copyright ยฉ 2020 Pearson
48) All IF functions have three arguments.
Answer: TRUE
Diff: 1
Objective: E2.07 Use the IF Function
49) You could use both A3>b9 or B99,”Bigger”,”Smaller”)
II. =???(12%/12,360,-120000)
III. =???(A4,B4:F9,2)
IV. =???(B9:E21)
V. =???()
A. NOW
B. PMT
C. VLOOKUP
D. IF
E. SUM
Answer: D, B, C, E, A
Diff: 3
Objective: Multiple Objectives
96) Match the following terms with their description:
I. VLOOKUP
II. HLOOKUP
III. Lookup table
IV. Lookup value
V. Column index number
A. Data is organized in rows
B. Column that contains the return values
C. Cell that contains the value to be looked up
D. Has the data used with HLOOKUP or VLOOKUP
E. Data is organized in columns
Answer: E, A, D, C, B
Diff: 2
Objective: E2.05 Use Lookup Functions
18
Copyright ยฉ 2020 Pearson

## Document Preview (18 of 229 Pages)

You are viewing preview pages of the document. Purchase to get full access instantly.

-37%

### Test Bank For Exploring: Microsoft Excel 2019 Comprehensive, 1st Edition

$18.99 ~~$29.99~~Save:$11.00(37%)

24/7 Live Chat

Instant Download

100% Confidential

Store

##### Evelyn Miller

0 (0 Reviews)

## Best Selling

The World Of Customer Service, 3rd Edition Test Bank

$18.99 ~~$29.99~~Save:$11.00(37%)

Chemistry: Principles And Reactions, 7th Edition Test Bank

$18.99 ~~$29.99~~Save:$11.00(37%)

Solution Manual for Designing the User Interface: Strategies for Effective Human-Computer Interaction, 6th Edition

$18.99 ~~$29.99~~Save:$11.00(37%)

2023-2024 ATI Pediatrics Proctored Exam with Answers (139 Solved Questions)

$18.99 ~~$29.99~~Save:$11.00(37%)

Data Structures and Other Objects Using C++ 4th Edition Solution Manual

$18.99 ~~$29.99~~Save:$11.00(37%)

Test Bank for Hospitality Facilities Management and Design, 4th Edition

$18.99 ~~$29.99~~Save:$11.00(37%)