Microsoft Excel 2019 Part 1 Pre/Post Assessment Exam

1. What is Excel 2016's primary task?

Calculating values

Writing letters

Presenting ideas

Editing images

Communicating with others

2. True or False? Excel 2016 can reference cells within its worksheet, from another worksheet, and from another worksheet in a different workbook.

True

False

3. What is a cell, or ranges of cells, referred to when the reference to that cell does not change when moving or copying a formula from one cell to another?

Absolute Referencing

Relative Referencing

Structured Referencing

Circular Reference

Conditional Referencing

4. What object in an Excel 2016 spreadsheet do you input, store, and manipulate data?

Column Header

Row Header

Formula Bar

Cell

Text box

5. True of False? An excel workbook can have a maximum of 255 worksheets.

True

False

6. What are individual pieces of information about workbook files that can help you search for and identify particular workbook files?

RSS

Meta-text

Workbook Properties

Workbook Synopsis

ASCII text

7. Most functions have arguments. What characters does Excel 2016 use to enclose the arguments?

Braces { }

Brackets [ ]

Parenthesis ( )

Quotations " "

Pipes | |

8. The Clear command, on the Home tab in the Editing group, has all of these commands except one. What is NOT on the Clear command?

Clear All

Clear Formats

Clear Hyperlinks

Clear Comments

Clear Themes

9. Which one of the following is NOT a valid operator in the Excel 2016 environment?

Carat ^

Plus +

Forward Slash /

Asterisks *

Hash mark #

10. In Excel 2016, which one of the following is NOT an option in the Find and Replace dialog box?

Use wildcards

Match case

Match entire cell contents

Options

Format…

11. Which of the following is the correct answer to this equation? = 2 + 8 / 4 * 3

7.5

8

2.67

9

0.84

12. What feature allows you to copy or fill a series by clicking and dragging the bottom right corner of a cell?

FlashFill

InstantFill

AutoFill

Copy & Paste

Refresh All

13. True or False? All of Excel 2016 features are backwards compatible.

True

False

14. Which Microsoft Office feature allows you to click on a cell, click the feature, and then apply that formatting to another cell or range of cells?

Format Duplicator

Format Themes

Format Styles

Format Painter

Format Again

15. True or False? You cannot add another dictionary to Excel 2016.

True

False

16. Which is a way that allows you to copy a worksheet to another position in a workbook?

Move or Copy Sheet… from the Format command in the Editing group on the Home tab.

Right-click the worksheet tab drag to the desired position.

Click and drag the worksheet tab to the desired position.

Copy and Paste the worksheet tab to the desired positon.

17. Which one of the following is NOT a Number Format category?

General

Fraction

Exponential

Scientific

Special

18. Excel 2016 is an XML based format that allows Excel 2016 to compress files when you close them. How much compression is possible?

10%

25%

50%

75%

100%

19. The Page Setup dialog allow you to do all of the following except which one?

Adjust margins

Add Headers and Footers

Change Print Quality

Change the color of a cell

Add a picture to the worksheet

20. What Microsoft Office feature allows a user to temporarily preview formatting before applying the formatting?

Microsoft Preview

Instant Formatting

Live Preview

Real-time Formatting

Preview Now

21. What feature on the ribbon allows you to type into a search box to find particular ribbon commands?

Help

Tell Me

Ribbon Commands

Clippy

Ask Me

22. Which of the following is not a way to resize a column?

Double-click the right line between the column headers

Click and drag the right line between the column headers

Right-click a cell in the column and choose Column width...

Choose Default width from the Format command in the Cells group on the Home tab

Choose Column Width... from the Format command in the Cells group on the Home tab

23. Which feature would you use when you want to select all of the blank cells within your selection?

Go To Blank…

Go To Special...

Find…

Go to Select…

Go to Null Values…

24. What feature automatically recognizes patterns across row as data is entered and then fills the pattern down a column??

Concatenation

Auto Fill

Relative Referencing

On-demand Input

Flash Fill

25. Which reference operator tells Excel to look for a value in the cell where two ranges intersect?

Space

Comma

Colon

Semi-color

Quotation marks

Microsoft Excel 2019 Part 1 Pre/Post Assessment Exam

1. What is Excel 2016's primary task?

2.

What first name or nickname would you like us to use?

2. True or False? Excel 2016 can reference cells within its worksheet, from another worksheet, and from another worksheet in a different workbook.

3. What is a cell, or ranges of cells, referred to when the reference to that cell does not change when moving or copying a formula from one cell to another?

4. What object in an Excel 2016 spreadsheet do you input, store, and manipulate data?

5. True of False? An excel workbook can have a maximum of 255 worksheets.

6. What are individual pieces of information about workbook files that can help you search for and identify particular workbook files?

7. Most functions have arguments. What characters does Excel 2016 use to enclose the arguments?

8. The Clear command, on the Home tab in the Editing group, has all of these commands except one. What is NOT on the Clear command?

9. Which one of the following is NOT a valid operator in the Excel 2016 environment?

10. In Excel 2016, which one of the following is NOT an option in the Find and Replace dialog box?

11. Which of the following is the correct answer to this equation? = 2 + 8 / 4 * 3

12. What feature allows you to copy or fill a series by clicking and dragging the bottom right corner of a cell?

13. True or False? All of Excel 2016 features are backwards compatible.

14. Which Microsoft Office feature allows you to click on a cell, click the feature, and then apply that formatting to another cell or range of cells?

15. True or False? You cannot add another dictionary to Excel 2016.

16. Which is a way that allows you to copy a worksheet to another position in a workbook?

17. Which one of the following is NOT a Number Format category?

18. Excel 2016 is an XML based format that allows Excel 2016 to compress files when you close them. How much compression is possible?

19. The Page Setup dialog allow you to do all of the following except which one?

20. What Microsoft Office feature allows a user to temporarily preview formatting before applying the formatting?

21. What feature on the ribbon allows you to type into a search box to find particular ribbon commands?

22. Which of the following is not a way to resize a column?

23. Which feature would you use when you want to select all of the blank cells within your selection?

24. What feature automatically recognizes patterns across row as data is entered and then fills the pattern down a column??

25. Which reference operator tells Excel to look for a value in the cell where two ranges intersect?