Copy and paste data ................................................................. 81
Insert cells ................................................................................ 82
Insert rows ................................................................................ 82
Insert columns ........................................................................... 83
Delete cells, rows, or columns ..................................................... 83
Format Data ............................................................................................ 83
Format numbers and text ............................................................ 83
Adjust column widths and row heights ......................................... 84
Fit rows and columns to data ...................................................... 84
View the data you want ............................................................................ 84
Adjust the view of the worksheet ................................................. 84
Zoom in or out .......................................................................... 85
Hide and display rows or columns ............................................... 85
Go to a cell or region ................................................................ 85
Filter data in a worksheet ........................................................... 85
Sort data in a worksheet ............................................................ 86
Calculate ................................................................................................ 86
Calculate values automatically .................................................... 86
Add values automatically ........................................................... 86
Enter a simple formula ............................................................... 87
Enter a formula that contains a cell reference ................................ 87
Enter a formula that contains a function ........................................ 87
Work with charts ...................................................................................... 88
Overview ................................................................................. 88
Create a chart .......................................................................... 88
Add titles to a chart ................................................................... 89
Add a legend to a chart ............................................................. 89
Change the chart type ............................................................... 89
Change the scale of a chart ........................................................ 89
Delete a chart ........................................................................... 90
Work with worksheets .............................................................................. 90
Insert a worksheet ..................................................................... 90
Delete a worksheet .................................................................... 90
Rename a worksheet .................................................................. 91
Switch to another worksheet ....................................................... 91
Work with PowerPoint Mobile .................................................................................. 91
Overview ................................................................................................ 91
Open and view a slide show presentation ................................................... 91
Change the slide show orientation .............................................................. 91
Set slide show playback options ................................................................. 92
Zoom in and out in a slide ........................................................................ 92
Navigate between slides ........................................................................... 93
OneNote Mobile .................................................................................................... 93
Overview ................................................................................................ 93
vii
