-
web.groovymark@gmail.com
- December 8, 2024
Question 01
Which of the following is the shortcut to open the “Format Cells” dialog box?
A. Ctrl + 1
B. Ctrl + 2
C. Alt + F
D. Shift + F11
Answer: A. Ctrl + 1
Explanation: Ctrl + 1 opens the Format Cells dialog box, where you can change various formatting options.
Question 02
What does the VLOOKUP function do in Excel?
A. Looks up values in rows
B. Looks up values in columns
C. Calculates averages
D. Filters data
Answer: B. Looks up values in columns
Explanation: VLOOKUP is used to find a value in the leftmost column and returns a value in the same row from a specified column.
Question 03
What does the SUBTOTAL function in Excel do?
A. Sums the total of a range
B. Performs calculations like sum, average, count, etc., on visible cells
C. Multiplies values in a range
D. Returns the median of a range
Answer: B. Performs calculations like sum, average, count, etc., on visible cells
Explanation: SUBTOTAL allows you to perform calculations (sum, count, average) only on visible cells, ignoring hidden ones.
Question 04
How do you protect a worksheet in Excel?
A. Use the Format Cells option
B. Use the Review tab and select “Protect Sheet”
C. Use the Data tab and select “Data Protection”
D. Use the Home tab and select “Protect”
Answer: B. Use the Review tab and select "Protect Sheet"
Explanation: The Protect Sheet option in the Review tab allows you to restrict users from making changes to a worksheet.
Question 05
Which Excel function is used to count only cells that contain numbers?
A. COUNTA
B. COUNT
C. COUNTIF
D. COUNTBLANK
Answer: B. COUNT
Explanation: COUNT only counts the cells that contain numerical data.
Question 06
What happens when you double-click the fill handle in Excel?
A. It fills the series down to the end of the data range
B. It clears the contents of the cell
C. It formats the selected range
D. It opens the Format Cells dialog box
Answer: A. It fills the series down to the end of the data range
Explanation: Double-clicking the fill handle automatically fills the series down based on adjacent data.
Question 07
What is the main purpose of the PivotTable feature in Excel?
A. To filter data
B. To summarize and analyze large datasets
C. To create visual charts
D. To sort data alphabetically
Answer: B. To summarize and analyze large datasets
Explanation: PivotTables allow users to summarize, analyze, and explore large amounts of data interactively.
Question 08
Which of the following error codes represents an invalid cell reference?
A. #NAME?
B. #REF!
C. #VALUE!
D. #NUM!
Answer: B. #REF!
Explanation: #REF! occurs when a formula contains an invalid cell reference.
Question 09
How can you insert multiple rows at once in Excel?
A. Press Alt + R multiple times
B. Right-click and choose “Insert” after selecting multiple rows
C. Press Ctrl + I
D. Use the Fill Handle and drag down
Answer: B. Right-click and choose "Insert" after selecting multiple rows
Explanation: You can insert multiple rows by selecting the same number of rows as you want to insert, right-clicking, and selecting “Insert.”
Question 10
Which of the following is the correct syntax for the IF function?
A. IF(condition, value_if_true, value_if_false)
B. IF(condition, value_if_false, value_if_true)
C. IF(value_if_true, condition, value_if_false)
D. IF(condition, value_if_false)
Answer: A. IF(condition, value_if_true, value_if_false)
Explanation: The IF function takes a condition, followed by the values to return if the condition is true or false.
Question 11
How do you apply a filter to a data range in Excel?
A. Use the “Data” tab and select “Filter”
B. Use the “Home” tab and select “Sort & Filter”
C. Right-click and select “Apply Filter”
D. Use the “View” tab and select “Data Filter”
Answer: A. Use the "Data" tab and select "Filter"
Explanation: Filters can be applied to a data range through the Filter option in the Data tab.
Question 12
Which of the following features allows you to apply specific formatting based on cell values?
A. Conditional Formatting
B. Data Validation
C. Filter
D. Table Styles
Answer: A. Conditional Formatting
Explanation: Conditional Formatting lets you apply different formats to cells based on their values or specific conditions.
Question 13
What is the main purpose of the “Goal Seek” feature in Excel?
A. To find an input value needed to reach a desired result
B. To filter large datasets
C. To calculate averages
D. To highlight data
Answer: A. To find an input value needed to reach a desired result
Explanation: Goal Seek is used to calculate the input value required to achieve a specified output in a formula.
Question 14
Which of the following is the shortcut for creating a new chart?
A. F11
B. Ctrl + Shift + C
C. Alt + C
D. Ctrl + Alt + F11
Answer: A. F11
Explanation: Pressing F11 creates a new chart based on the selected data in Excel.
Question 15
How do you lock a specific cell to prevent it from changing when copying a formula?
A. Use relative cell references
B. Use absolute cell references with $
C. Use dynamic cell references
D. Press Ctrl + L
Answer: B. Use absolute cell references with $
Explanation: Absolute cell references (e.g., $A$1) prevent cell references from changing when copying formulas.
Question 16
What does the CONCATENATE function do in Excel?
A. Adds numbers
B. Joins text from multiple cells into one
C. Counts cells with text
D. Replaces text
Answer: B. Joins text from multiple cells into one
Explanation: CONCATENATE combines text from different cells into a single cell.
Question 17
Which of the following is the correct formula to calculate the average of a range of cells A1?
A. =AVERAGE(A1)
B. =SUM(A1)
C. =MEDIAN(A1)
D. =AVG(A1)
Answer: A. =AVERAGE(A1)
Explanation: The AVERAGE function calculates the mean of a specified range.
Question 18
What does pressing Ctrl + Z do in Excel?
A. Redoes the last action
B. Undoes the last action
C. Copies the selected cell
D. Deletes the current row
Answer: B. Undoes the last action
Explanation: Ctrl + Z is the standard shortcut for undoing the most recent action.
Question 19
Which of the following functions is used to return the current date and time in Excel?
A. NOW()
B. TODAY()
C. TIME()
D. DATE()
Answer: A. NOW()
Explanation: The NOW() function returns the current date and time.
Question 20
What does the term “cell range” refer to in Excel?
A. A single cell in a worksheet
B. A collection of adjacent cells
C. A chart in a worksheet
D. A filtered set of data
Answer: B. A collection of adjacent cells
Explanation: A cell range refers to a block of adjacent cells in a worksheet.
