FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can disable the Quick Analysis feature from the ____ window.
A
Excel Template
B
Excel Chart
C
Excel Options
D
Excel Functions
E
None
Explanation: 

Detailed explanation-1: -You can turn on/off the quick analysis feature in Excel in the Excel options menu. Just go to “Options” under the “File” tab. Under the General tab, check or uncheck the “Show Quick Analysis Options on Selection” tick box to toggle it on/off.

Detailed explanation-2: -Click the Tools menu, and then click Excel Add-ins. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

Detailed explanation-3: -Click on the File tab, then Options, and select Tick Mark. Tick Mark shows you if Quick Analysis is activated. Select the box labeled Show Quick Analysis Options on Selection. It will turn on the tool.

Detailed explanation-4: -In the Quick Analysis tool, both the Table and PivotTable options are available under TABLES.

There is 1 question to complete.
Previous
Next