Microsoft Excel Review Part 3

Identify this icon

• Use this icon to quickly add a new worksheet.

• Use this icon to insert symbols that are not on your keyboard.

• To specify that someone must sign the worksheet, use this function.

• Use this icon to insert a circle or square.

Answer explanation

The correct choice indicates that this icon is used to quickly add a new worksheet, which is a common function in spreadsheet applications. The other options describe different functionalities that do not match the icon's purpose.

Identify this icon

• Use this icon to quickly add a new worksheet.

• Use this icon to insert symbols that are not on your keyboard.

• To specify that someone must sign the worksheet, use this function.

• Use this icon to insert a circle or square.

Answer explanation

The correct choice is to use this icon to insert symbols that are not on your keyboard, as it specifically allows users to access a variety of special characters and symbols that are not readily available on standard keyboards.

Identify this icon.

• Use this icon to quickly add a new worksheet.

• Use this icon to insert symbols that are not on your keyboard.

• To specify that someone must sign the worksheet, use this function.

• Use this icon to insert a circle or square.

Answer explanation

The correct choice indicates that the icon is used to specify that someone must sign the worksheet, which is essential for document validation and approval processes.

Identify this icon.

• Use this icon to quickly add a new worksheet.

• Use this icon to insert symbols that are not on your keyboard.

• To specify that someone must sign the worksheet, use this function.

• Use this icon to insert a circle or square.

Answer explanation

The correct choice is to use this icon to insert a circle or square, as it specifically relates to shape insertion, unlike the other options which pertain to different functions.

What should be used to add a process chart or an organizational chart to a worksheet?

• Signature Line

• WordArt

• SmartArt

• Shapes

Answer explanation

SmartArt is specifically designed for creating process charts and organizational charts in a worksheet, making it the correct choice. Other options like WordArt and Shapes do not provide the same structured functionality.

Which of the following can be done to a worksheet?

• Name

• Rename

• Move

• All of these

Answer explanation

You can perform multiple actions on a worksheet, including naming it, renaming it, and moving it. Therefore, the correct answer is 'All of these' as it encompasses all the listed options.

Inserting a hyperlink allows you to create a link in your worksheet for quick access to webpages and files.

• TRUE

• FALSE

Answer explanation

TRUE. Inserting a hyperlink in your worksheet indeed allows you to create links for quick access to webpages and files, enhancing navigation and usability.

Identify this icon.

• Use this icon to insert a column chart.

• Use this icon to insert a chart that compares values across geographical regions.

• Use this icon to insert a line chart.

• Use this icon to insert a pie chart.

Answer explanation

The correct choice is 'Use this icon to insert a column chart.' because column charts are specifically designed to compare values across different categories, making them ideal for visualizing data in this format.

Identify this icon.

• Use this icon to insert a column chart.

• Use this icon to insert a chart that compares values acrossgeographical regions.

• Use this icon to insert a line chart.

• Use this icon to insert a pie chart.

Answer explanation

The correct choice is for a chart that compares values across geographical regions, typically represented by a map or similar visual, distinguishing it from other chart types like line or pie charts.

Identify this icon.

• Use this icon to insert a column chart.

• Use this icon to insert a chart that compares values acrossgeographical regions.

• Use this icon to insert a line chart.

• Use this icon to insert a pie chart.

Answer explanation

The correct choice is 'Use this icon to insert a line chart.' because line charts are specifically designed to show trends over time, making them ideal for displaying data points connected by lines.