Exam 1: Getting Started With Excel

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

A(n)____________________ is a grouping of text and numbers in a rectangular grid or table.

To go to column A of the current row,press ____.

Normal view shows how the worksheet will appear when printed._________________________

____ makes it easier to enter repetitive text in cells.

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Every function follows a set of rules,or syntax,which specifies how the function should be written._________________________

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window._________________________  

Identify the letter of the choice that best matches the phrase or definition. -A named operation that replaces the arithmetic expression in a formula

An Excel worksheet can have a maximum of ____ columns in a worksheet.

When you ____________________ a workbook,a dialog box might open,asking whether you want to save the workbook.

____ displays the location of the different page breaks within the worksheet.

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Cutting moves the selected content,whereas copying duplicates the selected content._________________________

A common business practice is to include a worksheet named Documentation that contains a description of the workbook,the name of the person who prepared the workbook,and the date it was created._________________________

The worksheet is organized into individual cells._________________________  

To move or copy a range of cells,select the correct order:?1.Move the pointer over the border of the selection until the pointer changes shape.?2.Select the cell or range you want to move or copy.?3.To move the range,click the border and drag the selection to a new location,or to copy the range,hold down the Ctrl key and drag the selection to a new location.

Which of the following will not change the location of the active cell?