Microsoft Excel Excel MCQ 5 — Questions and Answers
Question 1: What is the result of =ROUND(3.567, 2)?
- 3.5
- 3.57 (Correct answer)
- 3.56
- 4.0
Correct answer: 3.57
ROUND(3.567, 2) rounds 3.567 to 2 decimal places, resulting in 3.57.
Question 2: Which of the following is NOT a valid cell reference style in Excel?
- A1
- R1C1
- AA100
- 1A (Correct answer)
Correct answer: 1A
Cell references in the A1 style must begin with the column letter(s) followed by the row number.
Question 3: What is the purpose of Data Validation in Excel?
- To check formulas for errors automatically
- To restrict the type or range of data entered into a cell (Correct answer)
- To format cells based on their values
- To sort and filter data in a table
Correct answer: To restrict the type or range of data entered into a cell
Data Validation restricts what users can enter into a cell, such as only allowing numbers within a specific range.
Question 4: Which keyboard shortcut selects an entire row in Excel?
- Ctrl + Space
- Shift + Space (Correct answer)
- Ctrl + R
- Alt + Space
Correct answer: Shift + Space
Shift + Space selects the entire row of the currently active cell.
Question 5: What does the NOW() function return in Excel?
- Only the current date
- The current date and time (Correct answer)
- Only the current time
- The date and time the file was last saved
Correct answer: The current date and time
NOW() returns the current date and time as a serial number that updates whenever the worksheet is recalculated.
Question 6: Which Excel feature allows you to split a single column of data into multiple columns based on a delimiter?
- Flash Fill
- Text to Columns (Correct answer)
- Power Query Split
- Data Separation
Correct answer: Text to Columns
Text to Columns (under the Data tab) splits cell content into separate columns using a delimiter like a comma or space.
Question 7: What is the function of the SUMPRODUCT formula?
- Multiplies all values in a single range
- Multiplies corresponding elements in arrays and returns their sum (Correct answer)
- Adds numbers only if a condition is met
- Calculates the product of a range then adds a constant
Correct answer: Multiplies corresponding elements in arrays and returns their sum
SUMPRODUCT multiplies corresponding values across multiple arrays and returns the sum of those products.
Microsoft Excel Excel MCQ 5
What is the result of =ROUND(3.567, 2)?