Data Creative | Excel Assessment Quiz

Excel Assessment Quiz

Unlock Your Potential with Excel Mastery: Take the Assessment Quiz Today!

"*" indicates required fields

Step 1 of 8

12%

Taking a Microsoft Excel assessment quiz is more than just a test; it’s a strategic move towards unlocking your full potential and advancing your career. Excel expertise is a highly sought-after skill in today’s data-driven economy, with employers across all industries valuing those who can demonstrate mastery in spreadsheet analysis and data management. By taking an Excel assessment quiz, you can showcase your skills and qualifications.

Don’t wait – take the quiz today and embark on your journey to Excel mastery and career success!

Basic Courses

Level 1: Introduction
Level 2: Tables & Charts
Level 3: Formulas & Functions

Advanced Courses

Level 4: Advanced Features + Macros
Level 5: Pivot Tables
Level 6: Power Pivot

Choose Course Type

Basic

Advanced

Level 1: Introduction

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: Advanced Features + Macros

What is the purpose of a macro?*

To increase the productivity of formulas and functions

To automate the functions process

To automate repetitive tasks

To increase the point size of spreadsheets with small font

What is a histogram used for?*

To accurately organize historical data chronologically

To organize list data into user defined bin ranges

To provide a graphical representation of a range chronologically

To create a visual representation of list data

What is the primary function of data validation?*

To ensure the data type entered on a spreadsheet meets specific criteria

To ensure the data typed on a spreadsheet is valid

To add drop down lists to worksheets

All of these are correct

None of these are correct

What is quick data analysis?*

A tool that quickly associates spreadsheet data with matching built in functions

A tool that analyzes spreadsheet data and offers the correct function category

A tool that offers to arrange selected data into charts, tables, sparklines and other features

A took that gives insights about data inserted into charts, tables, sparklines and other features

Level 5: 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

Level 6: Power Pivot

How do you relate excel lists in power pivot so they can be queried into a pivot table?*

You cannot relate excel lists, that is done in a relational database

Merge the lists into a singular list making them related

On the ribbon, use the relationships button providing the spreadsheets have like data to match

Export the lists to a database, relate them, then import them as related pivot tables

What is the purpose of a Primary Key/Unique identifier?*

It allows a rule to be made such as everyone in the IT department moves to the correct table

It assigns a hierarchy to specific named fields avoiding duplication errors

It prevents duplication on any data type in any column of a table

To quickly identify unique values across database tables

How is a Hierarchy created within Power pivot and then displayed in a pivot table?*

On the insert tab of the ribbon in excel, click the hierarchy button

Select the data you want included in the hierarchy, on the power pivot ribbon, click hierarchy

Choose diagram view from power pivot, click the hierarchy button on the table, select the data

Hierarchies are not created in power pivot, they must be done within the pivot table itself

How is a calculated field created in power pivot?*

From the ribbon click fields, items, and sets; click create field, then add it to the table

Click the first blank column header, build the formula by clicking a cell in the other columns as needed, press enter when finished

Insert a new column in the table, from the formulas tab on the ribbon choose the function and build the formula. Press enter when finished

From the ribbon, choose create calculated field, select formula from Intellisense

Enter your contact info to see the recommended courses for you

Full Name*

Phone*

Email*

Supervisor Email*

The Leading Classes Business App That Empowers Learners Around The World To Unlock Their Learning Potential!

Classes

Microsoft Excel
Microsoft Office
Adobe Creative Cloud
SQL
Microsoft Power BI
Microsoft Azure
Microsoft Power Platform
Microsoft Security
Python
Smartsheet
Tableau
Amazon Web Services (AWS)
CompTIA
IT Related Certifications

Quick Links

About
Certifications
Blog
Tutorials
Contact Us

Website designed by WPXStudios

Excel Assessment Quiz

Basic Courses

Advanced Courses

Level 1: Introduction

Level 2: Tables & Charts

Level 3: Formulas & Functions

Level 4: Advanced Features + Macros

Level 5: Pivot Tables

Level 6: Power Pivot

Enter your contact info to see the recommended courses for you

Register Now