MOS Microsoft Excel

What can Microsoft Excel display data graphically in?

• Text

• Symbols

• Numbers

• Bars

Answer explanation

Microsoft Excel can display data graphically in bars, making it easier to visualize and analyze the information.

Why is presenting data in a chart useful?

• Doesn't affect readability

• Makes it easier to read

• Makes it harder to read

• No impact on interpretation

Answer explanation

Presenting data in a chart is useful because it makes it easier to read, allowing for a clearer visualization and understanding of the information.

How can you create a chart in Excel?

• Select the View tab and click on the Freeze Panes button

• Select the Data tab and click on the Filter button

• Select the Insert tab and click on the Chart button

• Select the Home tab and click on the Sort button

Answer explanation

To create a chart in Excel, you need to select the Insert tab and click on the Chart button.

What does the Chart Tools tab enable you to do?

• Change the font style

• Edit your chart with designs, layouts, and formats

• Apply conditional formatting

• Insert new rows

Answer explanation

The Chart Tools tab enables you to edit your chart with designs, layouts, and formats, allowing for customization and adjustments to the visual appearance of the chart.

How can you add a title to a chart in Excel?

• Use the AutoFilter feature

• Click on the Format tab and choose a title style

• Click on the Chart Title text box and press Enter

• Select the cell range A1:E5

Answer explanation

To add a title to a chart in Excel, you should click on the Chart Title text box and press Enter.

What happens to a chart when you change the worksheet data?

• The chart becomes blurry

• The chart remains the same

• The chart disappears

• The chart is updated

Answer explanation

When you change the worksheet data, the chart is updated to reflect the new data entered.

How can you create a Pie Chart in Excel?

• Select the cell range A1:A5 and D1:D5

• Click on the Insert tab and choose the Line Chart option

• Select the cell range A1:E5

• Click on the Home tab and select the AutoFill button

Answer explanation

Select the cell range A1:A5 and D1:D5 to create a Pie Chart in Excel.

What does the AutoFilter feature in Excel allow you to do?

• Merge cells

• Change the font color

• View and quickly locate data that meet specific criteria

• Apply borders to cells

Answer explanation

The AutoFilter feature in Excel allows you to view and quickly locate data that meet specific criteria.

What is the purpose of the Custom Filter option in Excel?

• To create named ranges

• To choose records based on specific criteria

• To sort data alphabetically

• To change the page layout

Answer explanation

The purpose of the Custom Filter option in Excel is to choose records based on specific criteria.

What is the Auto Fill feature in Excel used for?

• Change the chart type

• Automatically complete data in a series

• Apply formatting to cells

• Freeze rows and columns

Answer explanation

The Auto Fill feature in Excel is used to automatically complete data in a series, making it easier to fill in repetitive information quickly.