COMPUTER 4_Enrichment Activity (FINAL)

What is the purpose of formatting cells in Excel?

• To calculate the sum of numbers in a cell

• To create charts and graphs automatically

• To store data in a database format

• The purpose of formatting cells in Excel is to improve the visual presentation and readability of data.

How do you change the font size of a cell in Excel?

• Select the cell, go to the 'Home' tab, and adjust the 'Font Size' in the 'Font' group.

• Double-click the cell and type the new font size directly.

• Right-click the cell and select 'Change Font Size' from the menu.

• Use the 'Insert' tab to adjust the font size.

What does the Autofill feature do in Excel?

• Autofill only works with text data.

• Autofill requires manual input for each cell.

• Autofill can only fill cells with random numbers.

• The Autofill feature automatically fills cells with data based on a pattern.

How can you sort data in Excel?

• Click 'File' and select 'Export'

• Right-click and choose 'Delete'

• Use the 'Insert' tab to add a chart

• Select data range, go to 'Data' tab, click 'Sort'.

What is the first step to filter data in Excel?

• Select the range of cells to filter.

• Sort the data alphabetically.

• Insert a new row for data entry.

• Change the cell colors.

What is the shortcut to copy a cell in Excel?

• Ctrl + V

• Alt + C

• Ctrl + X

• Ctrl + C

How do you change the background color of a cell?

• Right-click the cell and select 'Delete'.

• Change the font size to alter the cell's appearance.

• Select the cell, then choose a background color from the formatting options.

• Insert an image to cover the cell background.

What happens when you drag the fill handle in Excel?

• It opens a new Excel file.

• It copies and fills adjacent cells with a series or pattern.

• It changes the font style of the selected cells.

• It deletes the contents of adjacent cells.

How can you remove a filter in Excel?

• Use the 'Save' option in the File tab.

• Apply a new filter to the data.

• Use the 'Clear' option in the Data tab or clear filters from the column header.

• Sort the data in ascending order.

What is the difference between sorting and filtering?

• Sorting organizes data by order; filtering narrows down data by criteria.

• Sorting removes duplicates; filtering adds more data.

• Sorting is for numerical data only; filtering is for text data.

• Sorting changes data values; filtering changes data types.