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

Question 1

When you click the ________ button,the filtering arrows are removed from the cells,but the color and formatting of the table style remain.

A)Convert to Range
B)Convert to Table
C)Available Windows
D)Get External Data

Answer 1

A

Question 2

In a database,________ is a vertical column that stores information that describes a record.

A)an array
B)an item
C)a field
D)a table

Answer 2

C

Question 3

The ________ function is used to join up to 255 strings of characters.

A)UPPER
B)CONCATENATE
C)MID
D)LOWER

Answer 3

B

Question 4

A ________ is an XML file that contains the rules for what can and cannot reside in an XML data file.

A)data rule
B)schema
C)query
D)data import

Question 5

Records display in ________.

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

Question 6

To make sorting and filtering easier,you can separate data into separate fields by using ________.

A)data rule
B)Flash Fill
C)query
D)Remove Duplicates

Question 7

The ________ function changes the case of the characters in a string making all characters lowercase.

A)UPPER
B)LEFT
C)MID
D)LOWER

Question 8

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

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

Question 9

The letter D at the beginning of a function identifies to Excel that a ________ range will be used in the formula.

A)table
B)column
C)row
D)database

Question 10

In Excel,you can create simple ________,which are collections of data related to a particular topic or purpose.

A)tables
B)databases
C)arrays
D)functions

Question 11

To bring data from other sources into Excel you ________ the data.

A)query
B)export
C)limit
D)import

Question 12

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

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

Question 13

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

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

Question 14

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

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

Question 15

The ________ function extracts a series of characters from a text string given the location of the beginning character.

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

Question 16

On the ribbon,on the Data tab,use commands in the ________ group to bring data from outside Excel into an Excel worksheet.

A)Connections
B)Get External Data
C)Data Tools
D)Analysis

Question 17

Functions are predefined formulas that perform calculations by using specific values,called ________.

A)inputs
B)arguments
C)numbers
D)syntax

Question 18

The ________ function removes extra blank spaces from a string of characters.

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

Question 19

The ________ function changes the case of the characters in a string,making all characters uppercase.

A)UPPER
B)LEFT
C)MID
D)LOWER

Question 20

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

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

Question 21

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

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

Question 22

________ is an arrangement of the arguments in a function.

A)criteria
B)schema
C)syntax
D)information

Question 23

When getting external data into Excel,you can establish connections to the external data so that you can automatically update your Excel workbook from the original data.

Question 24

If a worksheet is slightly wider and taller than the normal margins,use ________ to keep all the information on one page.

A)Scale to Fit
B)Page Layout
C)Orientation
D)Margins

Question 25

The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).

A)one
B)three
C)four
D)two

Question 26

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

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

Question 27

To print all the worksheets in a workbook at the same time,you can either ________ the worksheets,or under Print Settings,select Print Entire Workbook.

A)view
B)define print area
C)scale
D)group

Question 28

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

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

Question 29

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

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

Question 30

Custom headers and footers provide ________ sections where you can type your own text or insert header and footer elements.

A)two
B)three
C)one
D)four

Question 31

When you convert data to a table,a table style is applied,and the headings display ________ arrows.

A)filter
B)table
C)heading
D)column

Question 32

Data can be imported from a text file into Excel.

Question 33

To center a page horizontally,use the Margins tab in the ________ dialog box.

A)Page Setup
B)Sheet Options
C)Orientation
D)Print Area

Question 34

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

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

Question 35

The ________ function counts the cells containing numbers in the column of records that match the conditions you specify.

A)DAVERAGE
B)DCOUNT
C)DSUM
D)AVERAGE

Question 36

________ make(s)data easier to interpret by changing the data's appearance based on a condition.

A)Applying styles
B)Sorting and filtering
C)Conditional formatting
D)Side-by-side tables

Question 37

Data in an Access database is organized in a format of horizontal rows and vertical columns.

Question 38

Which of the following statements is NOT true about side-by-side tables?

A)Side-by-side tables enable you to view and compare similar sets of data.
B)In Excel,you can insert a table beside another table in the same worksheet.
C)Side-by-side tables must have the same number of rows and columns.
D)Side-by-side tables allow you to work with data separately.

Question 39

With the use of icon sets for conditional formatting,icons that make your data easier to interpret are placed ________ the cells.

A)below
B)inside
C)above
D)outside

Question 40

The shape or color of icons in an icon set indicates the ________ in the cells relative to all other adjacent cells formatted using the same condition.

A)size
B)data
C)range
D)values

Question 41

Data in a worksheet is NOT always formatted in a way you can use it.

Question 42

In an icon set,a green upward pointing arrow icon in a range of cells represents a higher value.

Question 43

Side-by-side tables can be sorted individually.

Question 44

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

Question 45

Side-by-side tables must contain the same number of rows and columns.

Question 46

Filtering controls enable you to change the background color of table cells.

Question 47

An icon set can make data visually easier to interpret.

Question 48

Data stored in a format of rows and columns is referred to a field.

Question 49

Microsoft Access is a database program that manages database files.

Question 50

In Excel,you can not only track and manage financial and numerical data,but you can also create simple databases.

Question 51

In Excel,you can insert a table beside another table in the same worksheet,and then work with the data in each table separately.

Question 52

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

Question 53

Conditional formatting makes your data easier to interpret by changing the appearance of your data based on a condition.

Question 54

To convert a table to a range,you must first select the entire table.

Question 55

To use Flash Fill to place data in a column,the data that you want to alter must be in the adjacent column.

Question 56

Imported data must be free of duplicate data or it will result in an error.

Question 57

Excel CANNOT format text data.

Question 58

Excel includes several tools to help you clean up data automatically.

Question 59

Database functions are identified by the letters DF.

Question 60

The CONCATENATE function removes extra blank spaces from a string.

Question 61

Custom headers and footers can be added to worksheets.

Question 62

You can establish connections to the external data so that you can automatically ________ your Excel workbook from the original data.

Question 63

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

Question 64

A ________ is a horizontal row in a database table that stores all of the data about one database item.

Question 65

When creating custom headers and footers,you can insert text but NOT pictures or the date.

Question 66

The ________ text function will return the specified number of characters from the beginning of a string of characters.

Question 67

The ________ function capitalizes the first letter of each word in a string.

Question 68

From Excel you can establish links,also known as data ________,to external data so that you can update your Excel workbook from the original data whenever it changes.

Question 69

The ________ Wizard assists you with steps to import a text file into Excel.

Question 70

Each vertical column stores information that describes the record and is referred to as a ________.

Question 71

Microsoft ________ is a database program that manages database files.

Question 72

Filtering arrows are removed from column headings when you use the ________ to Range command.

Question 73

The ________ text function will extract a series of characters from a string of characters given the location of the beginning character.

Question 74

You can ________ data into Excel from an Access database.

Question 75

The ________ text function will return the specified number of characters from the end of a string of characters.

Question 76

To get data that resides outside of Excel into Excel,use the commands in the ________ group.

Question 77

A(n)________ is a collection of data related to a particular topic or purpose.

Question 78

You can create custom headers and footers to provide useful information about your worksheet.

Question 79

You CANNOT type your own text in headers and footers.

Question 80

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.