OA Exams

  • California, TX 70240
  • Info@gmail.com
  • Office Hours: 8:00 AM – 7:45 PM
  • 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.

Complete the Captcha to view next question set.

Tags

Prev Post
WGU D100 Practice Exam Questions – Set 2 – Part 2
Next Post
WGU D100 Practice Exam Questions – Set 3 – Part 1