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

In Excel,you can not only track and manage financial and numerical data,but you can also create simple databases.

A ________ is an XML file that contains the rules for what can and cannot reside in an XML data file.

Data in an Access database is organized in a format of horizontal rows and vertical columns.

With the use of icon sets for conditional formatting,icons that make your data easier to interpret are placed ________ the cells.

A ________ is a horizontal row in a database table that stores all of the data about one database item.

Filtering controls enable you to change the background color of table cells.

The ________ function is used to join up to 255 strings of characters.

To make sorting and filtering easier,you can separate data into separate fields by using ________.

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

You can ________ data into Excel from an Access database.

Which of the following statements is NOT true about side-by-side tables?

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

To easily compare similar sets of data in the same worksheet,use side-by-side ________.

The ________ function capitalizes the first letter of each word in a string.

You can establish connections to the external data so that you can automatically ________ your Excel workbook from the original data.

Data can be imported from a text file into Excel.

When you convert a range to a table,a table style is applied,and the headings display ________ arrows.

Small graphic images known as ________ provide visual cues about the value of a cell relative to other cells.

________ make(s)data easier to interpret by changing the data's appearance based on a condition.

When viewing your Excel worksheet in Page Layout view,you can use the ________ to measure and get a better visual view of your headers and footers.