Deck 8: Excel : Datasets and Tables

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

A

Question 3

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.

Answer 3

C

Question 4

Which of the following is not a freeze option?

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

Question 5

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 6

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

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 9

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 10

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

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

Question 11

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 12

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 13

Which of the following is not a conditional formatting option?

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

Question 14

What is the default data table style?

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

Question 15

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 16

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 17

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 18

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 19

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 20

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 21

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 22

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 23

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 24

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 25

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 26

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 27

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 28

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 29

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 30

What cannot be found on the Manage Rules dialog box?

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

Question 31

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 32

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

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 35

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 36

By how many levels will Excel allow you to sort?

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

Question 37

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

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

Question 38

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

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 41

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

Question 42

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

Question 43

Using the Print ________ can help you save paper.

Question 44

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

Question 45

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

Question 46

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

Question 47

Excel will allow you to sort on ________ levels.

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

Filter arrows are always displayed in data tables.

Question 62

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

Question 63

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

Question 64

Table ________ add color and borders to a table.

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

Selecting a range automatically makes it a data table.

Question 72

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

Question 73

Excel uses dashed blue lines to indicate manual page breaks.

Question 74

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

Question 75

Excel uses solid blue lines to indicate automatic page breaks.

Question 76

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

Question 77

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

Question 78

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

Question 79

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 80

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