Pivot Tables and Pivot Charts — Cumulative exam Answers

93 verified answers6 views
61
Free Preview

Why do MLA citations exclude a source’s web address, or URL?

A
URLs are too long.
B
URLs often change.
C
URLs are difficult to copy.
D
URLs have errors.
62
Free Preview

Which command suppresses the visibility of a particular row or column in a worksheet?

A
AutoFit
B
Hide
C
Insert
D
Replace
63

Naomi would like to reorder the worksheets in a workbook. What is the easiest method of doing this?

A
drag and drop
B
keyboard shortcut
C
Backstage view
D
Format Options
64

How should students properly use media in a presentation? Check all that apply.incorporate images that are irrelevant but interestingengage viewers by adding varietystimulate the senses of the viewerclarify relevant details in the textselect songs that decrease the presentation’s impact

A
incorporate images that are irrelevant but interesting
B
engage viewers by adding variety
C
stimulate the senses of the viewer
D
clarify relevant details in the text
E
select songs that decrease the presentation’s impact
65

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
67

audiosensoryvisualonline

A
audio
B
sensory
C
visual
D
online
68

What is the proper name for C4:D5?

A
cell
B
column
C
range
D
row
70

communicationisolationseparationevaluation

A
communication
B
isolation
C
separation
D
evaluation
71

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

When considering time management techniques, it is important to remember that ________.

A
The more techniques used, the better off you will be
B
You have to try strategies that don’t make sense for your type of work
C
Not all techniques work well for all people in all situations
D
Each strategy can work for everyone
73

When Padma creates her research schedule, it would be most helpful to

A
get all the research done in one day so she can concentrate her energy on writing the paper.
B
spread out the research work over a period of time to keep the research load manageable.
C
complete the research paper the day that it is due.
D
ask the teacher ahead of time to extend the due date.
74

The image shows various objects.

Question illustration
A
illustrating a project.
B
conducting an experiment.
C
administering a test.
D
asking research questions.
75

Which formula represents the correct arguments for the SUMIF function?

A
=SUMIF(criteria, range, criteria_range)
B
=SUMIF(criteria_range, true, false)
C
=SUMIF(range, criteria, [sum_range])
D
=SUMIF(range, sum_range, [criteria])
76

Which multimedia sources are best for a student writing a research paper on childhood obesity? Check all that apply.

A
a documentary produced by an association of pediatricians
B
a sound bite of doctors at a forum discussing the issue
C
a cartoon showing families eating dinner at a fast-food restaurant
D
a podcast in which children share their eating habits
E
a timeline made by the government showing obesity trends
77

downloaduploadprintexport

A
download
B
upload
C
print
D
export
78

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)
79

Maya is preparing a presentation about photosynthesis for her science class. She wants to use text to explain the process plants use to get energy, but she would also like to incorporate a purposeful media example.

A
a map showing the home countries of notable photosynthesis scholars
B
a video showing different types of plants in the world
C
a diagram that explains the steps involved in photosynthesis
D
a graph that tracks the changes in the Sun’s magnetic field
80

Sunil’s basketball coach asks him to prepare a presentation for his teammates on the proper way to shoot a basketball. After researching the topic online, Sunil decides to add a visual aide to his report.

A
a podcast describing how to shoot a basketball
B
a video tutorial showing how to shoot a basketball
C
a graph showing how many players shot a basketball
D
a sound bite describing a player shooting a basketball

Did you find these answers helpful?