Microsoft Excel 2019 Part 2 Pre/Post Assessment Exam
.
- 1.
What feature in Excel 2016 enables users to organize datasets into hierarchical groups?
- A.
Subtotals
- B.
Indentation
- C.
Outdent
- D.
Collapse / Expand
- E.
Outline
Correct Answer
E. Outline -
- 2.
Which is NOT a valid cell name?
- A.
Cell Name1
- B.
CellName1
- C.
Cell_Name
- D.
Cell_Name_1
Correct Answer
A. Cell Name1 -
- 3.
Which of the following is the correct syntax for the TODAY function?
- A.
=TODAY(Date)
- B.
=TODAY()
- C.
=TODAY(05/05/2016)
- D.
=TODAY(A1)
- E.
=TODAY(A1:B2)
Correct Answer
B. =TODAY() -
- 4.
Which of the following is NOT a LOGICAL FUNCTION?
- A.
GREATER THAN
- B.
OR
- C.
NOT
- D.
AND
Correct Answer
A. GREATER THAN -
- 5.
Once you have sorted a table in Ascending order, how do you remove the sort?
- A.
Click Clear Sort in the Sort command in the Sort & Filter group on the Data tab.
- B.
Right-click and choose Remove Sort.
- C.
Use the Undo command.
- D.
Save the workbook, close it and reopen it.
- E.
Sort another column.
Correct Answer
C. Use the Undo command. -
- 6.
You have sorted three columns in sequence. Which one is the primary sort.
- A.
First column you sorted
- B.
Second column you sorted
- C.
Third column you sorted
- D.
None of the columns are sorted
- E.
You must use the Sort command to perform this task
Correct Answer
C. Third column you sorted -
- 7.
To perform and advanced filter, what is one of the two items that needs to be defined in the Advanced Filter dialog box?
- A.
Cell Range
- B.
Worksheet Range
- C.
Named Range
- D.
List Range
Correct Answer
D. List Range -
- 8.
True or False? You can identify database functions because the function names are preceded by the letter D.
- A.
True
- B.
False
Correct Answer
A. True -
- 9.
What function set allows you to perform calculations on subsets of data?
- A.
SUBSETS
- B.
LOOKUP
- C.
SEARCH
- D.
SUBTOTAL
- E.
VALUE
Correct Answer
D. SUBTOTAL -
- 10.
What is a trendline?
- A.
A graphical representation which follows the exact placement of data points.
- B.
The algorithm Excel 2016 uses when saving documents in 97-2003 format.
- C.
The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series.
- D.
A line connecting data labels to their respective data points.
- E.
A line which conforms to a Company's Standards and Guidelines.
Correct Answer
C. The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series. -
- 11.
What is an array?
- A.
A range of cells highlighted in Excel 2016.
- B.
Multiple worksheets grouped together.
- C.
A visual depiction of values from a range of cells.
- D.
The individual values saved in a range of individual cells.
- E.
A range of data entered into a computer's memory and accessed by Excel 2016.
Correct Answer
E. A range of data entered into a computer's memory and accessed by Excel 2016. -
- 12.
What key-stroke combination is required to create an array?
- A.
Control + Shift + Enter
- B.
Control + Enter
- C.
Alt + Shift + Enter
- D.
Alt + Enter
- E.
Control + Shift + Alt + Enter
Correct Answer
A. Control + Shift + Enter -
- 13.
What is a graphical representation of numerical values and relationships in a dataset?
- A.
Trendlines
- B.
Charts
- C.
Category / Value Axis'
- D.
Elements
- E.
CubeSet
Correct Answer
B. Charts -
- 14.
What is a PivotTable?
- A.
An interactive table that summarizes, organizes, and compares large amounts of worksheet data.
- B.
A chart with embedded data which can be manipulated.
- C.
An Excel tool which allows you to pivot between a Word Table and an Excel spreadsheet.
- D.
A static table that summarizes, organizes, and compares large amounts of worksheet data.
- E.
An Excel element that allows you to filter data in a static worksheet.
Correct Answer
A. An interactive table that summarizes, organizes, and compares large amounts of worksheet data. -
- 15.
PivotTable work best with Transactional Data. What is Transactional Data?
- A.
Raw data that has been summarized.
- B.
Data with both column labels and row labels.
- C.
Summarized data with row labels.
- D.
Raw data with column labels.
- E.
Summarized data with column labels.
Correct Answer
D. Raw data with column labels. -
- 16.
Ture or False? A PivotTable works best when there are no duplicates in any column.
- A.
True
- B.
False
Correct Answer
A. True -
- 17.
Which function allows you to generate a summary from a PivotTable and place it elsewhere in a worksheet?
- A.
PIVOTDATA
- B.
SUMPIVOTDATA
- C.
ANALYZEPVT
- D.
GETPIVOTDATA
- E.
ANALYZEPIVOTDATA
Correct Answer
D. GETPIVOTDATA -
- 18.
Which feature allows you to filter by any date entries in a PivotTable?
- A.
DATETIME
- B.
Timeline
- C.
Chronological Filter
- D.
Quantum Analysis
- E.
ISOWEEKNUM
Correct Answer
B. Timeline -
- 19.
You have selected a range of cells across multiples and would like to name each column by it's column label name. Which command would you use?
- A.
Define Name in the Defined Names group on the Formulas tab.
- B.
Use in Formula in the Defined Names group on the Formulas tab.
- C.
Name Manger in the Defined Names group on the Formulas tab.
- D.
Create from Selection in the Defined Names group on the Formulas tab.
- E.
Use Label Names in the Defined Names group on the Formulas tab.
Correct Answer
D. Create from Selection in the Defined Names group on the Formulas tab. -
- 20.
You are using the Formula AutoComplete to write your functions. Name a method you can use to enter the function or named range into the cell?
- A.
Click once on the function or named range.
- B.
Highlight the function or named range and press the Tab key.
- C.
Highlight the function or named range and press the Enter key.
- D.
Highlight the function or named range and press the right arrow key.
Correct Answer
B. Highlight the function or named range and press the Tab key. -
- 21.
The default calculation method in Excel 2016 is to Automatically calculate the work book. What other four options are available?
- A.
Automatic Except for Data Tables
- B.
Manual
- C.
Calculate Now
- D.
Calculate on Save
- E.
Calculate Sheet
Correct Answer
D. Calculate on Save -
- 22.
Where would you find, and be able to use, all of the functions available to Excel 2016 in one dialog box?
- A.
More Functions in the Function Library group on the Formulas tab
- B.
More Functions in the Function Library group on the Data tab
- C.
Insert Function in the Function Library group on the Formulas tab
- D.
Insert Function in the Function Library group on the Data tab
- E.
Click Help and type Functions.
Correct Answer
C. Insert Function in the Function Library group on the Formulas tab -
- 23.
What function adds all of its arguments that meet multiple criteria?
- A.
SUMIF
- B.
COUNTIF
- C.
OFFSET
- D.
SUMIFS
- E.
SUBTOTAL
Correct Answer
D. SUMIFS -
- 24.
In Excel 2016, what is the term used when placing a function or formula inside of another function or formula?
- A.
Grouping
- B.
Inserting
- C.
Placing
- D.
Combining
- E.
Nesting
Correct Answer
E. Nesting -
- 25.
True or False? To change the data of a chart, you must delete the chart and reinsert it using it's saved Template.
- A.
True
- B.
False
Correct Answer
A. True -
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