TEST BANK YOUR OFFICE MICROSOFT OFFICE 2013 1ST EDITION VOLUME 1 BY AMY KINSER

TEST BANK YOUR OFFICE MICROSOFT OFFICE 2013 1ST EDITION VOLUME 1 BY AMY KINSER

Your Office: Microsoft Office 2013, Volume 1 (Kinser et al.)

Integrated Projects Workshop 2

1) Both Access and Excel can be used to ________ data.

1. A) collect and store
2. B) collect, store, and sort
3. C) store and sort
4. D) collect and sort

Answer: B

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

2) Data is stored in Excel in ________.

1. A) a chart
2. B) multiple tables
3. C) rows and columns
4. D) reports

Answer: C

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

3) Data is stored in Access in ________.

1. A) multiple tables
2. B) a flat table
3. C) a chart
4. D) formulas

Answer: A

Diff: 2 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

4) When data is imported into Excel from Access, a(n) ________ connection is created.

1. A) temporary
2. B) automatic
3. C) conditional
4. D) permanent

Answer: D

Diff: 2 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

5) Because all data in Access is stored in tables, data in Excel must be in ________ before it can be imported into Access.

1. A) table form
2. B) list form
3. C) report form
4. D) object form

Answer: B

Diff: 2 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

6) Column headings in Excel become ________ when imported into Access.

1. A) data
2. B) forms
3. C) field names
4. D) records

Answer: C

Diff: 2 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

7) Rows in Excel become ________ when imported into Access.

1. A) records
2. B) field names
3. C) data
4. D) forms

Answer: A

Diff: 2 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

8) Before you import Excel data into Access, it is good practice to remove ________.

1. A) data labels
2. B) blank rows
3. C) column headings
4. D) all charts

Answer: B

Diff: 1 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

9) If a worksheet has excess data that you do not want to import into an Access table, you can create a ________.

1. A) column selection
2. B) row selection
3. C) named range
4. D) data range

Answer: C

Diff: 2 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

10) When importing data from Excel to Access, you can import ________ at a time.

1. A) one worksheet
2. B) two worksheets
3. C) all worksheets
4. D) selected worksheets

Answer: A

Diff: 2 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

11) To help you import data from Excel into Access, you can follow step-by-step instructions by using the ________ Wizard.

1. A) Import Workbook
2. B) Import Worksheet
3. C) Import Data
4. D) Import Spreadsheet

Answer: D

Diff: 2 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

12) When you use the Wizard to import data from Excel into Access, which of the following is NOT an option?

1. A) Create an embedded table
2. B) Create a new table
3. C) Append the Excel data to an existing table
4. D) Create a linked table

Answer: A

Diff: 3 Page Ref: 1038

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

13) The Get External Data – Excel Spreadsheet dialog box offers ________ choice(s) for importing data from Excel to Access.

1. A) one
2. B) two
3. C) three
4. D) four

Answer: A

Diff: 3 Page Ref: 1038

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

14) In a well-designed database, a ________ key is selected for every table.

1. A) foreign
2. B) primary
3. C) major
4. D) table

Answer: B

Diff: 2 Page Ref: 1039

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

15) If you try to import a list into Access that does not contain a field for a primary key, Access will ________.

1. A) ask you to create a primary key
2. B) assign one for you
3. C) display an error message
4. D) import the data without a primary key

Answer: B

Diff: 1 Page Ref: 1039

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

16) When you first open a blank database in Access, a table called ________ is automatically created.

1. A) Table1
2. B) BlankTable
3. C) DataTable
4. D) nettable

Answer: A

Diff: 2 Page Ref: 1040

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

17) A mail merge is a process that simplifies the task of preparing many documents that contain ________ formatting, layout, and text but where certain portions of each document vary.

1. A) matching
2. B) duplicate
3. C) identical
4. D) similar

Answer: C

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

18) If you want to use only some of the data in an Access table, you should create a ________.

1. A) sub-table
2. B) query
3. C) form
4. D) report

Answer: B

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

