-
web.groovymark@gmail.com
- December 8, 2024
Question 21
What is the purpose of the HLOOKUP function in Excel?
A. Looks up values in columns
B. Looks up values in rows
C. Filters data by criteria
D. Replaces text in a cell
Answer: B. Looks up values in rows
Explanation: HLOOKUP searches for a value in the first row of a table and returns a value in the same column from another row.
Question 22
Which of the following is a valid Excel formula?
A. =SUM(A1, B2, C3)
B. =SUM(A1; B2; C3)
C. SUM(A1 + B2 + C3)
D. SUM = (A1, B2, C3)
Answer: A. =SUM(A1, B2, C3)
Explanation: Excel uses commas to separate arguments in a function.
Question 23
Which of the following tools helps visualize data in Excel?
A. PivotTable
B. PivotChart
C. Goal Seek
D. Freeze Panes
Answer: B. PivotChart
Explanation: PivotCharts are visual representations of the summarized data in PivotTables.
Question 24
How do you group rows or columns in Excel?
A. Use the Data tab and select “Group”
B. Use the View tab and select “Group Rows”
C. Right-click and select “Group Columns”
D. Press Ctrl + G
Answer: A. Use the Data tab and select "Group"
Explanation: The Group option in the Data tab allows you to group rows or columns.
Question 25
What is the purpose of the TEXT function in Excel?
A. Converts numbers to text in a specific format
B. Converts text to numbers
C. Removes spaces from text
D. Splits text into different columns
Answer: A. Converts numbers to text in a specific format
Explanation: The TEXT function formats numbers as text according to a specified format.
Question 26
Which of the following is the shortcut to insert the current date in Excel?
A. Ctrl + D
B. Ctrl + Shift + ; (semicolon)
C. Ctrl + ; (semicolon)
D. Alt + D
Answer: C. Ctrl + ; (semicolon)
Explanation: Pressing Ctrl + ; inserts the current date into the selected cell.
Question 27
What is the purpose of the FIND function in Excel?
A. Searches for a text string within another text string
B. Returns the first numeric value in a range
C. Calculates the sum of all numbers
D. Filters rows based on criteria
Answer: A. Searches for a text string within another text string
Explanation: FIND locates the position of a substring within another text string.
Question 28
How do you remove gridlines from a worksheet in Excel?
A. Use the View tab and uncheck the “Gridlines” box
B. Use the Home tab and uncheck “Show Gridlines”
C. Press Ctrl + Shift + G
D. Use the Insert tab and select “Remove Gridlines”
Answer: A. Use the View tab and uncheck the "Gridlines" box
Explanation: The View tab contains the option to show or hide gridlines in a worksheet.
Question 29
What does the MATCH function do in Excel?
A. Finds the relative position of a value in a range
B. Returns the sum of a range
C. Joins multiple text values
D. Divides a range by a number
Answer: A. Finds the relative position of a value in a range
Explanation: MATCH returns the position of a specific value in a range of cells.
Question 30
How do you create a named range in Excel?
A. Use the Formula tab and select “Define Name”
B. Right-click and select “Name Range”
C. Use the Data tab and select “Create Range”
D. Use the Home tab and select “Format Range”
Answer: A. Use the Formula tab and select "Define Name"
Explanation: The Define Name option in the Formula tab allows you to create named ranges
Question 31
What is the shortcut for switching between worksheets in Excel?
A. Ctrl + Tab
B. Alt + Tab
C. Ctrl + Page Up/Page Down
D. Shift + F11
Answer: C. Ctrl + Page Up/Page Down
Explanation: Ctrl + Page Up/Page Down allows you to navigate between different worksheets in a workbook.
Question 32
What does the LEFT function do in Excel?
A. Trims spaces from text
B. Extracts a substring from the beginning of a text string
C. Finds text in a cell
D. Joins text from two cells
Answer: B. Extracts a substring from the beginning of a text string
Explanation: LEFT returns a specified number of characters from the beginning of a text string.
Question 33
What is the purpose of the OFFSET function in Excel?
A. Returns a reference to a range offset from a given reference
B. Counts cells with numbers
C. Sums a range of cells
D. Filters data based on a condition
Answer: A. Returns a reference to a range offset from a given reference
Explanation: OFFSET returns a reference to a cell or range of cells that is a specific number of rows and columns from a given reference.
Question 34
How do you create a drop-down list in Excel?
A. Use Data Validation and select “List”
B. Use the Home tab and select “Create List”
C. Use the Insert tab and select “Drop-down”
D. Press Ctrl + Shift + D
Answer: A. Use Data Validation and select “List”
Explanation: You can create a drop-down list in Excel using Data Validation and selecting the “List” option.
Question 35
What is the purpose of the SUBSTITUTE function in Excel?
A. Replaces text in a string with another text
B. Joins text strings together
C. Converts text to uppercase
D. Sorts text in alphabetical order
Answer: A. Replaces text in a string with another text
Explanation: SUBSTITUTE replaces occurrences of specified text within a text string.
Question 36
What does the MID function do in Excel?
A. Extracts a substring from the middle of a text string
B. Returns the midpoint of a range
C. Finds a text string in a cell
D. Divides a text string into two parts
Answer: A. Extracts a substring from the middle of a text string
Explanation: MID returns a specified number of characters from a text string, starting from a given position.
Question 37
What is the correct formula to calculate the square root of a number in Excel?
A. =SQRT(number)
B. =SQR(number)
C. =ROOT(number)
D. =POWER(number, 0.5)
Answer: A. =SQRT(number)
Explanation: The SQRT function returns the square root of a given number.
Question 38
How do you remove all formulas from a worksheet while keeping the results?
A. Copy and paste values only
B. Use the “Clear All” feature
C. Use the Data tab and select “Remove Formulas”
D. Press Alt + F11
Answer: A. Copy and paste values only
Explanation: Copying the cells and pasting them as values replaces formulas with their results.
Question 39
Which of the following is the correct function to return the remainder of a division in Excel?
A. MOD
B. DIV
C. QUOTIENT
D. REMAINDER
Answer: A. MOD
Explanation: MOD returns the remainder of a division between two numbers.
Question 40
What is the purpose of the INDIRECT function in Excel?
A. Returns the reference specified by a text string
B. Directs to a specific cell reference
C. Joins text from two different cells
D. Filters data based on criteria
Answer: A. Returns the reference specified by a text string
Explanation: INDIRECT converts a text string into a valid cell reference.
