MIS 112 SAR QUESTIONS WITH CORRECT
ANSWERS 2025
WouldHyouHbeHableHtoHapplyHtheH"watchHwindow"HoptionHinHmultipleHsheetsHatHtheHsameHtimeH?H-
HCORRECTHANSWERH-Yes
PleaseHreferHtoHtheHfigure.HWithinHtheH"Number"Htab,HhowHmanyHcategoriesHareHavailableHforHdisp
layingHnumbers?H-HCORRECTHANSWERH-12
WhatHcharactersHareHNOTHallowedHinHsheetHnamesH?H-HCORRECTHANSWERH-[H]
PleaseHreferHtoHtheHfigure.HHowHmanyHworksheetsHareHcontainedHinHtheHworkbookHshown?H-
HCORRECTHANSWERH-5
PleaseHreferHtoHtheHfigure.HWhatHExcelHelementHisHshownHinHtheHredHbox?
topHbarHshowingHallHinfo.H-HCORRECTHANSWERH-Ribbon
WhichHofHtheHfollowingHstatementsHisHtrue?H-HCORRECTHANSWERH-
AHworkbookHcanHhaveHmanyHworksheets.
WhichHofHtheHfollowingHisHtheHkeyboardHshortcutHthatHcreatesHaHnewHblankHworkbookHinHExcel?H-
HCORRECTHANSWERH-CtrlH+HN
PleaseHreferHtoHtheHfigure.HInHanHExcelHworksheet,HwhatHcolumnHnameHcomesHdirectlyHafterHColu
mnHZ?H-HCORRECTHANSWERH-AA
, PleaseHexamineHtheHattachedHworkbook.HGivenHtheHdataHinHSheet1,HwhichHofHtheHfollowingHstepsH
shouldHbeHfollowedHtoHobtainHtheHdataHinHSheet2H?H-HCORRECTHANSWERH-
SelectHcellsHA1HthroughHD3HinHSheet1H->HCopyH->HGoHtoHSheet2H->HPasteH->HTranspose
WhileHcomparingHtwoHsheetsHusingHtheH"ViewHSideHbyHSide"Hfeature,HthereHisHanHoptionHwhichHlet
sHyouHscrollHtheHtwoHsheetsHinHsync.HWhatHisHthatHoptionHcalledH?H-HCORRECTHANSWERH-
SynchronousHScrolling
PleaseHseeHtheHattachedHworkbook.HWhichHofHtheHfollowingHstepsHallowHyouHtoHaddHaHcommentHt
oHaHspecificHcell?H(WhenHyouHmoveHoverHtheHcellHwithHyourHmouse,HtheHcommentHwillHpopHup)H-
HCORRECTHANSWERH-ReviewH->HCommentsH->HNewHComment
HowHcanHyouHeditHtheHcontentsHofHcellH(byHenteringHcell-editHmode)?HChooseHtheHbestHanswer.H-
HCORRECTHANSWERH-AllHofHtheHoptionsHprovidedHareHcorrect
InHtheHattachedHExcelHworkbookHPS1_Comments_Calculation.xlsxH,HwhichHofHtheHfollowingHformu
lasHcanHbeHusedHtoHcalculateHSophie'sHtotalHscoreHinHbothHtheHexams?H-HCORRECTHANSWERH-
=B4+C4
YouHselectHaHcellHwithHdataH"120"HinHanHExcelHworksheetHandHpressHtheH"Delete"HkeyHonHyourHkey
board.HWhichHofHtheHfollowingHholdsHTRUE?H-HCORRECTHANSWERH-
onlyHtheHcontentsHofHtheHcellHareHremoved
WhatHisHtheHshortcutHtoHopenHtheHFindHandHReplaceHdialogHboxHwithHtheH"Find"HtabHopen?H-
HCORRECTHANSWERH-Ctrl+F
WhichHkeyboardHshortcutsHcanHbeHusedHtoHmoveHtheHactiveHcellHoneHcolunnHtoHtheHleft?H-
HCORRECTHANSWERH-LeftHarrowHorHShiftH+HTab
ANSWERS 2025
WouldHyouHbeHableHtoHapplyHtheH"watchHwindow"HoptionHinHmultipleHsheetsHatHtheHsameHtimeH?H-
HCORRECTHANSWERH-Yes
PleaseHreferHtoHtheHfigure.HWithinHtheH"Number"Htab,HhowHmanyHcategoriesHareHavailableHforHdisp
layingHnumbers?H-HCORRECTHANSWERH-12
WhatHcharactersHareHNOTHallowedHinHsheetHnamesH?H-HCORRECTHANSWERH-[H]
PleaseHreferHtoHtheHfigure.HHowHmanyHworksheetsHareHcontainedHinHtheHworkbookHshown?H-
HCORRECTHANSWERH-5
PleaseHreferHtoHtheHfigure.HWhatHExcelHelementHisHshownHinHtheHredHbox?
topHbarHshowingHallHinfo.H-HCORRECTHANSWERH-Ribbon
WhichHofHtheHfollowingHstatementsHisHtrue?H-HCORRECTHANSWERH-
AHworkbookHcanHhaveHmanyHworksheets.
WhichHofHtheHfollowingHisHtheHkeyboardHshortcutHthatHcreatesHaHnewHblankHworkbookHinHExcel?H-
HCORRECTHANSWERH-CtrlH+HN
PleaseHreferHtoHtheHfigure.HInHanHExcelHworksheet,HwhatHcolumnHnameHcomesHdirectlyHafterHColu
mnHZ?H-HCORRECTHANSWERH-AA
, PleaseHexamineHtheHattachedHworkbook.HGivenHtheHdataHinHSheet1,HwhichHofHtheHfollowingHstepsH
shouldHbeHfollowedHtoHobtainHtheHdataHinHSheet2H?H-HCORRECTHANSWERH-
SelectHcellsHA1HthroughHD3HinHSheet1H->HCopyH->HGoHtoHSheet2H->HPasteH->HTranspose
WhileHcomparingHtwoHsheetsHusingHtheH"ViewHSideHbyHSide"Hfeature,HthereHisHanHoptionHwhichHlet
sHyouHscrollHtheHtwoHsheetsHinHsync.HWhatHisHthatHoptionHcalledH?H-HCORRECTHANSWERH-
SynchronousHScrolling
PleaseHseeHtheHattachedHworkbook.HWhichHofHtheHfollowingHstepsHallowHyouHtoHaddHaHcommentHt
oHaHspecificHcell?H(WhenHyouHmoveHoverHtheHcellHwithHyourHmouse,HtheHcommentHwillHpopHup)H-
HCORRECTHANSWERH-ReviewH->HCommentsH->HNewHComment
HowHcanHyouHeditHtheHcontentsHofHcellH(byHenteringHcell-editHmode)?HChooseHtheHbestHanswer.H-
HCORRECTHANSWERH-AllHofHtheHoptionsHprovidedHareHcorrect
InHtheHattachedHExcelHworkbookHPS1_Comments_Calculation.xlsxH,HwhichHofHtheHfollowingHformu
lasHcanHbeHusedHtoHcalculateHSophie'sHtotalHscoreHinHbothHtheHexams?H-HCORRECTHANSWERH-
=B4+C4
YouHselectHaHcellHwithHdataH"120"HinHanHExcelHworksheetHandHpressHtheH"Delete"HkeyHonHyourHkey
board.HWhichHofHtheHfollowingHholdsHTRUE?H-HCORRECTHANSWERH-
onlyHtheHcontentsHofHtheHcellHareHremoved
WhatHisHtheHshortcutHtoHopenHtheHFindHandHReplaceHdialogHboxHwithHtheH"Find"HtabHopen?H-
HCORRECTHANSWERH-Ctrl+F
WhichHkeyboardHshortcutsHcanHbeHusedHtoHmoveHtheHactiveHcellHoneHcolunnHtoHtheHleft?H-
HCORRECTHANSWERH-LeftHarrowHorHShiftH+HTab
