Microsoft Excel 2016 Part 2 Pre/Post Assessment Exam

SettingsSettings
Please wait...
  • 1/25 Questions

    Which is NOT a valid cell name?

    • Cell Name1
    • CellName1
    • Cell_Name
    • Cell_Name_1
Please wait...
Microsoft Excel 2016 Part 2 Pre/Post Assessment Exam - Quiz
About This Quiz

.


Quiz Preview

  • 2. 

    What is a trendline?

    • A graphical representation which follows the exact placement of data points.

    • The algorithm Excel 2016 uses when saving documents in 97-2003 format.

    • The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series.

    • A line connecting data labels to their respective data points.

    • A line which conforms to a Company's Standards and Guidelines.

    Correct Answer
    A. The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series.
  • 3. 

    What is a graphical representation of numerical values and relationships in a dataset?

    • Trendlines

    • Charts

    • Category / Value Axis'

    • Elements

    • CubeSet

    Correct Answer
    A. Charts
  • 4. 

    What is a PivotTable?

    • An interactive table that summarizes, organizes, and compares large amounts of worksheet data.

    • A chart with embedded data which can be manipulated.

    • An Excel tool which allows you to pivot between a Word Table and an Excel spreadsheet.

    • A static table that summarizes, organizes, and compares large amounts of worksheet data.

    • 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.
  • 5. 

    Ture or False? A PivotTable works best when there are no duplicates in any column.

    • True

    • False

    Correct Answer
    A. True
  • 6. 

    In Excel 2016, what is the term used when placing a function or formula inside of another function or formula?

    • Grouping

    • Inserting

    • Placing

    • Combining

    • Nesting

    Correct Answer
    A. Nesting
  • 7. 

    What key-stroke combination is required to create an array?

    • Control + Shift + Enter

    • Control + Enter

    • Alt + Shift + Enter

    • Alt + Enter

    • Control + Shift + Alt + Enter

    Correct Answer
    A. Control + Shift + Enter
  • 8. 

    Which of the following is the correct syntax for the TODAY function?

    • =TODAY(Date)

    • =TODAY()

    • =TODAY(05/05/2016)

    • =TODAY(A1)

    • =TODAY(A1:B2)

    Correct Answer
    A. =TODAY()
  • 9. 

    True or False? You can identify database functions because the function names are preceded by the letter D.

    • True

    • False

    Correct Answer
    A. True
  • 10. 

    Which of the following is NOT a LOGICAL FUNCTION?

    • GREATER THAN

    • OR

    • NOT

    • AND

    Correct Answer
    A. GREATER THAN
  • 11. 

    What function set allows you to perform calculations on subsets of data?

    • SUBSETS

    • LOOKUP

    • SEARCH

    • SUBTOTAL

    • VALUE

    Correct Answer
    A. SUBTOTAL
  • 12. 

    Once you have sorted a table in Ascending order, how do you remove the sort?

    • Click Clear Sort in the Sort command in the Sort & Filter group on the Data tab.

    • Right-click and choose Remove Sort.

    • Use the Undo command.

    • Save the workbook, close it and reopen it.

    • Sort another column.

    Correct Answer
    A. Use the Undo command.
  • 13. 

    What feature in Excel 2016 enables users to organize datasets into hierarchical groups?

    • Subtotals

    • Indentation

    • Outdent

    • Collapse / Expand

    • Outline

    Correct Answer
    A. Outline
  • 14. 

    PivotTable work best with Transactional Data. What is Transactional Data?

    • Raw data that has been summarized.

    • Data with both column labels and row labels.

    • Summarized data with row labels.

    • Raw data with column labels.

    • Summarized data with column labels.

    Correct Answer
    A. Raw data with column labels.
  • 15. 

    What function adds all of its arguments that meet multiple criteria?

    • SUMIF

    • COUNTIF

    • OFFSET

    • SUMIFS

    • SUBTOTAL

    Correct Answer
    A. SUMIFS
  • 16. 

    Where would you find, and be able to use, all of the functions available to Excel 2016 in one dialog box?

    • More Functions in the Function Library group on the Formulas tab

    • More Functions in the Function Library group on the Data tab

    • Insert Function in the Function Library group on the Formulas tab

    • Insert Function in the Function Library group on the Data tab

    • Click Help and type Functions.

    Correct Answer
    A. Insert Function in the Function Library group on the Formulas tab
  • 17. 

    To perform and advanced filter, what is one of the two items that needs to be defined in the Advanced Filter dialog box?

    • Cell Range

    • Worksheet Range

    • Named Range

    • List Range

    Correct Answer
    A. List Range
  • 18. 

    Which function allows you to generate a summary from a PivotTable and place it elsewhere in a worksheet?

    • PIVOTDATA

    • SUMPIVOTDATA

    • ANALYZEPVT

    • GETPIVOTDATA

    • ANALYZEPIVOTDATA

    Correct Answer
    A. GETPIVOTDATA
  • 19. 

    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?

    • Click once on the function or named range.

    • Highlight the function or named range and press the Tab key.

    • Highlight the function or named range and press the Enter key.

    • Highlight the function or named range and press the right arrow key.

    Correct Answer
    A. Highlight the function or named range and press the Tab key.
  • 20. 

    Which feature allows you to filter by any date entries in a PivotTable?

    • DATETIME

    • Timeline

    • Chronological Filter

    • Quantum Analysis

    • ISOWEEKNUM

    Correct Answer
    A. Timeline
  • 21. 

    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?

    • Define Name in the Defined Names group on the Formulas tab.

    • Use in Formula in the Defined Names group on the Formulas tab.

    • Name Manger in the Defined Names group on the Formulas tab.

    • Create from Selection in the Defined Names group on the Formulas tab.

    • Use Label Names in the Defined Names group on the Formulas tab.

    Correct Answer
    A. Create from Selection in the Defined Names group on the Formulas tab.
  • 22. 

    The default calculation method in Excel 2016 is to Automatically calculate the work book. What other four options are available?

    • Automatic Except for Data Tables

    • Manual

    • Calculate Now

    • Calculate on Save

    • Calculate Sheet

    Correct Answer
    A. Calculate on Save
  • 23. 

    True or False? To change the data of a chart, you must delete the chart and reinsert it using it's saved Template.

    • True

    • False

    Correct Answer
    A. True
  • 24. 

    You have sorted three columns in sequence. Which one is the primary sort.

    • First column you sorted

    • Second column you sorted

    • Third column you sorted

    • None of the columns are sorted

    • You must use the Sort command to perform this task

    Correct Answer
    A. Third column you sorted
  • 25. 

    What is an array?

    • A range of cells highlighted in Excel 2016.

    • Multiple worksheets grouped together.

    • A visual depiction of values from a range of cells.

    • The individual values saved in a range of individual cells.

    • A range of data entered into a computer's memory and accessed by Excel 2016.

    Correct Answer
    A. A range of data entered into a computer's memory and accessed by Excel 2016.

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
Back to Top Back to top
Advertisement