Mastering Electronic Spreadsheets

What is the first step to create a chart in an electronic spreadsheet?

• Adjust the chart size.

• Select the data for the chart.

• Insert a title for the chart.

• Choose the chart type.

Which chart type is best for displaying trends over time?

• Line chart

• Pie chart

• Scatter plot

• Bar chart

How can you filter data to show only specific entries in a spreadsheet?

• Use the filter function in the 'Data' menu to select specific criteria.

• Use the search bar to highlight specific entries.

• Delete all entries that do not match the criteria.

• Sort the data alphabetically to find specific entries.

What is the purpose of sorting data in an electronic spreadsheet?

• To create visual charts automatically.

• To increase the file size of the spreadsheet.

• To organize and analyze data more effectively.

• To delete unnecessary data entries.

Which feature allows you to visualize data relationships in a spreadsheet?

• Charts or graphs

• Conditional formatting

• Formulas

• Tables

How do you change the data range for an existing chart?

• Double-click the chart and change the title.

• Select the chart and press the delete key.

• Use the chart menu to add a new chart type.

• Right-click the chart, select 'Select Data', and modify the data range.

What is the shortcut key for sorting data in ascending order?

• Alt + S, A

• Ctrl + S

• Shift + A, S, D

• Alt + A, S, A

How can you apply multiple filters to a dataset?

• Apply filters one at a time only.

• Use only one filter condition at a time.

• Use logical operators to combine filter conditions.

• Filters cannot be combined in a dataset.

What type of graph would you use to compare parts of a whole?

• Histogram

• Line graph

• Pie chart

• Bar graph

How do you remove a filter from a dataset in an electronic spreadsheet?

• Right-click on the dataset and select 'Delete Filter'

• Click on the filter icon and select 'Clear Filter' or 'Remove Filter'.

• Select the entire dataset and press 'Delete'

• Use the 'Data' menu and choose 'Remove All Filters'