1
Microsoft Office Specialist Exam - Excel Questions with
Answers (100% Correct Answers)
Import .txt or .cvs Data Into A New Workbook Answer: File —> Open
—> Browse —> Change The Data Type To All Files —> Find Text
Document —> Text Import Wizard —> Delimited —> Tick My Data
Has Headers —> Finish
White Gap Between The Words = Tab In There
Import .txt or .cvs Data Into An Existing Workbook Answer: Select The
Cell Where You Want The Worksheet To Come In From —> Select
Data —> From Text/CSV —> Select File —> Import —> Preview
Window —> Load To —> Import Data Window —> Table —> Existing
Worksheet (= Cell) —> Ok
Find Data Within A Workbook Answer: Control + F —> Find and
Replace Window —> Find —> Find What: _____ (Doesn't Matter If It's
Upper or Lower Case, As Long As The Match Case Is Not Selected) —>
Search Within Workbook —> Find Next
© 2025 All rights reserved
,2
Replace Data Within A Workbook Answer: Control + F —> Find and
Replace Window —> Replace —> Find What: _____ —> Replace With:
_____ —> Replace All
See All The Worksheet At The Same Time Answer: On The Vertical
Dotted Lines (Bottom Of Excel) and Hold The Mouse Down = Decrease
The Width of The Scroll Bar
Create Data With Named Ranges Answer: Select All The Data On The
Column You Want Named Or Click On The Cell You Want Named —>
Type In The Name Box: _____ (Cannot Begin With A Number) —>
Enter
Insert Hyperlinks Answer: Select The Cell —> Right-Click —> Link —>
Place In This Document —> Click The Defined Name —> Ok
Edit Or Remove Hyperlinks Answer: Right-Click On The Cell With
The Hyperlink —> Edit or Remove Link
Link An Object Such As A Logo Graphic To A Named Range Answer:
Insert —> Link —> Place In This Document —> Select The Named
Range Listen Under Defined Names
© 2025 All rights reserved
, 3
Modify Page Setup Answer: Page Layout —> Orientation (Change To
Landscape For More Space) —> Dashed Vertical Line (Where The
Current Page Break Is) —> Margins —> Narrow (Gives Us More Space
On The Right and Left Side)
Manually Insert A Page Break Answer: Page Layout —> Click On The
Left Side of The Row To Select It —> Breaks —> Insert Page Break
Adjust Column Width Answer: Click On The Column Between A and
B —> Double Click (Automatically Increases That Width To The
Longest Length of Text In The Column) —> OR —> Hold The Mouse
Down —> Drag
Select A Column To A Specific Width Answer: Home —> Format —>
Column Width —> Type In The Width —> Enter
Adjust Row Height Answer: Select Rows —> Home —> Format —>
Row Height —> Type In The Height —> Enter
Add New Workbook Answer: + Sign (Bottom of Excel) —> Double
Click —> Rename —> Drag To Move It
Tab Colour Answer: Right-Click On The Tab—> Tab Colour
© 2025 All rights reserved
Microsoft Office Specialist Exam - Excel Questions with
Answers (100% Correct Answers)
Import .txt or .cvs Data Into A New Workbook Answer: File —> Open
—> Browse —> Change The Data Type To All Files —> Find Text
Document —> Text Import Wizard —> Delimited —> Tick My Data
Has Headers —> Finish
White Gap Between The Words = Tab In There
Import .txt or .cvs Data Into An Existing Workbook Answer: Select The
Cell Where You Want The Worksheet To Come In From —> Select
Data —> From Text/CSV —> Select File —> Import —> Preview
Window —> Load To —> Import Data Window —> Table —> Existing
Worksheet (= Cell) —> Ok
Find Data Within A Workbook Answer: Control + F —> Find and
Replace Window —> Find —> Find What: _____ (Doesn't Matter If It's
Upper or Lower Case, As Long As The Match Case Is Not Selected) —>
Search Within Workbook —> Find Next
© 2025 All rights reserved
,2
Replace Data Within A Workbook Answer: Control + F —> Find and
Replace Window —> Replace —> Find What: _____ —> Replace With:
_____ —> Replace All
See All The Worksheet At The Same Time Answer: On The Vertical
Dotted Lines (Bottom Of Excel) and Hold The Mouse Down = Decrease
The Width of The Scroll Bar
Create Data With Named Ranges Answer: Select All The Data On The
Column You Want Named Or Click On The Cell You Want Named —>
Type In The Name Box: _____ (Cannot Begin With A Number) —>
Enter
Insert Hyperlinks Answer: Select The Cell —> Right-Click —> Link —>
Place In This Document —> Click The Defined Name —> Ok
Edit Or Remove Hyperlinks Answer: Right-Click On The Cell With
The Hyperlink —> Edit or Remove Link
Link An Object Such As A Logo Graphic To A Named Range Answer:
Insert —> Link —> Place In This Document —> Select The Named
Range Listen Under Defined Names
© 2025 All rights reserved
, 3
Modify Page Setup Answer: Page Layout —> Orientation (Change To
Landscape For More Space) —> Dashed Vertical Line (Where The
Current Page Break Is) —> Margins —> Narrow (Gives Us More Space
On The Right and Left Side)
Manually Insert A Page Break Answer: Page Layout —> Click On The
Left Side of The Row To Select It —> Breaks —> Insert Page Break
Adjust Column Width Answer: Click On The Column Between A and
B —> Double Click (Automatically Increases That Width To The
Longest Length of Text In The Column) —> OR —> Hold The Mouse
Down —> Drag
Select A Column To A Specific Width Answer: Home —> Format —>
Column Width —> Type In The Width —> Enter
Adjust Row Height Answer: Select Rows —> Home —> Format —>
Row Height —> Type In The Height —> Enter
Add New Workbook Answer: + Sign (Bottom of Excel) —> Double
Click —> Rename —> Drag To Move It
Tab Colour Answer: Right-Click On The Tab—> Tab Colour
© 2025 All rights reserved
