Pivot Tables and Pivot Charts — Cumulative exam Answers

2 verified answers2 views
1
Free Preview

Which method deletes a footer from a document?

A
Double-click the footer region and delete all the content in the Footer.
B
Click on the Insert tab on the ribbon, click the Footer button, and select Remove Footer from the list.
C
Double-click the footer region; under the Design tab in the Header & Footer group, click on the Footer button and select Remove Footer from the list.
D
All the above are methods for deleting a footer from a document
2
Free Preview

Ryan has inserted an image into a Word document, but the image is too large. There are sections of the image that he would like to eliminate to decrease the overall size of the image.Which option should Ryan use?

A
Cut
B
Copy
C
Crop
D
Layout options
3

Zoe needs to ensure that a larger spreadsheet fits on a single page. How can she achieve this?

A
Orientation settings
B
Margin settings
C
Collation settings
D
Label settings
5

Which function is used to add a range of cells?

A
=SUM
B
=AVERAGE
C
=MAX
D
=ADD
6

Chris needs to modify the default bullets that are used in a nonnumbered list in Word.Which method should he use?

A
Select the arrow next to the bullet list option in the Paragraph group.
B
Select the arrow next to the number list option in the Paragraph group.
C
Use the Styles group on the Home tab.
D
This cannot be done.
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.
9

Which item is used in Excel to identify the row of a particular cell?

A
letter
B
number
C
type
D
sheet
10

Nadia would like to find text in her current document that differentiates CompanyABC from companyabc.Which option should she use?

A
Find whole words only
B
Match Case
C
Wildcards
D
Match Prefix
11

Which of these functions may be used with positional arguments? Select four options.AVERAGECOUNTIFCOUNTSUMMAX

A
AVERAGE
B
COUNTIF
C
COUNT
D
SUM
E
MAX
12

What are the features of the Outline view in Word? Select three options.

A
making it easier to deal with larger documents
B
manipulating headings
C
displaying text with Heading styles
D
changing data inside headings
E
inserting Table of Contents
13

How can the Column settings be accessed?

A
Layout tab, Page Setup group
B
Layout tab, Paragraph group
C
Layout tab, Arrange group
D
Design tab, Document Formatting group
14

Karen would like to apply a group of colors, fonts, effects, and styles very quickly to a document that she has created.Which of these styles should she use?

A
Normal template
B
Document theme
C
Custom styles
D
none of the above
15

Stephen needs to insert a field into a building block that will contain variable data.Which keyboard shortcut can he use to toggle between data and the field codes?

A
ALT+F8
B
ALT+F9
C
ALT+F2
D
none of the above
16

Carla needs to be able to quickly switch back and forth between open worksheets. Which option should she use?

A
Arrange All
B
Arrange Side by Side
C
Switch Windows
D
Collapse Windows
17

To which of these options does the style in Word apply? Select three options.

A
lists
B
tables
C
headings
D
images
E
shapes
18

Where are the mail merge options located in Word 2016?

A
Mailings tab, Start Mail Merge group
B
Mailings tab, Preview Results group
C
Insert tab, Mail Merge group
D
References tab, Research group
19

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.
20

What options does the Table Tools Layout contextual tab contain? Select three options.

A
modify text direction
B
change font
C
insert rows and columns
D
add border and shading
E
split table

Did you find these answers helpful?