Microsoft Office Tutorials and References

In Depth Information

**Chapter Summary**

4

Click the OK button (Page Setup dialog box) to set the print scaling to normal.

Quick Reference

For a table that lists how

to complete the tasks

covered in this topic

using the mouse, Ribbon,

shortcut menu, and

keyboard, see the Quick

Reference Summary at

the back of this topic, or

visit the Excel 2010 Quick

Reference Web page

(scsite.com/ex2010/qr).

5

Display the Home tab.

What is the purpose of the Adjust to box in the Page Setup dialog box?

The Adjust to box allows you to specify the percentage of reduction or enlargement in the

printout of a worksheet. The default percentage is 100%. When you click the Fit to option,

this percentage automatically changes to the percentage required to i t the printout on

one page.

To Save the Workbook and Quit Excel

With the workbook complete, the following steps save the workbook and quit

Excel.

1

2

Click the Save button on the Quick Access Toolbar.

Click the Close button on the upper-right corner of the title bar.

Chapter Summary

In this chapter you have learned how to enter formulas, calculate an average, i nd the highest and lowest

numbers in a range, verify formulas using Range Finder, added borders, align text, format numbers, change

column widths and row heights, and add conditional formatting to a range of numbers. In addition, you learned

to spell check a worksheet, print a section of a worksheet, and display and print the formulas version of the

worksheet using the Fit to option. The items listed below include all the new Excel skills you have learned in

this chapter.

1. Enter a Formula Using the Keyboard (EX 75)

2. Enter Formulas Using Point Mode (EX 77)

3. Copy Formulas Using the Fill Handle (EX 80)

4. Determine the Average of a Range of Numbers

Using the Keyboard and Mouse (EX 84)

5. Determine the Highest Number in a Range of

Numbers Using the Insert Function Box (EX 86)

6. Determine the Lowest Number in a Range of

Numbers Using the Sum Menu (EX 87)

7. Copy a Range of Cells Across Columns to an

Adjacent Range Using the Fill Handle (EX 89)

8. Verify a Formula Using Range Finder (EX 91)

9. Change the Workbook Theme (EX 94)

10. Change the Background Color and Apply a Box

Border to the Worksheet Title and Subtitle (EX 96)

11. Format Dates and Center Data in Cells (EX 98)

12. Apply an Accounting Number Format and Comma

Style Format Using the Ribbon (EX 100)

13. Apply a Currency Style Format with a Floating

Dollar Sign Using the Format Cells Dialog

Box (EX 102)

14. Apply a Percent Style Format and Use the Increase

Decimal Button (EX 103)

15. Apply Conditional Formatting (EX 104)

16. Change the Widths of Columns (EX 107)

17. Change the Heights of Rows (EX 110)

18. Check Spelling on the Worksheet (EX 112)

19. Change the Worksheetâ€™s Margins, Header, and

Orientation in Page Layout View (EX 114)

20. Print a Section of the Worksheet (EX 118)

21. Display the Formulas in the Worksheet and Fit the

Printout on One Page (EX 119)

If you have a SAM 2010 user proi le, your instructor may have assigned an autogradable

version of this assignment. If so, log into the SAM 2010 Web site at www.cengage.com/sam2010

to download the instruction and start i les.