DATA ANALYSIS Spreadsheet Functions to Organize Data Latest Assessment MODULE 2 Q & A 2026 (Complete And Verified Study material) (16pages) LEARNEXAMS

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