Bus 110

By how many levels will Excel allow you to sort? 16 32 64 128

Which one of the following filter options is not found on the text filter sub menu? Begins With Includes Contains Custom Filter

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

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

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

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

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

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

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

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

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

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

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

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

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

In conditional formatting what happens if the cell value does not pass the logical test? The cell is formatted however you have determined for the FALSE result. The cell is formatted with Excel's default FALSE format. The cell is not formatted. A small green triangle displays in the top-left corner of the cell.

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

To what does the @ symbol refer in a structured reference? Current cell Current table Current column Current row

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

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

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

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

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

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

What is the default data table style? Normal Medium 1 Medium 2 None of the above