Toggle navigation
Toggle navigation
Classes
Quizzes
Subjects
Login
Register
Go
Microsoft Excel
|
Take A Quiz
Toggle navigation
Classes
Quizzes
Subjects
Go
Login
|
Register
Microsoft Excel
Take a practice test
7 Quiz Set/s
Microsoft Excel
7 Quiz Sets
Microsoft Excel
Prove It - Microsoft Excel Test
Can you answer
25
questions in 10 minutes?
Prove It - Microsoft Excel Test |
1. Renaming A Worksheet
Double-click The Sheet 1 Tab. Type "Title" - Then Press Enter.
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Select Custom Margins. Check The Boxes Next To Horizontally And Vertically. Click Ok.
Click The Align Right Button.
Click The Sort & Filter Button Then Click Custom Sort. Click The Sort By Drop-down Arrow Then Click Time To Reorder? Click The Order Drop-down Arrow Then Click Z To A. Click The Add Level Button. Click The Then By Drop-down Arrow Then Click Quantity In Reorder. Click The Ok Button.
2. Sort: Sort The Selected Cells By Last Name - In Ascending Order
Right-click Task Name Then Click Add To Column Labels.
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Select Custom Margins. Check The Boxes Next To Horizontally And Vertically. Click Ok.
Click The Data Tab - Then Click The Text To Columns Button. Click The Next Button. Uncheck The Tab Checkbox. Click The Other Checkbox - Then Type ":" Into The Other Field. Click The Next Button. Click The Finish Button.
Click The Sort & Filter Drop-down Menu Then Sort A To Z.
3. Margins: Change The Page Margins To Wide Or Where The Top - Left - Bottom - And Right Margin Is At 1"
Type "-concatenate(A2 - B2)"And Press The Enter Key.
Double-click The Sheet 1 Tab. Type "Title" - Then Press Enter.
Click The Insert Button. Choose Row.
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Wide.
4. Custom Sort: Sort The Selected Cells By Time To Reorder? (In Z To A Order) And Then Quantity In Reorder (Smallest To Largest)
Double-click The Sheet 1 Tab. Type "Title" - Then Press Enter.
Click The Bold Button.
Click The Insert Button. Choose Row.
Click The Sort & Filter Button Then Click Custom Sort. Click The Sort By Drop-down Arrow Then Click Time To Reorder? Click The Order Drop-down Arrow Then Click Z To A. Click The Add Level Button. Click The Then By Drop-down Arrow Then Click Quantity In Reorder. Click The Ok Button.
5. Paste Special: Copy The Selected Cells And Paste With Actual Values
Click The Save Button.
Click The Border Drop-down Arrow - Then Select All Borders.
Click The Copy Button. Click The Paste Drop-down Menu Then Click Values.
Click The Fill Handle And Continue To Hold Down The Mouse Button. While Holding Down The Mouse Button - Drag The Mouse To Cell G11 - Then Release The Mouse Button.
6. Select Multiple Worksheets: Select Worksheets Option 1 - Option 2 - And Option 3
Click The Bold Button.
While Holding Down The Shift Key - Click The Option 3 Tab.
While Holding Down The Ctrl Key - Click Cell C2.
Click The Sort & Filter Button Then Click Custom Sort. Click The Sort By Drop-down Arrow Then Click Time To Reorder? Click The Order Drop-down Arrow Then Click Z To A. Click The Add Level Button. Click The Then By Drop-down Arrow Then Click Quantity In Reorder. Click The Ok Button.
7. Convert Text To Columns: The Selected Column Contains A List Of Airport Codes And The Location On The Airport. Split The Selected Column - Using The Common Delimiter - A Colon (:) - So That The Airport Codes Are In Column K And The Airport Locations Are In Column L
Click The Page Layout Tab. Click The Orientation Drop-down Menu - Then Landscape.
Click The Data Tab - Then Click The Text To Columns Button. Click The Next Button. Uncheck The Tab Checkbox. Click The Other Checkbox - Then Type ":" Into The Other Field. Click The Next Button. Click The Finish Button.
Click The Formulas Tab - Then The Autosum Button. Click The Autosum Button Again.
Click The Bold Button.
8. Page Orientation: Change The Orientation Of This Worksheet To Landscape
Click The Page Layout Tab. Click The Orientation Drop-down Menu - Then Landscape.
While Holding Down The Ctrl Key - Click Cell C2.
Double-click The Sheet 1 Tab. Type "Title" - Then Press Enter.
Click The Design Tab. Click The More Arrow In The Chart Styles Section. Click Style 8.
9. Select Non-contiguous Cells: Select Cells G2 And C2 Without Selecting Cells D2 - E2 - And F2
While Holding Down The Ctrl Key - Click Cell C2.
Type "-concatenate(A2 - B2)"And Press The Enter Key.
Click The Insert Tab. Click The Text Drop-down Menu And Then The Header & Footer Button. Click The Footer Drop-down Menu Then Page 1.
Click The Page Layout Tab. Click The Orientation Drop-down Menu - Then Landscape.
10. Create Pivotchart: Using The Current Worksheet's Selected Data - Create A Pivotchart That Displays The Project Name And Time In Hours
Click The Formulas Tab - Then The Autosum Button. Click The Autosum Button Again.
Click The Insert Tab. Click The Pivotchart Drop-down Arrow Then Click Pivotchart. Click The Ok Button. Click The Project Name Checkbox Then The Time In Hours Checkbox.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
Click The View Tab. Click The Top Half Of The Macros Button. Click The Run Button.
11. Paste A Function
Click The Paste Button.
Click The Page Layout Tab. Click The Page Setup Dialog Box Launcher. Click The Fit To: 1 Page(S) Wide By 1 Tall Radio Button. Click The Ok Button.
Click The Page Layout Tab. Click The Print Area Button Then Click Set Print Area.
Click The Sort & Filter Button Then Click Filter.
12. Turn On Autofilter: Turn On The Autofilter Feature For The Selected Cells
Click The Align Right Button.
Click The Paste Button.
Click Review Tab. Click The Spelling Button. Click The Change Button.
Click The Sort & Filter Button Then Click Filter.
13. Print Centered On Page: Perform The Commands To Center The Selected Worksheets Both Horizontally And Vertically On The Printed Page.
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Select Custom Margins. Check The Boxes Next To Horizontally And Vertically. Click Ok.
While Holding Down The Shift Key - Click The Option 3 Tab.
Click The Page Layout Tab. Click The Orientation Drop-down Menu - Then Landscape.
Select Column F. Click The Insert Button.
14. Print Worksheet
Click On The Format As Table Button. Click Table Style Light 2. Click The Ok Button.
Click The File Tab. Click The File Name.
Click Review Tab. Click The Spelling Button. Click The Change Button.
Click The File Tab - Then Select Print. Click The Print Button.
15. Use Average Function
Click The File Tab. Click The File Name.
Click The Task Name Drop-down Arrow. Click The Vacation Checkbox. Click The Ok Button.
Select The Formulas Tab - Click The Autosum Drop-down Arrow - Then Click Average. Press Enter.
Right-click Task Name Then Click Add To Column Labels.
16. Create A Macro: Using The Macro Recorder - Record A Macro That Will Type "800-555-5555" In The Current Cell. The Macro Name Is "Phone" And The Shortcut-key To Assign To The Macro Is "Ctrl+e"
Click The Formulas Tab - Then Click The Lookup & Reference Button Then Click Vlookup. Type "E2" Into The Lookup_value Field. Click The Table_array Field And Type "K:L". Click The Col_index_num Field And Type "2". Click The Range_lookup Field And Type "False". Click The Ok Button.
While Holding Down The Ctrl Key - Click Cell C2.
Click The View Tab. Click The Macros Drop-down Arrow Then Click Record Macro. Type "Phone" In The Macro Name Field - Then Press Tab - Then Type "E" In The Shortcut Key Field. Click The Ok Button. In Cell A1 - Type "800-555-5555" And Press The Enter Key. Click The Macros Drop-down Menu - Then Click Stop Recording Macro.
Click The Column D Drop-down Arrow. Click The Select All Checkbox. Click The Design Checkbox Then Click The Ok Button.
17. Print Scaling
Click The Sort & Filter Button Then Click Filter.
Click The Insert Button. Choose Row.
Click The Copy Button.
Click The Page Layout Tab. Click The Page Setup Dialog Box Launcher. Click The Fit To: 1 Page(S) Wide By 1 Tall Radio Button. Click The Ok Button.
18. Hide Column
Click The Formulas Tab - Then Click The Lookup & Reference Button Then Click Vlookup. Type "E2" Into The Lookup_value Field. Click The Table_array Field And Type "K:L". Click The Col_index_num Field And Type "2". Click The Range_lookup Field And Type "False". Click The Ok Button.
Click The Design Tab. Click The More Arrow In The Chart Styles Section. Click Style 8.
Click The View Tab. Click The Top Half Of The Macros Button. Click The Run Button.
Click The Format Button. Place Your Mouse Over Hide & Unhide - Then Click Hide Columns On The Drop Down Menu.
19. Insert Page Break: Without Changing The View - Insert A Page Break For The Selected Sheets Above Row 21
While Holding Down The Shift Key - Click The Option 3 Tab.
Click The Copy Button. Click The Paste Drop-down Menu Then Click Values.
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Wide.
Click Row 21. Click The Page Layout Tab. Click The Breaks Drop-down Arrow Then Click Insert Page Break.
20. Insert Chart
Click The Design Tab. Click The More Arrow In The Chart Styles Section. Click Style 8.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
Click The Conditional Formatting Button. Select Highlight Cells Rules Then Click Equal To. Type "Yes". Click The Ok Button.
While Holding Down The Ctrl Key - Click Cell C2.
21. Cell References: Divide F2 By F76. Use A Relative Reference For Cell F2 And A Mixed Cell Reference To Refer To The Row For Cell F76
Click The Copy Button.
In Cell G2 - Type "=F2/F$76" And Press The Enter Key.
Click The View Tab. Click The Freeze Panes Button - Then Select Freeze Top Row.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
22. Create Pivottable: Using The Current Worksheet's Data - Create A Report That Displays The Quarterly Sales By Territory
Click The Copy Button. Click The Paste Drop-down Menu Then Click Values.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
Click The Sort & Filter Button Then Click Custom Sort. Click The Sort By Drop-down Arrow Then Click Time To Reorder? Click The Order Drop-down Arrow Then Click Z To A. Click The Add Level Button. Click The Then By Drop-down Arrow Then Click Quantity In Reorder. Click The Ok Button.
Click The Insert Tab. Click Down The Tables Drop-down Menu - And Then The Pivot Table Button. Click The Ok Button. Click The Territory Checkbox. Click The Quarterly Sales Checkbox.
23. Sum Function
Click The File Tab. Click The File Name.
Click The Formulas Tab - Then The Autosum Button. Click The Autosum Button Again.
Click The Merge & Center Button.
While Holding Down The Ctrl Key - Click Cell C2.
24. Merge And Center Cells
Click The Wrap Text Button.
Click The Save Button.
Click The Merge & Center Button.
Click The Align Right Button.
25. Change The Chart Style To Style 8
Click The Fill Handle And Continue To Hold Down The Mouse Button. While Holding Down The Mouse Button - Drag The Mouse To Cell G11 - Then Release The Mouse Button.
Click The Data Tab - Then Click The Text To Columns Button. Click The Next Button. Uncheck The Tab Checkbox. Click The Other Checkbox - Then Type ":" Into The Other Field. Click The Next Button. Click The Finish Button.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
Click The Design Tab. Click The More Arrow In The Chart Styles Section. Click Style 8.
Please login/register to bookmark chapters.
Subjects
Aptitude
Basic Life Skills
High School
Elementary School
Entrance and Placement Exams
Jobs and Occupations
Information Technology
Certifications
Business Skills
Trades and Vocational
Languages
English
Healthcare
Math
Science and Technology
Education Standards and Boards
Humanities
Law
Explore
Browse Fatskills by topics
All Subjects on Fatskills
Popular Tests on Fatskills
Fatskills Community
About Fatskills
Privacy Policy
Terms of Use
Bighow News
|
Truho
|
The Success Manual
Please report any error in fatskills quizzes and questions to 'simpleversity at gmail.com'.
Without work one finishes nothing. - Ralph Waldo Emerson
© The
Simple
Project 2019