DATA ANALYSIS
Spreadsheet Functions
to Organize Data Latest
Assessment
MODULE 2 Q & A
2024
,1. What is the keyboard shortcut to insert a function in
Excel?
a) Ctrl + F
b) Shift + F3
c) Alt + F
d) F4
Answer: b) Shift + F3
Rationale: This shortcut opens the Insert Function dialog
box, which allows you to search and select a function from
various categories.
2. Which of the following functions can be used to count
the number of cells in a range that meet a certain
condition?
a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK
Answer: c) COUNTIF
Rationale: The COUNTIF function takes two arguments: a
range of cells and a condition (or criteria). It returns the
number of cells in the range that match the condition.
3. What is the difference between absolute and relative cell
references in Excel?
a) Absolute references refer to fixed cells, while relative
references refer to cells that change depending on the
position of the formula.
b) Absolute references refer to cells that change depending
, on the position of the formula, while relative references
refer to fixed cells.
c) Absolute references refer to cells in another worksheet,
while relative references refer to cells in the same
worksheet.
d) Absolute references refer to cells in the same worksheet,
while relative references refer to cells in another
worksheet.
Answer: a) Absolute references refer to fixed cells, while
relative references refer to cells that change depending on
the position of the formula.
Rationale: Absolute references use dollar signs ($) before
the column and row coordinates, such as $A$1. Relative
references do not use dollar signs, such as A1. When
copying and pasting formulas, absolute references stay the
same, while relative references adjust according to the new
location.
4. Which of the following functions can be used to look up
a value in a table based on a matching value in another
column or row?
a) VLOOKUP
b) HLOOKUP
c) XLOOKUP
d) All of the above
Answer: d) All of the above
Rationale: VLOOKUP, HLOOKUP, and XLOOKUP are
all lookup functions that can find a value in a table based
on a matching value in another column or row. VLOOKUP
stands for vertical lookup, HLOOKUP stands for horizontal
Spreadsheet Functions
to Organize Data Latest
Assessment
MODULE 2 Q & A
2024
,1. What is the keyboard shortcut to insert a function in
Excel?
a) Ctrl + F
b) Shift + F3
c) Alt + F
d) F4
Answer: b) Shift + F3
Rationale: This shortcut opens the Insert Function dialog
box, which allows you to search and select a function from
various categories.
2. Which of the following functions can be used to count
the number of cells in a range that meet a certain
condition?
a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK
Answer: c) COUNTIF
Rationale: The COUNTIF function takes two arguments: a
range of cells and a condition (or criteria). It returns the
number of cells in the range that match the condition.
3. What is the difference between absolute and relative cell
references in Excel?
a) Absolute references refer to fixed cells, while relative
references refer to cells that change depending on the
position of the formula.
b) Absolute references refer to cells that change depending
, on the position of the formula, while relative references
refer to fixed cells.
c) Absolute references refer to cells in another worksheet,
while relative references refer to cells in the same
worksheet.
d) Absolute references refer to cells in the same worksheet,
while relative references refer to cells in another
worksheet.
Answer: a) Absolute references refer to fixed cells, while
relative references refer to cells that change depending on
the position of the formula.
Rationale: Absolute references use dollar signs ($) before
the column and row coordinates, such as $A$1. Relative
references do not use dollar signs, such as A1. When
copying and pasting formulas, absolute references stay the
same, while relative references adjust according to the new
location.
4. Which of the following functions can be used to look up
a value in a table based on a matching value in another
column or row?
a) VLOOKUP
b) HLOOKUP
c) XLOOKUP
d) All of the above
Answer: d) All of the above
Rationale: VLOOKUP, HLOOKUP, and XLOOKUP are
all lookup functions that can find a value in a table based
on a matching value in another column or row. VLOOKUP
stands for vertical lookup, HLOOKUP stands for horizontal
