UPWORK TEST » September 26, 2015

Daily Archives: September 26, 2015

Upwork Computer Skills

MS Word 2003 Test 2016

Published by:

1. In Word 2003, the two primary graphic categories are:

Answers:

  1. charts
  2. drawing objects
  3. AutoShapes
  4. pictures
  5. Clip Art

2. The figure shows the Save As dialog box under the File menu. The Save As Type has been specified as XML Document and the Apply transform option has been checked (selected). What does this mean?

Answers:

  1. It allows you to attach a custom schema to apply custom XML tags and discard Word formatting, saving only the custom data.
  2. It allows you to save XML files automatically while working.
  3. It allows you to change the author name for that XML file.
  4. You can apply XSLT when you save an XML document by selecting the Apply transform check box and browsing to the XSLT file.

3. When you press the TAB key, the cursor moves 1/2 inch across the page and an arrow appears on the screen. This is a default setting. How can you change this setting?

Answers:

  1. Press CTRL+ ALT; change the Tab stop position settings. Press OK.
  2. Choose File > Tabs from the menu; change Tab Stop Position. Click Set.
  3. Choose Format > Tabs from the menu. In the “Default tab stops” box, enter the amount of spacing you want between tab stops.
  4. Choose the Tabs position in the Format menu; change Default Tab Stop Position. Click Exit.
  5. Press SHIFT+TAB. Change the default settings in the Tab Stop Position field. Press Set.

4. How can you resize the width or height of a picture in a Word 2003 document? Select all of the answers below that apply.

Answers:

  1. By dragging the sizing handles that appear at the edges of the picture.
  2. By altering the height and width values on the “Size” dialog box available from the Format > Picture menu.
  3. By scaling the height and width in the “Picture position” tab available at the Edit > Graphics menu.
  4. By right-clicking on the picture and, from the Format Picture floating menu, choose the “Size” tab.

5. What is the function of hanging indents in Microsoft Word 2003?

Answers:

  1. The Hanging Indent feature indents each line except the last line by the amount specified in the By field.
  2. The Hanging Indent feature indents the last line by the amount specified in the By field.
  3. The Hanging Indent feature indents each line except the first line by the amount specified in the By field.
  4. The Hanging Indent feature indents all the highlighted lines by the amount specified in the By field.
  5. The Hanging Indent feature right indents the first line by the amount specified in the By field.

6. Can you insert a new table inside a cell of an existing table in your Word 2003 document?

Answers:

  1. Yes
  2. No

7. What is the method to disable the Reading Layout feature and open documents in the default (Print Layout)?

Answers:

  1. Press the ALT+F5 keys; choose the View option from the menu. Uncheck the Reading Layout check box. Click OK.
  2. Click the Tools menu; select Options and then choose Customize. Undo the Reading Layout feature.
  3. Click on the View menu and choose the Compatibility option; uncheck “Permit Starting in Reading Layout.”
  4. Click the Tools menu and choose Options; when the Options multi-tabbed dialog box appears, click General. Uncheck “Allow Starting in Reading Layout.” Click OK.

8. State whether the following statement is True or False.
It is possible to add custom words to the dictionary that Word 2003 uses to check spelling errors in document.

Answers:

  1. True
  2. False

9. When you choose the Split option in the Window menu, the window gets split into two. How can you return to the original state (i.e., back to a single window)?

Answers:

  1. Left click on the Window menu and choose Remove Split.
  2. Left click on the Edit menu and choose Undo Split.
  3. Left click on the Window menu and choose Delete Split.
  4. Left click on the Tools menu and choose Remove Split.
  5. Left click on the Window menu and choose Split Window.

10. How can you right-align a paragraph by using shortcut keys?

Answers:

  1. Select the paragraph. Press SHIFT+R.
  2. Select the paragraph. Press F3.
  3. Select the paragraph. Press SHIFT+CTRL+R.
  4. Select the paragraph. Press CTRL+ALT+R.
  5. Select the paragraph. Press CTRL+R.

11. Which font effect has been applied on the text shown in the figure?

Answers:

  1. Superscript
  2. Subscript
  3. Shadow
  4. Emboss
  5. Strikethrough
  6. Engrave
  7. Double strikethrough

12. State whether the following statement is True or False.
Once a macro is running, it is not possible to stop it.

Answers:

  1. True
  2. False

13. State whether True or False.

You can open the Find and Replace dialog box by pressing the CTRL + F key combination.

Answers:

  1. True
  2. False

14. How can you create a box around the text that is placed on a web page, as shown in the figure?

Answers:

  1. Place the text in a table and give the table a boundary.
  2. Choose the “Box” option under the menu Format > Borders and Shading > Borders.
  3. Right-click on the selected text and choose “add boundary” in the text properties.
  4. Draw a rectangle around the text using the rectangle drawing tool.

15. What is thesaurus used for?

Answers:

  1. Spelling options
  2. Grammar options
  3. Synonyms and Antonyms
  4. Opposite words
  5. Different options for spelling the word

16. What does CTRL+Left Arrow key accomplish in Word 2003?

Answers:

  1. It exits the currently open window.
  2. It adds a page break to the document.
  3. It makes the cursor move backwards (i.e., to the left) “word by word” in the document.
  4. It initiates the spell check procedure.
  5. It inserts a new table into the document.

17. What will you do to print an A5-size (148mm x 210mm) document on A4-size (210 x 297mm) paper?

Answers:

  1. Scale the font size of the text by the required percentage: e.g., the A5 size is 30% smaller, than the A4 size, so scale the font size to 142% and print the document.
  2. Select File > Print. Under Zoom, specify the paper size in the”Scale to Paper Size” list as A4.
  3. On the Format menu, click Print. Under Paper, click the A4 option in the “Scale to paper Size” box.
  4. Choose the option Allow A4/Letter paper resizing in the Print Options available at the menu File > Print.

18. The title bar is present at the top of the Microsoft Word 2003 window. What does it contain at the left corner?

Answers:

  1. Alignment Icon
  2. Edit window
  3. Office Clipboard
  4. Application icon
  5. Maximize Button

19. The figure shows the Character Spacing tab options under the menu Format > Fonts. The Scale has been set at 200%. What effect does this have on the text?

Answers:

  1. The spacing between the characters in the text increases by 200%.
  2. The spacing between the characters in the text decreases by 200%.
  3. The font size of the characters in the text increases by 200%.
  4. The characters in the text are stretched horizontally by 200%.
  5. The characters in the text are stretched vertically by 200%.

20. What does the CTRL+I shortcut accomplish in Word 2003?

Answers:

  1. It converts the selected text into the next larger size of the same font.
  2. It adds a line break to the document.
  3. It makes the selected text bold.
  4. It applies italic formatting to the selected text.
  5. Picture toolbar

21. How can you change the font of a text?

Answers:

  1. Select the text and choose Format > Font from the menu.
  2. Select the text and choose Tools > Font from the menu.
  3. Press the F4 key and choose the Font from the drop down list.
  4. Press ALT+O and choose Format > Font from the menu.
  5. Select the text and press CTRL+O to reach the Font Type window.

22. In which view are thumbnails not available in Word 2003?

Answers:

  1. Web Layout view
  2. Reading Layout view
  3. Normal view
  4. Print Layout view

23. The figure shows the Edit tab under the Tools > Options menu. The “Enable click and type” option has been checked. What function does this option perform?

Answers:

  1. It allows you to quickly insert text, graphics, tables, or other items in a blank area of a document.
  2. It enables automatic formatting of paragraphs in the document by double clicking on the paragraph.
  3. It automatically inserts a chosen graphic or icon wherever the user double-clicks on the document.
  4. It performs a spell check of the word that has been double-clicked.
  5. It automatically creates a table and inserts the document text into various cells according to how it has been formatted with commas and semicolons.

24. If the word “trick” is displayed on the screen, with the cursor between the letters ‘i’ and ‘c’ and the Delete key is pressed once, how will said word appear on the screen?

Answers:

  1. trik
  2. rik
  3. tr
  4. trck
  5. trick

25. A paragraph can be made to stand out from the rest of the document by giving it a border or shading. How can you give a (selected) paragraph a special shade?

Answers:

  1. Select Format > Borders and Shading. Select the Page Border tab. Select the Color and click OK.
  2. Select View > Borders and Shading. Select the Coloring tab. Select the Color and click OK.
  3. Select Format > Borders and Shading. Select the Shading tab. Select the Color and click OK.
  4. Select Insert > Borders and Shading; Select Shading tab. Select the Color you want to shade the paragraph with and Click OK.

26. Can you change the background picture of a Word 2003 Theme that has been applied to a page?

Answers:

  1. Yes
  2. No

27. How can you convert the whole document into uppercase if you have it typed in lowercase?

Answers:

  1. Select the document text and choose the “All caps” option under the menu Format > Style.
  2. Select the document text and choose “Corporate” under the menu Format > Theme.
  3. Select the document text and select the “All caps” check box in the Font dialog box after first selecting Format > Fonts.
  4. Select the document text and choose the “UPPERCASE” option in the Change Case dialog box after first selecting Format > Change Case from the menu.
  5. There is no such option available in Word 2003.

28. State whether True or False.
In a Word 2003 document, if the formatting is restricted, the commands and keyboard shortcuts that apply formatting directly are not available.

Answers:

  1. True
  2. False

29. What is the function of AutoSummarize feature in Word 2003?

Answers:

  1. It creates a 250-word, 500-word, or 1000-word summary of the document.
  2. It adds automatic headers, bold and italic characters, as well as automatic formatting of the document, to give the look of a well summarized document.
  3. It summarizes the statistics of the document into a report, such as total words, total characters, total pages, total paragraphs, file size, etc.
  4. It identifies the key points in a document for you to share with others or quickly scan.

30. How can you hide the Clipboard icon from popping up on the Windows taskbar?

Answers:

  1. Select Insert > Office Clipboard; click on Symbol. Uncheck “Show Office Clipboard Icon on Taskbar.”
  2. Choose Table > Formula; click on the Options button. Uncheck “Show Office Clipboard Icon on Taskbar.”
  3. Choose Edit > Office Clipboard; click on the Options button. Uncheck “Show Office Clipboard Icon on Taskbar” and “Show Status Near Taskbar When Copying.”
  4. Press ALT+R key; click on the Clipboard button. Undo “Show Office Clipboard Icon on Taskbar.”

31. What is a watermark?

Answers:

  1. A watermark is any text or graphic image that is printed to overlap existing text in a document, either in the background or foreground.
  2. A small icon that is automatically printed on the footer of a page to indicate that the page must be edited before saving.
  3. An area on the left side of a page that increases the overall left margin. This space is required for binding the document after printing.
  4. An image or picture anywhere in the document that links to a Web page on the Internet.
  5. A small mark that appears next to the text on the page. Placing the mouse pointer over the text displays comments related to the text.

32. The figure shows the Margins tab under the File > Page Setup menu. The gutter margin has been set at 0.1″. What is a gutter margin?

Answers:

  1. Some extra space added to the right margin of the page required for cutting the page into even sizes at the time of binding.
  2. Some extra space added to the left margin of the page required for binding the document.
  3. A maximum limit set for editing the left margin so that it is not decreased beyond a certain limit.
  4. A maximum limit set for editing the right margin so that it is not increased beyond a certain limit.
  5. A bottom margin set for all pages that are required for footnotes.

33. What does the Format Painter icon look like in the Formatting Toolbar?

Answers:

  1. Like a book
  2. Like a brush
  3. Like an arrow
  4. Like a twisted arrow

34. How can you create a non-breaking hyphen?
Answers:

  1. Press ALT+SHIFT+H.
  2. Press CTRL+HYPHEN.
  3. Press CTRL+SHIFT+HYPHEN.
  4. Press ALT+CTRL+HYPHEN.
  5. None of the Above.

35. Normally, when you click on the File menu, Microsoft Word 2003 shows you the names of the last four files used. How can this list be increased?

Answers:

  1. Choose the Office Clipboard option in the File menu; click Security and “Recently Used File List.”
  2. Under Tools > Options; click the General tab. Increase the number on the “Recently Used File List” option.
  3. Choose the Page Numbers option from the Insert menu; go to the “Recently Used List.” Increase the number and click OK.
  4. Go to the Tools menu; select “Recently Used List.” Increase its number and click Exit.
  5. Select Arrange All in the Window menu option; choose Recent List and press Set.

36. The figure shows the Drop Cap menu option. What function does this option perform?

Answers:

  1. It does not allow capital letters to be used in the document.
  2. It does not allow capital letters to be used in the document apart from the first letter of any sentence.
  3. It lets you begin a paragraph with a large dropped initial capital letter.
  4. It automatically starts all paragraphs and sentences with capital letters.
  5. It provides options for converting all uppercase text to lowercase text.

37. If you want to copy and paste some formatted text so that the text becomes unformatted where it is pasted, you could perform a ________ operation.

Answers:

  1. Setting the Page
  2. Hyper Text
  3. Paste Unformat
  4. Paste Special
  5. Post Special

38. What does the CTRL+U shortcut accomplish in Word 2003?

Answers:

  1. It underlines the selected word.
  2. It converts the selected word to uppercase.
  3. It undeletes the last deleted word.
  4. It undoes the last action performed in Word 2003.

39. The figure shows the print options under the menu File > Print. The “Print data only for forms” option is unchecked (not been selected). What does this mean?

Answers:

  1. It allows for printing of the complete online form along with the data in the form.
  2. It allows for printing of the online form only along with its data, and does not print anything else on the document.
  3. It allows for printing of the data in an online form as a table. Each entry in the form is printed as a row in the table.
  4. It allows for printing of the data entered into an online form without printing the online form.

40. How can you insert a sound file in a Word 2003 Document?

Answers:

  1. From the Insert > Object menu option.
  2. From the Insert > Sound menu option.
  3. From the Insert > File menu option.
  4. By right-clicking on the document and choosing the “Add sound” option.

41. The given figure shows the Reviewing toolbar. What function is performed by the button marked by the letter X?

Answers:

  1. It allows you to jump to sections in a document.
  2. It allows you to insert comments in a document.
  3. It allows you to highlight the selected text or graphic in a document.
  4. It allows you to track changes in a document.

42. What does the CTRL+B shortcut accomplish in Word 2003?

Answers:

  1. It converts the selected text into the next larger size of the same font.
  2. It adds a line break to the document.
  3. It makes the selected text bold.
  4. It adds a segment break to the document.

43. Can you give a 3-D (3-Dimensional) effect to your text and graphics using Word 2003?

Answers:

  1. Yes
  2. No

44. In Microsoft Word 2003, you can easily create bulleted or numbered lists of items. What is the method for removing the numbering?

Answers:

  1. Select Bullets and Numbering in the Tools menu; choose the Undo option. Click Exit.
  2. Highlight the numbered list; choose Format > Bullets and Numbering from the menu and click None. Click OK.
  3. Press CTRL+O key; select Remove Numbering from the given menu options. Press OK.
  4. Select the Numbering List; right click and choose the Undo Numbering option. Click OK.

45. In the figure, the words “fox jumped” appear lower than the rest of the words in the sentence. Which effect has been applied to these words?

Answers:

  1. Superscript
  2. Lowered
  3. Subscript
  4. Shadow
  5. Laid down

46. State whether True or False

You create a table in Word 2003 and enter some values in various cells and save the document. Later, you decide to delete the table. If you directly try to delete the table, Word 2003 will first prompt you to delete the various values in the cells.

Answers:

  1. True
  2. False

47. What is a Tab Stop in Word 2003?

Answers:

  1. A setting that disables the use of the Tab key while working on a document.
  2. A setting that disables the use of the Shift+Tab key combination while working on a document.
  3. A position you set for placing and aligning text on a page.
  4. The point at which one page ends and another begins.

48. What are bookmarks used for?

