MOS Excel 3 — Questions and Answers
Question 1: In an Excel formula, what does the $ symbol do when placed before a column letter or row number?
- Formats the cell as currency
- Creates an absolute reference that does not change when copied (Correct answer)
- Indicates a named range
- Links to an external workbook
Correct answer: Creates an absolute reference that does not change when copied
The $ symbol creates an absolute reference, preventing the row or column from changing when the formula is copied.
Question 2: Which chart type is best suited for showing the proportion of parts to a whole?
- Line chart
- Bar chart
- Pie chart (Correct answer)
- Scatter chart
Correct answer: Pie chart
A pie chart displays data as slices of a circle, making it ideal for showing each category's proportion of a total.
Question 3: What does the Excel function TODAY() return?
- The current date and time
- The current date only (Correct answer)
- The current time only
- The date the workbook was created
Correct answer: The current date only
TODAY() returns the current date as a serial number formatted as a date, with no time component.
Question 4: Which option in Excel's Paste Special dialog lets you paste only the results of formulas, not the formulas themselves?
- Paste All
- Paste Formulas
- Paste Values (Correct answer)
- Paste Formats
Correct answer: Paste Values
Paste Values pastes only the calculated results of formulas, stripping out the underlying formula.
Question 5: In Excel, which of the following is a valid way to reference the range A1 to D10?
- A1,D10
- A1:D10 (Correct answer)
- A1-D10
- A1..D10
Correct answer: A1:D10
The colon (:) operator defines a range from the first cell to the last cell, so A1:D10 references all cells from A1 through D10.
Question 6: What is the maximum number of rows supported in an Excel worksheet (Excel 2016 and later)?
- 65,536
- 1,048,576 (Correct answer)
- 524,288
- 2,097,152
Correct answer: 1,048,576
Excel 2007 and later versions support up to 1,048,576 rows per worksheet.
Question 7: Which Excel function concatenates two or more text strings into one string?
- JOIN
- CONCAT (Correct answer)
- MERGE
- COMBINE
Correct answer: CONCAT
CONCAT (or the older CONCATENATE) joins multiple text strings into a single string.
MOS Excel 3
In an Excel formula, what does the $ symbol do when placed before a column letter or row number?