19) One of the items that typically changes in a mail merge letter is the ________.

1. A) company name
2. B) sender’s address
3. C) recipient’s address
4. D) closing

Answer: C

Diff: 3 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

20) When you export data to an RTF file to use in another document, ________ step(s) is(are) involved.

1. A) one
2. B) two
3. C) three
4. D) five

Answer: B

Diff: 3 Page Ref: 1043

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

21) If a Security Warning bar displays when you first open a database, you must click the ________ button before you can make any changes to the database.

1. A) Close Security
2. B) Open Content
3. C) Enable Security
4. D) Enable Content

Answer: D

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

22) The Mail Merge Wizard will not work if the Access database from which you are importing data is in ________ mode.

1. A) locked
2. B) security
3. C) exclusive
4. D) update

Answer: C

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

23) A(n) ________ is used to control the use of uppercase and lowercase letters, so that even when names are entered incorrectly, they will be correct in the merged document.

1. A) Edit field command
2. B) Small caps command
3. C) Format field switch
4. D) All caps option

Answer: C

Diff: 3 Page Ref: 1045

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

24) To make sure that first names and last names will start with an uppercase letter, you would select ________ in the Field dialog box.

1. A) Uppercase
2. B) Lowercase
3. C) First capital
4. D) Title case

Answer: D

Diff: 3 Page Ref: 1045

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

25) If you are not going to use a merged file again, it is good practice NOT to ________ the file.

1. A) edit
2. B) save
3. C) close
4. D) print

Answer: B

Diff: 2 Page Ref: 1047

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

26) Access and Excel can both be used to collect, store, and sort data.

Answer: TRUE

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

27) Excel has more sophisticated tools than Access for collecting, sorting, and storing data.

Answer: FALSE

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

28) Both Excel and Access can be used to create charts.

Answer: FALSE

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

29) Data CANNOT be exchanged between Access and Excel.

Answer: FALSE

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

30) When data is imported into Excel from Access, a permanent connection is created.

Answer: TRUE

Diff: 2 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

31) When data is imported into Access from Excel, one of your options is to link the data, so that changes in Excel will be reflected in the table in Access.

Answer: TRUE

Diff: 3 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

32) Exchanging data between Access and Excel allows you to take advantage of the strengths of each.

Answer: TRUE

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

33) Excel is often used when not appropriate because people are more comfortable with Excel than Access.

Answer: TRUE

Diff: 1 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

34) It is good practice to import Excel data with blank rows into Access.

Answer: FALSE

Diff: 1 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

35) Column headings in Excel become field names when imported into Access.

Answer: TRUE

Diff: 1 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

36) If you have a lot of data to enter into Access, it will be beneficial to create a form to make data entry easier.

Answer: TRUE

Diff: 1 Page Ref: 1035

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

37) Multiple worksheets can be imported from Excel into Access at the same time.

Answer: FALSE

Diff: 2 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

38) Trying to maintain records in two or more places is not good business practice.

Answer: TRUE

Diff: 1 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

39) Access gives you the ability to create a named range in Excel.

Answer: FALSE

Diff: 2 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

40) You can use data from either an Access table or a query for a Word mail merge.

Answer: TRUE

Diff: 1 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

41) In order to create a mail merge in Word, you must always create a query in Access.

Answer: FALSE

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

42) To use Access data in a Word document, the data must first be entered directly into Access.

Answer: FALSE

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

43) An advantage to using mail merge is that multiple documents, where only certain portions vary, can be created quickly.

Answer: TRUE

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

44) Word includes a Letter Merge Wizard to help create customized letters.

Answer: FALSE

Diff: 1 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

45) When you open a database, a Security Warning bar appears to prevent viruses from entering your computer.

Answer: TRUE

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

46) When you see the Security Warning bar, you can click the Disable Security button to continue editing your document.

Answer: FALSE

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

47) When you choose the First capital format switch from the Field dialog box, all names will start with a capital letter.

Answer: FALSE

Diff: 3 Page Ref: 1045

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

