Toggle navigation
Toggle navigation
Classes
Quizzes
Subjects
Sign in
Sign up
Go
Microsoft Excel
|
Take A Quiz
Toggle navigation
Classes
Quizzes
Subjects
Go
Sign in
|
Sign up
Microsoft Excel
Take a practice test
17 Quiz Set/s
Microsoft Excel
17 Quiz Sets
Microsoft Excel
Prove It - Microsoft Excel Test
Can you answer
25
questions in 10 minutes?
Prove It - Microsoft Excel Test |
1. Fill Handle: Use The Fill Handle To Fill The Empty Cells From G3:G11
Click The Save Button.
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 View Tab. Click The Top Half Of The Macros Button. Click The Run Button.
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.
2. Concatenate: In Cell 2 - Create A Formula To Combine The Item In A2 (Ch-ad) And Inventory Id In B2 (2986) With No Space Between Them - So That C2 Lists "Ch-ad2986"
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Wide.
Click Cell A3 - Drag The Mouse To Cell F3 - And Release The Mouse Button.
While Holding Down The Shift Key - Click The Option 3 Tab.
Type "-concatenate(A2 - B2)"And Press The Enter Key.
3. Vlookup: In Cell F2 - Create A Vlookup Formula That Will Look Up The Airport Code In E2 And Display The Appropriate City Name (Using Columns K And L). Look For An Exact Match
Click The Format Button. Place Your Mouse Over Hide & Unhide - Then Click Hide Columns On The Drop Down Menu.
Click The Insert Button. Choose Row.
Click The Sort & Filter Drop-down Menu Then Sort A To Z.
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.
4. Font Style: Change The Font Style Of The Selected Cell To Bold
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 Bold Button.
Click The Align Right 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.
5. Selecting Cells: Select Cells A3 Through F3
Select The Formulas Tab - Click The Autosum Drop-down Arrow - Then Click Average. Press Enter.
Click Cell A3 - Drag The Mouse To Cell F3 - And Release The Mouse Button.
Click The Sort & Filter Button Then Click Filter.
Select Column F. Click The Insert Button.
6. Insert Chart
Click The Merge & Center Button.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
Click Cell A3 - Drag The Mouse To Cell F3 - And Release The Mouse Button.
Click The Column D Drop-down Arrow. Click The Select All Checkbox. Click The Design Checkbox Then Click The Ok Button.
7. Print Area: Set The Print Area To Contain The Selected Cells A1:C7
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 Format Button. Place Your Mouse Over Hide & Unhide - Then Click Hide Columns On The Drop Down Menu.
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 Page Layout Tab. Click The Print Area Button Then Click Set Print Area.
8. Text Alignment: Change The Alignment For The Selected Cells To The Right
Click The New Worksheet Tab.
Click The Align Right Button.
Click The Page Layout Tab. Click The Margins Drop-down Menu - Then Wide.
Type "-concatenate(A2 - B2)"And Press The Enter Key.
9. 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 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 Column D Drop-down Arrow. Click The Select All Checkbox. Click The Design Checkbox Then Click The Ok 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 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.
10. Borders: Create A Border Around The Selected Cells Using All Borders Or Outline And Inside
Click The Paste Button.
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.
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 Border Drop-down Arrow - Then Select All Borders.
11. Create A Custom List
Click The File Tab - Then Select Options. Click On The Advanced Button - Then Click The Edit Custom Lists. Click The Import Button.
Click The File Tab - Then Select Print. Click The Print Button.
In Cell G2 - Type "=F2/F$76" And Press The Enter Key.
Click The Save Button.
12. Use Average Function
Click The Insert Button. Choose Row.
Click Review Tab. Click The Spelling Button. Click The Change 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.
Select The Formulas Tab - Click The Autosum Drop-down Arrow - Then Click Average. Press Enter.
13. Sort: Sort The Selected Cells By Last Name - In Ascending Order
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 Sort & Filter Drop-down Menu Then Sort A To Z.
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 Copy Button.
14. Create Pivottable: Using The Current Worksheet's Data - Create A Report That Displays The Quarterly Sales By Territory
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.
Click The Save Button.
Click Review Tab. Click The Spelling Button. Click The Change Button.
Select The Formulas Tab - Click The Autosum Drop-down Arrow - Then Click Average. Press Enter.
15. Print Scaling
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 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 New Worksheet Tab.
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.
16. Conditional Formatting: Format The Selected Column (Column G) To Highlight Cells With "Light Red Fill With Dark Red Text" Option If The Cell Is Equal To "Yes".
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 Cell A3 - Drag The Mouse To Cell F3 - And Release The Mouse Button.
Click The Conditional Formatting Button. Select Highlight Cells Rules Then Click Equal To. Type "Yes". Click The Ok Button.
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.
17. Column Width: Change The Width Of Column F So That The Contents Automatically Fit Within The Column
Click The Formulas Tab - Then The Autosum Button. Click The Autosum Button Again.
Click The Bold Button.
Click The Copy Button.
Click The Format Drop-down Menu - Then Autofit Column Width.
18. Select Multiple Worksheets: Select Worksheets Option 1 - Option 2 - And Option 3
While Holding Down The Ctrl Key - Click Cell C2.
While Holding Down The Shift Key - Click The Option 3 Tab.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
Click The File Tab - Then Select Options. Click On The Advanced Button - Then Click The Edit Custom Lists. Click The Import Button.
19. Spell Check
Click The Copy Button.
Click Review Tab. Click The Spelling Button. Click The Change Button.
Type "-concatenate(A2 - B2)"And Press The Enter Key.
Click The Copy Button. Click The Paste Drop-down Menu Then Click Values.
20. Text Warp: Modify The Format Of The Selected Cell - So That The Text Automatically Wraps Around It.
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.
Click The Wrap Text Button.
Click The Fx Button. Click The Category Drop-down Arrow Then Click Statistical. Click Countif Then The Ok Button. Type "B:B" Into The Range Field And Press Tab. Click The Criteria Field And Type "B2". Click The Ok Button.
Click The Bold Button.
21. Insert Page Break: Without Changing The View - Insert A Page Break For The Selected Sheets Above Row 21
Click Row 21. Click The Page Layout Tab. Click The Breaks Drop-down Arrow Then Click Insert Page Break.
Click Review Tab. Click The Spelling Button. Click The Change Button.
Click The Format Drop-down Menu - Then Autofit Column Width.
Click The Formulas Tab - Then The Autosum Button. Click The Autosum Button Again.
22. Select Non-contiguous Cells: Select Cells G2 And C2 Without Selecting Cells D2 - E2 - And F2
Click The New Worksheet Tab.
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 Fx Button. Click The Category Drop-down Arrow Then Click Statistical. Click Countif Then The Ok Button. Type "B:B" Into The Range Field And Press Tab. Click The Criteria Field And Type "B2". Click The Ok Button.
While Holding Down The Ctrl Key - Click Cell C2.
23. If Statement: In Cell G2 - Create A Formula That Will Place The Word "Yes" If Cell F2 (Quantity In Stock) Is Less Than 25% Of H2 (Quantity In Reorder) Or "No" If This Condition Is Not Met
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.
Click The File Tab. Click The File Name.
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.
Click The Insert Tab. Click The Column Drop-down Menu. Click The 2-d Column Design.
24. Table Style: Change The Table Style To Table Style Light 2 (2nd Column - 1st Row)
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.
Click On The Format As Table Button. Click Table Style Light 2. Click The Ok Button.
Click The Wrap Text Button.
Click Cell A3 - Drag The Mouse To Cell F3 - And Release The Mouse Button.
25. Save
Click The Save Button.
Click The Align Right 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.
Click The Format Button. Place Your Mouse Over Hide & Unhide - Then Click Hide Columns On The Drop Down Menu.
×
Please login to subscribe
×
Subscribed Successfully
The First & Only Encyclopedia of Self Help,
Self Improvement & Career Advice
250+ Easy-to-Follow Guides
5000+ Proven Tips
13 Types of Essential Skills Covered
Get The Value of 100+ Best Books in 1 Book.
502 Pages | $3.99 | PDF / EPub, Kindle Ready
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 Career Aptitude Tests
Fatskills Community
About Fatskills
Privacy Policy
Terms of Use
Fatskills on Facebook
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 2020