Pivot Tables and Pivot Charts — Cumulative exam Answers

45 verified answers
23

Which statement explains the difference between plagiarism and copyright?

A
Plagiarism is the legal right to sell or reproduce work, while copyright involves using the works of others without permission.
B
Copyright is the legal right to sell or reproduce work, while plagiarism involves using the works of others without permission.
C
Plagiarism means to give credit when using the works of others, while copyright involves paying to use such work.
D
Copyright means to download work without permission, while plagiarism involves getting authorization for such work.
24

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

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

Which options should they choose during their evaluation process? Check all that apply.

A
a teacher’s aide who creates world population materials for a class
B
a professor who publishes world population research in a journal
C
a United Nations report that analyzes trends in the world’s population
D
a nonprofit that tracks how the world’s population affects policy decisions
E
a local news program that evaluates why some countries are overpopulated
27

Once Mia knows what her topic is, she should next focus on

A
finding her sources.
B
setting up her schedule.
C
setting research goals.
D
writing her questions.
28

Style guides advise writers on which issues? Check all that apply.

A
applying consistent standards
B
citing sources
C
formatting text
D
performing research
E
using correct definitions
30

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

Where is a bibliography or works-cited list placed within a paper or report?

A
in the introductory material
B
at the bottom of each page
C
at the end
D
in the appendix
32

Flora needs a copy of Romeo and Juliet for class. Which type of online text source should she use?

A
a blog
B
an e-book
C
an e-zine
D
an online reference
35

Original documents or objects used during Internet research are known as

A
Boolean sources.
B
primary sources.
C
secondary sources.
D
tertiary sources.
36

Which is the most relevant source for students researching the effects of climate change?

A
a government report written by a group of leading scientists
B
a study funded by private corporations refuting global warming
C
a blog that seeks to combat global warming by selling solar panels
D
a magazine that provides commentary on the environment
39

Roman is looking for specific nutritional information regarding his cereal. Which would have the most reliable information?

A
a .gov website
B
an influencer’s social media
C
an online health magazine
D
a .info website
40

Those with positive attitudes tend to ___________.a.Be dissatisfied with their jobs fasterb.Be sick more often than othersc.Be unable to solve problems creativelyd.Be comfortable around other people

A
A
B
B
C
C
D
D

Did you find these answers helpful?