MCQ Questions
Q.1.
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?
  • 0%
    c. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
  • 100%
    c. Values & Source Formatting
  • 0%
    d. Increase the column width.
  • 0%
    b. Increase the left and right margins.
Q.2.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
  • 0%
    d. B4^2
  • 0%
    b. Press Ctrl+`.
  • 0%
    d. Enter labels, values, and formulas.
  • 0%
    c. Fill Color
Q.3.
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?
  • 0%
    a. Dollar sign immediately on the left side of the value
  • 0%
    b. Increase the left and right margins.
  • 0%
    c. Values & Source Formatting
  • 0%
    c. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
Q.4.
Which of the following characteristics is not applicable to the Accounting Number Format?
  • 0%
    c. Fill Color
  • 0%
    a. Dollar sign immediately on the left side of the value
  • 0%
    d. Enter labels, values, and formulas.
  • 0%
    d. Increase the column width.
Q.5.
What is a fast way to apply several formats at one time?
  • 0%
    b. Apply a cell style.
  • 0%
    c. Fill Color
  • 0%
    b. Press Ctrl+`.
  • 0%
    d. Enter labels, values, and formulas.
Q.6.
Which step is not part of planning a worksheet design?
  • 0%
    d. Increase the column width.
  • 0%
    b. Apply a cell style.
  • 0%
    d. Enter labels, values, and formulas.
  • 0%
    a. Dollar sign immediately on the left side of the value
Q.7.
Which of the following is not an alignment option?
  • 0%
    b. Press Ctrl+`.
  • 0%
    b. Apply a cell style.
  • 0%
    a. Dollar sign immediately on the left side of the value
  • 0%
    c. Fill Color