Question Bank - Computer Awareness

Here's the question bank on all the computer awareness topics.

What is the output of the following MS-Excel formula? =SUM(1,2)^SUM(1,1)

A.
8
B.
9
C.
Error
D.
16

Solution:

The correct answer is 9.The result of the MS-Excel formula-SUM(1,2)^SUM(1, 1) is 9.Firstly SUM(1,2) will be solved and it is equal to 3------3^SUM(1,1)Then SUM(1,1) will be solved and it is equal to 2------3^2Then lastly 3^2 is solved which means the square of 3 is equal to 9.Additional InformationThe Excel SUM function returns the sum of values supplied.These values can be numbers, cell references, ranges, arrays, and constants, in any combination.SUM can handle up to 255 individual arguments.Purpose Add numbers togetherReturn value The sum of values supplied.Syntax =SUM (number1, [number2], [number3], ...)Arguments number1 - The first value to sum.number2 - [optional] The second value to sum.number3 - [optional] The third value to sum.

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.