Excel Quiz

What does the Format Painter tool do in Excel?

• It changes the color of the text.

• It copies the format from one cell and applies it to another.

• It deletes the content in the cell.

• It creates a chart.

How do you print a worksheet in Excel?

• Click on "File" and then choose "Print."

• Press the "Delete" button.

• Right-click on the worksheet and select "Format Cells."

• Click "Home" and select "Format Painter."

Where can you find workbook properties like title and category?

• On the "Home" tab.

• In the "File" tab under "Info."

• In the "View" tab under "Show."

• By right-clicking on the worksheet.

How do you set a print area in Excel?

• Go to the "File" tab and click "Print."

• Select the area you want to print, then go to the "Page Layout" tab and click "Set Print Area."

• Click "Insert" and select "Print."

• Right-click and select "Save As."

How do you change the margins to "Wide" in Excel?

• Go to the "View" tab and click "Wide."

• Go to the "Page Layout" tab, click "Margins," and select "Wide."

• Click "Insert" and then select "Margins."

• Go to the "Home" tab and select "Margins."

How can you add the file name or sheet tab name in the header or footer?

• Go to the "Insert" tab, then click "Header & Footer" and add the file name or sheet name.

• Right-click on the worksheet and select "Insert File Name."

• Go to the "Home" tab and click "Header."

• Press "Ctrl + P" to print the file name.

How do you repeat row and column headings on every printed page?

• Go to the "Page Layout" tab, click "Print Titles," and select the rows or columns to repeat.

• Right-click the cell and choose "Repeat."

• Click "Home" and select "Repeat Titles."

• Go to the "Insert" tab and click "Repeat Rows."

What is the purpose of Data Validation in Excel?

• To change the font color.

• To allow only certain types of data in a cell, like numbers or dates.

• To copy a cell to another location.

• To format a cell with borders.

How do you set up Data Validation in Excel?

• Go to the "Home" tab and click "Data Validation."

• Go to the "Data" tab, click "Data Validation," and set the criteria you want.

• Right-click the cell and select "Validate."

• Go to the "Insert" tab and choose "Validation."

What happens when you protect a sheet in Excel?

• You cannot save the worksheet.

• Certain cells or the entire sheet are locked so others can’t change them without a password.

• The worksheet is deleted.

• You can’t open the workbook again.