BASIC KNOWLEDGE
GOOD KNOWLEDGE
COMPLETE KNOWLEDGE
NO KNOWLEDGE
Excel Fundamentals
1.
Creating a New Workbook
A
B
C
D
2.
Inserting/Deleting/Renaming Worksheets
A
B
C
D
3.
Moving worksheet to another existing/New Workbook
A
B
C
D
4.
Starting a New Workbook
A
B
C
D
5.
Saving a File
A
B
C
D
6.
The difference between Save and Save As
A
B
C
D
7.
Closing Files
A
B
C
D
8.
Opening Files
A
B
C
D
9.
[hidden Question default:Entering Text, Numbers, Dates "Entering Text, Numbers, Dates"]
Entering Text, Numbers, Dates
A
B
C
D
10.
Editing and Deleting cells
A
B
C
D
11.
Moving and Copying data
A
B
C
D
12.
Formatting Numbers
A
B
C
D
13.
Changing Font Type and Size
A
B
C
D
14.
Text Alignment and Orientation
A
B
C
D
15.
Wrapping Text
A
B
C
D
16.
Applying Borders and Shading
A
B
C
D
17.
Using Autoformat
A
B
C
D
18.
Conditional Formatting
A
B
C
D
19.
Format Painter
A
B
C
D
20.
Clearing Formats
A
B
C
D
21.
Inserting New Columns and Rows
A
B
C
D
22.
Changing height and width of Columns and Rows
A
B
C
D
23.
Hiding Sheets
A
B
C
D
24.
Inserting and Deleting Sheets
A
B
C
D
25.
Renaming and reordering sheet tabs
A
B
C
D
26.
Customizing Tabs and Quick Access Toolbar
A
B
C
D
Basic Formulae and Functions
1.
Understanding BODMAS
A
B
C
D
2.
Understanding the use of $ in Calculations
A
B
C
D
3.
Creating formuale using + and -
A
B
C
D
4.
Creating formuale using * and /
A
B
C
D
5.
Cut/Copy and Pasting Formulae
A
B
C
D
6.
Difference between Relative and Absolute References
A
B
C
D
7.
Use of Sum and Average Functions
A
B
C
D
8.
[hidden Question default:Use of MIN, MAX, COUNT and COUNTA Functions "Use of MIN, MAX, COUNT and COUNTA Functions"]
Use of MIN, MAX, COUNT and COUNTA Functions
A
B
C
D
Print and Page Setup Options
1.
Printing and Previewing spreadsheets
A
B
C
D
2.
Changing Page Orientation
A
B
C
D
3.
Adding Headers and Footers
A
B
C
D
4.
Printing a Selection
A
B
C
D
5.
Adjusting Page Breaks
A
B
C
D
6.
Setting a Print Area
A
B
C
D
More Advanced Functions
1.
[hidden Question default:Using the Now,Day,Month,Year functions "Using the Now,Day,Month,Year functions"]
Using the Now,Day,Month,Year functions
A
B
C
D
2.
Using If Statement
A
B
C
D
3.
Using Nested If
A
B
C
D
4.
COUNTIF and COUNTIFS
A
B
C
D
5.
SUMIF and SUMIFS
A
B
C
D
6.
AVERAGEIF and AVERAGEIFS
A
B
C
D
7.
Vlookup and Hlookup functions
A
B
C
D
8.
MATCH and INDEX
A
B
C
D
9.
[hidden Question default:Database Functions: Dsum, Dmin, Dmax "Database Functions: Dsum, Dmin, Dmax"]
Database Functions: Dsum, Dmin, Dmax
A
B
C
D
10.
Auditing Spreadsheets with Formulae and Functions
A
B
C
D
Charts and Graphs
1.
Creating Charts
A
B
C
D
2.
Editing and Formatting charts
A
B
C
D
3.
Creating Combination charts
A
B
C
D
4.
Saving Custom Charts
A
B
C
D
5.
Using Error Bars and Trendlines on a chart
A
B
C
D
6.
Changing the Tab Key Order on the forms
A
B
C
D
Working with Multiple Worksheet and Workbook
1.
Creating Multiple Spreadsheets File
A
B
C
D
2.
Linking Sheets in the same file
A
B
C
D
3.
Linking different Excel Files
A
B
C
D
4.
Using Data Consolidation
A
B
C
D
5.
Viewing Different Files at once
A
B
C
D
6.
Saving a Workspace
A
B
C
D
Named Ranges
1.
Naming individual and ranges of cells
A
B
C
D
2.
Deleting and amending named ranges
A
B
C
D
3.
Using named cells/ranges in formulae
A
B
C
D
4.
Named ranges as a navigation aid
A
B
C
D
5.
Applying names retrospectively
A
B
C
D
Sort and Filter
1.
Sorting Data
A
B
C
D
2.
Using Autofilter
A
B
C
D
3.
Using Advanced Filter
A
B
C
D
Pivot Tables and Charts
1.
Inserting Pivot Table
A
B
C
D
2.
Changing the Pivot Table Layout
A
B
C
D
3.
Pivot Chart
A
B
C
D
What If situations
1.
Setting up Scenarios
A
B
C
D
2.
Using Goal Seek and Solver
A
B
C
D
Views, Tracking, Protecting Import and Export
1.
Creating and using Custom Views
A
B
C
D
2.
Sharing a File
A
B
C
D
3.
Tracking changes
A
B
C
D
4.
[hidden Question default:Protecting Cells, Sheets, Files "Protecting Cells, Sheets, Files"]
Protecting Cells, Sheets, Files
A
B
C
D
5.
Password Protecting a cell range
A
B
C
D
6.
Importing / Exporting Text files
A
B
C
D
Subtotal and Outlining
1.
Outlining Spreadheets
A
B
C
D
2.
Adding Subtotals on a list
A
B
C
D
Macros
1.
Recording Macros
A
B
C
D
2.
Absolute and Relative recording files
A
B
C
D
3.
Personal Macro Workbook
A
B
C
D
4.
Running Macros
A
B
C
D
5.
Assigning Macro to a toolbar Button
A
B
C
D
VBA
1.
Using the Visual Basic Editor
A
B
C
D
2.
Navigating in a Module
A
B
C
D
3.
Inserting and Removing Modules
A
B
C
D
4.
Reassigning Keyboard Shortcuts
A
B
C
D
5.
Running Subroutines together
A
B
C
D
6.
Using Step Mode
[radio Using-Step-Mode use_label_element id:topic_794 "A]
[radio Using-Step-Mode use_label_element id:topic_794 "B]
[radio Using-Step-Mode use_label_element id:topic_794 "C]
D
7.
Using Object Browser
A
B
C
D
8.
Use of Arguments in functions
A
B
C
D
9.
Using Constants
A
B
C
D
10.
Compiling Code using IF structure
A
B
C
D
11.
Using Select Case
A
B
C
D
12.
Using the Immediate Window
A
B
C
D
13.
Using the Toggle Breakpoint
A
B
C
D
14.
[hidden Question default:Generating Combobox, Checkbox, Msgbox "Generating Combobox, Checkbox, Msgbox"]
Generating Combobox, Checkbox, Msgbox
A
B
C
D
15.
Creating Userforms
A
B
C
D
16.
Creating Custom Menus
A
B
C
D
17.
Using Event Procedures
A
B
C
D
18
Using Looping structure
A
B
C
D
Many thanks for completing the LNA form.
Please use the comment box below to tell us any topics or features of the application that you think
