BT-24: Ch.2: Excel 2016 L1

¡Supera tus tareas y exámenes ahora con Quizwiz!

What error code will display in a cell when an argument parameter does not meet a function's requirements?

#NUM!

Which of the following characters does Excel use to represent the mathematical operator for multiplication?

*

Which of the following characters does Excel use to represent the mathematical operator for division?

/

Which of the following contains a mixed cell reference?

=A12*C$2

The function that returns the arithmetic mean of the arguments is called

AVERAGE.

The Function Library group on the Formulas tab contains each of the following function categories except

Biological.

Use the _____ function to count the numeric values in a range.

COUNT

Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.

Editing; Home

When writing a formula by pointing at the desired cell references, complete the formula by pressing the _____ key.

Enter

Instead of typing dollar signs to indicate absolute cell references, you can press the _____ function key repeatedly to cycle through the various combinations of cell references.

F4

Update a workbook that contains the NOW or TODAY function by pressing this function key.

F9

Use this function key to update a NOW or TODAY function.

F9

Display formulas in a worksheet by clicking the Show Formulas button in this group on the Formulas tab.

Formula Auditing

Which function(s) would you use to find which employee has used the most vacation days and which has used the least?

MAX and MIN

The _____ function returns the current date and time in a date-and-time format.

NOW

When writing a formula by pointing, how do you end the formula?

Press the Enter key.

Use this keyboard command to display the Insert Function dialog box.

Shift + F3

What does it mean for a formula to have relative cell references?

The cell references change when the formula is copied to a new cell.

To display all formulas in the worksheet (rather than their results) press Ctrl +

` (grave accent).

What symbol is used to identify an absolute cell reference?

a dollar sign ($)

This cell reference refers to a cell in a specific location.

absolute cell reference

When writing your own formula, always begin the formula with

an equals sign (=).

What type of cell values will the AVERAGE function ignore and not use in its calculation?

blank cells

The AVERAGE function will ignore cells containing text and

blank cells.

To copy a formula to other cells using the Fill button, begin by selecting the

cell containing the formula as well as the cells to which the formula will be copied.

In the formula =SUM(A4:A17), the cell range (A4:A17) is an example of a(n)

cell reference argument.

A cell reference can be any of the following except

circular.

An absolute cell reference _____ change when copied to another cell.

does not

The Trace Error button displays with a(n) _____ inside a diamond.

exclamation point

A built-in formula, such as =SUM, is called a(n)

function

In the formula =SUM(A10:A15), the =SUM portion is referred to as the

function.

How many functions can Excel perform?

more than 300

When a formula contains two or more operators, Excel uses a specific order of operations to determine the sequence in which the operations are executed. Which of the following is the correct order of operations?

negations, percentages, exponentiations, multiplications, divisions, additions, subtractions

If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first.

parentheses

When a value calculated by a formula is inserted in a cell, this process is referred to as

returning the result.

The Trace Error button is a type of

smart tag

What is the general term for a pop-up button like the Trace Error button?

smart tag

By default, what displays in the Select a function list box in the Insert Function dialog box?

the most recently used functions

To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a

thin black cross.

To use the Formula AutoComplete feature, click the desired cell, type the equals sign, and then

type the first letter of the desired function.


Conjuntos de estudio relacionados

Module 4/Unit 4: The Accounting Cycle and Accounting Information Systems

View Set

The Catcher In The Rye Study Guide English III Honors

View Set

Specific Gynecology Course Objectives: Infections PA 603 Women's Health

View Set

General Biology 1011 Exam 3 Review

View Set

Comprehensive MSK Review (all classes)

View Set