Excel Chapter 4

What is true about adding a new field to the right side of an existing data table? A) You must insert the new field somewhere inside the existing table, then move the columns to the order you desire. B) You cannot add a new field to an existing data table. C) You can add it to the right of the data table and Excel will extend the table to include the new field. D) You must convert the table back to a range, add the field, then recreate the table.

Which one of the following filter options is not found on the text filter submenu? A) Custom Filter B) Includes C) Contains D) Begins With

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) A small green triangle displays in the top-left corner of the cell. D) The cell is not formatted.

How does Excel indicate that a column has been selected in a structured reference? A) A type of colored sticky note is attached to that column. B) There is nothing to indicate a column has been selected. C) A light shading appears in that column. D) A colored border appears around that column.

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?) A) Unlimited B) 2 or 3 C) 1,012 D) 256

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference? A) Formula AutoComplete B) Reference AutoComplete C) AutoComplete D) Nothing automatically displays a list of field headings.

What is the default data table style? A) Medium 1 B) Medium 2 C) Normal D) None

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent? A) The number of rows to subtotal B) The row number in which to place the subtotal C) The COUNT function D) The SUM function

What data does Excel print by default? A) The entire dataset on the active sheet B) The entire workbook C) The selected range of data D) There is no default setting for this in Excel.

By default, what is the first table on a worksheet named? A) Table B) Table A C) Table 1 D) Data tables do not have names.

Which of the following is not a conditional formatting option? A) Data bars B) Table format C) Color Scales D) Icon Sets

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent? A) The range to be included in the calculation B) The PAID record C) The label for the resultant Total Row D) The Excel function called PAID

Where does Excel display the Total row in a table? A) Below the last row in the table B) After each subtotal in the table C) At the top of the table D) Two rows below the last row in the table

By default Excel prints page in what order? A) All the even numbered pages, then all the odd numbered pages B) All the odd numbered pages, then all the even numbered pages C) Top-left section, top-right section, bottom-left section, and bottom-right section D) Top-left section, bottom-left section, top-right section, and bottom-right section

By how many levels will Excel allow you to sort? A) 32 B) 128 C) 64 D) 16

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) Color Scales D) Between Values Rules

What is not true about tables in Excel? A) Column headings stay on the screen automatically. B) You can export the data to a SharePoint list. C) Filter arrows make it quick and easy to filter the data in the table. D) Row headings stay on the screen automatically.

On which tab will you find options if you have to print a large dataset? A) Page Layout B) Home C) Print D) Review

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination? A) A1 becomes the active cell. B) The first unfrozen cell becomes the active cell. C) Row 1 and whatever column was active when you pressed the combination becomes the active cell. D) Column A and whatever row was active when you pressed the combination becomes the active cell.

To what does the @ symbol refer in a structured reference? A) Current column B) Current cell C) Current table D) Current row

The filter "Begins With..." option is found on which type of filter? A) Custom filter B) Text filter C) Number filter D) Date filter

Which conditional formatting option is not found in the Quick Analysis Gallery? A) Duplicate Values B) Unique Values C) Text Contains D) Undo Format

Which wildcard character only replaces one character with one other character? A) Tilde ~ B) Number sign # C) Question Mark ? D) Asterisk *

Using the data bars conditional formatting, how is the highest value represented? A) By the most number of bars B) By the longest bar C) By the darkest bar D) By the tallest bar

Which of the following is not a freeze option? A) Freeze Top Row B) Freeze First Column C) Freeze Panes D) Freeze Section

If you use the Icon sets conditional formatting, you are limited to how many categories? A) Three, four, or five B) One, two, or three C) Four, five, or six D) Two, three, or four

Which of the following is not a way to bring up the Go To dialog box? A) F5 B) Ctrl+G C) Alt+F7 D) Name Box

What cannot be found on the Manage Rules dialog box? A) New Rule B) Edit Rule C) Copy Rule D) Delete Rule

Which one of the following filter options is not found on the number filter submenu? A) Below Average B) Bottom 10... C) Greater Than... D) Between...

When would you not need to use a fully qualified structured reference? A) When referring to a cell on a different worksheet B) When referring to a cell on a different workbook C) When referring to a cell within the table D) When referring to a cell outside the table

Which of the following is not a characteristic of a table? A) Can contain multiple ranges B) Contains related data C) Helps to analyze information D) Helps to manage information

In a structured reference what do you use to indicate a column heading or field name? A) Parenthesis () B) Curly brackets {} C) Brackets [] D) Quotes ""

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) AutoComplete formatting B) Aggregate Cell formatting C) AutoFill formatting D) Conditional formatting

What is not true about creating a data table? A) Make sure to leave one blank row below the data labels. B) Format the field names so that they stand out visually. C) Keep field names short. D) Make sure no column labels are the same.

Which table style option is useful to display aggregated data when it is checked? A) Last Column B) Header Row C) Filter Button D) Total Row

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) Delete any blank columns in your table. D) It is best to put individual data tables on separate sheets.

Which table style option shows the field names when it is checked? A) Banded Columns B) Total Row C) First Column D) Header Row

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) January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015 B) January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959 C) December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959 D) December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959

What is not true about using the AND function in a custom conditional formatting rule? A) You may have as many tests as you need in the formula. B) You must have at least two tests in the formula. C) All the tests must be of the same data type, for example: all numbers or all text. D) All the logical tests must be true for the formatting to be applied.

Which one of the following filter options is not found on the date filter submenu? A) Between B) First Quarter C) Last Month D) Tomorrow

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

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

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

Using the Print ________ can help you save paper.

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

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

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

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

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

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

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

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

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

Excel will allow you to sort on ________ levels.

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

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.

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

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

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

Table ________ add color and borders to a table.

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

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

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

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

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

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

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

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

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

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

True or False: Filter arrows are always displayed in data tables.

True or False: Selecting a range automatically makes it a data table.

True or False: When you use the Freeze Panes option you freezing both columns and rows.

True or False: In a data table calculated columns will copy down the table automatically.

True or False: "John Smith" is a good example of a field.

True or False: You can freeze as many columns and rows at the same time as you desire.

True or False: It is impossible to create a data table from random, unorganized data.

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

True or False: You can select multiple print areas.

True or False: 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.

True or False: 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.

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

True or False: Excel uses dashed blue lines to indicate manual page breaks.

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

True or False: Excel uses solid blue lines to indicate automatic page breaks.

True or False: Records are individual pieces of information.

True or False: It is a good practice to print column and row labels on each page.

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

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

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

True or False: You cannot sort cells by their fill color.

True or False: 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.

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

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

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

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

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

You cannot sort cells by their fill color.