FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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: -Chances are that it might be disabled and you have to enable it first to make it appear. Open the File menu and choose Options. You will find the General tab placed under the Options tab. Check the tick box on “Show Quick Analysis Options on Selection”, given under the General Tab in the Excel Options menu.

Detailed explanation-4: -The QUICK ANALYSIS TOOL is a collection of selected options that you can use to analyze the data quickly. It includes conditional formatting, charts, pivot table, and sparklines. It also takes care of what type of data (text, dates, or numbers) you have selected and show you the options based on that.

There is 1 question to complete.
Previous
Next