Page 13 - Excel 2013 All-in-One For Dummies

Table of Contents xi
Statistical Functions....................................................................................399 AVERAGE, MAX, and MIN.................................................................. 400 Counting cells.....................................................................................401 Using specialized statistical functions............................................407
Chapter 6: Lookup, Information, and Text Formulas . . . . . . . . . . . . . .409
Lookup and Reference ................................................................................ 409 Looking up a single value with VLOOKUP and HLOOKUP............ 410 Performing a two-way lookup........................................................... 413 Reference functions...........................................................................417
Information, Please . . ................................................................................. 420 Getting specific information about a cell ........................................ 420 Are you my type? ............................................................................... 423 Using the IS functions........................................................................ 423
Much Ado about Text ................................................................................. 424 Using text functions........................................................................... 425 Concatenating text............................................................................. 428
Book IV: Worksheet Collaboration and Review ............ 431
Chapter 1: Protecting Workbooks and Worksheet Data . . . . . . . . . . .433
Password-Protecting the File ..................................................................... 433 Protecting the workbook when saving the file............................... 434 Assigning a password to open from the Info screen.....................436 Entering the password to gain access............................................. 437 Entering the password to make changes........................................438 Changing or deleting a password .................................................... 439
Protecting the Spreadsheet........................................................................ 440 Changing the Locked and Hidden cell formatting ......................... 441 Protecting the worksheet ................................................................. 442 Enabling cell range editing by certain users .................................. 445 Doing data entry in the unlocked cells of a protected worksheet ... 450 Protecting the workbook .................................................................. 452 Protecting a shared workbook.........................................................453
Chapter 2: Using Hyperlinks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .455
Hyperlinks 101 ............................................................................................. 455 Adding hyperlinks.............................................................................. 456 Follow that link!..................................................................................459 Editing hyperlinks..............................................................................460
Using the HYPERLINK Function.................................................................461