Home
Microsoft Office Index
Excel
Word
PowerPoint
What's New?
A~Z Quizzes
Computer Programming
Domains & Hosting
Typing Index
Typing Speed Test
English Lessons & Practice Tests
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 Training - Tuts & Tests
Understanding Excel Functions Test
Free Online Microsoft Excel Tests
Excel 2010 - Formulas and Functions
* How to Find a Function
* How to Insert a Function
* How to Edit a Function
* Sum and Count
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Understanding Excel Functions Test
1)
Which of the following is NOT a function category you can select functions from in Excel?
a) The Financial category.
b) The Text category.
c) The Conditional Formatting category.
d) The Engineering category.
2)
What is the purpose of the Insert Function dialogue box?
a) It is used to search for specific functions using keywords and descriptions.
b) It is used to insert a specific function by clicking on its name in the Insert Function list.
c) It is used to display information about the arguments needed to build a function.
d)
All of the above options are correct.
3)
Study the screenshot above. How many arguments does the above function contain?
a) There are four arguments: IF, Logical_test, Value_if_true and Value_if_false.
b) There are three arguments: Logical_test, Value_if_true and Value_if_false.
c) There are two arguments: Logical and Value.
d) There are five arguments: IF, Logical_test, Value_if_true and Value_if_false and Logical_test.
4)
Study the screenshot above. This is an example of a function entered into a cell. What will the result be if the function is used to evaluate cell A1 above?
a) It will return:
above average
b) It will return:
below average
c) It will return the value: 12.
d) It will return an error.
5)
Study the screenshot above. What is the contents of the Value if False part of this argument?
a) It is: 0.
b) It is: ISBLANK.
c) It is: A1.
d)
It is: 10.
6)
Which of the following methods can you use to edit a function that has been created and inserted into a cell?
a) Double click the cell containing the function and make amendments to the function within the cell.
b) Click the cell containing the function and then click in the Formula Bar to make amendments to the function.
c) Click the cell containing the function and then click on the
fx
symbol to the left of the Formula Bar to launch the Function Arguments dialogue box where amendments can be made.
d) All of the above options are correct.
7)
Patrick needs a function that can count all the item reference numbers he inserts in a spreadsheet for stock keeping purposes. How can he go about finding a function to do this?
a) If he clicks on the Home tab in Excel, he can use the Find & Select function to look for a function that counts items.
b) If he presses Ctrl+F on his keyboard, he can use the Find dialogue box to look for a function that counts items.
c) If he presses Shift+F3 he can use the Insert Function dialogue box to look for a function that counts items.
d) All of the above options are correct.
8)
It is often impossible to tell what the purpose of a function is by just looking at the name of a function, for example, VLOOKUP. Which of the following is an easy way to find just a short description of the purpose of a function?
a) In the Insert Function dialogue box, click on the function name to get a short description of what the function is used for.
b) Open Excel Help from the Backstage View and search for the function in the Help Library.
c) Insert the function in a cell and right-click the cell for an explanation.
d) All of the above options are correct.
9)
Under which tab(s) on the Ribbon will you find the Function Library from where you can insert functions into your worksheet?
a) Under the Insert tab on the Ribbon.
b) Under the Formulas tab.
c) Under the Home tab on the Ribbon.
d) All of the above options are correct.
10)
Study the screenshot above. Do you think the arguments for this SUM function has been completed correctly?
a) No, the references entered into Number1 and Number4 are incorrect.
b) No, the cells are not from the same range, for example A5 and B5 is not even the same column reference.
c) Yes, the cells contain valid arguments referring to various non-adjacent cell references.
d) The arguments above do not represent the SUM function.
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
TUTORIAL
8.
Using Financial Functions Excel
TEST
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
Excel 2016 Articles
1. Free Excel Templates - get organized
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
TUTORIAL
7.
Window and Zoom Options in Excel 2016
TEST
