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 – The Views in Excel Test – Excel 2010 – Getting Started
The Views in Excel Test
Free Online Microsoft Excel Tests
Excel 2010 – Getting Started
* Normal View
* Page Layout View
* Page Break Preview
* Zoom Options
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
The Views in Excel Test
1)
Study the image of a sample worksheet below this question. Which view type does this represent?
a) The Normal View
b) The Page Layout
c) The Page Break View
d) The Zoom View
2)
Study the image above. What will happen if I move the blue line located between columns D and E to the right, between columns G and H?
a) This will resize the print area and my worksheet will print on one page only.
b) This will resize the print area.
c) My worksheet will change to landscape orientation and print on one page only.
d) None of the above options are correct.
3)
Study the image below taking note of the vertical and horizontal dotted lines across the center of the worksheet. What is the purpose of these lines?
a) These are table border lines and help make the data easier to read.
b) These are printing guidelines as to where the center of each page is situated.
c) These represent section breaks denoting the different sections that will be printed.
d) These represent page breaks denoting where the edges of each page will be when printed.
4)
Which of the following view types can you use to insert headers, footers and page numbers into your worksheet?
a) The Page Layout View.
b) The Normal View.
c) The Page Break View.
d) All of the above.
5)
Study the area circled in orange in the image below. This is a page number that was inserted using the page number buttons in the Design tab in the Page Layout View. Which of the following represents what this text will look like when printed?
a) &[Page] of &[Pages]
b) Page 1
c) 1 of 2
d) Page 1 of 2 Pages
6)
Your boss asks you to insert the company logo into your worksheet so that it will automatically display at the top of every printed page. How will you go about doing this?
a) Display the worksheet in the Page Layout View and manually insert the company logo into the top of each individual page.
b) Add the company logo to the header or footer of the first page in the Page Layout View.
c) Insert the company logo into the top of the worksheet in Normal View. It will automatically repeat.
d) It is not possible to insert logos into Excel. Instead print the worksheets on company headed paper that contains the logo.
7)
Which of the following is NOT a Zoom option/setting?
a) Zoom to Selection
b) 103%
c) Zoom to page
d) Fit Selection
8)
Study the image below this question. Myrtle’s hand slipped whilst she was working on a spreadsheet and her data is now so small she is unable to read it. Which of the following actions will solve her problem?
a) If she holds down the control key on her keyboard and scrolls her mouse wheel forwards, the magnification will be corrected.
b) If she clicks on the button that is labelled 100% in the Zoom group under the View tab, the magnification will be corrected.
c) If she clicks on the button that is labelled Zoom in the Zoom group under the View tab and type 120% into the custom box, the magnification will be corrected.
d) All of the above actions will solve her problem.
9)
Study the image below this question. Which of the following statements are true about the header “January 2015 Price List”?
a) The header will appear on all the pages that are printed.
b) The header will appear only on the first page.
c) The header together with the text “My Candy Shop Sales” will appear on all printed pages.
d) The header will only display in the Page Layout view. It will not print.
10)
Study the image below. Which of the following statements is true with regard to this worksheet?
a) When printing, only the data within the blue borders will print. The data with a grey background will not print.
b) The worksheet looks the way it does because it is viewed in the Page Layout view. All the data will print including the data with a grey background.
c) The first page of the worksheet is selected. If you click on the area with the grey background, the display will move to the second page.
d) The area within the blue borders represents the header that will be repeated on each page.
* 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