All categories

3 years ago

Which operation would occur in the equation =C3+D5*C6-B2 in excel.

Computers and Technology

1 answer:

UkoKoshka [18]3 years ago

5 0

Answer:

The operation that will occur first is D5*C6 (multiplication).

Explanation:

Excel’s default order of operator precedence mandates that Excel perform multiplication before addition and substraction. If you want the addition or substraction to be performed before multiplication or division, they must be in parentheses.

The order of operations in exel is:

1. Evaluate items in parentheses.

2. Evaluate ranges (:).

3. Evaluate intersections (spaces).

4. Evaluate unions (,).

5. Perform negation (-).

6. Convert percentages (%).

7. Perform exponentiation (^).

8. Perform multiplication (*) and division (/), which are of equal precedence.

9. Perform addition (+) and subtraction (-), which are of equal precedence.

10. Evaluate text operators (&).

11. Perform comparisons (=, <>, <=, >=).

You might be interested in

Write a function named isDivisible that takes two parameters

nirvana33 [79]

Answer:

def isdivisible():

maxint=input("Enter the Max Int")

int1=0

int2=0

int1=input("Enter the first Integer")

int2=input("Enter the second Integer")

tup1=(int1, int2)

print(tup1)

i = 1

for i in range(1, int(maxint)-1):

if int(tup1[0])%i==0 & int(tup1[1])%i==0:

print(i)

else:

continue

isdivisible()

1.2 Outputs

First test case:

Enter the Max Int6

Enter the first Integer2

Enter the second Integer8

('2', '8')

Second test case: returning empty list

Enter the Max Int2

Enter the first Integer13

Enter the second Integer27

('13', '27')

Test case 3:

Enter the Max Int4

Enter the first Integer8

Enter the second Integer10

('8', '10')

Explanation:

The program is as above, and the three test cases are also mentioned. We have created a tuple out of two input integer, and performed the output as required.

3 0

3 years ago

Convert the following numbers. (Please show all steps; no marks will be awarded if no steps are shown) [1.5 x 4 = 6 marks]

katen-ka-za [31]

Answer:

i. 10210212

ii. 100 101 001 in BASE 2

iii. 46.4631

iv. 12.453125

Explanation:

i. Converting to base 10 we get

= 10 x 162 + 13 x 161 + 9 x 160 = 2777

Converting to base 10 we get =

2777/3 = 925 with remainder 2

925/3 = 308 with remainder 1

308/3 = 102 with remainder 2

102/3 = 34 with remainder 0

34/3 = 11 with remainder 1

11/3 = 3 with remainder 2

3/3 = 1 with remainder 0

1/3 = 0 with remainder 1

Hence the Answer is 10210212

ii. = Octal is taken in pair of 3 bits , Writing binary of each number in 3 bits we get = 100 101 001 in BASE 2

iii. = 1 x 52 + 2 x 51 + 3 x 50 + 3 x 5-1 = 38.6 in decimal

Converting to Octal we get

38 /8 = 4 with remainder 6

4 /8 = 0 with remainder 4

.6 x 8 = 4.8

.8 x 8 = 6.4

46.4631

iv. = 1x 81 + 4 x 80 + 3 x 8-1 + 5 x 8-2 = 12.453125

Check here for Free courses about IT and Management www.eacademy.lk

4 0

3 years ago

There are two kinds of emotions: positive and negative. True False

fgiga [73]

Answer:

False

Explanation:

There are many emotions the human brain can experience

6 0

3 years ago

Read 2 more answers

What is a way to minimize technical problems with your computer

nlexa [21]

A good way to minimize technical problems with your computer would be to make sure it is updated regularly. Also, you could make sure all the latest drivers are installed for your computer hardware

3 0

3 years ago

Which of these tools can best be used as a self assessment for career planning purposes? a personality test an asset analysis a

Ivahew [28]

Answer:

a goal development checklist

Explanation:

8 0

3 years ago