Excel Knowledge Quiz

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?

• Workbook views

• Show

• Zoom

• Window

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

• Entry

• Workbook

• Row

• Column

Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:

• cell.

• column.

• range.

• row.

In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?

• Smart Fit

• AutoFit

• Best Fit

• True Fit

Which command on the Fill options dialog box is the default option if a month or day is entered?

• Copy Cells

• Fill Formatting Only

• Fill without Formatting

• Fill Series

What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?

• Fill handle

• Filler

• Copy handle

• Copy box

Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?

• Form

• Boilerplate

• Smart Sheet

• Template

Jim would like to print only the cell range A1:F20. What page setup option should he change?

• Orientation

• Page Break

• Print Area

• Print Titles

Steve would like to print only the worksheet he is currently working on. What print option should he choose?

• Print Active Sheet

• Print Entire Workbook

• Print Selection

• Print Custom Range

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?

• =$B$1+25

• =B1+25

• =SUM(B1:B39)

• =B1:B39