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 – Printing Large Excel Worksheets – Excel 2010
Printing Large Excel Worksheets Test
Free Online Microsoft Excel Test
Excel 2010 Training – Printing
* Scaling a Page for Printing
* Insert Page Breaks
* Move Page Breaks in Page Break Preview Window
* Set Print Area
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Printing Large Excel Worksheets Test
1)
Study the screenshot above. Over how many pages will this worksheet print?
a) It will print over only one page.
b) It will Print over eight pages.
c) It will print over two pages.
d) It is impossible to tell over how many pages it will print.
2)
If a worksheet has multiple columns that need to fit on the same page, which of the following options would be a useful setting towards achieving this?
a) Setting the page layout to
Landscape Orientation
.
b) Changing the page margin size to
Narrow
.
c) Using the
Fit All Columns on One Page
Scaling option.
d) All of the above options can be used in conjunction with one another to ensure the columns fit the page.
3)
To print a worksheet so that the columns will not exceed the width of one page and the rows will not exceed ten pages, which setting entered into the Page Setup box under Scaling will achieve this?
a) Fit to 1 page(s) wide by 10 tall.
b) Fit to 10 page(s) wide by 1 tall.
c) Adjust to 100 % wide and 10 % tall.
d) None of the above options are correct.
4)
Study the screenshot above. If you wished to insert a page break after the row highlighted in yellow (Row 22), how would you do this?
a) Select Row 23 and press Ctrl+Enter on your keyboard.
b) Select Row 23, click on Breaks on the Ribbon and select
Insert Page Break
.
c) Select Row 22, click on Breaks on the Ribbon and select
Insert Page Break
.
d) Select Row 23, right-click and select Insert from the menu list.
5)
Study the screenshot above. Which view type is this and how do you access it?
a) This is the Normal View. Click on the File tab and select
Normal
from the list.
b) This is the Print Preview view. Click on the File tab and select
Print
from the list.
c) This is the Page Break Preview view. Click on Page Break Preview under the View tab on the Ribbon.
d) This is the Page Layout view. Click on Page Layout View under the View tab on the Ribbon.
6)
Don received a worksheet from a colleague. Every time he tries to print the sheet, only the first three columns print. Which of the following options will solve this problem?
a) He needs to select the whole worksheet by pressing Ctrl+A before pressing Print.
b) He needs to select
Print Active Sheets
from the Print Area options.
c) He needs to clear any Print Areas by clicking on
Clear Print Area
under the Print Area button in the Page Setup Group.
d) He needs to clear any Page Breaks by clicking on the Breaks button and selecting
Clear All Breaks.
7)
To access specific Page Setup options such as Scaling, Orientation and Paper Size, where can you go to launch the Page Setup dialogue box?
a) Click on the Page Layout tab and click on the dialogue box launcher in the Page Setup group.
b) Click on the Page Setup link in the second pane of the Print Preview area.
c) Select
Custom Scaling Options
from the list that appears when you click on the Scaling button in the Print Preview area.
d) All of the above options are correct.
8)
Under which tab on the Ribbon will you find the Print Area setting button, the insert Breaks function and the Page Orientation options?
a) Under the Page layout tab in the Page Setup group.
b) Under the Home tab in the Page Setup group.
c) Under the File tab in the Print Preview area.
d) Under the Insert tab in the Insert Page Elements group.
9)
To ensure a worksheet, which does not contain that many rows and columns, fit on one page instead of slightly flowing over into two pages wide and two pages tall, which option should you select?
a) In the Print Area of the Backstage View, select
Fit All Data on One Page
from the Page Orientation button.
b) In the Print Area of the Backstage View, select
Fit All Columns on One Page
from the Scaling options button.
c) In the Print Area of the Backstage View, select
Fit All Columns and Rows on One Page
from the Scaling options button.
d) In the Print Area of the Backstage View, select
Fit Sheet on One Page
from the Scaling options button.
10)
Is it possible to enlarge a worksheet so that it automatically increases the font size when printing?
a) If you select the
Fit Sheet on One Page
option from the Scaling options button, the content will automatically expand to fit the page.
b) If you enter a value in the
Adjust
to
box that is more than 100%, the font will increase in size when printing the worksheet.
c) If you use the Zoom button in the Print Preview area to enlarge the Print Preview Pane view of your worksheet, it will print this size.
d) All of the options listed above 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