Test Bank Docx ExcelChapter 4 Datasets And Tables 1e Poatsy

Exploring Microsoft Office 2019 Introductory (Poatsy/Grauer)

Excel Chapter 4 Datasets and Tables

1) Which of the following is not a freeze option?

A) Freeze Panes

B) Freeze Top Row

C) Freeze First Column

D) Freeze Section

Diff: 1

Objective: E4.01 Freeze Rows and Columns

2) Data ________ is the organization method used to manage multiple data points within a dataset.

A) structure

B) design

C) configuration

D) planning

Diff: 2

Objective: E4.03 Explore the Benefits of Data Tables

3) When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

A) A1 becomes the active cell.

B) Column A and whatever row was active when you pressed the combination becomes the active cell.

C) Row 1 and whatever column was active when you pressed the combination becomes the active cell.

D) The first unfrozen cell becomes the active cell.

Diff: 2

Objective: E4.01 Freeze Rows and Columns

4) By default, Excel prints page in what order?

A) Top-left section, top-right section, bottom-left section, and bottom-right section

B) All the odd numbered pages, then all the even numbered pages

C) All the even numbered pages, then all the odd numbered pages

D) Top-left section, bottom-left section, top-right section, and bottom-right section

Diff: 3

Objective: E4.02 Print Large Datasets

5) What data does Excel print by default?

A) The selected range of data

B) The entire dataset on the active sheet

C) The entire workbook

D) There is no default setting for this in Excel.

Diff: 2

Objective: E4.02 Print Large Datasets

6) What is not true about tables in Excel?

A) Column headings stay on the screen automatically.

B) Filter arrows make it quick and easy to filter the data in the table.

C) Row headings stay on the screen automatically.

D) You can export the data to a SharePoint list.

Diff: 3

Objective: E4.03 Explore the Benefits of Data Tables

7) Which of the following is not a characteristic of a table?

A) Can contain multiple ranges

B) Helps to manage information

C) Helps to analyze information

D) Contains related data

Diff: 2

Objective: E4.03 Explore the Benefits of Data Tables

8) What is not true about creating a data table?

A) Make sure no column labels are the same.

B) Make sure to leave one blank row below the data labels.

C) Format the field names so that they stand out visually.

D) Keep field names short.

Diff: 3

Objective: E4.04 Design and Create Tables

9) What is the default data table style?

A) Normal

B) Medium 1

C) Medium 2

D) None

Diff: 3

Objective: E4.04 Design and Create Tables

10) What is true about adding a new field to the right side of an existing data table?

A) You must convert the table back to a range, add the field, then recreate the table.

B) You can add it to the right of the data table and Excel will extend the table to include the new field.

C) You cannot add a new field to an existing data table.

D) You must insert the new field somewhere inside the existing table, then move the columns to the order you desire.

Diff: 3

Objective: E4.04 Design and Create Tables

11) By default, what is the first table on a worksheet named?

A) Table 1

B) Table A

C) Table

D) Data tables do not have names.

Diff: 2

Objective: E4.04 Design and Create Tables

12) What is not true about creating a data table?

A) Each record should be unique somehow.

B) For efficiency, make sure your data table does not exceed 256 rows.

C) It is best to put individual data tables on separate sheets.

D) Delete any blank columns in your table.

Diff: 2

Objective: E4.04 Design and Create Tables

13) Data ________ define how information is stored, organized, and accessed.

A) structure

B) organization

C) points

D) planning

Diff: 2

Objective: E4.03 Explore the Benefits of Data Tables

14) Which table style option is useful to display aggregated data when it is checked?

A) Last Column

B) Total Row

C) Filter Button

D) Header Row

Diff: 2

Objective: E4.05 Apply a Table Style

15) In a structured reference what do you use to indicate a column heading or field name?

A) Brackets []

B) Parenthesis ()

C) Curly brackets {}

D) Quotes ""

Diff: 2

Objective: E4.06 Create Structured References in Formulas

16) How does Excel indicate that a column has been selected in a structured reference?

A) A light shading appears in that column.

B) There is nothing to indicate a column has been selected.

C) A colored border appears around that column.

D) A type of colored sticky note is attached to that column.

Diff: 2

Objective: E4.06 Create Structured References in Formulas

17) When would you not need to use a fully qualified structured reference?

A) When referring to a cell outside the table

B) When referring to a cell on a different worksheet

C) When referring to a cell on a different workbook

D) When referring to a cell within the table

Diff: 2

Objective: E4.06 Create Structured References in Formulas

18) To what does the @ symbol refer in a structured reference?

A) Current cell

B) Current table

C) Current column

D) Current row

Diff: 3

Objective: E4.06 Create Structured References in Formulas

