DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Note: There is no SUBTRACT function in Excel. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM(100, -32, 15, -6) returns 77.
Detailed explanation-2: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done.
Detailed explanation-3: -In essence, Excel AutoSum automatically enters a formula to sum numbers in your worksheet.
Detailed explanation-4: -The FALSE function in Excel is equivalent to the number 0. We can perform all the mathematical operations with this function. If we multiply any number with this function, it will return zero.