1 / 12

Excel Test Study Guide

Browning 2014. Excel Test Study Guide. Question #1. A specific location on a storage medium is called a folder. In a computer, a folder is a virtual container in which groups of files and other directories can be organized and stored .

fineen
Télécharger la présentation

Excel Test Study Guide

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. Browning 2014 Excel Test Study Guide

  2. Question #1 • A specific location on a storage medium is called a folder. In a computer, a folder is a virtual container in which groups of files and other directories can be organized and stored. • The terms folder and file cabinet were used by programmers to provide some relevancy to a traditional office file cabinet. • On a computer, the files are kept organized by storing files that are related to each other in the same directory. When a directory is inside another directory, it is called a sub-directory.

  3. Question #2 • A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets. • The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel. • So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.

  4. Question #3 • Fill data automatically in worksheet cells • Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells. This article does not explain how to enter data manually or enter data simultaneously on multiple worksheets.

  5. Question #4 • The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number. But the accounting format has a few differences that make it easier to do accounting, such as showing zero values as dashes, aligning all the currency symbols and decimal places, and displaying negative amounts in parentheses.

  6. Question #5 • The Name Box in Excel can be used to quickly navigate to different cells in a spreadsheet. The Name Box in Excel can be used to quickly navigate to different cells in a spreadsheet. 

  7. Question #6 • Worksheets • Charts • Tables are all major parts of Excel 2010

  8. Question #7 • Excel automatically positions text left aligned in a cell.

  9. Question #8 • Ribbon commands include tabs, text boxes, checkboxes, and galleries.

  10. Question #9 • Quick access toolbar, ribbon, office buttons are all the Excel components that can be used to make your work more efficient worksheets more professional!

  11. Question #10 • Basic unit of a worksheet into which you enter data is called cell.

  12. Join Remind 101 • To join please text to (864) 416-7506a • Enter the code message for our class is : @ibaper

More Related