Question 1

A ________ is a list of values that are acceptable for a range of cells.
A)table array
B)data table
C)validation list
D)cell range

Accepted Answer

A validation list is a list of acceptable values that can be used to restrict user input to a predefined set of options. This helps to ensure that data entered into a range of cells is accurate and consistent.

Question 2

Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.
A)relationships
B)links
C)pathways
D)sequences

Accepted Answer

Excel's Formula Auditing features are designed to show relationships between cells and formulas, helping users ensure that their formulas are logical, correct, and to resolve any error messages that may arise.

Question 3

________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.
A)Financial
B)Lookup
C)Statistical
D)Logical

Accepted Answer

Lookup functions, such as VLOOKUP and HLOOKUP, are used to search for a specific value in a range of cells and return a corresponding value from another cell in the same row or column. This makes it easy to retrieve data from a different part of the workbook without having to manually search for it. Financial functions are used for calculations related to finances, statistical functions are used for analyzing data, and logical functions are used for evaluating logical expressions.

Question 4

________ displays arrows that indicate what cells are affected by the value of the currently selected cell.
A)Trace Dependents command
B)Trace Precedents command
C)Tracer Arrow
D)Trace Error command

Accepted Answer

The Trace Dependents command displays arrows that indicate which cells are affected by the value in the currently selected cell.

Question 5

________ cells are cells that are referred to by a formula in another cell.
A)Dependent
B)Precedent
C)Trace
D)Related

Accepted Answer

Precedent cells are those that are referred to by a formula in another cell, meaning they are the cells that the formula depends on to calculate its value.

Question 6

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.
A)Goal Seek
B)Data validation
C)Data protection
D)What-If Analysis

Accepted Answer

Data validation is a technique to restrict or control the type of data or the values that can be entered into a worksheet. It helps improve the accuracy of data and ensures consistency in the data entered. Goal Seek, Data Protection, and What-If Analysis are different Excel tools and techniques that have different purposes.

Question 7

When you start typing a formula,such as =SUM(B Excel will display the ________,which contains all of Excel's built in functions starting with the letter B.
A)table array
B)Formula AutoComplete list
C)defined name
D)AutoFill

Accepted Answer

The Formula AutoComplete list appears when you start typing a formula and provides suggestions for functions or arguments. In this scenario, since we started typing =SUM(B, Excel will display a list of all built-in functions starting with B, and we can choose the suitable function from the list.

Question 8

An indicator that shows the relationship between the active cell and its related cell is called a(n)________.
A)tracer arrow
B)tracking arrow
C)error triangle
D)error diamond

Accepted Answer

A tracer arrow is an indicator in Microsoft Excel that shows the relationship between the active cell and its related cell. It is used to identify cells that are used in a formula or an equation in the active cell. Option B is not the correct answer because there is no such thing as a tracking arrow in Excel. Options C and D refer to error indicators in Excel and are not related to tracer arrows.

Question 9

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________.
A)Trace Dependents command
B)Trace Precedents command
C)Trace Error command
D)Tracer command

Accepted Answer

The Trace Precedents command displays arrows pointing to cells that are used in a formula in the selected cell. This helps to identify which cells affect the value of the selected cell. The Trace Dependents command displays arrows pointing from the selected cell to cells that depend on its value. The Trace Error command identifies cells with errors, and the Tracer command is not a valid Excel command.

Question 10

The Error Checking button displays as a ________.
A)purple arrow
B)blue circle
C)red square
D)yellow diamond

Accepted Answer

The Error Checking button in Microsoft Excel displays as a yellow diamond with an exclamation point inside it.

Question 11

For lookup functions to work properly,the data in the table array must be sorted ________.
A)by color
B)in reverse alphabetic order
C)in descending order
D)in ascending order

Accepted Answer

Lookup functions such as VLOOKUP and HLOOKUP require the data in the table array to be sorted in ascending order to work properly. This is because these functions search for the values in the leftmost column of the table array and the values in this column must be in ascending order for the function to return accurate results.

Question 12

A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.
A)orange
B)green
C)red
D)blue

Accepted Answer

A green triangle in the upper left corner of a cell in Excel indicates that the formula in the cell is suspect for some reason and could be a potential error. This is part of Excel's error checking feature.

Question 13

In a lookup formula,the defined range is referred to as the ________.
A)table array
B)named range
C)validation list
D)defined name

Accepted Answer

In a lookup formula, the defined range is referred to as the table array. This is the range of data where the formula will search for the lookup value. The other options mentioned are different terms in Excel but do not refer to the defined range in a lookup formula.

Question 14

________ is the process of examining a worksheet for errors in formulas.
A)Segmenting
B)Tracing
C)Defining
D)Auditing

Accepted Answer

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

Question 15

Use the ________ command to locate and resolve an error in a formula.
A)Find Error
B)Locate Error
C)Trace Error
D)Fix Error

Accepted Answer

The "Trace Error" command in Microsoft Excel allows the user to locate and resolve errors in a formula by visually tracking the precedents and dependents of a cell that contains an error. This helps in identifying any incorrect references or missing inputs in the formula.

Question 16

The ________ function looks up values in a table array arranged in horizontal rows.
A)VLOOKUP
B)MATCH
C)LOOKUP
D)HLOOKUP

Accepted Answer

The HLOOKUP function is used to look up values in a table array that is arranged in horizontal rows. The other options listed are used for other types of lookup tasks.

Question 17

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.
A)COLUMN
B)VLOOKUP
C)HLOOKUP
D)MATCH

Accepted Answer

The VLOOKUP function is used to look up values in a table array arranged as vertical columns. It searches for a specified value in the first column of a table and returns a value in the same row from a column that you specify. The COLUMN function returns the column number for a reference, the HLOOKUP function is used for looking up values in a table array arranged as horizontal rows, and the MATCH function is used to return the relative position of a specified item in a range or array.

Question 18

In the Data Validation dialog box,you can create a ________ that will display when the cell is selected and that provides instructions to the person entering data.
A)defined name
B)ScreenTip
C)cell reference
D)table array

Accepted Answer

A ScreenTip is a message that will appear when the cell is selected, providing instructions or guidance to the person entering data. The other options listed are not related to providing instructions in this manner.

Question 19

Cells that are referred to by a formula in another cell are called ________.
A)dependent cells
B)precedent cells
C)Trace dependents
D)Trace precedents

Accepted Answer

Precedent cells are those cells that are referred to by a formula in another cell, indicating that the value or formula in the precedent cell directly affects the outcome of the formula in the referring cell.

Question 20

The ________ command checks for common errors that occur when using formulas.
A)Hide Error
B)Audit
C)Error Checking
D)Seek Error

Accepted Answer

The Error Checking command checks for common errors such as formula inconsistencies, incorrect cell references, and circular references within formulas.

Quiz 4: Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

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

Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.

________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.

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

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

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.

When you start typing a formula,such as =SUM(B Excel will display the ________,which contains all of Excel's built in functions starting with the letter B.

An indicator that shows the relationship between the active cell and its related cell is called a(n) ________.

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

The Error Checking button displays as a ________.

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

A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.

In a lookup formula,the defined range is referred to as the ________.

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

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

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

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

In the Data Validation dialog box,you can create a ________ that will display when the cell is selected and that provides instructions to the person entering data.

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

The ________ command checks for common errors that occur when using formulas.