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
Category | Exams and Certifications |
Comments | 0 |
Rating | |
Sales | 0 |