Deck 7: Organizing Data for Effective Analysis

Question 1

HTML documents are user-defined documents in which the user develops a DTD that defines the elements contained in a document.

Answer 1

False

Question 2

The easiest way to create a PivotChart report is to use an existing PivotTable report as the source data.

Answer 2

True

Question 3

Any data you enter in the row below an XML table will be added to the table.

Answer 3

True

Question 4

The CONCATENATE function combines the values in a range of cells into one numeric item in a new cell.

Question 5

Excel includes several external data sources saved as database files that you can use to import data into Excel.

Question 6

XML is a free, nonproprietary format.

Question 7

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

Question 8

In a computer application, the term "string" refers to a meaningful sequence of characters.

Question 9

Dividing text into columns is also referred to as parsing text into columns.

Question 10

Creating an Excel worksheet often bridges the gap between tables and simple databases.

Question 11

The syntax for the YEARFRAC function is as follows: =YEARFRAC(start_date,end_date,[basis]).

Question 12

The TRIM function removes all spaces in a text string except for the single spaces between words.

Question 13

Hypertext Markup Language is the markup language that creates Web pages.

Question 14

Placing a field in the Row Labels area of a PivotTable displays data from that field in columns and rows.

Question 15

To remove a filter from a column and display all of the data in the Excel table again, click the column's filter arrow, and then click Clear Filter From.

Question 16

The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.

Question 17

A database is created by and defined in a database management warehouse (DBW), which is a software program that creates and accesses the data in a database.

Question 18

Excel uses an XML map to relate the data to the elements when importing and exporting XML data.

Question 19

When you create formulas referencing cells that contain dates and/or times, Excel will never format the result as a date instead of as a number.

Question 20

The SEARCH function is case sensitive.

Question 21

The term "well-formed" is commonly used in the XML community to describe an XML document that is properly structured and meets established rules and guidelines. _________________________

Question 22

A ____ identifies the end of each field in a comma-delimited file.

A) paragraph mark
B) pound sign
C) comma
D) question mark

Question 23

A database stored in one table is sometimes called a(n) flat-file database. _________________________

Question 24

The START function returns the starting position of one text value within another text value. _________________________

Question 25

A(n) list is a set of related data that is stored in tables. _________________________

Question 26

Excel table data is organized in rows and columns, where each column defines a record. _________________________

Question 27

The TODAY function returns the current date's serial number (based on the computer's internal clock). _________________________

Question 28

When you create an Excel table, drop-down list arrows appear in the header row for each column when the ArrowFilter feature is enabled. _________________________

Question 29

A(n) marked language uses a set of tags to distinguish different elements in a document and uses attributes to define those elements further. _________________________

Question 30

The LAST function returns the last character or characters in a text string, based on the number of characters specified. _________________________

Question 31

A PivotChart report represents source data as a(n) graphic. _________________________

Question 32

The data format that separates the values in each record with commas is often called ____.

A) comma-separated values (CSV)
B) comma-separated data (CSD)
C) comma data (CD)
D) comma-separated records (CSR)

Question 33

The AutoFilter option called Text Filters removes any existing filters, displays all data in the column, and restores the default (Select All) option. _________________________

Question 34

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

A) comma-delimited
B) comma-limited
C) comma-delineated
D) comma-lineated

Question 35

In Excel, you can use a text function to link together or transpose the information from multiple cells into one cell. _________________________

Question 36

The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.

A) format
B) size of the file
C) color coding
D) reports

Question 37

Many DBMSs are called absolute database management systems because the data is stored in tables that are related to each other through a common field. _________________________

Question 38

A(n) PivotSheet report is an interactive report that lets you summarize and analyze a data set. _________________________

Question 39

You can enter data into a worksheet by ____.

A) typing data into cells
B) importing data into a worksheet
C) linking data to another document
D) all of the above

Question 40

The FIXED function rounds a number to a specified number of decimals and returns the number as text with commas and a period. _________________________

Question 41

The syntax for the CONCATENATE function is as follows: ____.

A) =CON(text1,text2,...)
B) =CONCATENATE(text1,text2,...)
C) CONCATE(text1,text2,...)
D) LINK(text1,text2,...)

Question 42

In the FIND function ____ is the character position in which to start the search.

A) start_num
B) num_start
C) char_pos
D) pos_char

Question 43

In the ____ function, text is the text string or cell reference that contains the space(s) that you want to remove.

A) TRIM
B) SPACE
C) REMOVE
D) NOSPACE

Question 44

In the FIND function, ____ is the text containing the text that you want to find.

A) text_within
B) within_text
C) contain_text
D) text_contain

Question 45

The syntax for the RIGHT function is as follows: ____.

A) =RIGHT(text,[num_chars])
B) =RIGHT(num_chars,[text])
C) =RIGHT(range,[num_chars])
D) =RIGHT(num_chars,[range])

Question 46

In the FIND function, ____ is the text that you want to find.

A) find_text
B) find_words
C) text_find
D) words_find

Question 47

The syntax for the TRIM function is as follows: =TRIM(____).

A) num
B) text
C) cell
D) range

Question 48

The TRIM function removes all spaces in a text string except for the single spaces ____.

