Accounting Spreadsheet Fundamentals

__________ occur as a set of parentheses within another set of parentheses. An example is /((9+6)*3).

A. Open parentheses

B. Nested parentheses

C. Recurring values

D. Repeated values

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

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

If you want to change a formula sequence, you must use:

A. the formula pointing method.

B. exponentiation.

C. parentheses.

D. toolbar buttons.

The values of cells C1, C2, and C3 are 3, 6, and 9, respectively. What is the result of the formula *C2/C3-1?

A. 0

B. 1

C. 2.25

D. An error message

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.

The simplest type of formula that you can create in Excel is one that contains only numbers and:

A. values.

B. text.

C. mathematical operators.

D. functions.

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

The Order of Precedence (priority) for a formula that does NOT include parentheses is:

A. addition or subtraction, then multiplication or division, then exponentiation.

B. multiplication or division, then addition or subtraction, then exponentiation.

C. exponentiation, then multiplication or division, then addition or subtraction.

D. exponentiation, then addition or subtraction, then multiplication or division.

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.

Which one of the following is NOT a symbol for an arithmetic operator?

A. A plus sign (+)

B. An equal sign (=)

C. A caret (^)

D. An asterisk (*)

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

A. 0

B. 1

C. 2.25

D. An error

If you combine several operators in a single formula, Excel will first evaluate exponents, followed by multiplication and division, followed by addition and subtraction. When the formula involves both multiplication and division or both addition and subtraction, the operators are evaluated from left to right. This is referred to as the:

A. Sequence of Evaluation.

B. Order of Precedence.

C. Parenthetical Expression.

D. Mathematical Operator.

You can control the sequence of computations by using:

A. functions.

B. formulas.

C. parentheses.

D. mathematical operators.

The mathematical operation .9*4 yields what result?

A. 12.9

B. 8.94

C. 2.225

D. 35.6

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

Accounting Spreadsheet Fundamentals __________ 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 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 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 If you want to change a formula sequence, you must use: A. the formula pointing method. B. exponentiation. C. parentheses. D. toolbar buttons. 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 message 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. The simplest type of formula that you can create in Excel is one that contains only numbers and: A. values. B. text. C. mathematical operators. D. functions. 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 The Order of Precedence (priority) for a formula that does NOT include parentheses is: A. addition or subtraction, then multiplication or division, then exponentiation. B. multiplication or division, then addition or subtraction, then exponentiation. C. exponentiation, then multiplication or division, then addition or subtraction. D. exponentiation, then addition or subtraction, then multiplication or division. 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. Which one of the following is NOT a symbol for an arithmetic operator? A. A plus sign (+) B. An equal sign (=) C. A caret (^) D. An asterisk (*) 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 If you combine several operators in a single formula, Excel will first evaluate exponents, followed by multiplication and division, followed by addition and subtraction. When the formula involves both multiplication and division or both addition and subtraction, the operators are evaluated from left to right. This is referred to as the: A. Sequence of Evaluation. B. Order of Precedence. C. Parenthetical Expression. D. Mathematical Operator. You can control the sequence of computations by using: A. functions. B. formulas. C. parentheses. D. mathematical operators. The mathematical operation =8.9*4 yields what result? A. 12.9 B. 8.94 C. 2.225 D. 35.6 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