Excel Lesson 7 (potential questions)

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?

Breaks

Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?

Delete

Which of the following statements describes how to increase or decrease a column's width?

Drag the boundary next to the column heading.

Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

Format

In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?

Formatting

John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?

Freeze Panes

What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?

Header & Footer

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?

Hide

Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?

Hide

Which term describes the blank portions of a page that fall outside the main body of the printed document?

Margins

In which of the following locations are check boxes that you can select to view or print gridlines?

On the Page Layout tab, in the Sheet Options group

Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?

Page Layout

Which of the following dialog boxes is used to transpose rows and columns?

Paste Special

Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?

Print Titles

Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?

Scale

__________ refers to shrinking or stretching printed output to a percentage of its actual size.

Scaling

Which command do you use to remove manual page breaks from a worksheet area?

Select Remove Page Break from the Breaks drop-down area

Which of the following statements describes how to you unhide a hidden row or column?

Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?

Sheet Options

Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?

Theme

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?

Unhide

The __________ is the line between rows or columns.

boundary

The identifying letter at the top of a column is called the _____. (hint: answer is two words)

column heading

A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.

header

__________ is the top-to-bottom measurement of a row, measured in points. (hint: answer is two words)

row height

A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.

theme