Page 19 of 20PREVNEXT

Audio course: So that's how! Working with really big worksheets

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


Which key do you press to group two or more nonadjacent worksheets?

CTRL.

SHIFT.

ALT.

You saw in the practice how to filter data to see only sales above a certain amount. You clicked the AutoFilter arrow, and then clicked _____ in the list.

Sort Descending

Top 10

Custom

If you'll often print just a particular part of one worksheet, you should select the cells, click Print, and then, under Print what, click Selection.

True.

False.

To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.

True.

False.

Page 19 of 20PREVNEXT