MOS Excel 2 — Questions and Answers
Question 1: Which Excel function returns the number of cells in a range that meet a single condition?
- COUNT
- COUNTIF (Correct answer)
- SUMIF
- COUNTA
Correct answer: COUNTIF
COUNTIF counts cells within a range that meet a specified single condition.
Question 2: When you freeze panes in Excel, what is frozen by default when you select cell B2 and apply Freeze Panes?
- Only row 1
- Only column A
- Row 1 and column A (Correct answer)
- Rows 1-2 and columns A-B
Correct answer: Row 1 and column A
Freeze Panes with B2 selected freezes everything above and to the left — row 1 and column A.
Question 3: Which keyboard shortcut applies the Currency format to selected cells in Excel?
- Ctrl+Shift+$ (Correct answer)
- Ctrl+Shift+%
- Ctrl+Shift+#
- Ctrl+Shift+@
Correct answer: Ctrl+Shift+$
Ctrl+Shift+$ applies the Currency number format to selected cells.
Question 4: In Excel, what does the TRIM function do?
- Removes all spaces from text
- Removes leading, trailing, and extra spaces between words (Correct answer)
- Truncates text to a specified length
- Removes non-printable characters
Correct answer: Removes leading, trailing, and extra spaces between words
TRIM removes leading and trailing spaces and reduces multiple spaces between words to a single space.
Question 5: What is the purpose of the Name Box in Excel?
- Displays the file name of the workbook
- Shows and navigates to cell references or named ranges (Correct answer)
- Lists all defined functions
- Displays the current worksheet tab name
Correct answer: Shows and navigates to cell references or named ranges
The Name Box (left of the formula bar) displays the current cell address and can be used to navigate to or name ranges.
Question 6: Which function would you use to look up a value in the first column of a table and return a value in the same row from another column?
- HLOOKUP
- VLOOKUP (Correct answer)
- MATCH
- INDEX
Correct answer: VLOOKUP
VLOOKUP searches vertically in the first column of a range and returns a value from a specified column in the same row.
Question 7: Which Excel feature allows you to define a series of valid entries for a cell and display them as a dropdown list?
- Conditional Formatting
- Data Validation (Correct answer)
- Cell Styles
- Format Cells
Correct answer: Data Validation
Data Validation can restrict cell input to a list of valid entries and display them as a dropdown list.
MOS Excel 2
Which Excel function returns the number of cells in a range that meet a single condition?