Function names may be entered a in upper or lower case b sur

Function names may be entered:

a. in upper or lower case

b. surrounded by quote marks (\'\'\')

c. only in lower case

d. in binary

In Excel, you format nubmers, which changes of the numbers

a. the actual values, but not the appearance

b. the appearance, but not the actual values

c. both the appearance ant the actual values

d. neither the appearance not the actual values

In Excel, changing a number\'s format will change:

a. only the actual value of the number

b. neither the appearance, nor the actual value of the number

c. only the appearance of the number

d. the appearance and the actual value of the number

Which function will result in only one value if something is TRUE and another if False?

a. IF

b. MAX

c. AVERAGE

d. SUM

Which one of the following is an example of a nested function?

a. ROUND(SUM(A1:A4))

b. SUM(A1+A2)/3

c. =(1*2)/(6-2)

d. (D1*D3)/(D4-D5)

The function AVERAGE(C3:C10) means to take the average of:

a. cell C3 or C10

b. cells C3 and C10

c. cells C3 minus cell C10

d. Cells C3 through C10