HW-1975 Excel Set-2

Question 1 of 20 5.0 Points
Function names may be entered:


A. in upper or lower case

B. surrounded by quote marks (“”)

C. only in lower case

D. in binary
Question 2 of 20 5.0 Points
In Excel, you can format numbers, 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 and the actual values

D. neither the appearance nor the actual values
Question 3 of 20 5.0 Points
When you enter a formula in a cell, the formula itself will be displayed in the:


A. Formula bar.

B. cell.

C. cell range.

D. cell operator.

Question 4 of 20 5.0 Points
Which number is in a different format that the rest?


A. 10,000

B. 10,000.0

C. 10,001

D. 100
Question 5 of 20 5.0 Points
__________ occur as a set of parentheses within another set of parentheses. An example is =90/((9+6)*3).


A. Open parentheses

B. Nested parentheses

C. Recurring values

D. Repeated values
Question 6 of 20 5.0 Points
The mathematical operation =8.9*4 yields what result?


A. 12.9

B. 8.94

C. 2.225

D. 35.6
Question 7 of 20 5.0 Points
Regardless of the complexity, a formula will always:


A. start with an equal sign.

B. contain the elements to be evaluated.

C. contain one or more operators.

D. All of the above
Question 8 of 20 5.0 Points
In a function, the parentheses tell Excel:


A. the order in which the function is evaluated.

B. where the arguments start and end.

C. the name of the function.

D. where the result starts and ends.

Question 9 of 20 5.0 Points
The formula =(45*8/(9+27) will result in an error message because:


A. The formula is not preceded by ‘

B. * is not a mathematical operator

C. The formula is not preceded by +

D. There are two left parentheses and only one right parentheses.

Question 10 of 20 5.0 Points
An actual value of 98.7 in a cell could yield a value of 99 in that same cell in Excel because of:


A. rounding

B. text

C. mathematical error

D. #REF
Question 11 of 20 5.0 Points
The __________ number format uses commas; can specify decimal place and use of $ (placed to the far left side of the cell). All values are aligned one space in from far right side of cell.


A. Pricing

B. Number

C. Currency

D. Accounting
Question 12 of 20 5.0 Points
The cell reference (C5:C8) is the same as:


A. (C5,C8).

B. (C5,C6,C7,C8).

C. (C6,C7).

D. (C5,6,7,8).

Question 13 of 20 5.0 Points
The values of cells C1, C2, and C3 are 3, 6, and 9, respectively. What is the result of the formula =C1*C2/(C3-1)?


A. 0

B. 1

C. 2.25

D. An error
Question 14 of 20 5.0 Points
Which of the following numbers is in the currency style?


A. $12.56

B. $13

C. 12.56%

D. .1256
Question 15 of 20 5.0 Points
The __________ function finds the arithmetic mean of a group of numbers.


A. MIDPOINT

B. MEDIUM

C. AVERAGE

D. AVPT

Question 16 of 20 5.0 Points
Which function will result in one value if something is true and another if false?


A. IF

B. MAX

C. AVERAGE

D. SUM
Question 17 of 20 5.0 Points
If you want to change a formula sequence, you must use:


A. the formula pointing method.

B. exponentiation.

C. parentheses.

D. toolbar buttons.

Question 18 of 20 5.0 Points
The __________ button places cells in the Accounting format with no $, but two decimal places.


A. Currency Style

B. Accounting Style

C. Decimal Style

D. Comma Style

Question 19 of 20 5.0 Points
Values in a function:


A. must be spelled out in words, not numbers

B. must be entered as whole numbers

C. can be a cell or a range of cells

D. cannot have a negative value
Question 20 of 20 5.0 Points
The function AVERAGE(C3:C10) means to take the average of:


A. cell C3 or C10.

B. cells C3 and C10.

C. cell C3 minus cell C10.

D. cells C3 through C10.


Answer will be sent by email as attachment.