Due Date: Tuesday, September 10, 2002



MNSC 341 HOMEWORK ASSIGNMENT 5

(Excel Projects 6 & 7)

Due Date: submit with Lab Assignment 5

Multiple Choice, True/False, and Fill-up the blanks questions

1 The series 1, 2, 3, etc. is an example of a(n) __________.

1 date/time series b. AutoFill series c. linear series d. growth series

2 The series 1, 1, 1, etc. is an example of a(n) __________.

1 date/time series b. AutoFill series c. linear series d. growth series

3 Saving a template is just like saving a workbook except that __________.

1 the Template button is clicked instead of the Save button on the Standard toolbar

2 the word Template must appear in the file name

3 in the Save As dialog box, Template is selected in the Save as type box

4 all of the above

4 The __________ format symbol displays text along with numbers entered in a cell.

1 (comma) b. " " (quotation marks) c. * (asterisk) d. _ (underscore)

5 All of the following specifications are assigned to the Normal style except __________.

1 Number = General b. Font = Arial 10 c. Borders = No Borders d. Protection = Unlocked

6 The six check boxes in the Style dialog box are identical to the six tabs in the __________ dialog box.

1 Format Cells b. Save As c. Page Setup d. Links

7 Cell B5 on the Pittsburgh sheet is referred to as __________.

1 =B5Pittsburgh! b. =B5!Pittsburgh c. =PittsburghB5! D. =Pittsburgh!B5

8 The __________ chart is similar to a 3-D Bar chart in that it can be used to show trends or illustrate comparisons among items.

1 3-D Cone b. 3-D Pie c. 3-D Area d. 3-D Bubble

9 To remove the comment in cell A14 in the accompanying figure, __________.

1 right-click cell A14 and then click Delete Comment on the shortcut menu

2 click cell A14 and then press the DELETE key

3 right-click cell A14 and then click Clear Contents on the shortcut menu

4 click cell A14 and then click the Cut button on the Standard toolbar

[pic]

10 In the accompanying figure, the __________ in the upper-right corner of cell A14 indicates the cell has a comment associated with it.

1 comment pointer b. comment indicator c. comment arrow d. comment gauge

11 The default margins in Excel are set to the following: __________.

1 Top = .75"; Bottom = .75"; Left = 1"; Right = 1"

2 Top = 1"; Bottom = .75'; Left = 1'; Right = 1"

3 Top = .75"; Bottom = 1"; Left = .75"; Right = .75"

4 Top = 1"; Bottom = 1"; Left = .75"; Right = .75"

12 In the Find dialog box, if __________ is selected in the Look in box, Excel will look only in cells that do not have formulas.

1 Values b. Formulas c. Comments d. By Rows

13 In Excel, formulas can be entered on one worksheet that reference cells found on other worksheets, which allows worksheet data to be summarized.

1 True b. False

14 Selecting simple numbers as dummy data allows a user to check quickly to see if the formulas are generating the proper results.

1 True b. False

15 The general form of the ROUND function is =ROUND(number of digits, number), where the number of digits argument determines how many places will be rounded, and the number argument can be a number, cell reference that contains a number, or a formula that results in a number.

1 True b. False

16 While a fixed dollar sign always displays immediately to the left of the first significant digit, a floating dollar sign always displays in the same position in the cell (regardless of the number of significant digits).

1 True b. False

17 A format code can have up to four sections: positive numbers, negative numbers, zeros, and text.

1 True b. False

18 If a formatted template is saved in the folder: c:officeusing the file name Book, Excel uses it as the default Blank Workbook template each time a blank worksheet is begun or inserted.

1 True b. False

19 The default styles that come with Excel can be deleted freely because none of the buttons on the toolbars are dependent on them.

1 True b. False

20 The capability of drilling data through worksheets is an efficient way to enter data that is different in each worksheet.

1 True b. False

21 To draw an arrow, click the Text Box button on the Drawing toolbar.

1 True b. False

