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
covered in this topic
using the mouse, Ribbon,
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 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