MICROSOFT OFFICE SPECIALIST EXCEL EXAM QUESTIONS AND ANSWERS

MICROSOFT OFFICE SPECIALIST EXCEL EXAM QUESTIONS AND ANSWERS
Import .txt or .cvs Data Into A New Workbook - CORRECT 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 - CORRECT 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 - CORRECT 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



Replace Data Within A Workbook - CORRECT ANSWER✅✅Control + F —> Find and Replace Window —>
Replace —> Find What: _____ —> Replace With: _____ —> Replace All



See All The Worksheet At The Same Time - CORRECT 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 - CORRECT 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 - CORRECT ANSWER✅✅Select The Cell —> Right-Click —> Link —> Place In This
Document —> Click The Defined Name —> Ok



Edit Or Remove Hyperlinks - CORRECT 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 - CORRECT ANSWER✅✅Insert —> Link —>
Place In This Document —> Select The Named Range Listen Under Defined Names

, Modify Page Setup - CORRECT 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 - CORRECT ANSWER✅✅Page Layout —> Click On The Left Side of The
Row To Select It —> Breaks —> Insert Page Break



Adjust Column Width - CORRECT 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 - CORRECT ANSWER✅✅Home —> Format —> Column Width —>
Type In The Width —> Enter



Adjust Row Height - CORRECT ANSWER✅✅Select Rows —> Home —> Format —> Row Height —> Type
In The Height —> Enter



Add New Workbook - CORRECT ANSWER✅✅+ Sign (Bottom of Excel) —> Double Click —> Rename —>
Drag To Move It



Tab Colour - CORRECT ANSWER✅✅Right-Click On The Tab—> Tab Colour



View Header and Footer Window - CORRECT ANSWER✅✅Insert —> Text —> Header & Footer



Built-In Header Headers Title Came From - CORRECT ANSWER✅✅File —> Info —> Properties —>
Advanced Properties



Create Custom Headers - CORRECT ANSWER✅✅Design —> Header —> Built-In Headers —> Select The
Ones You Want



Create Custom Footers - CORRECT ANSWER✅✅Design —> Go To Footer —> Select The Ones You Want