Deck 9: Excell: Datasets and Tables

Question 1

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.

Answer 1

B

Question 2

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.

Answer 2

B

Question 3

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

Answer 3

A

Question 4

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.

Question 5

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

Question 6

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.

Question 7

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 ""

Question 8

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

A) Current cell
B) Current table
C) Current column
D) Current row

Question 9

What is the default data table style?

A) Normal
B) Medium 1
C) Medium 2
D) None

Question 10

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

A) structure
B) design
C) configuration
D) planning

Question 11

Which of the following is not a freeze option?

A) Freeze Panes
B) Freeze Top Row
C) Freeze First Column
D) Freeze Section

Question 12

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

A) structure
B) organization
C) points
D) planning

Question 13

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

Question 14

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

Question 15

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.

Question 16

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.

Question 17

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.

Question 18

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.

Question 19

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

Question 20

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.

Question 21

By how many levels will Excel allow you to sort?

A) 16
B) 32
C) 64
D) 128

Question 22

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.

Question 23

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

A) Number filter
B) Date filter
C) Custom filter
D) Text filter

Question 24

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

Question 25

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.

Question 26

________ 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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

A) Text Contains
B) Duplicate Values
C) Unique Values
D) Undo Format

Question 31

What cannot be found on the Manage Rules dialog box?

A) Delete Rule
B) Copy Rule
C) New Rule
D) Edit Rule

Question 32

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

A) Question Mark ?
B) Asterisk *
C) Number sign #
D) Tilde ~

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

Which of the following is not a conditional formatting option?

A) Data bars
B) Color Scales
C) Icon Sets
D) Table format

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

Records are individual pieces of information.

Question 46

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

Question 47

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.

Question 48

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.

Question 49

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

Question 50

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

Question 51

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

Question 52

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.

Question 53

You can select multiple print areas.

Question 54

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

Question 55

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

Question 56

Selecting a range automatically makes it a data table.

Question 57

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

Question 58

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

Question 59

Excel uses dashed blue lines to indicate manual page breaks.

Question 60

Filter arrows are always displayed in data tables.

Question 61

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

Question 62

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

Question 63

You can sort cells by their fill color.

Question 64

Table ________ add color and borders to a table.

Question 65

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

Question 66

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

Question 67

The Print ________ defines what cells will print.

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

Using the Print ________ can help you save paper.

Question 79

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

Question 80

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