AnswersComputer Applications - Office 2016 - EL3520 APivot Tables and Pivot Charts

Pivot Tables and Pivot Charts — Unit test Answers

0 verified answers
1
Free Preview

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
2
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
3

Where is the option to set Conditional Formatting rules found?

A
Insert tab in the Formatting group
B
Page Layout tab in the Styles group
C
Home tab in the Styles group
D
Formulas tab in the Formatting group
4

Which function category is not in Excel 2016?

A
Financial
B
Text
C
Date and Time
D
Conditional Formatting
5

Which method is an easy way to find a short description of a function?

A
In the Insert Function dialog box, click the function name to get a short description.
B
Open Help from the Backstage view to find a list of functions.
C
Insert the function and right-click it in the cell to access a description.
D
Use the Search tool to find a list of functions and their descriptions.
6

Which statement describes how to insert the IF, COUNTIF, or SUM function into a cell?

A
Use the Insert tab and select the appropriate function from the Functions group.
B
Type an = sign in the cell, followed by the name of the function and the relevant arguments.
C
Right-click the cell to access the context menu to insert the function.
D
Use the View tab and choose the correct function from the displayed list.
7

Where are the Add Level and Delete Level buttons located?

A
Filter options list
B
Sort & Filter group
C
Sort dialog box
D
Custom filter dialog box
8

What is the quickest way to remove all filters that have been applied to a worksheet?

A
Click each filter and select Clear Filter.
B
Click the Filter button in the Sort & Filter group.
C
Select the worksheet and click Clear Filter.
D
Select the worksheet and click Delete All Filters.

Did you find these answers helpful?

More from this Course

Quiz
12 verified answers

Unit Test

Quiz
8 verified answers

Unit Test

Quiz
7 verified answers

Unit Test

Pivot Tables and Pivot Charts — Unit test…