1 / 8

Excel Lesson 6 Review

Excel Lesson 6 Review. Mrs. Bowser. Identify the following. This is an example of _____________order. Abcdefghijk … Appear in the lower-right corners of the column heading cells and are used to access the AutoFilter menu for that column . ______

paxton
Download Presentation

Excel Lesson 6 Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Lesson 6 Review Mrs. Bowser

  2. Identify the following.. • This is an example of _____________order. • Abcdefghijk… • Appear in the lower-right corners of the column heading cells and are used to access the AutoFilter menu for that column. ______ • A cell in a worksheet that opens another file or page when you click it. • A digital photograph or other image file. _________

  3. 5. Highlights worksheet data by changing the look of cells that meet a specified condition. _________ • Zyxwvutsr is an example of ___________order. • ____________________ formatting highlights worksheet data by changing the look of cells that meet a specified condition.

  4. 8. A note attached to a cell that is usually used to explain or identify information contained in the cell. _____________ 9. Menu that displays a list of all the values that appear in that column along with additional criteria and color filtering options.______ 10. Provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias. _________

  5. 11. To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button. a. Search c. Proofing b. Editing d. Help 12. Enhance worksheets by providing a visual representation of information and ideas.________

  6. 13. Anything that appears on the screen that you can select and work with as a whole._______ 14. To hide more than one row, select how many rows you want to hide, and then ____ the selection to show the short-cut menu. a. right-click c. highlight b. left-click d. double-click

  7. 15. Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria. _______________ 16. True or False The Top/Bottom Rules format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average. ____________________

  8. True or False The template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting. • True or False When you sort data contained in columns of a worksheet, Excel includes the column headings.

More Related