Question

1. Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

Select one:

a. data bars

b. color scales

c. icon sets

d. Highlight Cells Rules

2. Elise is preparing to print a worksheet that displays the worksheet name centered at the bottom of every page. She also wants to display the current date next to the worksheet name. Which of the following should she do?

Select one:

a. Add a header to display the date.

b. Add the date to a worksheet cell.

c. Edit the footer to add the date.

d. Add a document property showing the current date.

Answer 1

1.Answer D.

Highlight cells rules are usually used for showing small graphics in cells.

Cells are microscopic structures so their properties will be very small.so its better to do highlight in cell structure itself.

others are betterused to highlight some more big data.

2.answer C Edit the footer to add the date.

Because its already mentioned in the question the worksheet name in the bottom of every page. So to add date next to that she should edit footer note.

A.Header will be appearing above the page.

B.Work sheet cell contains content middle.

D.Its specifically said the date should be next to work sheet name.