Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101
Home > Jan's CompLit 101 > Working with Numbers > Format > Summary
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Format: Summary

In Excel Project 3, you learned how to format cells and text and how to move, insert, copy, and link data.

Cells can be formatted by adding background fill color or pictures, changing text formats, aligning cell contents both horizontally and vertically, wrapping text, and merging cells. A table style applies formatting to a whole range at once and adds to each column a menu of commands for sorting and filtering the table.

A cell style applies to the whole cell and can include any kind of formatting for the text and the cell background and border.

Data can be moved, inserted, and copied with several methods. When inserting, the existing data can be moved only to the right or down.

Linking cells by typing the references or with Paste Link keeps copies of data updated with the latest information.

Every aspect of a chart can be changed after it is created.

Printing choices include the entire workbook, the active sheet(s), a selection, specific page(s). Showing formulas, with the key combo CTRL + `, instead of values can help you see where things went wrong.

Additional Information in the Appendix:

Table Error Values

Table Formatting:
    Comparing Word and Excel

Table How to Enter/Edit/Clear data

Table Pre-Print checklist

Table  Selecting parts of a spreadsheet

Table  Shortcut keys for Excel

Table  Working with Columns

Table  Working with Rows

What You Printed for Excel Project 3:

       File and sheet What is it? Which lesson? # of pages
1.

trips12-Lastname-Firstname.xlsx

Print selection.

 Modify Table 1 page
2.

trips12-clearformats-Lastname-Firstname.xlsx

Removed all formats except 'Special'.

 Modify Table 1 page
3. trips14-Lastname-Firstname.xlsx -
Pie Chart

Number of people pie chart

 Pie Chart 1 page
4. trips15-Lastname-Firstname.xlsx -
Tickets Sold Chart 		Columns chart with background Column Chart 1 page
5. trips15-Lastname-Firstname.xlsx -
Tickets Sold Chart 		Columns chart with one column formatted with pattern Column Chart 1 page
6. trips16-Lastname-Firstname.xlsx -
Specials		 Specials sheet Move 1 page
7. trips19-Lastname-Firstname.xlsx -
Sheet Tahiti-linked		 Sheet cells linked to Specials Link 1 page
8. trips19-Lastname-Firstname.xlsx -
Sheet Tahiti-linked - Formulas		 All on one sheet. Landscape orientation. Showing formulas Link 1 page
9.

trips20-Lastname-Firstname.xlsx

Print Entire Workbook.

 Group 7 pages

Skills Covered - by lesson

Apply Formatting

  • Edit an existing header in Page Layout View
  • Apply text formatting with dialog
  • Apply text formatting with ribbon
  • Merge cells and center cells 
  • Unmerge cell

Copy Formatting

  • Copy formatting with Format Painter
  • Copy formatting with AutoFill
  • Copy formatting with Paste Special  
  • Resize columns 
  • Format only part of a cell's contents
  • Apply a theme

Table Styles

  • Format with table style
  • Clear all formatting
  • Change theme

Modify Table

  • Change a table's size
  • Change table style options
  • Sort and filter with table columns
  • Filter with existing values
  • Filter with a logical test
  • Print a selection of a sheet 
  • Convert a table back to a range
  • Clear all formatting

Cell Styles

  • Open an existing workbook
  • Create a cell style 
  • Apply a cell style
  • Check what style a cell has  
  • Modify a cell style
  • Merge cell styles from another workbook
  • Wrap text

Format Pie Chart

  • Format chart title
  • Explode a pie chart
  • Explode one wedge of a pie chart
  • Format data points

Format Column Chart

  • Change chart type
  • Format chart area with background texture
  • Remove chart part
  • Edit chart title
  • Icon: Excel 2013 Icon: Excel 2016 Excel 2013, 2016: Format plot area
  • Add and edit Axis Titles
  • Edit Sheet tab
  • Icon: Excel 2010 Icon: Excel 2013 Icon: Excel 2016 Excel 2010, 2013, 2016: Format a column

Move

  • Move by dragging to empty cells
  • Move by cut and paste
  • Move cells to non-empty cells
  • Move with right drag
  • Move with menu commands
  • Move a sheet

Insert

  • Insert a column
  • Insert a row
  • Insert a cell
  • Fix formatting issues
  • Delete cells
  • Insert a sheet
  • Reorder sheet tabs

Copy

  • Copy by dragging range
  • Can not drag non-adjacent ranges
  • Copy by pasting on the same sheet
  • Copy by pasting to a different sheet
  • Use Paste Special for Column Widths and All
  • Icon: Excel 2010 Icon: Excel 2013 Icon: Excel 2016 Excel 2010, 2013, 2016: Use Paste icons
  • Fix formulas

Link

  • Create a link by typing the cell reference
  • Create a link by clicking the cell
  • Insert new sheet from ribbon
  • Use Paste Link
  • Use Format Painter to format linked cells
  • Correct formatting and formula errors and remove unneeded zeros
  • Print the sheet showing the links (formulas)

Group

  • Group sheets
  • Ungroup sheets
  • Copy to grouped sheets
  • Print the entire workbook

 

Skills in Exercises

Excel 3-1 Theater Tickets

  • Apply table style
  • Adjust formatting
  • Insert rows
  • Create totals and subtotals
  • Repair formulas

 

Excel 3-2 Soccer Budget

  • Move cells
  • Insert columns
  • Repair formulas
  • Format cells directly
  • Format with cell styles
  • Create totals
  • Rename sheet
  • Create a chart
  • Print whole workbook
  • Print formulas

Excel 3-3 Amazon Pings

  • Paste Link data
  • Format numbers - ribbon or Format Cells dialog
  • Apply a table style and convert back to range
  • Create and apply cell styles
  • Create a line chart
  • Format the chart
  • Rename sheets
  • Scale to fit one sheet
  • Change the theme

Important Terms

#####

#REF!

axes

cell style

chart area

chart tips

chart title

chart type

circular reference

Clear

clear formats

column chart

copy

data labels

data point

data series

data table

Edit mode

explode (pie chart)

filter

Format Cells…

Format Painter

group (sheets)

insert

legend

link

Merge

move

Paste Link

Paste Special

pie chart

Plot area

Print formulas

shift data

sort

table

table style

theme

ungroup

Unmerge