Bim

1. Bim • Spring Final Review 2014

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

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. • A range is identified by cell references separated by a __. • The contents of a cell can be seen in the cell and in the _____ _____.

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

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

6. A cell is the intersection of a column and a row. • Use the fill handle to “Squeeze” the worksheet down to one page. • A group of adjacent cells in a worksheet is called a matrix.

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? • You cannot move, size, and/or delete placeholders, you must choose a different slide layout to change the placeholders? • Which of these can you add to a PowerPoint slide? • clip art • chart • audio • video

11. PowerPoint is what type of software? • Which key on the keyboard will end a slide show? • 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. • In a PowerPoint placeholder, text can be aligned vertically and horizontally.

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

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

15. Transitions are the way that each new slide appears on the screen during a presentation. • PowerPoint is what type of software? • Slides cannot be copied once they are created. • 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. • Access gives no warning when deleting a record. • Similar to Excel, double-clicking the right column border of a field while in Datasheet View will auto-size (best-fit) the column. • An Access query is an object designed to extract data from a table or query based on given conditions.

17. Access automatically saves each record as you are entering information. • The field in a table that makes each record unique is referred to as the primary key. • 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. • 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.

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. • Deleting a record is no big deal. You can always just undo the deletion • Templates are preformatted items used for special purposes in Microsoft Office.