Pivot Tables and Pivot Charts — Cumulative exam Answers

2 verified answers2 views
21
Free Preview

Seneca needs to combine multiple cells into a single column heading. Which option should she use?

A
Wrap Text
B
Align Center
C
Merge and Center
D
Align Right
22
Free Preview

Where is the option to insert a PivotTable in Excel 2016 located?

A
Insert tab in the Tables group
B
Formulas tab in the Data Analysis group
C
Data tab in the PivotTables group
D
Data tab in the Tables group
23

Which formatting group would commonly be used for monetary figures?

A
number
B
general
C
accounting
D
currency
24

Which margin is at the very bottom of the page when printing worksheets?

A
top margin
B
bottom margin
C
header margin
D
footer margin
25

Jin needs to add a row into his spreadsheet, but he does not want to remove any existing data. Which combination of options should he use?

A
Delete > Shift Cells Left
B
Insert > Entire Row
C
Insert > Shift Cells Down
D
Delete > Entire Row
26

Which formatting option(s) can be set for Conditional Formatting rules?

A
light red fill with dark red text, yellow fill with dark yellow text, and green fill with dark green text
B
light red fill with dark red text
C
light red fill, light yellow fill, and light green fill
D
Any of these formatting options as well as number, border, shading, and font formatting can be set.
27

Where is the SUBTOTAL function located?

A
under the Formula tab on the ribbon in the Function Library group
B
under the Home tab on the ribbon in the QuickSum group
C
under the Insert tab on the ribbon in the Outlining group
D
under the Data tab on the ribbon in the Outlining group
28

Which ribbon tab is home to the Function library used to insert functions into worksheets?

A
Home
B
Insert
C
Formulas
D
Data
29

Where are options to add a border around the outside of a chart found?

A
Design tab in the Chart Layout gallery
B
Format tab in the Shape Styles group
C
Layout tab in the Background group
D
Insert tab in the Format gallery
30

When running a spelling and grammar check, which of these options in the "Not in Dictionary"/Suggestion area does Nora need to select when she wants to fix an error?

A
Add to dictionary
B
Ignore Once
C
Ignore All
D
one of the suggested words

Did you find these answers helpful?