Pivot Tables and Pivot Charts — Cumulative exam Answers

14 verified answers1 views
21
Free Preview

Which statement describes what the Conditional Formatting option in Excel 2016 allows users to do?

A
It automatically applies formatting based on specific rules or conditions being met.
B
It automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.
C
It automatically changes the font of selected cell ranges based on specific rules or conditions being met.
D
All of the options listed are correct.
22
Free Preview

Keisha has a worksheet with a range of cells using the following columns: Name, Score, Group, Study Group, and Date. Keisha needs to sort the worksheet on the Date field. Which option should she use to most efficiently complete this task?

A
Use the Cut and Paste option to reorganize the data to fit that order.
B
Use the Filter function to organize the data based on the date.
C
Use the Order function to organize the data based on the date.
D
Use the Sort function to organize the data based on date order.
24

Priya has created a document and will now create a table of contents.Which statement describes the items that will automatically be added into the table of contents?

A
Nothing will be added automatically.
B
Only items that you have manually marked as a Table of Contents entry will be added.
C
All items that have been formatted as Heading 1 or Title will be added.
D
All items that have been formatted as Headings 1, 2, or 3 and Title will be added.

Did you find these answers helpful?