Exam 17: Getting Started With Excel Essentials

Case 17-1 Kristin is new to spreadsheets. She was asked to create a worksheet for her business club's fundraiser. Kristin is entering data in cells. Why does she see ### in some of the cells?

A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.

Computer software engineer is one of the fastest growing occupations.

FIGURE 17-1 The arrows in Figure 17-1 above are pointing to ____.

When you select a group of cells, the group is called a(n) ____________________.

Case 17-2 Lino is creating a project schedule for the construction company where he works. He needs to list the tasks that need to be completed each day and show which employees will complete the work. What should Lino click to select an entire column so that he can change its formatting?

Case 17-1 Kristin is new to spreadsheets. She was asked to create a worksheet for her business club's fundraiser. Kristin wants to insert three new columns. What should she do before executing the Insert Sheet Columns command?

You can only have one Excel workbook open at a time.

When using the AutoComplete feature, you can press ____ to accept a proposed entry.

All cells in a range touch each other and form a rectangle.

When a cell is selected, it is called the ____.

A1:D4 is an example of a ____.

What are the advantages of an electronic spreadsheet over a paper spreadsheet? Do you think it would be helpful to use a pencil and paper to plan an electronic spreadsheet? List at least two reasons why or why not.

The Ribbon, tabs, and command groups are part of the ____.

All cells in a range touch each other and form a triangle .

Case 17-2 Lino is creating a project schedule for the construction company where he works. He needs to list the tasks that need to be completed each day and show which employees will complete the work. Which feature can Lino use to quickly fill in a series of dates?

Usually the top row of a worksheet is used for explanatory text or column headings that identify the type of data in each column.

The Undo and Redo commands are available on the ____.

The row heading is the letter at the left of the row.

Where are the sizing buttons that control the application and worksheet windows?