Bus 230 Chapt 4 Excel

A text file is a document that includes formatted text.

When using an Advanced Filter, you need to create a criteria range.

A worksheet can have only one outline.

The Subtotal command includes SUM, AVERAGE, MAX, and MIN as well as other Statistical functions.

When you save worksheet data as a text file, Excel renames the sheet with the same file name that you type for the text file.

When you work with large numbers of records in a worksheet, you can use groups to hide data that is not needed at the moment.

You can create your own conditional formatting rule as well as edit existing rules with the Manage Rules command.

With Conditional Formatting, Top/Bottom Rules use a ranking to format the highest (top) or lowest (bottom) items, either by number or percentage.

You can import a table or a query from an Access database into an Excel worksheet.

In Excel, dates are treated as values.

If data is formatted as an Excel table, convert it to a normal cell range before using the Subtotal command.

Which of the following is a type of conditional formatting that displays cells with a fill color, a horizontal bar, or an icon? A. advanced filter B. PivotTable C. Microsoft Access database D. data visualization

Which of the following is an example of a data visualization command? A. Data Bars B. Color Scales C. Icon Sets D. all of the above

How does Excel treat dates? A. as text B. as values C. as filters D. as criterion

How does the Subtotal command format the list data? A. It doesn't format the list data. B. as an outline C. as a table D. as a PivotTable

In an Excel table, which of the following contains descriptive titles or labels? A. header row B. record C. field D. table

In an Excel table, which of the following represents a column of data? A. header row B. record C. field D. table

In an Excel table, which of the following represents a row of data? A. header row B. record C. field D. table

Using the Text Import Wizard to set the type of delimiter used in a text file, which of the following delimiters is commonly used? A. tab B. comma C. space D. all of the above

What type of file can most software applications read? A. Word documents B. Excel documents C. Access documents D. text files

Which of the following types of file might you see when downloading a bank statement? A. .docx B. .xlsx C. .csv D. .pdf

When you sort a cell range using A to Z or Z to A, what is rearranged? A. numeric values B. cells within a selected row C. cells within a selected column D. complete rows of data

Which kinds of source data can you import into Excel? A. text file B. database C. web location D. All of the above

Which of the following applies specified formats to cells only when the cells meet some criteria? A. Subtotal command B. Auto Outline command C. Group button D. Conditional Formatting

Which of the following is a specific item name in a structured reference that Excel automatically places in a table? A. #All B. #Data C. #Headers D. all of the above

Which of the following functions can be inserted by the Subtotal command? A. SUM B. AVERAGE C. MIN and MAX D. all of the above

Which of the following use ranking or averages to format cells? A. Top/Bottom Rules B. Quick Analysis tool C. Highlight Cells Rules D. all of the above

Which of the following represents an individual column in a text file? A. text file B. field C. Text Import Wizard D. delimiter