Pivot Tables and Pivot Charts — Cumulative exam Answers

93 verified answers6 views
81
Free Preview

The excerpt is a sample works-cited list.Based on MLA standards, how could this list be improved?

Question illustration
A
alphabetize according to title
B
change it to a bibliography
C
order it according to in-text citations
D
use hanging indents in the second line
82
Free Preview

Keisha has a worksheet with a range of cells using the following columns: Name, Score, Group, Study Group, and Date. Keisha needs to sort the worksheet on the Date field. Which option should she use to most efficiently complete this task?

A
Use the Cut and Paste option to reorganize the data to fit that order.
B
Use the Filter function to organize the data based on the date.
C
Use the Order function to organize the data based on the date.
D
Use the Sort function to organize the data based on date order.
83

The leaders of a community are concerned that people’s health might be at risk from mosquito-borne illnesses. The mayor asks Denise, the city’s health director, to prepare a presentation for a community forum.

A
a state health department video about mosquito-borne illness produced by the state’s health department
B
a local news segment in which a television anchor explains mosquito-borne illnesses
C
a commercial produced by a company that has developed a special mosquito spray
D
a podcast in which the mayor explains why mosquito-borne illnesses are a problem
84

Jonas is creating a presentation for students about volunteering. He wants to begin by speaking about the various opportunities available, but he also wants to use multimedia to engage the students.

A
a chart listing the volunteering opportunities and their benefits
B
a video in which students talk about volunteer experiences
C
a speech from the principal about volunteering
D
a timeline showing the history of volunteering
86

Online multimedia is best designed to appeal to the viewer’s sense of

A
hearing and touch.
B
hearing and taste.
C
sight and touch.
D
sight and hearing.
87

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

questionsinformationunawarenesschanges

A
questions
B
information
C
unawareness
D
changes
90

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
93

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

Which describes the first step a crawler-based search engine uses to find information?

A
Stored web addresses related to search terms are found and displayed.
B
Pages are ranked by a mathematical formula called an algorithm.
C
Text and keywords are selected and recorded in huge data centers.
D
Robots called “spiders” read a web page and follow links to other pages.
96

Which website citation is correctly formatted according to MLA standards?

A
MyPlate. United States Department of Agriculture, n.p. Web.
B
MyPlate. United States Department of Agriculture, 7 June 2013. Web. 30 May 2012.
C
United States Department of Agriculture. MyPlate. United States Department of Agriculture, 30 May 2012. Web. 7 June 2013.
D
MyPlate. United States Department of Agriculture, 30 May 2012. Web. 7 June 2013.
97

Why do writers use in-text citations?

A
to reference all works used in research
B
to direct readers to an information source
C
to organize their reference materials
D
to receive credit for their own ideas
98

Amit is researching the science behind a new diet. He typed the name of the diet and the word science into a search engine.

A
infomercial featuring the nutritionist who invented the diet.
B
journal article about the diet written by a government nutritionist.
C
chat room discussion about the pros and cons of the diet.
D
website with links to diets that have come and gone over the years.
99

What questions should be asked when evaluating a source? Check all that apply.Is there a lot of unnecessary information?How many pages is the source?How appropriate is the information? Is the source sufficient?Is the source reliable and accurate?

A
Is there a lot of unnecessary information?
B
How many pages is the source?
C
How appropriate is the information?
D
Is the source sufficient?
E
Is the source reliable and accurate?
100

Which statement describes what the Conditional Formatting option in Excel 2016 allows users to do?

A
It automatically applies formatting based on specific rules or conditions being met.
B
It automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.
C
It automatically changes the font of selected cell ranges based on specific rules or conditions being met.
D
All of the options listed are correct.

Did you find these answers helpful?