R. Craig Collins > ITSE 1294 > Test 3 Review

Test 3 Review © R. Craig Collins, 2005/6

Now that you are mastering the theory, it is time to ramp up the tests a bit. Just as there are no multiple choice job interviews, the third test is designed to see not what you recognize, but what you have learned. The test and review below, have more short answer questions, where you have to write out a short phrase to answer the question. You'll have 40 minutes for the test, so you will need fairly rapid recall to finish in the allotted time. Go over your completed review frequently, though, and you'll do just fine!

(Here are my Study Tips)
(Here are my Test Taking Tips)
PS, The third part of the final will include the same information as Test 3.

1. What is a ‘right click?’ (see Chap 5, p. 73)

2. What does a ‘right click’ do? (see Chap 5, p. 73)

3. File Management is the ability to change file or folder names, move or delete
files or folder, etc. What tool is used for File Management? (see Chap 5, p. 65 Windows Explorer is also know as [My] Computer )

4. What does a folder do? (Chap 4 , p. 53)

5. What is a subfolder? (Chap 4 , p. 53)

6. What is the Windows Clipboard? (Chap 5 , p. 70)

7. What does the Copy Disk feature do? (Chap 5 , p. 73, Backup or copy)

8. What is the purpose of the Recycle Bin? (Chap 5, p. 71)

9. What is access time? (Chap 5, p. 72)

10. What is a fragmented file? (Chap 5 , p. 74)

11. How can you locate a file on your computer? (see Chap 5, p. 75)

EXCEL (see also notes near the bottom of this page)

12. What is a Spreadsheet? (Chap 11, p. 155, Overview 4, Lab 5, Excel Crash Course )

13. Give examples of some popular spreadsheet programs. (Chap 11, p. 155)

14. What is a ‘what if’ scenario? (Chap 11, p. 155)

15. What is a formula? (Chap 11, p. 156)

16. What is a Cell Reference (Chap 11, p. 156)

17. What is a function used for in a spreadsheet? (Chap 11, p. 157)

18. What is a spreadsheet range? (Chap 11, p. 159)

19. What extension is placed on Excel spreadsheets? (look at your lab’s file name)
a.) .xlsx b.) .docx c.) pptx d.) pdf

POWEPOINT (see also notes at the bottom of this page)

20. How are most presentations delivered? (Chap 13, p. 188, PowerPoint Tips)

21. What is a transition? (Chap 13, p. 185)

22. What is a slide template or slide layout? (Chap 13, p. 183)

23. What extension is placed on PowerPoint presentations? (look at your lab’s file name)
a.) .xlsx b.) .docx c.) pptx d.) pdf

24. What is a UPS? (Chap 6, p. 82)

25. What is a bad sector or corrupt file? (Chap 6, p. 81)

26. What tool can repair a bad sector? (Terms)

27. What is a Computer Virus? (Chap 6, p. 83)

28. What are some common symptoms of a computer containing a virus? (Ch 6 p. 83)

29. What is the most common way to get a virus? email or download

30. What is anti-virus software? (Chap 6, p. 83)

31. What is Backup (Chap 6, p. 84)

32. What’s the difference between random & sequential access? (Terms)

33. What is the Internet? (Chap 7, p. 97)

34. What are some common uses of the Internet?

35. What is a Modem (Chap 7, p. 97)

36. What is Bandwidth, in relation to download speed? (Terms, My Notes on bandwidth)

37. What does WWW stand for? (Terms, Chap 7, p. 111)

38. What is the difference between digital service and dialup (analog) service? (Ch 7, p. 98)

39. What is an ISP? (Chap 7, p. 97)

40. What is digital cash? (Chap 7, p. 108)

41. What is E-Commerce? (Chap 7, p. 108)

42. What is a homepage? (Chap 8, p. 111)

43. What is another name for links? (Chap 8, p. 111)

44. True or false; a URL is protocol://host.domain.top level domain/document (Chap 8, p. 112)

45. Give an example of a full URL. (Chap 8, p. 112)

46. What is HTTP? (Chap 8, p. 112)

47. What is HTML? (Chap 8, p. 112)

48. What are some top level Domain names? (Chap 8, p. 112)

49. What does HTML use to format text? (Chap 8, p. 113)

50. What is a URL? (Chap 8, p. 112)

51. What is Temple College’s URL?

52. What kind of software ‘reads’ web pages? (Chap 8, p. 113)

53. What is a plug-in? (Chap 8, p. 113)

54. What is a “cookie”? (Chap 8, p. 113)

55. How can you locate web sites that might interest you? (Chap 8, p. 114)

56. What is DSL (Chap 8, p. 98)

57. What are some common ways of connecting to the Internet? (Chap 8, p. 98)

58. From above, which are “always on” connections? (Hint not dial up, Ch 8, p. 98, 100)

Overview 4, Lab 5, Excel Crash Course

• Tables are composed of ...?
• What is the intersection of the above, called?
• What 4 things can you put into the above?
• What do you call a group of these storage areas?
• How do you identify this group of storage areas?
• How do you enter text or numbers, and how does excel display them?
• What is ?
• How does work?
• What is actually in the cell, and what acutally displays?
• What do all non-numerical and all non-text entries begin with?
• When a cell is selected there is a handle at the bottom right. What can that handle do, if dragged?
• What can be used to more easily convey numerical information? How can one be easily created?
• When using a cell's contents as part of a formula, name 2 ways to include that cell address.
• Name and show the Excel versions of the arithmetic operators.
• How can you tell Excel which operations to do first?
• What is a function?
• What are the compound parts of the 'Average' function?
• What button do you click to access functions?
• What is the difference between .4, 40%, and =2/5?
• What does ###### mean?
• How can you have Excel automatically resize?
• How can you change the size of a row or column?
• Is Excel 100% WYSIWYG? If not, how so?
• How can you display the actual contents of a cell, and not just the results?
• Discuss 'What if.'

PowerPoint Tips

• PowerPoint and Word share what basic foundation?
• What is a design template?
• Name two ways to add a new slide
• In this class, what four content slides should you include?
• Name at least three design tips
• Describe at least three ways to print in PowerPoint
• Name two ways to move in and out of the outline
• Name several ways to customize a presentation?
• How can you alter a presentation, without really changing it? Think slide sorter view.
• Compare and contrast transitions and custom animation.