Answers:

  1. To quickly jump to a specific location in the document.
  2. To add hyperlinks in a web page.
  3. To add anchors in a web page.
  4. To mark the ending of a page of the document.
  5. To mark the ending of a section of the document.

49. A graphic contained within a table cell would be properly formatted with the _____________ wrapping layout option if you see the ______________ when the graphic is selected. This layout option is usually the default. However, when you paste a graphic from another application than Word, you may have to properly set this option.

Answers:

  1. “Tight”, circular blue handles with a single-line red border
  2. “In line with text”, square black handles with a single-line black border
  3. “Square”, square blue handles with a double-line red border
  4. “Square”, circular blue handles with a double-line black border

50. Frames and text boxes are containers for text that can be positioned and sized on a page. Which of those two containers should you use in Word 2003 when your text or graphics contain comments, footnotes, or endnotes?

Answers:

  1. Frames
  2. Text boxes
  3. Either

51. What is a page break in Word 2003?

Answers:

  1. An instruction to the printer to print a new page.
  2. The point at which one page ends and another page begins.
  3. It refers to dividing a page into two parts vertically.
  4. It refers to dividing a page into two parts horizontally.
  5. It refers to Word 2003 automatically breaking the continuity of a block of text by adding headers, bold faced characters and breaking the text into new paragraphs.

52. The figure shows the Size tab options available from the Format > Picture menu. The “Lock aspect ratio” box is checked. Which of the following statements is true about the “Lock aspect ratio” setting?

Answers:

  1. You should select this box if you want to preserve the height-to-width proportions.
  2. If you select this box and then enter a pixel value in either the Width or Height box, Word 2003 will automatically change the value in the other box to preserve the graphic’s proportions.
  3. You can stretch the image to any extent if you do not select this option.
  4. Checking this option helps keep the image size the same when you stretch or reduce the image.

53. There are over a hundred predefined formatting styles in Word 2003 to choose from. However, only a small number of them are displayed in the default list of styles. If you want to see all formatting styles (both predefined and customized), you could:

Answers:

  1. Press the SHIFT key and click the arrow on the Style drop-down menu button on the Formatting toolbar.
  2. Select Formatting and Styles from the Styles menu. Then select “All Styles” from the Show options in the Formatting and Styles task pane.
  3. Press the CTRL key and click the arrow on the Formatting drop-down menu button on the Styles toolbar.
  4. Select Styles and Formatting from the Format menu. Then select “All Styles” from the Show options in the Styles and Formatting task pane.

54. How can you make letters bold?

Answers:

  1. By clicking on the Bold icon in the formatting toolbar.
  2. By Pressing ALT+B.
  3. By Pressing CTRL+B.
  4. By highlighting the desired text and choosing the AutoCorrect function in the Tools menu.

55. In the Print dialog box, the default option for the “Print what” field is Document. Which one of the following is not one of the six other “Print what” options?

Answers:

  1. Document properties
  2. Document showing markup
  3. List of markup
  4. List of graphics
  5. Styles
  6. AutoText entries
  7. Key assignments

56. The figure shows the horizontal ruler. What has been marked by the red arrow?

Answers:

  1. The indent marker
  2. The hanging indent marker
  3. The second line indent marker
  4. The paragraph indent marker
  5. The cascading indent marker

57. How can you spell check your entire Microsoft Word 2003 document?

Answers:

  1. Press F7 or click the Spelling icon on the Standard toolbar.
  2. Press F4 and click the Grammar icon.
  3. Choose Window > Spelling and Grammar.
  4. Choose Tools > Spelling and Grammar.
  5. Press the ALT+F6 key.

58. How can you redo the last performed action in Word 2003?

Answers:

  1. Press the CTRL+Y key.
  2. Press the SHIFT+X key.
  3. Choose Redo Action from the Window menu.
  4. Press the F9 key.
  5. None of the Above

59. What are sections used for in a Word 2003 document?

Answers:

  1. They are used to divide the document into parts so that each part may be independently printed when the print command is given.
  2. To divide the document into parts so as to allow certain parts of the document to display data from a table.
  3. To divide the document into parts so as to allow certain parts of the document to display data from the Internet.
  4. To vary the layout of a document within a page or between pages by dividing the document into parts, and then to allow formatting of each part the way you want.
  5. To vary the layout of a document within a page or between pages by dividing the document into parts, with the purpose of applying a different Word 2003 theme to each part.

60. The figure shows the Word 2003 formatting tools marked from (a) to (i) that are available in the formatting toolbar. Which tool has been used on the text shown on the picture?

Answers:

  1. Tool (a)
  2. Tool (c)
  3. Tool (g)
  4. Tool (h)
  5. Tool (e)

61. Which of the following Windows opens when you press the Shift + F1 key?

Answers:

  1. AutoSave
  2. Reveal Formatting
  3. Convert
  4. Auto Select
  5. Draw Table

62. Which feature of Word 2003 allows you to use information from two different files for the quick creation of personal correspondence and other documents like interview letters and invitations?

Answers:

  1. AutoComplete
  2. AutoSummarize
  3. Mail Merge
  4. Web Mail
  5. Mail Manager
  6. File Mail Manager

63. How are spelling errors displayed in Word 2003?

Answers:

  1. The errors are highlighted by a green wavy line.
  2. The word with the wrong spelling has a strikethrough font.
  3. The errors are highlighted by a red wavy line.
  4. The color of the word with the wrong spelling will change to red.

64. The figure shows the “Indents and Spacing” tab options under the menu Format > Paragraph. The Line spacing has been set at “Exactly”. What does this mean?

Answers:

  1. The line spacing is fixed, and Word 2003 does not adjust it. This option does not space all lines evenly.
  2. Word 2003 sets the line spacing at exactly one-and-one-half times that of single line spacing.
  3. Word 2003 accommodates the largest font in that line, plus a small amount of extra space depending upon the font used.
  4. The line spacing is fixed, and Word 2003 does not adjust it. This option spaces all lines evenly.

65. Which function key will allow you to check the spelling of the complete document if you have not changed the shortcut key’s settings?

Answers:

  1. F1
  2. F2
  3. F3
  4. F4
  5. F5
  6. F6
  7. F7
  8. F9

66. You want to view a document in the Reading Layout view. What will you do?

Answers:

  1. Click the Read button on the Standard toolbar.
  2. Press ALT+R.
  3. Press ALT+L.
  4. Select Reading Layout under the Edit -> Go To menu option.

67. Which Word 2003 toolbar is shown in the figure?

Answers:

  1. Forms toolbar
  2. Formatting toolbar
  3. Autotext toolbar
  4. Tables and Borders
  5. Database toolbar
  6. Drawing toolbar

68. Which of the following short cuts will open an existing file?

Answers:

  1. CTRL+N
  2. CTRL+A
  3. ALT+X
  4. CTRL+O
  5. ALT+SHIFT+N

69. Which of the following are valid sources for storing the addressee information required for Word 2003 mail merge?

Answers:

  1. Word 2003
  2. MS Access
  3. MS Outlook
  4. MS Excel
  5. All of the above

70. You are required to make a form in Word 2003. You require certain parts of the form to be protected against changes made by the end user and certain parts to be editable. How could you achieve this?

