AnswersComputer Applications - Office 2016 - EL3520 APivot Tables and Pivot Charts

Pivot Tables and Pivot Charts — Cumulative exam Answers

45 verified answers
1
Free Preview

What is the proper name for C4:D5?

A
cell
B
column
C
range
D
row
2
Free Preview

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
3

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])
4

An Access table contains rows of table data that contain a complete set of data for a single entity. Which term is used for a row of table data?

A
field
B
record
C
column
D
value
5

Josiah is training users to navigate Access forms. What is the best way to advance in the form to the next field?

A
Enter
B
Shift+Tab
C
Ctrl+Home
D
End
6

Which term refers to the use of expressions to check consistency in relation to other fields in the same record?

A
data validation
B
record validation
C
input mask
D
validation text
7

The link between two tables in a database based on primary and foreign keys is referred to as a ________________.

A
reference
B
relationship
C
join
D
link
8

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

Bill has to write a report for this manager. He must do some background research, write the report, and present it to a group of 30 employees. Which factor will likely influence his list of priorities?a.Logicb.Importancec.Achievabilityd.Time

A
A
B
B
C
C
D
D
10

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
11

A good filing system shares all of the common characteristics of a _________.a.Highway -- files often travel to different destinationsb.Database -- it must store information for easy access and retrievalc.Business -- each folder must have a unique structure to serve different clientsd.Library -- all files, whether they are used or not, must be in one location

A
A
B
B
C
C
D
D
12

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

Which elements of an MLA citation appear in italics? Check all that apply.article titlesbook titlesmagazine titlesnewspaper titlespublishers’ nameswebsite names

A
article titles
B
book titles
C
magazine titles
D
newspaper titles
E
publishers’ names
F
website names
14

What is the only way to remove a password encryption on an Excel file?

A
Resave the workbook as a new document or make a copy of it.
B
Open the workbook as Read Only and resave it without a password.
C
Open the workbook in Protected View and resave it without a password.
D
Enter the password to open the workbook, and delete the password created in the Encrypt with Password box.
15

Fair use allows individuals to break copyright so long as they ________.a.Think that they are being fair in their useb.Can prove they are not infringing on copyrightc.Share copyrighted material with everyoned.Ask for permission, even if they get no response

A
A
B
B
C
C
D
D
16

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
17

The first thing you must consider in any type of communication is ______.a.The type of communicationb.The style of communicationc.The purpose of the communicationd.The timing of the communication

A
A
B
B
C
C
D
D
18

Style guides advise writers on which issues? Check all that apply.applying consistent standardsciting sourcesformatting textperforming researchusing correct definitions

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

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

Which option can be used to access more settings than are available in the Backstage view?

A
Page Setup dialog box
B
Orientation settings
C
View tab
D
Insert tab

Did you find these answers helpful?

More from this Course

Quiz
14 verified answers

Cumulative Exam

RC
25 verified answers

Cumulative Exam

Assignment
5 verified answers

Pivot Tables and Pivot Charts