19) What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

A) Reference AutoComplete

B) Formula AutoComplete

C) AutoComplete

D) Nothing automatically displays a list of field headings.

Diff: 2

Objective: E4.06 Create Structured References in Formulas

20) What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

A) December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959

B) January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959

C) January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015

D) December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959

Diff: 2

Objective: E4.07 Sort Data

21) By how many levels will Excel allow you to sort?

A) 16

B) 32

C) 64

D) 128

Diff: 3

Objective: E4.07 Sort Data

22) The filter "Begins With..." option is found on which type of filter?

A) Number filter

B) Date filter

C) Custom filter

D) Text filter

Diff: 2

Objective: E4.08 Filter Data

23) Which wildcard character only replaces one character with one other character?

A) Question Mark ?

B) Asterisk *

C) Number sign #

D) Tilde ~

Diff: 2

Objective: E4.08 Filter Data

24) Which one of the following filter options is not found on the number filter submenu?

A) Greater Than...

B) Between...

C) Below Average

D) Bottom 10...

Diff: 3

Objective: E4.08 Filter Data

25) Which one of the following filter options is not found on the date filter submenu?

A) First Quarter

B) Tomorrow

C) Between

D) Last Month

Diff: 2

Objective: E4.08 Filter Data

26) Which one of the following filter options is not found on the text filter submenu?

A) Begins With

B) Includes

C) Contains

D) Custom Filter

Diff: 3

Objective: E4.08 Filter Data

27) In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

A) The COUNT function

B) The SUM function

C) The number of rows to subtotal

D) The row number in which to place the subtotal

Diff: 3

Objective: E4.09 Add a Total Row to a Table

28) Where does Excel display the Total row in a table?

A) At the top of the table

B) After each subtotal in the table

C) Two rows below the last row in the table

D) Below the last row in the table

Diff: 1

Objective: E4.09 Add a Total Row to a Table

29) In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

A) The PAID record

B) The range to be included in the calculation

C) The Excel function called PAID

D) The label for the resultant Total Row

Diff: 2

Objective: E4.09 Add a Total Row to a Table

30) Which of the following is not a conditional formatting option?

A) Data bars

B) Color Scales

C) Icon Sets

D) Table format

Diff: 2

Objective: E4.10 Apply Conditional Formatting

31) Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

A) Top/Bottom Rules

B) Highlight Cells Rules

C) Between Values Rules

D) Color Scales

Diff: 1

Objective: E4.10 Apply Conditional Formatting

32) Which conditional formatting option is not found in the Quick Analysis Gallery?

A) Text Contains

B) Duplicate Values

C) Unique Values

D) Undo Format

Diff: 3

Objective: E4.10 Apply Conditional Formatting

33) In conditional formatting what happens if the cell value does not pass the logical test?

A) The cell is formatted however you have determined for the FALSE result.

B) The cell is formatted with Excel's default FALSE format.

C) The cell is not formatted.

D) A small green triangle displays in the top-left corner of the cell.

Diff: 3

Objective: E4.10 Apply Conditional Formatting

34) If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

A) Conditional formatting

B) AutoFill formatting

C) AutoComplete formatting

D) Aggregate Cell formatting

Diff: 1

Objective: E4.10 Apply Conditional Formatting

35) Using the data bars conditional formatting, how is the highest value represented?

A) By the darkest bar

B) By the tallest bar

C) By the longest bar

D) By the most number of bars

Diff: 2

Objective: E4.10 Apply Conditional Formatting

36) ________ is the process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.

A) Holding

B) Locking

C) Freezing

D) Pinning

Diff: 2

Objective: E4.01 Freeze Rows and Columns

37) What is not true about using the AND function in a custom conditional formatting rule?

A) All the tests must be of the same data type, for example: all numbers or all text.

B) All the logical tests must be true for the formatting to be applied.

C) You must have at least two tests in the formula.

D) You may have as many tests as you need in the formula.

Diff: 2

Objective: E4.11 Create a New Conditional Formatting Rule

38) What cannot be found on the Manage Rules dialog box?

A) Delete Rule

B) Copy Rule

C) New Rule

D) Edit Rule

Diff: 1

Objective: E4.11 Create a New Conditional Formatting Rule

39) You can freeze as many columns and rows at the same time as you desire.

Diff: 2

Objective: E4.01 Freeze Rows and Columns

40) Locking is the process of making sure that certain rows or columns are visible at all times.

Diff: 1

Objective: E4.01 Freeze Rows and Columns

41) Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

Diff: 2

Objective: E4.01 Freeze Rows and Columns

42) When you use the Freeze Panes option you freezing both columns and rows.

Diff: 1

Objective: E4.01 Freeze Rows and Columns

43) Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Diff: 2

Objective: E4.01 Freeze Rows and Columns

44) In Normal view or Page Layout view the data to be printed has a dark blue border.

Diff: 3

Objective: E4.02 Print Large Datasets

45) You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

Diff: 3

Objective: E4.02 Print Large Datasets

46) It is a good practice to print column and row labels on each page.

Diff: 1

Objective: E4.02 Print Large Datasets

47) The use of field headings without row references in a structured formula is called a qualified reference.

Diff: 2

Objective: E4.06 Create Structured References in Formulas

48) Excel uses dashed blue lines to indicate manual page breaks.

Diff: 2

Objective: E4.02 Print Large Datasets

49) In Page Break Preview, the area to be printed has a light blue background.

Diff: 2

Objective: E4.02 Print Large Datasets

50) To print row labels on the left side of each page you would select the row(s) that contain the labels in the rows to repeat at left box.

Diff: 3

Objective: E4.02 Print Large Datasets

51) You can select multiple print areas.

Diff: 3

Objective: E4.02 Print Large Datasets

52) In a data table calculated columns will copy down the table automatically.

Diff: 2

Objective: E4.03 Explore the Benefits of Data Tables

53) Selecting a range automatically makes it a data table.

Diff: 2

Objective: E4.04 Design and Create Tables

54) Filter arrows are always displayed in data tables.

Diff: 3

Objective: E4.04 Design and Create Tables

55) After a table has been named, that name can be used in functions instead of cell references.

Diff: 3

Objective: E4.04 Design and Create Tables

56) Records are individual pieces of information.

Diff: 1

Objective: E4.04 Design and Create Tables

57) Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

Diff: 2

Objective: E4.04 Design and Create Tables

58) "John Smith" is a good example of a field.

Diff: 2

Objective: E4.04 Design and Create Tables

59) You can add a row to a data table as long as you put in the row immediately below the table.

Diff: 1

Objective: E4.04 Design and Create Tables

60) It is impossible to create a data table from random, unorganized data.

Diff: 2

Objective: E4.04 Design and Create Tables

61) This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

Diff: 3

Objective: E4.06 Create Structured References in Formulas

62) When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

Diff: 2

Objective: E4.06 Create Structured References in Formulas

63) You can sort cells by their fill color.

Diff: 3

Objective: E4.07 Sort Data

64) To go to the first unfrozen cell you would press Ctrl+________ at the same time.

Diff: 2

Objective: E4.01 Freeze Rows and Columns

65) Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1, Page 2) on your display.

Diff: 3

Objective: E4.02 Print Large Datasets

66) The print ________ is the range of cells that will be printed.

Diff: 2

Objective: E4.02 Print Large Datasets

67) Using the Print ________ can help you save paper.

Diff: 1

Objective: E4.02 Print Large Datasets

68) ________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Diff: 2

Objective: E4.02 Print Large Datasets

69) Data ________ is the method used to organize data points in a dataset.

Diff: 3

Objective: E4.03 Explore the Benefits of Data Tables

70) A(n) ________ is a range of organized, related data.

Diff: 3

Objective: E4.03 Explore the Benefits of Data Tables

71) In a data table you can use ________ references in place of cell references inside the formulas.

Diff: 3

Objective: E4.03 Explore the Benefits of Data Tables

72) A collection of fields about one person would be considered a(n) ________.

Diff: 1

Objective: E4.04 Design and Create Tables

73) In a data table each row is considered a(n) ________.

Diff: 2

Objective: E4.04 Design and Create Tables

74) In a data table each column is considered a(n) ________.

Diff: 2

Objective: E4.04 Design and Create Tables

75) The Print ________ defines what cells will print.

Diff: 2

Objective: E4.02 Print Large Datasets

76) Table ________ add color and borders to a table.

Diff: 1

Objective: E4.05 Apply a Table Style

77) In a structured reference, when you use field headings without row references it is called a(n) ________ reference.

Diff: 3

Objective: E4.06 Create Structured References in Formulas

78) The ________ symbol is used in structured references to refer to the current row.

Diff: 3

Objective: E4.06 Create Structured References in Formulas

79) When you include table names in a structure reference it is called a(n) ________ structured reference.

Diff: 3

Objective: E4.06 Create Structured References in Formulas

80) ________ references help to clarify what type of data is being used in any calculations.

Diff: 3

Objective: E4.06 Create Structured References in Formulas

81) Use the Sort by ________ Color if you want to sort records by the color of the text.

Diff: 1

Objective: E4.07 Sort Data

82) If you wanted to sort the days of the week in their natural order, not alphabetically, you would set up a(n) ________ sort.

Diff: 3

Objective: E4.07 Sort Data

