Microsoft Office Tutorials and References
In Depth Information
Chapter Summary
Chapter Summary
In this chapter you have learned how to enter text and numbers to create a worksheet, select a range, use the
Sum button, format cells, insert a chart, and preview and print a worksheet. The items listed below include all
the new Excel skills you have learned in this chapter, with the tasks grouped by activity.
Clear Cells
Clear Cell Entries Using the Fill Handle (EX 52)
Clear Cell Entries Using the Shortcut Menu (EX 52)
Clear Cell Entries Using the Key
(EX 52)
Clear Cell Entries and Formatting Using the Clear
Button (EX 52)
Clear Cell Formatting Using the Cell Styles
Button  (EX 52)
Clear the Entire Worksheet (EX 52)
Display AutoCalculate Functions
Use the AutoCalculate Area to Determine a
Maximum (EX 48)
Enter Data
Enter the Worksheet Titles (EX 7)
Enter Column Titles (EX 9)
Enter Row Titles (EX 11)
Enter Numbers (EX 12)
Enter Functions and Formulas
Sum a Column of Numbers (EX 14)
Copy a Cell to Adjacent Cells in a Row (EX 16)
Determine Multiple Totals at the Same Time (EX 18)
Enter a Formula Using the Keyboard (EX 20)
File Management
Change Document Properties (EX 44)
Format a Worksheet
Change a Cell Style (EX 24)
Change the Font (EX 25)
Bold a Cell (EX 26)
Increase the Font Size of a Cell Entry (EX 27)
Change the Font Color of a Cell Entry (EX 28)
Center Cell Entries across Columns by Merging
Cells (EX 29)
Format Rows Using Cell Styles (EX 30)
Format Numbers in the Worksheet (EX 32)
Adjust the Column Width (EX 34)
Use the Name Box to Select a Cell (EX 35)
Insert a Chart
Add a 3-D Pie Chart (EX 38)
Apply a Style to a Chart (EX 40)
Manage Worksheets
Move a Chart to a New Sheet (EX 41)
Change the Worksheet Tab Name (EX 42)
Preview and Print Worksheets
Preview and Print a Worksheet in Landscape
Orientation (EX 46)
What decisions will you need to make when creating workbooks and charts in the future?
1. Determine the workbook structure.
a) Determine the data you will need for your workbook.
b) Sketch a layout of your data and your chart.
2. Create the worksheet.
a) Enter titles, subtitles, and headings.
b) Enter data, functions, and formulas.
3. Format the worksheet.
a) Format the titles, subtitles, and headings using styles.
b) Format the totals.
c) Format the numbers.
d) Format the text.
4. Create the chart.
a) Determine the type of chart to use.
b) Determine the chart title and data.
c) Format the chart.
 
Search JabSto ::




Custom Search