INDEX

A-B

access to spreadsheets, rescinding 68

Add Sheet button 64

adding sheets to spreadsheet 64

adjusting

column width 33

row height 33

aligning cell data 36–37

AVERAGE function 45

background color, changing 38–39

C

calculating arithmetic mean, AVERAGE function 46

cells. See also columns; rows

background colors, changing 38–39

data, aligning 36–37

ranges 28

multicolumn sorts 30

selecting 28

sorting 30

chatting with spreadsheet viewers 68

Clear Format button 35

collaborating on spreadsheets 67–68

collaborative editing 11

colors

background colors, changing 38–39

of text, changing 35

columns

deleting 31

resizing 33

selecting 32

comparing to Excel 6–8

compatibility between Google Spreadsheets and Excel 12

copies of spreadsheets, saving 23

copying data 32–33

COUNT function 45

creating new spreadsheets 21

CSV files, importing 22

cutting and pasting data 31–32

D

data

aligning in cells 36–37

copying 32–33

cutting and pasting 31–32

deleting 31

editing 27

entering 26–27

formulas

creating with mouse 42

editing 39,42

entering 41

functions 43–63

ranges 28

multicolumn sorts 30

selecting 28

sorting 30

sorting 29

types of 26

data loss 5

defining data 26

deleting

data 31

sheets from spreadsheet 64

spreadsheets 25–26

E

editing

data 27

formulas 39,42

spreadsheets, collaboration 67–68

entering

data 26–27

formulas 41

functions 43–44

Excel

comparing Google Spreadsheets to 6–8

migrating from 12

spreadsheets, importing 22

exporting spreadsheets to Excel format 24–25

F-G

features 5

comparing to Excel 6–8

files

deleting 25–26

importing 22

fonts, changing 35–36

Format tab 14

formatting text 34

number formats 37–38

formulas

accepted operators 40

creating with mouse 42

editing 39,42

elements of 40

entering 27,41

functions 43

AVERAGE 45

COUNT 45

entering 43–44

format 43

MAX 46

MIN 46

PRODUCT 47

SUM 44

table listing 47–63

Formulas tab 16

freezing the header row 20

functions 43

AVERAGE 45

COUNT 45

entering 43–44

MAX 46

MIN 46

PRODUCT 47

SUM 44

format of 43

table listing 47–63

H

header row, freezing 20

height of rows, changing 33

horizontal alignment, adjusting 37

I-J-K

importing Excel spreadsheets 22

inserting rows 30

inviting users for spreadsheet collaboration 66–68

keyboard navigation 19

M

MAX function 46

Microsoft Excel. See Excel

migrating from Excel to Google Spreadsheets 12

MIN function 46

mouse

formulas, creating 42

navigation 19

multicolumn sorts, performing 30

N-O

navigating

with mouse and keyboard 19

workspace elements 13,18–19

Format tab 14

Formulas tab 16

Sort tab 15

number format, changing 37–38

opening spreadsheets 21

operators 40

P-Q

Paste command 32

printing spreadsheets 65

privacy issues 9

PRODUCT function 47

R

ranges 28

background colors, changing 38–39

selecting 28

sorting 30

removing users from viewing list 68

renaming

sheets within spreadsheets 64

spreadsheets 24

rescinding access from viewing or editing 68

resizing columns and rows 33

rows

deleting 31

header row, freezing 20

inserting 30

resizing 33

S

saving spreadsheets 22–23

in Excel format 24–25

versioning 69

security issues 9

selecting

entire columns 32

ranges 28

sharing

collaborative editing 11

spreadsheets

for collaboration 67–68

for viewing 66

sheets, adding to spreadsheets 64

Sort tab 15

sorting data 29

multicolumn sorts 30

spreadsheets

deleting 25–26

printing 65

renaming 24

saving 22–23

sharing 66

sheets

deleting 64

renaming 64

SUM function 44

T

text

aligning 36–37

fonts, changing 35–36

formatting 34

numbers, formatting 37–38

type size, changing 35–36

type sizes, changing 35–36

U-V

Undo button 31

unique features of Google spreadsheets 5

versioning 69

vertical alignment, adjusting 37

viewing chat pane 68

W-X-Y-Z

web-based spreadsheets 8

width of columns, changing 33

workspace navigation 13,18–19

Format tab 14

Formulas tab 16

Sort tab 15

XLS files, importing 22