Home
Microsoft Office Index
Excel
Word
PowerPoint
A~Z Quizzes
Computer Programming
Typing Index
Typing Speed Test
English Lessons & Practice Grammar Tests
Excel 2016
Word 2016
www.TestsTestsTests.com
Microsoft Excel FREE Resources Index Page
*45
Excel Tests & Quizzes
*
43 Excel Tutorials
*
Excel Training
*
43 Excel Tutorials with 42 Corresponding Tests
*
What is Excel?
*
What version of Excel?
*
Excel 2016 Tutorials & Excel Test Index
Free Excel Test – Using the File Tab Test – Excel 2010 – Getting Started
Using the File Tab Test
Free Online Microsoft Excel Tests
Excel 2010 – Getting Started
* Recent documents
* Pushpins
* Print
* Print Preview
* Save
* Save as
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Using the File Tab Test
1) Select which of the following lists most accurately represent functions found in the Backstage View in Excel:
a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review.
b) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print and Options.
c) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and Access.
d) None of the above lists are entirely correct.
2)
The Recent Workbooks list located in the Backstage View shows all workbooks recently opened. What action can I take to ensure a workbook remains on this list regardless of how many workbooks I opened subsequent to opening this workbook?
a) I can save the Workbook to the Recent Workbooks folder.
b) By adding the Workbook to My Favorites on the Quick Access Toolbar.
c) The Recent Workbooks list automatically keeps all workbooks that have been opened and I do not need to do anything.
d) By ‘pinning’ the workbook to the Recent Workbooks list by clicking the pin icon located next to it.
3)
John has a workbook open that his colleague created. The workbook is titled: “Management Budget”. John wants to use this workbook as a base for creating a workbook called “Project Management”. Which of the following is the correct sequence of actions for him to take?
a) File – Backstage View – Save – File Name – “Project Management” – Save.
b) File – Backstage View – Save As – File Name – “Project Management” – Save.
c) File – Backstage View – Open – File Name – “Project Management” – Open.
d) File – Backstage View – Save As – File Name – “Management Budget” – Save as Type – “Project Management”.
4)
Study the Print Preview in the image below. Which of the following statements is NOT true about how this worksheet will print?
a) It will print over 2 pages.
b) It will print in portrait orientation.
c) Sheets will be reduced to fit onto 2 sheets.
d) Sheets will be printed at their actual size.
5)
Study the image below. Which of the following actions will allow you to exit the Backstage View and continue working in the actual workbook?
a) Pressing the Home tab.
b) Pressing the Exit button.
c) Pressing the Close button.
d) All of the above options are correct.
6)
The following shortcut key combinations will allow you to Open, Close and create a New workbook, respectively:
a) Pressing Alt + O to Open, Alt + C to Close, Alt + N for New.
b) Pressing Control + O for Open, Control + C for Close, Control + N for New.
c) Pressing Control + O for Open, Control + W for Close, Control + N for New.
d) None of the above options are correct.
7)
Lucy made some changes to a workbook called “Sept 2014”. She then clicked Save As, typed “Sept_2014_New” in the File Name box and clicked Save. Which of the following statements are true?
a) The changes Lucy made to “Sept 2014” will be reflected in the new workbook, “Sept_2014_New” only.
b) The changes Lucy made will be reflected in both versions, “Sept 2014” and “Sept_2014_New”.
c) By using the Save As function Lucy replaced the file “Sept 2014” with “Sept_2014_New”. The original file no longer exists.
d) The changes Lucy made will stay in “Sept 2014” and will not be reflected in “Sept_2014_New”.
8)
Ben is using a colleague’s PC. He is curious as to how much his colleague earns and when he sees a folder with the title “Budget”, he decides to snoop. He opens the folder and views a few of the workbooks in this folder. Will his colleague be able to know he snooped, and if yes, how?
a) No, Ben is safe. Unless his colleague is an IT specialist, he will never find out.
b) Yes, if his colleague presses the Data tab on the Ribbon, this will reveal a list of recently displayed documents.
c) No, Excel automatically deletes recently access workbook and file history if you close and shutdown the PC.
d) Yes, if his colleague opens the Backstage View and go to the Recent Workbooks and Recent Places area.
9)
A client emails you and informs you that they were unable to open a workbook you sent them as they still use MS Excel 2003. Which of the following options will quickly resolve this issue and allow the client to open the workbook?
a) They will need to install MS Excel 2010 or use someone else’s software in order to open the workbook.
b) You can use the Save As function to select a Save As Type: Excel 97-2003 Workbook.
c) If you open the workbook, you can go to the client and copy and paste all the content into their version of Excel.
d) If you rename your workbook: “Excel 2003”, this will allow the client to open the file.
10)
Which of the following statements about the Print Preview is true?
a) It allows you to view what your document will look like before you physically print the pages.
b) You access the Print Preview area of the Backstage View by pressing: Control + P.
c) You access the Print Preview area by clicking on the File button to go to the Backstage View and then on the Print button.
d) All of the above statements are correct.
* More from TestsTestsTests.com
Please leave this field empty.
1. Excel Keyboard Shortcuts
6 TUTORIALS & 7 TESTS
1.
Easy Excel Shortcuts
TEST
2.
Intermediate Excel Shortcuts
TEST
3.
Keyboard Shortcuts for Worksheets
TUTORIAL
3.
Keyboard Shortcuts for Worksheets
TEST
4.
Keyboard Shortcuts for Cell Contents
TUTORIAL
4.
Keyboard Shortcuts for Cell Contents
TEST
5.
Shortcuts for Inserting & Deleting Rows,
Columns & Cells
TUTORIAL
5.
Shortcuts for Inserting & Deleting Rows,
Columns & Cells
TEST
6.
Keyboard Shortcuts for Formatting Numbers
TUTORIAL
6.
Keyboard Shortcuts for Formatting Numbers
TEST
7.
Keyboard Shortcuts for Formulas
TUTORIAL
7.
Keyboard Shortcuts for Formulas
TEST
8.
30 second Shortcuts Video Part 1
TUTORIAL
2. Getting Started in Excel
6 TUTORIALS & 7 TESTS
1.
Excel Basics
TUTORIAL
1.
Excel Basics
TEST
2.
Using the File Tab
TUTORIAL
2.
Using the File Tab
TEST
3.
The Views in Excel
TUTORIAL
3.
The Views in Excel
TEST
4.
Moving Around the Worksheet
TUTORIAL
4.
Moving Around the Worksheet
TEST
5.
Using the Ribbon Excel
TUTORIAL
5.
Using the Ribbon Excel
TEST
6.
Customizing the Quick Access Toolbar
TUTORIAL
6.
Customizing the Quick Access Toolbar
TEST
7.
The Excel Screen
TEST
3. Entering Data in Excel
4 TUTORIALS & 4 TESTS
1.
Basic Data Entry & Navigation
TUTORIAL
1.
Basic Data Entry & Navigation
TEST
2.
Copying and Pasting Excel
TUTORIAL
2.
Copying and Pasting Excel
TEST
3.
Using Autofill Excel
TUTORIAL
3.
Using Autofill Excel
TEST
4.
Formatting Text Excel
TUTORIAL
4.
Formatting Text Excel
TEST
4. Formulas & Functions
8 TUTORIALS & 8 TESTS
1.
Excel Formula Basics
TUTORIAL
1.
Excel Formula Basics
TEST
2.
Copying Formulas & using Relative &
Absolute Cell References
TUTORIAL
2.
Copying Formulas & using Relative &
Absolute Cell References
TEST
3.
Excel Formatting Numbers Basics
TUTORIAL
3.
Excel Formatting Numbers Basics
TEST
4.
Understanding Functions
TUTORIAL
4.
Understanding Functions
TEST
5.
Using IF, SUMIF and COUNTIF
TUTORIAL
5.
Using IF, SUMIF and COUNTIF
TEST
6.
Nested IFs, SUMIFs & COUNTIFs
in Functions
TUTORIAL
6.
Nested IFs, SUMIFs & COUNTIFs
in Functions
TEST
7.
Using Nested Functions
TUTORIAL
7.
Using Nested Functions
TEST
8.
Using Financial Functions Excel
TEST
8.
Using Financial Functions Excel
TUTORIAL
5. Excel Worksheets
4 TUTORIALS & 4 TESTS
1.
Excel Basic Worksheet Formatting
TUTORIAL
1.
Excel Basic Worksheet Formatting
TEST
2.
Advanced Worksheet Formatting
TUTORIAL
2.
Advanced Worksheet Formatting
TEST
3.
Protecting Worksheets Excel
TUTORIAL
3.
Protecting Worksheets Excel
TEST
4.
Working with Multiple Worksheets
TUTORIAL
4.
Working with Multiple Worksheets
TEST
6. Excel Charts
1 TUTORIAL & 1 TEST
1.
Creating & Modifying Excel Charts
TUTORIAL
1.
Creating & Modifying Excel Charts
TEST
7. Printing Excel Worksheets
2 TUTORIALS & 2 TESTS
1.
Printing Basics Excel
TUTORIAL
1.
Printing Basics Excel
TEST
2.
Printing Large Excel Worksheets
TUTORIAL
2.
Printing Large Excel Worksheets
TEST
8. Macros in Excel
1 TUTORIAL & TEST
1.
Using Macros Excel
TUTORIAL
1.
Using Macros Excel
TEST
9. Working with Data in Excel
10 TUTORIALS & 10 TESTS
1.
Sort and Filter Data in Excel
TUTORIAL
1.
Sort and Filter Data in Excel
TEST
2.
Concatenate Function, Convert Text to Columns & Remove Duplicates
TUTORIAL
2.
Concatenate Function, Convert Text to Columns & Remove Duplicates
TEST
3.
Conditional Formatting Excel
TUTORIAL
3.
Conditional Formatting Excel
TEST
4.
Using Data Outline Tools
TUTORIAL
4.
Using Data Outline Tools
TEST
5.
What-If Analysis Excel
TUTORIAL
5.
What-If Analysis Excel
TEST
6.
Using Data Validation Tools
TUTORIAL
6.
Using Data Validation Tools
TEST
7. VLOOKUP & INDEX-MATCH
TUTORIAL
Using Formulas to Look Up Data
7. VLOOKUP & INDEX-MATCH
TEST
Using Formulas to Look Up Data
8.
Formulas to Manipulate & Clean Data
TUTORIAL
8.
Formulas to Manipulate & Clean Data
TEST
9.
Data Forms Excel
TUTORIAL
9.
Data Forms Excel
TEST
10.
Pivot Tables Excel
TUTORIAL
10.
Pivot Tables Excel
TEST
10. Images & Graphical Elements
1 TUTORIAL & 1 TEST
1.
Images & Graphical Elements
TUTORIAL
1.
Images & Graphical Elements
TEST
11. More Microsoft Excel
1. Excel Training & Excel MOS Exams Explained
2. What is Microsoft Excel?
3. What MS Excel Training is best for you?
QUIZ
4. What version of Excel are you using?
Excel Tutorials & Tests Index Page
Excel Tutorials Index Page
Excel Tests Index Page
Microsoft Office Index Page
EXCEL 2016 INDEX – TUTORIALS & TESTS
1. Free Excel Templates – get organized
Excel 2016 Articles
1. Learn Excel Basics – Excel 2016
7 TUTORIALS & 7 TESTS
1.
What’s New in Excel 2016?
TUTORIAL
1.
What’s New in Excel 2016?
TEST
2.
Parts of the Excel Screen
TUTORIAL
2.
Parts of the Excel Screen
TEST
3.
Navigating Workbooks & Sheets
TUTORIAL
3.
Navigating Workbooks & Sheets
TEST
4.
The File Tab & Backstage View
TUTORIAL
4.
The File Tab & Backstage View
TEST
5.
Making Excel View Types Work for You
TUTORIAL
5.
Making Excel View Types Work for You
TEST
6.
Mastering the Ribbon & QAT (Quick Access Toolbar)
TUTORIAL
6.
Mastering the Ribbon & QAT (Quick Access Toolbar)
TEST
7.
Window and Zoom Options in Excel 2016
TEST
7.
Window and Zoom Options in Excel 2016
TUTORIAL
2. Data Entry & Formatting – Excel 2016
5 TUTORIALS & 5 TESTS
1.
Adding Text & Numbers to a Worksheet
TUTORIAL – Excel 2016
1.
Adding Text & Numbers to a Worksheet
TEST – Excel 2016
2.
Formatting Text & Numbers
TUTORIAL – Excel 2016
2.
Formatting Text & Numbers
TEST – Excel 2016
3.
Aligning Cell Content
TUTORIAL – Excel 2016
3.
Aligning Cell Content
TEST – Excel 2016
4.
Customizing Number & Text Formats
TUTORIAL – Excel 2016
4.
Customizing Number & Text Formats
TEST – Excel 2016
5.
How to Add Excel Borders & Shading to Cells
TUTORIAL – Excel 2016
5.
How to Add Excel Borders & Shading to Cells
TEST – Excel 2016
3. Excel Formulas & Functions 2016
3 TESTS
1. VLOOKUP & INDEX-MATCH TEST
Excel 2016
2. HLOOKUP, VLOOKUP & INDEX-MATCH TEST Excel 2016
3. How to use VLOOKUP in Excel TEST 2016
4. Excel Data Analysis ToolPak
1 TUTORIAL & 1 TEST
1. t-Test in Excel, F-test and z-Test
TUTORIAL – Excel 2016
1. t-Test in Excel, F-test and z-Test
QUIZ – Excel 2016