A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

Which formula is NOT equivalent to all of the others?

Which custom format will make the cells in column A appear like the corresponding cells in column B?

Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?

You're working with columns whose width and font-size should not be changed. Yet the columns are too narrow to display all the text in each cell. What tool should you use to solve the problem?

Of the four chart types listed, which works best for summarizing time-based data?

There is only ONE way to group a pivot table item.

The Remove Duplicates command:

How do you make sure that a MACRO won't automatically run on a spreadsheet you've downloaded?

What do you click on to navigate between worksheets in a workbook?

Double-clicking column separators will do what?