Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

_______ is a finance funtion. a. ABS b. DDB c. VARP d. NPER When creating a data

ID: 3926439 • Letter: #

Question

_______ is a finance funtion.

a. ABS

b. DDB

c. VARP

d. NPER

When creating a database, Excel will:

a. duplicate the values in the first entry for each entry

b. automatically format each entry based on your first entry

c. automactically create a function to total numerical values

d. delete each previous entry when you add a new entry

What function returns the minimum value found in specified ranges or a list of cells separated by commas?

a. RANGE

b. MIN(values)

c. MIN(list)

d. MIN(range)

The function SUM:

a. is sometimes used to display long division

b. summarizes key data in a spreadsheet

c. is used to add the values of two or more cells

d. will only add positive numbers

_______ is a mathematical function

a. ABS

b. DDB

c. VARP

d. NPER

Explanation / Answer

Answer :

_______ is a finance funtion.

a. ABS

b. DDB

c. VARP

d. NPER

Answer : b

DDB is a finance function.

When creating a database, Excel will:

a. duplicate the values in the first entry for each entry

b. automatically format each entry based on your first entry

c. automactically create a function to total numerical values

d. delete each previous entry when you add a new entry

Answer : b

b. automatically format each entry based on your first entry

What function returns the minimum value found in specified ranges or a list of cells separated by commas?

a. RANGE

b. MIN(values)

c. MIN(list)

d. MIN(range)

Answer : b

Min(values)

The function SUM:

a. is sometimes used to display long division

b. summarizes key data in a spreadsheet

c. is used to add the values of two or more cells

d. will only add positive numbers

Answer : c

The function SUM is used to add the values of two or more cells.

_______ is a mathematical function

a. ABS

b. DDB

c. VARP

d. NPER

Answer : a

ABS is a mathematical function