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

Index 757
Formula bar, 16, 27–28, 133–134, 193, 301
formulas. See also range names
absolute references, 315–318
array, 318–323
AutoFill feature, using for,
103
AutoSum feature, 302–304 building manually,
300–301
cell ranges in, 126 circular references,
336–338
conditional formatting,
basing on, 180 converting into calculated
values in cell ranges,
216
copying, 206, 312–315 dates in, 90
default settings for, 55 deleting cells with
references, 233 editing, 301–302 general discussion,
299–300
Insert Function button,
using, 309–312 linking, 333–334 mixed cell references,
318–319
numeric, 91–92 operators, building with,
305–309 printing in reports,
294–295
Quick Analysis tool,
304–305
range names, 326–328 recalculation, 334–336
Formulas and Number Formats option, Paste Special dialog box, 214
Formulas Inconsistent with Other Formulas in Region check
box, 356
Formulas option, Paste Special dialog
box, 213 Formulas Referring to
Empty Cells check
box, 356
Formulas section, Excel
Options dialog box,
59–60
Formulas tab, 23, 48–50,
310, 355–356
Formulas Which Omit Cells
in a Region check box,
356
FORMULATEXT function,
417
Freeze Panes feature,
201–204, 237
French mode, 52, 224 Function Arguments dialog
box, 311–312, 739–740 functionality of
spreadsheets, 83 functions. See specific functions by name
FV (Future Value) function, 378–379
G
General alignment option, 157
General number format, 89, 149–150
General Options dialog box, 434–435, 436, 440
General tab, Excel Options dialog box, 45–48, 59–60, 251
Generalized Reduced Gradient (GRG)
Nonlinear method,
662, 665
Get a Digital ID alert dialog
box, 467
Get External Data button,
PowerPivot add-in, 698 GETPIVOTDATA function,
50, 417
Getting Started section,
Excel Help window,
34–35 GlobalSign, 466
Go To feature, 132–133, 324, 351–352
goal seeking, 645, 657–659 gradients, 167
Grand Totals option, 677 graphical conditional
formatting, 174–175 graphics
aligning, 551
assigning to worksheet
background, 250–251 clip art, inserting, 554–556 default settings for, 58 downloading from Web,
556–557
drawing predefined
shapes, 561–562 editing pictures, 558 formatting pictures,
559–560
general discussion, 546 grouping, 551–552
local pictures, inserting,
557–558
macros for, 720 managing in Selection
task pane, 552–554 manipulating, 547–548 moving to new layers,
548–550