USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you add a Total Row to a table?
|
Enable the Total Row table style option
|
|
Insert a blank row at the bottom of the table and then type “Total Row” as its heading
|
|
Enable the Total Row conditional formatting option
|
|
Use the Insert ribbon, then check Total Row
|
Explanation:
Detailed explanation-1: -Create a table, select any cell in the table, and press Ctrl + Shift +T. The total row will be added to the end of the table.
Detailed explanation-2: -Select a cell in a table. Select Design > Total Row. The Total row is added to the bottom of the table. Note: To add a new row, uncheck the Total Row checkbox, add the row, and then recheck the Total Row checkbox.
Detailed explanation-3: -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.
There is 1 question to complete.