Q1 The special characters Word inserts into your document are calledA. removable characters B. nonprinting characters C. printing characters D. hidden characters |
Q2 The selection bar isA. below the title bar B. to the far left of your document C. used to open other office applications D. none of the above |
Q3 You can add and date to a document byA. inserting a text date B. inserting a date field that will update automatically C. typing the date manually D. all of the above |
Q4 you can delete text byA. selecting the text and pressing the CTRL key B. selecting the text and pressing the DELETE key C. selecting the text and pressing the ALT+PAGEUP keys D. none of the above |
Q5 The insert mode meansA. you can highlight text B. you can type over existing text C. new text is placed in the document at the insertion point D. selecting a vertical block of text |
Q6 You can display the next page in print preview byA. clicking the page forward button B. clicking the previous page button C. using the vertical scroll bar D. clicking the next page button |
Q7 documents can be printed toA. a CD B. a file on the disk C. a printer D. b and c |
Q8 you can printA. specified page of the document B. selected text in the document C. the page that contains the insertion point D. a and b |
Q9 The default paper size and orientation isA. A4 B. 9.5" x 12" Portrait C. 8.5" x 11" Portrait D. 8.5" x 12" Landscape |
Q10 you can print a documentA. from page layout view B. from normal view C. from print preview D. b, c and d |
Q11 The magnifier buttonA. allow you to zoom your document B. display two pages side by side C. scroll you to a new page D. none of the above |
Q12 In print preview, you canA. format text B. print your document C. zoom each page D. all of the above |
Q13 Which of the following formating options is not available on the Tables and Borders toolbar?A. border color B. aligning text at the centre of a cell C. fill color D. all are formating options on the Tables and Borders toolbar. |
Q14 To align numbers with the same number of decimal points in the table columnA. set a decimal tab stop B. right-align the numbers C. centre-align the numbers D. a and b |
Q16 If you change a document and then try to close the Word application, the Word willA. ignore any changes to the document B. automatically save the changes without a message prompt C. display a message prompting you to save changes D. close without saving any changes to the document. |
Q17 Which of the following special characters can be used in a filename?A. the semicolon (;) B. the hyphen (-) C. the period (.) D. the asterick (*) |
Q18 After you create a document, you may need toA. close it B. save it C. print it D. all of the above |
Q19 The horizontal ruler provides features you can use toA. record a macro B. display the next page of a document C. move the insertion point below the end-of-file market D. none of the above. |
Q20 The Select Object Browse button is locatedA. below the vertical scroll bar B. on the menu bar C. on the formatting toolbar D. below the standard toolbar |
Q21 To preserve any change to the document currently displayed on your screen, you shouldA. close the application B. open a new document C. move the document to null screen D. save the document frequently |
Q22 The insertion pointA. provides features for changing margins, tabs and indentations B. indicate the location where text is entered in a document C. is located under the Standard toolbar and has shortcut buttons D. all of the above. |
Q23 The Word Wrap featureA. Automatically move text to the next line when necessary B. appears at the bottom of the document C. allows you to type over text D. none of the above |
Q24 To conserve computer resources, when you have completely finished with a document you shouldA. close it B. save it C. type it D. edit it |
Q25 The following toolbars display in the Word application window by defaultA. Standard toolbar B. drawing toolbar C. formatting toolbar D. a and c |
Q26 Which key or key combination will move the insertion point to the bottom of your document ?A. END B. PAGEDOWN C. CTRL+PAGEDOWN D. None of the above |
Q27 To display hyperlink fields in a Word document, you can press theA. CTRL+SHIFT+F9 keys B. SHIFT+F9 keys C. CTRL+ALTkeys D. none of the above |
Q28 Hyperlinks can be created between a Word document andA. another word document B. another office 97 documents C. a web page on the WWW D. all of the above |
Q29 To cut or copy text you must firstA. click the Remove/Duplicate button B. click the Copy or Cut command C. click the Edit menu D. none of the above |
Q30 You can display the Find and Replace dialog box by using theA. CTRL+G keys B. F5 keys C. Find or Replace commands D. Select browsw objects button |
Q31 When you right-drag selected text, you canA. delete text B. link text C. copy text D. move text |
Q32 The drag-and-drop feature allows you toA. switch from insert to Overtype mode B. move and copy text using the mouse C. move and copy text using the Clipborad D. none of the above |
Q33 The clipboard isA. used to temporarily store items that have been cut or copied B. a reserved place in the memory of the computer C. located below the status bar D. b and c |
Q34 You can search a Word document forA. formatting B. special characters C. words D. a, b and c |
Q35 The "Use smart cut and paste" optionA. inserts a special symbol at the end of each document B. copies text in a documents without using the Clipboard C. adds or deletes spaces as needed when pasting text D. copies text to the Clipboard |
Q36 You can move and copy textA. within a Word document B. between office 97 applications C. between Word documents D. a, b and c |
Q37 AutoText entriesA. can be deleated B. can be edited C. are saved with the Normal template D. a, b and c |
Q38 The SpikeA. allows you to combine text from several documents and then insert all the text into one document at one time B. allows you to edit Auto Text entries C. allow you to format Auto Text enteries D. b and c |
Q39 You can insert an Auto Text entryA. with the Auto Complete feature B. with the F3 key C. with the AutoText subcommand on the insert menu D. a, b and c |
Q40 When you create an Auto text entryA. you can save it with the current template B. you should keep the name short C. you must assign it a unique name D. a, b and c |
Q41 The auto Complete featureA. presents a tip box with contents you can insert by pressing the ENTER key B. checks the style of the document C. checks the readability of the document D. check the spelling in the document |
Q42 The Spelling and Grammar toolA. indicates grammatical errors B. corrects spelling errors as you type C. identifies words with capitalization problems D. a, b and c |
Q43 The Thesaurus toolA. finds repeated word on the document B. adds new words to the custom dictionary C. checks for misspelted words as you type D. none of the above |
Q44 The AutoCorrect toolsA. provides statistics about your document B. display words with the same or similar meaning C. check the grammar in the document D. check the misspelted words as you type and underlines them. |
Q45 Which of the following is not an option for changing the case of text?A. indent case B. sentence case C. toggle case D. uppercase |
Q46 Italicizing allows you to emphasize text byA. adding a blinking background B. slanting the text to the left C. placing the text above the baseline D. slanting the text to the right |
Q47 Character spacing option are found in theA. Auto Text dialog box B. formatting dialog box C. Autocorrect dialog box D. none of the above |
Q48 The bold, Underline, and Italic buttons on the Formatting toolbarA. apply formats that emphasize text. B. are toggle switches that apply or remove formats C. are turned on by defaults D. a and b. |
Q49 You can apply a double underline to text withA. the underline list box in the Fond dialog box B. the underline button on the Formatting toolbar C. the Subscript option in the Font dialog fox D. none of the above |
Q50 When you use the Repeat command on the Edit menu to repeat formats applied from the Formatting toolbarA. only the last format is applied B. the text is changed to uppercase C. none of the formats are repeated D. all the formats are repeated |
Q51 You can copy character formats byA. using the True Type fonts B. selecting the text and pressing the DELETE key C. using the Find command on the Edit menu D. using the Format Painter tool |
Q52 Typeface reffer toA. the dencity of the characters B. the design and appearance of the characters C. the slant of the characters D. the height of the characters |
Q53 Which of the following is not a tab-stop alignment?A. Bar B. Decimal C. Justify D. Right |
Q54 Header and footers areA. text that appears only in Print Preview B. text that appears on every page above or below the body text C. text that appears only in Online Layout view D. none of the above |
Q55 Which of the following is not paragraph formatting?A. Alignment B. Line spacing C. margins D. Boldface |
Q56 You can indent selected text byA. clicking the Decrease indent button B. clicking the increase indent button C. dragging an indent marker on the horizontal ruler D. all of the above |
Q57 You can display margins in text on the horizontal or vertical ruler with the mouse endA. the ALT key B. the Front Size button C. The DELETE key D. the SPACEBAR |
Q58 Which of the following items is not a default setting?A. no headers or footers B. single line spacing C. Tabs every 0.25" D. Left text alignment. |
Q59 When you display your document in Full Screen viewA. You cannot use the menu or shortcut menu commands B. you see the Previous Page and Next Page buttons C. the title bar, status bar, menu barm scroll bars, taskbar and toolbars are displayed. D. you can view more typing area in your document |
Q60 Which of the following is not an editing view?A. Online Layout view B. Full Screen view C. Format view D. Normal view |
Q61 Which of the following options is not an option in the Print dialog box?A. Print selected pages B. Print selected text C. Set the paper orientation D. print to file |
Q62 You can view and change print options by clicking theA. Set Print options button in the Print dialog box B. Print Options command on the Print Preview menu C. Option commands on the Tools menu D. Print commands on the File menu |
Q63 You can decrease your document by one page by using theA. shrink to Fit button B. Fiy to One Page button C. Magnifier button D. Minimize buttons |
Q64 To update a formula in a table, press theA. F9 key B. ALT+F9 key C. SHIFT+F9 key D. F8 key |
Q65 You can create a table withA. the insert table button on the Standard toolbar B. the Draw table command on the table menu C. The Insert Table command on the Table menu D. a and d |
Q66 You can move the insertion point in a tableA. with the UP ARROW and DOWN ARROW keys B. with the SHIFT+TAB keys C. with the TAB key D. all of the above |
Q67 A tableA. is a grid organized in columns and rows B. is a method of organising data in your document C. can be created and modified with a button on the Standard toolbar D. b and c |
Q68 The four types of Mail Merge main documents areA. Form Letters, Directories, Cataloge and Envelopes B. From Letters, Envelopes and Mailing lables, Directories, and Lists C. Basic Letters, Envelopes, lables, and Lists D. From Letters, Envelopes, Mailing Lables, and Catalog. |
Q69 Which of the following is not of the merge process?A. Preview the merge results B. Format a main document C. Edit a data source D. Create a data source |
Q70 In the merge process, you canA. preview a merge B. merge directly to a printer C. merge to a new document D. a, b and c |
Q71 Data fieldsA. may be left empity B. separate data into many logical parts C. may contain multiple lines of the text D. all of the the above |
Q72 A data source consists ofA. header row B. data fields C. data records D. all of the above |
Q73 Which of the following is not part of the merge process?A. date dield B. merge fields C. data sources D. main document |
Q74 you can print only an embedded chart byA. moving the chart toa chart sheet before you print B. formatting the chart before you print C. selecting the chart before you print D. a and c |
Q75 Data markers on a chart are linked to data points in a worksheets, therefore,A. you can automatically apply formatting to a data series B. you can change the position of a data marker and automatically change the data point value in the worksheet C. you can change a data point value and automatically redraw the chart D. a and b |
Q76 To select an individual data marker or data label, you mustA. double-click the data series B. right-click the selected marker C. double-click the marker or label D. none of the above |
Q77 using the F11 shortcut key to create a chart on a chart sheet createsA. a defaut chart B. a 2-dimensional column chart C. a 2-dimensional bar chart D. a 3-dimensional line chart |
Q78 You can create hyperlinks from an Excel workbook toA. a Web page on company Intranet B. a Web page on the Internet C. other Excel workbooks D. all of the above |
Q79 To drag a selected range of data to another worksheet in the same workbook, use theA. TAB key B. ALT key C. SHIFT key D. CTRL key |
Q80 You can group noncontiguous worksheets withA. The Group button on the Standard toolbar B. The SHIFT key and the mouse C. The CTRL key and the mouse D. none of the above |
Q81 When you group worksheetsA. you can enter variable data on multiple worksheets at one time B. you can print more than one worksheet at a time C. you can enter common data, formats, and formulas on multiple worksheets at one time D. b and c |
Q82 The drag-and-drop-method of copying or moving dataA. can we used betwwn worksheets but not workbooks B. can be used between workbooks but not worksheets C. can be used between worksheets D. c and d |
Q83 A 3-D reference in a formulaA. cannot be modified B. only appears on summary worksheets C. limits the formatting options D. spans worksheets |
Q84 Which of the following methods cannot be used to edit the contents of a cell?A. pressing the ALT key B. clicking the formula bar C. pressing the F2 key D. none of the above |
Q85 Which of the following methods cannot be used to enter data in a cell?A. pressing an arrow key B. pressing an TAB key C. pressing an ESC key D. pressing an ENTER key |
Q86 You can use the horizontal and vertical scroll bars toA. split a worksheets into two panes B. view different rows and columns C. edit the contents of a cell D. none of the above |
Q87 When the formula bar is activated, you can seeA. the edit Formula button B. the Cancel button C. the Enter button D. all of the above |
Q88 Status indicators are located on theA. vertical scroll bar B. horizontal scroll bar C. formula bar D. standard toolbar |
Q89 You can activate a cell byA. pressing the TAB key B. clicking the cell C. pressing an arrow key D. all of the above |
Q90 Each Excel file is callled a workbook becauseA. it cfan contain text and data B. it can be modified C. it can contain many sheets including worksheets and chart sheets D. you have to work hard to create |
Q91 Which of the following is not a basic step in creating a worksheet?A. save the workbook B. modify the worksheet C. enter text and data D. copy the worksheet |
Q92 Tab scrolling buttonsA. allow you to view a different worksheet B. allow you to view additional worksheet rows down C. allow you to view additional worksheet columns to the right D. allow you to view additional sheet tabs |
Q93 The name BoxA. Shows the location of the previously active cell B. appears to the left of the formula bar C. appears below the status bar D. appear below the menu bar |
Q94 Documentation should includeA. destination and users of the output data B. source of input data C. information on the purpose of the workbook D. all of the above |
Q95 which of the following is not a worksheet design criterio?A. efficiency B. auditibility C. description D. clarity |
Q96 to center worksheet titles across a range of cells, you mustA. select the cells containing the title text and use the fill handle to center the text across a range of cells B. widen the columns C. select the cells containing the title text plus the range over which the title text is to be centered D. format the cells with the Comma Style |
Q97 You can use the formula palette toA. format cells containing numbers B. create and edit formulas containing functions C. enter assumptions data D. copy a range of cells |
Q98 to activate the previous cell in a preselected range,pressA. the ALT key B. the TAB key C. the Enter key D. none of the above |
Q99 you can select a single range of cells byA. clicking the upper -left cells in a group of cells and then pressing the SHIFT key while clicking the lower-right cell in a group of cells B. pressing the CTRL key while dragging over the desired cells C. pressing the SHIFT key and an arrow key D. dragging over the desired cells |
Q100 rounding errors can occurA. when you use multiplication,division,or exponentiation in a formula B. when you use addition and subtraction is a formula C. because Excel uses hidden decimal palces in computation D. when you show the results of formula with different decimal palces than the calculated results |
Q101 the autocalculate featureA. can only add values in a range of cells B. provides a quick way to view the results of an arithmetic operation on a range of cells C. automatically creates formulas and adds then to a worksheet D. a and c |
Q102 which of the following is correct order of precedence in a formula calculationA. multiplication and divison,exponentiation,positive and negative values B. multiplication and division,positve and negative values,addtion and aubtraction C. addtition and subtraction,positie and negative values,exponentiation D. none of the above |
Q103 in a worksheet you can selectA. the entire worksheet B. rows C. columns D. a,b and c |
Q104 the autofill featureA. extends a sequential series of data B. automatically adda a range of cell values C. applies a border aroud selected cells D. none of the above |
Q105 you can copy data of formulasA. with the copy,paste wnd cut commands on the edit menu B. with commands on a shortcut menu C. with button on the Standard toolbar D. a,b,cand d |
Q106 to view a cell commentA. click the edit comment command on the insert menu B. click the display comment command on the window menu C. position the mouse pointer over the celll D. click the comment command on the view menu |
Q107 to hold row and column titles in place so that they do not scroll when you scroll a worksheet,click theA. unfreeze panes command on the window menu B. freeze panes command on the window menu C. hold titles command on the edit menu D. spilt command on the window menu |
Q108 to copy cell contents using drag-and-drop press theA. END key B. SHIFT key C. ESC key D. none of the above |
Q109 you can use the format painter multiple times before you turn it off byA. you can use the format painter button only one time when you click it B. double-clicking the format painter button C. pressing the CTRL key and clicking the format painter button D. pressing the ALT key and clicking the format painter button |
Q110 it is acceptable to let long text flow into adjacent cells on a worksheet whenA. data willl be entered in the adjacent cells B. no data will be entered in the adjacent cells C. there is no suitable abbreviation for the text D. there is not time to format the text |
Q111 you can use the drag-and-drop method toA. copy cell contents B. delete cell contents C. add cell contents D. a and d |
Q112 to insert three columns between column D and E,you wouldA. select column D B. select column E C. select column E,F and G D. select columns D,E and F |
Q113 which of the following is not an underline option in the format cells dialog boxA. double B. single engineeriing C. single accounting D. double accounting |
Q114 weight refers toA. the print density of characters B. the height of the printed characters C. upright or slanted shape D. the design and appearance of characters |
Q115 which of the following is not an option in the spelling dialog boxA. edit B. ignore C. ignore all D. change |
Q116 you can create only a horizontal page break by first selectingA. a row below the row where you want the page break to occur B. a cell in row 1 C. a cell in column A D. a and c |
Q117 when working in page break preview you canA. view exactly where each page break occurs B. add or remove page breaks C. change the print area D. a,b and c |
Q118 when you work with large worksheets, you may need toA. size the worksheet to fit on a specific number o f pages B. add abd remove page breaks C. specify only certain print areas D. a,b,and c |
Q119 the default header for a worksheet isA. your name B. the date and time C. none D. the sheet tab name |
Q120 you can zoom a worksheetA. with the mouse pointer in print preview B. with the Zoom button on the print preview toolbar C. with the zoom command on the view menu D. a,b,and c |
Q121 which of the following setup options cannnot be set in the page setup dialog boxA. printer selection B. vertical or horizontal placement C. orientation D. row and column titles |
Q122 when you print preview a worksheetA. the entire worksheet is displayed B. the selected range is dispalyed C. the active portion of the worksheet is displayed D. a.b.and c |
Q123 when creating a vertical page breakA. the active cell must be A1 B. the active cell can be anywhere in the worksheet C. the active cell must be in row 1 D. the active cell must be in column a |
Q124 gridlinesA. may be turned off for display but turned on for printing B. may be turned on or off for printing C. may be turned off for display and printing D. a,b,and c |
Q125 you can printA. a range of cells by range name B. an entire workbook C. a single worksheet D. all of the above |
Q126 the chart wizardA. can place a chart on a new chart sheet or an any sheet in the workbook B. can only place a chart on a new chart sheet C. can only place a chart on a new blank worksheet D. can only be used to create embedded charts |
Q127 graphic objects on a chart are used toA. add emphasis to chart data B. add interest to a chart C. help explain the chart data D. a.b and c |
Q128 when you use the fill effects in the format data series dialog box you cannnotA. rotate text on the chart B. select a foreground color C. select a pattern D. select a background color |
Q129 you can insert labels forA. all the data markers on a chart B. a data series C. a selected data marker D. a,b and c |
Q130 chart tips canA. show the formatting of a data label B. show the name of a data series C. show the value of a data point D. b and c |