Microsoft Excel Basic and Advance 2 — Questions and Answers
Question 1: Which function returns the number of cells in a range that meet a given condition?
- COUNT
- COUNTIF (Correct answer)
- SUMIF
- COUNTA
Correct answer: COUNTIF
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?
- Formats the cell as currency
- Anchors the reference so it does not change when copied (Correct answer)
- Adds a dollar sign to the displayed value
- Marks the cell as protected
Correct answer: Anchors the reference so it does not change when copied
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?
- AutoCorrect
- Flash Fill
- AutoFill (Correct answer)
- Quick Analysis
Correct answer: AutoFill
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)?
- 3
- 2 (Correct answer)
- 3.4
- 12
Correct answer: 2
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?
- Ctrl+I
- Ctrl+U
- Ctrl+B (Correct answer)
- Ctrl+F
Correct answer: Ctrl+B
Ctrl+B toggles bold formatting on or off for the selected text or cells.
Question 6: When you sort a table by a column in ascending order, how does Excel sort text values?
- Z to A
- A to Z (Correct answer)
- By cell color
- By font size
Correct answer: A to Z
Ascending sort orders text alphabetically from A to Z.
Question 7: Which function would you use to round 4.567 to two decimal places?
- =TRUNC(4.567,2)
- =INT(4.567,2)
- =ROUND(4.567,2) (Correct answer)
- =CEILING(4.567,2)
Correct answer: =ROUND(4.567,2)
ROUND(number, num_digits) rounds a number to the specified number of decimal places using standard rounding rules.
Microsoft Excel Basic and Advance 2
Which function returns the number of cells in a range that meet a given condition?