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 – Creating and Modifying Charts Test – Excel 2010 – Charts
Creating and Modifying Charts Test
Excel 2010 Training – Charts
Free Online Microsoft Excel Tests
* Select and Insert a Chart
* Edit Data Ranges for a Chart
* Change Chart Type and Layout
* Formatting a Chart
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Creating and Modifying Charts Test
1)
Study the screenshot above. To insert this type of chart in Excel, which of the following options must you choose from the Insert Chart group?
a) Click on Other Charts and select Doughnut from the menu list.
b) Click on Other Charts and select Bubble from the menu list.
c) Click on Area and select 3D area.
d) Click on Pie and select Pie from the menu.
2)
Which of the options below represent the method for inserting a title or heading for a chart?
a) Under Chart Tools, click on the Design tab and select
Insert Chart Title
in the Chart Layouts group
.
b) Under Chart Tools, click on the Layout tab and select
Insert Chart Heading from the Background group.
c) Under Chart Tools, click on the Layout tab, select
Chart Title
and choose the relevant option for where to insert the title.
d) Under Chart Tools, click on the Format tab and select
Format Chart Title
from the Headings group.
3)
Charlotte selected data in her worksheet and then inserted a chart. However, the chart is obscuring her data. How can she rectify this?
a) She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.
b) She needs to delete the current chart and first select a blank sheet or space before inserting the chart again.
c) She needs to right-click the chart and select
Move Below Data Table
from the menu list.
d) All of the options listed above are correct.
4)
After a chart has been inserted and formatted, is it possible to change the data range it refers to or to add new rows of data?
a) No, additional data cannot be included in a chart once it has been created. Delete the chart and create a new chart.
b) Yes, click on the Select Data button in the Data group under the Design tab to extend or reduce the data range.
c) Yes, click on the chart, select the additional rows or columns of data you wish to add and press Enter on your keyboard.
d) Yes, double click the chart and select Properties from the list. In the Properties box insert the new data range to include in the chart.
5)
Patrick has inserted a Bar Chart but his boss has asked him to rather use a Column Chart to represent the data range. How do you change a Bar Chart to a Column Chart?
a) Right-click the Bar Chart and select rotate from the menu list. This will turn the bar chart vertically to display as columns.
b) Select the chart, click on the Design tab and then select the Switch Row/Column button to rotate the data so that it displays as columns.
c) Select the chart, click on the Design tab and then select the Change Chart Type button and select the Column Chart from the list.
d) None of the options listed above are correct.
6)
Study the screenshot above. In chart anatomy, what is the area circled in yellow called?
a) This is called the Legend of the chart.
b) This is called Data Labels.
c) This is called Axes Titles.
d) This is called Plot Area Labels.
7)
Where will you find options to add or remove the background color or style of a chart?
a) Under the Design tab in the Chart Layouts group.
b) Under the Design tab in the Chart Styles gallery.
c) Under the Format tab in the Shape Styles group.
d) Under the Layout tab in the Insert group.
8)
Study the screenshot above. How can the amounts in the data labels on each segment of the Pie Chart be displayed as percentages in addition to the amounts currently displayed?
a) By inserting a formula to convert data to percentages in the original data set that the chart is based on.
b) By deleting the amounts and typing in the percentages in the Data Labels.
c) By right-clicking on any of the Data Labels, selecting Format Data Series and ticking the box for
Percentage
under the Label Options.
d) By right-clicking on any of the Data Labels, selecting Format Data Labels and ticking the box for
Percentage
under the Label Options.
9)
Study the screenshot above. How can you quickly change the colors for each of the bars in the chart from orange to purple, blue, green, turquoise, yellow and red, respectively?
a) Click on the bars to select them, then go to the Chart Styles group under the Design tab and select the relevant color style from the gallery.
b) Click on individual bars to select them, then go the Shape Styles group under the Format tab and select a color from the Shape Fill button.
c) Click on individual bars to select them, then go to the Chart Layouts group under the Design tab and select the relevant color style from the gallery to apply to individual bars.
d) Click on the bars to select them, then in the Styles group under the Format tab tick the
Multicolor
box in the list.
10)
Where will you find options to add a border around the outside of your chart?
a) Under the Design tab in the Chart Layout gallery.
b) Under the Format tab in the Shape Styles group.
c) Under the Layout tab in the Background group.
d) None of the options 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