BCAP 106 – FINAL EXAM

Student Name: __________________________________ Date:_________________________
EXERCISE 1 – MS Excel
40 Points

You work at a small Orthopedics clinic as a Medical Assistant. Your manager wants you to take a day to do inventory of all medical supplies in the office. She would like to know the profit potential for their inventory based on the categories of inventory in Table 1. Table 1 contains the format of the desired report. The required formulas are shown in Table 2. Please create the table using MS Excel and incorporate the formulas requested in Table 1.
Save the files as: “Your Name – Final Exam Exercise 1”

Table 2 | | | FORMULAS | Formula A = Units on Hand * Average Unit Cost | Formula B = Average Unit Cost * (1 / (1-.58)) | Formula C = Units on Hand * Average Unit Price | Formula D = Total Value - Total Cost | Formula E = "SUM" of required cells | Formula F = AVERAGE function | Formula G = MIN function | Formula H = MAX function |

EXERCISE 2 – MS Excel
20 Points

Open the “Final Exam – Exercise 2” file. Bold, Center, Underline, and add color to the Headings in this document. Expand the cells so all of the information can be seen. Add Borders around all the cells containing information. Filter the data. Place all information in alphabetical order by Last Name.
Save the file as “Your Name – Final Exam Exercise 2”.
EXERCISE 3 – Test Questions
40 Points
1. The view in which all of the slides in your presentation display in a miniature is: ________
A. Themes B. Slide Sorter View
C. Edit View D. Reading View
2. The charts embedded in a cell that give a visual trend summary alongside your data is: ________
A. Embedded Charts B. Sparklines
C. Chart Styles D. Grids
3. When typing reaches the right border of a cell in a table, wordwrap ________
A. Doesn’t work within a Microsoft Word table.
B. Moves the text to the next available cell to the right.
C. Moves the text to the next line with the same cell.
D. Moves the text to the next cell below in the same column.
4. The process of displaying only a portion of the data based on matching a specific value to show _______A only the data that meets the criteria that you specify is called:
A. Filtering B. Sorting
C. Scaling D. Valuing
5. The SmartArt type that show steps in a process or timeline is: ________
A. Cycle B. Process
C. Radial D. List
6. The green wavy line under text indicates a potential: ________
A. Word usage error B. Spelling error
C. Formatting error D. Grammar error
7. On startup, Excel displays a new blank: ________
A. Workbook B. Document
C. Grid D. Page
8. When you point to an image in the Clip Art pane, the screen element that displays the keyword ________ and information about the size of the image is the:
A. Screen tip B. Navigation bar
C. Gallery D. Menu
9. The action of pulling out a pie slice from a pie chart is called: ________
A. Extract B. Plot
C. Pull D. Explode
10. Which key is used to move from cell to cell in a Word table? ________
A. Enter B. Spacebar
C. Backspace D. Tab
11. A large image of the active slide is displayed in the: ________
A. Notes pane B. Outline pane
C. Slide pane D. Thumbnails
12. Which of the following is the default line spacing in Microsoft Word 2010? ________
A. 1.25 B. 1.15
C. 2.0 D. 1.0
13. A cell surrounded by a black border and ready to receive data is the: ________
A. Reference cell B. Address cell
C. Active cell D. Bottom cell
14. The process of modifying a presentation by adding and deleting slides or by changing the ________ contents of individual slides is referred to as:
A. Aligning B. Changing
C. Editing D. Formatting
15. A chart type that displays trends over time is a: ________
A. Line chart B. Pie chart
C. Column chart D. Trend chart
16. The end a line before the normal end of the line, without creating a new paragraph, hold down ________ the SHIFT key while pressing the:
A. ENTER key B. CTRL key
C. ALT key D. TAB key
17. These are printouts that show the slide image on the top of the page and the notes that have been ________ created on the bottom of the page:
A. Slide handouts B. Notes pages
C. Slide transitions D. Slide panes
18. A gallery of text styles with which you can create decorative effects, such as shadowed or ________ mirrored text is:
A. Gallery art B. Text fill
C. Shape effects D. WordArt
19. To locate specific text in a document quickly, use the: ________
A. Find command B. Replace command
C. Locate command D. Found command
20. Lines, arrows, callouts, and banners are examples of: ________
A. Shapes B. Artistic effects
C. Picture styles D. Font styles