Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started