Excel - Ch. 7: Excel Cell Referencing
Text-only quiz: Ch. 7: Excel Cell Referencing
Want to study this quiz?
Copy it to your free Gradiuz library and make it your own.
Question 1
What is the primary purpose of using range references in Microsoft Excel?
- To refer to groups of cells on a worksheet
- To change the font of multiple cells
- To create new worksheets
- To hide rows and columns
Question 2
To reference a range of cells from A1 to A10, the correct notation would be A1:_____.
Fill in the blank
Question 3
When specifying a range of cells, the starting and ending cells are separated by a semicolon.
- True
- False
Question 4
Which of the following functions is explicitly mentioned as taking range references as arguments?
- SUM
- IF
- VLOOKUP
- CONCATENATE
Question 5
The formula =SUM(A1:A10) would calculate the _____ of the values in cells A1 through A10.
Fill in the blank
Question 6
Which type of range reference automatically adjusts according to changes made to your data?
- Dynamic range reference
- Static range reference
- Absolute range reference
- Relative range reference
Question 7
The INDIRECT function can be used to create dynamic range references.
- True
- False
Question 8
Microsoft Excel uses range references to refer to groups of cells on a _____
Fill in the blank
Question 9
Named Ranges can enhance the clarity and comprehensibility of your formulas.
- True
- False
Question 10
What symbol separates the starting and ending cells when referencing a range?
- A colon
- A comma
- A semicolon
- A hyphen
Question 11
Which of these functions is NOT mentioned as supporting dynamic range references in the provided text?
- OFFSET
- INDEX
- INDIRECT
- SUM
Question 12
What is the default reference style used in Microsoft Excel?
- A1 Style
- R1C1 Style
- Absolute Style
- Mixed Style
Question 13
In the A1 Style, cells are identified using a combination of their column letter and _____
Fill in the blank
Question 14
In the R1C1 style, how is the cell in the first row and first column denoted?
- R1C1
- A1
- 1A
- C1R1
Question 15
Which of the following represents the cell positioned in the second row and third column using the R1C1 style?
- R2C3
- C3R2
- B3
- R3C2
Question 16
If a formula in cell A1 references cell B1 (=B1) and is copied to cell A2, it will automatically adjust to reference cell B2 (=B2).
- True
- False
Question 17
To denote an absolute reference, a "$" symbol is added before the column letter and/or _____
Fill in the blank
Question 18
What is the defining characteristic of absolute references in Excel?
- Their unwavering constancy, no matter how many times the formula is copied.
- Their ability to adjust based on their new position when copied.
- Their flexibility to change either row or column when copied.
- Their use of only column letters for identification.
Question 19
Which type of reference allows either the row or the column to remain fixed while the other can change when the formula is copied?
- Mixed Reference
- Relative Reference
- Absolute Reference
- A1 Style Reference
Question 20
A mixed reference like $A1 locks column A while still allowing the row number to change when copied horizontally.
- True
- False
Made with Gradiuz
Turn any PDF into quizzes, flashcards and summaries - free.