DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the formula for =sum(B2:B9)
|
|
B1+B2+B3+B4
|
|
|
=B2+B3+B4+B5+B6+B7+B8+B9
|
|
|
B2+B3+B4+B5+B6+B7+B8+B9
|
|
|
=B1+B2+B3+B4
|
Explanation:
Detailed explanation-1: -Microsoft Excel formulas-the basics After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5. Use the SUM function: =SUM(B1:B5)
Detailed explanation-2: -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.
There is 1 question to complete.