Enhanced Computer Concepts And Microsoft Office 2013 Illustrated 1st Edition By by June Jamrich Parsons -Test Bank

 

 

To Purchase this Complete Test Bank with Answers Click the link Below

 

https://tbzuiqe.com/product/enhanced-computer-concepts-and-microsoft-office-2013-illustrated-1st-edition-by-by-june-jamrich-parsons-test-bank/

 

If face any problem or Further information contact us At tbzuiqe@gmail.com

 

Sample Test

Access_2013_Unit_C_Using_Forms

 

 

1. Forms can be used to enter and edit data.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 54

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

2. A form allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 54

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

3. Each item on a form is called a control.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 54

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

 

4. In the accompanying figure, the first tool in the list creates a form from scratch in Form Design View.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.043 – Create a split form

 

5. If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 58

LEARNING OBJECTIVES:  

ENHC.PARS.16.044 – Format controls in Layout View

 

6. You can add fields to a form in either Layout View or Design View.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 60

LEARNING OBJECTIVES:  

ENHC.PARS.16.045 – Add fields to a form

 

7. Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 60

LEARNING OBJECTIVES:  

ENHC.PARS.16.045 – Add fields to a form

 

8. Bound controls exist only to describe or enhance the appearance of the form.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Access 61

LEARNING OBJECTIVES:  

ENHC.PARS.16.046 – Define bound and unbound controls

 

9. A tab control is an unbound control.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 61

LEARNING OBJECTIVES:  

ENHC.PARS.16.046 – Define bound and unbound controls

 

10. On a form, text box controls display data from an underlying record source.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

11. You can press an arrow key to move a selected control.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 64

LEARNING OBJECTIVES:  

ENHC.PARS.16.048 – Move controls on a form

 

12. It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 66

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

 

13. The Spacing feature represents the space between controls.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Access 67

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

 

14. A background image is an image that fills the entire form or report, appearing “behind” the other controls.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 69

LEARNING OBJECTIVES:  

ENHC.PARS.16.050 – Insert an image on a form

 

15. The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.

 

a.

fields

b.

title

 

c.

layout

d.

All of the above.

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 54

LEARNING OBJECTIVES:  

ENHC.PARS.16.051 – Create a form with the Form Wizard

 

16. Which of the following is NOT a form view?

 

a.

Data

b.

Form

 

c.

Layout

d.

Design

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 55

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

17. Which form creation tool can you use to create a form from scratch in Form Design View?

 

a.

Form

b.

Blank Form

 

c.

Form Design

d.

Form Wizard

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

18. Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

 

a.

Form Wizard

b.

More Forms

 

c.

Split Form

d.

Navigation

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

19. Which form creation tool can you use to build a form based on Multiple Items, Datasheet, or Split Form, for example?

 

a.

Form Design

b.

Blank Form

 

c.

More Forms

d.

Form Wizard

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.043 – Create a split form

 

 

20. In the accompanying figure, the ____ tool will create a form with one click, based on the selected table or query.

 

a.

first

b.

second

 

c.

third

d.

fifth

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

21. In the accompanying figure, the ____ tool will create a form from scratch in Form Layout View.

 

a.

first

b.

second

 

c.

third

d.

fourth

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

22. In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.

 

a.

second

b.

third

 

c.

fourth

d.

fifth

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

23. In the accompanying figure, the ____ tool is used to navigate or move between different areas of the database.

 

a.

first

b.

second

 

c.

third

d.

fifth

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

24. Referential integrity prevents the creation of ____ records.

 

a.

indexed

b.

split

 

c.

unlicensed

d.

orphan

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

25. ____ records are those on the many side of a relationship that do not have a match on the one side.

 

a.

indexed

b.

split

 

c.

unlicensed

d.

orphan

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.052 – Enter and edit data in a form

 

26. ____ View lets you make some design changes to a form while you are browsing the data.

 

a.

Layout

b.

Design

 

c.

Browse

d.

Data

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 58

LEARNING OBJECTIVES:  

ENHC.PARS.16.053 – Resize controls in Layout View

 

