Pivot Tables and Pivot Charts — Cumulative exam Answers

15 verified answers2 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.
26

Which step ensures that the page margins are not too narrow?

A
Always preview your document or print a test page first to ensure the margins are not too narrow.
B
Zoom out of your document to ascertain how close to the edges of the document your text is.
C
You do not have to ensure that margins are correct; Word will warn you if they are not.
D
In the Page Setup dialog box, ensure that margins are not set to less than 1" for top, bottom, left, and right areas.
27

Which formula represents the correct arguments for the SUMIF function?

A
=SUMIF(criteria, range, criteria_range)
B
=SUMIF(criteria_range, true, false)
C
=SUMIF(range, criteria, [sum_range])
D
=SUMIF(range, sum_range, [criteria])
29

Naomi would like to reorder the worksheets in a workbook. What is the easiest method of doing this?

A
drag and drop
B
keyboard shortcut
C
Backstage view
D
Format Options
30

Which command suppresses the visibility of a particular row or column in a worksheet?

A
AutoFit
B
Hide
C
Insert
D
Replace

Did you find these answers helpful?