Question 1

Which of the following is NOT a method for rounding numbers to a specific number of decimal places in Excel?

Accepted Answer

There is no "DECIMAL" command in Excel. The other options - Increase/Decrease decimal command, Currency Style command, and Format Cells command - are all valid methods for rounding numbers to a specific number of decimal places in Excel.

Question 2

Which describes the value of the underlined digit? $ 8.027 $

Accepted Answer

The underlined digit is in the hundredths place, therefore its value is 2 hundredths.

Question 3

When Sarah bought school supplies, the total cost was $31.76. Sarah gave the cashier two twenty-dollar bills, so her change should be $8.24.

Accepted Answer

Sarah gave $40 in total ($20+$20) and the total cost was $31.76, so her change should be $8.24 ($40-$31.76).

Question 4

Which describes the value of the underlined digit? $16.10 \underline{1}$

Accepted Answer

The digit underlined is in the thousandths place, making it 1 thousandth.

Question 5

Ryan bought a phone with an original price of $145.80. He received a 25% discount off the phone, which amounted to $36.45. How much did he pay for the phone?

Accepted Answer

To find the discounted price, we need to subtract the amount of discount from the original price:
$145.80 - $36.45 = $109.35 
Therefore, Ryan paid $109.35 for the phone.

Question 6

Juan wants to place a border along his four flower gardens. He measures the lengths of each and finds them to be 1.25 m, 1.4 m, 0.83 m, and 1.68 m. If Juan buys 5 meters of border, he will have just enough border to line the front of the four gardens.

Accepted Answer

The total length of the four gardens is 1.25+1.4+0.83+1.68 = 5.16m. Juan needs to buy at least 5.16m of border, so he does not have enough with only 5m.

Question 7

Which is the best estimate to find the quotient for 1,380 $ \div $ 115?

Accepted Answer

B is the best choice as it is the closest multiple of 100 to both the dividend and divisor. A is too far from the divisor and C and D are too far from the dividend.

Question 8

Which is the product of 419  823?

Accepted Answer

The answer of Which is the product of 419 ...

Question 9

Which is the total cost of 3.5 pounds of grapes at $2.10 a pound?

Accepted Answer

The total cost of 3.5 pounds of grapes at $2.10 a pound is calculated by multiplying the price per pound by the number of pounds: 3.5 pounds * $2.10/pound = $7.35.

Question 10

Which is the product of $31  101?

Accepted Answer

To multiply these two numbers, we can use the distributive property and then regroup and carry as necessary. We get:
\begin{align*}
&\quad\phantom{ }31\
&	imes 11ec1544_ca03_5c71_aa23_618e7a26e605\
\cline{1-2}
&\phantom{000}31\
&\phantom{00}310\
&\phantom{0}3,100\
+&311,000\
\underline{+&3,100,000}\
&3,131,031
\end{align*}
So the product is $3,131$, which corresponds to answer choice $\boxed{	extbf{(C)}}$.

Question 11

Which is the quotient of 8,084 $ \div $ 94?

Accepted Answer

The quotient of 8,084 divided by 94 is 86.

Question 12

Which is the quotient of 10.276 $ \div $ 2.8?

Accepted Answer

To divide 10.276 by 2.8, we can use long division or a calculator. In either case, we get a quotient of approximately 3.67. Therefore, the best choice is C.

Question 13

What is 53.872 $ \div $ 3.7?

Accepted Answer

The answer of What is 53.872 $ \div $ 3.7?...

Question 14

Which number is the same as two million seven hundred thousand fifteen ?

Accepted Answer

Two million seven hundred thousand fifteen is written as 2,700,015. Thus, the answer is choice C.

Question 15

Mrs. Novotny uses Excel to track her students' grades. The first students' quiz scores are stored in Row 2, Columns B through E. Which of the following is a multimath formula which represents the average of the students' quiz scores?

Accepted Answer

The function =SUM(B2:E2)/5 will add up the quiz scores in cells B2 through E2, and then divide the sum by 5 to get the average. This is the appropriate formula for calculating the average of a set of numbers.

Question 16

Which is the best estimate to find the quotient for 657 $ \div $ 54?

Accepted Answer

The answer of Which is the best estimate to find...

Question 17

Mrs. Washington went to the store to purchase white boards for her students. The boards she chose cost $7.98 each. Her school has authorized up to $225, therefore, Mrs. Washington can purchase 29 boards.

Accepted Answer

If Mrs. Washington purchases 29 boards at $7.98 each, the total cost would be $231.42, which exceeds the maximum authorized amount of $225. Therefore, she cannot purchase 29 boards. She could buy a maximum of 28 white boards.

Question 18

What is the sum of 513.78 + 4.203?

Accepted Answer

