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 – Basic Worksheet Formatting Test – Excel 2010 – Worksheets
Basic Worksheet Formatting Test
Free Online Microsoft Excel Tests
Excel 2010 – Worksheets
* Inserting & Deleting Cells, Rows & Columns
* Setting Width & Height for Columns & Rows
* Inserting & Formatting Borders
* Inserting Headers, Footers & Page Numbers
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Basic Worksheet Formatting Test
1)
Which of the following options most accurately represent a method for inserting rows into a worksheet in Excel?
a) Select the whole worksheet by pressing Ctrl+A and then right-click and select
Insert
from the menu list.
b) Select a row in the worksheet by clicking on the row label to select it and then right-click and select
insert
from the menu list.
c) Select a row in the worksheet by clicking on the row label to select it and then press the Enter key to insert a new row.
d) All of the above options are correct.
2)
Study the screenshot above. What is a quick way to resize the columns in the screenshot above to ensure all content fits within their respective column widths?
a) Select each individual column and then drag the column divider to resize each column.
b) Select all the columns, right-click and select
Resize Columns
from the menu list, then enter the column width value required.
c) Select all the columns and then double click any of the column dividers in the selection to resize columns to fit content.
d) Select the last column on the right and then double click its divider to resize all the columns in the worksheet.
3)
Study the screenshot above. In order to apply borders that look like those in the worksheet above, which option would you have to select from the Borders menu?
a) Outside Borders.
b) Right border, left border and bottom border.
c) Inside Borders.
d) All Borders.
4)
How do you remove borders that have been applied to a worksheet?
a) Select all the cells you wish to remove the borders from and then click on
No Border
in the Borders menu list.
b) Select all the cells you wish to remove the borders from and then click on
Remove Borders
in the Borders menu list.
c) Select all the cells you wish to remove the borders from and press Ctrl+Delete on your keyboard.
d) All of the above are methods for removing borders from selected cells.
5)
Casey has an Excel worksheet that prints over several pages. She wishes to add automatic page numbers to make it easier to collate when printing the worksheet. Which of the following solutions could she use to add page numbers?
a) Use the Page Break Preview view to ascertain where page breaks appear. Then insert a page number above each page break.
b) In the Print Preview view use the Insert Page Numbers function to number pages before they are printed.
c) In the Page Layout view, use the Header & Footer tools to insert automatic page numbers in the Header or Footer region of every page.
d) None of the above options are correct.
6)
Which of the following is NOT an element that can be inserted into the Header & Footer region of an Excel worksheet?
a) ClipArt, Photos, Images, Shapes and other graphical elements.
b) Sheet name, page number, worksheet name and author.
c) Current date and time.
d) All of the above are elements that can be inserted into the Header and/or Footer region of a worksheet.
7)
How do you remove all Headers & Footers from a worksheet?
a) In the Page Layout view, go to each page in the worksheet and delete all content from the Header and Footer regions.
b) In the Normal view, right-click either the Header or Footer area and select
Delete Headers & Footers
from the menu list.
c) In the Page Layout view, select
None
from both the Header and Footer menus under the Header & Footer Tools – Design tab.
d) All of the above options are correct.
8)
The Header & Footer Tools – Design tab is a contextual tab. What condition(s) must be met before the Header & Footer Tools Ribbon displays?
a) Page Layout view must be activated.
b) You must click in the Header or Footer region of the worksheet.
c) You must click on the Header & Footer – Design tab in the Ribbon.
d) All of the above are essential elements in gaining access to the Header & Footer Design Tools.
9)
Katy attempted to insert an automatic page number into the Footer of every worksheet. She followed all the instructions for inserting an automatic page number in the Page Numbering tutorial, but her page number is still displaying as: &[Page] . How can she fix this?
a) If she presses the Enter key on her keyboard, the correct page number will appear.
b) She has inserted an incomplete formula. She needs to insert an equal sign so that the formula reads: =&[Page]
c) She needs to click away from the Header region back into the body of the document to view the page number.
d) She needs to reinsert the page number by selecting Page Number from the Header & Footer Elements group.
10)
Where will you find options to change the line style and color of borders in a worksheet?
a) By clicking on the Format button in the Cells group under the Home tab and selecting Format Cells.
b) By pressing Ctrl+1 on your keyboard and then clicking on the Border tab in the Format Cells dialogue box.
c) By clicking on the Border button in the Font group and selecting Line Color and Line Style from the menu list.
d) All of the above options 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