48) To export data from Access to Word, you use the Mail Merge command.

Answer: TRUE

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

49) The Mail Merge Wizard allows you to preview your merged documents, before the merge is completed.

Answer: TRUE

Diff: 2 Page Ref: 1047

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

50) When you create a merged document, it must be saved before you can print the individual documents.

Answer: FALSE

Diff: 2 Page Ref: 1047

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

51) Both Access and Excel can be used to collect, store, and ________ data.

Answer: sort

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

52) Data is stored in Excel in ________.

Answer: rows and columns

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

53) Data is stored in Access in ________.

Answer: multiple tables

Diff: 1 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

54) When data is imported into Access from Excel, a(n) ________ connection is created.

Answer: permanent

Diff: 2 Page Ref: 1034

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

55) Because all data is stored in tables in Access, the data in Excel must be in a(n) ________ form.

Answer: list

Diff: 2 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

56) Before you import data from Excel into Access, you need to make sure the data is ________.

Answer: compatible.

Diff: 2 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

57) When importing data from an Excel table, rows become ________ in Access.

Answer: records

Diff: 1 Page Ref: 1035

Objective: Prepare Excel Data for Export to Access

Text: Your Office: Microsoft Office 2013 Volume 1

58) ________ worksheet(s) can be imported from Excel into Access at the same time.

Answer: One

Diff: 2 Page Ref: 1037

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

59) If you try to import a list into Access that does not contain a field for a ________ key, Access will assign one.

Answer: primary

Diff: 1 Page Ref: 1039

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

60) When you import data into a new table, Access will use the field names and data types of the imported data for the new table ________.

Answer: structure

Diff: 3 Page Ref: 1041

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

61) The Import Spreadsheet Wizard gives you the option to change the ________ and data types before you import the data.

Answer: field names

Diff: 3 Page Ref: 1041

Objective: Import Excel Data into Access

Text: Your Office: Microsoft Office 2013 Volume 1

62) One common example of using ________ data in a Word document, is to create a mail merge.

Answer: Access

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

63) A(n) ________ is a process that allows you to prepare multiple documents that contain identical text but where only certain portions of each document vary.

Answer: mail merge

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

64) Data for a mail merge in Word can come either from a(n) ________ table or query.

Answer: Access

Diff: 2 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

65) To find customers who have birthdays in a specific month, you must first create a(n) ________.

Answer: query

Diff: 1 Page Ref: 1041

Objective: Prepare Access Data for a Mail Merge

Text: Your Office: Microsoft Office 2013 Volume 1

66) The ________ bar reports that certain features of Access have been disabled to maintain security and prevent viruses from infecting your computer.

Answer: Security Warning

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

67) The ________ Wizard can be used to export data from Access to be used in Word.

Answer: Mail Merge

Diff: 2 Page Ref: 1044

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

68) If you are going to use a merged file just one time, it is not necessary to ________ it.

Answer: save

Diff: 2 Page Ref: 1047

Objective: Export Access Query Results to Word

Text: Your Office: Microsoft Office 2013 Volume 1

69) Match the terms with their correct definition.

1. Named range
2. Mail merge
3. Query
4. Security warning

1. Displays when you open a database
2. A specific name given to a range of cells other that the cell reference
3. A process that produces multiple documents
4. Produces a subset of data that matches specific criteria

Answer: B, C, D, A

Diff: 2 Page Ref: Multiple Pages

Objective: Multiple Objectives

Text: Your Office: Microsoft Office 2013 Volume 1

70) Match the terms with their correct definition.

1. Import Spreadsheet Wizard
2. Mail Merge Wizard
3. Rich Text Format (RTF)
4. Format field switch

1. Helps create multiple documents where some elements vary in each
2. A file format that retains the formatting of the original document
3. Provides steps to help import Excel data into Access
4. Controls formatting, such as uppercase and lowercase letters

Answer: C, A, B, D

Diff: 2 Page Ref: Multiple Pages

Objective: Multiple Objectives

Text: Your Office: Microsoft Office 2013 Volume 1