Microsoft Excel 2016 Part 1 Pre/Post Assessment Exam
-
What is Excel 2016's primary task?
-
Calculating values
-
Writing letters
-
Presenting ideas
-
Editing images
-
Communicating with others
-
.
Quiz Preview
- 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
Correct Answer
A. True -
- 3.
What object in an Excel 2016 spreadsheet do you input, store, and manipulate data?
-
Column Header
-
Row Header
-
Formula Bar
-
Cell
-
Text box
Correct Answer
A. Cell -
- 4.
True of False? An excel workbook can have a maximum of 255 worksheets.
-
True
-
False
Correct Answer
A. True -
- 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?
-
Absolute Referencing
-
Relative Referencing
-
Structured Referencing
-
Circular Reference
-
Conditional Referencing
Correct Answer
A. Absolute Referencing -
- 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
Correct Answer
A. Workbook Properties -
- 7.
Most functions have arguments. What characters does Excel 2016 use to enclose the arguments?
-
Braces { }
-
Brackets [ ]
-
Parenthesis ( )
-
Quotations " "
-
Pipes | |
Correct Answer
A. Parenthesis ( ) -
- 8.
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…
Correct Answer
A. Use wildcards -
- 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?
-
Clear All
-
Clear Formats
-
Clear Hyperlinks
-
Clear Comments
-
Clear Themes
Correct Answer
A. Clear Themes -
- 10.
Which one of the following is NOT a valid operator in the Excel 2016 environment?
-
Carat ^
-
Plus +
-
Forward Slash /
-
Asterisks *
-
Hash mark #
Correct Answer
A. Hash mark # -
- 11.
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
Correct Answer
A. AutoFill -
- 12.
True or False? All of Excel 2016 features are backwards compatible.
-
True
-
False
Correct Answer
A. True -
- 13.
Which of the following is the correct answer to this equation? = 2 + 8 / 4 * 3
-
7.5
-
8
-
2.67
-
9
-
0.84
Correct Answer
A. 8 -
- 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
Correct Answer
A. Format Painter -
- 15.
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.
Correct Answer
A. Move or Copy Sheet… from the Format command in the Editing group on the Home tab. -
- 16.
True or False? You cannot add another dictionary to Excel 2016.
-
True
-
False
Correct Answer
A. True -
- 17.
Which one of the following is NOT a Number Format category?
-
General
-
Fraction
-
Exponential
-
Scientific
-
Special
Correct Answer
A. Exponential -
- 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%
Correct Answer
A. 75% -
- 19.
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
Correct Answer
A. Tell Me -
- 20.
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
Correct Answer
A. Right-click a cell in the column and choose Column width... -
- 21.
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
Correct Answer
A. Live Preview -
- 22.
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
Correct Answer
A. Change the color of a cell -
- 23.
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
Correct Answer
A. Flash Fill -
- 24.
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…
Correct Answer
A. Go To Special... -
- 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
Correct Answer
A. Space -
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, 2022Quiz Edited by
ProProfs Editorial Team -
Sep 23, 2016Quiz Created by
Back to top