Excel Unit 3 Quiz

What is the function of the AutoFit option in Excel 2019?

• Eliminates empty space by matching column width to its longest entry

• Deletes empty cells

• Inserts new rows

• Changes font size

What is the purpose of the Themes button in Excel 2019?

• To apply a theme to a workbook

• To insert a new worksheet

• To delete a worksheet

• To rename a worksheet

How can you copy a worksheet in Excel 2019?

• Press the Control key as you drag and drop the sheet tab

• Right-click and select "Copy"

• Press Ctrl + C

• Go to Edit > Copy

How can you auto fit the column or row to the contents of a cell in Excel 2019?

• Double-click the right border of a column or the bottom border of a row heading

• Press Ctrl + F

• Right-click and select "AutoFit"

• Go to File > AutoFit

How can you specify the height or width of a row or column in Excel 2019?

• By choosing the row height or column width options and entering a value

• By pressing Ctrl + H

• By right-clicking and selecting "Size"

• By going to File > Properties

What is the purpose of color-coding worksheet tabs in Excel 2019?

• To organize and differentiate worksheets

• To delete worksheets

• To insert new worksheets

• To rename worksheets

Where do you find the option to add headers and footers in Excel 2019?

• Insert tab in the Text group.

• Home tab in the Cells group.

• View tab in the Workbook group.

• Data tab in the Sort & Filter group.

How do you switch to Page Layout view in Excel 2019?

• Click on the Insert tab and then the Header and Footer button.

• Click on the View tab and then the Page Layout button.

• Click on the Home tab and then the Page Layout button.

• Click on the Data tab and then the Page Layout button.

Which button do you click to change the margins of a worksheet in Excel 2019?

• Orientation

• Print Titles

• Margins

• Breaks

How can you set the page orientation for a worksheet in Excel 2019?

• Click the Margins button

• Click the Orientation button

• Click the Print Titles button

• Click the Breaks button