USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is incorrect?
|
|
=sum(A1:H1)
|
|
|
=sum(G1:H1)
|
|
|
=sum:G1+H1
|
|
|
=A1+B1+C1+D1+E1+F1+G1+H1
|
Explanation:
Detailed explanation-1: -For example, to add together cells A1 and B1, move to C1 (or wherever you want the result of the calculation to appear) and type the =. Then use the mouse to click in A1, type the +, click in B1, and hit the enter key.
Detailed explanation-2: -The correct answer is SUBTRACT().
Detailed explanation-3: -Using a formula like: =SUM(A1, A2, A3, B1, B2, B3)
Detailed explanation-4: -This is because your formula is stored as text. To change it, go to Home tab> Select General from the dropdown. Then, press F2 and then Enter to recalculate the value in the cell. Your calculated result will now be displayed!
There is 1 question to complete.