Microsoft Excel 2019 Part 1 Pre/Post Assessment Exam
.
- 1.
What feature on the ribbon allows you to type into a search box to find particular ribbon commands?
- A.
Help
- B.
Tell Me
- C.
Ribbon Commands
- D.
Clippy
- E.
Ask Me
Correct Answer
B. Tell Me -
- 2.
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?
- A.
Absolute Referencing
- B.
Relative Referencing
- C.
Structured Referencing
- D.
Circular Reference
- E.
Conditional Referencing
Correct Answer
A. Absolute Referencing -
- 3.
Most functions have arguments. What characters does Excel 2016 use to enclose the arguments?
- A.
Braces { }
- B.
Brackets [ ]
- C.
Parenthesis ( )
- D.
Quotations " "
- E.
Pipes | |
Correct Answer
C. Parenthesis ( ) -
- 4.
What object in an Excel 2016 spreadsheet do you input, store, and manipulate data?
- A.
Column Header
- B.
Row Header
- C.
Formula Bar
- D.
Cell
- E.
Text box
Correct Answer
D. Cell -
- 5.
What are individual pieces of information about workbook files that can help you search for and identify particular workbook files?
- A.
RSS
- B.
Meta-text
- C.
Workbook Properties
- D.
Workbook Synopsis
- E.
ASCII text
Correct Answer
C. Workbook Properties -
- 6.
What Microsoft Office feature allows a user to temporarily preview formatting before applying the formatting?
- A.
Microsoft Preview
- B.
Instant Formatting
- C.
Live Preview
- D.
Real-time Formatting
- E.
Preview Now
Correct Answer
C. Live Preview -
- 7.
What feature automatically recognizes patterns across row as data is entered and then fills the pattern down a column??
- A.
Concatenation
- B.
Auto Fill
- C.
Relative Referencing
- D.
On-demand Input
- E.
Flash Fill
Correct Answer
E. Flash Fill -
- 8.
What is Excel 2016's primary task?
- A.
Calculating values
- B.
Writing letters
- C.
Presenting ideas
- D.
Editing images
- E.
Communicating with others
Correct Answer
A. Calculating values -
- 9.
Which of the following is the correct answer to this equation? = 2 + 8 / 4 * 3
- A.
7.5
- B.
8
- C.
2.67
- D.
9
- E.
0.84
Correct Answer
B. 8 -
- 10.
True or False? All of Excel 2016 features are backwards compatible.
- A.
True
- B.
False
Correct Answer
A. True -
- 11.
True of False? An excel workbook can have a maximum of 255 worksheets.
- A.
True
- B.
False
Correct Answer
A. True -
- 12.
Excel 2016 is an XML based format that allows Excel 2016 to compress files when you close them. How much compression is possible?
- A.
10%
- B.
25%
- C.
50%
- D.
75%
- E.
100%
Correct Answer
D. 75% -
- 13.
What feature allows you to copy or fill a series by clicking and dragging the bottom right corner of a cell?
- A.
FlashFill
- B.
InstantFill
- C.
AutoFill
- D.
Copy & Paste
- E.
Refresh All
Correct Answer
C. AutoFill -
- 14.
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?
- A.
Clear All
- B.
Clear Formats
- C.
Clear Hyperlinks
- D.
Clear Comments
- E.
Clear Themes
Correct Answer
E. Clear Themes -
- 15.
True or False? Excel 2016 can reference cells within its worksheet, from another worksheet, and from another worksheet in a different workbook.
- A.
True
- B.
False
Correct Answer
A. True -
- 16.
Which one of the following is NOT a valid operator in the Excel 2016 environment?
- A.
Carat ^
- B.
Plus +
- C.
Forward Slash /
- D.
Asterisks *
- E.
Hash mark #
Correct Answer
E. Hash mark # -
- 17.
Which reference operator tells Excel to look for a value in the cell where two ranges intersect?
- A.
Space
- B.
Comma
- C.
Colon
- D.
Semi-color
- E.
Quotation marks
Correct Answer
A. Space -
- 18.
Which of the following is not a way to resize a column?
- A.
Double-click the right line between the column headers
- B.
Click and drag the right line between the column headers
- C.
Right-click a cell in the column and choose Column width...
- D.
Choose Default width from the Format command in the Cells group on the Home tab
- E.
Choose Column Width... from the Format command in the Cells group on the Home tab
Correct Answer
C. Right-click a cell in the column and choose Column width... -
- 19.
In Excel 2016, which one of the following is NOT an option in the Find and Replace dialog box?
- A.
Use wildcards
- B.
Match case
- C.
Match entire cell contents
- D.
Options
- E.
Format…
Correct Answer
A. Use wildcards -
- 20.
Which feature would you use when you want to select all of the blank cells within your selection?
- A.
Go To Blank…
- B.
Go To Special...
- C.
Find…
- D.
Go to Select…
- E.
Go to Null Values…
Correct Answer
B. Go To Special... -
- 21.
True or False? You cannot add another dictionary to Excel 2016.
- A.
True
- B.
False
Correct Answer
A. True -
- 22.
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?
- A.
Format Duplicator
- B.
Format Themes
- C.
Format Styles
- D.
Format Painter
- E.
Format Again
Correct Answer
D. Format Painter -
- 23.
Which one of the following is NOT a Number Format category?
- A.
General
- B.
Fraction
- C.
Exponential
- D.
Scientific
- E.
Special
Correct Answer
C. Exponential -
- 24.
The Page Setup dialog allow you to do all of the following except which one?
- A.
Adjust margins
- B.
Add Headers and Footers
- C.
Change Print Quality
- D.
Change the color of a cell
- E.
Add a picture to the worksheet
Correct Answer
D. Change the color of a cell -
- 25.
Which is a way that allows you to copy a worksheet to another position in a workbook?
- A.
Move or Copy Sheet… from the Format command in the Editing group on the Home tab.
- B.
Right-click the worksheet tab drag to the desired position.
- C.
Click and drag the worksheet tab to the desired position.
- D.
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. -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 09, 2020Quiz Edited by
ProProfs Editorial Team -
Jan 09, 2020Quiz Created by
Back to top