Complete the following steps to protect this spreadsheet.

1.Lock/protect the entire file so that a password is required to open the workbook.

2.Lock/protect the entire first sheet that is named "Contact Information" so that no one can select any cells in the entire sheet.

3.Lock/protect the entire second sheet that is named "Debt List" and then hide the sheet so it is not visible.

4.Lock/protect the entire third sheet that is named "Personal Problems" but leave it visible (do not hide it).

5.Select the boxes for text on the "Updates" sheet.  Make sure that when you lock the sheet thatthese are still "unlocked" so that you can type in them.  Depending on your version of a spreadsheetthis may be different.Look at the helpon your spreadsheet tool to find out how to leave some cells open for editing.

 

 

First Name
Rebecca
Steven
Patrick
Holly
Safiya
Dominique
Grant
Willie
Maya
James
Paul
Jake
Jason
Michael
Jason
Hannah
Zachary
Shelby
Diana
Anthony
Mark
Vinkle
Elizabeth
Larry
Christopher
Iesha
Shana
Elsa
Courtney
Shanda
Jasmine
Jeremy
David
Elizabeth
Zechariah
Scylance
Kellee
Jessica
Samantha
Zoe
Krystyna
Michael Last Name
Adams
Allen
Almon
Amey
Anand
Bardenwerper
Belden
Boatwright
Brook
Burnham
Clarke
Clonts
Crane
Dean
Fenton
Griffiths
Heisey
Henderson
Hoydic
Kiprotich
Kuglar
Leach
McClure
McCray
McCrite
Murray
Palmer
Parks
Prempeh
Reese
Roberts
Scapillati
Scott
Simmonds
Spain
Stapleton
Stephens
Taylor
Turner
Van Meter
Watkins
Wituszynski Address
5352 Honey End
3455 Blue Impasse
8528 Dewy View Cove
335 Rustic Forest Downs
8222 Lost River Mount
875 Misty Diversion
3872 Gentle Estates
788 Hidden Deer Circle
732 Noble Creek Common
7795 Umber Farms
763 Round Autumn Crossing
7728 Iron Hollow
2109 Jagged Bear Grounds
3260 Hazy Timber Way
3056 Dusty Mountain
2072 Crystal Dale Circuit
4268 Rocky Pointe
6521 Quiet Highlands
7364 Easy Panda Ramp
2246 Grand Private
2552 Harvest Subdivision
4142 Cotton Anchor Corner
4467 Quaking Pines
5107 Wishing Rise
3139 Old View
8348 Heather Path
1553 Colonial Spring Pike
1074 Red Blossom Bend
9088 Tawny By-pass
2919 Green Falls
3892 Cozy Corners
551 High Wood
518 Pleasant Quail Close
956 Sunny Berry Maze
3927 Broad Hills Walk
3468 Lazy Robin Highway
6320 Clear Pond Line
2903 Merry Parkway
2540 Shady Log Knoll
5985 Indian Fawn Key
912 Sleepy Park
9579 Thunder Grove Field City
State
Atlanta
GA
Stone MountaGA
Atlanta
GA
Marietta
GA
Norcross
GA
Stone MountaGA
Norcross
GA
Norcross
GA
Atlanta
GA
Atlanta
GA
Atlanta
GA
Atlanta
GA
Norcross
GA
Atlanta
GA
Marietta
GA
Norcross
GA
Marietta
GA
Stone MountaGA
Stone MountaGA
Alpharetta GA
Atlanta
GA
Stone MountaGA
Alpharetta GA
Atlanta
GA
Alpharetta GA
Atlanta
GA
Norcross
GA
Atlanta
GA
Alpharetta GA
Stone MountaGA
Atlanta
GA
Atlanta
GA
Stone MountaGA
Atlanta
GA
Norcross
GA
Norcross
GA
Atlanta
GA
Atlanta
GA
Norcross
GA
Norcross
GA
Atlanta
GA
Atlanta
GA Zip
30389
30086
30392
30066
30091
30086
30092
30091
30398
31106
30390
31107
30091
30396
30066
30091
30064
30087
30087
30009
30399
30083
30004
31106
30005
31126
30003
30389
30004
30088
30399
31126
30088
30390
30091
30010
31119
31120
30071
30091
31107
30394 Rebecca Wright 410 Stony Elk Row Norcross GA 30092 Phone
Username
6568038647 RAdams
6352358744 SAllen
6015294856 PAlmon
7616537630 HAmey
5728008760 SAnand
4113633787 DBarde
5334523074 GBelde
3436858847 WBoatw
2732494486 MBrook
6897974399 JBurnh
5721696492 PClark
6904891564 JClont
6360258809 JCrane
6277813790 MDean
6460433506 JFento
6009575264 HGrif
4804323131 ZHeise
4013559639 SHende
2795022358 DHoydi
4033622418 AKipro
3772815598 MKugla
6303049773 VLeach
6693106637 EMcClu
4810787938 LMcCra
2727818009 CMcCri
2696545776 IMurra
3970585991 SPalme
4387946674 EParks
2873061991 CPremp
5208909385 SReese
6015404906 JRober
5765309964 JScapi
6257972154 DScott
2781489168 ESimmo
3827032036 ZSpain
4243955094 SStapl
3123714422 KSteph
3064356415 JTaylo
2845547041 STurne
6545897011 ZVan M
2576576542 KWatki
5110058215 MWitus Complete
Completethe
thefollowing
following steps
steps to
to protect
protectthis
this spreadsheet.
spreadsheet.
1.
1. Lock/protect
Lock/protect the
the entire
entire file
file so
so that
that aapassword
passwordisis required
required to
to open
open the
the
workbook.
workbook.
2.
2. Lock/protect
Lock/protect the
the entire
entire first
first sheet
sheetthat
thatisisnamed
named "Contact
"Contact
Information"
Information" so
so that
that no
no one
onecan
can select
select any
any cells
cellsin
inthe
the entire
entire sheet.
sheet.
3.
3. Lock/protect
Lock/protect the
the entire
entire second
second sheet
sheet that
that isis named
named "Debt
"DebtList"
List" and
and
then
thenhide
hide the
thesheet
sheet so
so ititisis not
not visible.
visible.
4.
4. Lock/protect
Lock/protect the
the entire
entire third
thirdsheet
sheet that
thatisis named
named"Personal
"Personal Problems"
Problems"
but
but leave
leave itit visible
visible(do
(do not
not hide
hideit).
it).
5.
5. Select
Select the
theboxes
boxes for
for text
text on
on the
the "Updates"
"Updates" sheet.
sheet. Make
Make sure
sure that
that
when
whenyou
youlock
lock the
thesheet
sheetthat
thatthese
theseare
are still
still "unlocked"
"unlocked" so
so that
that you
you can
can
type
typein
in them.
them. Depending
Dependingon
on your
your version
version of
of aa spreadsheet
spreadsheet this
this may
may be
be
diferent.
diferent. Look
Look at
atthe
the help
help on
on your
your spreadsheet
spreadsheet tool
tool to
to find
find out
out how
how to
to
leave
leavesome
some cells
cells open
open for
for editing.
editing. 2660534492 RWrigh preadsheet.
preadsheet. ord isis required
word
required to
to open
open the
the amed
amed "Contact
"Contact
ls in
lls
inthe
the entire
entire sheet.
sheet.
s named
is
named "Debt
"DebtList"
List" and
and named
named"Personal
"Personal Problems"
Problems" sheet.
sheet. Make
Make sure
sure that
that
nlocked" so
unlocked"
so that
that you
you can
can
a spreadsheet
spreadsheet this
this may
may be
be
et tool
eet
tool to
to find
find out
out how
how to
to First Name
Rebecca
Steven
Patrick
Holly
Safiya
Dominique
Grant
Willie
Maya
James
Paul
Jake
Jason
Michael
Jason
Hannah
Zachary
Shelby
Diana
Anthony
Mark
Vinkle
Elizabeth
Larry
Christopher
Iesha
Shana
Elsa
Courtney
Shanda
Jasmine
Jeremy
David
Elizabeth
Zechariah
Scylance
Kellee
Jessica
Samantha
Zoe
Krystyna
Michael Last Name
Adams
Allen
Almon
Amey
Anand
Bardenwerper
Belden
Boatwright
Brook
Burnham
Clarke
Clonts
Crane
Dean
Fenton
Griffiths
Heisey
Henderson
Hoydic
Kiprotich
Kuglar
Leach
McClure
McCray
McCrite
Murray
Palmer
Parks
Prempeh
Reese
Roberts
Scapillati
Scott
Simmonds
Spain
Stapleton
Stephens
Taylor
Turner
Van Meter
Watkins
Wituszynski Amount of Debt Debt on Credit Cards
$7,878.00
$4,726.80
$12,669.00
$5,067.60
$10,094.00
$4,037.60
$19,562.00
$7,824.80
$10,159.00
$4,063.60
$16,599.00
$6,639.60
$12,480.00
$4,992.00
$11,051.00
$4,420.40
$3,286.00
$1,971.60
$12,206.00
$4,882.40
$17,707.00
$7,082.80
$11,504.00
$4,601.60
$15,005.00
$6,002.00
$23,579.00
$9,431.60
$21,699.00
$8,679.60
$7,681.00
$4,608.60
$8,153.00
$4,891.80
$8,749.00
$5,249.40
$21,095.00
$8,438.00
$10,183.00
$4,073.20
$23,690.00
$9,476.00
$19,785.00
$7,914.00
$22,036.00
$8,814.40
$6,647.00
$3,988.20
$20,397.00
$8,158.80
$3,056.00
$1,833.60
$5,702.00
$3,421.20
$20,010.00
$8,004.00
$20,592.00
$8,236.80
$10,585.00
$4,234.00
$10,215.00
$4,086.00
$21,906.00
$8,762.40
$17,423.00
$6,969.20
$20,437.00
$8,174.80
$15,558.00
$6,223.20
$11,648.00
$4,659.20
$10,906.00
$4,362.40
$10,673.00
$4,269.20
$17,952.00
$7,180.80
$18,436.00
$7,374.40
$19,308.00
$7,723.20
$4,370.00
$2,622.00 Complete
Complete the
thefollowing
following steps
steps to
to 1.
1. Lock/protect
Lock/protectthe
theentire
entire file
file so
s
workbook.
workbook.
2.
2. Lock/protect
Lock/protectthe
theentire
entire first
first s
Information"
Information" so
so that
that no
noone
one can
can
3.
3. Lock/protect
Lock/protectthe
theentire
entire secon
seco
then
then hide
hide the
the sheet
sheetso
so itit isis not
not v
4.
4. Lock/protect
Lock/protectthe
theentire
entire third
third
Problems"
Problems" but
butleave
leaveititvisible
visible(d
(d
5.
5. Select
Select the
the boxes
boxes for
for text
text on
ontt
when
when you
you lock
lock the
the sheet
sheet that
that th
th
type
type in
in them.
them. Depending
Depending on
on yo
yo
diferent.
diferent. Look
Look at
atthe
the help
help on
on yo
y
leave
leave some
some cells
cells open
openfor
for editin
editin Rebecca Wright $21,638.00 $8,655.20 Complete
Complete the
thefollowing
following steps
steps to
to protect
protectthis
this spreadsheet.
spreadsheet. 1.
1. Lock/protect
Lock/protectthe
theentire
entire file
file so
so that
that aapassword
password isis required
required to
toopen
open the
the
workbook.
workbook.
2.
2. Lock/protect
Lock/protectthe
theentire
entire first
first sheet
sheetthat
that isis named
named "Contact
"Contact
nformation" so
Information"
so that
that no
noone
one can
can select
select any
any cells
cells in
inthe
theentire
entire sheet.
sheet.
3.
3. Lock/protect
Lock/protectthe
theentire
entire second
secondsheet
sheet that
that isis named
named "Debt
"Debt List"
List" and
and
then
hide
the
sheet
so
it
is
not
visible.
then hide the sheet so it is not visible.
4.
4. Lock/protect
Lock/protectthe
theentire
entire third
third sheet
sheetthat
thatisis named
named"Personal
"Personal
Problems"
Problems" but
butleave
leaveititvisible
visible(do
(do not
not hide
hideit).
it).
5.
5. Select
Select the
the boxes
boxes for
for text
text on
onthe
the "Updates"
"Updates" sheet.
sheet. Make
Makesure
sure that
that
when
you
lock
the
sheet
that
these
are
still
"unlocked"
so
that
when you lock the sheet that these are still "unlocked" so that you
you can
can
type
type in
in them.
them. Depending
Depending on
on your
your version
version of
of aa spreadsheet
spreadsheet this
this may
may be
be
diferent.
diferent. Look
Look at
atthe
the help
help on
on your
your spreadsheet
spreadsheettool
tool to
to find
find out
out how
how to
to
eave some
leave
some cells
cells open
openfor
for editing.
editing. First Name
Rebecca
Steven
Patrick
Holly
Safiya
Dominique
Grant
Willie
Maya
James
Paul
Jake
Jason
Michael
Jason
Hannah
Zachary
Shelby
Diana
Anthony
Mark
Vinkle
Elizabeth
Larry
Christopher
Iesha
Shana
Elsa
Courtney
Shanda
Jasmine
Jeremy
David
Elizabeth
Zechariah
Scylance
Kellee
Jessica
Samantha
Zoe
Krystyna
Michael Last Name
Adams
Allen
Almon
Amey
Anand
Bardenwerper
Belden
Boatwright
Brook
Burnham
Clarke
Clonts
Crane
Dean
Fenton
Griffiths
Heisey
Henderson
Hoydic
Kiprotich
Kuglar
Leach
McClure
McCray
McCrite
Murray
Palmer
Parks
Prempeh
Reese
Roberts
Scapillati
Scott
Simmonds
Spain
Stapleton
Stephens
Taylor
Turner
Van Meter
Watkins
Wituszynski Personal Problems Caused by Debt
Loss of job
Divorce
Separated from spouse
Began drinking
Avoiding phone calls
Utilities turned of
Loss of job
Divorce
Separated from spouse
Began drinking
Utilities turned of
Loss of job
Divorce
Avoiding phone calls
Avoiding phone calls
Utilities turned of
Loss of job
Divorce
Separated from spouse
Began drinking
Utilities turned of
Loss of job
Divorce
Avoiding phone calls
Divorce
Separated from spouse
Began drinking
Utilities turned of
Loss of job
Divorce
Avoiding phone calls
Utilities turned of
Loss of job
Divorce
Avoiding phone calls
Divorce
Utilities turned of
Loss of job
Divorce
Separated from spouse
Began drinking
Utilities turned of Rebecca Wright Divorce Persoanal Problems that Caused the debt
No money management skills
Gambling problem
No money management skills
Too elaborate lifestyle
No money management skills
Gambling problem
No money management skills
No money management skills
Too elaborate lifestyle
No money management skills
Gambling problem
No money management skills
Gambling problem
Too elaborate lifestyle
Too elaborate lifestyle
Gambling problem
No money management skills
Gambling problem
No money management skills
Too elaborate lifestyle
No money management skills
Too elaborate lifestyle
No money management skills
Gambling problem
No money management skills
Gambling problem
Too elaborate lifestyle
Too elaborate lifestyle
Gambling problem
No money management skills
Too elaborate lifestyle
No money management skills
Gambling problem
No money management skills
Gambling problem
Too elaborate lifestyle
Too elaborate lifestyle
Gambling problem
No money management skills
Too elaborate lifestyle
No money management skills
Gambling problem Complete
Complete the
the following
followingsteps
stepsto
to protect
protect this
this spreadsheet.
spreadsheet. 1.
1. Lock/protect
Lock/protect the
the entire
entire file
file so
so that
thataa password
passwordisis required
required
workbook.
workbook.
2.
2. Lock/protect
Lock/protect the
the entire
entire first
firstsheet
sheet that
that isis named
named "Contact
"Contact
Information"
Information"so
so that
thatno
no one
onecan
canselect
selectany
anycells
cells in
in the
the entire
entire
3.
3. Lock/protect
Lock/protect the
the entire
entire second
second sheet
sheet that
thatisisnamed
named "Debt
"Debt
then
then hide
hidethe
thesheet
sheet so
soititisisnot
not visible.
visible.
4.
4. Lock/protect
Lock/protect the
the entire
entire third
third sheet
sheet that
that isis named
named "Persona
"Person
Problems"
Problems" but
but leave
leave itit visible
visible (do
(donot
not hide
hide it).
it).
5.
5. Select
Selectthe
the boxes
boxesfor
for text
texton
on the
the "Updates"
"Updates" sheet.
sheet. Make
Make su
su
when
whenyou
youlock
lock the
thesheet
sheet that
that these
these are
are still
still "unlocked"
"unlocked" so
sotha
tha
type
type in
in them.
them. Depending
Dependingon
on your
your version
version of
of aa spreadsheet
spreadsheetth
th
diferent.
diferent. Look
Look at
at the
the help
help on
on your
your spreadsheet
spreadsheet tool
tool to
to find
find oo
leave
leave some
some cells
cells open
open for
for editing.
editing. No money management skills to
to protect
protect this
this spreadsheet.
spreadsheet.
so
so that
thataa password
passwordisis required
requiredto
to open
openthe
the ttsheet
sheet that
that isis named
named "Contact
"Contact
an
anselect
selectany
anycells
cells in
in the
the entire
entire sheet.
sheet.
ond
sheet
that
is
named
cond sheet that is named "Debt
"Debt List"
List" and
and
tt visible.
visible.
d sheet
rd
sheet that
that isis named
named "Personal
"Personal
(do
(donot
not hide
hide it).
it).
n the
the "Updates"
"Updates" sheet.
sheet. Make
Make sure
sure that
that
these
these are
are still
still "unlocked"
"unlocked" so
sothat
thatyou
youcan
can
our version
your
version of
of aa spreadsheet
spreadsheetthis
this may
may be
be
your
your spreadsheet
spreadsheet tool
tool to
to find
find out
out how
how to
to
ting.
ting. First Name
Rebecca
Steven
Patrick
Holly
Safiya
Dominique
Grant
Willie
Maya
James
Paul
Jake
Jason
Michael
Jason
Hannah
Zachary
Shelby
Diana
Anthony
Mark
Vinkle
Elizabeth
Larry
Christopher
Iesha
Shana
Elsa
Courtney
Shanda
Jasmine
Jeremy
David
Elizabeth
Zechariah
Scylance
Kellee
Jessica
Samantha
Zoe
Krystyna
Michael Last Name
Notes from Meeting 1 Progress Week 1 Notes from Week 2
Adams
Allen
Almon
Amey
Anand
Bardenwerper
Belden
Boatwright
Brook
Burnham
Clarke
Clonts
Crane
Dean
Fenton
Griffiths
Heisey
Henderson
Hoydic
Kiprotich
Kuglar
Leach
McClure
McCray
McCrite
Murray
Palmer
Parks
Prempeh
Reese
Roberts
Scapillati
Scott
Simmonds
Spain
Stapleton
Stephens
Taylor
Turner
Van Meter
Watkins
Wituszynski Rebecca Wright Progress Week 2 Notes from Week 3 Progress Week 3 Notes from Week 4 Progress Week 4 Complete
Complete the
thefollowing
following steps
steps to
to protect
protectthis
this spreadsheet.
spreadsheet.
1.
1. Lock/protect
Lock/protect the
the entire
entire file
file so
so that
that aapassword
password isis required
required to
to open
open the
the
workbook.
workbook.
2.
2. Lock/protect
Lock/protect the
the entire
entire first
first sheet
sheetthat
that isis named
named "Contact
"Contact
Information"
Information" so
so that
that no
no one
one can
can select
select any
any cells
cells in
inthe
the entire
entire sheet.
sheet.
3.
3. Lock/protect
Lock/protect the
the entire
entire second
second sheet
sheet that
that isis named
named "Debt
"Debt List"
List" and
and
then
hide
the
sheet
so
it
is
not
visible.
then hide the sheet so it is not visible.
4.
4. Lock/protect
Lock/protect the
the entire
entire third
third sheet
sheet that
thatisis named
named"Personal
"Personal
Problems"
Problems" but
butleave
leaveititvisible
visible(do
(do not
not hide
hideit).
it).
5.
5. Select
Select the
the boxes
boxes for
for text
text on
on the
the "Updates"
"Updates" sheet.
sheet. Make
Makesure
sure that
that
when
you
lock
the
sheet
that
these
are
still
"unlocked"
so
that
when you lock the sheet that these are still "unlocked" so that you
you can
can
type
type in
in them.
them. Depending
Depending on
on your
your version
version of
of aa spreadsheet
spreadsheet this
this may
may be
be
diferent.
diferent. Look
Look at
atthe
the help
help on
on your
your spreadsheet
spreadsheettool
tool to
to find
find out
out how
how to
to
leave
leavesome
some cells
cells open
open for
for editing.
editing.

Attachments:

• 1493357535-Assignment 4.xlsx