83) You can see how many records meet the conditions of the filter by looking at the ________ bar.

Diff: 3

Objective: E4.08 Filter Data

84) ________ is the process of arranging records by the value of one or more fields within a table.

Diff: 3

Objective: E4.07 Sort Data

85) When you set up various conditions with the purpose of only showing a subset of data, that process is called ________.

Diff: 1

Objective: E4.08 Filter Data

86) If you need to perform complex filters on your data you will want to use the ________ AutoFilter dialog box.

Diff: 2

Objective: E4.08 Filter Data

87) The ________ wildcard symbol is often used in filters and can represent any number of characters.

Diff: 2

Objective: E4.08 Filter Data

88) If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells, you would use the Data ________ conditional formatting option.

Diff: 3

Objective: E4.10 Apply Conditional Formatting

89) Match the following terms with their description:

I. Field

II. Record

III. Table

IV. Table style

V. Total row

A. Includes complimentary fill colors

B. Complete set of fields for one entity

C. Structured range

D. Appears below the last row in a table

E. Smallest piece of data collected

Diff: 1

Objective: Multiple Objectives

90) Match the following terms with their description:

I. Color scale

II. Icon set

III. Filtering

IV. Sorting

V. Data bars

A. Colors are based on the relative values in the cell.

B. Arranging records

C. Symbols or signs that classify data

D. Various widths represent the cell's value.

E. Using conditions to limit the visible data

Diff: 1

Objective: Multiple Objectives

91) Match the following terms with their description:

I. Print area

II. Print order

III. Page break

IV. Freezing

V. Conditional formatting

A. Where data will print on the next page

B. The range of cells that will be printed

C. Rules used to emphasize cells

D. Keeps certain rows or columns on the screen at all times

E. Sequence of printed pages

Diff: 1

Objective: Multiple Objectives

92) Match the following terms with their description:

I. Unqualified reference

II. Fully qualified structured reference

III. Structured reference

IV. SUBTOTAL function

V. Total row

A. Uses a field name as the reference in a table

B. Contains the table name

C. Field headings without row references

D. Displays below the last row in a table

E. Calculates an aggregate value

Diff: 1

Objective: Multiple Objectives

93) Match the following table style options with their description:

I. Header Row

II. Total Row

III. First Column

IV. Last Column

V. Banded Rows

A. The formatting of this row/these rows take/takes priority over column formatting.

B. Alternate fill colors distinguish one row from another row.

C. Makes sure that the row headings stand out

D. Displays the field names when checked

E. Often used for aggregated data

Diff: 3

Objective: E4.05 Apply a Table Style

94) Match the following table style options with their description:

I. Header Row

II. Total Row

III. First Column

IV. Last Column

V. Filter Button

A. Displays a total row when selected

B. Makes sure that the row headings stand out

C. Displays on the right side of each heading in the header row

D. Used to make aggregated data stand out

E. Removes field names when not checked

Diff: 2

Objective: E4.05 Apply a Table Style

95) Match the following Data Type Sort Options with their example:

I. Sort Z to A

II. Sort Oldest to Newest

III. Sort Largest to Smallest

IV. Sort A to Z

V. Sort Newest to Oldest

A. Number; Othniel; Psychology

B. 11/20/2015; 8/20/2015; 5/25/91

C. 58; 29; 27

D. 1/16/1957; 12/26/1959; 1/7/87

E. Karen; Doug; Barb

Diff: 1

Objective: E4.07 Sort Data

96) Match the following Subtotal Function with their Table Numbers:

I. AVERAGE

II. MAX

III. MIN

IV. SUM

V. COUNTA

A. 104

B. 103

C. 101

D. 109

E. 105

Diff: 3

Objective: E4.09 Add a Total Row to a Table

97) Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:

I. Text Contains

II. Duplicate Values

III. Unique Values

IV. Equal To

V. Clear Format

A. Formats cells that have exactly the same value

B. Formats any cell that has content that matches the first content in the first selected cell

C. Removes any conditional formatting

D. Formats cells that have no matching values

E. Formats cells that have the value

Diff: 1

Objective: E4.10 Apply Conditional Formatting

98) Match the following Conditional Formatting Options with their description:

I. Highlight Cells Rules

II. Top/Bottom Rules

III. Data bars

IV. Color Scales

V. Icon Sets

A. Formats cells if they fall in the lowest % (% determined by the user)

B. Formats cells with gradients of color depending on the cell's value compared to the other values in the range

C. Formats cells with colors whose width is proportional to the other values in the range

D. Formats cells if a date falls in a certain range

E. Uses symbols to represent the comparison of values

Diff: 1

Objective: E4.10 Apply Conditional Formatting