Bim

1. Bim • Spring Final Review 2013

2. True/false, multiple choice, fill in the blank • In Excel, a single spreadsheet is called a __________. • worksheet • Excel aligns numbers to the _____. • Right • Excel is what type of software? • Spreadsheet • __________ appear horizontally and are identified by numbers. • Rows

3. If you change the contents of a cell that is included in a formula, the resulting values from that formula will automatically be recalculated. True • A range is identified by cell references separated by a __. : (colon) • The contents of a cell can be seen in the cell and in the _____ _____. Formula Bar

4. _____ appear vertically and are identified by letters. • Columns • A cell reference is made up of the cell’s ___ ___ and ___ ___. • Column Letter and Row Number

5. _____ _____ shows what a cell would look like if you made a formatting change. • Live Preview • To center cell contents across several columns, click the ___ ___ button. • Merge & Center • In Excel worksheets, rows are designated using letters. False, rows - numbers & columns - letters

6. A cell is the intersection of a column and a row. True • Use the fill handle to “Squeeze” the worksheet down to one page. False, copy a formula or extend a series • A group of adjacent cells in a worksheet is called a matrix. False, range

7. The AutoComplete feature in Excel does which of the following? • completes formulas for you as you type • fills in adjacent cells with the same or incremental values • automatically formats the worksheet from a list of choices • completes text entries if the first few letters match another entry in the column

8. All formulas in an Excel worksheet must begin with this symbol. • $ • + • = • @

9. A group of worksheets in the same file is called a • workset • workbook • workgroup • workfile • What is the first step that should be taken when creating a chart? • provide a name for the chart • select the chart type • select the range of cells that contain the data the chart will use • choose the data labels that will be used on the chart

10. When you click in a cell it becomes the active cell? True • You cannot move, size, and/or delete placeholders, you must choose a different slide layout to change the placeholders? False • Which of these can you add to a PowerPoint slide? • clip art • chart • audio • video

11. PowerPoint is what type of software? Presentation • Which key on the keyboard will end a slide show? Esc • Clicking the New Slide button will insert a new slide where? • at the beginning of the slide show • at the end of the slide show • after the selected slide • before the selected slide

12. In the Slides/Outline pane, with the Slides tab selected, how are individual slides displayed? • as text only, no graphics • as graphics only, no text • as thumbnails • no slides are visible • Slide transitions must be the same for each slide in a PowerPoint presentation. False • In a PowerPoint placeholder, text can be aligned vertically and horizontally. True

13. PowerPoint always aligns text to the left and you cannot change it. False • Clicking the left mouse button, pressing the Enter key or pressing the right arrow button will advance a slide show to the next slide. True • Which program opens beside PowerPoint when inserting a chart? • Outlook • Word • Publisher • Excel

14. Use Slide Sorter view to rearrange slides. True • _____ are effects that make objects move during a slide show. • Live preview • Transitions • Animations • Hyperlinks • The order of Animations cannot be changed. False

15. Transitions are the way that each new slide appears on the screen during a presentation. True • PowerPoint is what type of software? Presentation • Slides cannot be copied once they are created. False • In Access, each field is represented by one ____. • file • datasheet • row • column

16. Fields can be moved in an Access table by simply dragging them to a new position. True • Access gives no warning when deleting a record. False • Similar to Excel, double-clicking the right column border of a field while in Datasheet View will auto-size (best-fit) the column. True • An Access query is an object designed to extract data from a table or query based on given conditions. True

17. Access automatically saves each record as you are entering information. True • The field in a table that makes each record unique is referred to as the primary key. True • Each record in a table is represented by one _____. • row • column • datasheet • file

18. Each database must contain at least one one _____. • module • query • report • table • Conditions added to a field’s Criteria box in a query design will cause Access to display only those records that meet the given requirements. True • If you have a database containing the information about the members of a health club, then the members’ last names would be an example of a field. True

19. All of the information about one person in the State of Texas Driver License database is a _____. • field • file • table • record • Once you enter data into a record, you cannot go back change the data. False • Deleting a record is no big deal. You can always just undo the deletion False • Templates are preformatted items used for special purposes in Microsoft Office. True

20. 53. A report __________ can be used when the same information needs to be displayed month after month, such as a monthly sales report, using a file that contains the basic elements of the document: page and paragraph formatting, fonts and text.a) Page Layoutb) Stylec) Linkd) Template