-
web.groovymark@gmail.com
- December 8, 2024
Question 21
How can you force a formula to calculate the product of two ranges of numbers?
A. Use the MULTIPLY function
B. Use the PRODUCT function
C. Use the SUM function
D. Use the MULT function
Answer: B. Use the PRODUCT function
Explanation: The PRODUCT function multiplies all numbers in the specified ranges.
Question 22
Which of the following tools allows you to track changes made by multiple users in a workbook?
A. Track Changes
B. Goal Seek
C. Data Validation
D. Protect Sheet
Answer: A. Track Changes
Explanation: Track Changes records the modifications made by different users to a shared workbook.
Question 23
What happens when you press Ctrl + Shift + L in Excel?
A. Applies a filter to the selected data
B. Locks the selected cells
C. Deletes the active worksheet
D. Toggles the gridlines
Answer: A. Applies a filter to the selected data
Explanation: Ctrl + Shift + L toggles filters on or off for the selected data.
Question 24
Which of the following is the keyboard shortcut to insert a new row in Excel?
A. Ctrl + Shift + +
B. Alt + R
C. Ctrl + +
D. Ctrl + Shift + T
Answer: A. Ctrl + Shift + +
Explanation: Ctrl + Shift + + inserts a new row above the currently selected row.
Question 25
What is the purpose of the ROUND function in Excel?
A. To truncate decimal values
B. To round numbers to a specified number of decimal places
C. To generate random numbers
D. To change the format of a cell
Answer: B. To round numbers to a specified number of decimal places
Explanation: The ROUND function rounds numbers to the specified number of decimal places.
Question 26
Which of the following functions would you use to find the number of cells in a range that meet a certain condition?
A. COUNT
B. COUNTA
C. COUNTIF
D. COUNTBLANK
Answer: C. COUNTIF
Explanation: COUNTIF counts the number of cells in a range that meet a specific condition.
Question 27
Which of the following is NOT a function related to text manipulation in Excel?
A. LEFT
B. TEXT
C. PROPER
D. MEAN
Answer: D. MEAN
Explanation: MEAN is not a function in Excel, but LEFT, TEXT, and PROPER are used to manipulate text.
Question 28
How can you enable editing in a cell without using the mouse?
A. Press F2
B. Press F4
C. Press Ctrl + E
D. Press Alt + E
Answer: A. Press F2
Explanation: Pressing F2 puts the active cell in edit mode, allowing you to modify its contents.
Question 29
What is the result of the formula =SUM(3,5,8,-2)?
A. 16
B. 14
C. 15
D. 18
Answer: A. 16
Explanation: SUM adds the values together, resulting in 16.
Question 30
Which of the following is NOT an Excel error message?
A. #VALUE!
B. #NAME?
C. #DIV/0!
D. #INVALID!
Answer: D. #INVALID!
Explanation: #INVALID! is not an Excel error message, while #VALUE!, #NAME?, and #DIV/0! are common error messages.
Question 31
How do you create a named range in Excel?
A. Use the Name Box next to the formula bar
B. Right-click and choose “Name Range”
C. Use the Format tab
D. Go to Data Validation
Answer: A. Use the Name Box next to the formula bar
Explanation: You can create a named range by typing the name in the Name Box and pressing Enter.
Question 32
Which of the following tools allows you to highlight cells that meet a specific condition?
A. Trace Precedents
B. Conditional Formatting
C. Data Validation
D. Goal Seek
Answer: B. Conditional Formatting
Explanation: Conditional Formatting allows you to apply visual formatting to cells that meet a condition.
Question 33
What does the HLOOKUP function do in Excel?
A. Searches for a value in the top row of a table
B. Searches for a value in the left column of a table
C. Looks for a specific value across multiple sheets
D. Compares two sets of data
Answer: A. Searches for a value in the top row of a table
Explanation: HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a row you specify.
Question 34
What happens if you press Ctrl + Home in Excel?
A. Moves the cursor to the last cell with data
B. Selects the first row
C. Moves the cursor to cell A1
D. Highlights the active cell
Answer: C. Moves the cursor to cell A1
Explanation: Ctrl + Home moves the cursor to the top-left corner of the worksheet, cell A1.
Question 35
Which of the following is a valid argument for the VLOOKUP function?
A. Table_Array
B. Row_Index_Number
C. Match_Type
D. Start_Value
Answer: A. Table_Array
Explanation: Table_Array is one of the necessary arguments for the VLOOKUP function, which defines the range containing the lookup data.
Question 36
What is the purpose of the IFERROR function?
A. To return the number of errors in a range
B. To return a custom result if a formula generates an error
C. To fix errors in a formula
D. To display formulas with errors
Answer: B. To return a custom result if a formula generates an error
Explanation: IFERROR allows you to specify a value or message to return if an error occurs in a formula.
Question 37
How can you quickly select an entire row in Excel?
A. Click the row number
B. Press Ctrl + A
C. Press Shift + R
D. Press Ctrl + Shift + R
Answer: A. Click the row number
Explanation: Clicking the row number on the left side of the worksheet selects the entire row.
Question 38
What function would you use to find the most frequently occurring value in a dataset?
A. MEDIAN
B. MODE
C. AVERAGE
D. MIN
Answer: B. MODE
Explanation: The MODE function returns the value that appears most frequently in a dataset.
Question 39
Which of the following is the shortcut to insert the current time in Excel?
A. Ctrl + Shift + ;
B. Ctrl + ;
C. Ctrl + T
D. Ctrl + Shift + T
Answer: A. Ctrl + Shift + ;
Explanation: Ctrl + Shift + ; inserts the current time in the active cell.
Question 40
What is the purpose of the RANK function?
A. To sort a range of values in ascending order
B. To return the rank of a number within a list of numbers
C. To find the highest value in a range
D. To calculate the sum of a list of numbers
Answer: B. To return the rank of a number within a list of numbers
Explanation: The RANK function returns the position of a value within a list of numbers based on its size relative to the other numbers.
