Which of the following can be used to navigate documents?

By default, on which page the header or the footer is printed?

A. On every page

B. On first page

C. On alternate page

D. On next page

E. None of the above

35. MS-Word automatically moves the text to the next line when it reaches the right edge of the screen and is called?

A. Word Wrap

B. Carriage Return

C. Enter

D. On next page

E. None of the above

36. Which key should be pressed to start a new paragraph in MSWord?

A. Enter Key

B. Down Cursor Key

C. Shift + Enter

D. Control + Enter

E. Control + Z

37. Which option in File pull-down menu is used to close a file in MSWord?

A. Close

B. Exit

C. New

D. Quit

E. Save

38. Which bar is usually located below that Title Bar that provides categorized options?

A. Menu bar

B. Tool bar

C. Scroll bar

D. Status Bar

E. None of the above

39. Which menu in MSWord can be used to change character size and typeface?

A. Format

B. Data

C. View

D. Tools

E. Save

40. Which key is used to select all the text in the document?

A. Ctrl+A

B. Ctrl+F

C. Ctrl+N

D. Ctrl+T

E. Ctrl+Z

41. Which key is used to increase left indent?

A. Ctrl+M

B. F10

C. Alt+I

D. Ctrl+I

E. Ctrl+Z

42. To undo the last work, press …..

A. Ctrl+Z

B. Ctrl+Y

C. Ctrl+U

D. Ctrl+W

E. Ctrl+A

43. In MS Word, Ctrl+S is for …..

A. Save

B. Spelling Check

C. Size

D. Scenarios

E. Paste

44. Which language does MS-Word use to create Macros?

A. Visual Basic

B. Access

C. FoxPro

D. Visual C++

E. Turbo Pascal

45. Which keystroke is used for updating a field?

A. F9

B. F6

C. F11

D. F12

E. F1

46. Which key deletes the character to the right of the cursor?

A. Delete

B. Home

C. Backspace

D. End

E. Page Up

47. Which would you choose to save a document with a new name?

A. Click File, Save As

B. Click Tools, Options, Save

C. Press Ctrl+S

D. Click File, Save

E. Press Ctrl+A

Which would you choose to move selected text from one place to another?

A. Cut and Paste

B. Delete and Paste

C. Move and Paste

D. Copy and Paste

E. Cut and Save

48. Which key deletes the character to the left of the cursor?

A. Backspace

B. Delete

C. End

D. Home

E. Page Down

49. How do you magnify your document?

A. View, Zoom

B. Tools, Options

C. Tools, Customize

D. Format, Font

E. Tools, Zoom

50. Which of the following can be used to divide a web page into areas?

A. Frames

B. Table of contents

C. Theme

D. Hyperlinks

E. None of the above

51. By default, Word automatically formats each heading in a table of contents as ………..

A. Hyperlinks

B. Bookmarks

C. Cross-references

D. Word-fields

E. None of the above

Which of the following can be used to navigate documents?

A. Hyperlinks

B. Web toolbar

C. Frames

D. Word-fields

E. All of the above

53. With which view can you see how text and graphics will appear on the printed page?

A. Print Layout

B. Web Layout

C. Normal

D. Outline

E. All of the above

54. How do you open the Header and Footer toolbar?

A. On the View menu, click Header and Footer.

B. On the View menu, click Toolbars, and select Header and Footer from the list of toolbars.

C. Right–click any toolbar and click Header and Footer.

D. File/Format/Bold

E. None of the above

55. Which keyboard shortcut bolds selected text?

A. Ctrl+B

B. Alt+B

C. Ctrl+A

D. File/Format/Bold

E. None of the above

56. Which keyboard shortcut centers selected text?

A. Ctrl+E

B. Ctrl+C

C. Alt+C

D. There is no keyboard shortcut for this operation

E. Ctrl+A

57. How many margins are on a page?

A. Four (top, bottom, right, left)

B. Two (header and footer)

C. Two (landscape and Portrait)

D. Two (top and bottom)

E. Two (top and footer)

58. How can you highlight text without using the mouse?

A. Use the arrow keys while holding down a Shift key

B. It is impossible

C. Use the F5 key

D. Use the arrow keys while holding down a Ctrl key

E. Use the F1 key

59. What is the keyboard shortcut for creating a chart from the selected cells?

A. F11

B. F3

C. F7

D. F9

E. F1

60. Microsoft Excel 2007 is a ___________________?

A. Spreadsheets Package

B. Graphics Package

C. Multimedia Package

D. Word Processing Package

E. None of the above

61. An Excel spreadsheet is also called a ______________________

A. Workbook

B. Worksheet

C. Document

D. Sheet

E. Table

62. To name a cell or range, you use the _______________

A. Names Box

B. Format cells

C. Define name

D. Paste name

E. Tools

63. In MS Excell _____________ is the horizontal part of the spreadsheet.

A. Rows

B. Cell

C. Column

D. Table

E. Sheet

64. If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:

A. Type the data in A1 and Merge cells A1:E1

B. Type the data in A1 and Merge cells A1:A5

C. Choose Center from the Format menu

D. Type the data in C1

E. Type the data in C1 and Merge cells E1:A5

65. Columns are identified by a _______________ .

A. Letter

B. Word

C. Number

D. Number and letter

E. Callouts

66. Using the autosum button will place in the selected cell _____.

A. A formula which will add values in the range Excel guesses you want to add

B. The sum of values in the cell's column

C. The sum of the cell's row unless you change the range

D. Nothing until you selects a range of cells

E. Choose Center from the Format menu

67. To open the Format Cells dialog box, press

