Microsoft Excel Chapter 2

Question 1

When typing a formula, begin the formula with this sign

Answer 1

=

Question 2

This is the operator for division that is used when writing a formula

Answer 2

/

Question 3

This is the operator for multiplication that is used when writing a formula

Answer 3

*

Question 4

As an alternative to the fill handle, use this button to copy a formula relatively in a worksheet.

Answer 4

fill button

Question 5

A function operates on this, which may consist of a constant, a cell reference, or other function.

Answer 5

an argument

Question 6

This function returns the largest value in a set of values.

Answer 6

MAX

Question 7

This is the keyboard shortcut to display formulas in a worksheet.

Answer 7

Control ~

Question 8

This function finds the periodic payment for a loan based on constant payments and a constant interest rate.

Answer 8

PMT

Question 9

This function returns the serial number of the current date and time.

Answer 9

NOW

Question 10

This function is considered a conditional function.

Answer 10

IF

Question 11

To identify an absolute cell reference, type this symbol before the column and row.

Answer 11

$

Question 12

This function returns the lowest value in a set of values.

Answer 12

MIN

Question 13

If Excel detects an error in a formula, a _____ ____ button appears and a dark green triangle displays in the upper left corner of the cell.

Answer 13

Trace Error

Question 14

This function counts the numbers of cells containing numbers within the list of arguments.

Answer 14

COUNT

Question 15

This function returns the future value of an investment periodic, constant payments and a constant interest rate.

Answer 15

FV