Exam 10: Excell: External Data, Database Functions, and Side-By-Side Tables

The ________ function changes the case of the characters in a string,making all characters uppercase.

________ formatting makes your data easier to interpret by changing the appearance of data based on a condition.

The letter D at the beginning of a function identifies to Excel that a ________ range will be used in the formula.

Data that is organized in a useful manner is referred to as ________.

The shape or color of icons in an icon set indicates the ________ in the cells relative to all other adjacent cells formatted using the same condition.

Custom headers and footers provide ________ sections where you can type your own text or insert header and footer elements.

To center a page horizontally,use the Margins tab in the ________ dialog box.

Filtering arrows are removed from column headings when you use the ________ to Range command.

In a database,________ is a vertical column that stores information that describes a record.

The ________ text function will return the specified number of characters from the beginning of a string of characters.

To convert a table to a range,you must first select the entire table.

When you click the ________ button,the filtering arrows are removed from the cells,but the color and formatting of the table style remain.

The ________ text function will return the specified number of characters from the end of a string of characters.

Data stored in a format of rows and columns is referred to a field.

In Excel,you can insert a table beside another table in the same worksheet,and then work with the data in each table separately.

The ________ function counts the cells containing numbers in the column of records that match the conditions you specify.

To insert headers or footers in several worksheets at the same time,you must first ________ the worksheets.

On the ribbon,on the Data tab,use commands in the ________ group to bring data from outside Excel into an Excel worksheet.

Match the following five terms to their meanings: i.data connections II.delimited III.schema IV.Microsoft Access v.Extensible Markup Language (XML)

To print all the worksheets in a workbook at the same time,you can either ________ the worksheets,or under Print Settings,select Print Entire Workbook.