Welcome to our assessment tool!

You or your instructor may choose to use this self-evaluation in various ways: as a check of your baseline knowledge before taking the course, to evaluate your progress as you learn, and/or as a follow up to verify your understanding of the material. We hope using this tool will be a positive experience that supports your learning and development.

Please note that this assessment is based on a Windows Operating System.

Name*

First Last

Email*

Enter Email Confirm Email

Company

Department

Assessment questions

How will you select an entire worksheet?*

In the Name Box, type Select All and press Enter.

Below the Name Box, click the Select All button.

In the Formula Bar text box, type Select All.

On the Sheet navigation bar, click on the Sheet1 tab.

Which of these print settings affects the magnification level of printed data?*

Paper Size

Collating

Orientation

Scaling

What is the default file format for Excel 2019 files?*

.xlsx

.xltx

.xlsb

.xlsm

True or False? In Excel, you may hide either rows or columns temporarily.*

True

False

In an arthimetic formula, which is used to group computation instructions?*

Plus sign ( + )

Open and closed parentheses ( )

Asterisk ( * )

Which of the following is true about options available for managing Excel worksheet tabs?*

You can rename worksheets

You can rearrange worksheets

You can modify the worksheet tab color

All are correct

You have a formula in an Excel cell that states =SUM(A1, A3, A5, A10). Which of the following results would you expect Excel to display?*

Adding only the odd cells from A1 to A10

Adding all values from A1 to A10

Average all values from A1 to A10

Adding only A1, A3, A5, and A10 specifically

Which of the following commands in Excel doesn't affect the text font?*

Italic

Underline

Bold

Borders

What type of cell reference is A4 an example of?*

Absolute

Relative

Worksheet

Mixed

Which formula is complete?*

#A5+A6

A5+A6

(A5+A6)

=A5+A6

Excel enables you to perform which of the following actions using the Find and Replace dialog box?*

Locate particular content anywhere within a workbook.

Replace the contents of a single cell with new data.

Replace all instances of a particular entry with another entry simultaneously.

All answers are correct

True or False? If you apply number formatting to a cell to reduce the number of decimal places shown to 1, the underlying value in the cell does not change.*

True

False

In Excel, what does a SUM function do?*

Divides Values

Subtracts Values

Adds Values

Creates an Average

You have a formula in an Excel cell that states =SUM(A5:A10). Which of the following results would you expect Excel to display?*

Adding only the odd cells from A5 to A10

Adding only A5 and A10 specifically

Average all values from A5 to A10

Adding all values from A5 to A10

Which are elements of Excel functions?*

Equal sign

Arguments

Function Name

All are correct

True or False? The Quick Access Toolbar is a temporary pop-up window that provides you with quick access to common text editing commands.*

True

False

True or False? Hiding rows and columns affects formulas with references to cells in those rows and columns.*

True

False

Which of the following is a method to navigate to a specific cell, say cell D80?*

Press Page Up

In the Name Box, type D80 and press Enter.

In the Formula Bar text box, type D80 and press Enter.

Press Page Down.

True or False: A relative reference in a formula never changes when the formula is copied and pasted.*

True

False

An absolute reference in a formula looks like which of the following:*

= abs (A5)

$A$5

A5+ A6

A5

True or False? You can search for Excel templates online, but you cannot create custom templates.*

True

False

In Excel, what does an AVERAGE function do?*

Returns the Count of the arguments

Returns the Average value of the arguments

Returns the Difference of the arguments

Returns the Sum of the arguments

In cell A10, you have a formula that states =SUM($C$10:$C$15). True or False? If you copy this formula and paste to cell A11, the formula will not change.*

True

False

Which of the following statement is true regarding cutting data in Excel?*

You can only cut all of a cell's data at once.

Cutting cell data and then pasting it in another cell leaves the original data intact.

Cutting cell data and then pasting it in another cell removes the original data.

Cutting data is not possible in Excel

True or False? Excel formulas always begin with a plus sign*

True

False

Which of the following statement about conditional formatting is true?*

Cell values do not affect it.

By default, it applies to all data in a worksheet.

By default, it applies to all data in a workbook.

It uses defined criteria to apply formatting.

True or False? Merging cells can cause data loss.*

True

False

Which reference describes a cell reference to the first five cells in column A of a worksheet?*

A1:E1

A1:A5

A1:E5

A1:5A

The 'Save As' command is used for which of the following scenarios:*

When you need to create a new file name, file type or file location

When you need to create a new worksheet

When you need to change the print settings of a file

When you need to Open the most recent file

True or False? Auto-fill can be used to copy/paste formulas in a region.*

True

False

Excel Beginners Assessment

Assessment questions

Questions?