USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is the correct formula to add cells A1 and B2?
|
|
=Sum(A1:B2)
|
|
|
A1+B2
|
|
|
=A1+B2
|
|
|
=$A1, $B2
|
Explanation:
Detailed explanation-1: -Formula for adding values of cells A1 to A5 would be =SUMA1 : A5.
Detailed explanation-2: -Which sequence will add 5 to each number in cells A1, A2, and A3? Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.
Detailed explanation-3: -For example, A1 refers to the cell at the intersection of column A and row 1. The reference tells Formula One for Java to use the contents of the referenced cell(s) in the formula. If a formula requires a number, you can substitute a reference to a cell that contains a number.
There is 1 question to complete.