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 – Protecting Worksheets Test – Excel 2010 – Worksheets
Protecting Worksheets Excel Test
Excel 2010 Training – Worksheets
Free Online Microsoft Excel Test
* Password Protect a Workbook
* Protect a Worksheet from Changes
* Protect a Workbook Structure from Changes
* Unlocking Selected Cells to Allow Edits
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Protecting Worksheets Excel Test
1)
In order for the
Lock
or
Unlock Cells
function to work, which option should be enabled?
a) The
Protect Workbook
function needs to be enabled.
b) No functions need to be enabled other than the lock or unlock cells options.
c) The worksheet must be saved before the cells will become locked or unlocked.
d) The
Protect Worksheet
function needs to be enabled.
2)
Study the screenshot above. Based on this image, do you think the selected cell(s) are locked or unlocked?
a) They are locked.
b) They are unlocked.
c) It is impossible to tell.
d) The sheet is protected, so all cells are locked.
3)
What does the
Protect Workbook
function do?
a) It protects all the worksheets in a workbook from being reformatted or typed into.
b) It adds a password to access the worksheet.
c) It prevents worksheets from being inserted, deleted or moved.
d) It saves a workbook in a way that will allow only a select group of people to access to it.
4)
Study the screenshot above. Where will you find the option to launch this dialogue box?
a) Under the Home tab, in the Cells group, click on the Format menu and select
Lock Cells
.
b) Under the Insert tab, in the Text group, click on the
Worksheet Protection
button.
c) Under the Review tab on the Ribbon, click on the
Protect Workbook
button in the Cells group.
d) Under the Review tab on the Ribbon, click on the
Protect Worksheet
button in the Cells group.
5)
Casey is doing a very confidential company budget worksheet in Excel. How can she prevent anyone, including the IT department, from being able to open the file and view its contents?
a) By clicking on the Home tab, selecting
Protect Sheet
and entering a password to prevent access to the sheet.
b) By clicking on the Info tab in the Backstage View, selecting
Protect Workbook – Encrypt with Password
and entering a password.
c) By clicking on the Review tab and selecting
Protect Workbook
and entering a password for protecting the sheet.
d) All of the options listed above will block access to the workbook.
6)
How do you remove
Workbook Protection
that has been applied to a workbook?
a) Open the file, enter the password and then resave the workbook to remove the protection.
b) Right click the workbook and select
Remove Protection
from the menu list.
c) Select the cells to unprotect, click on the Home tab on the Ribbon and select
Lock Cells
in the Format menu.
d) Click on the Review tab on the Ribbon and then click on
Protect Workbook
in the Changes group.
7)
Which option will protect a worksheet window from being minimized?
a) Protect Workbook with the
Windows
option ticked.
b) Protect Workbook.
c) Protect Worksheet with the
Windows
option ticked.
d) Protect Worksheet.
8)
What is the only way of removing password encryption on an Excel file?
a) Resaving the workbook as a new document or making a copy of it.
b) Opening the workbook as
Read Only
and resaving it without a password.
c) Opening the workbook in
Protected View
and resaving it without a password.
d) Entering the password to open the Workbook and then deleting the password created in the Permissions – Encrypt with Password box.
9)
How can I specify that I want users of my worksheet to be able to change and apply formatting when the worksheet is protected?
a) Tick the boxes for
Format Cells, Format Columns
and
Format Rows
in the
Protect Sheet
dialogue box.
b) Select only the
Structure
and
Windows
options in the
Protect Workbook
dialogue box.
c) Select pre-set formatting options from the
Cell Styles Gallery
under the Home tab in the Styles group.
d) All of the options listed above are incorrect.
10)
Study the screenshot above. A colleague has sent this workbook to you because they believe it is corrupt as most of the functions, for example
Alignment
,
Number Formatting
and
Styles
on the Ribbon are greyed out and impossible to select. What is happening here?
a) The worksheet has been encrypted with a password.
b) The worksheet has been protected.
c) The workbook has been protected.
d) The workbook has become corrupted due to oversharing.
* 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