DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=A1*B1
|
|
|
A1xB1
|
|
|
A1*B1
|
|
|
=SUM(A1*B1)
|
Detailed explanation-1: -To perform the division formula in Excel, enter the cells you’re dividing in the format, =A1/B1. This formula uses a forward slash, “/, ” to divide cell A1 by cell B1. For example, if A1 was 5 and B1 was 10, =A1/B1 would return a decimal value of 0.5. Division in Excel is one of the simplest functions you can perform.
Detailed explanation-2: -Type =(A1&” “&B1) in C1 and press enter. Combined string will appear in cell C1. What this formula is doing is concatenating three strings. First it brings content of cell A1 and suffix it with a space (there is a space between double quotes) and then content of cell B1 are suffixed to it.
Detailed explanation-3: -To do this, you’ll simply need to begin the cell reference with the worksheet name followed by an exclamation point (!). For example, if you wanted to reference cell A1 on Sheet1, its cell reference would be Sheet1!A1.