Excel Formatting and Page Setup

What is the first step to remove page breaks in Excel?

• Click on the Home tab

• Go to the View tab

• Click File and then Options

• Select the Insert tab

Which method allows you to adjust row height precisely?

• Dragging the row border

• Using the Format option

• Double-clicking the row number

• Typing in the formula bar

Which option allows you to set an exact column width?

• Typing in the formula bar

• Double-clicking the column header

• Using the Format drop-down menu

• Dragging the column border

How can you auto-fit all column widths at once?

• Select each column individually

• Double-click the right edge of any column with the entire worksheet selected

• Use the Format drop-down menu

• Manually adjust each column

What is the purpose of headers and footers in Excel?

• To add extra rows and columns

• To adjust the font size

• To display additional information in print preview

• To change the background color

What is the shortcut for auto-fitting rows?

• Type in the formula bar

• Use the Format drop-down menu

• Double-click the bottom edge of any row with the sheet selected

• Drag the row border

Which tab do you use to start adding a header in Excel?

• Home

• Data

• Insert

• Page Layout

What should you do to set the page margins to wide?

• Use the View tab

• Click on the Insert tab

• Select the Margins dropdown in the Page Layout tab

• Go to the Home tab

How do you add the current date to the left side of the footer?

• Use the date icon in the Custom Footer option

• Select the Insert tab

• Use the Home tab

• Type it manually

What is the final step to complete the lab exercise?

• Click Finish twice

• Click Next once

• Click OK three times

• Click Cancel