FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) table
B) column
C) row
D) database

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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.

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

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

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

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

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.

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.

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.

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

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.

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

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

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

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