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.making it easier to deal with larger documentsmanipulating headingsdisplaying text with Heading styleschanging data inside headingsinserting Table of Contents

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

Did you find these answers helpful?