1 / 30

Computer Applications

Computer Applications. Common Assessment Review. Matching - Match the letter with the appropriate Excel features on the next page (#1- #3) a)Workbook b)Active worksheet c)Cell reference d)Worksheet e)Spreadsheet 1. The worksheet that is displayed in the work area.

phillipwilliams
Download Presentation

Computer Applications

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. Computer Applications Common Assessment Review

  2. Matching - Match the letter with the appropriate Excel • features on the next page (#1- #3) • a)Workbook • b)Active worksheet • c)Cell reference • d)Worksheet • e)Spreadsheet • 1. The worksheet that is displayed in the work area. • 2. The file used to store worksheets. • 3. A grid of rows and columns in which you enter text, numbers, and the results of calculations.

  3. 4. ________________ of the worksheet appear vertically and are identified by letters at the top of the worksheet window. • columns • rows • cells • headings

  4. True/False 5. You use Excel to prepare a presentation that includes slides. False

  5. True/False 6. The Save As command saves an existing Excel workbook on a disk, flash drive, etc. using its current name and save location. False

  6. To use the Replace command, in the _______ group on the Home tab of the Ribbon, click on the Find & Select button, and then click Replace. • data • editing • formulas • proofing

  7. Case Scenario (for #8 ONLY) • Adrian is starting to use the keyboard to navigate around an Excel spreadsheet. • To move down one window, Adrian • presses the _____________________. • a) CTRL + HOME key • b) CTRL + END key • c) PAGE UP key • d) PAGE DOWN key

  8. 9. You can change the active worksheet in a workbook to next worksheet by pressing the _________+ PAGE DOWN. • ALT • CTRL • FN • TAB

  9. Matching -Match the letter with the appropriate Office 2010 application below • a. Word • b. Excel • c. Access • d. PowerPoint • e. Publisher • C 10. Database programs • D 11. Presentation programs • A 12. Word-Processing programs • E 13. Desktop Publishing programs • B 14. Spreadsheet programs

  10. 15. You can shrink the Ribbon to one line that shows the tab names by double-clicking any tab or clicking the ___________________ the Ribbon Button. • a. shrink c. minimize b. close d. pin

  11. 16. A dialog box is a window that opens ____________________ the program window. • a. on top of c. to the right of • b. underneath d. to the left of

  12. 17. The main screen and workspace that opens when Windows is started. • a. work area c. notification area • b. status bar d. desktop

  13. The area at the bottom of the Windows screen that contains the Start button as well as program or window buttons for open programs. • a. taskbar c. start bar • b. status bar d. menu bar

  14. To find a Web page, the Web uses an address system. The official name for this type of address is Uniform Resource ______________________. • a. location c. link • b. locator d. log

  15. 20. To use Full Screen Reading view, click the _______________tab on the Ribbon, and then in the Document Views group, click the Full Screen Reading button. a. view c. page layout b. insert d. home

  16. To exit Word, click the Close button in the ________________ corner of the document window. • a. upper-right c. upper-left • b. lower-right d. lower-left

  17. Most documents are printed in __________________ orientation. • a. landscape c. portrait • b. sideways d. upright

  18. True/False 23. Pressing the Delete key deletes the character to the left of the insertion point. False

  19. True/False 24. You can use the Zoom feature to magnify and reduce your document on the screen. True

  20. True/False 25. The text appears in the document window at the insertion point when you enter text in a new document. True

  21. True/False 26. Print Layout view displays only the text of a document without showing the arrangement of the text. False

  22. True/False 27. You can create a new folder in the Save As dialog box True

  23. True/False 28. The Quick Access Toolbar is “command central” for the Office programs. False

  24. True/False 29. The Make larger button enlarges a window to the full size of the screen. False

  25. True/False • To go to a specific Web page from an Office 2010 document, you click the Address bar in your browser, type the ISP, and then press enter. False

  26. True/False 31. In all Office programs, you open, save, and close files in the same way- Backstage View. True

  27. True/False 32. Microsoft Office 2010 is a collection of hardware programs. False

  28. True/False 33. The taskbar identifies the path for the currently open folder. False

  29. True/False 34. Each program has a different file extension, which is a series of letters office adds to the end of a file name that identifies in which program the file was created. True

More Related