CGS 2518 EXAM QUESTIONS
AND CORRECT ANSWERS
UPDATED 2026/2027
IngMicrosoftgExcel,gthegfilegyougcreategandgeditgisgcalledga:g-gCORRECTgANSWER-Workbook
Bygdefault,gExcelg2021gfilesgaregsavedgwithgthisgextension.g-gCORRECTgANSWER-.xlsx
Textgingagworksheetgthatgdisplaysgagname,gagmaingtitle,growgorgcolumngtitles,gandgsimilargdescriptiveginfor
mationgisgcalledga(n):g-gCORRECTgANSWER-label
Whengyougclickgongagcellgtogactivategit,gthegcellgaddressgappearsgingthe:g-gCORRECTgANSWER-namegbox
Whengyougwantgtogdeletegcharactersgingagcellgtogthegleftgofgtheginsertiongpointgpress:g-gCORRECTgANSWER-
Backspace
AgnewgExcelgworkbookgusesgthegdefaultgthemegnamed:g-gCORRECTgANSWER-Office
AgrectangularggroupgofgcellsgingExcelgisga(n):g-gCORRECTgANSWER-Range
Thegthingblackgplusgsigngpointergisgusedgto:g-gCORRECTgANSWER-Copygcellgcontentsgorgcompletegagseries.
Togquicklygselectgallgthegcellsgingagworksheet:g-gCORRECTgANSWER-PressgCtrl+A
Aftergyougselectgandgcutgcells,gthegcellsgaregplaced:g-gCORRECTgANSWER-OngthegClipboard
IngangExcelgworksheetgdatesgandgtimesgare:g-gCORRECTgANSWER-Values
, Whengyougwantgcolumngandgrowgheadingsgdisplayedgwhethergyougaregatgthegtop,gbottom,gleft,gorgrightgofg
thegspreadsheet,gselect:g-gCORRECTgANSWER-FreezegPanes
Usegthisgbuttongtogcombinegtwogorgmoregcellsgintogonegcellgandgcentergthegtextgovergaggroupgofgcolumns.g-
gCORRECTgANSWER-Mergeg&gCenter
Agquickgwaygtoginsertgagnewgcolumngorgrowgingangexistinggworksheetgisgtogselectgagcolumngorgrowgandgpres
s:g-gCORRECTgANSWER-Ctrl+plusgsigng(+)
ThegdefaultgviewgingExcelgis:g-gCORRECTgANSWER-Normal
ThisgExcelgfeaturegallowsgusersgtogusegcommongarithmeticgoperationsgtogperformgagcalculation:g-
gCORRECTgANSWER-Formulas
ThisgsymbolgalertsgExcelgthatgyougaregenteringgagformulagandgnotgtext:g-gCORRECTgANSWER-=
Thegcolor-
codedgeditinggtoolgthatgappliesgdifferentgcolorsgtogeachgcellgorgcellgrangegincludedgwithingagformulagisgcalle
dgthe:g-gCORRECTgANSWER-RangegFinder
Whengagformulagcontainsgagsyntaxgerror,gsuchgasgspellinggagfunctiongnamegincorrectly,gusinggangincorrectg
operatorgsymbol,ghavinggthegwronggnumbergofgarguments,gandgsogon,gitgreturns:g-gCORRECTgANSWER-
Angerrorgmessagegthatgbeginsgwithgagnumbergsigng(#)
ThegExcelgtoolgbuttongthatgallowsgyougtogstepgthroughgeachgpartgofgagformulagisgcalled:g-
gCORRECTgANSWER-EvaluategFormula
Whengyougcopygagformulagwithgagrelativegcellgreference,gthegcopiedgcellgreferencegis:g-gCORRECTgANSWER-
Relative
Thisgtypegofgcellgreferencegdoesgnotgchangegwhengcopiedgandgremainsgingagfixedgpositiongduringgoperation
s.g-gCORRECTgANSWER-Absolute
AND CORRECT ANSWERS
UPDATED 2026/2027
IngMicrosoftgExcel,gthegfilegyougcreategandgeditgisgcalledga:g-gCORRECTgANSWER-Workbook
Bygdefault,gExcelg2021gfilesgaregsavedgwithgthisgextension.g-gCORRECTgANSWER-.xlsx
Textgingagworksheetgthatgdisplaysgagname,gagmaingtitle,growgorgcolumngtitles,gandgsimilargdescriptiveginfor
mationgisgcalledga(n):g-gCORRECTgANSWER-label
Whengyougclickgongagcellgtogactivategit,gthegcellgaddressgappearsgingthe:g-gCORRECTgANSWER-namegbox
Whengyougwantgtogdeletegcharactersgingagcellgtogthegleftgofgtheginsertiongpointgpress:g-gCORRECTgANSWER-
Backspace
AgnewgExcelgworkbookgusesgthegdefaultgthemegnamed:g-gCORRECTgANSWER-Office
AgrectangularggroupgofgcellsgingExcelgisga(n):g-gCORRECTgANSWER-Range
Thegthingblackgplusgsigngpointergisgusedgto:g-gCORRECTgANSWER-Copygcellgcontentsgorgcompletegagseries.
Togquicklygselectgallgthegcellsgingagworksheet:g-gCORRECTgANSWER-PressgCtrl+A
Aftergyougselectgandgcutgcells,gthegcellsgaregplaced:g-gCORRECTgANSWER-OngthegClipboard
IngangExcelgworksheetgdatesgandgtimesgare:g-gCORRECTgANSWER-Values
, Whengyougwantgcolumngandgrowgheadingsgdisplayedgwhethergyougaregatgthegtop,gbottom,gleft,gorgrightgofg
thegspreadsheet,gselect:g-gCORRECTgANSWER-FreezegPanes
Usegthisgbuttongtogcombinegtwogorgmoregcellsgintogonegcellgandgcentergthegtextgovergaggroupgofgcolumns.g-
gCORRECTgANSWER-Mergeg&gCenter
Agquickgwaygtoginsertgagnewgcolumngorgrowgingangexistinggworksheetgisgtogselectgagcolumngorgrowgandgpres
s:g-gCORRECTgANSWER-Ctrl+plusgsigng(+)
ThegdefaultgviewgingExcelgis:g-gCORRECTgANSWER-Normal
ThisgExcelgfeaturegallowsgusersgtogusegcommongarithmeticgoperationsgtogperformgagcalculation:g-
gCORRECTgANSWER-Formulas
ThisgsymbolgalertsgExcelgthatgyougaregenteringgagformulagandgnotgtext:g-gCORRECTgANSWER-=
Thegcolor-
codedgeditinggtoolgthatgappliesgdifferentgcolorsgtogeachgcellgorgcellgrangegincludedgwithingagformulagisgcalle
dgthe:g-gCORRECTgANSWER-RangegFinder
Whengagformulagcontainsgagsyntaxgerror,gsuchgasgspellinggagfunctiongnamegincorrectly,gusinggangincorrectg
operatorgsymbol,ghavinggthegwronggnumbergofgarguments,gandgsogon,gitgreturns:g-gCORRECTgANSWER-
Angerrorgmessagegthatgbeginsgwithgagnumbergsigng(#)
ThegExcelgtoolgbuttongthatgallowsgyougtogstepgthroughgeachgpartgofgagformulagisgcalled:g-
gCORRECTgANSWER-EvaluategFormula
Whengyougcopygagformulagwithgagrelativegcellgreference,gthegcopiedgcellgreferencegis:g-gCORRECTgANSWER-
Relative
Thisgtypegofgcellgreferencegdoesgnotgchangegwhengcopiedgandgremainsgingagfixedgpositiongduringgoperation
s.g-gCORRECTgANSWER-Absolute