27. The Align button in the Sizing & Ordering group is available on the ____ tab.

 

a.

ARRANGE

b.

OPTIONS

 

c.

HOME

d.

FORMAT

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 60

LEARNING OBJECTIVES:  

ENHC.PARS.16.054 – Align controls

 

28. Which of the following is NOT a bound control?

 

a.

Text box

b.

Combo box

 

c.

List box

d.

Label

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 61

LEARNING OBJECTIVES:  

ENHC.PARS.16.046 – Define bound and unbound controls

 

29. Which control displays a list of possible data entries from which the user can choose?

 

a.

Label

b.

Text box

 

c.

List box

d.

Tab control

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

30. Which control is used to create a three-dimensional aspect to a form?

 

a.

Command button

b.

Toggle button

 

c.

Rectangle control

d.

Tab control

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

31. Which control provides an easy way to initiate a command or run a macro?

 

a.

Check box

b.

Toggle button

 

c.

Command button

d.

Image control

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

32. Which control is both a list box and a text box control?

 

a.

Bound image control

b.

Unbound image control

 

c.

Combo box

d.

Option group

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

33. Which of the following would most likely be used to display a Yes/No field on a form?

 

a.

Check box

b.

Command button

 

c.

Combo box

d.

Label

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

34. Which control, when it appears pressed, displays “yes” information?

 

a.

Bound image control

b.

Combo box

 

c.

Tab control

d.

Toggle button

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

35. Which control is used to provide consistent descriptive text as you navigate from record to record?

 

a.

Text box

b.

Combo box

 

c.

List box

d.

Label

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

36. Expressions must start with what character?

 

a.