To add the two decimals, line up the decimal points and add each place value. Starting from the right, 8+3=11 (write down 1, carry over 1), 7+0+0=7 (add the carried over 1 from before), 5+2=7, and 5+4=9. Therefore, the sum is 517.983. The correct answer choice is B.

Question 19

What is 7,938 $ \div $ 42?

Accepted Answer

The answer of What is 7,938 $ \div $ 42?...

Question 20

Excel follows the same basic order of operations that is used in algebra.

Accepted Answer

Excel uses the same order of operations as algebra, which is parentheses, exponents, multiplication and division (from left to right), addition and subtraction (from left to right).

Quiz 1: Basic Math Functions

Which of the following is NOT a method for rounding numbers to a specific number of decimal places in Excel?

Which describes the value of the underlined digit? $8.027$

When Sarah bought school supplies, the total cost was $31.76. Sarah gave the cashier two twenty-dollar bills, so her change should be $8.24.

Which describes the value of the underlined digit? $16.10 \underline{1}$

Ryan bought a phone with an original price of $145.80. He received a 25% discount off the phone, which amounted to $36.45. How much did he pay for the phone?

Juan wants to place a border along his four flower gardens. He measures the lengths of each and finds them to be 1.25 m, 1.4 m, 0.83 m, and 1.68 m. If Juan buys 5 meters of border, he will have just enough border to line the front of the four gardens.

Which is the best estimate to find the quotient for 1,380 $\div$ 115?

Which is the product of 419 823?

Which is the total cost of 3.5 pounds of grapes at $2.10 a pound?

Which is the product of $31 101?

Which is the quotient of 8,084 $\div$ 94?

Which is the quotient of 10.276 $\div$ 2.8?

What is 53.872 $\div$ 3.7?

Which number is the same as two million seven hundred thousand fifteen ?

Mrs. Novotny uses Excel to track her students' grades. The first students' quiz scores are stored in Row 2, Columns B through E. Which of the following is a multimath formula which represents the average of the students' quiz scores?

Which is the best estimate to find the quotient for 657 $\div$ 54?

Mrs. Washington went to the store to purchase white boards for her students. The boards she chose cost $7.98 each. Her school has authorized up to $225, therefore, Mrs. Washington can purchase 29 boards.

What is the sum of 513.78 + 4.203?

What is 7,938 $\div$ 42?

Excel follows the same basic order of operations that is used in algebra.

Quiz 1: Basic Math Functions

Which of the following is NOT a method for rounding numbers to a specific number of decimal places in Excel?

Which describes the value of the underlined digit? 8.027 8.027 8.027

When Sarah bought school supplies, the total cost was $31.76. Sarah gave the cashier two twenty-dollar bills, so her change should be $8.24.

Which describes the value of the underlined digit? 16.101‾16.10 \underline{1}16.101​

Ryan bought a phone with an original price of $145.80. He received a 25% discount off the phone, which amounted to $36.45. How much did he pay for the phone?

Juan wants to place a border along his four flower gardens. He measures the lengths of each and finds them to be 1.25 m, 1.4 m, 0.83 m, and 1.68 m. If Juan buys 5 meters of border, he will have just enough border to line the front of the four gardens.

Which is the best estimate to find the quotient for 1,380 ÷ \div ÷ 115?

Which is the product of 419 823?

Which is the total cost of 3.5 pounds of grapes at $2.10 a pound?

Which is the product of $31 101?

Which is the quotient of 8,084 ÷ \div ÷ 94?

Which is the quotient of 10.276 ÷ \div ÷ 2.8?

What is 53.872 ÷ \div ÷ 3.7?

Which number is the same as two million seven hundred thousand fifteen ?

Mrs. Novotny uses Excel to track her students' grades. The first students' quiz scores are stored in Row 2, Columns B through E. Which of the following is a multimath formula which represents the average of the students' quiz scores?

Which is the best estimate to find the quotient for 657 ÷ \div ÷ 54?

Mrs. Washington went to the store to purchase white boards for her students. The boards she chose cost $7.98 each. Her school has authorized up to $225, therefore, Mrs. Washington can purchase 29 boards.

What is the sum of 513.78 + 4.203?

What is 7,938 ÷ \div ÷ 42?

Excel follows the same basic order of operations that is used in algebra.

Which describes the value of the underlined digit? $8.027$

Which describes the value of the underlined digit? $16.10 \underline{1}$

Which is the best estimate to find the quotient for 1,380 $\div$ 115?

Which is the quotient of 8,084 $\div$ 94?

Which is the quotient of 10.276 $\div$ 2.8?

What is 53.872 $\div$ 3.7?

Which is the best estimate to find the quotient for 657 $\div$ 54?

What is 7,938 $\div$ 42?