A22.0004
Midterm Solutions

Correct answer is in boldface:

1. I put an alias (i.e., a shortcut) on the desktop. What is this?

  • (a) A pointer to a document.
  • (b) A pointer to a document or a program.
  • (c) A copy of a document.
  • (d) A convenient way to start up a program.
  • 2. A document is:

  • (a) A file created by and used by an application;
  • (b) A collection of files and other documents;
  • (c) Something that starts up a program;
  • (d) A floppy disk or hard disk.
  • 3. A folder (or directory) is:

  • (a) A collection of files and other folders;
  • (b) A manila sheet of cardboard folded in half and placed on the desktop;
  • (c) A section of the hard disk;
  • (d) Something that holds a program.
  • 4. To throw away a file so that no one can ever see it, you should:

  • (a) Drag the icon for the file to the waste bin (or recycle bin);
  • (b) Select "delete" from the menu when the file is selected;
  • (c) Select the file and hit the delete key;
  • (d) None of the above, since it might be the case that the file can then be retrieved from the waste (recycle) bin.
  • 5. This symbol is the icon for:

  • (a) The Microsoft Word program;
  • (b) A Microsoft Word document;
  • (c) A document with a drop cap;
  • (d) A folder containing Word documents.
  • 6. A typical Word document containing a page of text will be about the following size:

  • (a) 100 bytes
  • (b) 10 kilobytes
  • (c) 1 Megabyte
  • (d) 100 Megabytes
  • 7. A High Density diskette holds about:

  • (a) 100 bytes
  • (b) 10 kilobytes
  • (c) 1 Megabyte
  • (d) 100 Megabytes
  • 8. You should use "Save As..." and not "Save" whenever:

  • (a) You need to give a new name to the document;
  • (b) You don't want to overwrite the document that you opened with any of the changes that you are about to make, but instead want to store them elsewhere;
  • (c) You started a new document which has the default name "Document 1", and you haven't yet saved the document;
  • (d) Any of the above.
  • 9. To open a document, you can:

  • (a) Double click on the icon for the document;
  • (b) Select "Open" from the File menu of the appropriate application;
  • (c) Select the appropriate document name amoung the recently-used documents in the "File" menu;
  • (d) Any of the above.
  • 10. Before you copy text from one application to another, you must:

  • (a) Select the text that you wish to copy, and execute the copy command from the Edit menu, or perform an equivalent short-cut;
  • (b) Open the first document in the target application;
  • (c) Cut the text using the delete key;
  • (d) You can't copy text from one application to another.
  • 11. You can send email to:

  • (a) Anyone with an account on the "IS" machines;
  • (b) Anyone to whom you have permission to send email;
  • (c) Anyone with an account anywhere on the internet in the north American continent;
  • (d) Anyone with an account anywhere on the internet.
  • 12. An attachment to an email message is:

  • (a) A document that you send with the email message;
  • (b) A fancy signature that you have set up;
  • (c) A comment meant only for your girlfriend or boyfriend;
  • (d) The information about where the message is going.
  • 13. Netscape Navigator is an example of:

  • (a) An HTML document;
  • (b) A web page;
  • (c) A browser;
  • (d) All of the above.
  • 14. The URL http://cs.nyu.edu brings up what information:

  • (a) The NYU Computer Science Department home page;
  • (b) The home page for the course A22.0004;
  • (c) The NYU Computing Facility information page;
  • (d) An error message, saying that there's no such document.
  • 15. To shut down the computer, you should:

  • (a) Pull the plug out of the wall;
  • (b) Turn the off button, or press the computer's power button;
  • (c) Issue a "Shutdown" command from the proper menu;
  • (d) Any of the above will work fine with no problems.
  • 16. A GIF is:

  • (a) A general interruption fault;
  • (b) A format for a file containing a picture;
  • (c) someone who uses the computer all the time;
  • (d) A picture of oneself to send to people.
  • 17. An email message sent to fred@is2.nyu.edu can be read by:

  • (a) Fred, and only by fred;
  • (b) Anyone who is logged into is2 as fred;
  • (c) Anyone logged in as fred on is2, system administrators of is2, and potentially other people with appropriate access;
  • (d) Anyone with an account in is2.
  • 18. When you run netscape on a machine that is networked to the internet, you can display

  • (a) HTML documents located and accessible on that machine;
  • (b) HTML documents located within the local network and accessible on the network;
  • (c) HTML documents on machines on the internet that the author has made accessible;
  • (d) All of the above.
  • 19. Telnet is:

  • (a) A long distance telephone company;
  • (b) An application used to log onto remote computers from a networked computer;
  • (c) A networking protocol that is more sophisticated than TCP/IP;
  • (d) None of the above.
  • 20. Pine is:

  • (a) A web browsing application;
  • (b) A file transfer program for moving files from one machine to another;
  • (c) An application to make drawings;
  • (d) An email application.
  • MICROSOFT WORD

    21. In order to move a picture (or graphic) embedded in Word to a desired position on the page, you should

  • (a) Insert a frame and drag the frame in Page Layout view;
  • (b) Insert a frame and drag the frame in Normal view;
  • (c) Drag and drop the graphic to the appropriate position;
  • (d) Insert carriage returns and spaces in order to appropriately posision the graphic.
  • 22. To indent the first line of a paragraph, you should:

  • (a) Insert five spaces before the first character;
  • (b) Insert a tab before the first character;
  • (c) Use the paragraph formatting to set the "First Line" indentation, or use the indent marker on the ruler;
  • (d) You shouldn't indent paragraphs.
  • 23. Times New Roman is

  • (a) a sans serif font;
  • (b) a serif font;
  • (c) a news magazine;
  • (d) a 12-point font.
  • 24. A 24-point heading is about how tall?

  • (a) One inch;
  • (b) One-half inch;
  • (c) One-third inch;
  • (d) One-sixth inch.
  • 25. Clip art can be obtained from:

  • (a) HyperCard;
  • (b) Microsoft Word installed clip art;
  • (c) By copying and pasting from other MS Word documents with art;
  • (d) Any of the above.
  • 26. When you begin a new document in Microsoft Word, you most likely use which template:

  • (a) Traditional Letterhead;
  • (b) Standard;
  • (c) Normal;
  • (d) My Document.
  • 27. A carriage return is entered only when:

  • (a) The document is finished;
  • (b) You need to start a new line because the current line is full;
  • (c) To start a new paragraph;
  • (d) To insert blank vertical space.
  • 28. In the figure below, the popup box containing the text "question" gives:

  • (a) Answers to questions;
  • (b) The name of the style at the current location;
  • (c) An indication of an error;
  • (d) The name of the current font.
  • 29. The "u" at the far right is a button that is used to:

  • (a) Underline selected text;
  • (b) Undo the last command;
  • (c) Check the spelling of selected text;
  • (d) Capitalize the selected letter.
  • 30. If you modify a style, then:

  • (a) All paragraphs with that style will be modified;
  • (b) The display will look different, but the document printed out will look the same;
  • (c) The current paragraph will be modified;
  • (d) All documents based on that style will be modified.
  • 31. Microsoft Word has the ability to do which of the following:

  • (a) Check the spelling of the text;
  • (b) Check the grammar of the text;
  • (c) Hyphenate words;
  • (d) All of the above.
  • 32. What does this button do?

  • (a) Inserts a new paragraph;
  • (b) Inserts a carriage return;
  • (c) Displays on the text the location of carriage returns;
  • (d) Activates all carriage returns so they cause new paragraphs.
  • 33. The "body text" style is used for:

  • (a) Figures and captions;
  • (b) Titles;
  • (c) Internal paragraphs;
  • (d) Footnotes.
  • 34. A template contains a set of styles. You can:

  • (a) Modify the styles;
  • (b) Apply a different template, updating the paragraphs with styles whose names overlap with the former template's styles;
  • (c) Selectively change the style applied to a paragraph;
  • (d) Any of the above.
  • 35. Microsoft Word has which of the following:

  • (a) A drawing program;
  • (b) A calculator;
  • (c) An email program;
  • (d) None of the above.
  • 36. In order to place text labels on a drawing, you should:

  • (a) Insert a frame and place some text in it, inserting it at the desired position;
  • (b) Use a callout or a text box from the drawing program;
  • (c) Just type the text at the desired position;
  • (d) You can't put text in a drawing!
  • 37. A typical font size for text in Microsoft Word is:

  • (a) 6 point;
  • (b) 10 point;
  • (c) 18 point;
  • (d) 72 point.
  • 38. This question has a change bar on the right hand edge. This was most likely inserted using:

  • (a) The change bar tool;
  • (b) Borders and Shading… under the "Format" Menu, using a border on the right hand side;
  • (c) Placing a vertical line in a frame placed over on the right hand edge;
  • (d) Using a pen, drawing a vertical line in the correct place before the master copy was photocopied.
  • 39. In a Word document, you cut and paste some text in order to:

  • (a) Place some holes in the paper;
  • (b) Insert multiple copies of the selected text;
  • (c) Delete some text;
  • (d) Move some text to a different position.
  • 40. In order to check the spelling of all the words in a document:

  • (a) You must first save the document, quit Word, and run a spell checking program;
  • (b) You may use the spell checker in Word;
  • (c) You must install a dictionary program;
  • (d) You must first select all the text.
  • Microsoft Excel

    41. =A1+A2 will:

  • (a) Place the contents of A1 into A2
  • (b) Add the contents of A1 to A2 and place the result in A3;
  • (c) Add the contents of A1 and A2 and display the result in the current cell;
  • (d) None of the above.
  • 42. =AVERAGE(B1:B3) is the same as:

  • =B1+B3
  • =(B1+B3)/2
  • =(B1+B2+B3)/3
  • =(B1+B2+B3)
  • 43. If I drag the formula =A1+A2 one cell to the right using the fill handle, the result will be:

  • =A1+A2
  • =B1+B2
  • =B2+B3
  • 0.
  • 44. The Chart Wizard is used to make:

  • Charts of the continents, or selected countries of the world;
  • Graphs of data in columns or rows of the spreadsheet;
  • Colored backgrounds for the cells in the spreadsheet;
  • None of the above.
  • 45. Dragging a cell using the fill handle is:

  • Dangerous, since the machine can crash;
  • The same as dragging using the border;
  • The same as performing a copy and paste;
  • The same as performing a series fill.
  • 46. The Cell Formatting controls:

  • The alignment of text within the cell;
  • The format of the number displayed in the cell, such as the number of digits of precision displayed after the decimal point;
  • The kind of border placed around the cell;
  • Any (or all) of the above.
  • 47. If I copy a selected portion of a Microsoft Excel spreadsheet from Excel and paste the result in a Word document, the result is:

  • A text file in the Word document;
  • A picture in the Word document;
  • A table in the Word document;
  • An Excel document in the Word document.
  • 48. In a cell in an Excel Spreadsheet, I see ########. What does this most likely mean?

  • The cell contains a NULL value;
  • There is an error, and the value of the cell cannot be computed;
  • The formatting of the cell is such that the value in the cell does not fit in the space allowed for the cell;
  • The cell contains a label consisting of sharps.
  • 49. I use "AutoFormat" to:

  • Format the entire spreadsheet, choosing a color scheme and highlighting the labels;
  • Choose the format of a single cell;
  • Choose the format of a row or column;
  • To make the rows and columns line up.
  • 50. Whenever it is possible, you should use:

  • Color;
  • A small number;
  • A long label centered across the selection;
  • A formula.