DATABASE FUNDAMENTALS
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: -The correct formula to add two numbers in two cells A1 and A2 of a spreadsheet is =A1+A2. In a spreadsheet, the SUM function is responsible for adding values.
Detailed explanation-2: -Formula for adding values of cells A1 to A5 would be =SUMA1 : A5.
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.