USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Where are Totals calculations placed when added using the Quick Analysis feature?
|
|
On a new worksheet
|
|
|
Beginning at cell A1
|
|
|
On the last row visible on the screen
|
|
|
Adjacent to the data range
|
|
|
None
|
Explanation:
Detailed explanation-1: -The result of the totals can appear below the selected range or to the right of the selected range.
Detailed explanation-2: -Click the Quick Analysis Smart Tag icon or press Ctrl + Q. A gallery appears with tabs across the top and buttons below each tab. Click the Totals tab. Point to the button with the type of total calculation you would like to use such as Sum (if you simply point to the button, you will see a live preview).
There is 1 question to complete.