171. On a PivotTable, what is a field with
values not entered as data but determined by a computation involving data in
other fields called?
A.
Total field
B.
AutoSum
C.
Calculated field
D.
Analyzed field
Answer: C
172. Which is a special workbook a user can
create and then use as a pattern to create new, similar workbooks or
worksheets?
A.
Form
B.
Boilerplate
C.
SmartSheet
D.
Template
Answer: D
173. What is the process of bringing data
containing text fields separated by commas into Excel called?
A.
Importing data
B.
Data collection
C.
Data integration
D.
Data migration
Answer: A
174. Which file contains data fields
separated by a special character such as a comma?
A.
Text file
B.
Delimited file
C.
Import file
D.
Data file
Answer: B
175. Which is a way to qualify data by
specifying a matching condition or asking a question of the data?
A.
Filter
B.
Sort
C.
Query
D.
Probe
Answer: C
0 comments:
Post a Comment