Index
printing
background images, 185–186
cell gridlines, 185
charts, 466
column headers, 185
column titles, 183–185
copying page settings, 190
custom views, creating, 192–194
default settings, 173–174
error values, 427
named views, creating, 193–194
Normal view, 174, 175
number of copies, specifying, 181
one-click printing, 173
Page Break Preview view, 175, 176–178
page breaks. See page breaks
Page Layout view, 3–4, 174, 175–176
page margins, adjusting, 181–183
page orientation, changing, 181
page settings, adjusting, 178–180
paper size, specifying, 181
PDF files, creating, 194
preventing cells, 191
preventing objects, 191–192
prev iew ing, 174
row headers, 185
row titles, 183–185
scaling output, 185
specifying what to print, 180–181
watermarks, inserting, 186–187
worksheets, 26–27
XPS files, 194
PRN files, 581
exporting to, 611
profit
break-even, 338–340
EBIT (earnings before interest and taxes), 335–336
EBITA (earnings before interest, taxes, depreciation,
and amortization), 335–336
ROA (return on assets), calculating, 337
ROE (return on equity), calculating, 337–338
Project Properties dialog box, 777–778
PROPER function, 256, 595–596
properties, ActiveX controls
adjusting, 987–988
CheckBox, 991
ComboBox, 992
CommandButton, 992
LinkedCell, 989
ListBox control, 993
OptionButton, 993
ScrollBar, 994
shared, 988–989
SpinButton, 995
TextBox, 995–996
properties (of objects), 938–939
Application object, 939
Range object, 940–941
Protect Sheet command, 770–771
Protect Sheet dialog box, 770, 772
Protect Structure and Windows dialog box, 776
Protect Workbook command, 776
Add a Digital Signature, 780
Encrypt with Password, 774
Mark as Final, 778
Protected View, 156
protecting
VBA Projects, 777–778
workbooks, 59, 774–777
adding digital signatures, 780
inspecting workbooks, 779–780
marking as final, 778
worksheets, 59, 769, 770–774
Publish as PDF or XPS dialog box, 194, 778
pv argument, PMV function, 346
PV function, 354–356Q
qualified object references, 1012
quarter(s), calculating
calendar quarter, 286
fiscal quarter, 287–288
quartiles
QUARTILE function, 377–379
QUARTILE.EXC function, 379–382
queries. See Power Query
Queries & Connections
grouping queries, 904–905
managing queries, 845–846
refreshing data, 844
Quick Access toolbar, 5, 6
custom izi ng, 17–18, 195–197
adding commands, 17, 197–199
rearranging icons, 199
removing icons, 199
resetting to default state, 200
sharing customizations, 200
for specific workbooks, 199