(1) .create the worksheet as shown
(2) . filter filter the data according to the pay rate
Answers
Explanation:
When you click “Blank workbook,” Excel closes the welcome page and opens a new, blank worksheet, as shown in Figure 1-2. A worksheet is a grid of cells where you type in information and formulas. This grid takes up most of the Excel window. It’s where you’ll perform all your work, such as entering data, writing formulas, and reviewing the results.
The largest part of the Excel window is the worksheet grid, where you type in your information.
Figure 1-2. The largest part of the Excel window is the worksheet grid, where you type in your information.
Here are a few basics about Excel’s grid:
The grid divides your worksheet into rows and columns. Excel names columns using letters (A, B, C…), and labels rows using numbers (1, 2, 3…).
The smallest unit in your worksheet is the cell. Excel uniquely identifies each cell by column letter and row number. For example, C6 is the address of a cell in column C (the third column) and row 6 (the sixth row). Figure 1-3 shows this cell, which looks like a rectangular box. Incidentally, an Excel cell can hold approximately 32,000 characters.
A worksheet can span an eye-popping 16,000 columns and 1 million rows. In the unlikely case that you want to go beyond those limits—say, if you’re tracking blades of grass on the White House lawn—you’ll need to create a new worksheet. Every spreadsheet file can hold a virtually unlimited number of worksheets, as you’ll learn in Chapter 4.
When you enter information, enter it one cell at a time. However, you don’t have to follow any set order. For example, you can start by typing information into cell A40 without worrying about filling any data in the cells that appear in the earlier rows.