USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Gabriel needs to crate a shortcut formula in cell B40 to calculate total sales located in cell B1 through B39. Which function should he create?
|
|
=$B1 + 25
|
|
|
=B1:B39
|
|
|
=Sum(B1:B39)
|
|
|
=B1 + 25
|
Explanation:
Detailed explanation-1: -The Autosum Excel Function[1] can be accessed by typing ALT + the = sign in a spreadsheet, and it will automatically create a formula to sum all the numbers in a continuous range.
Detailed explanation-2: -Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
There is 1 question to complete.