USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AVERAGE
|
|
|
COUNTIF
|
|
|
SUM
|
|
|
MAX
|
Detailed explanation-1: -On the Q1 Sales worksheet, insert a function in cell B19 that calculates all sales from the Total column. On the Q1 Sales worksheet, select cell B19. In the formula field, type =SUM(F4:F17). Click Enter on the keyboard to display the result.
Detailed explanation-2: -Enter “=SUM(D1:D#)” in the next empty cell in column D. Replace “#” with the row number of the last entry in column D. In the example, enter “=SUM(D1:D2)” to calculate the total sales revenue for the two items.
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: -SUM: This function adds all the values of the cells in the argument.
Detailed explanation-5: -Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.