USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Quickly generate new values based on existing data
|
|
|
Forecast or project future value
|
|
|
Analyze data and generate a text-based report
|
|
|
Quickly generate totals and visualizations
|
|
|
None
|
Detailed explanation-1: -The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline. The Quick Analysis function helps you quickly format your data into a chart, table, summary formula, sparkline, or highlighted figures with just a few simple steps.
Detailed explanation-2: -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.
Detailed explanation-3: -The Excel quick analysis tool is a versatile feature that allows you to instantly analyze your data. Use it when you need to quickly calculate row or column totals and apply conditional formatting. You can instantly add tables, charts, and sparklines with the quick analysis tool.
Detailed explanation-4: -Quickly Create Data Bars This option comes in handy when you work with numeric data (conditional formatting data bars). You need to click on the quick analysis button and the formatting tab and then select the “Data Bars” option. It will instantly add solid data bars (Blue) to the selected data.