Студопедия КАТЕГОРИИ: АвтоАвтоматизацияАрхитектураАстрономияАудитБиологияБухгалтерияВоенное делоГенетикаГеографияГеологияГосударствоДомЖурналистика и СМИИзобретательствоИностранные языкиИнформатикаИскусствоИсторияКомпьютерыКулинарияКультураЛексикологияЛитератураЛогикаМаркетингМатематикаМашиностроениеМедицинаМенеджментМеталлы и СваркаМеханикаМузыкаНаселениеОбразованиеОхрана безопасности жизниОхрана ТрудаПедагогикаПолитикаПравоПриборостроениеПрограммированиеПроизводствоПромышленностьПсихологияРадиоРегилияСвязьСоциологияСпортСтандартизацияСтроительствоТехнологииТорговляТуризмФизикаФизиологияФилософияФинансыХимияХозяйствоЦеннообразованиеЧерчениеЭкологияЭконометрикаЭкономикаЭлектроникаЮриспунденкция |
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
|
|||
Последнее изменение этой страницы: 2018-04-11; просмотров: 550. stydopedya.ru не претендует на авторское право материалов, которые вылажены, но предоставляет бесплатный доступ к ним. В случае нарушения авторского права или персональных данных напишите сюда... |