Chapter 5 : Create Charts and Objects
Visualization is key to interpreting data effectively. In this section, you?ll practice creating various chart types, customizing them, and adding objects like shapes, text boxes, and images to enhance your reports and dashboards.
Ques 1: How can you create a new chart in Excel?
A. Insert > Chart
B. Use Quick Analysis
C. Right-click > Insert Chart
D. Data > Create Chart
Ques 2: What is the first step to add an additional data series to an existing chart?
A. Right-click on the chart
B. Use the Chart Tools tab
C. Insert > New Series
D. Click on ""Add Data""
Ques 3: How can you switch between rows and columns in the source data for a chart?
A. Right-click > Switch Rows and Columns
B. Use the ""Switch Row/Column"" button in the Chart Tools
C. Use Quick Analysis
D. Press Ctrl + Shift + R
Ques 4: What feature can you use to quickly analyze data in Excel and suggest chart options?
A. Quick Analysis
B. Data Analysis
C. PivotTable Wizard
D. Chart Wizard
Ques 5: How can you resize a chart in Excel?
A. Drag the corners of the chart
B. Use the Format tab
C. Right-click on the chart
D. Double-click the chart
Ques 6: What is the purpose of adding and modifying chart elements in Excel?
A. To enhance the readability and understanding of the chart
B. To change the chart style
C. To add animations
D. To resize the chart
Ques 7: Which of the following can be added to a chart to give it a clearer meaning?
A. Data Labels
B. Gridlines
C. Trendline
D. All of the above
Ques 8: How can you apply a new chart layout to an existing chart in Excel?
A. Right-click > Apply Layout
B. Use the Chart Tools > Design tab
C. Use Quick Analysis
D. Click on Chart Styles
Ques 9: What is the feature in Excel that allows you to apply a specific style to your chart, such as color themes or design?
A. Chart Styles
B. Quick Layout
C. Data Analysis
D. Chart Wizard
Ques 10: How can you move a chart to a chart sheet in Excel?
A. Right-click > Move to Chart Sheet
B. Use the Move Chart option in the Chart Tools
C. Drag the chart to a new sheet
D. Double-click the chart
Ques 11: Which of the following objects can you insert into a worksheet in Excel?
A. Text boxes
B. Images
C. Shapes
D. All of the above
Ques 12: How can you modify the properties of an object in Excel?
A. Right-click on the object and select ""Format""
B. Use the Format tab
C. Use the Properties dialog
D. All of the above
Ques 13: What feature allows you to add a text description for an object to enhance accessibility?
A. Alternate Text
B. Object Properties
C. Object Description
D. Insert Caption
Ques 14: How do you insert a text box into a worksheet in Excel?
A. Insert > Text Box
B. Right-click > Insert Text
C. Insert > Object
D. Format > Text
Ques 15: What is the purpose of adding shapes to a worksheet in Excel?
A. To create visual elements
B. To organize data
C. To make charts interactive
D. To insert formulas
Ques 16: Which tab would you use to insert an image into a worksheet?
A. Insert
B. Home
C. View
D. Data
Ques 17: How can you resize an inserted object such as an image or shape in Excel?
A. Drag the corners of the object
B. Use the Format tab
C. Right-click > Resize
D. Both A and B
Ques 18: What is the first step to remove an object such as a shape or image in Excel?
A. Right-click > Delete
B. Press the Delete key
C. Use the Format tab
D. Select and press Ctrl+Z
Ques 19: How do you apply a chart style to your existing chart in Excel?
A. Right-click on the chart and choose Style
B. Use the Chart Tools > Design tab
C. Click on Quick Analysis
D. Insert > Chart Style
Ques 20: Which of the following chart elements can be modified in Excel?
A. Axis titles
B. Data labels
C. Chart title
D. All of the above
Ques 21: How do you change the layout of a chart to have a different arrangement of elements?
A. Use Quick Layout
B. Apply Chart Style
C. Resize the chart
D. Use Format tab
Ques 22: How can you make your chart more accessible for users with disabilities in Excel?
A. Add alternative text to objects
B. Use simpler charts
C. Use larger fonts
D. Add color contrast
Ques 23: Which feature in Excel can be used to quickly visualize and format large datasets?
A. Quick Analysis
B. Chart Styles
C. Conditional Formatting
D. PivotTables
Ques 24: How do you switch the data series displayed in rows to columns in a chart in Excel?
A. Use the Chart Tools > Design tab
B. Right-click on the chart
C. Click ""Switch Row/Column"" in the Chart Tools
D. Click on Quick Analysis
Ques 25: What is the advantage of moving a chart to a chart sheet in Excel?
A. To make the chart larger
B. To separate the chart from the data
C. To improve performance
D. To hide the chart