170 likes | 305 Views
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
E N D
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\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
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
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
Who wrote Visicalc? • Steve Jobs and Bill Gates • Bill Gates and Steve Ballmer • Dan Bricklin and Bob Frankston • Al Gore
The value of the formula =5*3 + 8/2 • 27.5 • 19 • 31 • 18
How many megabytes are in 2 gigabytes? • 200 • 2048 • 0.5 • 2 • 1024
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
The formula =sum(a3:a5) is the same as • =a3+a5 • =a3*a5 • =a3+a4+a5 • =a3/a5
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
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
Digital devices always • cost more than analog • store measurements as numbers • do a better job than analog • none of the answers
NSFnet was an ancestor of • ARPANet • the Internet • Usenet • all supercomputers
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
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
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