DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB 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. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-3: -To subtract multiple values from one another, simply type an equals sign followed by your first value or cell, a hyphen, and the value or cell you’re subtracting. Press Enter to return the difference between both values.
Detailed explanation-4: -To subtract a number from a range of cells, click on the cell where you want to display the result, and type “=” (equal) and the cell reference of the first number then “-” (minus) and the number you want to subtract. You can then copy this formula down the column to the rows below.