1 / 17

CS 101 Lecture Test 1

CS 101 Lecture Test 1. Review. What is one way to get bonus points in this class?. Going to the last lab Taking tests Writing a paper Coming to every lecture. A file with a path like c : spring classescs101sheet1.jpg. Is a picture file – the jpg tells you that

Download Presentation

CS 101 Lecture Test 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CS 101 Lecture Test 1 Review

  2. What is one way to get bonus points in this class? • Going to the last lab • Taking tests • Writing a paper • Coming to every lecture

  3. A file with a path like c:\spring\classes\cs101\sheet1.jpg • Is a picture file – the jpg tells you that • Is a text file – the folder classes tells you that • Is a spreadsheet – sheet1 tells you that • is a calendar file – fall11 tells you that

  4. A file with a path like c:\spring\classes\cs101\sheet1.jpg • Is stored at the root of the hard drive • Is stored on the floppy drive • Is stored in the “My Documents” folder • None of the above

  5. If cell D18 contains =$A13+B$15, and the formula is copied to cell E15, what does it change to? • =$A13+B$15 • =B10+C12 • =$A10+C$15 • =$A13+C$15

  6. Who wrote Visicalc? • Steve Jobs and Bill Gates • Bill Gates and Steve Ballmer • Dan Bricklin and Bob Frankston • Al Gore

  7. The value of the formula =5*3 + 8/2 • 27.5 • 19 • 31 • 18

  8. How many megabytes are in 2 gigabytes? • 200 • 2048 • 0.5 • 2 • 1024

  9. If the formula =C5+1 were in cell C5 • It would add 1 to the value already there • It would cause a precedence error • It would cause a #NAME error • It would cause a circular reference

  10. The formula =sum(a3:a5) is the same as • =a3+a5 • =a3*a5 • =a3+a4+a5 • =a3/a5

  11. Being volatile is a property of • data on a hard drive • data in RAM • a printout of a document • a file burned on a CD

  12. When does the Recycle bin not work to restore a file? • When you erase something from a removable device • When it gets full • When you wait a long time to restore a file • More than one of these is true

  13. Digital devices always • cost more than analog • store measurements as numbers • do a better job than analog • none of the answers

  14. NSFnet was an ancestor of • ARPANet • the Internet • Usenet • all supercomputers

  15. Where did most PCs store their software in the 70’s-80’s? • on the Internet • on a LAN • on their hard drives or other storage devices, locally • it is unknown

  16. The Digital Divide • divides Mac users from PC users • divides people with technology from people without • people in the first world from people in the third world • older people from younger people

  17. What does it mean to freeze a spreadsheet? • the sheet is hung up and needs to be reloaded • some columns and rows will not scroll when the rest of the sheet does • all formulas are locked and cannot be altered • an error has been found in a formula and it must be fixed before anything can be added

More Related