Answers:

  1. Add sections to the form, and choose which sections you would like to protect from the end user. You can make this choice at the menu Tools > Protect document.
  2. Add Page breaks to the form, and choose which Page breaks you would like to protect from the end user. You can make this choice at the menu Tools > Protect document.
  3. Mark the unprotected parts of the form by using ** and /** characters and protect the whole form from the menu Tools > Protect document.
  4. Mark the unprotected parts of the form by using && and /&& characters and protect the whole form from the menu Tools > Protect document.
  5. Select the parts of the form that you do not want to protect, and choose Tools > do not protect. After completing this, protect the whole form from the menu Tools > Protect document

71. Which one of the following is a shortcut for going to the beginning of a column in the same column in a Table?

Answers:

  1. ALT+PageUp
  2. ALT+X
  3. SHIFT+F7
  4. CTRL+O
  5. ALT+TAB

72. When you right-click on a cell of a table drawn in a Word 2003 document, you can see the properties and options as shown in the figure. The Split Cells option has been highlighted in the figure. What is the function of this option?

Answers:

  1. It divides an existing cell horizontally into 2 equal cells.
  2. It divides an existing cell vertically into 2 equal cells.
  3. It allows you to divide an existing cell of a table into more rows and columns.
  4. It allows you to merge 2 or more existing cells with one another.

73. When you left-click on the Insert menu option and click Page Numbers, a pop up window opens. Which of the following options is/are available in the pop-up menu?

Answers:

  1. Styles and Formatting
  2. Break
  3. Position
  4. Layout
  5. Alignment

74 Which Task Pane of Word 2003 is shown in the given figure?

Answers:

  1. XML Structure task pane
  2. Protect Document task pane
  3. Shared Workspace task pane
  4. IRM task pane

75. You are required to prepare an essay in Word 2003 consisting of only 250 words. What is the most convenient way for you to count the total number of words in your document?

Answers:

  1. First justify the document (both left and right justified), then count the number of words on one line and multiply them by the number of lines.
  2. Select the text whose words you require to count and right-click the mouse button. Choose the “Word Count” option.
  3. Choose the “Word Count” option under the Tools menu.
  4. Choose the “Paragraph statistics” option under the View menu.
  5. Count each word one by one. There is currently no tool available for counting the number of words.

76. Wrapping styles can be used to modify the layout of text in relation to a graphic. Which style wraps the text around a graphic in an irregular shape bounding the actual image? (The graphic will move as text is added or deleted.)

Answers:

  1. In front of text
  2. Square
  3. Behind text
  4. In line with text
  5. Tight

77. In documents having many paragraphs, the appearance of the documents can be improved by increasing the spacing between paragraphs. Where in Word, is the built-in option that allows you to add such space?

Answers:

  1. Click on Insert > Paragraph; go to the Spacing section and change the “Before” and “After” fields.
  2. Click on Format > Paragraph; go to the Spacing section and change the “Before” and “After” fields.
  3. Click on Format > Theme; go to the Spacing section and change the “Before” and “After” fields.
  4. Press ALT+X; click on the Spacing menu; change the line spacing measurements.

2,990 total views, 1 views today

Upwork Computer Skills

MS Word 2000 Test 2016

Published by:

1. You require to make a form in Word 2000. You require certain parts of the form to be protected against changes made by the end user and certain parts to be editable. How will you achieve this?

Answers:

  1. Add sections to the form, and choose which sections you would like to protect from the end user. You can make this choice at the menu Tools->Protect document/li>
  2. Add Page breaks to the form, and choose which Page breaks you would like to protect from the end user. You can make this choice at the menu Tools->Protect document
  3. Mark the unprotected parts of the form by using ** and /** characters and protect the whole form from the menu Tools->Protect document
  4. Mark the unprotected parts of the form by using && and /&& characters and protect the whole form from the menu Tools->Protect document
  5. Select the parts of the form that you do not want to protect, and choose Tools->do not protect. After completing this, protect the whole form from the menu Tools->Protect document

2. The figure shows the Word 2000 formatting tools marked from A to I which are available in the formatting toolbar. Which tool has been used on the text shown on the picture?

Answers:

  1. Tool A
  2. Tool C
  3. Tool G
  4. Tool H
  5. Tool E

3. Can you give a 3D (3 Dimensional) effect to your text and graphics using Word 2000?

Answers:

  1. Yes
  2. No

4. The figure shows the horizontal ruler. What has been marked by the red arrow?

Answers:

  1. The indent marker
  2. The hanging indent marker
  3. The second line indent marker
  4. The paragraph indent marker
  5. The cascading indent marker

5. You have to prepare an essay in Word 2000 consisting of only 250 words. What is the most convenient way for you to count the total number of words in your document?

Answers:

  1. First justify the document (both left and right justified), then count the number of words on one line, and multiply them by the number of lines
  2. Select the text whose words you require to count and right-click the mouse button. Choose the ‘Words count’ option
  3. Choose the ‘Words count’ option under the Tools menu
  4. Choose the ‘Paragraph statistics’ option under the View menu
  5. Count each word one by one. There is currently no tool available for counting the number of words

6. The figure shows the Size Tab options available at the menu Format->Picture. The ‘Lock aspect Ratio’ box is checked. Which of the following statements is true about the ‘Lock aspect Ratio’ setting?

Answers:

  1. You should select this box if you want to preserve the height-to-width proportions
  2. If you select this box and then enter a pixel value in either the Width or Height box, Word 2000 will automatically change the value in the other box to preserve the graphic’s proportions
  3. You can stretch the image to any extent if you do not select this option
  4. Checking this option helps keep the image size the same when you stretch or reduce the image

7. What is the function of AutoSummarize feature in Word 2000?

Answers:

  1. It creates a 250 word, 500 word or 1000 word summary of the document
  2. It adds Automatic headers, Bold and italic characters as well as automatic formatting of the document to give the look of a well summarized document
  3. It summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size etc
  4. It identifies the key points in a document for you to share with others or to help you scan them quickly

8. What are bookmarks used for?

Answers:

  1. To quickly jump to a specific location in the document
  2. To add hyperlinks in a web page
  3. To add anchors in a web page
  4. To mark the ending of a page of the document
  5. To mark the ending of a section of the document

9. The figure shows the Edit tab under the Tools->Options Menu. The ‘Tabs and backspace set left indent’ option has been checked. What function does this option perform if it is checked?

Answers:

  1. It sets the page indent from the left side of the page instead of the right side
  2. It fixes the left indent at zero and the TAB and BACKSPACE keys have no effect on indenting the text
  3. It increases and decreases the left indents when you press the TAB and BACKSPACE keys
  4. It fixes the left indent at 1 inch, and the TAB and BACKSPACE keys have no effect on indenting the text

10. Which font effect has been applied on the text shown in the figure?

Answers:

  1. Superscript
  2. Subscript
  3. Shadow
  4. Emboss
  5. Strikethrough
  6. Engrave
  7. Double strikethrough

11. Which Word 2000 toolbar is shown in the figure?

Answers:

  1. Forms toolbar
  2. Formatting toolbar
  3. Autotext toolbar
  4. Tables and Borders
  5. Database toolbar
  6. Drawing toolbar

12. What will you do to print an A5-size (148mm x 210mm) document on an A4-size (210 x 297mm) paper?

Answers:

  1. Scale the font of the text by the required percentage e.g. if A5-size is 20% smaller then A4-size, scale the font to 120% and print the document
  2. Specify Scale to paper size as A4 under the File->Print menu
  3. Specify paper size as A4 in the print properties available at the menu File->Print
  4. Choose the option Allow A4/letter paper resizing in the Print Options available at the menu File->Print

13. What does the CTRL+I shortcut accomplish in Word 2000?

Answers:

  1. It converts the selected text into the next larger size of the same font
  2. It adds a line break to the document
  3. It makes the selected text bold
  4. It applies italic formatting to the selected text
  5. Picture toolbar

14. The figure shows the Drop Cap menu option. What function does this option perform?

Answers:

  1. It does not allow capital letters to be used in the document
  2. It does not allow capital letters to be used in the document apart from the first letter of any sentence
  3. It lets you begin a paragraph with a large dropped initial capital letter
  4. It automatically starts all paragraphs and sentences with capital letters
  5. It provides options for converting all uppercase text to lowercase text

15. You can add Headers and Footers to a document from the menu View->Header and Footer. Why are Headers and Footers used in a document?

Answers:

  1. To enhance the overall appearance of the document
  2. To mark the starting and ending of a page
  3. To make large documents more readable
  4. To allow Page headers and footers to appear on the document when it is printed
  5. To allow Page headers and footnotes to appear on a web page when it is previewed in a browser

16. How are spelling errors displayed in Word 2000?

Answers:

  1. The errors are highlighted by a green wavy line
  2. The word with the wrong spelling has a strikethrough font
  3. The errors are highlighted by a red wavy line
  4. The color of the word with the wrong spelling will change to red

17. The figure shows the Margin Tab under the Menu File->Page Setup. The Gutter Margin has been set at 0.1″. What is a gutter margin?

Answers:

  1. Some extra space added to the right margin of the page required for cutting the page into even sizes at the time of binding
  2. Some extra space added to the left margin of the page required for binding the document
  3. A maximum limit set for editing the left margin so that it is not decreased beyond a certain limit
  4. A maximum limit set for editing the right margin so that it is not increased beyond a certain limit
  5. A bottom margin set for all pages that are required for footnotes

18. Your document consists of 10 pages. You would like to print page 1, page 2, page 4, page 5, page 7, page 8, page 9, and page 10. Which of the following is a valid page range that you can specify at the time of printing the document?

Answers:

  1. 1,2,4,5,7-10
  2. 1-2,4-5,7-10
  3. 1 to 2,4,5,7,8,9,10
  4. 1,2,4,5,7,8,9,10

19. What does the CTRL+B shortcut accomplish in Word 2000?

Answers:

  1. It converts the selected text into the next larger size of the same font
  2. It adds a line break to the document
  3. It makes the selected text bold
  4. It adds a segment break to the document

20. Which feature of Word 2000 allows you to use information from two different files for the quick creation of personal correspondence and other documents like interview letters and invitations?

Answers:

  1. AutoComplete
  2. AutoSummarize
  3. Mail Merge
  4. Web Mail
  5. Mail Manager
  6. File Mail Manager

21. State whether True or False.

You create a table in Word 2000 and enter some values in various cells and save the document. Later, you decide to delete the table. If you directly try to delete the table, Word 2000 first prompts you to delete the various values in the cells.

Answers:

  1. True
  2. False

22. What is the Thesaurus used for?

Answers:

  1. Spelling options
  2. Grammar options
  3. Synonyms and Antonyms
  4. Opposite words
  5. Different options for spelling the word

23. Why are footnotes and endnotes used in printed documents?

Answers:

  1. To mention the page number at the bottom of the page
  2. To mention the current date and the date the document was created
  3. To explain, comment on, or provide references for text in a document
  4. To add html links that can link the document to a web page

24. The figure shows the Character Spacing Tab options under the menu Format->Fonts. The Scale has been set at 200%. What effect does this have on the text?

Answers:

  1. The spacing between the characters in the text increases by 200%
  2. The spacing between the characters in the text decreases by 200%
  3. The font size of the characters in the text increases by 200%
  4. The characters in the text are stretched horizontally by 200%
  5. The characters in the text are stretched vertically by 200%

25. What is a Tab Stop in Word 2000?

Answers:

  1. A setting that disables the use of the Tab key while working on a document
  2. A setting that disables the use of the Shift+Tab key combination while working on a document
  3. A position you set for placing and aligning text on a page
  4. The point at which one page ends and another begins

26. How can you insert a sound file in a Word 2000 Document?

Answers:

  1. From the Insert->Object menu option
  2. From the Insert->Sound menu option
  3. From the Insert->File menu option
  4. By right-clicking on the document and choosing the ‘Add sound’ option

27. The figure shows the print options under the menu File->print. The ‘Print data only for forms’ option is unchecked (not been selected). What does this mean?

Answers:

  1. It allows for printing of the complete online form along with the data in the form
  2. It allows for printing of the online form only along with its data, and does not print anything else on the document
  3. It allows for printing of the data in an online form as a table. Each entry in the form is printed as a row in the table
  4. It allows for printing of the data entered into an online form without printing the online form

28. What is a watermark?

Answers:

  1. Any text or graphic which when printed appears either on top of or behind the existing document text
  2. A small icon that is automatically printed on the footer of a page to indicate that the page must be edited before saving
  3. An area on the left side of a page that increases the overall left margin. This space is required for binding the document after printing
  4. An image or picture anywhere in the document that links to a web page on the internet
  5. A small mark that appears next to the text on the page. Placing the mouse pointer over the text displays comments related to the text

29. How can you convert the whole document into uppercase if you have it typed in lowercase?

Answers:

  1. Select the document text and choose the ‘All caps’ option under the menu Format->Style
  2. Select the document text and choose ‘Corporate’ under the menu Format->Theme
  3. Select the document text and choose the ‘All caps’ option under the menu Format->Fonts
  4. There is no such option available in Word 2000

30. In the figure, the words ‘fox jumped’ appear lower than the rest of the words in the sentence. Which effect has been applied to these words?

Answers:

  1. Superscript
  2. Lowered
  3. Subscript
  4. Shadow
  5. Laid down

31. Can you change the background picture of a Word 2000 Theme that has been applied to a page?

Answers:

  1. Yes
  2. No

32. State whether the following statement is True or False.

Once a macro is running, it is not possible to stop it.

Answers:

  1. True
  2. False

33. The figure shows the ‘Indents and Spacing’ Tab options under the menu Format->Paragraph. The Line spacing has been set at ‘Exactly’. What does this mean?

Answers:

  1. The line spacing is fixed and Word 2000 does not adjust it. This option does not space all lines evenly
  2. Word 2000 sets the line spacing at exactly One-and-one-half times that of single line spacing
  3. Word 2000 accommodates the largest font in that line, plus a small amount of extra space depending upon the font used
  4. The line spacing is fixed and Word 2000 does not adjust it. This option spaces all lines evenly

34. When you right-click on a cell of a table drawn in a document, you can see the properties and options as shown in the figure. The split cells option has been highlighted in the figure. What is the function of this option?

Answers:

  1. It divides an existing cell horizontally into 2 equal cells
  2. It divides an existing cell vertically into 2 equal cells
  3. It allows you to divide an existing cell of a table into more rows and columns
  4. It allows you to merge 2 or more existing cells with one another

35. What does the CTRL+U shortcut accomplish in Word 2000?

Answers:

  1. It underlines the selected word
  2. It converts the selected word to uppercase
  3. It undeletes the last deleted word
  4. It undoes the last action performed in Word 2000

36. The figure shows the Edit Tab under the Tools->Options Menu. The ‘Enable click and type’ option has been checked. What function does this option perform?

Answers:

  1. It allows you to quickly insert text, graphics, tables, or other items in a blank area of a document
  2. It enables automatic formatting of paragraphs in the document by double clicking on the paragraph
  3. It automatically inserts a chosen graphic or icon wherever the user double-clicks on the document
  4. It performs a spell check of the word that has been double-clicked
  5. It automatically creates a table and inserts the document text into various cells according to how it has been formatted with commas and semicolons

37. What is the minimum number of rows and columns that a Word 2000 table can have?

Answers:

  1. Zero
  2. 2 Rows and 1 Column
  3. 2 Rows and 2 Columns
  4. 1 Row and 1 Column
  5. 1 Row and 2 Columns

38. What is a page break in Word 2000?

Answers:

  1. It refers to an instruction to the printer to print a new page
  2. It refers to the point at which one page ends and another begins
  3. It refers to dividing a page into 2 parts vertically
  4. It refers to dividing a page into 2 parts horizontally
  5. It refers to Word 2000 automatically breaking the continuity of a block of text by adding headers, bold faced characters and breaking the text into new paragraphs

39. How can you resize the width or height of a picture in a Word 2000 document?

Answers:

  1. By dragging the sizing handles that appear at the edges of the picture
  2. By altering the height and width size in the ‘Size’ Tab available at the menu Format->Picture
  3. By scaling the height and width in the ‘Size’ tab available at the menu Format->Picture
  4. By right-clicking on the picture and choosing the ‘Picture Size’ option

40. Which shortcut key combination will allow you to check the spelling of the complete document if you have not changed the shortcut keys’ settings?

Answers:

  1. F1
  2. F2
  3. F3
  4. F4
  5. F5
  6. F6
  7. F7
  8. F9

41. Which of the following are valid sources for storing the addressee information required for Word 2000 mail merge?

Answers:

  1. Word 2000
  2. MS Access
  3. MS Outlook
  4. MS Excel

42. Why are sections used in a Word 2000 document?

Answers:

  1. They are used to divide the document into parts so that each part may be independently printed when the print command is given
  2. To divide the document into parts so as to allow certain parts of the document to display data from a table
  3. To divide the document into parts so as to allow certain parts of the document to display data from the internet
  4. To vary the layout of a document within a page or between pages by dividing the document into parts, and then to allow formatting of each part the way you want
  5. To vary the layout of a document within a page or between pages by dividing the document into parts, with the purpose of applying a different Word 2000 theme to each part

43. Can you insert a new table inside a cell of an existing table in your Word 2000 document?

Answers:

  1. Yes
  2. No

44. How can you create a box around text placed on a web page, as shown in the figure?

Answers:

  1. Place the text in a table and give the table a boundary
  2. Choose ‘box’ under the Menu item Format->Borders and Shading
  3. Right-click on the selected text and choose ‘add boundary’ in the text properties
  4. Draw a rectangle around the text using the rectangle drawing tool

45. Is it possible for you to add custom words to the dictionary that Word 2000 uses to check spelling errors in your document?

Answers:

  1. Yes
  2. No

1,598 total views, 1 views today

Upwork Computer Skills

MS Excel 2007 Test 2016

Published by:

1. What is the option on the Document Inspector that finds the content type information?

Answers:

  1. Comments and Annotations
  2. Headers and Footers
  3. Document Properties and Personal Information
  4. Hidden Rows and Columns

2. How can a chart be modified?

Answers:

  1. By modifying a legend
  2. By modifying the display of chart axes
  3. By modifying titles and data labels
  4. All of the above

3. State whether true or false:

If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.

Answers:

  1. True
  2. False

4. How would you select an entire PivotTable report?

Answers:

  1. On the Home tab, in the Editing group, select the ‘Entire PivotTable’ option
  2. On the Options tab, in the Actions group, click on Select, and then click ‘Entire PivotTable'”
  3. On the Analyze tab, in the Data group, click on ‘Select Entire PivotTable’ option
  4. None of the above

5. Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

Answers:

  1. Scoping by selection
  2. Scoping by corresponding field
  3. Scoping by value field
  4. All of the above

6. When does the triangle appear in the top-left corner of the cell, as shown in the picture?

Answers:

  1. When the cell contains hidden information
  2. When the cell contains the Time function
  3. When there is an error in the formula
  4. None of the above

7. How will you display the Go To dialog box?

Answers:

  1. You will press F4
  2. You will press F5
  3. You will press F6
  4. You will press F7

8. Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.

Answers:

  1. A
  2. B
  3. C
  4. D

9. Which tab should be used to display or hide axes?

Answers:

  1. Data tab
  2. Layout tab
  3. Insert tab
  4. View tab

10. When ‘a’ or ‘p’ is not typed after the time in Worksheet cells, what does Excel enter the default time as?

Answers:

  1. It displays the prompt box and asks the user to type ‘a’ or ‘p’
  2. It displays an error message
  3. It enters the time as PM
  4. It enters the time as AM
  5. None of the above

11. Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?

Answers:

  1. CTRL+ALT+F10
  2. CTRL+SHIFT+ALT+F9
  3. SHIFT+F9
  4. None of the above

12. Which of the following is not true regarding naming a cell?

Answers:

  1. Names are case sensitive
  2. A name can contain up to 255 characters
  3. Names can contain uppercase and lowercase letters
  4. Some keyboard characters can cause unexpected results if used in cell names

13. State whether true or false:

When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.

Answers:

  1. True
  2. False

14. Where can the ‘Show All Comments’ command be found?

Answers:

  1. On the Page Layout tab
  2. On the View tab
  3. On the Review tab
  4. All of the above

15. What does the screen tip displaying “Showing All” mean?

Answers:

  1. It means that a Filter has been applied
  2. It means that Filtering has been enabled but not applied
  3. It means Excel does not support such a Filter
  4. None of the above

16. State whether true or false:
When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

Answers:

  1. True
  2. False

17. Which of the following is not true regarding column width?

Answers:

  1. If the column width is set to 0, the column is hidden
  2. A column width between 0 to 255 can be specified
  3. The default column width is 8.43 characters
  4. All of the above are true

18. Which chart displays axes but cannot display axis titles?

Answers:

  1. Radar chart
  2. Doughnut chart
  3. Pie chart
  4. All of the above

19. When does the error, as shown in the picture, occur?

Answers:

  1. It occurs when a column is not wide enough
  2. It occurs when a negative date is used
  3. It occurs when a negative time is used
  4. All of the above

20. Which among the following options displays Legend entries in the given picture?

Answers:

  1. A
  2. B
  3. C
  4. None of the above

21. Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

Answers:

  1. HLOOKUP
  2. VLOOKUP
  3. TRANSPOSE
  4. None of the above

22. How would you assign a Macro to a graphic?

Answers:

  1. On the Developer tab, in the Controls group, select Macro name
  2. On the View tab, click on Macros and then click ‘Assign Macro’ on the shortcut menu. In the Macro name box, click on the macro that you want to assign
  3. On a worksheet, right-click on the graphic, then click ‘Assign Macro'” on the shortcut menu. In the Macro name box, click on the macro that you want to assign
  4. All of the above

23. How should blank cells be inserted on a Worksheet?

Answers:

  1. Select the cell or the range of cells. Then on the Home tab, in the Cells group, click ‘Insert Cells’
  2. Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
  3. Both a and b
  4. None of the above

24. Which of the following is not true about the Watch Window?

Answers:

  1. The Watch Window makes it convenient to inspect, audit, or confirm formula calculations
  2. When cells are not visible on the worksheet, those cells and their formulae can be seen in the Watch Window
  3. There can be two Watch Windows per cell

25. Refer to the given image. Which line style option should be used to specify the style used for the end of the line?

Answers:

  1. A
  2. B
  3. C
  4. D

26. Which of the given methods would you follow to add an alternative text to a picture?

Answers:

  1. Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
  2. Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
  3. Both a and b
  4. None of the above

27. Refer to the given picture. Which option causes the last row in the table to appear and displays the word Total in the leftmost cell?

Answers:

  1. A
  2. B
  3. C
  4. D

28. Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?

Answers:

  1. CTRL+SHIFT+”
  2. CTRL+SHIFT+:
  3. CTRL+;
  4. None of the above

29. Which option would you choose to display a list of formula used in the current PivotTable report?

Answers:

  1. On the Options tab, in the Tools group, click on Formula, and then click ‘Solve Order'”
  2. On the Formula tab, in the Function library, click ‘Show Formula’
  3. On the Options tab, in the Tools group, click on Formula, and then click ‘List Formula’
  4. None of the above

30. When would the data validation command be unavailable on the data tab?

Answers:

  1. When an Excel table is linked to a SharePoint site
  2. When data in a cell is entered
  3. When the workbook is shared or protected
  4. All of the above

31. Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?

Answers:

  1. A
  2. B
  3. C
  4. D

32. What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?

Answers:

  1. It signifies that the cell contains a formula
  2. It signifies that the cell contains a comment
  3. It signifies that the cell contains a macro
  4. All of the above

33. Refer to the given image. What will be the result if the formula =B3&”, “&A3 is applied on the given table?

Answers:

  1. It will display Nancy Davolio
  2. It will display Fuller Andrew
  3. It will display Fuller, Andrew
  4. Both b and c

34. Which of the following charts have no axes?

Answers:

  1. Doughnut charts
  2. Pie charts
  3. Both a and b
  4. None of the above

35. Which keyboard shortcut should be used to enter the current time?

Answers:

  1. CTRL+SHIFT+”
  2. CTRL+SHIFT+:
  3. CTRL+;
  4. None of the above

36. Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?

Answers:

  1. Consolidate by position
  2. Consolidate by category
  3. Consolidate by formula
  4. None of the above

37. Which of the following options would you choose to clear a PivotChart report?

Answers:

  1. On the Analyze tab, in the Data group, click on Clear, and then click ‘Clear All’
  2. On the Options tab, in the Actions group, click on Clear, and then click ‘Clear All’
  3. Both a and b
  4. None of the above

38. Which file format is typically used to remove printer corruption?

Answers:

  1. XLS format
  2. HTML format
  3. SYLK format
  4. All of the above

39. State whether true or false:
A Macro project can be digitally signed.

Answers:

  1. True
  2. False

40. Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?

Answers:

  1. By selection
  2. By corresponding field
  3. By value field
  4. By number field

41. Which method will you use to update table data from a Sharepoint list?

Answers:

  1. On the Data tab, in the Data Tools group, click Refresh
  2. On the View tab, in the Show/Hide group, click Refresh
  3. On the Design tab, in the External Data group, click Refresh
  4. None of the above

42. Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?

Answers:

  1. A
  2. B
  3. C
  4. D

43. Which type of additional information is stored within the digital signature?

Answers:

  1. Date information
  2. Time information
  3. The Office version number of the program in which the file was created
  4. All of the above

44. State whether true or false:

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

Answers:

  1. True
  2. False

45. Which of the following is not a valid file extension in which an Excel file can be saved?

Answers:

  1. XLSB
  2. XLSM
  3. PXL
  4. All of the above are valid

46. As shown in the image, the checkbox ‘Create links to source data’ has been selected. Which of the following statements is correct regarding this?

Answers:

  1. This option does not let you change the consolidation
  2. This option does not let you create the consolidation
  3. Both a and b
  4. None of the above

47. Refer to the given image. What is the purpose of the cell denoted as ‘A’ in the worksheet?

Answers:

  1. It selects all the cells in the worksheet
  2. It selects a large range of cells in the worksheet
  3. It selects non-adjacent cells in the worksheet
  4. It selects an entire row in the worksheet

48. What is the purpose of using the Keep text flat option, as shown in the picture?

Answers:

  1. It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
  2. It prevents the text from blurring
  3. It moves the WordArt or text backward
  4. Both b and c

49. Which of the following methods would you follow to remove subtotals?

Answers:

  1. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
  2. On the Data tab, in the Data Tools, select Remove Subtotals
  3. Both a and b
  4. None of the above

50. How would you locate the last filled cell on a worksheet?

Answers:

  1. Click anywhere in the worksheet, and then press CTRL+HOME
  2. Click anywhere in the worksheet, and then press CTRL+INSERT
  3. Click anywhere in the worksheet, and then press CTRL+END
  4. None of the above

51. Which database function estimates variance based on a sample from selected database entries?

Answers:

  1. DSTDEV
  2. DSUM
  3. DVAR
  4. DVARP

52. State whether true or false:

When a part of a formula is replaced with its calculated value, it cannot be restored.

Answers:

  1. True
  2. False

53. Which of the following is not true about an offline cube file?

Answers:

  1. It stores data in the form of an OLAP cube
  2. The file format for an offline cube file is .CUE
  3. It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable

54. Which part of the formula displays references in the given picture?

Answers:

  1. A
  2. B
  3. C
  4. D

55. State whether true or false:

No data is deleted when an outline is hidden or removed.

Answers:

  1. True
  2. False

56. What does the red icon indicate, as shown in the given picture?

Answers:

  1. It tells the user that macro is enabled
  2. It tells the user that the document contains Signatures
  3. It tells the user that macro is disabled
  4. None of the above

57. State whether true or false:

Deleting the PivotChart report automatically deletes the associated PivotTable report.

Answers:

  1. True
  2. False

58. Which among the following is not true regarding a calculated column?

Answers:

  1. It uses a single formula that adjusts for each row
  2. It automatically expands to include additional rows
  3. A formula is required to be entered only once in a calculated column
  4. Additional formulae cannot be entered in a calculated column as exceptions

59. How will you reverse the direction of a SmartArt graphic?

Answers:

  1. Right-click on the SmartArt graphic, select Reverse
  2. Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
  3. Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
  4. All of the above

60. Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?

Answers:

  1. Automatically updated properties
  2. Standard properties
  3. Custom properties
  4. Properties for the organization

61. Which keyboard shortcut should be used to minimize or restore the ribbon?

Answers:

  1. CTRL+F3
  2. CTRL+F2
  3. CTRL+F1
  4. None of the above

62. Which among the following settings is the default macro setting?

Answers:

  1. Disable all macros without notification
  2. Disable all macros except digitally signed macros
  3. Disabled all macros with notification
  4. Enable all macros

63. Which of the following wildcard characters can be used as comparison criteria for Text Filters?

Answers:

  1. ?
  2. *
  3. ~
  4. All of the above

64. How will you find cells with data validation?

Answers:

  1. On the Home tab, in the Editing group, click the arrow next to Find & Select,, then click Go To Special. Click on Data Validation, and then click All
  2. On the View tab, in the Windows group, click Data Validation
  3. Both a and b
  4. None of the above

65. State whether true or false:

For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.

Answers:

  1. True
  2. False

66. Which of the following options is not available on the Status bar?

Answers:

  1. Cell mode
  2. Selection mode
  3. End mode
  4. Start mode

67. What would be the result, when =T(A4) is applied on the given table?

Answers:

  1. The text True is returned
  2. The text Rainfall is returned
  3. Empty text is returned
  4. None of the above

68. Which Chart type is displayed in the given picture?

Answers:

  1. A stock chart
  2. A surface chart
  3. An XY (Scatter) chart
  4. None of the above

69. Refer to the given image. Which formula should be written on the given table to display “Nancy Davolio”?

Answers:

  1. =UPPER(A2)
  2. =LOWER(A2)
  3. =PROPER(A2)
  4. None of the above

6,221 total views, 5 views today

Upwork Computer Skills

MS Excel 2000 Test 2016

Published by:

1. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?

Answers:

  1. #N/A
  2. Blank cell appears
  3. #ERROR
  4. #NUM

2. Which of the following shortcuts can be used to insert a new line in the same cell?

Answers:

  1. Ctrl+Enter
  2. Enter
  3. Alt+Enter
  4. Ctrl+L

3. State whether True or False.

When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.

Answers:

  1. True
  2. False

4. When using the VLOOKUP function, the error #REF! will appear in a cell if ________________.

Answers:

  1. the lookup_value is not found in the first column of the table_array
  2. the col_index_num argument is greater than the number of columns in table_array
  3. the table_array argument includes empty columns on the left of the table_array

5. Which of the following options would be used if you need to insert a number 77889867810070809 in a cell?

Answers:

  1. Place the character T before the number e.g. T 77889867810070809
  2. Place the characters TX before the number e.g. TX 77889867810070809
  3. Enclose the number is brackets e.g. (77889867810070809)
  4. Apply the Text Format to empty cells, and then type the numbers

6. State whether True or False:

When you clear the contents from a cell, the formatting of the cell is also lost.

Answers:

  1. True
  2. False

7. A smart tag will be removed from a cell when ________________ .

Answers:

  1. the cell is hidden
  2. the cell is moved
  3. the data in the cell is changed or deleted
  4. the formatting of the cell is changed

8. You have entered text in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?

Answers:

  1. Start typing in the cell and press the Enter key when you want to start another line
  2. Use the Wrap Text option in the Format -> Cells -> Alignment menu
  3. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu

9. What does the purple triangle at the bottom right corner of the cell signify?

Answers:

  1. Formatted cell
  2. Text
  3. Smart tag
  4. Hidden data

10. Which of the following functions would return a value of 8?

Answers:

  1. roundup(8.4999,0)
  2. rounddown(8.4999,0)
  3. round(8.4999,0)
  4. a and c
  5. b and c

11. What function does the ‘Compare Side by Side With’ command on the Window menu perform?

Answers:

  1. It allows you to compare two worksheets simultaneously in a single workbook
  2. It allows you to scroll through two or more workbooks simultaneously
  3. It allows you to scroll through only two workbooks simultaneously to identify the differences between them
  4. It only allows you to scroll through more than two worksheets in a single workbook simultaneously

12. Which of the following statements regarding the QUARTILE function is not true?

Answers:

  1. If array is empty, QUARTILE returns the #NUM! error value.
  2. If quart is not an integer, it is truncated.
  3. If quart < 0 or if quart > 4, QUARTILE returns the #NUM! error value.
  4. The functions MEDIAN(array) and QUARTILE(array,2) will return different values when applied to the same array.

13. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘A’?

Answers:

  1. It is used to publish the worksheet on a web browser for viewing over the Internet
  2. It is used to make the worksheet universally shareable
  3. It is used to add a hyperlink

14. What is the quickest way to select all the columns on a worksheet?

Answers:

  1. Click on the column heading of the first column, press Shift, and then click on the column heading of the last column
  2. Click on the column heading of the first column, press Ctrl, and then click on the column heading of the last column
  3. Choose Edit->Select all from the main menu
  4. Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

15. The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter ‘X’ ?

Answers:

  1. It inserts a Diagram or Organization Chart in the worksheet
  2. It is used to rotate the picture in the worksheet to the desired angle
  3. It inserts clipart in the worksheet
  4. It applies 3-D style to the picture in the worksheet

16. What should you add before a fraction to avoid entering it as a date, e.g. 1/3, in Excel?

Answers:

  1. F
  2. //
  3. zero
  4. FR
  5. zero space

17. There is a workbook named Sales.xls which has a worksheet named Quarterly. This worksheet contains the quarterly sales figures for the company in cells A3 to A6. Now you want to create a formula in a different workbook that reads the quarterly sales figures and adds them up while the Sales workbook is closed. Which of the following is the correct formula to do this?

Answers:

  1. =SUM([Sales.xls]Quarterly!A3:A6)
  2. =SUM(‘C:MyFilesSales.xls!Quarterly’A3:A6)
  3. =SUM(C:MyFilesSales.xls,Quarterly!A3:A6)
  4. =SUM(‘C:MyFiles[Sales.xls]Quarterly’!A3:A6)

18. State whether True or False.

With the help of the Research task pane you can conduct research on Topics using an encyclopedia, Web search and also by accessing third-party content.

Answers:

  1. True
  2. False

19. Which of the following function you will use to find the highest number in a series of numbers?

Answers:

  1. MAX(B1:B3)
  2. MIN(B1:B3)
  3. AVERAGE(B1:B3)
  4. SUM(B1:B3)

20. What will be the value in the cell C2 as shown in the figure when we use formula =A2+B2?

Answers:

  1. 63
  2. 91
  3. 120
  4. 92

21. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘Z’?

Answers:

  1. It is used to add a background color to the selected cell
  2. It is used to add a colored boundary around the selected cell
  3. It copies the formatting properties from one cell to another
  4. It deletes the values of all the selected cells

22. Which of the following statements is true if the cell B1 contains the formula =$A$1

Answers:

  1. The value of cell B1 contains the same number of characters as the value of cell B2
  2. There is an absolute reference to cell A1 so that the formula =$A$1 can be copied to other cells without changing the reference to A1
  3. There is a relative reference to cell A1 so the formula will change each time it is copied to other cells
  4. The value of cell B1 is copied only once, further changes in value of A1 will not effect the value of B1

23. There is a workbook named Sales.xls which has a worksheet named Quarterly. This worksheet contains the quarterly sales figures for the company in cells A3 to a6. Now you want to create a formula in a different workbook that reads the quarterly sales figures and adds them up while the Sales workbook is open. Which of the following is the correct formula to do this?

Answers:

  1. =SUM[Sales.xls]Quarterly!A3:A6
  2. =Sales.xls!SUM(A3:A6)
  3. =SUM([Sales.xls]Quarterly!A3:A6)
  4. =Sales.xls[Quarterly]SUM(A3:A6)

24. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Answers:

  1. =A1&”,”&B1
  2. =A1&”_”&B1
  3. =A1&”.”&B1
  4. =A1&” “&B1

25. Which of the following Date and Time function will you use to return the serial number of the last day of the month before or after a specified number of months?

Answers:

  1. DATEVALUE
  2. EOMONTH
  3. TIMEVALUE
  4. EDATE.

26. Which of the following statement is true if the author has created the content with restricted permission using IRM?

Answers:

  1. Prevent an unauthorized recipient from accessing e-mail content, including attachments.
  2. Prevent restricted e-mail content from being copied by using the Print Screen feature in Microsoft Windows.
  3. Restricted e-mail content from being copied by using third-party screen-capture programs.
  4. None of the above

27. What does the NOW() function return?

Answers:

  1. Returns the serial number of the current date and time
  2. Returns the serial number of the current date
  3. Returns the serial number of the current time
  4. None of the above

28. How does the AutoComplete feature in Excel help you save time?

Answers:

  1. It automatically completes abbreviated words
  2. It completes text and numeric entries that match an existing entry in the same column
  3. It completes text entries that match an existing entry in the same worksheet
  4. It completes text entries that match an existing entry in the same column

29. The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Answers:

  1. Select the cells A2 to A6 and cells B1 to F1 and click on Freeze Panes under the menu Window->Freeze Panes
  2. Select the cell B2 and click on Freeze Panes under the menu Window->Freeze Panes
  3. Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes
  4. Select the cells F1 and A6 and click on Freeze Panes under the menu Window->Freeze Panes
  5. None of the above

30. Is the following statement true or false?

If a workbook is placed in the XLSTART folder, then the same workbook will open each time Excel is launched.

Answers:

  1. True
  2. False

31. The figure shows an Excel worksheet. What does the red triangle in cell C2 signify?

Answers:

  1. The cell is locked
  2. The data entered in the cell will be validated to see if it matches the criteria set
  3. The cell has been marked so that it can be referred to in case of need
  4. There is a comment associated with the cell

32. You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Answers:

  1. The print area will be printed
  2. The selected area will be printed
  3. Excel will prompt you to de-select the selected area

33. The given figure shows the ‘Compare Side by Side’ toolbar. What function is performed by the button marked with letter ‘A’?

Answers:

  1. It allows you to open a new workbook for comparison
  2. It allows synchronous scrolling of the workbooks
  3. It allows you to stop comparing workbooks
  4. It allows you to reset the workbook windows to the positions they were in when you first started comparing workbooks

34. What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

B1:27
B2:22
B3:28
B4:21

Answers:

  1. #N/A
  2. 27
  3. 0
  4. Error

35. The figure shows the AutoFit Selection menu option. What function does it perform?

Answers:

  1. It automatically resizes the column width to the minimum necessary to fit the contents of the selected cell
  2. It automatically resizes the column height to the minimum necessary to fit the contents of the selected cell
  3. It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell
  4. It automatically compacts the text to fit into the original column size

36. State whether True or False.

AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Answers:

  1. True
  2. False

37. The figure shows the Calculation tab under the Tools->Options menu. The option under Calculation has been checked as Automatic. What does this mean?

Answers:

  1. Excel will calculate the values for all formulas entered into cells when you click Calc Now on the calculation tab
  2. Excel will automatically calculate the values for all formulas before saving
  3. Excel will automatically calculate the values for all formulas as you change the values within cells

38. The figure shows the Text to Column menu option. What function does it perform?

Answers:

  1. It allows you to add comma separated text into various cells automatically
  2. It converts the selected text to a table
  3. It automatically resizes the cell size whenever a large text is added into the cell

39. How can you select all the blank cells in your worksheet?

Answers:

  1. This must be done manually as it is not automated through any built-in feature
  2. Choose Edit->Select->Blank under the main menu
  3. Choose Blanks in the Edit->Go To->Special menu option
  4. Choose Blanks in the View->Go To->Special menu option

40. As shown in the figure what information will be enlisted by the tab marked as “B” about the current document?

Answers:

  1. It displays custom properties of the current document
  2. It displays whether the current document is up to date or not
  3. It displays when the current document was last modified
  4. It displays whether the current document is in conflict with another member’s copy
  5. It displays your Information Rights Management permissions

2,096 total views, 1 views today