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

Advertisement