A) between numbers
B) between words
C) between cells
D) between worksheets

Question 49

The LEFT function extracts characters from the ____ of a text string.

A) left side
B) specified area
C) end
D) none of the above

Question 50

The CONCATENATE function combines the values in a range of cells into ____ in a new cell.

A) one text item
B) one numeric item
C) multiple text items
D) multiple numeric items

Question 51

The SEARCH function is not case sensitive, so searching for ____ returns the same result as searching for D.

A) D
B) d
C) either a or b
D) neither a nor b

Question 52

The FIND function is case sensitive, so searching for ____ returns a different result than searching for D.

A) d
B) D
C) either a or b
D) neither a nor b

Question 53

In the RIGHT function, the argument called ____ specifies the number of characters that you want the RIGHT function to extract.

A) text
B) num_chars
C) table
D) word

Question 54

The FIND function returns the ____ one text value within another text value.

A) starting position of
B) ending position of
C) middle position of
D) comma between

Question 55

When data is in a comma-delimited form, there is a single ____ of data with commas separating the data.

A) cell
B) row
C) column
D) worksheet

Question 56

The DOLLAR function converts a number to ____ in currency format with a dollar sign and the specified number of decimal places.

A) a formula
B) text
C) a graphic
D) none of the above

Question 57

The ____ function returns the last character or characters in a text string, based on the number of characters specified.

A) LEFT
B) CHARACTER
C) RIGHT
D) NUMBER

Question 58

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

A) text
B) table
C) word
D) chars

Question 59

You can use a text function to ____, or concatenate, the information from multiple cells into one cell.

A) look up
B) link together
C) transform
D) calculate

Question 60

In the FIND function, if you omit start_num, Excel assumes a start number of ____.

A) 0
B) 1
C) whatever is in the first cell of the range
D) none of the above

Question 61

You can add a row at the top of a worksheet (called a ____ row) and type labels that identify the data contained in each column.

A) title
B) neon
C) header
D) footer

Question 62

When working with an Excel table, you should insert ____ around the list to segregate it from any other data in the worksheet.

A) empty columns
B) empty rows
C) both a and b
D) neither a nor b

Question 63

An Excel table is a range of ____ that you formalize as a single unit of data.

A) labels
B) cells
C) worksheets
D) functions

Question 64

The ____ Wizard separates the values in a text string into columns or fields.

A) Convert Text to Columns
B) Convert Text
C) Separate Values
D) Convert Values

Question 65

When you click a filter arrow in the header row, you can ____.

A) sort the records in ascending or descending order
B) display the top 10 records
C) display records containing a specific value that appears in the column
D) all of the above

Question 66

The ____ function converts a text string that represents a number (a number, date, or time) to a number.

A) VALUE
B) NUMBER
C) CONVERT
D) NEW

Question 67

The SEARCH function finds one text string ____ another text string (not case sensitive).

A) alphabetically in front of
B) alphabetically after
C) in the row next to
D) within

Question 68

The Subtotal command creates summary reports that let you ____ the level of detail in a report.

A) collapse
B) expand
C) both a and b
D) neither a nor b

Question 69

Excel must load the entire workbook into memory when you open it, which can lead to performance problems ____.

A) with very small lists
B) when adding column headings
C) with very large tables
D) when using functions

Question 70

Clicking within an Excel table opens the ____ tab on the ribbon.

A) TABLE TOOLS DESIGN
B) TOOLS DESIGN
C) TABLE DESIGN
D) WORKSHEET DESIGN

Question 71

The REPLACE function replaces part of a text string with a new text string based on the number of characters specified in ____.

A) num_chars
B) range
C) text
D) start_num

Question 72

The FIXED function rounds a number to a specified number of decimals and returns the number as text with ____.

A) commas
B) a period
C) both a and b
D) neither a nor b

Question 73

To remove a filter from a column and display all of the data in the Excel table again, click the column's drop-down list arrow, and then click ____.

A) Clear Filter From
B) Clear Filter Now
C) Clear Filter Range
D) Delete Filter

Question 74

If you want to sort by more than one column, you can use the Sort dialog box to sort by up to ____ columns.

A) 12
B) 24
C) 64
D) 128

Question 75

The ____ function converts lowercase letters in a text string to uppercase.

A) UPPER
B) LOWER
C) TEXT
D) INCREASE

Question 76

The Subtotal command works with ____ calculation(s) at a time.

A) one category and one subtotal
B) multiple categories and one subtotal
C) one category and multiple subtotal
D) multiple categories and multiple subtotal

Question 77

The maximum number of rows and columns in a worksheet limits the number of records and fields you can have in your list to ____ rows and 16,384 columns.

A) 16,384
B) 65,535
C) 148,576
D) 1,048,576

Question 78

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

A) slash
B) tab character
C) paragraph mark
D) quotation mark

Question 79

The ____ function converts uppercase letters in a text string to lowercase.

A) HIGHER
B) LOWER
C) UPPER
D) STRING

Question 80

When data is formatted as an Excel table, you can insert a new row into the table by selecting the last cell in the last row of the existing data and pressing the ____ key to create a new row.

A) +
B) Tab
C) Ctrl
D) F2