Design:
Quiz

Did you want Working with Numbers: 2007,2010,2013,2016 or español

For each question, click on the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.

Choose the BEST answer.

1. A cell that contains a comment has _____.

a. a dark wide border

b. a small red triangle in the upper right corner

c. a small red triangle in the upper left corner

d. a dark square in the lower right corner

2. A logical test can use which of the following operators?
= < > <>

a. = < >

b. < > <>

c. all four

3. In a conditional format you may set any of the following:

a. font, font size, font color

b. font, font size, font color, fill color

c. font, font size, font color, fill color, border

d. font, font style, font size, font color, fill color, border

4. In an IF function, the arguments required are _____.

a. the logical test itself, value if test is true, value if test is false

b. the logical test itself, three possible values

c. the logical test itself, value if test is true, value if test is false, formatting you want to use when the test is true

d. the logical test itself, value if test is true, value if test is false, initial value

5.   According to the Planning Checklist you should test your sheet's calculations using _____.
     a. values that are easy to calculate with
     b. realistic values
     c. extreme values like very small, very large, and zero
     d. realistic values that you know answers for

a, b, c, d

a, c, d

b and c

a and d

6. Which of the following IF functions is correctly written?

a. IF(C4>=D4,C4,"Too small")

b. IF(C4>=D4;C4,Too small)

c. =IF(C4>=D4,C4,"Too small")

d. =IF(C4>=D4;C4;"Too small")

7. To include an Excel sheet table in a Word document that will show the most recent version of the data, use _____ .

a. an embedded object

b. an linked object

c. a picture object

8. A sheet has the following named cells:
B3 is named Current, C3 is named Last Month, D3 is named Average for Year. Which formula below calculates the difference between the current value and last month's value?

a. =Current - Last Month

b. Current - Last Month

c. =B3(Current) - D3(Last Month)

d. =(Current + Last Month) /2

9. The setting for how comments will print is found _____.

a. on the Print tab of the Page Setup dialog

b. on the Sheet tab of the Page Setup dialog

c. on the Tools | Options dialog

d. on the Print dialog

10. The formatting of a comment is restricted to _____.

a. rectangle shape

b. AutoShapes