Question

Question 1

A worksheet is composed of multiple workbooks.

True

False

Question 2

A1 contains 3 and A2 contains 4. Cell B2 contains = $A$1 ^ $A$1.

What value will cell C2 display if you copy the formula from cell B2 to cell C2?

0

27

12

16

Question 3

Which of the following cannot be a cell reference?

cell1

B3

$C5

$F$3

none of the above is correct

Question 4

What are the 3 most common types of data that are used in a worksheet cell?

Group of answer choices

text, numbers, and formulas

text, numbers, and values

text, sheets, and formulas

names, values, and formulas

none of the above is correct

Question 5

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has =C2 - B5 + A1 in it, what is displayed in cell D1?

3

4

6

7

this formula has a syntax error in it

Question 6

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has =2 * C2 -( B5 + A1) in it, what is displayed in cell D1?

2

4

7

11

none of the above is correct

Question 7

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has = 2 * (C2 - B5) + A1 in it, what is displayed in cell D1?

4

5

10

11

none of the above is correct

Question 8

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has = 2 * C2 - B5 + A1 in it, what is displayed in cell D1?

5

6

11

none of the above is correct

Question 9

In the formula below, which operator will a worksheet evaluate first?

=A2+B2*(2-5/C3)

=

+

*

-

/

Flag this Question

Question 10

In the formula below, which operation will a worksheet perform first?

=A2+B2*2-5/C3

=

+

*

-

/

Question 11

If cell A1 has 3 in it, cell B2 has 2 in it, what is the value displayed in cell B3 if it contains the following formula?

= 2*A1^B2+1

216

37

19

3

none of the above

Question 12

Which of the choices below is the correct way to express the mathematical value π in a worksheet?

p

pi

=pi

=PI

=PI()

Question 13

If A1 has 3 in it and A2 has 5 in it, what is the value in cell B3 if it contains the following formula?

=SQRT( A1 + 3 * A2 - 2 )

1.73...

2.236...

2.828...

3.46...

4

Question 14

Which formula below is a correct implementation of the square root of the sum of the squares of B2 and C3?

Group of answer choices

=SQRT( B2 + C3 )

=SQRT( B2 ^ 2 + C3 ^ 2)

=SQRT( B2 + C3 ) ^ 2

=SQRT( B2 ^ 2 ) + SQRT( C3 ^ 2 )

none of the above

Question 15

Which is the correct formula in a spreadsheet program to calculate x in the equation 10^x = 27?

=LOG10( 27 )

=SIN( 27 )

=LOG( 10, 27 )

=LN ( 20 )

none of the above

Question 16

Which of the following is NOT an acceptable range in a worksheet?

F2:G4

G, H

A1:A3

B3:B1

Question 17 1 pts

The formula below is in cell C5. If the formula is copied and pasted into D6, how will it appear?

= A1^(2-B2)

Group of answer choices

= B2^(2-C3)

= A1*(2-B2)

= C5^(2-D6)

= A1^(2-B2)

none of the above

Question 18

Which formula below has a syntax error in it?

= A2 + A3 - EXP( A4 )

= A2 + A3 - SQRT( A3 - A4 )

= LOG10(A2 + A3 - LOG10( A4 )

= A2 + 3 * A3 - PI()

= LN( SQRT( A2 + A3 - A4) )

Question 19

A spreadsheet has -2 in cell A3 and 4 in cell B7. Exactly what will be displayed in cell C5 if it contains exactly the following (be careful!):

B7/A3

Group of answer choices

0

-2

2

B7/A3

Question 20

In a worksheet, cell A1 contains 5 and A2 contains miles. What is displayed in cell B4 if it contains the formula

=A1 + A2?

5miles

5 miles

A1 + A2

error message

5

Answer 1

Question 1
False

Explanation
Workbooks composed of multiple worksheets

--

Question 2
27

Explanation

---

Question 3
cell1

Explanation
for reference it should mention cell number
"cell1" is not a cell number so
it cannot a cell reference
---

Question 4

text, numbers, and formulas

Explanation

Question 5

6

Explanation

---

Question 6
7

Explanation

---

Question 7
10

Explanation

---

Question 8
11

Explanation

--

Question 9
/

Explanation
=A2+B2*(2-5/C3)
first
5/C3
will execute first
5/3=1.6666
then
B2*2
then
addition
subtraction

---

Question 10
*

Explanation
=A2+B2*2-5/C3
First B2*2 will execute first
so * will be the answer

---

as per the guidelines Answered first part completely with explanation

please post remaining question separately

love to answer

all the best