Multiple Choice Questions

You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select?
  • c. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
  • c. Values & Source Formatting
  • d. Increase the column width.
  • b. Increase the left and right margins.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
  • d. B4^2
  • b. Press Ctrl+`.
  • d. Enter labels, values, and formulas.
  • c. Fill Color
You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?
  • a. Dollar sign immediately on the left side of the value
  • b. Increase the left and right margins.
  • c. Values & Source Formatting
  • c. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
Which of the following characteristics is not applicable to the Accounting Number Format?
  • c. Fill Color
  • a. Dollar sign immediately on the left side of the value
  • d. Enter labels, values, and formulas.
  • d. Increase the column width.
What is a fast way to apply several formats at one time?
  • b. Apply a cell style.
  • c. Fill Color
  • b. Press Ctrl+`.
  • d. Enter labels, values, and formulas.
Which step is not part of planning a worksheet design?
  • d. Increase the column width.
  • b. Apply a cell style.
  • d. Enter labels, values, and formulas.
  • a. Dollar sign immediately on the left side of the value
Which of the following is not an alignment option?
  • b. Press Ctrl+`.
  • b. Apply a cell style.
  • a. Dollar sign immediately on the left side of the value
  • c. Fill Color
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0