Duplicate of Excel Review (Advanced)

Question 1

In a PMT function, the argument indicated by fv refers to

Accepted Answer

future value

Question 2

The ____ function returns current date and time based on the computer's date and time settings

Accepted Answer

NOW()

Question 3

An example of a square root function written correctly is _______.

Accepted Answer

=SQRT(C4)

Question 4

In IF, the third argument determines the value that appears in the cell if the logical test is

Accepted Answer

false

Question 5

Three types of cell references are used in formulas that do NOT include ______________.

Accepted Answer

relational

Question 6

Some mathematical operations, such as +,-,* & /, do not require functions.

Accepted Answer

True

Question 7

The Round function is considered to be a ______________ function.

Accepted Answer

mathematical

Question 8

Functions that are used to format and work with cell contents

Accepted Answer

Text functions

Question 9

In IF, the second argument determines the value that appears in the cell if the logical test is

Accepted Answer

true

Question 10

When formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ________.

Accepted Answer

=$A$3+$A$4

Question 11

The Sum button is located in the ______group on the Home tab of the Ribbon.

Accepted Answer

Editing

Question 12

____Functions, such as the square root function manipulate quantitative data in a worksheet

Accepted Answer

mathematical functions

Question 13

Functions used to describe large quantities of data

Accepted Answer

Statistical

Question 14

Functions that are used to insert dates and times in a worksheet

Accepted Answer

Date and Time Functions

Question 15

To make all formulas visible, click the Show Formulas button in the ______ group.

Accepted Answer

Formula Auditing

Question 16

A constant (text or number) or cell reference used in a formula.

Accepted Answer

Operand

Question 17

Cell references that contain both ______ references are called mixed cell references.

Accepted Answer

relative and absolute

Question 18

Whenever you select a range, the Ribbon shows the results of common calculations for the cells.

Accepted Answer

False

Question 19

Do not change when copied or moved to a new cell

Accepted Answer

Absolute cell reference

Question 20

You can include cell references in a formula more quickly by using the point and click method.

Accepted Answer

True

Question 21

After you finish typing a formula in a cell, you must enter it by pressing the _______.

Accepted Answer

all answers

Question 22

The results of the calculation appear in the cell in which the formula is entered.

Accepted Answer

True

Question 23

When evaluating formulas, the _____ of parentheses is evaluated first.

Accepted Answer

innermost set

Question 24

Adjusts to its new location when copied or moved

Accepted Answer

relative cell reference

Question 25

The SUM function that adds the numbers in the range D5:D17 is _________.

Accepted Answer

=SUM(D5:D17)

Question 26

A(n)_______is a constant (text or number) or cell reference used in a formula.

Accepted Answer

operand

Question 27

A symbol that indicates the type of calculation to perform.

Accepted Answer

Operator

Question 28

An example of a function that returns the number of cells in a range of cells that have data is

Accepted Answer

=COUNT(B4:B15)

Question 29

Each formula begins with a quotation mark.

Accepted Answer

False

Question 30

Functions used to analyze loans and investments

Accepted Answer

Financial functions

Question 31

The rounding operation requires two arguments, which are separated by a comma.

Accepted Answer

True

Question 32

Logical functions can determine the average, standard dev. or variance of a range of data.

Accepted Answer

False

Question 33

If you need to find the average of a range of numbers, how would it be written correctly?

Accepted Answer

=AVERAGE(E4:E9)

Question 34

Cell references that contain both relative and absolute references

Accepted Answer

Mixed cell references

Duplicate of Excel Review (Advanced)

Questions 34

Duplicate of Excel Review (Advanced)

Questions 34