Microsoft Excel Basic and Advance 2

Question 1

Which function returns the number of cells in a range that meet a given condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells within a range that satisfy a single specified criterion.

Question 2

What does the $ symbol do when placed before a column letter or row number in a formula?

Accepted Answer

Anchors the reference so it does not change when copied

Answer

A $ before a column letter or row number creates an absolute reference that stays fixed when the formula is copied.

Question 3

Which Excel feature automatically suggests a formula pattern based on adjacent data you have already entered?

Accepted Answer

AutoFill

Answer

AutoFill extends a pattern (numbers, dates, or formulas) by dragging the fill handle across adjacent cells.

Question 4

What is the result of =MOD(17, 5)?

Accepted Answer

2

Answer

MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2.

Question 5

Which keyboard shortcut applies bold formatting to the selected cells?

Accepted Answer

Ctrl+B

Answer

Ctrl+B toggles bold formatting on or off for the selected text or cells.

Excel Practice Test