Microsoft Excel Quiz on Insert Tab

What is the process of inserting a chart in Excel?

• Open a new worksheet and paste the chart

• Go to the Home tab and click on the Chart option

• Go to the Insert tab and click on the Chart option

• Use the Format tab to insert a chart

Explain the steps to create a column chart in Excel.

• Select the data range > Go to the Insert tab > Click on 'Column Chart' in the Charts group

• Select the data range > Go to the View tab > Click on 'Column Chart'

• Select the data range > Go to the Home tab > Click on 'Column Chart'

• Go to the Data tab > Click on 'Column Chart' in the Charts group

How can you use the header and footer in Excel to add page numbers?

• Home tab > Header & Footer > Page Number

• Insert tab > Header & Footer > Page Number

• Data tab > Header & Footer > Page Number

• Format tab > Header & Footer > Page Number

Describe the function of the header and footer in Excel.

• They are used to change the font style of the entire spreadsheet.

• They are used to create new worksheets within the spreadsheet.

• They are used to display information at the top and bottom of each printed page.

• They are used to insert images into the spreadsheet.

What are the steps to create a hyperlink in Excel?

• Navigate to the Review tab, click on the Hyperlink button, and enter the address or select the location for the hyperlink

• Go to the Insert tab, click on the Hyperlink button, and enter the address or select the location for the hyperlink

• Use the Format tab, click on the Hyperlink button, and enter the address or select the location for the hyperlink

• Go to the Home tab, click on the Hyperlink button, and enter the address or select the location for the hyperlink

Explain how to insert a hyperlink to a website in an Excel spreadsheet.

• Navigate to the Data tab, click on the Hyperlink button, and enter the address of the website in the Address box.

• Use the Format tab, click on the Hyperlink button, and enter the address of the website in the Address box.

• Go to the Home tab, click on the Hyperlink button, and enter the address of the website in the Address box.

• Go to the Insert tab, click on the Hyperlink button, and enter the address of the website in the Address box.

How can you add shapes and symbols in Excel?

• By using the 'Insert' tab and selecting 'Shapes' or 'Symbols'

• By using the 'Review' tab and selecting 'Insert'

• By using the 'Data' tab and selecting 'Symbols'

• By using the 'Format' tab and selecting 'Shapes'

Describe the process of inserting a star shape in an Excel worksheet.

• Go to the 'Format' tab, click on 'Insert Object' in the 'Shapes' group, select the star shape, and then double-click on the worksheet to insert the star.

• Open the 'Home' tab, click on 'Insert' in the 'Illustrations' group, select the star shape, and then click once on the worksheet to insert the star.

• Go to the 'Insert' tab, click on 'Shapes' in the 'Illustrations' group, select the star shape, and then click and drag on the worksheet to draw the star.

• Navigate to the 'Review' tab, click on 'Shapes' in the 'Insert' group, select the star shape, and then right-click on the worksheet to draw the star.

What is the method to insert a screenshot in Excel?

• Insert tab > Screenshot

• Home tab > Screenshot

• Review tab > Screenshot

• Format tab > Screenshot

Explain the steps to insert a screen recording in an Excel document.

• Go to the 'Insert' tab, click on 'Screenshot' and select the screen recording from the available options.

• Open a new Excel document, right-click and choose 'Insert Screen Recording'

• Go to the 'Format' tab, click on 'Insert' and select 'Screen Recording'

• Access the 'Home' tab, click on 'Add' and choose 'Screen Capture'