Final Exam Review

1
Final Exam Review

• Information Processing

2

• Correct!!

3

• Incorrect try again

4

• All MLA reports margins are set at
• 2 inch
• 1 inch
• 1.5 inch
• ½ inch

5

• To save and give a name to a file, use
• save
• save as
• delete
• none of these

6

• You might use mail merge to
• simplify your taxes
• create a demonstration
• mail letters to colleges
• pay your dentist

7

• Microsoft Word allows you to put borders
• around blocks of text
• around textboxes
• around whole pages
• all of the above

8

• On your keyboard, you press this button to remove
  a letter immediately to the left of where your
  cursor is blinking.
• delete
• backspace
• shift
• alt

9

• The inside address is the person who
• sends the letter
• types the letter
• receives the letter
• none of the above

10

• The fill handle in an Excel worksheet
• is located on the bottom right hand corner of a
  cell
• can copy formulas
• can copy values
• all of the above

11

• In Excel, the columns are identified by
• numbers
• symbols
• names
• letters

12

• Quadruple space after which two letter
  components
• return address complimentary closing
• inside address body
• dateline complimentary closing
• dateline signature (or typed name)

13

• When entering data into a table in Access we use
  the __?__ view.
• datasheet view
• normal view
• print view
• design view

14

• A __?__ indents everything except the first line
  of a paragraph.
• hanging indent
• first line indent
• left indent
• right indent

15

• Before printing, from any software application,
  you should
• preview
• proofread
• save the file
• all of these

16

• When you print you can turn the paper sideways
  (11 X 8 ½) by selecting
• sideways
• portrait
• landscape
• legal

17

• Which parts of the Full Block letter are
  formatted by aligning them to the center most
  part of the document?
• inside address, dateline, closing and the
  writers name
• return address, dateline, salutation and the
  closing
• return address, dateline, inside address and the
  closing
• none of these

18

• What function will find the average of cell range
  A1 through A5?
• avg(A5-A1)
• average(A1A5)
• average(A1A5)
• (A1A5)/4

19

• All formulas in Excel start with a(n) ___?___
  sign.
• -

20

• The spacing of a MLA paper is
• single space
• 1.5 space
• double space
• none of these

21

• Numbers in a Word table are aligned to the
• left
• right
• center
• justified

22

• What would be the most appropriate data type for
  a phone number or social security number? (Note
  neither require calculations)
• text
• number
• memo
• currency

23

• In Excel, the rows are identified by
• numbers
• symbols
• names
• letters

24

• In Excel, to add numbers quickly use the
• Average function
• AutoSum function
• Min function
• None of these

25

• Every Access record must have a field with a
  unique value for each record. This is called the
  __?__.
• primary key field
• unique key field
• unique record field
• record field

26

• The BEST software to compare and analyze data is
• Microsoft Office
• Microsoft Excel
• Microsoft Word
• Microsoft Publisher

27

• On your keyboard, you press this button to remove
  a letter immediately to the left of where your
  cursor is blinking.
• delete
• backspace
• shift
• alt

28

• The BEST software to create and format a letter
  is
• Microsoft Office
• Microsoft Excel
• Microsoft Word
• Microsoft Publisher

29

• An example of an Excel function is
• B4G7
• B4G7
• sum(B4B17)
• B4B17

30

• Microsoft Excel is a ___?___ program.
• word processing
• spreadsheet
• database
• presentation

31

• In Excel, A3 represents
• a row
• a column
• a range of cells
• a cell

32

• The parts of a personal business letter start
  with
• dateline, inside address, salutation
• return address, dateline, inside address,
  salutation
• inside address, dateline, attention line,
  salutation
• dateline, return address, inside address,
  salutation

33

• Microsoft Access is a ___?___ program.
• word processing
• database
• spreadsheet
• presentation

34

• The four parts of a memo heading are
• Title, Body, Closing, Signature
• To, From, Date, Closing
• To, From, Date, Subject
• To, From, Date, Signature

35

• The four commonly used objects of Access are
• table, query, internet, access
• table, query, form, view
• table, query, internet, view
• table, query, form, report

36

• To change the placement of an image that has been
  inserted within a Word document, go to
• File, Page Setup
• Edit, Picture
• From the Format Picture dialog box, select the
  SIZING tab
• From the Format Picture dialog box, select the
  LAYOUT tab

37

• Custom animation effects are
• how your slides appear and disappear
• commercials integrated into a slide
• how an item appears or disappears from the slide
• clipart in motion

38

• Of the following proofreaders marks, this is the
  one that signals to start a new paragraph.
• A.
• B.
• C.
• D.

39

• What four items should be within the heading of
  your MLA paper?
• Name, Teachers Name, Class, Date
• Name, Teachers Name, Class, Subject
• Name, Assignment, Class, Date
• To, From, Date, Subject

40

• What is a simple formula that would multiply B4
  and D4?
• B4 X D4
• product(B4D4)
• B4 D4
• B4D4

41

• When creating a PowerPoint presentation, the
  first slide is known as the
• temporary slide
• notes slide
• title slide
• master slide

42

• A memo is correspondence
• within a business or organization
• business to business
• person to business
• none of these

43

• What is the acceptable way to write the date in a
  letter?
• December 1, 2011
• Dec. 1, 2011
• 12/1/11
• 12-1-2011

44

• Which letter style has all parts aligned at the
  left margin?
• modified block
• simplified block
• full block
• business block

45

• Of the following proofreaders marks, this is
  the one that signals you to delete information.
• A.
• B.
• C.
• D.

46

• In Access, if you want to store a lot of text
  within a field use the following data type
• text
• memo
• report
• number

47

• To find the highest number in a range of cells,
  which function would you use?
• min
• max
• high
• average

48

• In Excel, the intersection of a column and a row
  is called a
• box
• place
• square
• cell

49

• How do you select columns that are not next to
  each other in Excel?
• select first column, hold SHIFT and select second
  column
• select first column, hold CRTL and select second
  column
• select first column, hold ALT and select second
  column
• none of these

50

• The header of a MLA paper should be right aligned
  and contain
• your last name and page number
• last name and first name
• last name and subject
• last name and date

51

• Printers, keyboards, and monitors are all
• computers
• software
• programs
• hardware

52

• To a PowerPoint presentation you can add
• pictures
• sound
• animation
• all of these

53

• In Access, which object allows us to find answers
  about a database such as which customers live in
  a particular state?
• table
• query
• form
• macro

54

• An example of a simple formula that uses an
  absolute cell reference is
• B4G7
• B4G7
• sum(B4B17)
• average(B4B17)