22 Like the other Excel toolbars, the WordArt toolbar can be displayed or hidden by right-clicking any toolbar and then clicking WordArt on the shortcut menu.

1 True b. False

23 When working with comments, if the None option regarding their display is chosen, then the comment will display when pointing to the cell with the comment.

1 True b. False

24 Remember to select all sheets to be modified before changing the headers, footers, or margins, because the page setup characteristics will change only for selected sheets.

1 True b. False

25 In an active header, the code &[Page] instructs Excel to insert the page number.

1 True b. False

26 In the 3-D reference 'A:hes pittsburgh pp.xls]Pittsburgh'!B5, the single quotation marks surrounding the location, workbook name, and sheet name are required if any spaces are in any of the three names.

1 True b. False

27 If the three source workbooks are open, when a value is changed in any one of the source workbooks Excel will display a dialog box that will give the option to update the links.

1 True b. False

28 The process of summarizing data found on multiple worksheets on one worksheet is called __________.

29 A(n) __________ is a series of format symbols that define how a format displays.

30 The technique of entering a number once and sinking it through worksheets so it displays in the same cell on all of the selected worksheets is referred to as __________.

31 A range that spans two or more sheets in a workbook, such as Pittsburgh:Phoenix!B5, is called a(n) __________.

32 A text box and arrow can be used to __________ (callout or highlight) objects or elements in a worksheet or chart.

33 A(n) __________ allows an object, such as a text box, to be connected to an annotated item.

34 Using the Page Setup command, the __________ can be changed to increase or decrease the white space surrounding a printed worksheet or chart.

35 To change page setup characteristics, select the desired sheet(s) and click the __________ on the File menu.

36 To delete a page break, select a cell in the row immediately below the dotted line that indicates the page break to be deleted, and then invoke the __________ on the Insert menu.

37 In the accompanying figure, if a check mark is placed in the __________, then Excel will stop only on cells that have the string with the same combination of capital letters and small letters.

[pic]

38 Consolidating data from other worksheets also is referred to as __________.

39 When a(n) __________ is opened, Excel asks whether the links should be updated.

40 With a dependent workbook open, the __________ on the Edit menu can be invoked to recalculate, open a source workbook, or change the source workbook.

41 Because a command or button in Excel does not exist for every possible worksheet task, Microsoft has included a powerful programming language called __________.

1 Formula Translation (FORTRAN) b. Common Business-Oriented Language (COBOL)

2 Report Program Generator (RPG) d. Visual Basic for Applications (VBA)

42 __________ can contain any combination of letters, numerals, spaces, and symbols, and it can be up to 15 characters long.

1 A password b. A macro name c. The name of a control d. All the above

43 To delete a macro, click __________ on the menu bar, point to Macro, click Macros on the Macro submenu, click the name of the macro in the Macro dialog box, and then click the Delete button.

1 Edit b. File c. Data d. Tools

44 A new menu name can be added to a menu bar by selecting New Menu in the __________.

1 Categories list of the Customize dialog box and dragging New Menu from the Categories list to the menu bar

2 Commands list of the Customize dialog box and dragging New Menu from the Categories list to the menu bar

3 Commands list of the Customize dialog box and dragging New Menu from the Commands list to the menu bar

4 Categories list of the Customize dialog box and dragging New Menu from the Commands list to the menu bar

45 A(n) __________ is a series of precise instructions that provides the computer with a step-by-step description of a task to be accomplished.

46 __________ means that a computer carries out the step-by-step instructions.

47 The __________ programming language allows the capabilities of Excel to be customized and extended.

48 A(n) __________ ensures that users will not unprotect a worksheet by using the Unprotect command.

49 To make a macro available whenever Microsoft Excel is used, select __________ in the Store macro list in the Record Macro dialog box.

50 The __________ is used by all office applications to enter, modify, and view VBA code.

51 To turn off the security warning that displays when a workbook containing macros is opened, click Tools on the menu bar, point to Macro, and then click __________ on the Macros submenu.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download