Business Computer Applications I Final & (EDGE Credit)
Settings
Mrs. Marcum's Business Computer Applications I classes will be taking this exam for college EDGE credit. � This test, along with your performance exam, will also count as part of your final�semester grade in BCA I. � You must pass the test with a score of 75% or better for college EDGE credit. � GOOD LUCK!������� �
- 1.System software includes which of the following?
- A.
Word, Excel, and PowerPoint
- B.
Windows, MAC OS, and Linux
- C.
Both A and B
- D.
Neither A nor B
- 2.Which of the following is NOT application software?
- A.
MS Word
- B.
Spreadsheets
- C.
Windows XP
- D.
Access
- 3.Hardware would include all the following EXCEPT
- A.
Monitors
- B.
CPUs
- C.
MS Office Suite
- D.
Keyboards
- 4.Information produced by the computer program on printed paper, or by using audio or video is called
- A.
Output
- B.
Input
- C.
Storage
- D.
Processing
- 5.Which of the following would NOT be considered an input device?
- A.
Printer
- B.
Keyboard
- C.
Mouse
- D.
MIDI keyboard
- E.
Gaming devices
- 6.Which of the following would be examples of storage devices?
- A.
Flash drives
- B.
Floppy disks
- C.
CDs
- D.
Memory cards
- E.
All of the above
- 7.A group of two or more computers linked together is called a
- A.
Network
- B.
Modem
- C.
Personal computer
- D.
CPU
- 8.Ethical computer practices include _____.
- A.
Making a backup copy
- B.
Reading co-workers E-mail
- C.
Making copies of copyrighted software
- D.
None of the above
- 9.Which of the following would NOT be an operating system?
- A.
Vista
- B.
Windows XP
- C.
Linux
- D.
Internet Explorer
- E.
MAC OS
- F.
Windows 7
- 10.An example of a presentation program used to create an on-screen show is
- A.
Access
- B.
Excel
- C.
PowerPoint
- D.
Word
- 11.An example of a spreadsheet program that calculates, manipulates, and analyzes numbers is
- A.
Access
- B.
Excel
- C.
PowerPoint
- D.
Word
- 12.What would you use to create letters, envelopes, memorandums, and reports?
- A.
Access
- B.
Excel
- C.
PowerPoint
- D.
Word
- 13.What would you use to collect related data in order to make the information useful for you?
- A.
Access
- B.
Excel
- C.
PowerPoint
- D.
Word
- 14.A __________ helps locate information on the Internet. (Ex. Yahoo, Google)
- A.
Browser
- B.
LAN or WAN
- C.
Search engine
- D.
Modem
- 15.This is used to produce professional-looking documents such as flyers, brochures, newsletters, menus, and programs.
- A.
Desktop publisher
- B.
Internet Explorer
- C.
PowerPoint
- D.
Word
- 16.In Access, these are columns of individual pieces of information.
- A.
Records
- B.
Fields
- C.
Rows
- D.
Tables
- 17.This is a communications device that enables a computer to transmit data over telephone lines.
- A.
URL
- B.
HTTP
- C.
HTML
- D.
Modem
- 18.The line at the start of a letter including the greeting and the recipient's name, such as Dear Mr. Doe, is called what?
- A.
Subject Line
- B.
Complimentary Closing
- C.
Copy Notation
- D.
Salutation
- 19.All computers require an operating system.
- A.
True
- B.
False
- 20.Sorting in ascending order will go from
- A.
1 to 10
- B.
A to z
- C.
Both A and B
- D.
Neither A nor B
- 21.To remove a character to the RIGHT of the insertion point, use the
- A.
Backspace key
- B.
Escape key
- C.
Delete key
- D.
ALT key
- 22.When using a spreadsheet program, rows in a worksheet are labeled with
- A.
Gridlines
- B.
Letters
- C.
Numbers
- D.
Titles
- 23.When Excel begins in MS 2007, the entire worksheet has a default font size of 11 point, no bold, no underline, and no italic. What is the default font type called?
- A.
Arial
- B.
Times New Roman
- C.
Courier New
- D.
Calibri
- 24.In Excel, a series of two or more adjacent cells in a column or row is called a/an
- A.
Range
- B.
Column
- C.
3-D formula
- D.
IF statement
- 25.In PowerPoint, the __________ introduces the presentation to the audience.
- A.
Animation
- B.
Slide master
- C.
Transition
- D.
Title slide
- 26.A __________ is a type of malicious software that typically affects the hard drive, eventually corrupting it so the files and programs on it can no longer be used.
- A.
File transfer protocol
- B.
Cancer
- C.
Virus
- D.
Growth
- 27.In Excel, you create formulas by preceding them with
- A.
A minus sign
- B.
A plus sign
- C.
An equal sign
- D.
A parentheses
- 28.The correct mathematical order of operations for calculating formulas in a spreadsheet are
- A.
Multiplication, division, addition, subtraction, parentheses, exponent
- B.
Parentheses, exponent, multiplication, division, addition, subtraction
- C.
Parentheses, multiplication, exponent, division, addition, subtraction
- D.
Multiplication, parentheses, exponent, division, addition, subtraction
- 29.In Access, the rows in a table are called
- A.
Fields
- B.
Forms
- C.
Objects
- D.
Records
- 30.Software that combines multiple applications into one package is called
- A.
Application software
- B.
Integrated software
- C.
System software
- D.
Network software
- 31.A temporary storage place for copied text is the
- A.
Office Clipboard
- B.
Random Access Memory
- C.
Read Only Memory
- D.
Central Processing Unit
- 32.Small graphics such as circles, squares, or diamonds used to draw attention to a line of text, are known as
- A.
Thumbnails
- B.
Paragraph marks
- C.
Bullets
- D.
Web pictures
- 33.__________ is a shortcut that allows a user to jump easily to other documents, objects, or pages such as the World Wide Web.
- A.
Refresh
- B.
Hyperlink
- C.
Action buttons
- D.
Hypertext Transfer Protocol
- 34.On the ribbon, which Tab is used to place a table into a Word document?.
- A.
Home
- B.
Insert
- C.
Page Layout
- D.
Review
- 35.The PRIMARY reason to use visual aids in a PowerPoint presentation is to
- A.
Enhance the use of nonverbal communication
- B.
Present additional information
- C.
Reinforce the speaker's message
- D.
Distract from the speaker
- 36.When copying data between two open files in the same application, the SECOND step should be to
- A.
Choose the copy command
- B.
Show the document that is to receive the data
- C.
Place the insertion point and then choose the Paste command
- D.
Highlight/select the data that is to be copied
- 37.Font size is determined by measuring the height of characters in units called _____.
- A.
Points
- B.
Serifs
- C.
Inches
- D.
Cases
- 38.A block style letter _____.
- A.
Is left-aligned
- B.
Formats the date and closing lines at the center point
- C.
Has indented paragraphs
- D.
All answers are correct
- 39.The rules of Internet behavior that govern interaction on the Internet are called
- A.
Etiquette
- B.
Dear Abby
- C.
ARPANET
- D.
Netiquette
- 40.Which way(s) are correct to bold text in a document?
- A.
Ctrl B
- B.
Click the B button on the Home Tab
- C.
Font launcher arrow, font style, bold
- D.
All of the above
- 41.SUM, COUNT, MAX, and MIN are examples of __________ in a spreadsheet program.
- A.
Formulas
- B.
Functions
- C.
Queries
- D.
Values
- 42.The transmitting and receiving of data over telephone lines with the use of a modem is called
- A.
Teleprompting
- B.
Telecommunicating
- C.
Telnet
- D.
TCP/IP
- 43.When saving a document for the FIRST time, the BEST command to select from the File menu is
- A.
Save
- B.
Save as
- C.
Properties
- D.
Page setup
- 44.To view hidden formatting characters in MS Word to help you edit your text, you would click the _____ button on the toolbar.
- A.
Zoom
- B.
Print Preview
- C.
Show/Hide
- D.
Hyperlink
- 45.To set up a report in proper MLA report style format, you would _____.
- A.
Set up the document so that all text is double-spaced
- B.
Set the page margins to 1" on all sides
- C.
Type your name, instructor's name, course title, & date at the left
- D.
All of the above
- 46.To place shapes into a Word document, you would use the _____ Tab.
- A.
Page Layout
- B.
Home
- C.
Insert
- D.
Design
- 47.In MS Excel (in the Page Setup Dialog Box), you can change _____.
- A.
The orientation
- B.
The margins
- C.
The headers/footers
- D.
The gridlines
- E.
Only a, b, and c are correct
- F.
A, b, c, and d are correct
- 48.Good keyboarding techniques include all the following EXCEPT _____.
- A.
Curving fingers
- B.
Wrists flat on the desk or keyboard
- C.
Sitting up straight in your chair
- D.
Keeping eyes on copy to be typed
- 49.The two letter parts that you quadruple after are the date and the salutation.
- A.
True
- B.
False
- 50.A _____ is a formal letter written on company letterhead by an individual on a business-related subject.
- A.
Personal business letter
- B.
Business letter
- C.
Memorandum
- D.
Facsimile
- 51.A _____ is an informal note sent to one or more people, usually within a business or organization.
- A.
Personal business letter
- B.
Business letter
- C.
Memorandum
- D.
Facsimile
- 52.What are the differences between a business letter format and a personal business letter format?
- A.
Reference notation, complimentary closing
- B.
Reference notation, return address
- C.
Return address, date
- D.
Return address, salutation
- 53.Use the spacebar once after a period ending a sentence when it is followed by another sentence in a paragraph.
- A.
True
- B.
False
- 54.The _____ command enables you to look at the document as it will appear when printed.
- A.
Page Setup
- B.
Page Layout
- C.
Print Preview
- D.
View
Back to top