Excel Lesson 7 Knowledge Assessment

How do you increase or decrease a column’s width? 

• Right-click anywhere in the column and select Format Cells.
• Use the Page Setup dialog box.
• Drag the boundary next to the column heading.
• Select a Width setting in the Scale to Fit group on the PAGE LAYOUT tab.

What must you do before formatting an entire row or column?

• Click the row heading or column heading to select it.
• Open Print Preview.
• Go into Page Layout view.
• Select a cell range.

Which dialog box do you use to transpose rows and columns?

• page setup
• paste special
• column width
• row height

Which of the following can you not modify when customizing a document theme? 

• colors
• fonts
• effects
• page orientation

Where are check boxes you can select to view or print gridlines? 

• In Print Preview
• On the HOME tab, in the Cells group
• On the PAGE LAYOUT tab, in the Sheet Options group
• On the PAGE LAYOUT tab, in the Page Setup group

Which Excel feature or view lets you drag automatic page breaks, converting them to manual page breaks, to achieve a more desirable printed document?

• print preview
• page break preview
• page layout view
• normal view

You want to repeat column A on every page when printing a multiple-page worksheet. Which feature do you use?

• print titles
• page break preview
• a header custom margins

What is not a predefined margin setting? 

• normal 
• large 
• narrow
• wide

How do you unhide a hidden row or column?  

• Select a range of cells in the row or column, right-click, and select Unhide. 
• Use the Page Setup dialog box.
• Remove all page breaks.
• Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

Your worksheet is a little too wide to print on one page. Which feature can you use to force all data to print on one page?

• a page break
• the Wide margin setting
• Scale to fit
• Commands in the Sheet Options group on the PAGE LAYOUT tab