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

1. In your own words, name at least three different file formats you can save Excel files in, and describe why you would use the different formats. 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. Prepare a paper, which should be no more than two pages in length, which describes 3 features presented in unit 3’s reading and how you can apply those features to your daily life. 3. Using Microsoft Excel or Excel online, complete Project 2-4 starting on page 58 in unit 3’s reading. Submit to the dropbox when finished.4. Where would you go in Excel to save, select a template, change document properties, and close or exit Excel?5. In Excel, which dialog box in Backstage view should you access to view and alter your workbook’s properties?6. In Excel, what is a predesigned file that already has a significant amount of formatting, text, and other features?7. Using Microsoft Excel or Excel Online, design and create a spreadsheet that organizes your total estimated personal expenses (including rent or house payments, car payments, loan payments, and other items on which you spend money) by month for a twelve-month period. This can be fictional data, as long as it’s realist data. Format the cells using the accounting number format, and add a worksheet title in cell A1. Merge and center cell A1 across the top of your worksheet, and format the text appropriately to give it a professional appearance. 8. Building on the spreadsheet you created in question #6; add your monthly income over the last 12 months. This can be fictional data, as long as it’s realist data. You may need to change your worksheet title to reflect this additional information. Format the monthly income using the accounting number format. Use the SUM function to calculate your total expenses, as well as your total income (you will add together your expenses for each of the twelve months, and then add together your income for each of the twelve months).9. 8. Using the spreadsheet from questions 6 and 7. Use the AVERAGE, MAX, and MIN functions to determine the following:* Use the AVERAGE function to determine your average monthly expenses* Use the AVERAGE function to determine your average monthly income* Use the MAX function to determine how much you spent during the month when your monthly expenses were the highest.* Use the MAX function to determine how much income you received during the month when your monthly income was the highest.* Use the MIN function to determine how much you spent during the month when your monthly expenses were the lowest.* Use the MIN function to determine how much income you received during the month when your monthly income was the lowest.Total word count excluding number 1 must equal 1200 words. All must be cited in APA format according to APA template uploaded and referenced in APA format.
apa_template_5.6.16.docx

https___vcampbethel.blob.core.windows.net_public_courses_gen_2020_unit_3_read.pdf

Unformatted Attachment Preview

