Wiley Excel 2010 Simplified 978-0-470-57763-9 ユーザーズマニュアル

+ (addition operator), 113
, (comma), 29, 93
/ (division operator), 113
= (equal sign) in formulas, 4, 112, 114
= (equal-to operator), 113
^ (exponentiation operator), 113
> (greater-than operator), 113
>= (greater-than or equal-to operator), 113
< (less-than operator), 113
<= (less-than or equal-to operator), 113
* (multiplication operator), 113
- (negation operator), 113
( ) (parentheses, and operator precedence), 113
% (percentage operator), 113
+ (plus sign), 113
- (subtraction operator), 113

absolute cell reference format, 129
Accounting Number format, 93
active or current cell, 26
adding

background color to worksheet, 90–91
blank worksheet to workbook, 134–135
border to worksheet range, 108–109
chart to worksheet, 5, 188–189
column to worksheet, 48–49
command

to Quick Access Toolbar, 12–13
to Ribbon, 15

comment to cell, 212–213
data to cell, 4, 26–27
Excel icon to Windows 7 taskbar, 7
formula to cell, 4, 114–115
function to formula, 4, 118–119
group to existing Ribbon tab, 14–15
range name to formula, 64, 124–125
record to Excel table, 179
row to worksheet, 48–49
special effect to chart element, 206–207
tab to Ribbon, 14–15
text label to chart, 191
title

to chart, 186, 190
to chart axis, 190

worksheet

template to workbook, 135
to workbook, 134–135

addition

AutoSum feature, 122–123
Sum button, 5, 122–123
SUM function, 120–121, 122, 123

addition operator (+), 113
address, cell

absolute reference format, 129
defined, 24
relative reference format, 129

aligning text

within cell, 84–85
centering across columns, 61, 86–87

analysis of data

converting range to table for, 178–179
creating data table for, 180–181
defined, 170
filtering data for, 174–175
rules for data validation, 176–177
sorting data for, 172–173
summarizing data, 182–183

Apply Names feature, 125
applying

conditional formatting, 98–99
font effect, 80–81
formatting by using AutoFormat feature, 96–97
percentage number format, 93
range name by using Apply Names feature, 125
styles, predefined

to chart, 195, 208–209
to worksheet, 100–101

theme to workbook, 79, 168–169

area chart

description, 187
horizontal gridlines for, 193

arithmetic formula, 113
Arrange Windows dialog box, 154–155
array formula, 181
arrow keys, using to navigate worksheet, 132
ASCII code symbol, 33
attachment, e-mail, sending workbook as, 224–225
AutoComplete feature, 27
AutoFill feature

customizing, 45
invoking, 44

AutoFilter feature, 174–175
AutoFit feature, 103, 105
AutoFormat feature, 96–97
automatic subtotals feature, 182
AutosShape, style, applying to chart element, 208–209
AutoSum feature, 122–123
AVERAGE function, 4, 117
axis

category, 186, 193
formatting, 200–203
value, 186

background

adding color to ranges, 90–91
customizing chart element, 202–203

bar chart

description, 187
vertical gridlines for, 193

bevel effect, adding to chart element, 207
blank workbook, creating, 148–149
blank worksheet, adding to workbook, 134–135
body font, 79, 164, 165

16_577639-bindex.indd   232

16_577639-bindex.indd   232

3/15/10   2:49 PM

3/15/10   2:49 PM