Microsoft EXCEL - Lesson 1 - Knowledge Assessment

An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?

• An additional Workbook

• An additional part of the current range

• A dialog box or task pane

• A list of worksheets

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

• Page Layout

• Print Layout

• Synchronous Scrolling

• ScreenTips

When you split a window, the window is divided into how many panes?

• Two

• Three

• Four

• Two or Four

Which of the following is the intersection of a row and column?

• Bar chart

• Cell

• Range

• Tab

Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently?

• A worksheet

• The Help window

• The Quick Access Toolbar

• The Ribbon

How many worksheets does a new Excel 2016 workbook open with?

• One

• Two

• Three

• Four

The Quick Access Toolbar appears on the right side of the title bar, above the ribbon.

• True

• False

The columns in a worksheet are identified by numbers.

• True

• False

The active cell in a worksheet is outlined by a bold rectangle.

• True

• False

Page Layout view is useful when preparing your data for printing.

• True

• False