27/01/2026,z907:2 t
3
Otherz 9 z 9 Computerz9Skills z 9 Save
MISYz95325z9Excelz9Midtermz9Ultimatez9Review
z 9 Leavez9thez9firstz9rating
Studentsz9alsoz9 studied
z9 z9 z9 z9 z9 z9
z9 z9
C
Termsz9inz9thisz9setz9(1029)
Az9ctrlz9keyz9shouldz9bez9pressedz9ifz9usersz9wantz9toz9 TRUE
selectz9cellsz9orz9az9rangez9ofz9cellsz9whichz9arez9not
z9adjacent.
Toz9properlyz9movez9az9chartz9toz9anotherz9worksh C.
eet,z9youz9shouldz9usez9thez9function movez9chart
_________________________ movez9chart
Ifz9usersz9enterz9thez9functionsz9correctly,z9thez9function TRUE
sz9SUMIFz9andz9DSUMz9shouldz9returnz9thez9samez9r
esult.
Whichz9ofz9thez9followingz9ofz9cellz9referencez9willz9not B.z9$A$1z9(Absolutez9Reference)
z9changez9whenz9thez9formulaz9wasz9copiedz9andz9paste
dz9inz9anotherz9cell?
Whichz9onez9ofz9thez9followingz9statementz9isz9NOTz9tr C.z9Oncez9thez9Tablez9functionz9isz9appliedz9onz9thez9data,z9therez9isz9noz9wayz9
uez9aboutz9thez9functionz9Table? toz9convertz9itz9back.
(Thez9abovez9statementz9isz9FALSE/NOTz9TRUE)
Toz9displayz9thez9formulaz9inz9az9worksheet,z9az9userz9sho C.z9Ctrlz9+z9Accent
uldz9press
____________
Thez9PVz9functionz9isz9usuallyz9usedz9toz9calculatez9thez TRUE
9endingz9balancez9ofz9thez9loanz9inz9anz9amortization
z9schedule.
Thez9functionz9Hidez9willz9allowz9usersz9toz9hidez9thez9c FALSE
olumn,z9butz9notz9row.
https://quizlet.com/625251514/misy-5325-excel-midterm-ultimate-review-flash-cards/ 1/13
, 27/01/2026,z907:2 t
3
Lindaz9depositsz9200z9intoz9az9bankz9everyz9month.z9Thez C.z9=z9-FV(6%/12,z94*12,z9200)
9annualz9interestz9ratez9isz96%.z9Shez9depositsz9thez9mon
eyz9forz94z9years. [withz9az9minusz9–z9signz9beforez9thez9futurez9value]
Whichz9onez9ofz9thez9followingz9isz9thez9functionz9toz9
calculatez9thez9moneyz9shez9wouldz9havez9atz9thez9endz
9ofz9thez9fourthz9year?
Typically,z9thez9functionz9Autosumz9shouldz9notz9bez9used TRUE
z9to
findz9thez9totalz9forz9az9columnz9containingz9dataz9inz9perc
entage.
Thez9functionz9Hidez9willz9allowz9usersz9toz9hidez9thez9col FALSE
umn,z9butz9notz9row.
Lindaz9depositsz9200z9intoz9az9bankz9everyz9month.z9Thez
9annualz9interestz9ratez9isz96%.z9Shez9depositsz9thez9mon
eyz9forz94z9years.
Whichz9onez9ofz9thez9followingz9isz9thez9functionz9toz9
calculatez9thez9moneyz9shez9wouldz9havez9atz9thez9endz
9ofz9thez9fourthz9year?
(Excel)z9TRUE/FALSE: TRUE
Toz9addz9az9piez9chart,z9firstz9selectz9thez9dataz9toz9bez
9chartedz9andz9thenz9tapz9orz9clickz9thez9Insertz9Piez9o
rz9Doughnutz9Chartz9buttonz9(INSERTz9tabz9|z9Chartsz
9group).
(Excel)z9TRUE/FALSE: FALSE
Toz9usez9thez9AutoCalculatez9area,z9selectz9thez9rangez9
ofz9cellsz9containingz9thez9numbersz9forz9az9calculation
z9youz9wantz9toz9verifyz9andz9thenz9pressz9andz9holdz
9orz9double-clickz9the
AutoCalculatez9areaz9toz9displayz9thez9Customizez9Statusz
9Barz9shortcutz9menu.
(Excel)z9TRUE/FALSE: TRUE
Thez9Microsoftz9Officez9Specialistz9(MOS)z9programz9p
rovidesz9anz9opportunityz9forz9youz9toz9obtainz9proofz9
thatz9youz9havez9thez9Excelz92013z9skillsz9requiredz9
byz9employers.
(Excel)z9TRUE/FALSE: TRUE
Youz9canz9clearz9cellz9contentsz9andz9formattingz9byz9ta
ppingz9orz9clickingz9Clearz9Contentsz9onz9thez9Clearz9b
uttonz9menu.
(Excel)z9TRUE/FALSE: TRUE
Thez9 equalz9signz9(=)z9 precedesz9az9formula.
https://quizlet.com/625251514/misy-5325-excel-midterm-ultimate-review-flash-cards/ 2/13
3
Otherz 9 z 9 Computerz9Skills z 9 Save
MISYz95325z9Excelz9Midtermz9Ultimatez9Review
z 9 Leavez9thez9firstz9rating
Studentsz9alsoz9 studied
z9 z9 z9 z9 z9 z9
z9 z9
C
Termsz9inz9thisz9setz9(1029)
Az9ctrlz9keyz9shouldz9bez9pressedz9ifz9usersz9wantz9toz9 TRUE
selectz9cellsz9orz9az9rangez9ofz9cellsz9whichz9arez9not
z9adjacent.
Toz9properlyz9movez9az9chartz9toz9anotherz9worksh C.
eet,z9youz9shouldz9usez9thez9function movez9chart
_________________________ movez9chart
Ifz9usersz9enterz9thez9functionsz9correctly,z9thez9function TRUE
sz9SUMIFz9andz9DSUMz9shouldz9returnz9thez9samez9r
esult.
Whichz9ofz9thez9followingz9ofz9cellz9referencez9willz9not B.z9$A$1z9(Absolutez9Reference)
z9changez9whenz9thez9formulaz9wasz9copiedz9andz9paste
dz9inz9anotherz9cell?
Whichz9onez9ofz9thez9followingz9statementz9isz9NOTz9tr C.z9Oncez9thez9Tablez9functionz9isz9appliedz9onz9thez9data,z9therez9isz9noz9wayz9
uez9aboutz9thez9functionz9Table? toz9convertz9itz9back.
(Thez9abovez9statementz9isz9FALSE/NOTz9TRUE)
Toz9displayz9thez9formulaz9inz9az9worksheet,z9az9userz9sho C.z9Ctrlz9+z9Accent
uldz9press
____________
Thez9PVz9functionz9isz9usuallyz9usedz9toz9calculatez9thez TRUE
9endingz9balancez9ofz9thez9loanz9inz9anz9amortization
z9schedule.
Thez9functionz9Hidez9willz9allowz9usersz9toz9hidez9thez9c FALSE
olumn,z9butz9notz9row.
https://quizlet.com/625251514/misy-5325-excel-midterm-ultimate-review-flash-cards/ 1/13
, 27/01/2026,z907:2 t
3
Lindaz9depositsz9200z9intoz9az9bankz9everyz9month.z9Thez C.z9=z9-FV(6%/12,z94*12,z9200)
9annualz9interestz9ratez9isz96%.z9Shez9depositsz9thez9mon
eyz9forz94z9years. [withz9az9minusz9–z9signz9beforez9thez9futurez9value]
Whichz9onez9ofz9thez9followingz9isz9thez9functionz9toz9
calculatez9thez9moneyz9shez9wouldz9havez9atz9thez9endz
9ofz9thez9fourthz9year?
Typically,z9thez9functionz9Autosumz9shouldz9notz9bez9used TRUE
z9to
findz9thez9totalz9forz9az9columnz9containingz9dataz9inz9perc
entage.
Thez9functionz9Hidez9willz9allowz9usersz9toz9hidez9thez9col FALSE
umn,z9butz9notz9row.
Lindaz9depositsz9200z9intoz9az9bankz9everyz9month.z9Thez
9annualz9interestz9ratez9isz96%.z9Shez9depositsz9thez9mon
eyz9forz94z9years.
Whichz9onez9ofz9thez9followingz9isz9thez9functionz9toz9
calculatez9thez9moneyz9shez9wouldz9havez9atz9thez9endz
9ofz9thez9fourthz9year?
(Excel)z9TRUE/FALSE: TRUE
Toz9addz9az9piez9chart,z9firstz9selectz9thez9dataz9toz9bez
9chartedz9andz9thenz9tapz9orz9clickz9thez9Insertz9Piez9o
rz9Doughnutz9Chartz9buttonz9(INSERTz9tabz9|z9Chartsz
9group).
(Excel)z9TRUE/FALSE: FALSE
Toz9usez9thez9AutoCalculatez9area,z9selectz9thez9rangez9
ofz9cellsz9containingz9thez9numbersz9forz9az9calculation
z9youz9wantz9toz9verifyz9andz9thenz9pressz9andz9holdz
9orz9double-clickz9the
AutoCalculatez9areaz9toz9displayz9thez9Customizez9Statusz
9Barz9shortcutz9menu.
(Excel)z9TRUE/FALSE: TRUE
Thez9Microsoftz9Officez9Specialistz9(MOS)z9programz9p
rovidesz9anz9opportunityz9forz9youz9toz9obtainz9proofz9
thatz9youz9havez9thez9Excelz92013z9skillsz9requiredz9
byz9employers.
(Excel)z9TRUE/FALSE: TRUE
Youz9canz9clearz9cellz9contentsz9andz9formattingz9byz9ta
ppingz9orz9clickingz9Clearz9Contentsz9onz9thez9Clearz9b
uttonz9menu.
(Excel)z9TRUE/FALSE: TRUE
Thez9 equalz9signz9(=)z9 precedesz9az9formula.
https://quizlet.com/625251514/misy-5325-excel-midterm-ultimate-review-flash-cards/ 2/13
