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