-
web.groovymark@gmail.com
- December 8, 2024
Question 21
What is the purpose of the TRIM function in Excel?
A. To cut the contents of a cell
B. To remove all spaces from text
C. To remove extra spaces from text except for single spaces between words
D. To format text to uppercase
Answer: C. To remove extra spaces from text except for single spaces between words
Explanation: The TRIM function removes any extra spaces in text, leaving only single spaces between words.
Question 22
How can you quickly duplicate a worksheet in Excel?
A. Right-click the sheet tab and select “Duplicate”
B. Press Ctrl + C and then Ctrl + V
C. Press Alt + D
D. Hold Ctrl and drag the sheet tab
Answer: D. Hold Ctrl and drag the sheet tab
Explanation: Holding the Ctrl key and dragging the sheet tab will create a duplicate of the worksheet.
Question 23
Which of the following formulas returns the current date and time?
A. NOW()
B. TODAY()
C. DATE()
D. TIME()
Answer: A. NOW()
Explanation: The NOW() function returns the current date and time.
Question 24
How do you open the “Find and Replace” feature in Excel?
A. Ctrl + F
B. Ctrl + H
C. Ctrl + Shift + F
D. Alt + F
Answer: B. Ctrl + H
Explanation: Ctrl + H opens the Find and Replace dialog in Excel.
Question 25
What is the shortcut for hiding a row in Excel?
A. Ctrl + Shift + 9
B. Ctrl + 9
C. Alt + 9
D. Ctrl + Shift + H
Answer: B. Ctrl + 9
Explanation: Pressing Ctrl + 9 hides the currently selected row.
Question 26
Which of the following functions would you use to find the smallest number in a range?
A. MIN
B. MAX
C. SMALL
D. RANK
Answer: A. MIN
Explanation: The MIN function returns the smallest number in a specified range of cells.
Question 27
What does the LEN function do in Excel?
A. Returns the length of text in characters
B. Counts the number of words in a cell
C. Measures the size of a worksheet
D. Calculates a sum based on text
Answer: A. Returns the length of text in characters
Explanation: LEN returns the number of characters in a text string.
Question 28
What is the shortcut to open a new workbook in Excel?
A. Ctrl + O
B. Ctrl + W
C. Ctrl + N
D. Alt + N
Answer: C. Ctrl + N
Explanation: Ctrl + N opens a new workbook in Excel.
Question 29
Which of the following Excel features allows you to perform what-if analysis?
A. Data Validation
B. Conditional Formatting
C. Scenario Manager
D. Data Filter
Answer: C. Scenario Manager
Explanation: Scenario Manager allows you to perform what-if analysis by comparing different sets of input values.
Question 30
What is the default number of sheets in a new Excel workbook?
A. 1
B. 2
C. 3
D. 5
Answer: A. 1
Explanation: In recent versions of Excel, a new workbook opens with a default of 1 sheet.
Question 31
How do you insert a new row in Excel?
A. Ctrl + Shift + + (Plus)
B. Ctrl + R
C. Alt + R
D. Shift + F10
Answer: A. Ctrl + Shift + + (Plus)
Explanation: This shortcut inserts a new row in Excel above the currently selected row.
Question 32
What does the IF function do in Excel?
A. Multiplies two numbers
B. Adds up a range of numbers
C. Returns one value if a condition is true and another if false
D. Divides two numbers
Answer: C. Returns one value if a condition is true and another if false
Explanation: The IF function allows you to test a condition and return different results based on whether the condition is true or false.
Question 33
How do you clear all the formatting in a cell?
A. Use the “Clear All” option
B. Use the “Format Painter”
C. Right-click and select “Remove Formatting”
D. Press Alt + R
Answer: A. Use the “Clear All” option
Explanation: The “Clear All” option removes all formatting, contents, and comments from a cell.
Question 34
What is the purpose of the CONCATENATE function in Excel?
A. To add two cells together
B. To combine text from multiple cells into one
C. To apply conditional formatting to text
D. To count characters in a cell
Answer: B. To combine text from multiple cells into one
Explanation: CONCATENATE joins two or more text strings into one.
Question 35
What does Ctrl + D do in Excel?
A. Deletes the selected cell
B. Duplicates the worksheet
C. Fills the cell below with the content of the current cell
D. Opens the Developer tab
Answer: C. Fills the cell below with the content of the current cell
Explanation: Ctrl + D copies the content of the active cell to the cell below.
Question 36
Which of the following functions returns the highest value in a range?
A. SUM
B. MAX
C. MIN
D. COUNT
Answer: B. MAX
Explanation: The MAX function returns the largest number in a specified range of cells.
Question 37
What does the ISBLANK function do in Excel?
A. Checks if a cell is empty
B. Checks if a cell contains a number
C. Checks if a cell contains text
D. Checks if a cell contains an error
Answer: A. Checks if a cell is empty
Explanation: ISBLANK returns TRUE if the cell is empty and FALSE otherwise.
Question 38
How do you copy the contents of a cell to the clipboard in Excel?
A. Press Ctrl + C
B. Press Ctrl + V
C. Press Ctrl + Shift + C
D. Press Alt + C
Answer: A. Press Ctrl + C
Explanation: Ctrl + C copies the contents of the selected cell to the clipboard.
Question 39
Which of the following features enables you to view two parts of a worksheet at once?
Freeze Panes
B. Split
C. Merge
D. Group
Answer: B. Split
Explanation: The Split feature divides the worksheet window into separate panes so you can view multiple parts simultaneously
Question 40
What is the shortcut for opening the Print dialog in Excel?
A. Ctrl + P
B. Ctrl + O
C. Ctrl + Shift + P
D. Alt + P
Answer: A. Ctrl + P
Explanation: Ctrl + P opens the Print dialog for printing the worksheet.
