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 – Conditional Formatting – Excel 2010 Training
Conditional Formatting Excel Test
Free Online Microsoft Excel Test
Excel 2010 Training – Working with Data
* What is Conditional Formatting?
* Highlight Cell Rules
* Top and Bottom Rules
* Manage Rules
* Remove Rules
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Conditional Formatting Excel Test
1)
The Conditional Formatting function in Excel allows you to:
a) Automatically apply formatting based on specific rules or conditions being met.
b) Automatically apply highlighting to selected cell ranges based on specific rules or conditions being met.
c) Automatically change the font of selected cell ranges based on specific rules or conditions being met.
d) All of the options listed above are correct.
2)
Where can you find the option to set Conditional Formatting rules?
a) Under the Insert tab on the Ribbon in the Formatting group.
b) Under the Page Layout tab on the Ribbon in the Styles group.
c) Under the Home tab on the Ribbon in the Styles group.
d) Under the Formulas tab on the Ribbon in the Formatting group.
3)
Study the screenshot above. Which option on the
Conditional Formatting
menu should you click to find the
Text That Contains…
option?
a) Click on the
Data Bars
option.
b) Click on the
Highlight Cells Rules
option.
c) Click on the
Top/Bottom Rules
option.
d) You can click on any of the options in the
Conditional Formatting
menu to access this option.
4)
Which of the following formatting options can you set for Conditional Formatting rules?
a) Light Red Fill With Dark Red Text, Yellow Fill With Dark Yellow Text and Green Fill With Dark Green Text.
b) Light Red Fill With Dark Red Text.
c) Light Red Fill, Light Yellow Fill and Light Green Fill.
d) You can apply any of the formatting detailed in the options above as well as number, border, shading and font formatting.
5)
Study the screenshot above. Several Conditional Formatting rules have been applied to this worksheet. How can you ascertain which rules have been applied and where?
a) Click on the
Conditional Formatting
button in the Styles group and select
Manage Rules.
b) Right click in an area of the worksheet that contains conditional formatting and select
Format Cells.
c) Click on the
Conditional Formatting
button in the Styles group and select
More Rules
.
d) None of the options listed above are correct.
6)
Study the screenshot above question 5. How can you remove conditional formatting, such as the colored font and blue, pink and green shading, from this worksheet?
a) Select the worksheet or range of cells, right click and select
Format Cells
from the menu list. From here you can remove formatting.
b) Select the worksheet or range of cells, click on
Conditional Formatting
and select the
Clear Rules
option.
c) Select the worksheet or range of cells, click on
Delete
in the
Cells
group and select
Delete Formatting Only.
d) All of the options listed above are correct.
7)
Top/Bottom Rules allow you to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow you to include in the rule?
a) The top or bottom 10 items or top or bottom 10% only.
b) The top 10 items and top 10% only.
c) The top or bottom 100 items only.
d) Any logical number of items or percentages in top or bottom value frames.
8)
Which of the following functions can you
NOT
perform using the Conditional Formatting option?
a) Insert icons that visually display the ranking or rating of values in a selected range.
b) Apply conditional formatting to dates that fall within specified date ranges.
c) Use conditional formatting to highlight any duplicate values or data in a worksheet.
d) Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.
9)
How do you change the range of cells that a Conditional Formatting rule applies to?
a) You cannot change the range, you have to clear the rule first and then reapply it.
b) In the
Conditional Formatting Rules Manager
dialogue box, edit the cell range for the rule in the
Applies To
section.
c) Select the cell range and reapply the rule. This will automatically delete the previous rule and create a new one.
d) Right click the cell range and select
Update Conditional Formatting Rule
from the menu list.
10)
Immediately after applying a conditional formatting rule, you realize it is a mistake. How do you fix it? Choose the best answer:
a) You have to clear the rule you created by going to the
Conditional Formatting Rules Manager
dialogue box and deleting the rule.
b) You have to clear all rules that have been applied to the worksheet or selected range, by clicking on the
Clear Rules
button.
c) You can simply press the Undo button or use the shortcut Ctrl+Z to undo the last rule created.
d) You can right click the area where the conditional formatting rule has been applied and select
Clear Rule
from the menu list.
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