DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
-
|
|
|
*
|
|
|
/
|
|
|
+
|
Detailed explanation-1: -You can use Excel as a calculator to add numbers by clicking on any cell and typing the = symbol and then the numbers you want to add together separated by a + symbol. In any cell, type “=9+7” (without the quotation marks). Notice that the equation in the formula bar for the cell still says “=9+7”.
Detailed explanation-2: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-3: -Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-4: -Launch your Excel app and go to “Insert > Symbols” menu. This will open Symbol utility having different special characters and symbols. Click on “Symbols” icon and choose “Greek” option from the dropdown. Select the symbol to insert on your sheet.