Enter a value or text in a cell ......................................................

76

Edit a value or text in a cell ........................................................

76

Enter a sequence of values automatically ......................................

76

Copy and paste data .................................................................

77

Insert cells ................................................................................

78

Insert rows ................................................................................

78

Insert columns ...........................................................................

79

Delete cells, rows, or columns .....................................................

79

Format Data ............................................................................................

79

Format numbers and text ............................................................

79

Adjust column widths and row heights .........................................

80

Fit rows and columns to data ......................................................

80

View the data you want ............................................................................

80

Adjust the view of the worksheet .................................................

80

Zoom in or out ..........................................................................

81

Hide and display rows or columns ...............................................

81

Go to a cell or region ................................................................

81

Filter data in a worksheet ...........................................................

81

Sort data in a worksheet ............................................................

82

Calculate ................................................................................................

82

Calculate values automatically ....................................................

82

Add values automatically ...........................................................

82

Enter a simple formula ...............................................................

83

Enter a formula that contains a cell reference ................................

83

Enter a formula that contains a function ........................................

83

Work with charts ......................................................................................

84

Overview .................................................................................

84

Create a chart ..........................................................................

84

Add titles to a chart ...................................................................

85

Add a legend to a chart .............................................................

85

Change the chart type ...............................................................

85

Change the scale of a chart ........................................................

85

Delete a chart ...........................................................................

86

Work with worksheets ..............................................................................

86

Insert a worksheet .....................................................................

86

Delete a worksheet ....................................................................

86

Rename a worksheet ..................................................................

87

Switch to another worksheet .......................................................

87

Work with PowerPoint Mobile ..................................................................................

87

Overview ................................................................................................

87

Open and view a slide show presentation ...................................................

87

Change the slide show orientation ..............................................................

87

Set slide show playback options .................................................................

88

Zoom in and out in a slide ........................................................................

88

vii