Question: QUESTION 1 5 points Save Answer In the spreadsheet below, if you typed =$A2+$B2 into cell C2, then copied the formula down to cell C3,

QUESTION 1 5 points Save Answer In the

QUESTION 1 5 points Save Answer In the spreadsheet below, if you typed =$A2+$B2 into cell C2, then copied the formula down to cell C3, what would be the numeric answer iin cell C3? B 1 Data 2 Data1 2 Answer 6 2 3 20 30 O A. 50 OB.6 OC. 600 OD. 24 QUESTION 2 5 points Save Answer If you typed into Excel the IF function below, which references the table below, what would be the value returned? =IF(A4="Sue", "This is Sue", "This is not Sue") 1 2 3 Data1 1 12 B Data2 2 15 blue John C Data3 3 22 4 red Sue green 5 Peter O A. This is Sue OB. Sue O C. This is not Sue OD. This is John

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!