Pivot Tables and Pivot Charts — Cumulative exam Answers

56 verified answers2 views
41
Free Preview

Recruiting new employees via the Internet allows companies to _________.

A
Reach candidates from across the world
B
Conduct recruiting sessions from the office
C
Gather résumés and cover letters paperlessly
D
All of the above
42
Free Preview

Boolean-basedcrawler-basedalgorithm-basedgovernment-based

A
Boolean-based
B
crawler-based
C
algorithm-based
D
government-based
43

Fiona is starting to utilize the protection capabilities of Excel 2016. For the Lock or Unlock Cells function to work, which option should be enabled?

A
The Protect Workbook function needs to be enabled.
B
No functions need to be enabled other than the lock or unlock cells options.
C
The worksheet must be saved before the cells will become locked or unlocked.
D
The Protect Worksheet function needs to be enabled.
44

A positive shift in attitude occurs as a result of ___________.

A
Painful loss
B
Wishful thinking
C
Good luck
D
Hard work
45

Which formatting option(s) can be set for Conditional Formatting rules?

A
light red fill with dark red text, yellow fill with dark yellow text, and green fill with dark green text
B
light red fill with dark red text
C
light red fill, light yellow fill, and light green fill
D
Any of these formatting options as well as number, border, shading, and font formatting can be set.
46

Which margin is at the very bottom of the page when printing worksheets?

A
top margin
B
bottom margin
C
header margin
D
footer margin
47

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

What advantage is there to treating each implementation of a solution as a learning experience?

Answer:

It provides feedback about what worked and what did not, so you can adjust the solution, address unintended problems, and make better decisions in the future.

51

Lorraina is editing a novel. Which style guide is the publisher most likely going to ask her to use?

A
American Psychological Association (APA)
B
Associated Press (AP)
C
Chicago Manual of Style (CMoS)
D
Modern Language Association (MLA)
52

To answer the research question "How am I going to find the information I need on the topic?” the best thing Georgia should do first is

A
get on her computer to search the topic.
B
make a list of the books she could use.
C
ask her teacher for specific suggestions.
D
make a list of relevant sources to check out.
54

Where is the option to insert a PivotTable in Excel 2016 located?

A
Insert tab in the Tables group
B
Formulas tab in the Data Analysis group
C
Data tab in the PivotTables group
D
Data tab in the Tables group
55

Where are the Add Level and Delete Level buttons located?

A
Filter options list
B
Sort & Filter group
C
Sort dialog box
D
Custom filter dialog box

Did you find these answers helpful?