Microsoft Excel 2019 Part 1 Pre/Post Assessment Exam

Please wait...
Question 1 / 25
0 %
0/100
Score 0/100
1. What is Excel 2016's primary task?
Submit
Please wait...
About This Quiz
Microsoft Excel 2019 Part 1 Pre/Post Assessment Exam - Quiz

.

Personalize your quiz and earn a certificate with your name on it!
2. True or False? Excel 2016 can reference cells within its worksheet, from another worksheet, and from another worksheet in a different workbook.
Submit
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?
Submit
4. What object in an Excel 2016 spreadsheet do you input, store, and manipulate data?
Submit
5. True of False? An excel workbook can have a maximum of 255 worksheets.
Submit
6. What are individual pieces of information about workbook files that can help you search for and identify particular workbook files?
Submit
7. Most functions have arguments. What characters does Excel 2016 use to enclose the arguments?
Submit
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?
Submit
9. Which one of the following is NOT a valid operator in the Excel 2016 environment?
Submit
10. In Excel 2016, which one of the following is NOT an option in the Find and Replace dialog box?
Submit
11. Which of the following is the correct answer to this equation? = 2 + 8 / 4 * 3
Submit
12. What feature allows you to copy or fill a series by clicking and dragging the bottom right corner of a cell?
Submit
13. True or False? All of Excel 2016 features are backwards compatible.
Submit
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?
Submit
15. True or False? You cannot add another dictionary to Excel 2016.
Submit
16. Which is a way that allows you to copy a worksheet to another position in a workbook?
Submit
17. Which one of the following is NOT a Number Format category?
Submit
18. Excel 2016 is an XML based format that allows Excel 2016 to compress files when you close them. How much compression is possible?
Submit
19. The Page Setup dialog allow you to do all of the following except which one?
Submit
20. What Microsoft Office feature allows a user to temporarily preview formatting before applying the formatting?
Submit
21. What feature on the ribbon allows you to type into a search box to find particular ribbon commands?
Submit
22. Which of the following is not a way to resize a column?
Submit
23. Which feature would you use when you want to select all of the blank cells within your selection?
Submit
24. What feature automatically recognizes patterns across row as data is entered and then fills the pattern down a column??
Submit
25. Which reference operator tells Excel to look for a value in the cell where two ranges intersect?
Submit
View My Results

Quiz Review Timeline (Updated): +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jan 09, 2020
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 09, 2020
    Quiz Created by
Cancel
  • All
    All (25)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
What is Excel 2016's primary task?
True or False? Excel 2016 can reference cells within its worksheet,...
What is a cell, or ranges of cells, referred to when the reference to...
What object in an Excel 2016 spreadsheet do you input, store, and...
True of False? An excel workbook can have a maximum of 255 worksheets.
What are individual pieces of information about workbook files that...
Most functions have arguments. What characters does Excel 2016 use to...
The Clear command, on the Home tab in the Editing group, has all of...
Which one of the following is NOT a valid operator in the Excel 2016...
In Excel 2016, which one of the following is NOT an option in the Find...
Which of the following is the correct answer to this equation? = 2 + 8...
What feature allows you to copy or fill a series by clicking and...
True or False? All of Excel 2016 features are backwards compatible.
Which Microsoft Office feature allows you to click on a cell, click...
True or False? You cannot add another dictionary to Excel 2016.
Which is a way that allows you to copy a worksheet to another position...
Which one of the following is NOT a Number Format category?
Excel 2016 is an XML based format that allows Excel 2016 to compress...
The Page Setup dialog allow you to do all of the following except...
What Microsoft Office feature allows a user to temporarily preview...
What feature on the ribbon allows you to type into a search box to...
Which of the following is not a way to resize a column?
Which feature would you use when you want to select all of the blank...
What feature automatically recognizes patterns across row as data is...
Which reference operator tells Excel to look for a value in the cell...
Alert!

Advertisement