Excel Year 2 Skills

How can you change the font style of a cell in Excel?

• Select the cell or range of cells, go to the 'Home' tab, choose font style from the dropdown menu.

• Press Ctrl + F to change font style

• Use the 'Insert' tab to change font style

• Right-click on the cell and select font style

What is the shortcut key to create a new chart in Excel?

• Alt + F1

• Shift + A

• Alt + C

• Ctrl + N

Explain the process of sorting data in Excel.

• Filter data -> Data tab -> Sort button -> Choose column -> Select order -> OK

• Highlight data -> Insert tab -> Sort button -> Choose column -> Select order -> OK

• Select range -> Data tab -> Sort button -> Choose column -> Select order -> OK

• Select range -> Format tab -> Sort button -> Choose column -> Select order -> OK

What are the different types of charts you can create in Excel?

• Waterfall

• Heatmap

• Gantt

• Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Doughnut, Bubble, Radar

How can you apply conditional formatting to a range of cells in Excel?

• 2. Use the 'Page Layout' tab and select 'Themes' to format the range of cells conditionally.

• 1. Click on the 'Insert' tab and choose 'Shapes' to apply conditional formatting.

• 3. Access the 'Review' tab and click on 'Spelling' to apply conditional formatting to the cells.

• You can apply conditional formatting to a range of cells in Excel by selecting the range, going to the 'Home' tab, clicking on 'Conditional Formatting' in the Styles group, choosing the desired formatting option, and setting the conditions.

Describe the steps to insert a line chart in an Excel worksheet.

• Select Insert tab -> Line Chart -> Choose data -> Chart inserted

• Right-click on data -> Insert tab -> Line Chart -> Chart inserted

• Choose data -> Insert tab -> Line Chart -> Right-click to insert

• Select data -> Insert tab -> Line Chart -> Choose subtype -> Chart inserted

What is the purpose of filtering data in Excel?

• The purpose of filtering data in Excel is to focus on specific information, hide irrelevant data, and analyze subsets of data more effectively.

• To slow down the analysis process

• To increase the file size

• To make the data harder to read

How can you merge cells in an Excel worksheet?

• Select cells, right-click, Format Cells, Alignment tab, check Merge cells, OK

• Highlight the cells, press Ctrl + M, select Merge from the dropdown menu

• Click on the cells, go to the Insert tab, click on Merge Cells

• Right-click on the cells, choose Merge & Center from the context menu

Explain the difference between a bar chart and a pie chart.

• A bar chart uses circles, a pie chart uses rectangles.

• A bar chart uses bars, a pie chart uses slices.

• A bar chart shows time series data, a pie chart shows geographical data.

• A bar chart represents percentages, a pie chart represents quantities.

What is the function of the 'Format Painter' tool in Excel?

• Copy and paste formatting

• Insert new rows

• Calculate formulas

• Change font color