user input, validating. See validation rules
user interface. See also ribbon
color scheme, changing, 18
common to Office programs, 3
customizing, 241
elements, navigating, 48
user interface objects in text, xx
user name
AutoText for, changing, 190
common to Office programs, 3
entering, 10
setting, 19
V
validating e-mail addresses
address book search order, customizing, 602
keyboard shortcut for, 599
validation circles
displaying, 362, 366
hiding, 363, 366
validation rules
creating, 361
entry messages with, 363-364
error messages with, 363-364
and existing data, 362
minimum and maximum, specifying, 364
overview of, 361
requiring numeric values, 362
setting for multiple cells, 362
turning off, 363
validation circles, 362-363, 366
violations, displaying, 362, 366
whole numbers, specifying, 364
value axes in charts, 463
values. See also numbers
adding together, 286
average, viewing with AutoCalculate, 355, 359
comparing , 334-337
count, viewing with AutoCalculate, 355, 359
filtering for highest or lowest, 349, 353
finding, 854
ignoring in calculations, 357
maximum and minimum, 281, 287
monitoring, 303, 304
replacing, 264
searching for, 264
searching in, 266
sum of, 286
testing, 332-338
total, viewing with AutoCalculate, 355, 359
unique, displaying, 358-359
VBA macros, 758, 759
vertical scroll bar, 47
video notes (OneNote)
appearance of, 586
manipulating video in, 585
pausing, 589
playing, 588
recording, 585, 588
rewinding, 588
searchability, activating, 585
View arrow, 761
View button, 771, 812
View Multiple Sheets button (Publisher), 894
View Ruler button (Word), 120
View Shortcuts toolbar, 9, 52, 752, 761
View Sync Status button (OneNote), 549
View tab (Excel), 242
View tab (OneNote), 521
View tab (Word), 14, 52
viewing color schemes, 426
viewing workbook properties, 229
views
advanced settings for, 661
column width, changing, 665
customizing, 661, 664
resetting, 665
switching, 761, 765, 771
views, Normal
creating slide sections in, 384
in PowerPoint, 53
views, Notes Page, 53, 494
views, Reading, 53, 482, 490
views, Slide Sorter, 53, 482
creating sections in, 382
rearranging slides in, 385
views, Web Layout, 52
visible cells, summarizing, 355, 357
volatile functions, 354
Vote button, 637
voting buttons, 637W
watch
deleting, 303, 307
setting, 303-304
Watch Window
defined, 303
deleting a watch, 303, 307
setting a watch, 303, 304
watermarks as background images, 341
Web App (OneNote), 5931028 user input, validating