FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

On the Quick Analysis Tools, you can select Icon Set under which option?

A	Formatting
B	Charts
C	Tables
D	Sparklines

Explanation:

Detailed explanation-1: -After clicking the quick analysis button, select “formatting”. It shows all the options under the tab: data bars, colors scale, icon set, greater than, top value and clear. Formatting is what you are looking for if you have a data to highlight.

Detailed explanation-2: -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.

Detailed explanation-3: -Quick Analysis takes a range of data and helps you pick the perfect chart with just a few commands. Select a range of cells. Select the Quick Analysis button that appears at the bottom right corner of the selected data. Or, press Ctrl + Q.

There is 1 question to complete.