Chat with us, powered by LiveChat Microcomputer Applications | acewriters
+1(978)310-4246 credencewriters@gmail.com
  

1. In your own words, explain three types of business documents created in Microsoft Excel. Thoroughly explain your examples. Please count your words and do not use citations.Please ensure your word count for the discussion response is at least 250 words, and you provide two scholarly sources. 2. Define the following terms:a. Default Settingsb. Groupc. Navigation Paned. Print Optionse. Tabf. Template3. What can you customize for quicker access to the most commonly used commands?4. Identify and Describe 5 things you can access in the Backstage View.5. Using Microsoft Excel or Excel Online, complete Project 6-1 on page 1746. Explain conditional formatting and describe a real life example of how you could use conditional formatting.7. Using Microsoft Excel or Excel Online, complete Project 6-3 on page 1758. Define the following terms:a. Find commandb. Freezec. Hided. Panee. Replace commandf. Unhideg. Zoom9. Using Microsoft Excel or Excel Online:a. Open 08 Brooks Music Annual Sales from the Course Material section.b. Delete the text Jan in cell C5 and replace with with Aprc. Use AutoFill to change the next two months’ column headings, and then change Qtr 1 to Qtr 2.d. Select cell range C6:E10 and press the Delete key.e. For the months in the second quarter, enter the following values:f. If necessary, adjust the width of each column so the entries are legible.ALL Answers must be cited and referenced in APA format consistent with APA template uploaded. minimum 200 word count on questions that it’s applicable. 5,7,and 9, upload as separate files for each.
https___vcampbethel.blob.core.windows.net_public_courses_gen_2020_unit_4_read.pdf

apa_template_5.6.16.docx

201710221543446916_bus2550_week4_brooks_music_annual_sales.xlsx

201710221544011029_bus2550_week4_fine_art.xlsx

201710221544189651_bus2550_week4_regional_sales.xlsx

Unformatted Attachment Preview

