-
web.groovymark@gmail.com
- December 8, 2024
Question 41
What is the shortcut to open the Format Cells dialog box?
A. Ctrl + 1
B. Ctrl + Shift + F
C. Ctrl + F3
D. Ctrl + F5
Answer: A. Ctrl + 1
Explanation: Ctrl + 1 opens the Format Cells dialog box, allowing you to format cell contents.
Question 42
How can you create a chart from a selected range of cells in Excel?
A. Press F12
B. Press F4
C. Press F11
D. Press F5
Answer: C. Press F11
Explanation: Pressing F11 creates a default chart from the selected range of data in a new worksheet.
Question 43
Which of the following tools checks for errors in a worksheet’s formulas?
A. Trace Precedents
B. Evaluate Formula
C. Show Formulas
D. Formula Auditing
Answer: B. Evaluate Formula
Explanation: The Evaluate Formula tool allows you to step through and analyze formulas to check for errors.
Question 44
What does the TRIM function do in Excel?
A. Removes duplicate values
B. Removes extra spaces from text
C. Rounds numbers to the nearest integer
D. Shortens text to a specific number of characters
Answer: B. Removes extra spaces from text
Explanation: The TRIM function eliminates any leading, trailing, or extra spaces in text.
Question 45
How do you remove gridlines from a worksheet in Excel?
A. Go to the Insert tab and uncheck Gridlines
B. Go to the Page Layout tab and uncheck Gridlines
C. Right-click the worksheet and choose Remove Gridlines
D. Use the View tab to hide the gridlines
Answer: B. Go to the Page Layout tab and uncheck Gridlines
Explanation: You can remove or hide gridlines by going to the Page Layout tab and unchecking the Gridlines option.
Question 46
What feature allows you to identify cells that influence the value of a selected cell?
A. Data Validation
B. Trace Precedents
C. Formula Auditing
D. Conditional Formatting
Answer: B. Trace Precedents
Explanation: Trace Precedents shows the cells that are referenced in the selected cell's formula.
Question 47
What is the shortcut to hide selected rows in Excel?
A. Ctrl + 9
B. Ctrl + 8
C. Ctrl + Shift + 9
D. Ctrl + Alt + 9
Answer: A. Ctrl + 9
Explanation: Ctrl + 9 hides the selected rows in the worksheet.
Question 48
How can you display the contents of a long text entry on multiple lines in a single cell?
A. Use the CONCATENATE function
B. Apply the Wrap Text option
C. Use the Text to Columns tool
D. Adjust the row height manually
Answer: B. Apply the Wrap Text option
Explanation: The Wrap Text option automatically adjusts the cell content to display on multiple lines within a single cell.
Question 49
Which of the following is NOT a function in Excel?
A. HLOOKUP
B. MATCH
C. LOOKUP
D. SEARCHVALUE
Answer: D. SEARCHVALUE
Explanation: SEARCHVALUE is not a function in Excel, while HLOOKUP, MATCH, and LOOKUP are valid functions.
Question 50
Which of the following will you use to generate a random number in Excel?
A. =RAND()
B. =RANDOM()
C. =RND()
D. =GENRAND()
Answer: A. =RAND()
Explanation: The RAND function generates a random number between 0 and 1.
