Exam 12: Creating a Worksheet

To delete an existing worksheet right-click anywhere within the worksheet and click Delete.

The ____________________ cell is the cell you can currently edit or modify.

To edit a label after the Enter key has been pressed, you should first click the cell, then click in the _____, type your correction, then press the Enter key to complete your entry.

After you select a function, you have to specify the _____.

Excel includes more than _____ functions from which you can choose.

Delete an existing worksheet by right-clicking the worksheet's tab and clicking _____.

In addition to writing your own formulas, you can use predefined formulas called _____.

Excel worksheets are saved in a(n) _____-dimensional workbook

A formula that references the cell in which the formula resides is called a _____.

Which of the following functions calculates the total of a column or row of cells?

The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab.

After you click a cell for a formula, a rectangle of _____ called a marquee appears around that cell.

Which of the following is a New sheet button?

To edit a label after you've pressed the Enter key, click the cell, then click in the ____________________ bar.

Formulas cannot include more than two functions.

Excel treats all cells as _____ references, by default.

Any text entered into a cell of the worksheet is called a(n) _____.

Case-Based Critical Thinking Questions Case 12-1 Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions. Ethan starts by saying that a worksheet will always consist of _____.

The Function Arguments dialog box contains a link, _____, that you should click to get help with the arguments.

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When it is copied and pasted into cell C8, why do the hash marks appear?