True/False
Based on the
statements indicate whether the statement is true (for Yes) familiar with the skill or false
(for No) not familiar with the skill mentioned. This is an assessment of your skills level NOT a
test.
NOTE: Bottom left , DO NOT FORGET
TO CLICK Grade and Submit button.
|
|
|
1.
|
Working with Names and
Ranges
|
|
|
2.
|
Defining and Using Range
Names
|
|
|
3.
|
The IF
function
|
|
|
4.
|
Using the Function
Library
|
|
|
5.
|
Manually entering a
function
|
|
|
6.
|
The AND
Function
|
|
|
7.
|
The OR
Function
|
|
|
8.
|
Working with Nested
Functions
|
|
|
9.
|
Nested IF
functions
|
|
|
10.
|
Applying Logical
Functions
|
|
|
11.
|
Using VLOOKUP to Find
Data
|
|
|
12.
|
How to Find an Exact Match with
VLOOKUP
|
|
|
13.
|
Finding the Closest Match with
VLOOKUP
|
|
|
14.
|
Validating Your
Data
|
|
|
15.
|
Creating Data Validation
Settings
|
|
|
16.
|
Creating Entry and Error
Messages
|
|
|
17.
|
Using a Formula to Validate
Entries
|
|
|
18.
|
Using Database
Functions
|
|
|
19.
|
Creating a Criteria
Range
|
|
|
20.
|
Entering the Database
Function
|
|
|
21.
|
Preparing Data to Create a
PivotTable
|
|
|
22.
|
Creating a
PivotTable
|
|
|
23.
|
Selecting PivotTable
Data
|
|
|
24.
|
Selecting PivotTable
Location
|
|
|
25.
|
Adding Fields to the
PivotTable
|
|
|
26.
|
Creating a PivotTable Frame
(Classic PivotTable Layout)
|
|
|
27.
|
Modifying a PivotTable using
Classic PivotTable Layout
|
|
|
28.
|
PivotTable
areas
|
|
|
29.
|
Rearranging PivotTable
Data
|
|
|
30.
|
Hiding and Showing Field
Data
|
|
|
31.
|
The PivotTable Tools
Ribbon
|
|
|
32.
|
Modifying Calculations and Data
Area Display
|
|
|
33.
|
Modifying a PivotTable using
Excel 2010 2013 2016 PivotTable Layout
|
|
|
34.
|
Formatting a
PivotTable
|
|
|
35.
|
Using PivotTables Options
Ribbon
|
|
|
36.
|
Using PivotTable Design
Ribbon
|
|
|
37.
|
Using the Home
Ribbon
|
|
|
38.
|
Refreshing a
PivotTable
|
|
|
39.
|
Creating a PivotChart From an
Existing PivotTable Without an Existing PivotTable
|
|
|
40.
|
Creating a PivotTable Based on
External Data
|
|
|
41.
|
Connecting to External
Data
|
|
|
42.
|
Refreshing PivotTable
Data
|
|
|
43.
|
Using ‘What-If’
Analysis Tools
|
|
|
44.
|
Using Scenarios in
Excel
|
|
|
45.
|
Creating a
Scenario
|
|
|
46.
|
Creating a Scenario Summary
Report
|
|
|
47.
|
Saving Multiple
Scenarios
|
|
|
48.
|
Using Goal
Seek
|
|
|
49.
|
Using
Solver
|
|
|
50.
|
Checking Solver
Installation
|
|
|
51.
|
When to use
Solver
|
|
|
52.
|
Setting Solver
Parameters
|
|
|
53.
|
Using One and Two Input Data
Tables
|
|
|
54.
|
What is a Data
Table?
|
|
|
55.
|
Preparing to Create a Data
Table
|
|
|
56.
|
Creating a One Input Data
Table
|
|
|
57.
|
Creating a Two Input Data
Table
|
|
|
58.
|
Creating a
macro
|
|
|
59.
|
The Developer
Ribbon
|
|
|
60.
|
Recording a
macro
|
|
|
61.
|
Playing a
Macro
|
|
|
62.
|
Macro
Security
|
|
|
63.
|
Recording a Relative Reference
Macro
|
|
|
64.
|
Running a Relative Reference
Macro
|
|
|
65.
|
Assigning a Keystroke to a
Macro
|
|
|
66.
|
Copying a Macro from a Workbook
or Template
|