18 Questions
Which key can be used to toggle through the four types of cell references in Excel?
F4
What type of cell reference has one part as absolute and the other as relative?
Mixed reference
In which cell does Excel display a green triangle if it detects a potential error in a formula?
Top-left corner
What type of cell reference is indicated by $A1 in an Excel formula?
Fixed reference
Which category of functions include Date & Time, Financial, Logical, and Statistical functions in Excel?
Function categories
What does a circular reference occur in Excel?
When a formula is self-referential and cannot be evaluated
'=SUM(A1:A3)' demonstrates what in Excel?
'SUM' function with correct syntax
'=E2*-$C$4' would lead to what kind of error message in Excel?
'#REF!' error
'=D3*$B$4' should be copied from row 3 to row 4. What will the formula become in row 4?
'=D4*$B$4'
What is the purpose of the SUM function in Excel?
Returns the mathematical sum of values in a range of cells
Which mathematical operation does the formula =D2-E2 represent?
Subtraction
In the formula =SUM(A1,B3,C5), what does the SUM function return?
Sum of values in cells A1, B3, and C5
What is the purpose of the MIN function in Excel?
Returns the smallest value in a range
What should not be used as an argument for the SUM function?
=SUM(A1+A2)
What does the MEDIAN function return in Excel?
Midpoint value between maximum and minimum values in a range
What does the COUNTBLANK function do?
Counts the number of empty cells in a range
What does the AVERAGE function do?
Returns arithmetic mean of values in a range
In Excel, what does the COUNT function return?
Number of numeric values in a range
Study Notes
Cell References
- Three types of cell references in Excel: absolute, relative, and mixed
- Absolute cell reference (e.g. $A$1): fixed address that doesn't change when copied
- Relative cell reference (e.g. A1): address adjusts relative to new location when copied
- Mixed cell reference (e.g. $A1 or A$1): one part is absolute, the other is relative
- F4 key toggles through the four types of cell references
Functions
- Predefined formulas available in various categories (Date & Time, Financial, Logical, Statistical)
- Example: =SUM(A1:A3) is a well-formed function that returns the sum of values in range A1 to A3
- Function syntax: =function_name(argument)
- Multiple cells or ranges can be separated by commas as arguments
Statistical Functions
- AVERAGE: returns the average or arithmetic mean of a range
- MEDIAN: returns the midpoint value in a range
- MIN: returns the smallest or minimum value in a range
- MAX: returns the largest or maximum value in a range
- COUNT: returns the number of numeric values in a range
- COUNTBLANK: returns the number of empty cells in a range
This quiz tests your knowledge on the types of cell references in Excel formulas: absolute, relative, and mixed references. Learn about how the F4 key can be used to toggle through these types of references.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free