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 – Working with Images & Graphical Elements Test – Excel 2010 Training
Working with Images &
Graphical Elements Excel Test
Excel 2010 Training – Graphical Elements in Excel
Free Online Microsoft Excel Test
* How to Insert an Image
* How to Insert Shapes
* Working with SmartArt
* Changing the Background Color
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Working with Images & Graphical Elements Excel Test
1)
How do you insert a phot that you have saved on your computer into an Excel worksheet?
a) By clicking on the Insert tab and select the photo from the Photo Gallery group.
b) By clicking on the Insert tab, selecting Picture and locating the photo on your PC to select and insert.
c) By clicking on the Images contextual tab and selecting the photo on your PC to insert.
d) You cannot insert photos into an Excel worksheet.
2)
Study the screenshot above. What happens if you click and drag the handle circled in orange towards the left?
a) The image will be rotated to the left.
b) The image will be resized to the left.
c) The image will be moved to the left.
d) All of the options listed above are correct.
3)
What is SmartArt?
a) It is special formatting that you can apply to images and photos in Excel that allows you to draw and add color.
b) It is a type of mathematical diagram that is used in Excel for special calculations.
c) It is a way of inserting scanned drawings, graphics and charts into an Excel worksheet.
d) It is a predesigned graphical and visual representation of lists, hierarchical structures, processes, cycles and more.
4)
Where on the Ribbon will you find the option to insert SmartArt?
a) Under the Insert tab in the Charts group.
b) Under the Insert tab in the Shapes group.
c) Under the Insert tab in the Illustrations group.
d) All of the options listed above are correct.
5)
Study the image above. What is the quickest and easiest method of adding text to this SmartArt diagram?
a) By clicking on the arrow to the left of the diagram to launch the textbox and typing text directly into this box.
b) Dragging and dropping text on the shape.
c) Inserting separate text box shapes with the text in them into the diagram.
d) All of the above options are correct.
6)
Study the screenshot above. What will happen if you drag the corner handle (circled in yellow) upwards and to the right?
a) This will rotate the selected shape to the right.
b) This will move the selected shape upwards and to the right.
c) This will launch the SmartArt textbox.
d) This will enlarge the selected shape.
7)
Lucy created a SmartArt diagram and now wishes to change the design. For some reason the SmartArt Tools Design tab is not visible. What is the problem?
a) It is a contextual tab that will only be visible if the SmartArt diagram is selected.
b) It needs to be enabled as a tab on the Ribbon via the Excel Options dialogue box.
c) The SmartArt options have expired. You are only able to edit it for up to 90 days after creating it.
d) None of the options listed above are correct.
8)
Study the screenshot above. What happens if you click the arrow circled in yellow?
a) The selected diagram will be inserted into the worksheet.
b) The SmartArt Layouts Gallery will expand.
c) The Ribbon will be hidden.
d) None of the options listed above are correct.
9)
How do you change the background color of a worksheet?
a) You cannot change the background color of a worksheet in Excel.
b) You have to change the background color setting in the Excel Options dialogue box under Background Settings.
c) Select the whole worksheet. In the Fonts group under the Home tab, pick a color from the Fill Color Gallery.
d) All of the options listed above are correct.
10)
How do you remove a background image from a worksheet?
a) Select the whole worksheet and press delete.
b) Click on the Fill Color Gallery button and select White from the options.
c) Change the Theme of the worksheet to No Background – Text Only.
d) Click on the Page Layout tab and in the Page Setup group, click No Background.
* 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