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
True or False: A relative reference in a formula never changes when the formula is copied and pasted.*
- True
- False

Save and Continue Later

Which of the following is a method to navigate to a specific cell, say cell D80?*
- In the Name Box, type D80 and press Enter.
- Press Page Down.
- In the Formula Bar text box, type D80 and press Enter.
- Press Page Up

Save and Continue Later

Which of the following statement is true regarding cutting data in Excel?*
- Cutting cell data and then pasting it in another cell removes the original data.
- 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 data is not possible in Excel

Save and Continue Later

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

Save and Continue Later

Which are elements of Excel functions?*
- Equal sign
- Arguments
- Function Name
- All are correct

Save and Continue Later

In Excel, what does an AVERAGE function do?*
- Returns the Difference of the arguments
- Returns the Sum of the arguments
- Returns the Count of the arguments
- Returns the Average value of the arguments

Save and Continue Later

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

Save and Continue Later

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

Save and Continue Later

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

Save and Continue Later

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 A1, A3, A5, and A10 specifically
- Average all values from A1 to A10
- Adding only the odd cells from A1 to A10
- Adding all values from A1 to A10

Save and Continue Later

Which of the following commands in Excel doesn't affect the text font?*
- Borders
- Italic
- Underline
- Bold

Save and Continue Later

In Excel, what does a SUM function do?*
- Subtracts Values
- Adds Values
- Creates an Average
- Divides Values

Save and Continue Later

Which formula is complete?*
- #A5+A6
- A5+A6
- (A5+A6)
- =A5+A6

Save and Continue Later

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

Save and Continue Later

Which of the following statement about conditional formatting is true?*
- By default, it applies to all data in a workbook.
- Cell values do not affect it.
- It uses defined criteria to apply formatting.
- By default, it applies to all data in a worksheet.

Save and Continue Later

The 'Save As' command is used for which of the following scenarios:*
- When you need to change the print settings of a file
- When you need to create a new worksheet
- When you need to create a new file name, file type or file location
- When you need to Open the most recent file

Save and Continue Later

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

Save and Continue Later

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

Save and Continue Later

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

Save and Continue Later

In an arthimetic formula, which is used to group computation instructions?*
- Plus sign ( + )
- Plus sign ( + )
- Open and closed parentheses ( )
- Asterisk ( * )

Save and Continue Later

An absolute reference in a formula looks like which of the following:*
- = abs (A5)
- A5+ A6
- A5
- $A$5

Save and Continue Later

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

Save and Continue Later

What is the default file format for Excel 2019 files?*
- .xlsm
- .xlsb
- .xltx
- .xlsx

Save and Continue Later

What type of cell reference is A4 an example of?*
- Absolute
- Relative
- Worksheet
- Mixed

Save and Continue Later

Which of these print settings affects the magnification level of printed data?*
- Orientation
- Collating
- Paper Size
- Scaling

Save and Continue Later

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

Save and Continue Later

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

Save and Continue Later

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 A5 and A10 specifically
- Adding only the odd cells from A5 to A10
- Average all values from A5 to A10
- Adding all values from A5 to A10

Save and Continue Later

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

Save and Continue Later

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.

Save and Continue Later

Excel Beginners Assessment

Step 1 of 30

Assessment questions

Questions?