Question 1

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

Accepted Answer

A)  Axes 
B)  Legend 
C)  Gridlines 
D)  Trendline 
A)  Axes 
B)  Legend 
C)  Gridlines 
D)  Trendline

Question 2

To edit an embedded object such as an Excel spreadsheet in its source application,double-click the drawer ID of the appropriate drawer in the Folders window,then double-click the folder containing the Excel spreadsheet,highlight it,choose Object > Edit Object to enter edit mode and make desired changes in it.

Accepted Answer

A) True 
 B)False

Question 3

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click)Chart Title > Font > Font tab > X> OK?

Accepted Answer

A)  Select a color in Color box. 
B)  Enter +Heading in Latin text font box. 
C)  Select Normal Spacing in Spacing box. 
D)  Enter the desired size of the chart title in the Size box. 
A)  Select a color in Color box. 
B)  Enter +Heading in Latin text font box. 
C)  Select Normal Spacing in Spacing box. 
D)  Enter the desired size of the chart title in the Size box.

Question 4

What will you do to explode a pie chart slice?

Accepted Answer

A)  Right-click the pie chart,click on Format Data Series,then enter a number in the percentage box. 
B)  Right-click the pie-chart,then click Change Series Chart Type,click Pie,and then click Pie of Pie. 
C)  Right-click the pie-chart,then click Change Series Chart Type,click Pie,and then click Bar of Pie. 
D)  Click the pie chart,then double-click the slice you want to explode,and drag it away from the center of the chart. 
A)  Right-click the pie chart,click on Format Data Series,then enter a number in the percentage box. 
B)  Right-click the pie-chart,then click Change Series Chart Type,click Pie,and then click Pie of Pie. 
C)  Right-click the pie-chart,then click Change Series Chart Type,click Pie,and then click Bar of Pie. 
D)  Click the pie chart,then double-click the slice you want to explode,and drag it away from the center of the chart.

Question 5

To move a chart to another location on the sane worksheet,drag it to the location you want.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

Accepted Answer

A)  Add 
B)  Edit 
C)  Remove 
D)  Delete 
A)  Add 
B)  Edit 
C)  Remove 
D)  Delete

Question 7

Arrow keys can be used to move any chart element.

Accepted Answer

A) True 
 B)False

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click)Chart Title > Font > Font tab > X> OK?

What will you do to explode a pie chart slice?

To move a chart to another location on the sane worksheet,drag it to the location you want.

Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

Arrow keys can be used to move any chart element.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters

Exam 4: Analyzing and Charting Financial Data

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click)Chart Title > Font > Font tab > X> OK?

What will you do to explode a pie chart slice?

To move a chart to another location on the sane worksheet,drag it to the location you want.

Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

Arrow keys can be used to move any chart element.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters