Deck 4: Datasets and Tables

Question 1

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.

Answer 1

D

Question 2

Which table style option shows the field names when it is checked?

A)Header Row
B)Total Row
C)First Column
D)Banded Columns

Answer 2

A

Question 3

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

Answer 3

A

Question 4

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.

Question 5

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 6

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 7

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.

Question 8

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 9

Which of the following is not a way to bring up the Go To dialog box?

A)Alt+F7
B)F5
C)Ctrl+G
D)Name Box

Question 10

On which tab will you find options if you have to print a large dataset?

A)Page Layout
B)Print
C)Review
D)Home

Question 11

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 12

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

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

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 15

What is the default data table style?

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

Question 16

Which of the following is not a freeze option?

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

Question 17

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 18

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 19

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 20

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

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

Question 21

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 22

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 23

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

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

Question 24

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 25

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 26

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 27

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 28

What cannot be found on the Manage Rules dialog box?

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

Question 29

If you use the Icon sets conditional formatting, you are limited to how many categories?

A)One, two, or three
B)Two, three, or four
C)Three, four, or five
D)Four, five, or six

Question 30

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 31

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 32

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 33

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 34

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 35

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 36

By how many levels will Excel allow you to sort?

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

Question 37

Which of the following is not a conditional formatting option?

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

Question 38

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 39

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)

A)Unlimited
B)256
C)1,012
D)2 or 3

Question 40

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 41

The Table Styles ________ shows you all the table styles which are available.

Question 42

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

Question 43

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

Question 44

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

Question 45

Table ________ add color and borders to a table.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

Using the Print ________ can help you save paper.

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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.

Question 63

Excel will allow you to sort on ________ levels.

Question 64

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

Question 65

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

Question 66

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

Question 67

You can select multiple print areas.

Question 68

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 69

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

Question 70

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

Question 71

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 72

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

Question 73

Excel uses dashed blue lines to indicate manual page breaks.

Question 74

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

Question 75

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 76

Selecting a range automatically makes it a data table.

Question 77

Excel uses solid blue lines to indicate automatic page breaks.

Question 78

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

Question 79

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

Question 80

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