DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Functions in Ms. Excel that is used to add up data in a column is correct
|
|
=sum(G5:G50)
|
|
|
+sum(G5:G50)
|
|
|
sum=(G5:G50)
|
|
|
=sum(G5:H50)
|
Explanation:
Detailed explanation-1: -One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum.
Detailed explanation-2: -For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6. Here’s a formula that uses two cell ranges: =SUM(A2:A4, C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787.
Detailed explanation-3: -It means the sum of all the values in the cells from A1 till A5 in MS Excel.
There is 1 question to complete.