Step 1 of 6

16%

Taking our FREE Excel Essentials quiz is a smart move, whether you’re searching for a new job or keen to enhance your skills in your current position. Excel proficiency is a highly valued asset in today’s data-driven world, with employers across all sectors appreciating individuals who “excel” in spreadsheet analysis and data management. By completing our free Excel Essentials quiz, you can:

Objectively evaluate your current skills
Identify areas where you can improve
Increase your chances of securing desirable job opportunities
Boost your productivity and efficiency in your current role
Demonstrate your expertise to employers
Open doors to career advancement

Take the quiz today and embark on your journey towards Excel mastery and career success!

Do you Know Microsoft Excel?

Level 1: User Essentials
Level 2: Tables & Charts
Level 3: Formulas & Functions
Level 4: Pivot Tables

Start Quiz

Basic

Level 1: User Essentials

What purpose does the fill handle serve?*

Selecting cells

Populating a series

Filling a range with background fill color

Populating a dynamic range with series values

How is a cell made into an absolute reference?*

By creating a formula based on the cell

By adding dollar symbols to the row and column of the cell

By adding a data table to reference the cell value

Open the shortcut menu to select Absolute Reference

How do you access the built in Functions?*

Click the FX button on the formula bar

Choose from the function library on the Formula tab of the ribbon

Start typing then use the intellisense drop down menu

All of these are correct

None of these are correct

What are the basic math operators in Excel?*

\ + – *

/ + – *

/ + – X

None of these are correct

Level 2: Tables & Charts

What are the choices for making a table?*

Select a group of cells and add gridlines

Use the CTRL + T keyboard shortcut

Insert one from the tables group in the ribbon

Number 1 and 2 are correct

Number 2 and 3 are correct

None of these are correct

How is a named range created?*

Add a heading row at the beginning of a contiguous data range

Add the name from the defined names group in the ribbon

Add the name from the data tools group in the ribbon

Insert a table, name the table in the table name box

How do you run a criterion-based auto filter on a table or pivot table?*

Filter options are available with the drop-down AutoFilter arrows

Select the table. On the Data tab of the ribbon, click the Filter button to run the AutoFilter

Criteria based AutoFilters cannot be performed on tables as they are Dynamic ranges

Select the table. On the Home tab, select Format as a Table and choose the AutoFilter option

What steps are involved to total figures across multiple sheets?*

Totals cannot be created across multiple sheets

Sum the totals for each sheet then enter the total in the destination sheet

Create a 3D reference in the destination sheet

Create a link to the figures on the sheets then sum them in the destination sheet

Level 3: Formulas & Functions

How do you join multiple varying length strings into a single cell?*

You do not join multiple strings as you cannot sort cells with multiple entries

Use the merge string function

Merge the cells with the strings together

Use the concatenate function

How do you extrapolate specific characters from within a string?*

You copy them from the origin string and paste them to the new location

You use the split columns function

You use the mid function

You use the flash fill

What is the purpose of nested functions?*

When you need to use multiple operators such as 10+10/3

When you need to create a hyperlink based on a formula

When you need to add specificities to a function

When you need to organize your functions for readability

How do you select non contiguous data?*

Using the mouse, click and drag to select the range you want

Using the mouse, drag the first range you want; hold down the shift key and drag the next

Select the first range you want, hold down the ctrl key and select the next range

Click the beginning cell, then shift click the last cell In the range you want selected

Level 4: Pivot Tables

How do you create a pivot table based on a database?*

Copy the database table, paste into a spreadsheet, insert a pivot table

Create the pivot table in the database, export it into an Excel spreadsheet

Connect to the data source and create the pivot table

Import the data from the database into excel, save the data, create a pivot table

Which of these are considered dynamic ranges when used with a pivot table?*

A contiguous range from another spreadsheet or workbook

A range from the current workbook on the current spreadsheet

A table from any data source that is connected

A contiguous or noncontiguous range from another workbook or spreadsheet

How do you generate a pivot chart from a pivot table?*

Select the data you want in the chart, and from the insert tab of the ribbon choose the chart type

Copy the data to a new spread sheet, from the insert tab of the ribbon choose the chart type

In the Pivot Table tools on the ribbon, click the chart button

Pivot data cannot be made into a chart, it would lose the pivot feature

How do you add custom fields to a pivot table?*

Click the first blank row or column from your data and add the function of your choice

You cannot add custom fields to a pivot table it is a locked non editable range

From the pivot table tools choose fields, items, and sets

From the formulas tab on the ribbon, choose the function you want applied to the range data

Enter your contact info to see the recommended courses for you

Full Name*

Phone*

Email*

Supervisor Email*

Excel Essentials Quiz

Do you Know Microsoft Excel?

Level 1: User Essentials

Level 2: Tables & Charts

Level 3: Formulas & Functions

Level 4: Pivot Tables

Enter your contact info to see the recommended courses for you

Get in Touch