[ left square bracket

b.

= equal sign

 

c.

( left parenthesis

d.

: colon

 

ANSWER:  

b

POINTS:  

1

REFERENCES:  

Access 64

LEARNING OBJECTIVES:  

ENHC.PARS.16.055 – Build calculations on a form

 

37. When referencing field names within an expression, surround the field name with ____.

 

a.

[square brackets]

b.

{curly brackets}

 

c.

(parentheses)

d.

“quotation marks”

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 64

LEARNING OBJECTIVES:  

ENHC.PARS.16.055 – Build calculations on a form

 

38. ____ refers to the space between the outer edge of the control and the data displayed inside the control.

 

a.

Spacing

b.

Reference

 

c.

Padding

d.

Margin

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 67

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

 

39. You can press ____ to move the focus through the controls of the form.

 

a.

[Page Down]

b.

[Tab]

 

c.

[F5]

d.

[F12]

 

ANSWER:  

b

POINTS:  

1

REFERENCES:  

Access 66

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

 

40. When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image.

 

a.

label indices

b.

sizing handles

 

c.

combo boxes

d.

command squares

 

ANSWER:  

b

POINTS:  

1

REFERENCES:  

Access 68

LEARNING OBJECTIVES:  

ENHC.PARS.16.050 – Insert an image on a form

 

41. Controls placed in the ____ form section print only once at the top of the printout.

 

a.

Form Header

b.

Detail

 

c.

Form First

d.

Form Top

 

ANSWER:  

a

POINTS:  

1

REFERENCES:  

Access 68

LEARNING OBJECTIVES:  

ENHC.PARS.16.056 – Modify form sections

 

42. You can insert a logo on a form using the ____ button in the Controls group.

 

a.

Graphic Art

b.

Art

 

c.

Graphic Image

d.

Insert Image

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 68

LEARNING OBJECTIVES:  

ENHC.PARS.16.050 – Insert an image on a form

 

43. Which of the following would NOT be considered a graphic image?

 

a.

Picture

b.

Logo

 

c.

Text

d.

Clip art

 

ANSWER:  

c

POINTS:  

1

REFERENCES:  

Access 68

LEARNING OBJECTIVES:  

ENHC.PARS.16.050 – Insert an image on a form

 

44. Controls placed in this form section print once for every record.

 

a.

Form Records

b.

Form Header

 

c.

Form Footer

d.

Detail

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Access 68

LEARNING OBJECTIVES:  

ENHC.PARS.16.057 – Print a selected record

 

45. ____________________ box controls are used to display as well as enter, edit, find, sort, and filter data on a form.

ANSWER:  

Text

POINTS:  

1

REFERENCES:  

Access 54

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

46. On a form, ____________________ View is used to enter, edit, and delete data.

ANSWER:  

Form

POINTS:  

1

REFERENCES:  

Access 55

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

47. On a form, ____________________ View is used to modify controls and does not display data.

ANSWER:  

Design

POINTS:  

1

REFERENCES:  

Access 55

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

48. On a form, ____________________ View can be used to move and modify controls while viewing live data.

ANSWER:  

Layout

POINTS:  

1

REFERENCES:  

Access 55

LEARNING OBJECTIVES:  

ENHC.PARS.16.042 – Describe form terminology and views

 

49. In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

ANSWER:  

split

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.043 – Create a split form

 

50. Use the ____________________ Form tool to create a form from scratch in Form Layout View.

ANSWER:  

Blank

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.043 – Create a split form

 

51. The ____________________ Sheet of a control is a comprehensive listing of all characteristics that you can modify for that control.

ANSWER:  

Property

POINTS:  

1

REFERENCES:  

Access 62

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

52. The ____________________ List lists the database tables and the fields they contain.

ANSWER:  

Field

POINTS:  

1

REFERENCES:  

Access 60

LEARNING OBJECTIVES:  

ENHC.PARS.16.045 – Add fields to a form

 

53. When you modify controls, you change their ____________________, or characteristics.

ANSWER:  

properties
property

POINTS:  

1

REFERENCES:  

Access 62

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

54. Controls placed in the Form ____________________ print only once at the end of the last page of the printout.

ANSWER:  

Footer

POINTS:  

1

REFERENCES:  

Access 68

LEARNING OBJECTIVES:  

ENHC.PARS.16.057 – Print a selected record

 

55. Differentiate between bound and unbound controls.

ANSWER:  

Controls are either bound or unbound. Bound controls display values from a field such as text boxes and combo boxes. Unbound controls do not display data; unbound controls describe data or enhance the appearance of the form. Labels are the most common type of unbound control, but other types include lines, images, tabs, and command buttons. Another way to distinguish bound from unbound controls is to observe the form as you move from record to record. Because bound controls display data, their contents change as you move through the records, displaying the entry in the field of the current record. Unbound controls such as labels and lines do not change as you move through the records in a form.

POINTS:  

1

REFERENCES:  

Access 61

LEARNING OBJECTIVES:  

ENHC.PARS.16.046 – Define bound and unbound controls

TOPICS:  

Critical Thinking

 

56. Discuss the difference between tab order and tab stop.

ANSWER:  

Tab order is the order the focus moves as you press [Tab] in Form View.
Tab stop refers to whether you can tab into a control when entering or editing data; in other words, whether the control can receive the focus.

POINTS:  

1

REFERENCES:  

Access 66

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

TOPICS:  

Critical Thinking

 

57. Discuss layout positioning. Include the following terms in your response: margin, padding, and anchoring.

ANSWER:  

If the controls on a form are organized in a layout, you can quickly modify that layout by modifying the margins, padding, and anchoring options of the layout. Each of these features is found in the Position group on the ARRANGE tab in Form Design View. Margin refers to the space between the outer edge of the control and the data displayed inside the control. Padding is the space between the controls. Anchoring allows you to tie controls together so you can work with them as a group.

POINTS:  

1

REFERENCES:  

Access 67

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

TOPICS:  

Critical Thinking

 

58. Click in the text box of the field you want to sort after clicking a sort button. _________________________

ANSWER:  

False – before

POINTS:  

1

REFERENCES:  

Access 54

LEARNING OBJECTIVES:  

ENHC.PARS.16.058 – Sort data in a form

 

59. The lower pane of a split form displays a(n) datasheet view. _________________________

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 56

LEARNING OBJECTIVES:  

ENHC.PARS.16.043 – Create a split form

 

60. The Size/Space button is in the Alignment group on the ARRANGE tab. _________________________

ANSWER:  

False – Sizing & Ordering

POINTS:  

1

REFERENCES:  

Access 60

LEARNING OBJECTIVES:  

ENHC.PARS.16.059 – Resize controls

 

61. When you add a new field to a form, two controls are usually created: a(n) caption and a text box. _________________________

ANSWER:  

False – label

POINTS:  

1

REFERENCES:  

Access 60

LEARNING OBJECTIVES:  

ENHC.PARS.16.045 – Add fields to a form

 

62. The connection between the text box and field is defined by the Control Source property. _________________________

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Access 64

LEARNING OBJECTIVES:  

ENHC.PARS.16.055 – Build calculations on a form

 

63. The Navigation tab on the Property Sheet allows you to change the tab stop or tab order properties. _________________________

ANSWER:  

False – Other

POINTS:  

1

REFERENCES:  

Access 66

LEARNING OBJECTIVES:  

ENHC.PARS.16.049 – Modify tab order properties

 

Case 3-1

You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them.

 

64. Which of the following is the default mouse pointer in Layout View?

a.

c.

b.

d.

 

ANSWER:  

C

POINTS:  

1

REFERENCES:  

Access 58

LEARNING OBJECTIVES:  

ENHC.PARS.16.053 – Resize controls in Layout View

TOPICS:  

Critical Thinking

 

65. Which of the following displays when you point to any unselected control on the form?

a.

c.

b.

d.

 

ANSWER:  

C

POINTS:  

1

REFERENCES:  

Access 58

LEARNING OBJECTIVES:  

ENHC.PARS.16.053 – Resize controls in Layout View

TOPICS:  

Critical Thinking

 

66. Which of the following appears when you point to the upper-left corner or edge of a selected control in Form Design View or the middle of the control in Form Layout View?

a.

c.

b.

d.

 

ANSWER:  

A

POINTS:  

1

REFERENCES:  

Access 58

LEARNING OBJECTIVES:  

ENHC.PARS.16.053 – Resize controls in Layout View

TOPICS:  

Critical Thinking

 

67. Which of the following appears when you point to one of the sizing handles (except the large one in the upper-left corner in Form Design View)?

a.

c.

b.

d.

None of the above.

 

ANSWER:  

B

POINTS:  

1

REFERENCES:  

Access 58

LEARNING OBJECTIVES:  

ENHC.PARS.16.053 – Resize controls in Layout View

TOPICS:  

Critical Thinking

 

Match each term below with the statement that best defines it.

a.

Command button

b.

Label

c.

Option button

d.

List box

e.

Tab control

f.

Combo box

g.

Toggle button

h.

Line

 

REFERENCES:  

Access 63

LEARNING OBJECTIVES:  

ENHC.PARS.16.047 – Modify control properties

 

68. Displays choices for a field

ANSWER:  

c

POINTS:  

1

 

69. Creates a three-dimensional aspect on a form

ANSWER:  

e

POINTS:  

1

 

70. Best choice to display a field such as Veteran that has only two options, Yes or No

ANSWER:  

g

POINTS:  

1

 

71. Provides consistent descriptive text as you navigate records

ANSWER:  

b

POINTS:  

1

 

72. Used to visually separate information on a form

ANSWER:  

h

POINTS:  

1

 

73. Used to provide a list of possible data entries

ANSWER:  

d

POINTS:  

1

 

74. Used to run a macro

ANSWER:  

a

POINTS:  

1

 

75. Used to provide a list of options for a field plus the ability for the user to enter a new value

ANSWER:  

f

POINTS:  

1

 

Excel_2013_Unit_A_Getting_Started_With_Excel_2013

 

1. In an electronic spreadsheet, you need to manually recalculate when you change the entries.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Excel 2

LEARNING OBJECTIVES:  

ENHC.PARS.16.089 – Describe the uses of Excel

 

2. An Excel 2013 workbook has the file extension .xml.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Excel 2

LEARNING OBJECTIVES:  

ENHC.PARS.16.089 – Describe the uses of Excel

 

3. Charts are updated automatically in Excel whenever data changes.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 2

LEARNING OBJECTIVES:  

ENHC.PARS.16.089 – Describe the uses of Excel

 

4. To open an Excel file, click Open Other Workbooks on the navigation bar, click Computer, and then click Browse to open the Open dialog box.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 4

LEARNING OBJECTIVES:  

ENHC.PARS.16.090 – Open and save an Excel file

 

5. You are in Edit mode any time you are entering or changing the contents of a cell.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 8

LEARNING OBJECTIVES:  

ENHC.PARS.16.091 – Build formulas with the AutoSum button

 

6. Arguments are Excel’s built-in formulas.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Excel 8

LEARNING OBJECTIVES:  

ENHC.PARS.16.091 – Build formulas with the AutoSum button

 

7. You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 12

LEARNING OBJECTIVES:  

ENHC.PARS.16.092 – Enter a formula

 

8. A named range can begin with a letter or number.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Excel 12

LEARNING OBJECTIVES:  

ENHC.PARS.16.093 – Use cell references to create a formula

 

9. You can use a named range instead of a cell address in a formula.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 12

LEARNING OBJECTIVES:  

ENHC.PARS.16.093 – Use cell references to create a formula

 

10. You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

 

a.

True

 

b.

False

 

ANSWER:  

False

POINTS:  

1

REFERENCES:  

Excel 14

LEARNING OBJECTIVES:  

ENHC.PARS.16.094 – Create a header/footer

 

11. Printing gridlines makes data easier to read.

 

a.

True

 

b.

False

 

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 16

LEARNING OBJECTIVES:  

ENHC.PARS.16.095 – Hide/view gridlines when printing

 

12. Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet. ____________________

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 2

LEARNING OBJECTIVES:  

ENHC.PARS.16.089 – Describe the uses of Excel

 

13. Labels are numbers, formulas, and functions that can be used in calculations. _____________________

ANSWER:  

False – Values

POINTS:  

1

REFERENCES:  

Excel 8

LEARNING OBJECTIVES:  

ENHC.PARS.16.091 – Build formulas with the AutoSum button

 

14. Reference operators compare values for the purpose of true/false results. _____________________

ANSWER:  

False – Comparison

POINTS:  

1

REFERENCES:  

Excel 12

LEARNING OBJECTIVES:  

ENHC.PARS.16.092 – Enter a formula

 

15. One of the ways to change your view of the worksheet window is by using the VIEW tab on the Ribbon. ______________________

ANSWER:  

True

POINTS:  

1

REFERENCES:  

Excel 14

LEARNING OBJECTIVES:  

ENHC.PARS.16.096 – Change worksheet views

 

16. When the paper orientation is portrait, the contents will print across the length of the page instead of across the width. _______________________

ANSWER:  

False – landscape

POINTS:  

1

REFERENCES:  

Excel 16

LEARNING OBJECTIVES:  

ENHC.PARS.16.097 – Change the page orientation

 

17. An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

 

a.

database

b.

spreadsheet

 

c.

dataform

d.

project

 

ANSWER:  

b

POINTS:  

1

REFERENCES:  

Excel 2

LEARNING OBJECTIVES:  

ENHC.PARS.16.089 – Describe the uses of Excel

 

18. In Excel, the electronic spreadsheet you work in is called a ____.

 

a.

tablet

b.

databook

 

c.

numericsheet

d.

worksheet

 

ANSWER:  

d

POINTS:  

1

REFERENCES:  

Excel 2

LEARNING OBJECTIVES:  

ENHC.PARS.16.098 – Define key spreadsheet terms

 

 

Comments

Popular posts from this blog

Business and Administrative Communication A Locker 12th Edition – Test Bank

Crafting and Executing Strategy The Quest for Competitive Advantage Concepts Arthur Thompson 22nd Edition- Test Bank

Experience Human Development 13Th Edition By Diane Papalia – Test Bank