Question 1

Which of the following is NOT an argument in the majority of database functions?

Accepted Answer

A) Dialog 
B) Field 
C) Database 
D) Criteria

Question 2

Records display in ________.

Accepted Answer

A) rows 
B) headings 
C) columns 
D) labels

Question 3

Match the following five functions to their descriptions:
i.Flash Fill
II.Text Function
III.LEFT
IV.CONCATENATE
v.TRIM

Accepted Answer

A) A text function that returns the specified number of characters from the beginning of a string of characters. 
B) A text function that can join up to 255 strings of characters. 
C) A function to combine or separate data,change case,and apply formatting to a string of characters. 
D) A text function to remove extra blank spaces from a string. 
E) A feature that predicts how to alter data based upon the pattern you enter into the cell at the beginning of the column.

Question 4

The DCOUNT function returns the number of occurrences of a specified condition in a database.

Accepted Answer

A) True 
 B)False

Question 5

Custom headers and footers can be added to worksheets.

Accepted Answer

A) True 
 B)False

Question 6

The ________ function returns the specified number of characters from the beginning of a string of characters.

Accepted Answer

A) FRONT 
B) LEFT 
C) MID 
D) RIGHT

Question 7

You can establish data links,called data ________,to external data so that you automatically update your Excel workbook from the original data whenever the original data source gets new information.

Accepted Answer

The answer of You can establish data links,called data ________,to...

Question 8

Data stored in a format of rows and columns is known as a ________.

Accepted Answer

The answer of Data stored in a format of rows...

Question 9

Information stored in rows and columns is referred to as ________.

Accepted Answer

A) a record 
B) a table 
C) a chart 
D) an array

Question 10

The ________ function will capitalize the first letter of each word.

Accepted Answer

A) TRIM 
B) LEFT 
C) MID 
D) PROPER

Question 11

Match the following five terms to their meanings:
i.DAVERAGE
II.DSUM
III.DCOUNT
IV.syntax
v.compound criteria

Accepted Answer

A) A function that counts the number of occurrences of a specified condition in a database. 
B) A function that calculates an average in a database range. 
C) An arrangement of elements in the database function arguments. 
D) The use of two or more criteria on the same row. 
E) A function that calculates a total in a database range.

Question 12

________ are arrows that display in the column titles of Excel data and that enable you to sort and filter the data when it is converted to a table.

Accepted Answer

A) Schema 
B) TRIM functions 
C) Conditional formatting controls 
D) Filtering controls

Question 13

________ refers to facts about people,events,things,or ideas.

Accepted Answer

A) Group 
B) Table 
C) Data 
D) Record

Question 14

Data refers to facts about people,events,things,or ideas.

Accepted Answer

A) True 
 B)False

Question 15

To combine or separate data,change case,and apply formatting to a string of characters,use a ________.

Accepted Answer

A) data rule 
B) schema 
C) query 
D) text function

Question 16

Microsoft ________ is a database program that manages database files.

Accepted Answer

The answer of Microsoft ________ is a database program that...

Question 17

By having two tables side-by-side in the same worksheet,you can ________ similar sets of data to make comparisons.

Accepted Answer

A) import 
B) filter 
C) sort 
D) select

Question 18

The CONCATENATE function removes extra blank spaces from a string.

Accepted Answer

A) True 
 B)False

Question 19

You CANNOT type your own text in headers and footers.

Accepted Answer

A) True 
 B)False

Question 20

________ are sets of three,four,or five small graphic images that make your data visually easier to interpret.

Accepted Answer

A) Icon sets 
B) Symbols 
C) Logos 
D) Images

Exam 10: Excell: External Data, Database Functions, and Side-By-Side Tables

Which of the following is NOT an argument in the majority of database functions?

Records display in ________.

Match the following five functions to their descriptions: i.Flash Fill II.Text Function III.LEFT IV.CONCATENATE v.TRIM

The DCOUNT function returns the number of occurrences of a specified condition in a database.

Custom headers and footers can be added to worksheets.

The ________ function returns the specified number of characters from the beginning of a string of characters.

You can establish data links,called data ________,to external data so that you automatically update your Excel workbook from the original data whenever the original data source gets new information.

Data stored in a format of rows and columns is known as a ________.

Information stored in rows and columns is referred to as ________.

The ________ function will capitalize the first letter of each word.

Match the following five terms to their meanings: i.DAVERAGE II.DSUM III.DCOUNT IV.syntax v.compound criteria

________ are arrows that display in the column titles of Excel data and that enable you to sort and filter the data when it is converted to a table.

________ refers to facts about people,events,things,or ideas.

Data refers to facts about people,events,things,or ideas.

To combine or separate data,change case,and apply formatting to a string of characters,use a ________.

Microsoft ________ is a database program that manages database files.

By having two tables side-by-side in the same worksheet,you can ________ similar sets of data to make comparisons.

The CONCATENATE function removes extra blank spaces from a string.

You CANNOT type your own text in headers and footers.

________ are sets of three,four,or five small graphic images that make your data visually easier to interpret.