If “Excel” is stored in cell A1 and 2 is stored in cell B1, then which of the following statements is correct? Statement 1: =A1+B1 will throw #VALUE! error Statement 1: =SUM(A1:B1) will return the value 2 a. Both statements are incorrect b. Both Statements 1 & 2 are correct c. Statement 1 is correct, and statement 2 is incorrect d. Statement 2 is correct, and Statement 1 is incorrect

C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter5: Repetition Statements
Section5.7: Do While Loops
Problem 3E: (Misc. application) a. Write a program to reverse the digits of a positive integer number. For...
icon
Related questions
icon
Concept explainers
Question

If “Excel” is stored in cell A1 and 2 is stored in cell B1, then which of the following statements is correct?
Statement 1: =A1+B1 will throw #VALUE! error
Statement 1: =SUM(A1:B1) will return the value 2

a. Both statements are incorrect
b. Both Statements 1 & 2 are correct
c. Statement 1 is correct, and statement 2 is incorrect
d. Statement 2 is correct, and Statement 1 is incorrect
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Operators
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr