Quiz
Exam 2 Tutorial 3
This quiz has question types that open in the usual player.
Questions in this quiz (19)
1Use the _____ symbol to make a cell reference absolute.
- Aa. asterisk *
- Bb. number #
- Cc. dollar $
- Dd. equal sign
2True/False: A relative reference is a cell reference that changes when it is copied and pasted in a new
location.- ATrue
- BFalse
3True/False: Functions are organized in the Function Library group.
- ATrue
- BFalse
4 True/False: To add a collection of numbers, use the COUNT function.
- ATrue
- BFalse
5To let Excel know you want to enter a formula, after clicking in a cell press the
[blank_start]Equal sign =[blank_end] key.- AEqual sign =
6True/False: An error indicator appears in the upper-left corner of the cell with the error value.
- ATrue
- BFalse
7 True/False: The #NUM! error value means that a cell reference used in a formula or function is no
longer valid.- ATrue
- BFalse
8 True/False: AutoFill copies content but not formats from a cell or range into an adjacent cell or range.
- ATrue
- BFalse
9True/False: The small black square in the lower-right corner of a selected cell or range is called the
AutoFill button.- ATrue
- BFalse
10 If you don’t want the cell reference to change when you copy the formula use the
[blank_start]absolute[blank_end] reference.- Aabsolute
11B$4 is an example of a(n) [blank_start]mixed[blank_end] reference.
- Amixed
12What symbol appears at the beginning of a function? An [blank_start]equal sign[blank_end]
- Aequal sign
13 A(n) [blank_start]comparison operator[blank_end] is a symbol that indicates the relationship between two values.
- Acomparison operator
14 True/False: The TODAY function doesn’t have any arguments.
- ATrue
- BFalse
15True/False: Like the COUNT function, many of Excel’s statistical functions ignore cells that are blank
or contain text.- ATrue
- BFalse
16True/False: If you leave a cell blank, the COUNTA function will include it.
- ATrue
- BFalse
17True/False: The values returned by the TODAY and NOW functions are updated automatically whenever
you reopen the workbook or enter a new calculation.- ATrue
- BFalse
18 To retrieve the return value from a vertical lookup table, you use the [blank_start]VLOOKUP[blank_end] function.
- AVLOOKUP
19 If the VLOOKUP function cannot find the lookup value, the [blank_start]#N/A[blank_end] error value is displayed in the
cell.- A#N/A
Information
- Description
- Quiz on Exam 2 Tutorial 3, created by Chris Serrano on 30/10/2015.
- Author
- Chris Serrano
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz