Exam 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

You can edit or delete a relationship once it has been created in the Relationships window.

Which error code will display if a formula contains a text error?

The Word Draw Table feature allows you to draw table cells exactly where you want them.​

Each cell in a table has a unique cell address composed of a letter and a number which is used when performing calculations. _________________________

Connector tools can draw free-form curved lines.

A cell with a(n) ____________________ reference contains a formula that refers to its own cell location.

A(n) ____________________ is a data separator; Excel uses it to separate data into columns.

Which of the following is NOT one of the arguments of a PMT function?

The Colors list arrow is on the ____ tab.

A connector has a yellow ____ handle which alters the path of the line.

The Address Block button is found on the ____ group.

Names of cells and ranges cannot use ____.

Which button do you click in the Function Library group to select SUMIF from the list of functions?

Cell and range names can have spaces.​

The simplest way to animate an object is to apply a ____ animation effect from the Animation group on the Animations tab.

The Name ____________________ dialog box can be used to delete and edit worksheet names.

One way to display formulas is by pressing this key combination.

Which sort order lists data alphabetically from A to Z?

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager.  There are four salespeople in the table. How would you sort the table by the names of the salespeople in alphabetical order?

A(n) ____________________ is the box formed by the intersection of a column and a row in a table.