| A | B |
|---|
| These buttons on the toolbar are identified by an icon of the letters “AZ” and an up or down arrow. | Sorting |
| To insert a picture from the Microsoft Clip Gallery, select Picture on this menu and then select Clip Art from the submenu. | Insert |
| These may be resized to fit within a specific area of the worksheet. | Pictures |
| This toolbar is used to create lines and objects in a worksheet. | Drawing |
| A spreadsheet may be saved in this format to view on the Web. | HTML |
| The Drawing button is on this toolbar. | Standard |
| Excel can open these that are created in other programs, such as Lotus 1-2-3. | Spreadsheets |
| You may insert these into a worksheet to access sites on the Web. | Hyperlinks |
| To sort in this order is to sort in alphabetically from Z to A and with numbers from highest to lowest. | Descending |
| These are files that automate tasks by creating a worksheet format that may be used more than once. | Templates |
| Excel can sort informations in these ways: | Alphabetically, ascending numeric and descending numeric |
| To prevent Excel from including the column headings in the sort, select this button in the Sort dialog box. | Header row |
| To move a picture, you must: | Drag it to the desired position |
| This action temporarily removes a row or column from the workbook screen. | Hiding |
| This operation displays a subset of the data in a worksheet that meet certain criteria. | AutoFilter |
| To refer a worksheet user to a data source on the Internet, you are most likely to perform one of these. | Insert a hyperlink |
| This worksheet operation is used to display the 10 largest items in a worksheet column. | AutoFilter |
| The Drawing toolbar usually appears near this part of the screen. | Bottom |
