Which step is not part of planning a worksheet design?
answer
d. Enter labels, values, and formulas.
question
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?
answer
c. Values & Source Formatting
question
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
answer
d. B4^2
question
How can you display formulas within the cells instead of the cell results?
answer
b. Press Ctrl+`.
question
What is a fast way to apply several formats at one time?
answer
b. Apply a cell style.
question
6. Which of the following is not an alignment option?
answer
c. Fill Color
question
7. Which of the following characteristics is not applicable to the Accounting Number Format?
answer
a. Dollar sign immediately on the left side of the value
question
8. 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?
answer
c. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
question
9. Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?
answer
b. Increase the left and right margins.
question
10. What should you do if you see pound signs (###) instead of values or results of formulas?
answer
d. Increase the column width.
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