A. Ctrl + 1

B. F1

C. Alt + 1

D. Ctrl + Shift + 1

E. Shift + 1

68. The _________________ displays the name of the sheets in the workbook.

A. Sheet Tabs

B. Book Tabs

C. Menu Bar

D. Scroll Bar

E. None of the above

69. Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?

A. =SUM(J1:J8)

B. =SUM J:1-8

C. =J:1+J:8

D. =ADD(J1-J8)

E. =ADD(J1:J8)

70. The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:

A. Apply a table style

B. Use Format Painter

C. Select all and use the Formatting dialog box

D. Format each element using the Toolbar

E. A range of cells by range name

71. Rows are identified by a _______________________

A. Number

B. Cell

C. Column

D. Menu Bar

E. Scroll Bar

72. Which of the following keys/key can be used to check spelling and grammar?

A. F7

B. F1

C. Crt-Home

D. Ctrl-End

E. Ctrl-Page Up

73. Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?

A. Sum

B. Count

C. Average

D. Max

E. Min

74. On an Excel sheet the active cell is indicated by ____.

A. A dark wide border

B. A dotted border

C. A blinking border

D. You've entered a number wrong.

E. None of the above

75. In order to multiply items in Excel you would use:

A. “*”

B. “ ^”

C. “@”

D. “#”

E. “<”

76. If cells: A1=90, A2=85, A3=80, A4=75, A5=75. What will be your formula if you are going to get the total?

A. =SUM(A1:A5), =A1+A2+A3+A4+A5, =sum(a1:a5), =a1+a2+a3+a4+a5

B. =SUM(A1:A4), =A1+A2+A3+A4+A5, =sum(a1:a5), =a1+a2+a3+a4+a5

C. =SUM(A1:A5), =A1+A2-A3+A4+A5, =sum(a1:a4), =a1+a2+a3+a4+a5

D. =SUM(A1:A2), =A1+A2+A3+A4-A5, =sum(a1:a5), =a1+a2+a3+a4+a5

E. None of the above

77. How do you rearrange the data in ascending or descending order?

A. Data, Sort

B. Data, Form

C. Data Subtotals

D. Data, Table

E. None of the above

78. An Excel Workbook is a collection of …….

A. Worksheets and Charts

B. Charts

C. Workbooks

D. Worksheets

E. Sheets

79. What do you mean by a Workspace?

A. Group of Workbooks

B. Group of Rows

C. Group of Worksheets

D. Group of Columns

E. Worksheets and Charts

80. Microsoft Excel is a powerful………..

A. Spreadsheet package

B. Word processing package

C. Communication S/W Package

D. DBMS package

E. Worksheets and Charts

81. MS-EXCEL is based on ……….?

A. WINDOWS

B. UNIX

C. DOS

D. OS/2

E. IOS

82. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?

A. Auto sum

B. Auto correct

C. Auto format

D. AutoFill

E. None of the above

83. Which key do you press to check spelling?

A. F7

B. F9

C. F3

D. F5

E. F1

84. Which would you choose to create a bar diagram?

A. Insert, Chart

B. Format, Chart

C. Edit, Chart

D. Tools, Chart

E. Chart,Format

85. Which language is used to create macros in Excel?

A. Visual Basic

B. Java

C. C

D. Visual C++

E. Pascal

86. Which of the following is not a term of MS-Excel?

A. Document

B. Cells

C. Rows

D. Columns

E. Charts

87. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A. Pie Chart

B. Line Chart

C. XY Chart

D. Column Chart

E. None of the above

88. The spelling dialog box can be involved by choosing spelling from ________ menu.

A. Tools

B. Insert

C. View

D. File

E. None of the above

89. The first cell in EXCEL worksheet is labeled as

A. A1

B. AA

C. Aa

D. A0

E. 0A

90. In Excel, the Fill Color button on the Formatting toolbar is used for what?

A. To add shading or color to a cell range.

B. To select a distribution of figures.

C. To insert a background.

D. To add borders.

E. None of the above

91. What are the tabs that appear at the bottom of each workbook called?

A. Sheet tabs

B. Reference tabs

C. Position tabs

D. Location tabs

E. None of the above

92. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

A. An absolute cell address is created.

B. Cell address will change when it is copied to another cell.

C. The status bar does not display the cell address.

D. The sheet tab is changed.

E. None of the above

93. A __________ is a grid with labeled columns and rows.

A. Worksheet

B. Dialog box

C. Toolbar

D. Clipboard

E. None of the above

94. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A. Financial

B. Logical

C. Statistical

D. Math & Trigonometry

E. Dialog box

94. If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:

A. Type the data in A1 and Merge cells A1:E1

B. Type the data in A1 and Merge cells A1:A5

C. Choose Center from the Format menu

D. Type the data in C1

E. None of the above

95. Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

A. Sum

B. Count

C. Average

D. ABS

E. None of the above

96. What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?

A. Cell

B. Matrix

C. Window

D. Sheet

E. None of the above

97. The name of the active cell appeares in the -----------------------.

A. Name box

B. Formula Bar

C. Column

D. Status Bar

E. None of the above

98. The cell labeled F5 refers to

A. Column F row 5

B. Row F column 5

C. Functions available in cells

D. Function key F4

E. None of the above

99. When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.

A. Formula

B. Name Box

C. Title bar

D. Scroll Bar

E. All of above

A. =AVERAGE(B3:B6)

B. =AVE(B3+B4+B5+B6)/4

C. =SUM(B3+B4+B5+B6)/4

D. =AVE(B3:B6)

E. =AVERAGE(B3+B4+B5+B6)/4