Using
Office Backstage
3
LESSON SKILL MATRIX
Skills
Exam Objective
Objective Number
Set a print area.
1.5.1
Print individual worksheets.
1.5.3
S
M to print.
Configure workbooks
I Access Toolbar.
Customize the Quick
T
Customize
Custtom
omize the
thhe ribbon.
riibb
bbon
o .
H
Create
Cre
reat
atee new
at
new workbooks
workkbooks using
ussing templates.
template
tess.
te
,
1.5.4
Accessing and Using Backstage View
Printing with Backstage
Set print scaling.
Changing the Excel Environment
Accessing and Using Excel Templates
J
O
S
H
U
A
1.5.7
1.4.3
1.4.4
1.4.
4.44
1.1.2
KEY TERMS
• default settings
• group
• navigation pane
• print options
• tab
• template
6
8
9
0
B
U
© matthewennisphotography / iStock photo
61
62
Lesson 3
Contoso, Ltd., employs hundreds of employees. The company rewards its employees with monthly potluck dinners in their departments and between departments.
In the past, there were too many drinks and desserts and not enough main dishes
and salads. Contoso has asked the new assistant office manager to create some
way of organizing the potlucks so the meals are balanced and still fun. In this lesson,
you learn how to create the types of workbooks Contoso uses for this task. You also
learn how to print these workbooks.
© matthewennisphotography / iStock photo
SOFTWARE ORIENTATION
Microsoft Excel 2013 Backstage
S View
The ribbon is a visual interface thatMallows you to work in a file and perform tasks such as
changing fonts, creating charts, and formatting numbers. The Backstage view, on the other
I you to use and master Excel’s file management feahand, is a visual interface that enables
u to T
g to a file rather than in a file. Backstage view’s
tures—functions that allow yyou
do things
left-side navigation
pane
iga
gati
ga
tiion pa
ane (seee Figure
Figu
uree 3-1)
3-11) gives
gi you
u access
acce
ac
cess
ss to
to workbook
work
wo
rkbookk aand file-related comrk
ugh
h a series
seeriies of
of tabs,
tabbs, in
ta
ncllH
udin
ng Info, New
w, Ope
peen, Sav
ve, Sav
ave A
av
mands through
including
New,
Open,
Save,
Save
As, Print, Share, Export, Close, Account,
Acccou
unt, and
and Options.
Optioonss,. Some
Som
me of the tabs
tabbs give
giive
v you additional
add
dition tabs. Other tabs
ct from m
any di
iffferentt op
opti
tion
ti
onss orr set
on
etti
et
ting
ti
nggs.
s Final
llyy, som
allow you to selec
select
many
different
options
settings.
Finally,
some tabs accomplish a
task and return you to the workbook.
J
The Exit command is no longer available
Take Note
O in Office 2013, at least in the same way it was available in prior versions. In this case, the Close tab in Backstage view closes the workbook. The
Close (X) button in the upper right S
corner of the Excel 2013 window closes Excel (see Figure
3-1).
H
U
A
Return to Document button
Close workbook
6
8
9
0
B
U
Close window
Additional tabs change third portion of screen
Navigation pane tabs
Figure 3-1
Backstage view—Open tab
Using Office Backstage
63
ACCESSING AND USING BACKSTAGE VIEW
Bottom Line
STEP BY STEP
In the Excel 2013 window, you see the green FILE tab in the upper left corner. This is your access
to Backstage view. When you click the FILE tab to access Backstage view, you see the navigation
pane containing many of the same commands that can be accessed through the Microsoft Office
button in previous versions of Excel. In this section, you access Backstage view and use these
commands to close a file.
Access Backstage View
GET READY. LAUNCH Excel and OPEN a blank workbook.
Another Way
You can also press
Alt + F to select FILE and go to
the Backstage view.
Figure 3-2
Backstage view—Info tab
1. Click the FILE tab to display Backstage view with the Open tab selected (see Figure 3-1).
2. In the upper left corner of Backstage view, click the Return to document button.
3. In cell A1, type abc and press Enter.
S view, like the ribbon, is context-sensitive and changes to
4. Click the FILE tab. Backstage
the Info tab (see Figure 3-2).
M
I
T
H
,
IInformation
n orm
nf
about the
ccurrent
urre file says it is
nnot
ot yet
ye saved.
J
O
S
H
U
A
6
8
9
0
B
5. Click the Save tab. Notice that there are additional tabs depending on your setup. In
U and Add a Place appear.
this case, SkyDrive, Computer,
6. Click the Save As tab. Notice that this looks identical to the Save tab. This is how it
looks the first time you save the file.
7. Click Computer and notice that the Recent Folders section where you last saved your
previous workbooks appears (see Figure 3-3).
64
Lesson 3
Figure 3-3
Backstage view—Save As tab
Recent locations
(drives and folders)
that you have accessed
8. Click Browse. In the File name box, type Temp, and then click Save.
S
10. Click Save. Notice that you doM
not see the options shown in Figure 3-3 (and Step 5
previously), but that you return
I directly to the workbook.
11. Click FILE and click Close. This action closes the workbook, but not Excel.
T
12. Click FILE
LE
Ea
and
nd the
h Open
he
n ttab
ab
ba
appears.
p ea
pp
arss. In the list
lis
istt of Recent
Rec
e en
entt Workbooks,
W rkkbo
Wo
o
select Temp and
H
your workbook
orkkbook re
rreturns.
tu
urns.
s
s.
,
PAUSE. CLOSE
Excel.
OSE E
xcel.
xc
9. Click FILE. Notice the Info tab appears.
Cross
Ref
Bottom Line
Backstage view is introduced in Lesson
J 1. Creating a new workbook and saving a file are discussed
in more detail in Lesson 2, “Working with Microsoft Excel 2013.”
O
S
PRINTING WITH BACKSTAGE
H
Backstage view contains Excel’s Print commands and options. You can use the Print settings to
manipulate workbook elements suchUas margins, orientation, paper size, and so on.
A
Printing and Previewing a Document
Backstage view includes a Print tab 6
with a Print Preview pane so you can preview your workbook
as you click Print options. Print options are a series of settings that allow you to change how a
document prints. You can print the8document so it is horizontal or vertical, display gridlines on
the page, scale the text to make it fit9on a single page, and select from many other options. In this
exercise, you create a form for a potluck and learn to use the Print and Print Preview features in
0
Excel.
B
U
STEP BY STEP
Print and Preview a Document
GET READY. LAUNCH Microsoft Excel 2013.
1. Create a new workbook, enter the worksheet data shown in Figure 3-4, and save it as
03 Contoso Potluck solution in a folder called Excel Lesson 3.
Using Office Backstage
65
Figure 3-4
03 Contoso Potluck solution
worksheet
2. CLOSE Excel.
Another Way
Another way to
create a new workbook is with
the Ctrl + N keyboard shortcut.
Figure 3-5
File Properties area
Print tab
Take Note
Cross
Ref
3. LAUNCH Excel again and notice that 03 Contoso Potluck Solution appears in your
Recent list. Click the file to bring it back up.
S
4. Click the FILE tab to automatically
display the Info tab. As shown in Figure 3-5, the
Properties area shows the M
size of the file, when it was last modified, and who the
author is.
I
T
H
,
J
O
S
H
U
A
Size of file
Last Modified date
Author
Click to go to the
folder for the file.
6
A handy feature, Open File Location,
8 allows you to open the folder where the current file is located.
9
In Lesson 2, the “Editing a Workbook’s
Properties” section demonstrates how to make changes to
some of the properties in a workbook.
0
Bthis displays the Print options in Backstage view. Take a
5. Click the Print tab. Note that
moment to preview the workbook in the Print Preview section in the right pane and
U
read through the Print options listed in the center section of the page (see Figure 3-6).
66
Lesson 3
Figure 3-6
Document preview
Print tab in
navigation pane
Print preview
area
Print options area
Another Way
You can also
activate Backstage view and
access Print options by pressing Ctrl + P.
STEP BY STEP
S
M
I
T
H
6. To print your
you
ur worksheet,
w rkksh
wo
hee
e t, at the
th
h,e top
po
off the Print
nt sscreen,
crreen, click
ck tthe
he P
Print button.
PAUSE. LEAVE
AVE the
h workbook
workb
k ook open
kb
open for
op
or the
the next
nex
ext exercise.
exer
ex
erci
er
cise
ci
se
J
Using Quick Print to Print a O
Worksheet
Use the Print tab in Backstage view when you need to review a draft of a worksheet before you are
S
ready to print the final workbook. If you click the Quick Print icon on the Quick Access Toolbar,
H printer. The Quick Print command on the Quick Access
the worksheet is sent directly to the
Toolbar is useful because worksheets
Uare frequently printed for review and editing or distribution
to others.
A
6
Use Quick Print to Print a Worksheet
8
GET READY. USE the open workbook from the previous exercise or open 03 Contoso
9
Potluck Solution.
1. On the Quick Access Toolbar, 0
if you do not see the Quick Print button, click the
Customize Quick Access Toolbar arrow at the end of the toolbar, and select Quick Print
B
(see Figure 3-7).
U
Figure 3-7
Customizing the Quick Access
Toolbar menu
Arrow to access menu
Customize Quick Access Toolbar
Quick Print is not checked
so it needs to be selected.
Using Office Backstage
Take Note
67
Discuss with your instructor whether you can print in the classroom. If you cannot, view all the
documents in preview mode to see how the document would print whenever printing is mentioned
in this book.
2. On the Quick Access Toolbar, click Quick Print (see Figure 3-8).
Figure 3-8
Quick Print
Quick Access Toolbar
3. Retrieve the printed copy of the worksheet from your printer.
4. Click the FILE tab, and then click Print. The preview pane should match what was
printed.
5. Click the Return to document button.
6. Notice that a dotted vertical line appears in the middle of the screen. The line shows
S
the right edge of the printed page. The line displays the first time you print or preview a
page.
M
I for the next exercise.
PAUSE. LEAVE the workbook open
T
H
Setting th
the
he Pr
Print
rin
intt Ar
Area
rea
e
You can use th
tthee Print
Prin
nt options
o tions in
op
n,Backstage
Backk sttage view
w too print
priint only a se
selected
elect portion, or print area, of
an Excel workbook.
exercise,
select
area
workbook for printing. You
workb
k ook. IIn
kb
n this ex
xerrcise,, yyou
ou llearn
earn
ea
rn ttoo se
sele
lect
le
ctt aan
n are
ea ooff a w
ea
print just the list of items and have a couple of people verify that these are items you should have
people bring to the potluck.
J
STEP BY STEP
O
S
Set the Print Area
H
GET READY. USE 03 Contoso Potluck
Solution that is already open or create the workbook
U
shown in Figure 3-4.
A
1. Click the PAGE LAYOUT tab.
2. In the Page Setup group, point to the Print Area button. Note the ScreenTip that
displays and defines the task
6 to be completed.
3. On the worksheet, click cell8A3, hold the mouse button, and drag to cell A13. Your cell
range should be highlighted in gray (see Figure 3-9).
Figure 3-9
Selecting a print area
9
0
Name Box says A3.
B
U
68
Lesson 3
4. With these cells highlighted, from the menu that appears, click the Print Area dropdown arrow and click Set Print Area. You have now set the print area. While the area is
still selected, note that the Name Box now says Print_Area (see Figure 3-10).
Figure 3-10
Selected print area
Name Box says Print_Area.
1.5.1
How do you set the print
area in a worksheet?
S
M
I
T
5. Click the
e FI
FILE
L tab
b to
to open
en Backstage
view.
6. Click Print
intt a
and
n n
nd
notice
o ic
ot
ice in
i the
eP
Print
rint
re
eview pa
pane
ane
e that y
you
ou
u ca
can
an ssee
ee
e only the list of items to
H PPreview
bring and
not
and
columns
nd n
ot th
the te
text
xt iin
n rows
ws 1 an
nd 2 and co
olum
umns
ns B and
d C.
C.
,
7. Click the
e Retu
Return
turrn to do
tu
docume
document
entt butt
button.
ton. You
u will not print
pri
rint at this
this
i time.
tim
PAUSE. SAVE the workbook in your Lesson 3 folder with the current name 03 Contoso
J
Potluck Solution and CLOSE Excel.
O
S
Printing Selected Worksheets
In this exercise, you learn to access H
the options for printing individual worksheets in a workbook.
You can use these options to print the current worksheet only or to print multiple worksheets.
U
A
STEP BY STEP
Print Selected Worksheets
6
8
1. OPEN 03 Contoso Potluck Depts. This is a modified version of the potluck workbook
you created previously. In this9case, there are three different worksheets for three
different departments.
0
2. Click each of the three worksheet tabs: HR, Operations, and Finance. Notice that the
B
title in C1 shows the department name and there are a different number of items to
bring to each potluck depending
U on the size of the department. Click the HR tab.
GET READY. LAUNCH Excel 2013, and then perform these steps:
3. Press Ctrl + P to display the Print options in the Backstage view. In the Print Preview
pane, the entire worksheet does not display (see Figure 3-11). This is because of the
selected print area.
Using Office Backstage
69
Figure 3-11
The entire worksheet
does not display because print
area is selected.
S
M
I
T
H
4. Presss Es
Esc
sc or
or click
clicck the
t e Ret
th
Return
turn
button.
butt
ttton.
, to documentt bu
5. Click the PA
PAGE L
LAYOUT
AYOUT ttab,
AY
ab
b, cli
click
ick Pr
Print
Prin
intt Ar
in
Area
Area,
ea, an
ea
and
d then
t en sselect
th
ele
ec t C
Clear Print Area.
6. Click the FILE tab and click Print. Notice that the entire worksheet for HR appears.
J
Also notice that the page number
shows 1 out of 1 indicating that only one of the
worksheets will print, and it will all fit on one page.
O
7. In the Settings section of the center pane in Print options, click the Print Active Sheets
S
drop-down arrow. In the drop-down
menu that appears, as shown in Figure 3-12, you
can select several printing options for your workbook or worksheet.
H
U
A
Figure 3-12
Worksheet print options
6
8
9
0
B
U
Entire workbook
appears because
print area cleared
Drop-down arrow
Page 1 of 1
70
Lesson 3
8. Click the Return to document button.
9. While the HR worksheet is active, hold down Ctrl and click on the Finance tab. Now
both the HR and Finance worksheets are selected.
10. Click the FILE tab and click Print. Now in the Print Preview area, the bottom of the
screen shows 1 of 2 with the HR worksheet preview. Click the right arrow to go to the
second page and notice that the Finance worksheet previews (see Figure 3-13).
Figure 3-13
Two worksheets will
print this time.
The current
Page 2 is
the Finance
worksheet.
Pa
Page
aggee 1 was
ass the
t he
HR
R worksheet.
workshe
heeet.
he
1.5.3
How do you print selected
worksheets?
S
M
I
T
H
,
J
O
S
H
11. Click the Return to document button to return to the workbook without printing.
U
PAUSE. CLOSE the workbook without saving. LEAVE Excel open for the next exercise.
A
Printing Selected Workbooks
6 are composed of multiple worksheets. It is much easier
In most scenarios in business, workbooks
to print an entire workbook than to8
print the workbook’s worksheets individually. In this exercise,
you use commands in Backstage view to print an entire workbook.
STEP BY STEP
Print Selected Workbooks
9
0
B
U
GET READY. With Excel open from the previous exercise, perform the following steps:
1. Click the FILE tab and click Open if it is not selected. Because you just used the
03 Contoso Potluck Depts workbook, it should be at the top of the list of the Recent
Workbooks (see Figure 3-14).
Using Office Backstage
71
Figure 3-14
03 Contoso Potluck Depts
is the most recent
workbook used.
03 Contoso
Potluck Depts
2. Click 03 Contoso Potluck Depts to open it.
3. Click the FILE tab and click Print.
4. Notice that the complete worksheet for HR does not display. This is because you did
not save the workbook after you cleared the print area. Clear the print area as you did
in Step 5 of the previous section and return to the Print tab of Backstage view.
S
5. In the Print window’s Settings options, click the Print Active Sheets drop-down arrow
and click Print Entire Workbook
M (see Figure 3-15). You will not print at this time.
I
T
H
,
Figure 3-15
Printing an entire workbook
Print En
Entire
ntirre Workbook
Woorkkbo
book
ok
1.5.7
How do you print a
workbook?
STEP BY STEP
J
O
S
H
U
ASAVE the workbook.
PAUSE. CLOSE Excel and do not
Applying Printing Options6
The Print command in Backstage
8 view offers a number of options for customizing printed workbooks. This exercise prepares you to customize such options as page setup, scale, paper selection,
9
and gridlines, all using the commands in Backstage view.
Apply Print Options
0
B
U
GET READY. LAUNCH Excel, OPEN 03 Contoso Potluck HR, and make sure the HR-P1
worksheet is selected.
1. Click the FILE tab and select Print (see Figure 3-16). Notice that the worksheet is small
and it might be nice to have lines for people to write in on a printed page.
72
Lesson 3
Figure 3-16
Print Settings area
Worksheet
print options
Page
Orientation
options
Paper type
options
Margin
options
Scaling
options
S
M
I
2. In the Settings
e ti
et
tin
ngs section
se
ection of the Print
dro
and click
T window, click the Margins drop-down
Wide (see
ee
e Figure
Figure
e 3-17).
3 -17).. The
The ne
new
ew ma
m
margins
r ins wi
rg
will
ill
l a
allow
llow
ll
ow tthe
he
ew
worksheet
o kshe
or
hee
he
e to be hole-punched
H
and put in
n a binder.
bin
nde
d r.
,
Figure 3-17
Normal margins are about
¾ of an inch. Wide margins
are 1 inch.
J
O
S
H
If you want to set a
margin that
Uis not on
the list, click Custom
Margins. A
6
8
3. Click the Scaling drop-down and see the choices below (see Figure 3-18). The scaling
9
options ensure that all columns, rows, or the entire worksheet fit on one page.
• Current choice is No scaling, 0
so the document prints the same size as the screen.
B
• If you want to fit everything that is on the worksheet on one page, select Fit Sheet on One
U
Page.
• If there are just a couple of columns extra, click Fit All Columns on One Page.
• If there are just a couple of rows extra, click Fit All Rows on One Page.
Using Office Backstage
Figure 3-18
73
No scaling
Print scaling options
Fit Sheet on One Page
Fit All Columns on One Page
Fit All Rows on One Page
4. In this case, you make the text larger without changing the font. Click Custom Scaling
Options. The Page Setup dialog box opens.
5. Make sure that the Page tab is selected and select Landscape so the page prints
horizontally.
6. In the Scaling area, type 200 for the % normal size (see Figure 3-19).
Figure 3-19
Page Setup dialog box
1.5.4
How do you set print
scaling to make the entire
document larger?
Figure 3-20
Final view of HR-P1
before printing
S
M
I
T
H
,
J
O
S
H
7. Click the Sheet tab and in the Print section, select the Gridlines box.
U view. Notice that the bottom of the screen still says,
8. Click OK to return to Backstage
1 of 1, meaning that only one page will print and notice that Print Preview shows larger
A
text with boxes around each cell (see Figure 3-20).
6
8
9
0
B
U
Indicates 1 page
will print
74
Lesson 3
Another Way
You can customize
the workbook settings and options from the PAGE LAYOUT
tab in the Page Setup, Scale to
Fit, and Sheet Options groups.
9. Without printing the document, click the Return to document button and then click the
HR-P2 worksheet.
10. Press Ctrl + P to go to the Print tab of the Backstage view and notice that the bottom of
the screen indicates that the document will print on two pages.
11. Change the Settings to print Landscape, to Fit Sheet on One Page, and add gridlines
based on the previous steps in this section. Print Preview should look like Figure 3-21.
Figure 3-21
Final view of HR-P2
before printing
S
M
I
T
H
,
1.5.7
How do you apply printing
options?
Cross
Ref
J
O
S
H
12. SAVE the workbook in your Lesson 3 folder as 03 Contoso Potluck HR Print Ready
Solution.
U
Afor the next exercise.
PAUSE. LEAVE the workbook open
See Lesson 7 for additional options for preparing a document for pr …
Purchase answer to see full
attachment

error: Content is protected !!