Computer Science

Auditing is the process of examining a worksheet for errors in formulas.

Started by brutforce

Data validation improves the accuracy of the person entering data into a worksheet.

Started by frankwu

In a Lookup formula, the defined range is referred to as the table array.

Started by hubes95

The HLOOKUP function looks up values in a table array arranged in vertical columns.

Started by melina_rosy

If you create a defined name and then decide that you no longer need it, you can delete the name and ...

Started by Mr.Thesaxman

When a new row is inserted into a named range, Excel adjusts formulas accordingly.

Started by eruditmonkey@yahoo.com

Naming cells has no effect on the displayed or underlying values.

Started by hbsimmons88

A one-variable data table will allow you to see how different interest rates and different payment ...

Started by jparksx

Data tables make it easy to calculate multiple versions in one operation, and then to view and ...

Started by biggirl4568

With Goal Seek, you can work backward from the desired outcome to find the number necessary to ...

Started by tuffie

Goal Seek is part of a suite of data tools used for What-If Analysis.

Started by kamilo84

The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.

Started by Beheh

________ displays arrows that indicate what cells are affected by the value of the currently selected cell.

Started by Mr3Hunna

A command that displays arrows to indicate what cells affect the value of the cell that is selected ...

Started by KWilfred

Cells that are referred to by a formula in another cell are called ________.

Started by mpobi80

Use the ________ command to locate and resolve an error in a formula.

Started by Diane

________ cells are cells that are referred to by a formula in another cell.

Started by Awilson837

A ________ is a list of values that are acceptable for a range of cells.

Started by mmm

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.

Started by james9437

For lookup functions to work properly, the data in the table array must be sorted ________.

Started by abarnes

The ________ function looks up values in a table array arranged in horizontal rows.

Started by karen

A defined name provides a logical reference to ________.

Started by Ebrown

Defined names can contain ________.

Started by mrsjacobs44

The location within which a defined name is recognized without qualification is referred to as the ________.

Started by acc299

A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a ...

Started by ericka1