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

Pivot Tables and Pivot Charts — Cumulative exam Answers

14 verified answers1 views
1
Free Preview

Leena needs to manually update the TOC and would prefer not to change the styles in the document.What should she do?

A
using the Add Text option in the Table of Contents group
B
using References tab, Table of Contents group, Update Table
C
using References tab, Captions Group, Insert Caption
D
none of the above
2
Free Preview

What is the proper name for C4:D5?

A
cell
B
column
C
range
D
row
3

Raj needs to apply sorting to a current list in his Word document.Where should he go to apply the sort?

A
Home tab Styles group
B
Home tab Paragraph group
C
Home tab Editing group
D
Design tab Sorting group
4

How can templates be made available to other users?

A
your user profile directory
B
a shared network location
C
an intranet SharePoint document library
D
none of the above
5

After a chart has been inserted and formatted, is it possible to change the data range it refers to or to add new rows of data?

A
No, additional data cannot be included in a chart once it has been created; the user should delete the chart and create a new chart.
B
Yes, click the Select Data button in the Data group under the Design tab to extend or reduce the data range.
C
Yes, click the chart, select the additional rows or columns of data to add, and press Enter on the keyboard.
D
Yes, double-click the chart and select Properties from the list; in the Properties box, insert the new data range to include in the chart.
6

Which command is not one of the available Change Case options?

A
lowercase
B
small caps
C
sentence case
D
capitalize each word
7

Which statement is true regarding the Quick Access toolbar?

A
It can be located at the top left-hand corner of the screen or below the ribbon.
B
It can contain functions that are also in the ribbon.
C
It can be modified to contain any function that you use frequently.
D
All the above statements are true.
8

Which step is first in changing the proofing language of an entire document?

A
Click the Language button on the Status bar.
B
Select the whole document by pressing Ctrl+A.
C
Under the Review tab on the ribbon in the Language group, click the Language button and select Set Proofing Language.
D
Run a Spelling and Grammar check on your document before changing the language.
9

Kari needs to change the brightness and contrast on an image she has inserted into a Word document. Which group should she use to do this?

A
Adjust
B
Picture Styles
C
Arrange
D
Size
10

Which statement best describes the purpose of the Insert Function dialog box?

A
It is used to search for specific functions using keywords and descriptions.
B
It is used to insert a specific function by selecting it from the Insert Function list.
C
It is used to display information related to the arguments that are used in a function.
D
It is used to put all types of Excel functions in alphabetical order.
11

Which phrase is the best definition of a PivotTable?

A
a table containing data that is organized horizontally
B
a table used to calculate financial pivot values
C
a tool used to summarize data
D
a table containing specific formatting
12

Which option can be used to access more settings than are available in the Backstage view?

A
Page Setup dialog box
B
Orientation settings
C
View tab
D
Insert tab
13

Seneca has just applied conditional formatting and realizes that she has made a mistake. Which action should she take to fix the mistake?

A
Clear the rule she created by going to the Conditional Formatting Rules Manager dialog box and deleting the rule.
B
Clear all rules that have been applied to the worksheet or selected range by clicking the Clear Rules button.
C
Use the Undo button or Ctrl+Z.
D
Right-click the area where the conditional formatting rule has been applied, and select Clear Rule from the menu list.
14

Jesse would like to modify the table that he has inserted into a Word document by making the first row a single header cell.Which action should Jesse do?

A
Merge
B
Split
C
Resize
D
none of the above
15

What will happen when a text in a paragraph in Word is double-clicked?

A
The font of the word becomes larger.
B
The line the word is positioned in will be selected.
C
The character that is double-clicked will be selected.
D
The word that is double-clicked will be selected.
16

Beth needs to multiply the values of two cells in her worksheet. What should she enter into the formula bar?

A
=CD/D4
B
=CD+D4
C
=CD*D4
D
=(CD)(D4)
17

Which statement is NOT a rule for the data source for the mail merge?

A
The top line must contain the names of the fields being using in the merge.
B
Each field name in the data source must be unique.
C
Field names can be any size.
D
Field names should start with a letter.
18

What are the benefits of building blocks?

A
They allow you to create custom content that can be easily inserted into Word documents.
B
They allow you to create temporary content for one Word document only.
C
They allow you to create content that can be used to build a whole Word document.
D
They allow you to create content that cannot be edited by mistake and inserted into Word documents.
19

What option in the alignment settings for a cell should be used to put text in a diagonal fashion?

A
Formatting
B
Align Right
C
Align Left
D
Orientation
20

David has created a lot of styles and now his Quick Style Gallery contains styles he no longer uses.How can he remove the unwanted styles?

A
Go into the Style Set and delete the styles he doesn’t use.
B
Delete the styles in the document by using the Clear Formatting button.
C
Right-click the style in the Quick Styles Gallery, and select the Remove from Quick Style Gallery option.
D
Select the style in the Quick Styles Gallery and press the Delete button on your keyboard.

Did you find these answers helpful?

More from this Course

Quiz
45 verified answers

Cumulative Exam

RC
25 verified answers

Cumulative Exam

Assignment
5 verified answers

Pivot Tables and Pivot Charts