Running head: APA TEMPLATE
1
An APA Template for Bethel University Students
Student’s Name
Bethel University
APA TEMPLATE
2
Abstract
An abstract is a 150-200 word paragraph describing the major outcomes, results, or findings of
the essay. An abstract is not an introduction and is not a conclusion. An abstract may not be
necessary for every paper. Students should check with their Facilitator regarding the need for an
abstract.
APA TEMPLATE
3
An APA Template for Bethel University Students
An introduction paragraph is the starting point of any paper. The introduction should
introduce the reader to the topics, outline the major points of the essay, and should conclude with
a strong thesis statement.
Level 1 Heading
The level 1 header names the first major topic discussed in the essay. The student
changes the words “Level 1 Heading” to some descriptive term corresponding to the topic
discussed. Level 2 and level 3 headers are only used when major subtopics are categorized under
the major topic. If you change to a new major topic, a new level 1 header is needed.
Level 2 Heading
Level 2 headers are used to identify major subtopics under the major topic listed as the
level 1 header. Level 2 headers are often unnecessary in short essays, less than 4 pages, but
sometimes useful in longer papers.
Level 3 Heading. All three headers in this template are formatted and placed in the
correct location for you! Level 3 headers are quite rare in short papers and rare in papers less
than seven pages in length.
Conclusion
Every essay should end with a concluding paragraph. In the conclusion, you restate the
major points and topics covered in the essay. You would sum up the paper by showing how these
major points and topics support the original thesis. Do not introduce new information in the
conclusion.
APA TEMPLATE
4
References
Barker, K. L. (Ed.). (2011). Education and Pedagogy. Grand Rapids, MI: Wiley.
Graham, G. (2005). Behaviorism. In E. N. Zalta (Ed.), The Stanford encyclopedia of philosophy
(Fall 2007 ed.). Retrieved from http://plato.stanford.edu/entries/behaviorism/
S
M
I
T
H
,
J
O
S
H
U
A
6
8
9
0
B
U
ii
Editor
Publisher
Director of Sales
Technical Editor
Executive Marketing Manager
Assistant Marketing Manager
Microsoft Strategic
Relationships Manager
Editorial Program Assistant
Content Manager
Production Editor
Creative Director
Cover Designer
Product Designer
Content Editor
Bryan Gambrel
Don Fowley
Mitchell Beaton
Joyce Nielsen
Chris Ruel
Debbie Martin
Gene Longo of Microsoft Learning
Allison Winkle
Kevin Holm
Jill Spikereit
Harry Nolan
Tom Nery
S Welter
Jennifer
Wendy
M Ashenberg
This book was set in Garamond by IBoxTwelve. and printed and bound by Courier/Kendallville.
The covers were
printed
Courier/Kendallville.
wer
eree printe
ed by C
ourier/Kendallville.
ou
T
Copyright © 2014
Wileyy &HSons,
Son
ns,, Inc. All rights reserved.
reserve
ved.
ve
d.
2014
14 by
by John
Joh Wiley
,
No part of this
system or transmitted in any
his publication
pub
u licatiion may be
be reproduced,
reprod
oduced,, st
sstored
orred
d in a re
rretrieval
trievaa l syste
form or by any means, electronic,
recording,
scanning or otherwise,
l
i mechanical,
h i l photocopying,
h
i
di
except as permitted under Sections J
107 or 108 of the 1976 United States Copyright Act, without
either the prior written permission of the Publisher, or authorization through payment of the
O Clearance Center, Inc. 222 Rosewood Drive, Danappropriate per-copy fee to the Copyright
vers, MA 01923, (978) 750-8400, fax
S (978) 646-8600. Requests to the Publisher for permission
should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street,
H
Hoboken, NJ 07030-5774, (201) 748-6011,
fax (201) 748-6008. To order books or for customer
service, please call 1-800-CALL WILEY
(225-5945).
U
Microsoft, ActiveX, Excel, InfoPath,AMicrosoft Press, MSDN, OneNote, Outlook, PivotChart,
PivotTable, PowerPoint, SharePoint, SQL Server, Visio, Windows, Windows Mobile, and
Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the
6 Other product and company names mentioned herein may
United States and/or other countries.
be the trademarks of their respective8owners.
9 products, domain names, e-mail addresses, logos,
The example companies, organizations,
people, places, and events depicted 0
herein are fictitious. No association with any real company,
organization, product, domain name, e-mail address, logo, person, place, or event is intended or
B
should be inferred.
U
The book expresses the author’s views and opinions. The information contained in this book is
provided without any express, statutory, or implied warranties. Neither the authors, John Wiley
& Sons, Inc., Microsoft Corporation, nor their resellers or distributors will be held liable for any
damages caused or alleged to be caused either directly or indirectly by this book.
ISBN 978-0-470-13308-8
Printed in the United States of America
10 9 8 7 6 5 4 3 2 1
www.wiley.com/college/microsoft
or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)
Working with
Microsoft Excel 2013
2
LESSON SKILL MATRIX
Skills
Exam Objective
Objective Number
Creating Workbooks
Create new blank workbooks.
1.1.1
Saving Workbooks
Save workbooks in alternate file formats.
1.5.2
Maintain backward compatibility.
1.5.6
SaveS
files to remote locations.
1.5.8
Append
M data to a worksheet.
2.1.1
I replace data.
Find and
2.1.2
Tcolumn width.
Adjust
Adju
j st
1.3.5
H
Demonstrate
Demoonstratee how to use
usee the
the Auto Fill
F lll tool.
Fi
too
ool.
,
2.1.4
Expand
Expa
pand
pa
n data
daataa across
acro
ac
ross
ro
sss columns.
collum
umns
ns..
ns
2.1.5
Delete cells.
2.1.6
Entering and Editing Basic Data in a Worksheet
Using Data Types to Populate a Worksheet
Cutting, Copying, and Pasting Data
Editing a Workbook’s Properties
J
ApplyO
Number formats.
CopyS
and paste data.
H to workbook properties.
Add values
U
A
2.2.6
2.1.3
1.4.8
KEY TERMS
• Auto Fill
6
8
9
0
B
U
• AutoComplete
• copy
• copy pointer
• cut
• fill handle
• Flash Fill
• formula bar
• keywords
• label
• move pointer
• natural series
• Office Clipboard
• paste
• range
• selecting text
• workbook properties
©asiseeit / iStockphoto
27
28
Lesson 2
Purchasing a home is generally the biggest financial investment most people make
in a lifetime. Real estate agents advise and assist those who want to buy a new
home or sell their present home. Some real estate agents can also help people
find rental homes. When people are ready to sell their homes, they often list with
a real estate agent who earns a commission or percentage of the home’s selling
price when the home sells. Agents take an exam to be licensed by their state. Many
licensed agents also become Realtors®. This is a trademarked name that an agent
can use only when he or she joins the local, state, and national associations of Re-
©asiseeit / iStockphoto
altors®. Fabrikam, Inc., located in Columbus, Ohio, is a real estate firm owned by
Richard Carey and David Ortiz. Fabrikam has five fulltime sales agents and a college intern. Fabrikam’s intern
uses Excel to help manage sales, expenses, and support the business. In this lesson, you continue to view,
add, and manipulate data in an Excel 2013 spreadsheet S
similar to that used by Fabrikam, Inc.
SOFTWARE ORIENTATION
Excel’s HOME
OM
ME Tab
Tab
M
I
T
H
,
The ribbon in Microsoft
Miicr
crosoft O
Office
f fice E
Excel
xccel 20
2013
013
3 iiss ma
madee u
up
p of a sseries
eries of
of tabs,
tabs, each related to specific kinds of tasks that you perform in Excel. The HOME tab, shown in Figure 2-1, contains
the commands that people use the most
J when creating Excel documents. Having commands
visible on the work surface enables you to see at a glance most tasks you want to perform. Each
O
tab contains groups of commands related to specific tasks or functions.
Cut
Paste
Figure 2-1
Ribbon, formula bar, and
command options
Copy
S
H
Command Dialog Box Launchers
U
A
Command Groups
Command options arrows
6
8
9
Column Marker
0Formula Bar
Some commands have an arrow associated
B with them. In Figure 2-1, you see the option arrows
associated with AutoSum and Find & Select. This indicates that in addition to the default
U
task, other options are associated with the task. Similarly, some of the groups have Dialog Box
Launchers associated with them. Clicking these displays additional commands not shown on
the ribbon. In Figure 2-1, the Clipboard, Font, Alignment, and Number groups have associated dialog boxes, whereas Styles, Cells, and Editing do not.
Working with Microsoft Excel 2013
29
CREATING WORKBOOKS
There are three ways to create a new Microsoft Excel workbook. You can open a new, blank
workbook using the FILE tab to access Backstage view or when you launch Excel. You can open
an existing Excel workbook, enter new or additional data, and save the file with a new name, thus
creating a new workbook. You can also use a template to create a new workbook. A template is a
model that has already been set up to display certain kinds of data, such as sales reports, invoices,
and so on.
Bottom Line
Creating a Workbook from Scratch
To create a new workbook, launch Excel and select a blank workbook or another type of template.
If you are working in Excel and want to begin a new workbook, click the FILE tab, click New,
and then click Blank workbook. Worksheets often begin with text that describes the content of
the worksheet. In this exercise, you create two Excel workbooks: one with a company address and
one with a quick phone message.
STEP BY STEP
S
M
Create a Workbook from Scratch
I
T givves you options
GET READY.
AD
DY.. LAUNC
LAUNCH
NCH Excel.
NC
Ex
xcel.. Excel
Exc
x el gives
opt
ptio
ions
ns for
for
or starting
s ta
artin
ng a blank workbook, taking
a tour, orr using
usi
s ng templates
tem
mpl
p attes
e (see
(se
ee H
Figure
Figu
ure
e 2-2).
,
Figure 2-2
Available options after Excel is
launched
J
O
S
H
U
A
6
8
9
0
B
U
1.1.1
How do you create a new
workbook file?
1. Click Blank workbook. If you have just launched Excel, Book1 – Excel appears in the
title bar at the top of the window. A blank workbook opens with A1 as the active cell.
2. In cell A1, type Fabrikam Inc. This cell is the primary title for the worksheet. Note that
as you type, the text appears in the cell and in the formula bar (see Figure 2-3). See the
definition of formula bar in the “Editing a Cell’s Contents” section on page 37.
30
Lesson 2
Figure 2-3
Typed text appears in both the
active cell and the formula bar.
3. Press Enter. The text is entered into cell A1, but appears as if it flows into cell B1.
4. In cell A2, type 123 Fourth Street and press Enter.
5. In cell A3, type Columbus, OH 43204 and press Enter.
6. Sometimes you need a quick work area to complete another task while you are in the
middle of a workbook. You can
Sopen another workbook as a scratch area. Click the FILE
tab, and in the left pane, click New. The different templates available appear (refer to
M
Figure 2-2).
7. In the Backstage view, click Blank
I workbook. A second Excel workbook opens and
Book2 appears in the title bar.
Another Way
When you work in
Excel, you can open a blank
workbook with the shortcut
combination Ctrl + N.
T
Hflight
9. In cell A2, type
typ Da
David
Dav
vid Or
Ortiz
O
tiz UA
A
flig
ghtt 525 arriving
arriiviing 4:30
3 pm
ma
and
nd
d pr
press Enter.
,
PAUSE. LEAVE
AVE both
bot
oth Excel
Ex
xce
el workbooks
workkbo
ooks open
op
pen for
orr the
he next exercise.
e ercisse.
ex
8. In cell A1,
A1
1, type
ty
ype Ph
Phone
Phon
o e Ca
Callss a
and
n press
nd
pre
esss Enter.
J
Switching Between Open Workbooks
The ability to multitask is prized byOmost employers. Windows and Excel enable you to work on
multiple projects simultaneously. When the phone rings, you can quickly go to another area, make
S
notes, or research a question, and then return to your work. If you have multiple workbooks open,
H the workbooks to finish your tasks.
you might need to move quickly between
U
A
STEP BY STEP
Switch Between Open Workbooks
6
GET READY. Both temporary workbooks
with the address and phone message should be
open. The Phone Calls workbook is the current workbook in this case.
8
1. To return to the company address, click the Excel icon on the taskbar (see Figure 2-4).
9
Each of the open workbooks appears in a preview window. When you move the mouse
pointer over each workbook, it
0previews on the screen.
B
U
Figure 2-4
Open workbooks appear
by clicking the Excel icon
on the taskbar.
Another Way
You can also switch
between two recent active
workbooks with Ctrl + Tab.
Excel icon
(open)
Taskbar
2. Click Book1 – Excel. The unsaved company address becomes the active workbook.
Working with Microsoft Excel 2013
Take Note
31
Unlike previous versions, Excel now displays each workbook in a separate window.
SAVING WORKBOOKS
Bottom Line
When you save a file, you can save it to a folder on your computer’s hard drive, a network drive,
disc, CD, USB drive, SkyDrive, or other storage location. You must first identify where the document is to be saved. The remainder of the Save process is the same, regardless of the location or
storage device.
Naming and Saving a Workbook
When you save a file for the first time, you are asked two important questions: Where do you want
to save the file? What name will you give to the file? In this lesson, you practice answering these
questions for two different files. By default in all Office applications, documents are saved to the
My Documents folder.
STEP BY STEP
Another Way
You can also save
the workbook with Ctrl + S.
Figure 2-5
Save As dialog box
S
M
Name and Save a Workbook
I
ADY.
AD
Y. USE the
the workbook
wo
orkbookTfrom the previous exercise or type
ork
typ your name and address
GET READY.
orrkboo
ok.
in a new w
workbook.
H
1. Click the
eF
FILE
IL
LE ttab
ab
b to
o open
n Backstage
Backs
s ta
age view. In
n the
th
he left pan
pane,
ane,
an
e cclick
e,
lic Save As to display the
,
i ns
ns.
save optio
options.
2. Double-click
ble-cliick Comp
Computer
m uter to
to open
open
n the
the Save
Sav
ave As dialog
dia
ialo
log
lo
g box
x (see
(se
(s
ee Figure
F
2-5).
J
O
S
H
U
A
6
8
9
0
B
U pane, in the Save As dialog box, click Desktop. The
3. From the left-hand navigation
Desktop becomes the new destination of your saved file.
4. In the Save As dialog box, click New folder. A folder icon appears with the words New
folder selected (see Figure 2-6).
32
Lesson 2
Figure 2-6
Type a new name in place
of New folder.
1.5.2
How do you name and save
a workbook to a specific
location?
Take Note
S
MEnter.
5. Type Excel Lesson 2 and press
6. Click the Open button.
I
7. In the File name box, type 02 Fabrikam Address Solution.
T
8. Click the
e Sa
Save
ave but
button.
utto
ut
t n.
H
PAUSE. LEAVE
AVE
E the
he workbook
workb
kbo
ook open
op
pen to use
usse in the next
nex
extt exercise.
ex
ex
xercise
e.
,
Save your workbook
kb k often
f and
d especially
i ll before
b f opening
i another
h workbook,
kb
printing, or after you
enter information.
J
O
S
H
Workplace
U
ORGANIZATIONS’ FILE CONVENTIONS
A
Ready
When you first start working at any organization, your employer might give you conventions to
use when naming files or editing those files. File conventions might include adding the date or
your name or initials to a portion of6a file name or adding “r” or “rev” followed by a revision number. An example might be 2014-03-17FiveYearBudgetR3.
8
9
In addition to file naming, your organization
might want you to save files to specific network
drives and folders for different kinds0of documents. They might have rules for which files require
passwords, when files should be destroyed, and frequencies required for backups. If you go into the
B you will be an asset to the organization. Even if there are
business knowing how to manage files,
no existing conventions, you might U
want to think about your own personal conventions to ensure
you can find and protect your files.
Following is an example of a simple drive structure for a charter school.
Working with Microsoft Excel 2013
33
S
M
I
T
H
Saving to Yo
Your
u SkyDrive
Sky
kyDr
D ive
e ,
SkyDrive is a cloud-based
clooud-ba
cl
baased application
appl
p iccation
pl
n that
that allows
a ll
llow
ows you
ow
you too sstore
tore your
you
ur fil
files so you can retrieve them
anywhere and share them with other people if desired. SkyDrive is also a great place to store
backup files of important documents.
SkyDrive comes with Windows 8 or you can install the
J
free desktop app on Windows 7 and Windows Vista. This exercise assumes you have Windows 8
O
already loaded with SkyDrive.
STEP BY STEP
S
H
Save to Your SkyDrive U
A
GET READY. USE the workbook from the previous exercise or type your name and address
in a new workbook.
1. Click the FILE tab and then 6
click Save As.
2. In the Backstage view, under Save As, click [Your name] SkyDrive (see Figure 2-7). You
8
may need to sign in to SkyDrive if you haven’t already.
9
0
B
U
34
Lesson 2
Figure 2-7
SkyDrive information on
the Backstage view
1.5.8
How do you save a file
to SkyDrive?
3. Click the
e Br
Browse
row
wse b
button.
utt to
ton.
S
M
I
T
H
,
4. Click the
e New
w folde
folder
er button
button.
n.
5. In the New folder text box, type Excel Lesson 2 to save a folder for this lesson on your
J
SkyDrive and press Enter.
6. Double-click the Excel LessonO
2 icon to move to that folder.
7. Keep the file with the same name (or type 02 Fabrikam Address Solution in the File
name box), and then click theS
Save button.
H
Uto use in the next exercise.
PAUSE. LEAVE the workbook open
A
Saving a Workbook Under a Different Name
You can rename an existing workbook
6 to create a new workbook. For example, the address you
created in the preceding exercise is current. When you have multiple offices, you can save the file
8
with a new name and use it to enter data for another office. You can also use an existing workbook
9 In this exercise, you learn how to use the Save As dialog
as a template to create new workbooks.
box to implement either of these options.
0
STEP BY STEP
B
U
Save a Workbook Under a Different Name
GET READY. USE the workbook from the previous exercise or type Fabrikam Inc. in cell A1.
1. In cell A2, type 87 East Broad Street and press Enter.
2. In cell A3, type Columbus, OH 43215 and press Enter.
3. Click the FILE tab, and in the left pane, click Save As. The Backstage view shows that
the Current Folder (see Figure 2-8) is Excel Lesson 2 on your SkyDrive, because it was
the folder that was last used to save a workbook.
Working with Microsoft Excel 2013
35
Figure 2-8
Current and Recent
folders used
S
M
I
T
H
4. Click Comp
Computer
mput
mp
u err to
o rreturn
eturn
n to
o, the
e drive you us
used
sed
db
before.
efore.
5. In the
e right
h pane,, d
ht
double-click
ouble
e -cl
c ick E
cl
Excel
xccel L
Lesson
esso
es
on 2.
2.
6. Click in the File name box, click after Fabrikam, and type Broad so the name reads
JSolution.
02 Fabrikam Broad Address
7. Click Save. You created a new
O workbook by saving an existing workbook with a new
name.
SAs in the left pane, and click Browse.
8. Click the FILE tab, click Save
H Fabrikam Address Template Solution.
9. In the File name box, type 02
10. In the Save a type box, click
Uthe drop-down arrow and choose Excel Template. Click
the Save button.
Take Note
1.5.2
How do you rename and
save an existing workbook?
Cross
Ref
A
Templates are automatically saved in another location so they can be opened with the FILE, New
option.
6
8
9 new workbook based on the example file eliminates the possiCreating a template to use for each
bility that you might lose data because
0 you might overwrite a file after you enter new data. To use
the templa …
Purchase answer to see full
attachment

error: Content is protected !!