Basic Concepts I Status : Completed Score: 150 out of 150 points Instructions: Question 1 10 of 10 points The mouse pointer, which is shaped like a hand with a pointed finger, is used to select or activate objects on the screen. Selected Answer: True Question 2 10 of 10 points To select the My Computer icon on the desktop, click it once with the left mouse button and press enter or double click with the left mouse. Selected Answer: True Question 3 10 of 10 points The Start button can be used to launch programs, set up printers, get help, and shut down your computer. Selected Answer: True Question 4 10 of 10 points When you move the pointer to the lower-right corner of a window to change the size of the window, the pointer changes to a four-way arrow. Selected Answer: False Question 5 10 of 10 points To move a window on the desktop, click and hold down the mouse in the status bar and drag to a new location. Selected Answer: True Question 6 10 of 10 points The vertical scrollbar enables you to view information too wide to fit in a window. Selected Answer: False Question 7 10 of 10 points Minimizing a window hides the window but leaves it open and available on the taskbar. Selected Answer: True Question 8 10 of 10 points If you are using one Office program and want to use another program, you need to close the first program before you open the new one. Selected Answer: False Question 9 10 of 10 points The Contents tab in the Help window can be used like a book. Selected Answer: True Question 10 10 of 10 points It is very important to shut the computer down using the Shut Down option from the Start menu. Selected Answer: True Question 11 10 of 10 points If the taskbar is not displayed on the screen, you can Selected Answer: move the pointer to the bottom of the screen Question 12 10 of 10 points If you double-click the My Computer icon and it does not open, it could be that __ Selected Answer: all of the above Question 13 10 of 10 points An arrow to the right of a menu option in the Start menu means Selected Answer: if you select that option, you see a submenu of programs and/or files Question 14 10 of 10 points In a scrollbar, the following enables you to see information that is not currently on the screen _________________ Selected Answer: all of the above Question 15 10 of 10 points If you don't know the correct terminology to find help on a topic, the best place to look would be __________ Selected Answer: the Help and support or Find or Search tab of the Help menu Name: Basic Concepts 2 Status : Completed Score: 150 out of 150 points Instructions: Question 1 10 of 10 points Formatting a disk sets it up to receive data. Selected Answer: True Question 2 10 of 10 points You cannot format a Macintosh disk for use in a Windows computer. Selected Answer: False Question 3 10 of 10 points You can create folders on hard disks but not on floppy disks. Selected Answer: False Question 4 10 of 10 points To sort the file and folder names in alphabetical order, you can click the column selector of the Name column in the Windows Explorer Content area. Selected Answer: True Question 5 10 of 10 points A quick way to copy a file from a hard disk or CD-ROM to a floppy disk is to right-click the filename and select Send To from the shortcut menu. Selected Answer: True Question 6 10 of 10 points A file extension consists of three characters at the end of a filename that identify the size of the file. Selected Answer: True Question 7 10 of 10 points You can rename a file, but not a folder. Selected Answer: False Question 8 10 of 10 points You can use the cut-and-paste method to move a file from one folder to another. Selected Answer: True Question 9 10 of 10 points One way to remove a file from a disk is to select it and press the Delete key. Selected Answer: True Question 10 10 of 10 points Copying a floppy disk is a good way to back up your work. Selected Answer: True Question 11 10 of 10 points If you put an unreadable disk in the floppy drive _________ Selected Answer: you are asked whether you want to format it the first time you try to select it. Question 12 10 of 10 points To rename a file or folder, you can ________ Selected Answer: all of the above Question 13 10 of 10 points When naming a file or folder, you can use _______ Selected Answer: numbers Question 14 10 of 10 points To move a file from one folder to another; you can ___________ Selected Answer: drag the file and drop it on the new folder icon Question 15 10 of 10 points When you use the Copy Disk procedure, ________ Selected Answer: the destination disk is automatically reformatted Question 1 10 of 10 points One of the strenths of Office 2000 programs is that they interact easily with the Web Selected Answer: True Question 2 10 of 10 points To launch an Office program you need to close any other Office program that is running at the same time. Selected Answer: False Question 3 10 of 10 points When you start typing in a document, the text appears at the pointer location. Selected Answer: False Question 4 10 of 10 points You can activate the menu bar by pressing the Alt key Selected Answer: True Question 5 10 of 10 points To expand a menu, double-click the menu choice in the menu bar. Selected Answer: False Question 6 10 of 10 points One way to turn toolbars on or off is to right-click anywhere in the toolbar area and click one of the toolbar choices Selected Answer: True Question 7 10 of 10 points When you use the Save As option, you can change the program name, which deletes the old version. Selected Answer: False Question 8 10 of 10 points Using File, Print from the menu gives you more control over printing than using the Print button. Selected Answer: True Question 9 10 of 10 points You can type questions in sentence form when you use the Office Assistant. Selected Answer: True Question 10 10 of 10 points When you see blue text in a Help window, it means that more help is available by clicking the text. Selected Answer: True Question 11 10 of 10 points Which of the following is a good reason to use the Microsoft Office suite of programs? Selected Answer: all of the above Question 12 10 of 10 points After a document has been saved on a flopy disk, you can move to the Windows Explorer and open it by __________ Selected Answer: double-clicking it with the left mouse button Question 13 10 of 10 points If a document doesn't print when you click the Print button, it could be that _____ Selected Answer: all of the above Question 14 10 of 10 points If the Office Assistant is not displayed on your screen, you can ____________ Selected Answer: select Help, Show the Office Assistant from the menu Question 15 10 of 10 points To expand the Office Assistant Help window so you can use the Contents and Index tabs, _________ Selected Answer: click the Show button in the Microsoft Word Help dialog box Question 1 10 of 10 points Which of the following is NOT a necessary characteristic of computer fluency? Selected Answer: Being able to write computer programs Question 2 10 of 10 points The four main functions of a computer are: Selected Answer: input, processing, output, and storage. Question 3 10 of 10 points The primary purpose of a computer is to process ________ and convert it into information. Selected Answer: data Question 4 10 of 10 points There are ________ bits in a byte. Selected Answer: eight Question 5 10 of 10 points The "brains" of the computer, which executes the instructions, is called the: Selected Answer: CPU. Question 6 10 of 10 points The circuitry that includes the CPU, memory chips, and expansion slots is located on the: Selected Answer: motherboard. Question 7 10 of 10 points All of the following are considered to be storage units EXCEPT: Selected Answer: CPU. Question 8 10 of 10 points The term that refers to computers that provide resources to other computers in a network is: Selected Answer: server. Name: Tech in Action Chapter 4 Status : Completed Score: 120 out of 120 points Instructions: Tech in Act Question 1 10 of 10 points The following are all ways of formatting your word processing document EXCEPT: Selected Answer: translating text to different languages. Question 2 10 of 10 points In a spreadsheet, the intersection between a column and a row is called a(n): Selected Answer: cell. Question 3 10 of 10 points The cell address C5 indicates that the cell: Selected Answer: is at the fifth row, third column of the worksheet. Question 4 10 of 10 points In a spreadsheet, an expression involving mathematical operators, cell addresses, and numbers is called a: Selected Answer: formula. Question 5 10 of 10 points AVERAGE and SUM are examples of: Selected Answer: functions. Question 6 10 of 10 points Slide layouts and design templates are features of ________ software. Selected Answer: presentation Question 7 10 of 10 points If you are using a template in a productivity software application, you are most likely trying to: Selected Answer: assign a basic theme or structure to the file with which you are working. Question 8 10 of 10 points Microsoft Office is an example of a(n): Selected Answer: software suite. Question 9 10 of 10 points CAD software is most likely to be used by: Selected Answer: engineers. Question 10 10 of 10 points WebCT and Blackboard are two popular software products for: Selected Answer: course management. Question 11 10 of 10 points Which of the following is an automated help feature that gives tips on tasks you are performing as you perform them? Selected Answer: The Office assistant Question 12 10 of 10 points Software that you can use for a trial period before paying for it is called: Selected Answer: shareware. Name: Tech in Action Chapter 5 Status : Completed Score: 70 out of 70 points Instructions: Question 1 10 of 10 points All of the following are tasks performed by the operating system EXCEPT: Selected Answer: performing housekeeping tasks like file compression and disk defragmentation. Question 2 10 of 10 points An essential difference between the operating system that runs a typical desktop computer and the operating system that runs a typical PDA is that: Selected Answer: the desktop OS can run several programs simultaneously whereas the PDA OS cannot. Question 3 10 of 10 points The MS DOS operating system is a: Selected Answer: command-driven interface, single-tasking operating system. Question 4 10 of 10 points Maintaining groups of related files on the computer is best done by grouping them into: Selected Answer: folders. Question 5 10 of 10 points Using Windows Explorer, you can tell if a folder has subfolders by looking for: Selected Answer: a plus (+) sign. Question 6 10 of 10 points Combining all pieces of files together and placing them in continuous locations of the disk is the purpose of a: Selected Answer: disk defragmenter. Question 7 10 of 10 points To cause your Windows XP computer to completely revert to the state it was in on a previous date, you can use the ________ utility. Selected Answer: System Restore Name: Tech in Action Chapter 7 Status : Completed Score: 60 out of 60 points Instructions: Question 1 10 of 10 points The most likely use of a router in a home network is to: Selected Answer: allow multiple computers in the network to connect to the Internet. Question 2 10 of 10 points The 802.11 (or Wi-Fi) standard pertains to: Selected Answer: wireless networks. Question 3 10 of 10 points Windows XP assists with configuring home networks via a: Selected Answer: wizard. Question 4 10 of 10 points A software program designed to prevent unauthorized access to a computer system is called a(n): Selected Answer: firewall. Question 5 10 of 10 points A computer program that attaches itself to another program and spreads itself to other computers via replication when files are exchanged is called a: Selected Answer: virus. Question 6 10 of 10 points Operating systems such as Windows XP periodically provide security ________ to overcome their vulnerabilities to invasion from hackers. Selected Answer: patches The monitor and printer are the primary input devices for personal computers. The Correct Answer: False 2. Not Answered RAM is a type of auxiliary storage device. The Correct Answer: False 3. Not Answered Microsoft Excel and Word are examples of data files. The Correct Answer: False 4. Not Answered Clock speed is measured in megahertz. The Correct Answer: True 5. Not Answered Some computer viruses can completely erase all files on a hard disk. The Correct Answer: True 6. Not Answered A local area network connects computers around the world. The Correct Answer: False 7. Not Answered Increasing resolution settings allows you to see more output on your monitor screen. The Correct Answer: True 8. Not Answered Windows XP replaces all previous versions of the operating system. The Correct Answer: True 9. Not Answered The Control Panel affects every aspect of Windows Explorer. The Correct Answer: False 10. Not Answered FTP specifies the rules by which files are sent and received. The Correct Answer: True 11. Not Answered When compressing files you can only include one document at a time. The Correct Answer: False 12. Not Answered The Standard toolbar included in the Office 2003 core programs contains the bold, font size, and italics commands. The Correct Answer: False 13. Not Answered Microsoft Outlook contains a calendar function, contacts function, and a journal area. The Correct Answer: True 14. Not Answered Any computer that stores hypertext documents and makes those documents available to other computers is known as a client. The Correct Answer: False 15. Not Answered Small files that are written to your hard drive each time you visit an Internet site are called cookies. The Correct Answer: True 16. Not Answered Which of the following cannot permanently store data? The Correct Answer: RAM 17. Not Answered Which of the following is not an output device? The Correct Answer: Keyboard 18. Not Answered Which version of Windows was intended for the professional rather than the typical home user? The Correct Answer: Windows 2000 19. Not Answered To access documents on the Web, you need: The Correct Answers: A browser, System Software 20. Not Answered Which of the following provides access to the Internet? The Correct Answer: An ISP 21. Not Answered Which of the following features is not found in all e-mail programs? The Correct Answer: Reject 22. Not Answered Encryption is available in which of the following browsers? The Correct Answer: Both Netscape Navigator and Internet Explorer 23. Not Answered To gain access to your e-mail mailbox, you must provide both a username and a:? The Correct Answer: Password 24. Not Answered How many bytes are in 1 GB? The Correct Answer: Approximately one billion 25. Not Answered Which of the following is included in Microsoft Office 2003? The Correct Answer: Microsoft Access 1. Not Answered The idea for a general purpose computer was first proposed by: The Correct Answer: Charles Babbage 2. Not Answered Approximately how many bytes are in 1KB? The Correct Answer: One thousand 3. Not Answered The size of a computer's memory refers to: The Correct Answer: The amount of RAM available 4. Not Answered Hard copy refers to: The Correct Answer: None of the above 5. Not Answered Which of the following would never be valid as a drive designation? The Correct Answer: Drives 1 and 2 for a floppy and fixed disk, respectively 6. Not Answered Which of the following devices is best suited to back up data from a PC? The Correct Answer: CD-R or CD-RW 7. Not Answered Which of the following displays capacities from smallest to largest? The Correct Answer: KB, MB, GB, TB 8. Not Answered Which of the following is true regarding the resolution of a monitor? The Correct Answer: Larger monitors enable you to work with higher resolutions 9. Not Answered Which of the following allows a user to record multiple times to the same CD? The Correct Answer: CR-RW 10. Not Answered Which of the following best describes the memory and fixed disk in an entry-level PC that you would buy today? The Correct Answer: The capacity of RAM is measured in megabytes, the capacity of a fixed disk is measured in gigabytes 11. Not Answered Which applications are new to Microsoft Office 2003? The Correct Answer: OneNote and InfoPath 12. Not Answered What is the best and cheapest way to double the warranty of a new computer up to an additional year? The Correct Answer: Use a major credit card that doubles the warranty for free 13. Not Answered When is a file compression program not necessary? The Correct Answer: To extract files from a self-extracting file 14. Not Answered Which of the following capabilities is built into the Microsoft Windows? The Correct Answer: Neither (a) nor (b) 15. Not Answered Which of the following is true about Microsoft Office? The Correct Answer: Neither (a) nor (b) 16. Not Answered Which of the following means of Internet access will tie up your telephone line and prevent you from speaking when the Internet connection is in effect? The Correct Answer: An analog modem 17. Not Answered What is a cookie? The Correct Answer: A small file that is written to a PC by a Web site 18. Not Answered A local area network is intended to: The Correct Answer: All of the above 19. Not Answered A virus can be transmitted when you: The Correct Answer: Both (a) and (b) 20. Not Answered Which of the following is an example of an XML Web service? The Correct Answer: Microsoft Passport 1. Not Answered A dimmed command on a pull-down menu indicates that additional information is required to execute the command. The Correct Answer: False 2. Not Answered A file that has been created in Microsoft Excel is called a ____________file. The Correct Answer: Data 3. Not Answered A folder that shows a minus sign in Windows Explorer is expanded. The Correct Answer: True 4. Not Answered A program file, such as Microsoft Excel, is executable. The Correct Answer: True 5. Not Answered A sub-menu will appear if you select a menu option that is followed by an ellipsis (...). The Correct Answer: False 6. Not Answered Dragging a file from one folder to another folder on a different drive moves the folder. The Correct Answer: False 7. Not Answered Dragging a file with the right mouse button from one folder to another folder displays a shortcut menu asking whether you want to copy or move the file. The Correct Answer: True 8. Not Answered How does a program indicate that a sub-menu option on a pull-down menu will appear? The Correct Answer: An arrowhead will appear next to the pull-down menu option 12. Not Answered The Help and Support Center provides access to certain help topic categories such as "printing," but does not allow you to search using a phrase such as "printing graphics." The Correct Answer: False 13. Not Answered The menu bar appears immediately below the title bar and provides access to pull-down menus. The Correct Answer: True 14. Not Answered The mouse pointer changes to a double arrow when you are moving a window. The Correct Answer: False 15. Not Answered The Start button shows all programs currently in memory. The Correct Answer: False 16. Not Answered The Start menu allows you to switch back and forth between programs that are currently running. The Correct Answer: False 17. Not Answered The title bar provides access to close, move, or size a window. The Correct Answer: True 18. Not Answered The Windows Media Player helps you to organize your pictures and share them with others. The Correct Answer: False 19. Not Answered To create a new folder in Windows Explorer, you would choose the New command from the File menu. The Correct Answer: True 20. Not Answered To use Windows Messenger you would need an Internet connection, a list of contacts, and a Microsoft Passport. The Correct Answer: True 21. Not Answered What happens when you click and drag the border of a window outward? The Correct Answer: Either the width or the height is enlarged depending on which border you drag from 22. Not Answered What happens when you click the X button on a window? The Correct Answer: Windows closes the window 23. Not Answered Which of the following allows you to see which programs are currently open and running? The Correct Answer: None of these answers is correct 24. Not Answered Which of the following indicates a way to determine a specific file type? The Correct Answer: All of these answers are correct 25. Not Answered Which of the following is the normal process for exiting Windows? The Correct Answer: To exit Windows, you should click the Start button, then choose Shut down 26. Not Answered Which of the following is true about the Recycle Bin? The Correct Answer: Any files that have been deleted from your hard disk are still recoverable from the Recycle Bin before it is emptied. 27. Not Answered Which view in My Computer shows the maximum amount of information about each file? The Correct Answer: Details 28. Not Answered You have just copied a file from drive A to drive C, then accidentally deleted it from drive A. Which of the following methods would allow you to recover it? The Correct Answer: Drag the file from drive C to drive A 1. Not Answered Which of the following is true regarding a dialog box? The Correct Answer: Both (a) and (b) 2. Not Answered Which of the following is the first step in sizing a window? The Correct Answer: Point to any corner or border 3. Not Answered Which of the following is the first step in moving a window? The Correct Answer: Point to the title bar 4. Not Answered Which button appears immediately after a window has been maximized? The Correct Answer: The Restore button 5. Not Answered What happens to a window that has been minimized? The Correct Answer: The window shrinks to a button on the taskbar 6. Not Answered What is the significance of a faded (dimmed) command in a pull-down menu? The Correct Answer: The command is not currently accessible 7. Not Answered The Recycle Bin enables you to restore a file that was deleted from The Correct Answer: Drive C 8. Not Answered Which of the following was suggested as essential to a backup strategy? The Correct Answer: Store backup files at another location 9. Not Answered A shortcut may be created for The Correct Answer: Both (a) and (b) 10. Not Answered What happens if you click the Folders button (on the Standard Buttons toolbar in the My Computer folder) twice in a row? The Correct Answer: The left pane displays either a task pane or the hierarchical view depending on what was displayed prior to clicking the button initially 11. Not Answered The Search Companion can The Correct Answer: Both (a) and (b) 12. Not Answered Which views display miniature images of photographs within a folder? The Correct Answer: Thumbnails view and Filmstrip view 13. Not Answered Which of the following statements is true? The Correct Answer: A plus sign next to a folder indicates that its contents are hidden 14. Not Answered Ben and Jessica are both registered users on a Windows XP computer. Which of the following is a false statement regarding their personal folders? The Correct Answer: Ben can access files in Jessica’s My Documents folder 15. Not Answered When is a file permanently deleted? The Correct Answer: When you empty the Recycle Bin 16. Not Answered What happens if you (left) click and drag a file to another folder on the same drive? The Correct Answer: The file is moved 17. Not Answered How do you shut down the computer? The Correct Answer: Click the Start button, then click the Turn Off Computer command 18. Not Answered Which of the following can be accomplished with Windows Messenger? The Correct Answer: All of the above Name: Word project 1 and chap 1 2003 Status : Completed Score: 310 out of 310 points Instructions: Question 1 10 of 10 points When you launch Word, it automatically opens a blank document called Document1 Selected Answer: True Question 2 10 of 10 points To create a blank line between lines of text, you press the Insert Blank Line Button Selected Answer: False Question 3 10 of 10 points To move the insertion point in your document, you can use the arrow keys on your keyboard. Selected Answer: True Question 4 10 of 10 points If you are typing a paragraph that does not fit on a single line, you press the Enter key at the end of each line of text. Selected Answer: True Question 5 10 of 10 points The Spelling checker identifies any words not found in its dictionary, even if the words are proper names or technical terms. Selected Answer: True Question 6 10 of 10 points Pressing the Del key deletes the character to the right of the insertion point's current position. Selected Answer: True Question 7 10 of 10 points Pressing the Backspace key causes all the text to the left of the insertion point to move to the left by one space each time the Backspace key is pressed. Selected Answer: False Question 8 10 of 10 points Spelling errors are indicated by a red jagged underline, and grammar errors are indicated by a green jagged underline. Selected Answer: True Question 9 10 of 10 points The first time you try to save a new document by pressing the Save button, the Save As dialog box opens to give you the opportunity to change the name and location of the file. Selected Answer: True Question 10 10 of 10 points When you find a spelling error, you can use the shortcut menu to Selected Answer: all of the above Question 11 10 of 10 points A word-processing function where the first word to reach the right margin automatically moves to the next line is known as Selected Answer: word wrap Question 12 10 of 10 points When you type, the text is always entered at the Selected Answer: insertion point Question 13 10 of 10 points The box in the vertical scrollbar can be used to Selected Answer: do all of the above Question 14 10 of 10 points What is used to move the view of the document down one screen at a time? Selected Answer: the PgDn key Question 15 10 of 10 points When entering text within a document, the Enter key is normally pressed at the end of every: Selected Answer: paragraph Question 16 10 of 10 points Which menu contains the commands to save the current document or to open a previously saved document? Selected Answer: The File menu Question 17 10 of 10 points How do you execute the Print command? Selected Answer: All of the above Question 18 10 of 10 points The Open command: Selected Answer: brings a document from disk into memory Question 19 10 of 10 points What is the easiest way to change the phrase, revenues, profits, gross margin, to read revenues, profits, and gross margin? Selected Answer: Use the insert mode, position the cursor before the g in gross, then type the word and followed by a space. Question 20 10 of 10 points The Save command: Selected Answer: stores the document in memory on disk. Question 21 10 of 10 points A document has been entered into Word with a given set of margins, which are subsequently changed. What can you say about the number of hard and soft returns before and after the change in margins? Selected Answer: The number of hard returns is the same, but the number and/or position of the soft returns is different. Question 22 10 of 10 points Which of the following will be detected by the spell check? Selected Answer: Both (a) and (b) Question 23 10 of 10 points Which of the following is likely to be found in a custom dictionary? Selected Answer: All of the above Question 24 10 of 10 points Ted and Sally both use Word. Both have written a letter to Dr. Joel Stutz and have run a spell check on their respective documents. Ted's program flags Stutz as a misspelling, whereas Sally's accepts it as written. Why? Selected Answer: Sally has added Stutz to her custom dictionary. Question 25 10 of 10 points The spell check will do all of the following except: Selected Answer: flag properly spelled words used incorrectly Question 26 10 of 10 points The AutoCorrect feature will: Selected Answer: Both (a) and (b) Question 27 10 of 10 points When does the Save As dialog box appear? Selected Answer: The first time a file is saved using either the Save or Save As commands Question 28 10 of 10 points Which of the following is true about the thesaurus? Selected Answer: Both (a) and (b) Question 29 10 of 10 points The grammar check: Selected Answer: Implements different rules for casual and business writing. Question 30 10 of 10 points What happens if you select a word, then click the Italics button on the Formatting toolbar twice in a row? Selected Answer: The word will have the same appearance as before; that is, clicking the Italics button twice in a row has no effect. Question 31 10 of 10 points Which of the following applies to the paragraph as a whole-that is, you can apply the command anywhere within the paragraph to format the entire paragraph? Selected Answer: All of the above Name: Word project 2 and chap 2 2003 Status : Completed Score: 260 out of 260 points Instructions: Question 1 10 of 10 points To open a document that is stored on a floppy disk, you click the button on the Standard toolbar that looks like a small floppy disk. Selected Answer: True Question 2 10 of 10 points When you use the Save As command and type a new filename for a document, the original document is erased and replaced with a new file. Selected Answer: False Question 3 10 of 10 points The Click and Type feature works in the Print Layout view but does not work in the Normal view. Selected Answer: False Question 4 10 of 10 points When you make a mistake, you can reverse your error by clicking the Undo button. Selected Answer: True Question 5 10 of 10 points If you want to undo a mistake, you must do so before you type anything else. The program can undo only one previous action. Selected Answer: False Question 6 10 of 10 points The Redo button is the opposite of the Undo button. It enables you to change your mind and restore the actions that you chose to undo. Selected Answer: False Question 7 10 of 10 points If you have made 10 changes to the text and notice that the change you made six steps ago is wrong, you may click the drop-down list arrow next to the Undo button, pick that one action from the list, and undo it. The other actions are not affected. Selected Answer: True Question 8 10 of 10 points Drag -and-Drop refers to a method of erasing blocks of text in which you drag the selected text to the trash. Selected Answer: True Question 9 10 of 10 points Using the Print option on the File menu gives you more options for printing than simply clicking the Print button on the toolbar. Selected Answer: False Question 10 10 of 10 points When you cut selected text, that text is stored in a memory area called the Office Clipboard. Selected Answer: True Question 11 10 of 10 points This button reverses the undo action and returns the text to its condition prior to the undo. Selected Answer: Redo Question 12 10 of 10 points What happens when you double-click a word in a sentence? Selected Answer: The word is selected Question 13 10 of 10 points To copy using the keyboard, press __________ + C Selected Answer: Ctrl key Question 14 10 of 10 points The method used to move text from one location to another by dragging it with the mouse to a new location is known as _____________. Selected Answer: drag-and-drop Question 15 10 of 10 points Which of the following commands does not place data onto the clipboard? Selected Answer: Paste Question 16 10 of 10 points What happens if you select a block of text, copy it, move to the beginning of the document, paste it, move to the end of the document, and then click paste again? Selected Answer: The selected text will be inserted at the beginning and end of the document. Question 17 10 of 10 points What happens if you select a block of text, copy it, move to the beginning of the document, paste it, move to the end of the document, and paste the text again? Selected Answer: The selected text will appear in three places: at the original location, and at the beginning and end of the document. Question 18 10 of 10 points Which of the following are set at the paragraph level? Selected Answer: All of the above Question 19 10 of 10 points How do you change the font for existing text within a document? Selected Answer: Select the text, then choose the new font Question 20 10 of 10 points The Page Setup command can be used to change: Selected Answer: both (a) and (b) Question 21 10 of 10 points Which of the following is a true statement regarding indents? Selected Answer: The insertion point can be anywhere in the paragraph when indents are set. Question 22 10 of 10 points The default tab stops are set to: Selected Answer: Left indents every 1/2 inch. Question 23 10 of 10 points What is the effect of executing two successive Undo commands, one right after the other? Selected Answer: The last two commands prior to the first Undo command are reversed. Question 24 10 of 10 points You are in the middle of a multipage document. How do you scroll to the beginning of the document and simultaneously change the insertion point? Selected Answer: Press Ctrl + Home. Question 25 10 of 10 points Which of the following deselects a selected block of text? Selected Answer: Clicking anywhere outside the selected text Question 26 10 of 10 points Which point size would be most appropriate for ordinary text? Selected Answer: 10 Name: Word project 3 Status : Completed Score: 130 out of 130 points Instructions: Question 1 10 of 10 points When you select text and change the font, the shape of the letter changes Selected Answer: True Question 2 10 of 10 points If you format a paragraph with a hanging indent, the first line begins further to the right than the rest of the lines in the paragraph. Selected Answer: True Question 3 10 of 10 points To make the letters thicker and appear more important, you can select the text and click the button on the toolbar that has a capital letter B on it. Selected Answer: True Question 4 10 of 10 points Creating a first-line indent by pressing the spacebar key five times is the same as setting the first-line indent to 0.5 inches. Selected Answer: True Question 5 10 of 10 points There is a certain type of tab that can be used to align a column of dollar figures to that the decimal points line up. Selected Answer: True Question 6 10 of 10 points If you want to apply the formatting of one paragraph to another, select Edit, Copy, Paste Special from the menu. Selected Answer: False Question 7 10 of 10 points If you set up a tab with a dot leader, pressing the Tab key produces a series of dots between the previous text and the text at that tab. Selected Answer: True Question 8 10 of 10 points The only way to place extra space between paragraphs is to press the Enter key one or two extra times. Selected Answer: True Question 9 10 of 10 points If you want to insert a bulleted list, you can click the Bullets button and type the list. Selected Answer: False Question 10 10 of 10 points What is the correct way to create a paragraph whose first line begins to the right of the rest of the lines of text? Selected Answer: Position the pointer at the beginning of the paragraph and click the increase indent button. Question 11 10 of 10 points Which tab moves inserted text to the left as you type to ensure that the right side of the text stays aligned with the position of the tab? Selected Answer: Right tab Question 12 10 of 10 points A line of text that has the same amount of space between its first word and the left margin and its last word and the right margin uses which kind of alignment? Selected Answer: center Question 13 10 of 10 points When all the lines of a paragraph line up both the left and right margins, the paragraph is _______________. Selected Answer: justified Name: Word project 4 Status : Completed Score: 140 out of 140 points Instructions: Question 1 10 of 10 points The margins are set by using the Format option on the menu bar. Selected Answer: False Question 2 10 of 10 points The header is placed in the top margin. Selected Answer: True Question 3 10 of 10 points The text in the footer must be the same font as the text in the body of the document. Selected Answer: False Question 4 10 of 10 points It is possible to enter a special date field into the header that automatically updates to the current date every time the document is used or printed. Selected Answer: True Question 5 10 of 10 points If a new topic starts near the bottom of the page, it is best to insert serveral blank lines in front of it to force it to the top of the next page. Selected Answer: True Question 6 10 of 10 points Print Preview enables you to see servel pages at a time so that you can see how the text flows from one page to the next. Selected Answer: True Question 7 10 of 10 points When you first place a clip art image in a document, it is treated as a large character in a line of text. Selected Answer: True Question 8 10 of 10 points If you use automatic page numbering, you have to use the Recalculate Page Numbers command when you delete or add enough text to change the previous page numbers. Selected Answer: False Question 9 10 of 10 points Headers and footers are used for information you want to appear at the top and bottom of every page (with the possible exception of the title page). Selected Answer: True Question 10 10 of 10 points Only one format is available for the automatic date in a header or footer. Dates must be in the dd/mm/yy format. Selected Answer: False Question 11 10 of 10 points Which dialog box do you use to change the margins in a document? Selected Answer: Page Setup Question 12 10 of 10 points To create a header or footer in Word, which of the following options would you choose? Selected Answer: View, Header or Footer Question 13 10 of 10 points What can the Print Preview window be used to do? Selected Answer: all of the above Question 14 10 of 10 points To add a Microsoft clip art image to a document, click where you want the image to be placed and choose ________ from the menu. Selected Answer: Insert, Picture, Clip Art Name: Word project 5 Status : Completed Score: 150 out of 150 points Instructions: Question 1 10 of 10 points Tables in word consist of rows and columns of cells that resemble a spreadsheet. Selected Answer: True Question 2 10 of 10 points To create a table in a document, you enter the data, using tabs to separate the columns; select the data and choose Format, Tabke from the menu. Selected Answer: False Question 3 10 of 10 points When you enter text in a table, the text is aligned to the left by default. Selected Answer: True Question 4 10 of 10 points To add an extra row when you reach the last cell at the bottom of a table, press the Tab key. Selected Answer: True Question 5 10 of 10 points When you enter data into cells of a table, you press the Enter key to move from one cell to the next. Selected Answer: False Question 6 10 of 10 points To center a table on the page, select the table and click the Center button. Selected Answer: True Question 7 10 of 10 points When you enter numbers in a table, they automatically align to the right side of each cell. Selected Answer: False Question 8 10 of 10 points A row or column of data can be aligned separately from the rest of the table. Selected Answer: True Question 9 10 of 10 points When you use an AutoFormat style, you cannot make changes to the formatting or alignment. Selected Answer: False Question 10 10 of 10 points AutoFormat provides a quick way to format a table. Selected Answer: True Question 11 10 of 10 points Which key(s) do you press to add another row to the table if the pointer is in the lower-right cell (the last cell in the table)? Selected Answer: Tab Question 12 10 of 10 points To wrap text around a table, _____________. Selected Answer: select the table, choose Table, Table Properties from the menu, and select Around Question 13 10 of 10 points Which of the following is the method you use to select a column in a Table? Selected Answer: Click the column, and choose Table, Select, Column from the menu. Question 14 10 of 10 points What is the name of the intersection of a row and a column in a table? Selected Answer: cell Question 15 10 of 10 points Which of the following types of information can be placed in a table? Selected Answer: all of the above 1. Not Answered When you are using Word, you should not press the Enter key at the end of each paragraph. The Correct Answer: False 2. Not Answered When Overtype mode is toggled on, text will move to the right as you type. The Correct Answer: False 3. Not Answered Clicking the Minimize button will shrink the Word program to a button on the taskbar. The Correct Answer: True 4. Not Answered The Save and Open commands are both found on the Standard toolbar. The Correct Answer: True 5. Not Answered The Print Layout view shows graphic elements in their exact position. The Correct Answer: True 6. Not Answered The task pane is available in all Office applications. The Correct Answer: True 7. Not Answered The spell checker will not catch duplicate words nor will it catch irregular capitalization. The Correct Answer: False 8. Not Answered AutoCorrect will automatically change taht to that. The Correct Answer: True 9. Not Answered The Save As command can save another copy of a document under a different file name, but it cannot save a document as a different file type. The Correct Answer: False 10. Not Answered If you are revising a document named “sports” and then decide to quit without saving, all of your editing changes will appear in the automatic backup copy of the document, but not in the main file. The Correct Answer: False 11. Not Answered The Enter key on the keyboard is an example of a toggle switch. The Correct Answer: False 12. Not Answered When the Insert mode is toggled on, text will move to the right as you type. The Correct Answer: True 13. Not Answered The backspace key deletes one character to the right of the insertion point. The Correct Answer: False 14. Not Answered The Standard and Formatting toolbars can be displayed on one row to save space within the application window. The Correct Answer: True 15. Not Answered The Grammar Check feature in Word is always run in conjunction with the Spell Check. The Correct Answer: False 16. Not Answered A(n) __ is created by the user when he or she presses the Enter key at the end of a paragraph. The Correct Answer: Hard return. 17. Not Answered Which of the following keys deletes text to the left of the insertion point? The Correct Answer: Backspace. 18. Not Answered Which of the following commands is found on both the File menu and the Standard toolbar? The Correct Answer: None of these answers is correct. 19. Not Answered Which of the following commands is found on Formatting toolbar? The Correct Answer: Underline. 20. Not Answered Which view of a document is best used to check the position of headers, footers, and graphical elements in their exact position? The Correct Answer: Print Layout. 21. Not Answered Suppose you type the phrase < i >before the game< /i > and then want to insert the word football between the and game. What is the easiest way to do this? The Correct Answer: Use the insert mode, position the cursor before the g in game, then type the word football followed by a space. 22. Not Answered Assume you have entered the following sentence in a Word document. Cindy Stevens, a member of the AMA, went to the Microsoft Word session at the conference this fall. Which of the following is likely to be found in the standard Word spell check dictionary? The Correct Answer: Microsoft Word. 23. Not Answered Which feature of Word will change TOo to Too or ATC to American Technology Counsel as you are typing the document? The Correct Answer: AutoCorrect. 24. Not Answered Which of the following commands is available from the task pane? The Correct Answer: All answers are correct. 25. Not Answered Which ruler enables you to change the top or bottom margins? The Correct Answer: The Vertical Ruler. 1. Not Answered When entering text within a document, the Enter key is normally pressed at the end of every: The Correct Answer: Paragraph 2. Not Answered Which menu contains the commands to save the current document, or to open a previously saved document? The Correct Answer: The File menu 3. Not Answered How do you execute the Print command? The Correct Answer: All of the above 4. Not Answered The Open command: The Correct Answer: Brings a document from disk into memory 5. Not Answered What is the easiest way to change the phrase, revenues, profits, gross margin, to read revenues, profits, and gross margin? The Correct Answer: Use the insert mode, position the cursor before the g in gross, then type the word and followed by a space 6. Not Answered The Save command: The Correct Answer: Stores the document in memory on disk 7. Not Answered A document has been entered into Word with a given set of margins, which are subsequently changed. What can you say about the number of hard and soft returns before and after the change in margins? The Correct Answer: The number of hard returns is the same, but the number and/or position of the soft returns is different 8. Not Answered Which of the following is detected by the spell check? The Correct Answer: Both (a) and (b) 9. Not Answered Which of the following is likely to be found in a custom dictionary? The Correct Answer: All of the above 10. Not Answered Ted and Sally both use Word. Both have written a letter to Dr. Joel Stutz and have run a spell check on their respective documents. Ted’s program flags Stutz as a misspelling, whereas Sally’s accepts it as written. Why? The Correct Answer: Sally has added Stutz to her custom dictionary 11. Not Answered The spell check will do all of the following except: The Correct Answer: Flag properly spelled words used incorrectly 12. Not Answered The AutoCorrect feature will: The Correct Answer: Both (a) and (b) 13. Not Answered When does the Save As dialog box appear? The Correct Answer: The first time a file is saved using either the Save or Save As commands 14. Not Answered Which of the following is true about the thesaurus? The Correct Answer: Both (a) and (b) 15. Not Answered The grammar check: The Correct Answer: Implements different rules for casual and business writing 16. Not Answered What happens if you select a word, then click the Italic button on the Formatting toolbar twice in a row? The Correct Answer: The word will have the same appearance as before; clicking the Italic button twice in a row has no effect 17. Not Answered Which of the following applies to the paragraph as a whole—that is, you can apply the command anywhere within the paragraph to format the entire paragraph? The Correct Answer: All of the above 18. Not Answered Which view is new to Microsoft Word 2003? The Correct Answer: Reading Layout 1. Not Answered The Undo command enables you to undo only the last three changes to a document. The Correct Answer: False 2. Not Answered The Find command can replace whole words only. The Correct Answer: False 3. Not Answered Ctrl + X is the keyboard shortcut for the Cut command. The Correct Answer: True 4. Not Answered A monospaced typeface allocates space according to the width of the character. The Correct Answer: False 5. Not Answered You can use the Format Font command to change the typeface style, as well as apply the underline option. The Correct Answer: True 6. Not Answered You change your headers and footers parameters within the Page Setup command. The Correct Answer: True 7. Not Answered To use the Format Painter, you would click on the Format Painter button, select the text that has the formatting you wish to copy, and then click and drag over the text to which you wish to apply the same identical formatting characteristics. The Correct Answer: False 8. Not Answered The first line indent affects only the first line in the paragraph, whereas hanging indent sets the first line of a paragraph at the left indent and indents the remaining lines. The Correct Answer: True 9. Not Answered The Columns command is found on the Tools menu. The Correct Answer: False 10. Not Answered The Microsoft Office clipboard cannot hold more than one item. The Correct Answer: False 11. Not Answered Which of the following is true in relation to the Office clipboard? The Correct Answer: You can copy multiple items to the Office clipboard. 12. Not Answered You are planning to use the Replace command. Which of the following statements is true? The Correct Answer: All of these answers are correct. 13. Not Answered Which of the following commands gives you control over the typeface, type size, and style of the text? The Correct Answer: Format Font command. 14. Not Answered Which page layout orientation will print the document at 11 x 8 ½ rather than the 8 ½ by 11 default? The Correct Answer: Landscape orientation. 15. Not Answered All of the following alignment options have a flush left margin except: The Correct Answer: Centered. 16. Not Answered The default tab stops are set at: The Correct Answer: Every one half of an inch. 17. Not Answered The Widows and Orphans command will affect: The Correct Answer: All of these answers are correct. 18. Not Answered Which of the following is true pertaining to line spacing? The Correct Answer: All of these answers are correct. 19. Not Answered Which of the following statements is true pertaining to the Borders and Shading command? The Correct Answer: If no text is selected, the Border command will place a border around the entire paragraph. 20. Not Answered Which of the following statements is true in relation to column formatting? The Correct Answer: All of these answers are correct. 1. Not Answered Which of the following commands does not place data onto the clipboard? The Correct Answer: Paste 2. Not Answered What happens if you select a block of text, copy it, move to the beginning of the document, paste it, move to the end of the document, and paste the text again? The Correct Answer: The selected text will appear in three places: at the original location, and at the beginning and end of the document 3. Not Answered What happens if you select a block of text, cut it, move to the beginning of the document, paste it, move to the end of the document, and paste the text again? The Correct Answer: The selected text will appear in two places: at the beginning and end of the document 4. Not Answered Which of the following are set at the paragraph level? The Correct Answer: All of the above 5. Not Answered How do you change the font for existing text within a document? The Correct Answer: Select the text, then choose the new font 6. Not Answered The Page Setup command can be used to change: The Correct Answer: Both (a) and (b) 7. Not Answered Which of the following is a true statement regarding indents? The Correct Answer: The insertion point can be anywhere in the paragraph when indents are set 8. Not Answered The default tab stops are set to: The Correct Answer: Left indents every ½ inch 9. Not Answered The spacing in an existing multipage document is changed from single spacing to double spacing throughout the document. What can you say about the number of hard and soft page breaks before and after the formatting change? The Correct Answer: The number of hard page breaks is the same, but the number and/or position of the soft page breaks is different 10. Not Answered Which of the following describes the Arial and Times New Roman fonts? The Correct Answer: Arial is a sans serif font, Times New Roman is a serif font 11. Not Answered What is the effect of executing two successive Undo commands, one right after the other? The Correct Answer: The last two commands prior to the first Undo command are reversed 12. Not Answered You are in the middle of a multipage document. How do you scroll to the beginning of the document and simultaneously change the insertion point? The Correct Answer: Press Ctrl+Home 13. Not Answered Which of the following substitutions can be accomplished by the Find and Replace command? The Correct Answer: Both (a) and (b) 14. Not Answered Which of the following deselects a selected block of text? The Correct Answer: Clicking anywhere outside the selected text 15. Not Answered Which point size would be most appropriate for ordinary text? The Correct Answer: 10 16. Not Answered The find and replacement strings must be The Correct Answer: None of the above 17. Not Answered Which of the following is a true statement about the Windows and Office clipboards? The Correct Answer: The Windows clipboard can hold only a single item, but the Office clipboard can hold multiple items 18. Not Answered Which of the following is set at the section level? The Correct Answer: Columns and margins 1. Not Answered A Word document can be enhanced by adding multiple objects. The Correct Answer: True 2. Not Answered The Microsoft Clip Organizer contains only clip art images and photographs. The Correct Answer: False 3. Not Answered The Format Picture command enables you to wrap text around, behind, and in front of a picture. The Correct Answer: True 4. Not Answered Symbols inserted in a Word document can be formatted as bold, italics, or underline. The Correct Answer: True 5. Not Answered The AutoCorrect feature will substitute © for (c). The Correct Answer: True 6. Not Answered A hyperlink can connect you to other Web pages only within your own company. The Correct Answer: False 7. Not Answered When a document specifically says it is in the public domain, it can be used only for nonprofit uses. The Correct Answer: False 8. Not Answered Endnotes provide additional source information and appear at the end of a document. The Correct Answer: True 9. Not Answered A partially completed document that contains formatting, text, and/or graphics is called a wizard. The Correct Answer: False 10. Not Answered A mail merge document makes use of a main document and a data source. The Correct Answer: True 11. Not Answered Which of the following allows you to insert accented characters, such as the "é" in Résumé? The Correct Answer: Insert Symbol command. 12. Not Answered Which of the following is true about moving an object in a Word document? The Correct Answer: To move an object in a Word document, you would click on the object once, then point anywhere on the object except at a sizing handle, click, and then drag to the desired position. 13. Not Answered Which of the following is true about hyperlink references? The Correct Answer: All of these answers are correct. 14. Not Answered Which of the following commands are available from the Drawing toolbar? The Correct Answer: All of these answers are correct. 15. Not Answered ___ provides legal protection to the author for a written or artistic work. The Correct Answer: Copyright. 16. Not Answered A ___ makes the process even easier by asking a series of questions, and then creating a customized template based on your answers. The Correct Answer: All of these answers are correct. 17. Not Answered Which of the following statements is true about saving pictures from the Web? The Correct Answer: To save a picture from the Web, simply hover the mouse over the picture, click the right mouse button, and choose the Save Picture As command. 18. Not Answered Which of the following toolbars contains the crop tool? The Correct Answer: The Picture toolbar. 19. Not Answered Which of the following statements is true? The Correct Answer: The mail merge feature makes use of a main document and a data source. 20. Not Answered A ____ is created from the mail merge process. The Correct Answer: form letter. 1. Not Answered How do you change the size of a selected object so that the height and width change in proportion to one another? The Correct Answer: Click and drag any of the four corner handles in the direction you want to go 2. Not Answered How do you insert a hyperlink into a Word document? The Correct Answer: Both (a) and (b) 3. Not Answered How do you search for clip art using the Clip Organizer? The Correct Answer: Both (a) and (b) 4. Not Answered Which of the following objects can be inserted into a document? The Correct Answer: All of the above 5. Not Answered Which of the following is true about a mail merge? The Correct Answer: Both (a) and (b) 6. Not Answered Which of the following best describes the documents that are associated with a mail merge? The Correct Answer: All of the above 7. Not Answered Which of the following is true about footnotes or endnotes? The Correct Answer: Both (a) and (b) 8. Not Answered Which of the following is true about the Insert Symbol command? The Correct Answer: Both (a) and (b) 9. Not Answered Which of the following is true regarding objects and the associated toolbars? The Correct Answer: Both (a) and (b) 10. Not Answered Which of the following objects can be downloaded from the Web for inclusion into a Word document? The Correct Answer: All of the above 11. Not Answered What is the significance of the Shift key in conjunction with various tools on the Drawing toolbar? The Correct Answer: All of the above 12. Not Answered What happens if you enter the text www.intel.com into a document? The Correct Answer: The entry is converted to a hyperlink, and further, the text will be underlined and displayed in a different color 13. Not Answered Which of the following is true about wizards? The Correct Answer: They are accessed from the General Templates link on the task pane 14. Not Answered Which of the following is true about a Web document that was created from within Microsoft Word? The Correct Answer: Both (a) and (b) 15. Not Answered Microsoft WordArt can be used to: The Correct Answer: All of these answers are correct 16. Not Answered Which of the following was introduced into Word 2003 to simplify the creation of a Web page from within Microsoft Word? The Correct Answer: Single File Web Page format 17. Not Answered What provides legal protection to the author for a written or artistic work? The Correct Answer: Copyright 18. Not Answered How do you insert a date into a document so that the date is automatically updated when the document is retrieved? The Correct Answer: Use the Insert Date and Time command in the Insert menu and check the box to insert the date as a field 1. Not Answered In a Word table, a single cell can be split into multiple cells by choosing the Split Cells command from the Table menu. The Correct Answer: True 2. Not Answered To move to the next available cell in a table, press Shift+Tab. The Correct Answer: False 3. Not Answered A paragraph style cannot be applied to just one sentence in a paragraph. The Correct Answer: True 4. Not Answered Outline view offers a structural view of a document that can be collapsed and expanded as necessary. The Correct Answer: True 5. Not Answered When using the AutoFormat command, the Normal style will be assigned to one-line paragraphs. The Correct Answer: False 6. Not Answered The Insert Page Number command does not allow use of Roman numerals, and you must start at page one. The Correct Answer: False 7. Not Answered A document can contain multiple sections, which allows for different headers, footers, and margins. The Correct Answer: True 8. Not Answered To create an index, you must go through a document and select each single occurrence of an entry individually to be included in the index. The Correct Answer: False 9. Not Answered The Go To command can be accessed by clicking the F5 function key. The Correct Answer: True 10. Not Answered Document sections enable you to apply different margins and/or page numbers to different parts of the document. The Correct Answer: True 11. Not Answered You do not have to identify headings in a document in order to create an automatic Table of Contents. The Correct Answer: False 12. Not Answered Assume you have selected a bulleted list in your document. What happens when you click the Bullets button on the Formatting toolbar? The Correct Answer: The bullets are removed. 13. Not Answered Which of the following allows you to format a numbered list? The Correct Answer: The Bullets and Numbering command on the Format menu. 14. Not Answered Which of the following statements regarding Word tables is true? The Correct Answer: None of these answers is correct. 15. Not Answered Which of the following statements regarding Word tables is true? The Correct Answer: All of these answers are correct. 16. Not Answered Which of the following statements regarding styles is true? The Correct Answer: A paragraph style stores paragraph formatting, such as line spacing, indents, and text flow, whereas a character style stores character formatting, such as font, font size, and font style. 17. Not Answered The advantage of Outline view versus Normal view is: The Correct Answer: All of these answers are correct. 18. Not Answered Which of the following statements regarding the AutoFormat command is true? The Correct Answer: All of these answers are correct. 19. Not Answered In Word, where can page numbers appear on a page? The Correct Answer: Page numbers can be left aligned, right aligned, or centered at the top or bottom of a page. 20. Not Answered What does it mean when a Word document is Web enabled? The Correct Answer: Web enabled means that the Word application will automatically detect and highlight any hyperlinks. 21. Not Answered To change the level within a numbered outline, which command would you choose? The Correct Answer: Either the Decrease Indent button or the Increase Indent button on the Formatting toolbar. 22. Not Answered Which of the following statements is true regarding inserting or deleting rows and/or columns in a table? The Correct Answer: To insert a column, click in the cell where you want the column to go to the left or right, then click the Insert command on the Table menu. 23. Not Answered In which view do you see headers and footers? The Correct Answer: Print Layout view. 24. Not Answered Which of the following is true about the Outline view? The Correct Answer: All of these answers are correct. 1. Not Answered Which of the following can be stored within a paragraph style? The Correct Answer: All of the above 2. Not Answered What is the easiest way to change the alignment of five paragraphs scattered throughout a document, each of which is formatted with the same style? The Correct Answer: Change the format of the existing style, which changes the paragraphs 3. Not Answered The AutoFormat command does not: The Correct Answer: Apply boldface italics to terms that require additional emphasis 4. Not Answered Which of the following is used to create a conventional outline? The Correct Answer: The Bullets and Numbering command 5. Not Answered In which view do you see headers and/or footers? The Correct Answer: Print Layout view 6. Not Answered Which of the following numbering schemes can be used with page numbers? The Correct Answer: All of the above 7. Not Answered Which of the following is a true statement regarding headers and footers? The Correct Answer: Neither (a) nor (b) 8. Not Answered Which of the following is a false statement regarding lists? The Correct Answer: The bullets or numbers cannot be removed 9. Not Answered Page numbers can be specified in: The Correct Answer: A header or a footer 10. Not Answered Which of the following is true regarding the formatting within a document? The Correct Answer: Neither (a) nor (b) 11. Not Answered What happens when you press the Tab key from within a table? The Correct Answer: The insertion point moves to the next column in the same row or the first column in the next row if you are at the end of the row 12. Not Answered Which of the following is true about pagination in the current document given that the status bar displays "Page 5 Section 3 7/9"? The Correct Answer: The insertion point is on the seventh page of the document, which is numbered as page 5 13. Not Answered The Edit Go To command enables you to move the insertion point to: The Correct Answer: Any of the above 14. Not Answered Once a table of contents has been created and inserted into a document: The Correct Answer: Neither (a) nor (b) 15. Not Answered Which of the following is a false statement about the Outline view? The Correct Answer: It is used to create a conventional outline 16. Not Answered What is the best way to create a conventional outline in a Word document? The Correct Answer: Use the Outline Numbered tab within the Bullets and Numbering command 17. Not Answered Which of the following is a predefined Word style that is available in every document? The Correct Answer: All of these answers are correct 18. Not Answered What happens if you modify the Body Text style in a Word document? The Correct Answer: Only those paragraphs formatted with the Body Text style will be changed 1.In the Normal view you can see both text and graphics on every slide. The Correct Answer: True 2.The Slide Show view is used to view your presentation electronically on the computer. The Correct Answer: True 3.A PowerPoint file name can contain up to 255 characters, including spaces, commas, and/or periods. The Correct Answer: True 4.If you rearrange the order of slides in the Slide Sorter view, you will not see the new slide order when you look at the presentation in Slide Show view. The Correct Answer: False 5.PowerPoint provides a set of predefined slide formats called placeholders. The Correct Answer: False 6.Once you choose a slide layout, you can change the layout only as long as you have not typed on the slide. The Correct Answer: False 7.Both the Tab key and the Demote button on the Outline toolbar will enter second-level bullets. The Correct Answer: True 8.Animation effects control the way one slide moves off the screen and the next slide appears. The Correct Answer: False 9.The Drawing toolbar contains commands to format clip art and to change the size of the clip art. The Correct Answer: False 10.A linked object is stored within the presentation. The Correct Answer: False 11.A template specifies the color scheme and placeholders on each slide. The Correct Answer: True 12.In which of the following ways can you deliver a PowerPoint presentation? The Correct Answer: All of these answers are correct. 13.In which PowerPoint view can you see the Slide, Outline, and Notes Page in a single window? The Correct Answer: Normal view 14.Which of the following design specifications is preset in a PowerPoint template? The Correct Answer: All of these answers are correct. 15.Which of the following are considered to be objects? The Correct Answer: All of these answers are correct. 16.Which of the following is true about animation effects? The Correct Answer: Animation effects can be applied to bulleted text and a piece of clip art. 17.Which of the following is true about elements in a PowerPoint presentation? The Correct Answer: None of these answers is correct. 18.Assume you are in the middle of a PowerPoint Slide Show and want to add an annotation to the current slide. You can press Ctrl+P to change the mouse pointer to a pen and then press ____________ at any time to change the mouse pointer back to an arrow. The Correct Answer: Ctrl+A 19.Where can you find a list of available transition effects? The Correct Answer: The task pane 1.How do you save changes to a PowerPoint presentation? The Correct Answer: Either (a) and (b) 2.Which of the following can be printed in support of a PowerPoint presentation? The Correct Answer: All of the above 3.Which toolbars are typically displayed in the Normal view? The Correct Answer: All of the above 4.Ctrl+Home and Ctrl+End are keyboard shortcuts that move to the beginning or end of the presentation in the: The Correct Answer: Neither (a) nor (b) 5.The predefined slide formats in PowerPoint are known as: The Correct Answer: Slide layouts 6.Which menu contains the commands to save the current presentation, or to open a previously saved presentation? The Correct Answer: The File menu 7.The Open command: The Correct Answer: Brings a presentation from disk into memory 8.The Save command: The Correct Answer: Stores the presentation in memory on disk 9.Which of the following can be displayed in the task pane? The Correct Answer: Both (a) and (b) 10.Where will the insertion point be after you complete the text for a bullet in the outline and press the Enter key? The Correct Answer: On the next bullet at the same level of indentation 11.Which of the following is true about an Excel chart that is linked to both a Word document and a PowerPoint presentation? The Correct Answer: Any changes to the chart will be reflected automatically in both the Word document and the PowerPoint presentation. 12.What advantage, if any, is there to collapsing the outline so that only the slide titles are visible? The Correct Answer: More slides are displayed at one time, making it easier to rearrange the slides in the presentation 13.Which of the following is a true statement regarding transition and build effects? The Correct Answer: Neither (a) nor (b) 14.Which of the following is true? The Correct Answer: Both (a) and (b) 15.Which of the following is a true statement regarding the Microsoft Clip Organizer? The Correct Answer: Both (a) and (b) 16.You are working on a PowerPoint presentation called First Presentation. You pull down the File menu, click the Save As command, and save the file with a new name, First Presentation Solution. Which of the following statements is true? The Correct Answer: Both (a) and (b) 17.What is the effect of executing two successive Undo commands, one right after the other? The Correct Answer: The last two commands prior to the first Undo command are reversed 18.Which of the following is a true statement about the Windows and Office clipboards? The Correct Answer: The Windows clipboard holds only a single item; the Office clipboard can hold multiple items 1.Once timings are rehearsed and accepted, the timings cannot be changed. The Correct Answer: False 2.Hidden slides cannot be accessed during a presentation in Slide Show view. The Correct Answer: False 3.The AutoContent Wizard provides a starting place for your presentation by providing you with a color scheme, custom formatting, and a general outline. The Correct Answer: True 4.You can send your presentation to an e-mail address using the Send To command on the File menu. The Correct Answer: True 5.The Insert Table command is found on the Insert menu. The Correct Answer: True 6.You can add a footer but not a header to your slides, The Correct Answer: False 7.A Copyright provides legal protection to a written or artistic work. The Correct Answer: True 8.When a written work specifically states that it is in the public domain, it can be used without permission from the author, as long as it is used for educational purposes only. The Correct Answer: False 9.In a PowerPoint presentation, a photograph can be cropped, formatted for black and white, or even rotated. The Correct Answer: True 10.Photos can be imported into PowerPoint from your hard disk and digital camera, but cannot be directly imported from a scanner. The Correct Answer: False 11.Animation applies to the slide as a whole. The Correct Answer: False 12.Animation controls the appearance of individual elements on a single slide. The Correct Answer: True 13.Which of the following is true about rehearsing the timings in a presentation? The Correct Answer: Slide Show view is used to rehearse timings in a presentation. 14.Which of the following is true regarding the Hide Slide command? The Correct Answer: To hide a slide, click the Slide Sorter view button, select the slide you want to hide, right-click the mouse button, and then choose the Hide Slide command 15.Which of the following is true about the AutoContent Wizard? The Correct Answer: All of these answers are correct. The AutoContent Wizard is accessed through the task pane. 16.Which of the following is true about moving an object in a PowerPoint Slide? The Correct Answer: To move an object in a slide, click on the object once, then point anywhere on the object except at a sizing handle, click, and then drag the object to the desired position. 17.Which of the following are true? The Correct Answer: You can save a PowerPoint presentation as a Web page by choosing Save As Web Page from the File menu. 18.____________ provides legal protection to the author for a written or artistic work. The Correct Answer: Copyright 19.Which of the following statements is true about saving picture from the Web? The Correct Answer: To save a picture from the Web, simply hover the cursor over the picture, click the right mouse button, and choose the Save Picture As command from the menu that pops up. 20.Which menu contains the command to insert a Word outline? The Correct Answer: None of the answers is correct. 1.How do you insert a hyperlink into a PowerPoint presentation? The Correct Answer: Both (a) and (b) 2.Which of the following is true about hidden slides? The Correct Answer: Neither (a) nor (b) 3.Which view displays the timings for individual slides after the timings have been established by rehearsing the presentation? The Correct Answer: Slide Sorter view 4.Which of the following is true about annotating a slide? The Correct Answer: The annotations are entered using the pen during the slide show 5.Which of the following can be printed for a presentation? The Correct Answer: All of the above 6.Which of the following is a true statement regarding the review of a presentation? The Correct Answer: The comments of multiple reviewers can be merged in a single session 7.Which of the following cannot be accomplished directly by using the Format Photo Album command? The Correct Answer: Adding custom animation to the individual photos 8.How do you crop a picture and then enlarge the result? The Correct Answer: Select the crop tool, click and drag any border toward the center, click off the picture, then click and drag any corner outward 9.Which of the following is not required to dissolve a black-and-white photograph into a color photograph? The Correct Answer: Apply the "dissolve in" entrance effect to the color photograph 10.Which of the following can be applied to a given object on a specific slide? The Correct Answer: Both an entrance and an exit effect 11.Which entrance effect(s) should be applied to multiple objects on a slide so that the objects appear one after another without having to click the mouse? The Correct Answer: Any entrance effect starting after the previous object 12.Which of the following parameters can be set for the "fly in" entrance effect? The Correct Answer: All of the above 13.Where can you store photographs for use in a subsequent presentation? The Correct Answer: All of the above 14.The AutoContent Wizard: The Correct Answer: Creates a generic presentation that can be customized as necessary 15.Which of the following can be done to customize a presentation created by the AutoContent Wizard? The Correct Answer: All of the above 16.Which of the following provides legal protection to the author for a written or artistic work? The Correct Answer: Copyright 17.Which of the following keyboard shortcuts is correct with respect to animating a presentation? The Correct Answer: Both (a) and (b) 18.Which format is most commonly associated with photographs? The Correct Answer: Joint Photograph Experts Group (JPEG), which is pronounced "jpeg" 1.There is no way to delete a box in an Organization Chart, you must delete the whole chart and start over. The Correct Answer: False 2.Chart types include columns, bars, lines, pies, and more. The Correct Answer: True 3.When you create a graph, data is entered directly into the default Datasheet. The Correct Answer: True 4.Once you enter data into the datasheet, you cannot delete the data series. If you need to make any changes you will have to delete the entire chart and start over again. The Correct Answer: False 5.The Cycle diagram is used to show elements revolving around a core. The Correct Answer: False 6.Adding a coworker box to a coworker in an organization chart gives the new coworker equal status. The Correct Answer: True 7.A target diagram is used to show steps toward a goal. The Correct Answer: True 8.In a chart, the data points are used for descriptive entries. The Correct Answer: False 9.A side-by-side chart would best be used to emphasize total revenue. The Correct Answer: False 10.If you specify the data series in rows, Microsoft Graph will use the first column for category labels on the X axis. The Correct Answer: False 11.If you specify the data series in columns, Microsoft Graph will use the first column for category labels on the X axis. The Correct Answer: True 12.In a Custom Animation, an entrance effect will have a red color code on the advanced timeline. The Correct Answer: False 13.There is NOT a way to animate individual branch boxes for an organization chart. The Correct Answer: False 14.To select multiple objects on a slide, press and hold the Ctrl key, and then click each object. The Correct Answer: True 15.In an organization chart, line and box colors can be changed. The Correct Answer: True 16.Which of the following diagrams should be used to show overlap between elements? The Correct Answer: Venn diagram 17.What is the advanced timeline? The Correct Answer: The advanced timeline shows the sequence and duration of each animation effect. 18.The emphasis custom animation effect will be color coded: The Correct Answer: yellow. 1.Which diagram type is recommended to show hierarchical relationships? The Correct Answer: Organization chart 2.You have created an organization chart with two levels. The president is at the top and there are three vice presidents. How do you add a fourth vice president? The Correct Answer: Click in the rightmost vice president’s box and add a coworker 3.Which of the following best describes the formatting options for a diagram? The Correct Answer: Both A and B 4.Which of the following cannot be accomplished using the Change to button on the Diagram toolbar? The Correct Answer: Change an organization chart to a cycle diagram 5.Which of the following is true regarding custom animation? The Correct Answer: An object may have both an entrance effect and an exit effect 6.Which of the following best describes the colors associated with custom animation effects? The Correct Answer: Green, red, and yellow for entrance, exit, and emphasis, respectively 7.Which of the following parameters is not specified in conjunction with the "Fly in" entrance effect? The Correct Answer: The exit path 8.Which of the following animations is available for an organization chart? The Correct Answer: All of the above 9.What happens if you click the View Datasheet button on the Microsoft Graph toolbar twice in a row? The Correct Answer: The datasheet is in the same status as it was before it was clicked 10.Which of the following is true of data series that are plotted in rows? The Correct Answer: Both A and B 11.Which of the following is true of data series that are plotted in columns? The Correct Answer: Both A and B 12.How do you create a new slide containing a chart? The Correct Answer: All of the above 13.Which effect will display the columns in a stacked column chart one at a time? The Correct Answer: Animation by category 14.Custom Animation enables you to: The Correct Answer: Both A and B 15.You are working on an organization chart. The hashed border surrounds the drawing canvas, but none of the objects in the chart is selected. What happens if you press the Del key? The Correct Answer: The entire organization chart is deleted 16.Nothing, since no objects are selected within the drawing area The Correct Answer: Periodic table 17.What happens if you click a chart that is not currently selected? The Correct Answer: The chart is selected 18.What happens if you double click a chart that is not currently selected? The Correct Answer: The application that created the chart (e.g., Microsoft Graph) is started 1.A template controls every aspect of a slide except for the size and placement of bullets. The Correct Answer: False 2.An action button will take you to a Web site at another location. The Correct Answer: False 3.To show a hidden slide during a slide presentation you must left click your mouse on the screen and then choose the Go To Slide command to pick the hidden slide from the list. The Correct Answer: False 4.The slide master stores information about the template, including font styles, placeholder sizes and positions, background design, and color schemes. The Correct Answer: True 5.The Sound Recorder is installed with every PowerPoint application. The Correct Answer: False 6.To make a single change that affects the slide design on Slides 3 and 4 but not on Slides 1 and 5, you must first be in the Normal View to select the slides you want to change. The Correct Answer: False 7.Pressing the [W] while giving a presentation will turn the screen white. The Correct Answer: True 8.You can save a PowerPoint presentation as a Web page by choosing Save As Web Page from the File menu. The Correct Answer: True 9.To upload a Web PowerPoint presentation you need a Web server and Internet access only. The Correct Answer: False 10.The single file Web page format saves your file with an HTML extension. The Correct Answer: False 11.There is no way to tell how long a sound recording is when it is created using the Record Narration command. The Correct Answer: False 12.A custom show can only consist of one subset of slides within a presentation. The Correct Answer: False 13.A Web broadcast can be live or recorded. The Correct Answer: True 14.A live Web Broadcast is a one-way connection. The Correct Answer: True 15.An online meeting is a two-way connection. The Correct Answer: True 16.Which of the following are true statements about using the Sound Recorder? The Correct Answer: The Sound Recorder is a Windows accessory. 17.To add an action button to every slide in a presentation at one time you would use the: The Correct Answer: Slide Master. 18. What is the purpose of a custom show? The Correct Answer: To save time if you are delivering the same presentation to multiple audiences 19.For which of the following would you send invitations to attend? The Correct Answer: A live broadcast 20.Which of the following would have a two-way connection? The Correct Answer: An online meeting 1.How do you insert a corporate logo or other identifying information on every slide in a presentation? The Correct Answer: Insert the object on the title and slide masters 2.Which of the following is true? The Correct Answer: PowerPoint supplies many different templates, and each template in turn has multiple color schemes 3.Which of the following is true? The Correct Answer: All of the above 4.What happens if you click the Hide Slide button twice in a row? The Correct Answer: The slide has the same status as before the button was clicked initially 5.What is the best way to switch between PowerPoint and Internet Explorer if both are open? The Correct Answer: Click the appropriate button on the taskbar 6.Internet Explorer can display a Web page stored on: The Correct Answer: All of the above 7.How do you save a presentation as a Web page? The Correct Answer: Web Page command 8.Which of the following requires an Internet connection? The Correct Answer: Using Internet Explorer to view the Microsoft home page 9.A Record Narration command that checks the box to link narrations will: The Correct Answer: Both A and B 10.You are using Internet Explorer to view a presentation saved as a Single File Web Page when you notice an error. You return to PowerPoint and fix the presentation. Which of the following must you do in order to see the changes in Internet Explorer? The Correct Answer: Both A and B 11.What sound quality and approximate storage requirement was recommended for recording a voice to narrate a presentation? The Correct Answer: Telephone quality at 10 kb/sec 12.Which of the following is true? The Correct Answer: Both A and B 13.Which of the following is true about a custom slide show? The Correct Answer: It contains a subset of the slides in a presentation 14.Which of the following was introduced in Office 2003? The Correct Answer: The Single File Web Page format 15.Which vehicle is best to deliver a live presentation to 100 people in different locations? The Correct Answer: A broadcast 16.Which technique should you use to minimize the file size of a presentation that contains multiple sound files? The Correct Answer: Link each sound file to the presentation 17.Which of the following can be easily accomplished with action buttons? The Correct Answer: All of the above 18.In which view is a hidden slide truly hidden (i.e., you do not see it unless you take special action)? The Correct Answer: Slide Show Name: PowerPoint Project 1 Getting Started with PowerPoint Status : Completed Score: 150 out of 150 points Question 1 To print an outline, select Outline view in the Print what box. Selected Answer: Correct True Question 2 Each time you press Enter in the Outline view, a new line of the outline is started that is the same level as the previous line. Selected Answer: Correct True Question 3 To demote a heading in PowerPoint, press the Tab key. Selected Answer: Correct True Question 4 In Slide view, placeholders designate different preformatted areas on the slide. Selected Answer: Correct True Question 5 You can add notes for the speaker in Slide View. Selected Answer: Correct False Question 6 In Slide view, to move a placeholder, the mouse pointer must be in the shape of a two-headed arrow. Selected Answer: Correct False Question 7 To change a slide's layout from a Bulleted List Slide to a Title Slide, click the Change Outline button on the Standard toolbar. Selected Answer: Correct False Question 8 To move a placeholder on a slide, you first click the border of the placeholder. Selected Answer: Correct True Question 9 To preview or display a slide so that it fills up the entire screen, click the Slide Show button. Selected Answer: Correct True Question 10 If you are viewing the third slide in Slide view and click the Slide Show button, the slide show automatically starts at the first slide. Selected Answer: Correct False Question 11 Which components does PowerPoint's Normal view include? Selected Answer: Correct all of the above Question 12 Which view is best to use when you want to focus on the flow of ideas from one topic to the next? Selected Answer: Correct Outline view Question 13 How can you develop a presentation in PowerPoint? Selected Answer: Correct any of the above Question 14 The main purpose of speaker notes is to _________. Selected Answer: Correct remind the speaker of additional information related to each particular slide Question 15 In Slide view, how do you move from one slide to another? Selected Answer: Correct all of the above POWERPOINT PROJECT 2 DESIGN OF PRESENTATION Name: PowerPoint Project 2 Design of Presentation Status : Completed Score: 150 out of 150 points Question 1 If you save a presentation with a new name, the new name displays in the title bar. Selected Answer: Correct True Question 2 When you open an existing presentation, it always displays first in Slide view. Selected Answer: Correct False Question 3 When you insert clip art, the program automatically adjusts the size tot he available empty space on the slide, and places the image in that space. Selected Answer: Correct False Question 4 The best way to change the size of a clip art image without distoring it is to click and drag one of the side sizing handles rather than a corner handle. Selected Answer: Correct False Question 5 Clip art is grouped into categories to make it easier to locate the appropriate image. Selected Answer: Correct True Question 6 Text typed in as WordArt is really a drawing object. Selected Answer: Correct True Question 7 Square handles around the outside of a WordArt object indicate that the object has been selected. Selected Answer: Correct True Question 8 Guides display to show you the new size or placement of a WordArt object in PowerPoint. Selected Answer: Correct True Question 9 You can increase the length of a text box by draggin one of its sizing handles. Selected Answer: Correct True Question 10 Audience handouts are valuable because your audience does not have to write down what is on the slide of your PowerPoint presentation and can concentrate on what you are saying. Selected Answer: Correct True Question 11 Connector handles are used to __________. Selected Answer: Correct attach one text box to another using a connector Question 12 The WordArt Gallery dialog box is used to Selected Answer: Correct select the WordArt style Question 13 Guides are dotted lines that display to indicate ___________. Selected Answer: Correct the new size or position of a WordArt object Question 14 Sizing handles _____. Selected Answer: Correct all of the above Question 15 You can select audience handouts to display ___________ Selected Answer: Correct all of the above POWERPOINT PROJECT 3 CHARTING NUMERICAL DATA Name: PowerPoint Project 3 Charting Numerical Data Status : Completed Score: 150 out of 150 points Question 1 The New Slide button is one of three Common Tasks buttons. Selected Answer: Correct True Question 2 You can add or delete rows and columns in a chart datasheet. Selected Answer: Correct True Question 3 If you want to chart a series of numbers in PowerPoint, you would use a subprogram called Microsoft Graph. Selected Answer: Correct False Question 4 To delete a row in a datasheet, put the cursor in any cell of that row and press the Delete key. Selected Answer: Correct False Question 5 You know you are in Microsoft Graph when the Data and Chart options are available in the menu. Selected Answer: Correct True Question 6 The type of chart you choose should be determined by the type of data you are going to display. Selected Answer: Correct True Question 7 You can modify a chart using the tools in the regular PowerPoint program. Selected Answer: Correct False Question 8 The legend in a chart is a key that identifies the color code for each series of data. Selected Answer: Correct True Question 9 The value axis is the horizontal line at the bottom of the chart. Selected Answer: Correct False Question 10 The category axis is the horizontal line at the bottom of the chart. Selected Answer: Correct True Question 11 text You can tell that the Microsoft Graph program is active when you _________. Selected Answer: Correct all of the above Question 12 The quickest way to switch the data on the category axis from colums to rows is to ______. Selected Answer: Correct use the By Column button on the Microsoft Graph toolbar Question 13 Screen tips ___________. Selected Answer: Correct all of the above Question 14 The primary purpose of a chart of numerical data is to __________. Selected Answer: Correct show change over time, parts of a whole, trends or comparisons Question 15 When you first activate the Microsoft Graph program _________. Selected Answer: Correct a datasheet with sample data displays POWERPOINT PROJECT 4 ANIMATIONS Name: PowerPoint Project 4 Animations Status : Completed Score: 150 out of 150 points Question 1 You can change the sequence of slides by clicking and dragging a slide to a new position in Slide Show view. Selected Answer: Correct False Question 2 In Slide Sorter view, you turn off the details of a slide and just show the slide's title by clicking the Show Formatting button. Selected Answer: Correct True Question 3 The Slide Transition Effects box displays how each line of bulleted text will be revealed. Selected Answer: Correct False Question 4 If you are in Slide Sorter View and want to see how a particular slide transition looks, you can click the small icon below the slide to preview the transition. (Show Formatting must be turned on.) Selected Answer: Correct True Question 5 The After animation option dims the previous slide during a slide show. Selected Answer: Correct True Question 6 Animation can be applied to each bulleted point, graphic, or chart in a presentation. Selected Answer: Correct True Question 7 Animation features include the direction, speed, and even the sound that is used when something new appears on a slide. Selected Answer: Correct True Question 8 Bulleted points can come onto the screen from the top or ottom of the screen but not from the side. Selected Answer: Correct False Question 9 When you dim a bullted point, you change it to a different color so that it is less dominant on the screen. Selected Answer: Correct True Question 10 Transitions between slides have to be the same for the entire presentation. Selected Answer: Correct False Question 11 A transition is best described as ____________ Selected Answer: Correct the way a slide appears on the screen Question 12 If you set a custom animation for a slide, the preset animation box _______ for that slide. Selected Answer: Correct is blank Question 13 Text animation effects control how bulleted points appear in a presentation by specifying ___________. Selected Answer: Correct all of the above Question 14 In the Slide Sorter view, the Show Formatting button is used to _______. Selected Answer: Correct turn the details of the slide on or off Question 15 The Slide Sorter view is used to ________. Selected Answer: Correct perform all of the above tasks POWERPOINT PROJECT 5 MASTER PAGES Name: PowerPoint Project 5 Master Pages Status : Completed Score: 150 out of 150 points Question 1 PowerPoint automatically adjust the font size to ensure that all the bulleted points fit on a slide. Selected Answer: Correct False Question 2 Italicizing the font on a first-level butteted point in the Slide Master italicizes all other levels. Selected Answer: Correct False Question 3 The Slide Header and Footer dialog box gives you the option of including the information on the title slide. Selected Answer: Correct True Question 4 You use the Slide Header and Footer dialog box to change the font characteristics of text in the Footer Area Selected Answer: Correct False Question 5 The Slide Master does not have a Header Area defined. Selected Answer: Correct False Question 6 It is generally a good idea to put your name, the date, and the title of your presentation on the Handout Master. Selected Answer: Correct True Question 7 To change a bullet on a slide, you open the Slide Master and place the insertion point in the bullet level you want to change. Selected Answer: Correct True Question 8 There are only about 20 bullet choices available. Selected Answer: Correct False Question 9 When you change a bullet, you cannot change the color of the bullet. Selected Answer: Correct False Question 10 You can print a Handout Master that is an outline rather than slides. Selected Answer: Correct True Question 11 To work with the Handout Master, what do you need to do first? Selected Answer: Correct Choose View, Masters, and click Notes and Handout Master. Question 12 The Master page you use to control bullet slides is the ___________. Selected Answer: Correct Slide Master Question 13 A place holder at the top of the Handout Master is the _________ placeholder. Selected Answer: Correct Header Area Question 14 The Slide Master has __________placeholders. Selected Answer: Correct Title Area, Date and Footer Question 15 Using the Slide Master, which of the following can you change? Selected Answer: Correct all of the above Question 1 10 of 10 points The scrollbar at the right of the screen is the vertical scrollbaar. Selected Answer: True Question 2 10 of 10 points Workbook and worksheet are the same thing. The words may be used interchangeably. Selected Answer: False Question 3 10 of 10 points The cells that are visible on the screen when you first open Excel are the only ones available. Selected Answer: False Question 4 10 of 10 points The vertical scrollbar and its arrows can be used to rapidly scroll through the sheet or scroll one row at a time. Selected Answer: False Question 5 10 of 10 points A cell that was in column C and row 2 would be referred to as cell 2C. Selected Answer: False Question 6 10 of 10 points The active cell has a darder border than the other cells. Selected Answer: True Question 7 10 of 10 points Text and numbers should be placed in the same cell together to save space. Selected Answer: False Question 8 10 of 10 points Clicking the AutoSum button places a formula in the currently selected cell that automatically adds up the nearest row or column of numbers. Selected Answer: True Question 9 10 of 10 points Pressing the Del key deletes the character to the right of the insertion point. Selected Answer: True Question 10 10 of 10 points To move from one cell to the next across the worksheet, press _____________. Selected Answer: The Tab key Question 11 10 of 10 points You can edit a cell by ____________. Selected Answer: all of the above. Question 12 10 of 10 points To insert a row in a worksheet, click in a cell in the row where you want to insert a new row and ________________. Selected Answer: choose Insert, Row Question 13 10 of 10 points When you use the AutoSum button, you know which cells will be added because ______. Selected Answer: all of the above Question 14 10 of 10 points To delete a column on a worksheet, ____________. Selected Answer: click the column heading and choose Edit, Delete from the menu. Question 1 10 of 10 points To open an existing workbook, use the Insert, File options from the menu. Selected Answer: False Question 2 10 of 10 points You can select all the cells in a row by clicking the row heading. Selected Answer: True Question 3 10 of 10 points All the cells in a selection must be touching each other, separate groups of cells cannot be selected at the same time. Selected Answer: False Question 4 10 of 10 points If you select a group of cells and click the Comma Style button, all the numbers in those cells have a comma placed between every two numbers. Selected Answer: False Question 5 10 of 10 points If a selected cell contains the number 5.25 and you click the Decrease decimal button, the number 5.2 displays. Selected Answer: False Question 6 10 of 10 points If a cell displays a row of # signs, it means that you made a mistake in writing a formula. Selected Answer: False Question 7 10 of 10 points A 16-point character is larger than an 8 point character. Selected Answer: True Question 8 10 of 10 points If you have a printer with only one color of ink, it does not matter which colors you choose for text and background. Selected Answer: False Question 9 10 of 10 points It is possible to print long column labels at an angle. Selected Answer: True Question 10 10 of 10 points What is the method used to automatically adjust the width of a column to accomodate the widest cell entry? Selected Answer: Double click the line dividing the column headings. Question 11 10 of 10 points What is the symbol used to indicate that a number is too big to fit in a cell? Selected Answer: Pound sign Question 12 10 of 10 points What is the setting that forces long text entries to fit within the available column width by increasing the row height and displaying the text on several lines within the cell? Selected Answer: Wrap text Question 13 10 of 10 points How would you add underlining to a cell? Selected Answer: Ctrl key Question 1 10 of 10 points If you select cell B4 and freeze the panes, rows 1 through 3 would be frozen as well as column A Selected Answer: True Question 2 10 of 10 points The fill handle is located in the lower-left corner of the selected cell. Selected Answer: False Question 3 10 of 10 points If you select a cell that contain the word "Jane" and drag the fill handle to an adjacent cell, the adjacent cell would contain the word "Jane". Selected Answer: True Question 4 10 of 10 points To print a range of cells, select the range and click the Print button on the toolbar. Selected Answer: False Question 5 10 of 10 points If Zoom is currently set at 100% and you change the Zoom percentage to 75%, you can see more cells on the screen. Selected Answer: True Question 6 10 of 10 points The copy button on the Standard toolbar looks like a small Clipboard with a page in front of it. Selected Answer: True Question 7 10 of 10 points The Preview window has a Zoom button but it only toggles back and forth between two sizes. Selected Answer: False Question 8 10 of 10 points If you had a worksheet that was wider (columns) than it was long (rows), you would use the Portrait page orientation. Selected Answer: False Question 9 10 of 10 points The Collapse Dialog box button is used to shring the dialog box to make it easier to make a selection from the worksheet. Selected Answer: True Question 10 10 of 10 points It is better to print several copies of the worksheet as you create it to make sure the final copy is error-free. Selected Answer: False Question 11 10 of 10 points The Page Setup dialog box is used to do which of the following? Selected Answer: all of the above Question 12 10 of 10 points How would you print part of a worksheet? Selected Answer: Select the range and use File, Print, Selection. Question 13 10 of 10 points If you wanted to freeze row 1 through 3 and columns A and B, what cell would you select before choosing Windows, Freeze Panes? Selected Answer: C4 Question 14 10 of 10 points What method would you use to put the same word into 20 cells in a nonadjacent column? Selected Answer: copy and paste Question 15 10 of 10 points Which of the following could be used as the first label in a sequence? Selected Answer: all of the above Question 1 10 of 10 points You can use only one cell reference in a formula. Selected Answer: False Question 2 10 of 10 points Math operations that are grouped inside parentheses are calculated first in a formula. Selected Answer: True Question 3 10 of 10 points When you use the fill handle to copy a formula that sums a column, Excel assumes an absolute reference to the numbers in the original column. Selected Answer: False Question 4 10 of 10 points To designate a cell reference as absolute, place a $ to the left of both the column and row identifiers. Selected Answer: True Question 5 10 of 10 points To view the formulas used in an Excel worksheet, press the Ctrl + ~, which is found on the key to the left of the 1 key. Selected Answer: True Question 6 10 of 10 points The loan payment formula uses and annual interest rate and the number of years of the load to calculate the monthly payment amount. Selected Answer: False Question 7 10 of 10 points The Paste Function button on the Standard toolbar opens a formula palette that you can use to enter formulas for making a variety of financial calculations. Selected Answer: True Question 8 10 of 10 points Relative reference is a cell reference that changes when the formula is copied, moved, or filled. Selected Answer: True Question 9 10 of 10 points The COUNTIF function in Excel can be used to count the number of cells that contain a selected word or number. Selected Answer: True Question 10 10 of 10 points When you change a number in a cell, it automatically changes the results of every formula that uses that cell. Selected Answer: True Question 11 10 of 10 points What is the term for the numbers or words that are used by a function to perform a calculation or operation? Selected Answer: argument Question 12 10 of 10 points What would you use the COUNTIF function for? Selected Answer: to count the number of occurrences of a word or a number in a range of cells Question 13 10 of 10 points What arguments are required by the PMT (payment) function to caculate a new car loan payment? Selected Answer: number of payments, interest rate per payment period, and the amount loaned Question 14 10 of 10 points A cell reference that changes when copied or filled is known as a(n) ______. Selected Answer: relative reference Question 1 10 of 10 points The Chart Wizard walks you through the creation of a chart. Selected Answer: True Question 2 10 of 10 points Pie charts are used to show trends. Selected Answer: False Question 3 10 of 10 points A 3-D chart requires at least three columns (or rows) of selected data. Selected Answer: False Question 4 10 of 10 points When selecting data to chart, always include the row and column totals. Selected Answer: False Question 5 10 of 10 points When you right-clcik a chart title, it automatically sizes the font to produce a title that spans three-quarters of the printed page. Selected Answer: False Question 6 10 of 10 points Column charts and bar charts are both used to illustrate data that shows comparisons. Selected Answer: True Question 7 10 of 10 points When you increase the font size of the y-axis, the size of the plot area remains the same. Selected Answer: True Question 8 10 of 10 points One of the choices you can make in the Chart Wizard is whether you want your chart to be on the same worksheet as the data or on its own sheet. Selected Answer: True Question 9 10 of 10 points After a line chart is created, the y-axis scale must always start at zero. Selected Answer: False Question 10 10 of 10 points Right-clicking a chart element calls up a shortcut menu that enables you to make changes. Selected Answer: True Question 11 10 of 10 points If you needed to show how much each division contributed to the profits of your company, which type of chart would you use? Selected Answer: pie chart Question 12 10 of 10 points If you wanted to show a comparison of your company's income and expenses to a group of peers, which type of chart would you use? Selected Answer: column chart Question 13 10 of 10 points A list that identifies a pattern or color used in an Excel worksheet chart is called the _______. Selected Answer: Legend Question 14 10 of 10 points In Excel, the X-axis is called the category axis, and the y-axis is known as the _____ axis. Selected Answer: value Question 1 10 of 10 points To move a worksheet in a workbook, you click and drag the sheet tab to a new position. Selected Answer: True Question 2 10 of 10 points If you want cells in one worksheet to reflect changes that are made in another worksheet, you must start with an equal sign in the destination cell. Selected Answer: True Question 3 10 of 10 points To copy data in a cell from one worksheet to another, chosse Edit, Worksheet. Selected Answer: False Question 4 10 of 10 points To copy a row of cells from one worksheet to another, the entire row of cells on the source worksheet must be selected. Selected Answer: True Question 5 10 of 10 points In a formula, a reference to another worksheet is indicated by an exclamation point at the beginning and the end of the worksheet name. Selected Answer: False Question 6 10 of 10 points To insert a hyperlink in a worksheet, click the Web button. Selected Answer: False Question 7 10 of 10 points To save the sheet as an interactive page suitable for publishing on the Internet, choose File, Save as HTML. Selected Answer: False Question 8 10 of 10 points You can tell when a worksheet label is a hyperlink because the label appears on the worksheet in a different color. Selected Answer: True Question 9 10 of 10 points If a worksheet is saved as an interactive Web page, you can sort the data on the sheet when viewing it with a Web browser. Selected Answer: True Question 10 10 of 10 points The Externsible Markup Language that makes interactive worksheets possilbe is known by the acronym, EML. Selected Answer: False Question 11 10 of 10 points What is the worldwide network of computer connections that enables people to have access to thousands of online resources called? Selected Answer: Internet Question 12 10 of 10 points The graphic interface system that makes it easier to access information on the Internet as known as the _____. Selected Answer: WWW Question 13 10 of 10 points A(n) __________ is a connection between a word or label in one location to a file in another location. Selected Answer: hyperlink Question 14 10 of 10 points Which of the following could be a reference to a cell in another worksheet? Selected Answer: ='First Quarter'!B4 Excel contains several categories of built-in functions. The PMT function computes the periodic payment for a loan based on three arguments (the interest rate per period, the number of periods, and the amount of the loan). The PMT function was used in worksheets to compute a car payment and a home mortgage. The IPMT and PPMT functions determine the amount of each periodic payment that goes toward interest and principal, respectively. The FV function returns the future value of an investment based on constant periodic payments and a constant interest rate. The function is associated with Individual Retirement Accounts and 401K retirement plans. A spreadsheet was developed using mixed references to create a two-level table showing the future value of a retirement account at different interest rates and time periods. Statistical functions were also discussed. The AVERAGE, MAX, and MIN functions return the average, highest, and lowest values in the argument list. The COUNT function returns the number of cells with numeric entries. The COUNTA function displays the number of cells with numeric and/or text entries. The IF, VLOOKUP, and HLOOKUP functions implement decision making within a worksheet. The IF function has three arguments: a condition, which is evaluated as true or false; a value if the test is true; and a value if the test is false. The VLOOKUP and HLOOKUP functions also have three arguments: the value to look up, the range of cells containing the table, and the column or row number within the table that contains the result. Several options were presented for working with large spreadsheets. Scrolling enables you to view any portion of a large worksheet but moves the labels for existing rows and/or columns off the screen. The Freeze Panes command keeps the row and/or column headings on the screen while scrolling within a large worksheet. The Page Break Preview command lets you see and/or modify the page breaks that will occur when a worksheet is printed. The AutoFilter command displays a selected set of rows within a worksheet according to a specified set of criteria. The hidden rows are not deleted but are simply not displayed. A spreadsheet is first and foremost a tool for decision making, and thus Excel includes several commands to aid in that process. The Goal Seek command lets you enter the desired end result of a spreadsheet model (such as the monthly payment on a car loan) and determines the input (the price of the car) necessary to produce that result. The assumptions and initial conditions in a spreadsheet should be clearly labeled and set apart from the rest of the worksheet. This facilitates change and reduces the chance for error. The hands-on exercises introduced several techniques to make you more proficient. The fill handle is used to copy a cell or group of cells to a range of adjacent cells. Pointing is a more accurate way to enter a cell reference into a formula as it uses the mouse or arrow keys to select the cell as you build the formula. The AutoFill capability creates a series based on the initial value(s) you supply. Which of the following options may be used to print a large worksheet? The Correct Answer: All of the above If the results of a formula contain more characters than can be displayed according to the present format and cell width, The Correct Answer: A series of pound signs will be displayed Which cell—A1, A2, or A3—will contain the amount of the loan, given the function =PMT(A1,A2,A3)? The Correct Answer: A3 Which of the following will compute the average of the values in cells D2, D3, and D4? The Correct Answer: The function =AVERAGE(D2:D4) The function =IF(A1>A2,A1+A2,A1*A2) returns The Correct Answer: Neither (a) nor (b) Which of the following is the preferred way to sum the values contained in cells A1 to A4? The Correct Answer: =SUM(A1:A4) Which of the following will return the highest and lowest arguments from a list of arguments? The Correct Answer: MAX/MIN Which of the following is a required technique to develop the worksheet for the mortgage analysis? The Correct Answer: Neither (a) nor (b) Given that cells B6, C6, and D6 contain the numbers 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>10,C6*2,D6*3)? The Correct Answer: 90 Which of the following is not an input parameter to the Goal Seek command? The Correct Answer: The value of the input cell that is required to reach the end result Which is the correct order of the arguments for the FV function? The Correct Answer: Interest Rate, Term, Annual Amount Which function will return the number of nonempty cells in the range A2 through A6, including in the result cells that contain text as well as numeric entries? The Correct Answer: =COUNTA(A2:A6) The annual interest rate, term in years, and principal of a loan are stored in cells A1, A2, and A3, respectively. Which of the following is the correct PMT function, given monthly payments? The Correct Answer: =PMT(A1/12,A2*12,-A3) The worksheet displayed in the monitor shows columns A and B, skips columns D, E, and F, then displays columns G, H, I, J, and K. What is the most likely explanation for the missing columns? The Correct Answer: Neither (a) nor (b) is a likely reason Given the function =VLOOKUP(C6,D12:F18,3) The Correct Answer: The entries in cells D12 through D18 are in ascending order A formula containing the entry =$B3 is copied to a cell one column over and two rows down. How will the entry appear in its new location? The Correct Answer: =$B5 You expect to contribute $2,000 a year for 10 years to a retirement plan and expect an annual return of 7%. Which of the following functions can you use to determine the expected future value? The Correct Answer: =FV(.07,10,-2000) Which of the following computes the monthly payment for a car loan of $10,000 that is amortized over 3 years at 5%? The Correct Answer: =PMT(.05/12,36,-10000) All of the following are required arguments to the PMT function EXCEPT: The Correct Answer: the time interval of the payments; i.e. months or years. When using the FV function, which required argument is normally expressed as a negative number? The Correct Answer: The amount of the periodic payment. You have used the FV function to calculate the value of your retirement fund and feel that you won’t have enough money. Which of the following can be used to calculate the return you will have to earn to reach your investment objectives? The Correct Answer: The Goal Seek command. You want to use the PMT function to calculate the monthly payment on a car loan. The price of the car is in cell B2, the down payment amount is in cell B3, the annual interest rate is in cell B5, and the term (in years) of the loan is in cell B6. Cell B4 contains the formula =B2 – B3. Which of the following will return the correct answer? The Correct Answer: =PMT(B5/12, B6*12, -B4). To select a non-contiguous cell range, after selecting the first cell range, hold down the ____________ key to select all other ranges. The Correct Answer: Ctrl. When copying formulas to other rows and columns, references to the assumptions in the worksheet are normally ____________ references. The Correct Answer: Absolute. To create a table where two parameters are varied, use ____________ references so that the formula can be copied to the other cells in the table. The Correct Answer: Mixed. When a cell is not wide enough to display the results of the formula in that cell, ____________ is displayed in that cell. The Correct Answer: a series of pound signs (########). If you want to specify the order in which rows in a spreadsheet are displayed, use the: The Correct Answer: Sort command. The equal to (=) sign and not equal to (<>) sign are examples of: The Correct Answer: relational operators. Which is NOT a required argument to the IF function? The Correct Answer: The column containing the breakpoints. Given the statement =VLOOKUP(B5, $D$15:$G$23, 3), the breakpoints for the value in cell B5 will be found in column: The Correct Answer: D. Which of the following is NOT included in the computation for the COUNTA function? The Correct Answer: Empty cells. To keep row and/or column headings visible as you scroll through the worksheet, use the ____________ command. The Correct Answer: Freeze Panes. To display only rows meeting certain criteria, use: The Correct Answer: the AutoFilter command. A function accepts variables as inputs to perform its calculations. The Correct Answer: False The FV function can be used to calculate the monthly payment on a car loan. The Correct Answer: False With the Goal Seek command, you may only change one input parameter at a time. The Correct Answer: True The use of functions is generally preferred over the use of arithmetic expressions. The Correct Answer: True When you use the AutoFilter command, rows not meeting the selected criteria are deleted. The Correct Answer: False A chart is based on numeric values called: The Correct Answer: data points. The most effective way to display proportional relationships is a: The Correct Answer: pie chart. In a column chart, category labels are shown along the __________. The Correct Answer: horizontal axis. In an embedded chart, the ____________ indicate(s) it is currently selected. The Correct Answer: sizing handles. Charts can be embedded in a worksheet or created in a: The Correct Answer: chart sheet. You can use the ____________ toolbar to add text boxes and other objects to a chart. The Correct Answer: Drawing. If you specify the data series are in rows, the Chart Wizard will use ____________ for the category labels. The Correct Answer: the first row. If you want to show total sales for a product category, use a ____________ chart. The Correct Answer: stacked column. If you specify a data series in columns, the Chart Wizard will use ____________ as the data series. The Correct Answer: all columns but the first. The key that will quickly create a default chart in its own worksheet is: The Correct Answer: F11. Which of the following is NOT suited for multiple data series? The Correct Answer: pie chart. You have a Word memo that is open, and linked to an Excel worksheet. You make changes in the worksheet. The memo is: The Correct Answer: updated immediately. You have a Word memo that has an embedded Excel worksheet. You save the original worksheet. The memo is: The Correct Answer: never updated. To cycle through all open applications, use the: The Correct Answer: Alt + Tab combination. The feature that allows you to create a document containing objects from another application is: The Correct Answer: object linking and embedding. A data point is a grouping of data series. The Correct Answer: False The most important step in creating a chart is deciding the message you are trying to convey. The Correct Answer: True The command to change the chart type can be found on the Chart toolbar. The Correct Answer: True With multiple data series, the data points plotted on the chart are the same regardless of whether the data series are in rows or columns. The Correct Answer: True A source file can only be linked to one destination file. The Correct Answer: False Which type of chart is best to portray proportion or market share? The Correct Answer: Pie chart Which of the following is a true statement about the Chart Wizard? The Correct Answer: All of the above Which of the following chart types is not suitable to display multiple data series? The Correct Answer: Pie chart Which of the following is best to display additive information from multiple data series? The Correct Answer: A column chart with the data series stacked one on top of another A workbook must contain: The Correct Answer: Neither (a) nor (b) Which of the following is true regarding an embedded chart? The Correct Answer: Both (a) and (b) Which of the following will produce a shortcut menu? The Correct Answer: All of the above Which of the following is done prior to invoking the Chart Wizard? The Correct Answer: The data series are selected Which of the following will display sizing handles when selected? The Correct Answer: All of the above How do you switch between open applications? The Correct Answer: Both (a) and (b) A Word document is linked to an Excel worksheet and associated chart. Which of the following best describes the way the documents are stored on disk? The Correct Answer: There are two files—one for the Word document and one for the Excel workbook, which contains both the worksheet and associated chart To represent multiple data series on the same chart: The Correct Answer: The data series may be in rows or columns with no requirement to be next to one another If multiple data series are selected and rows are specified: The Correct Answer: Both (a) and (b) If multiple data series are selected and columns are specified: The Correct Answer: Both (a) and (b) Which of the following is true about the scale on the Y axis in a column chart that plots multiple data series side-by-side versus one that stacks the values one on top of another? The Correct Answer: The scale for the stacked columns chart contains larger values than the side-by-side chart A workbook includes a revenue worksheet with two embedded charts. The workbook also includes one chart in its own worksheet. How many files does it take to store this workbook? The Correct Answer: 1 Assume that cells A1 through E5 have been selected, after which the Chart Wizard is used to create a side-by-side column chart. Which of the following is true, given that the data are plotted in rows? The Correct Answer: Both (a) and (b) Which of the following creates a dynamic link between a workbook and a word processing memo? The Correct Answer: Copy, Paste Special, and Paste Link You need to create an employee timecard. You use a partially completed workbook that contains formulas and formatting, but no data. The workbook you are using is called a: The Correct Answer: template. You wrote a Web query to retrieve statistics for your fantasy baseball league. When you opened the worksheet, you noticed that the statistics were for last week's games. What is the most likely explanation? The Correct Answer: You need to refresh the data. The tiny black square at the bottom right hand corner of the active cell is called the: The Correct Answer: fill handle. The key(s) that is(are) used to cycle through absolute, mixed, and relative references is: The Correct Answer: F4. You have a cell that contains the formula =$E5 * 2. You copy that cell over two columns and down three rows. How will the formula in the destination cell read? The Correct Answer: $E8. The command that allows you to save an Excel workbook in a form that can viewed in Internet Explorer is: The Correct Answer: Save as Web Page. You have saved an Excel worksheet as a Web page and are viewing it in Internet Explorer. You click the Edit in Microsoft Excel button and edit the document. You are using a feature known as: The Correct Answer: round-trip HTML. You are viewing an Excel worksheet. You click on a cell that says "Click here for my Web site." When you click that cell, you are taken to a Web site. The object you clicked on is called a(n): The Correct Answer: hyperlink. The ___________ is used to copy the formatting of a selected cell to other cells. The Correct Answer: Format Painter. You have created a Web page showing the selling price of all homes sold in your city for the past three months. Those houses that sold for above $300,000 are shaded light yellow, while those that sold for below $100,000 are shaded light blue. The rest of the houses have no shading. The most likely explanation is: The Correct Answer: Conditional formatting was applied to the cells. You saved an Excel document as a Web page and are viewing it in Internet Explorer. You notice a mistake and use the round-trip HTML feature to edit the page. In Internet Explorer, you notice that the browser is still displaying the "old" page. What is the most likely explanation? The Correct Answer: You did not refresh the Web page in Internet Explorer. To create a Web query: The Correct Answer: select the Import External Data command on the Data menu. Excel stores all dates as ___________. The Correct Answer: integers. Cell E4 contains the date of an employee's last absence from work. The formula to calculate the number of weeks since that employee's last absence is: The Correct Answer: =(Today()-E4)/7. To update the data in a Web query: The Correct Answer: click the Refresh button on the External Data toolbar. Given a cell with a reference to cell D$6, when that cell is copied down 2 rows and left 2 columns, that cell reference will read B$6. The Correct Answer: True Using the keyboard is the preferred method for entering cell references into a formula. The Correct Answer: False To open an Excel worksheet in a browser, use the Web Page Preview command. The Correct Answer: True To create a new Web query, use the Refresh command. The Correct Answer: False The Today() function always returns the system date. The Correct Answer: True The formula to compute the gross pay of an employee in the payroll example that was developed in this chapter uses: The Correct Answer: Relative references for hourly wage, regular hours, and overtime hours Which of the following best describes the formula to compute the withholding tax of an employee in the payroll example that was developed in this chapter? The Correct Answer: It contains a relative reference to gross pay and an absolute reference to the withholding rate Cell D12 contains the formula, =SUM (A12:C12). What will the contents of cell D13 be, if the formula in cell D12 is copied to cell D13? The Correct Answer: =SUM (A13:C13) A formula containing the entry =$B$3 is copied to a cell one column over and two rows down. How will the entry appear in its new location? The Correct Answer: =$B$3 How do you insert a hyperlink into a workbook? The Correct Answer: Any of the above A Web browser such as Internet Explorer can display a page from: The Correct Answer: All of the above What is the best way to enter the current price of a stock into an Excel worksheet? The Correct Answer: Create a Web query, then refresh the query to obtain the current price The estimated sales for the first year of a financial forecast are contained in cell B3. The sales for year two are assumed to be 10% higher than the first year, with the rate of increase (10%) stored in cell C23 at the bottom of the spreadsheet. Which of the following is the best way to enter the sales for year two? The Correct Answer: =B3+B3*$C$23 Which of the following requires an Internet connection? The Correct Answer: Updating the values that are obtained through a Web query Cell F6 contains the formula =AVERAGE(B6:D6). What will be the contents of cell F7 if the entry in cell F6 is moved to cell F7? The Correct Answer: =AVERAGE(B6:D6) What will be stored in a cell if 2/5 is entered in it? The Correct Answer: The date value February 5 of the current year You type 11/24/00 into a cell, press the Enter key, and expect to see Nov 24, 2000. Instead you see the value 36854. Which of the following is the most likely explanation? The Correct Answer: The cell is formatted to display a numeric value rather than a date Which of the following formulas can be used to compute an individual’s age, given that the individual’s birth date is stored in cell A4? The Correct Answer: =(Today( )–A4)/365 Microsoft Excel and Internet Explorer are both open and display the “same” worksheet. You make a change in the Excel file that is not reflected in the Web page. What is the most likely explanation? The Correct Answer: You did not refresh the Web page in Internet Explorer You notice that the values in a specific column are displayed in three different colors, red for values less than zero, blue for values greater than $100,000, and black otherwise. How is this possible? The Correct Answer: Conditional formatting was applied to the column A formula containing the cell reference A$4 is copied to a cell one column over and two rows down. How will the reference appear in its new location? The Correct Answer: The column will change but the row will remain the same The formula =B3+C4 is stored in cell D5. What will the formula be if a row is inserted above the second row? The Correct Answer: =B4+C5 You want to add the contents of cells C1, C2, C3, and C4 but expect that additional values may be inserted within the column of numbers at a later time. Which formula automatically adjusts to include the additional entries? The Correct Answer: =SUM(C1:C4) The intersection of a row and a column is called a _______. The Correct Answer: cell. A predefined computational task, such as AVERAGE, is known as a(n) _______. The Correct Answer: function. Which of the following is considered a constant? The Correct Answer: B3. The ____________ contains buttons corresponding to the most basic commands in Excel. The Correct Answer: Standard toolbar. You have an open workbook named Budget. The command that will save that workbook with the name Revised Budget is: The Correct Answer: Save As. The command used to create a new workbook is located on the __________ menu. The Correct Answer: File. You want to delete column B from your worksheet. The command that accomplishes this is: The Correct Answer: Delete. The command that gives you control over the printed worksheet is: The Correct Answer: Page Setup. You have entered the name "Grauer" in cell B12. In cell B19, you type a G, and Excel fills in the letters "rauer". This feature is known as: The Correct Answer: AutoComplete. The command(s) needed to duplicate the contents of one cell range in another location is(are): The Correct Answer: Both the Copy and Paste commands. Cell D16 contains the function =AVERAGE(D1:D15). If you copy D16 over 2 columns, the contents of the destination cell will be: The Correct Answer: =AVERAGE(F1:F15). A cell reference that does not adjust when it is copied is referred to as a(n): The Correct Answer: absolute reference. Cell J5 is formatted as percentage with one decimal place and displays 47.8%. The value of that cell (in decimal format) is: The Correct Answer: .478. By default, text entries are: The Correct Answer: left-aligned. The tab in the Format Cells dialog that allows you to choose a different color in which to shade a cell is: The Correct Answer: Patterns. An Excel worksheet consists of one or more workbooks. The Correct Answer: False A formula is a cell entry whose value will not change. The Correct Answer: False You can define the margins on a printed worksheet with the Page Setup command. The Correct Answer: True An absolute reference is one that is adjusted when a cell containing that reference is copied. The Correct Answer: False In a copy operation, the cell you are copying from is called the source range. The Correct Answer: True Which of the following is true? The Correct Answer: A workbook contains one or more worksheets The cell at the intersection of the second column and third row is cell: The Correct Answer: B3 What is the effect of typing F5+F6 into a cell without a beginning equal sign? The Correct Answer: The entry will be treated as a text entry and display F5+F6 in the cell The Open command: The Correct Answer: Brings a workbook from disk into memory The Save command: The Correct Answer: Stores the workbook in memory on disk In the absence of parentheses, the order of operation is: The Correct Answer: Exponentiation, multiplication or division, addition or subtraction Cells A1, A2, and A3 contain the values 10, 20, and 40, respectively. What value will be displayed in a cell containing the cell formula =A1/A2*A3+1? The Correct Answer: 21 The entry =AVERAGE(A4:A6): The Correct Answer: Computes the average of cells A4, A5, and A6 Which of the following was suggested with respect to printing a workbook? The Correct Answer: Print both the displayed values and cell formulas Which options are mutually exclusive in the Page Setup menu? The Correct Answer: Portrait and landscape orientation If cells A1, A2, and A3 contain the values 1, 2, and 5, respectively, what value will be displayed in a cell containing the formula =(A3-A1)/A2^2+A2? The Correct Answer: 3 Which of the following best describes the formula used to compute a student’s semester average, when the weights of each exam are isolated at the bottom of a spreadsheet? The Correct Answer: The student’s individual grades are entered as relative references and the exam weights are entered as absolute references Cell B11 contains the formula, =SUM (B3:B9). What will the contents of cell C11 be if the formula in cell B11 is copied to cell C11? The Correct Answer: =SUM (C3:C9) Given that cell E6 contains the formula =B6*$B$12+C6*$C$12+D6*$D$12. What will be the formula in cell E7 if the contents of cell E6 are copied to that cell? The Correct Answer: =B7*$B$12+C7*$C$12+D7*$D$12 A formula containing the reference =D$5 is copied to a cell one column over and two rows down. How will the entry appear in its new location? The Correct Answer: =E$5 The formula =B3+C4 is stored in cell D5. What will the formula be if row two is deleted from the worksheet? The Correct Answer: =B2+C3 You are creating a sales forecast, and have entered the sales for 2002 in cell B4. The expected rate of increase is in cell C2. What formula would you enter in cell C4 to compute the sales for 2003, given that you will copy that formula to cells D4:E4 to calculate the forecast for 2004 and 2005? The Correct Answer: =B4*(1+$C$2) What is the end result of clicking in a cell, then clicking the Italic button on the Formatting toolbar twice in a row? The Correct Answer: The cell contents are unchanged and appear exactly as they did prior to clicking the Italic button twice in a row
Site hosted by Angelfire.com: Build your free website today!