Pivot Tables and Pivot Charts — Cumulative exam

Question 1

Comprehension and speed are the two most important traits in reading for business.

Revolt · Accepted Answer

T

Question 2

In negative self talk, polarizing is when a person _______.a.Focuses only on their problems, ignoring their successesb.Blames themselves for every problem, whether it was their fault or notc.Believes that every situation will end badlyd.See themselves as a failure for not living up to impossible standards

Revolt · Accepted Answer

D

Question 3

Which function is used to add a range of cells?

Revolt · Accepted Answer

=SUM

Question 4

Which of the following is NOT considered a form of communication?a.E-mailb.Sign languagec.Smiling at someoned.Talking to yourself

Revolt · Accepted Answer

D

Question 5

A positive or negative outcome of a decision or action can be called a _____.a.Boonb.Consequencec.Tragedyd.Advantage

Revolt · Accepted Answer

B

Question 6

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

Revolt · Accepted Answer

number

Question 7

Which function can NOT be performed using the Conditional Formatting option?

Revolt · Accepted Answer

Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.

Question 8

Where is the SUBTOTAL function located?

Revolt · Accepted Answer

under the Data tab on the ribbon in the Outlining group

Question 9

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?

Revolt · Accepted Answer

Insert > Entire Row

Question 10

E-mails that are mailed directly to a consumer without their knowledge or permission are called ________.a.Virusesb.Spamc.Social maild.Flash mail

Revolt · Accepted Answer

B

Pivot Tables and Pivot Charts — Cumulative exam Answers

More from this Course

TRY EDGENUITY HACKS