Excel Knowledge Flashcard

Front

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

Back

Show

Front

What does Joan's First Name in cell B2 represent in the table?

Back

Entry

Front

In Sharon’s spreadsheet, what does ‘25’ identify in the address F25?

Back

row.

Front

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

Back

AutoFit

Front

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

Back

Fill Series

Front

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?

Back

Fill handle

Front

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

Back

Template

Front

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

Back

Print Area

Front

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

Back

Print Active Sheet

Front

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?

Back

=SUM(B1:B39)