Basic and Advance Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Basic and Advance flashcards as text
Which function returns the number of cells in a range that meet a given condition?
Answer: COUNTIF
COUNTIF counts cells within a range that satisfy a single specified criterion.
What does the $ symbol do when placed before a column letter or row number in a formula?
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.
Which Excel feature automatically suggests a formula pattern based on adjacent data you have already entered?
Answer: AutoFill
AutoFill extends a pattern (numbers, dates, or formulas) by dragging the fill handle across adjacent cells.
What is the result of =MOD(17, 5)?
Answer: 2
MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2.
Which keyboard shortcut applies bold formatting to the selected cells?
Answer: Ctrl+B
Ctrl+B toggles bold formatting on or off for the selected text or cells.
When you sort a table by a column in ascending order, how does Excel sort text values?
Answer: A to Z
Ascending sort orders text alphabetically from A to Z.
Which function would you use to round 4.567 to two decimal places?
Answer: =ROUND(4.567,2)
ROUND(number, num_digits) rounds a number to the specified number of decimal places using standard rounding rules.