Deck 1: Basic Math Functions

Question 1

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

A) DECIMAL command
B) Increase/Decrease decimal command
C) Currency Style command
D) Format Cells command

Answer 1

A

Question 2

Which describes the value of the underlined digit?

A) 2 hundreds
B) 2 tens
C) 2 tenths
D) 2 hundredths

Answer 2

D

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.

Answer 3

True

Question 4

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

A) 1 ten-thousandth
B) 1 thousandth
C) 1 hundredth
D) 1 tenth

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?

A) $109.35
B) $119.45
C) $171.25
D) $182.25

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.

Question 7

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

A) 1,400 120
B) 1,400 100
C) 1,300 150
D) 1,300 100

Question 8

Which is the product of 419 823?

A) 344,837
B) 346,932
C) 348,608
D) 404,093

Question 9

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

A) $5.60
B) $6.35
C) $7.04
D) $7.35

Question 10

Which is the product of $31 101?

A) $1,313
B) $3,100
C) $3,131
D) $3,441

Question 11

Which is the quotient of 8,084 94?

A) 66
B) 76
C) 86
D) 96

Question 12

Which is the quotient of 10.276 2.8?

A) 367
B) 36.7
C) 3.67
D) 0.367

Question 13

What is 53.872 3.7?

Question 14

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

A) 2,070,015
B) 2,070,150
C) 2,700,015
D) 2,700,150

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?

A) =SUM(B2:E2)
B) =(B2+E2)/5
C) =SUM(B2:E2)/5
D) =B2+C2+D2+E2/5

Question 16

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

A) 500 50
B) 600 50
C) 600 60
D) 700 50

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.

Question 18

What is the sum of 513.78 + 4.203?

A) 509.77
B) 517.983
C) 518.81
D) 5,179.83

Question 19

What is 7,938 42?

Question 20

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

Question 21

Solve:

Question 22

The word form for 4.061 is ____________________.

Question 23

Solve:

Question 24

A quick method for entering formulas that eliminates keyboarding by using the mouse to point to the cells that should be added is ____________________.

Question 25

Write the number form for twenty-two and eight tenths.

Question 26

Solve:

Question 27

Marybeth and Jim collected paper for a recycling drive. For 5 days they collected 45.15 lb, 67.25 lb, 75 lb, 61.5 lb, and 84 lb of paper. What is the average weight of the paper they collected?

Question 28

What is 2,639 13?

Question 29

Round $299.51 to the nearest dollar.

Question 30

What is 10.2563 8.09?

Question 31

Solve:

Question 32

What is 319.4 3.2?

Question 33

Solve:

Question 34

Solve:

Question 35

Nina went to the fish store and bought some guppies. She purchased 2 Flagtail guppies for $2.99 each, 6 Mosaic guppies for $3.49 each, and 4 Leopard guppies for $1.99 each. What was her total purchase?

Question 36

Solve:

Question 37

Solve:

Question 38

What is 2,089 151?

Question 39

Solve:

Question 40

Terri went to the flea market to buy plants. The cost for the plants were $14.99 for a Snake plant, $5.25 for a Philodendron, $7.49 for a Day Lily, and $13.89 for a Jade plant. How much did Terri spend on plants all together?

Question 41

Cell B5 contains hourly rate, Cell C5 contains regular hours, and Cell D5 contains overtime hours. What is the multimath formula that should be placed in Cell E5 to calculate gross earnings if overtime hours get paid at time-and-a-half?

Question 42

The cafeteria manager in the school lunch room has to keep track of all the lunches that are sold each day. For a five-day period, the numbers of lunches sold were 132, 156, 102, 158, and 175. What is the total number of lunches sold for the week?

Question 43

Rewrite by aligning the columns and then find the sum.

Question 44

Write the numeral form of six thousand two hundred twenty-eight .

Question 45

What is the Excel command that allows the user to select a row or column of numbers for addition and place the result at the bottom of the column or end of the row?

Question 46

Write the numeral and the position of the underlined digit.

Question 47

Write the word form for the number 1,084,203.

Question 48

Fill in each line as you mentally add.
5
5____
7 ____
5 ____
8 ____
+2 ____

Question 49

Describe how to round 315.715 to the tens place.

Question 50

Rewrite by aligning the columns and then find the sum.

Question 51

Find the sum of the following accumulation of products.

Question 52

Find the sum of the following accumulation of products.

Question 53

Fill in each line as you mentally add.
7
4 ____
5 ____
9 ____
2 ____
+5 ____

Question 54

What is 593.082 - 343.482?

Question 55

Mr. Jenkins builds Victorian dollhouses. He wants to carpet every room of a seven-room doll house. The square inches for each room are 120, 90, 64, 40, 56, 36, and 70. How many square inches of carpet will he need in all?

Question 56

What is 7,392,380 + 91,091?