Page 367 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 350
350 Excel Workbook For Dummies
ROUNDUP function scientific number format, 28
building formulas with the, 125–126 ScreenTip, 276
as a rounding function, 125 scrolling, 12–13
row headings search options within Find and Replace, 66
freezing, 312 searching for workbook files, 51–53
turning on, 43 secondary sort key, 207–208
Row Height dialog box, 25 Select Data Source dialog box, 272
row_index_num argument, 142 selecting
rows adjacent worksheets, 69
deleting/inserting, 60 a cell range, 14–15
hiding, 34–35 a cell range for editing, 56–57
modifying height of using AutoFit, 25–26 cells, 13
overriding default height, 23 a worksheet, 14
redisplaying hidden, 34 series formulas, 172
resizing height of, 25 Shareware programs, 326. See also installing CD
resizing overview, 23 files
selecting, 15 Shift key
dragging a cell selection with the, 63
horizontal/vertical scroll bar and the, 12–13
• S • selecting cells/cell ranges with the, 15
shortcut keys
salvage for depreciation calculation, 121 data entry, 317
Save As dialog box editing, 321
creating a new folder in the, 51 formatting, 319
opening with F12, 25 miscellaneous, 323
for saving spreadsheet as a static web page, single-variable data table, 233–235
262–263 SLN function (straight-line)
saving a spreadsheet with the, 20 arguments of the, 119
saving templates with the, 309 building formulas with the, 121–123
Save command, 20 as a depreciation function, 121
Save Options dialog box, 222 software. See also installing CD files
Save Preview Picture check box, 50 requirements for using this book, 2
Save Scenario dialog box, 243 trial/demo/evaluation versions of, 326
saving Solver
Ctrl+S for, 25 Add Constraint dialog box and, 243
a custom function as an Excel add-in, 303–305 complex problems and, 241–243
memory by using array formulas, 313–314 modifying multiple input values in a spread-
recalculation mode, 87 sheet with, 242–243
scenarios, 243 parameters used in, 242
a spreadsheet as a static Web page, 262–263 Scenario Manager and, 242
a spreadsheet in a Workbook File, 20–21 Solver Parameters dialog box, 242
from the Standard toolbar, 25 Solver Results dialog box, 243
templates with the Save As dialog box, 309 Sort dialog box, 208
scanned image, 193 Sort Options dialog box, 210
Scenario Manager dialog box, 238–239 sorting
Scenario Manager (Solver), 242 the fields (columns) in a data list, 209–211
Scenario Values dialog box, 238 keys, 207–208
scenarios lists, 207–211
command, 238–240 records in a data list, 208–209
constructing for a spreadsheet, 238–240 the records in a data list on more than three
overview, 238 keys, 209
saving, 243 text entries, 163