M8: Quiz (SUM)

Select two formatting options that can be done to one cell in Excel. *Select two.

• Bold font

• Centered aligned text

• Alpha sort

A relative cell reference does NOT change when copied to another cell.

• True

• False

Which function would you use to add the values of five cells together?

• Sum

• Average

• Hyperlink

• Max

________________ is the toolbar with icons provided across the top of your screen to provide easy access and editing options.

• Quick Access Toolbar

• Title Bar

• Formula Bar

• Scroll Bar

Text wrapping in an Excel spreadsheet cell means the text will stay on one line in the cell.

• True

• False

_________ is the cell in which the cursor is placed. It normally displays a colored border when selected.

• Active Cell

• Name Box

• Title Bar

• Rows

The place where the column and row intersect is called a _________________.

• Cell

• Sort

• Worksheet

• Graph

When creating a formula using multiplication, you must use an asterisk (*) for the multiplication symbol, NOT an x.

• True

• False

_______ is represented by numbers and is horizontal on the Excel spreadsheet.

• Row

• Column

• Sheet

• Tab

_____________ is represented by letters and is vertical on the Excel spreadsheet.

• Column

• Row

• Tab

• Sheet