Spreadsheet Part 1 QUIZ 6th

What is the first step to duplicate a sheet in a spreadsheet program?

• Click 'File' and then 'Save As'
• Right-click the tab of the sheet and select 'Duplicate'
• Select all cells and copy them
• Click 'Edit' and then 'Copy'

How can you insert a row between two existing rows in a spreadsheet?

• Right-click on a column header and choose 'Insert column'
• Click 'Edit' and select 'Insert row above'
• Right-click on a row number and choose 'Insert 1 above'
• Click 'Data' and select 'Insert row below'

What is the purpose of freezing a column in a spreadsheet?

• To delete it easily
• To keep it visible while scrolling through the sheet
• To change its color
• To copy it to another sheet

How do you add a border around cells in a spreadsheet?

• Use the 'Paint format' tool
• Select the cells and click the 'Borders' button
• Right-click and choose 'Add border'
• Click 'Insert' and select 'Add border'

Which option allows you to resize a column to fit the data in a spreadsheet?

• Double-click the right border of the column header
• Right-click and select 'Insert column'
• Click 'Edit' and choose 'Resize column'
• Use the 'Paint format' tool

What should you do to sort your entire sheet by one column?

• Hide all other columns
• Click 'Data' and then 'Sort sheet by column'
• Delete all rows except the ones in that column
• Select the column and click 'Insert'

How can you remove data validation from header rows?

• Click 'Data' and select 'Remove validation'
• Right-click and choose 'Clear validation'
• Select the header rows and press 'Delete'
• Click 'Format' and then 'Clear validation'

How do you insert a new column in a spreadsheet?

• Right-click on a row number and choose 'Insert column'
• Click 'Insert' and select 'Insert column'
• Click 'Edit' and select 'Insert column'
• Right-click a column header and choose 'Insert 1 column'

What is a quick way to number rows in a spreadsheet?

• Manually type numbers in each row
• Use 'Copy' and 'Paste' for each number
• Drag the fill handle from the first numbered cell
• Use the 'Sort' feature

How can you adjust the date format in a spreadsheet?

• Click 'File' and select 'Change date format'
• Select the cells and click 'Format', then 'Number', and choose 'Date'
• Use 'Edit' and select 'Date format'
• Right-click and choose 'Format cells'