CS 101 Midterm Review Questions
Prepare for your CS 101 midterm with these review questions covering topics such as bonus points, file paths, multitasking, character encoding, computer history, and basic calculations.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
CS 101 Midterm Review REVIEW 1
1. What is one way to get bonus points in this class? A. Going to an Open Lab B. Taking tests C. Writing a paper D. Coming to every lecture 2
2. A file with a path like c:\spring22\classes\cs101\sheet1.gif A. Is a picture file the gif tells you that B. Is a text file the folder classes tells you that C. Is a spreadsheet sheet1 tells you that D. is a calendar file fall20 tells you that 3
3. Multitasking is A. Not possible yet, still in research B. Possible with one CPU or with more than one CPU C. Only possible if the computer has a big power supply D. Not needed any more 4
4. A file with a path like c:\fall21\classes\cs101\sheet1.gif A. Is stored at the root of the hard drive B. Is stored on the floppy drive C. Is stored in the My Documents folder D. None of the above 5
5. One difference between ASCII and Unicode is A. ASCII is a newer code, Unicode is older B. ASCII has a smaller number of codes, Unicode has many more C. ASCII takes up more room per character than Unicode does D. 4. All of these are correct. 6
6. Gordon Moore A. Came up with an observation about how the power of computers (complexity of circuits) was doubling every 18 months/2 years. B. Is one of the founders of Intel. C. Is an engineer D. All of these are true 7
7. Who wrote Visicalc? A. Steve Jobs and Bill Gates B. Bill Gates and Steve Ballmer C. Dan Bricklin and Bob Frankston D. Al Gore 8
8. The value of the formula =5*3 + 8/2 A. 27.5 B. 19 C. 31 D. 18 9
9. How many megabytes are in 2 gigabytes? A. 200 B. 2048 C. 0.5 D. 2 E. 1024 10
10. If the formula =C5+1 were in cell C5 A. It would add 1 to the value already there B. It would cause a precedence error C. It would cause a #NAME error D. It would cause a circular reference 11
11. The formula =sum(a3:a7) is the same as A. =a3+a5 + a7 B. =a3*a7 C. =a3 + a4 + a5 + a6 + a7 D. =a3/a7 12
12. The system clock A. tells you what the date and time are B. sends out a regular signal to all computer components C. is used to make sure the hard drive is spinning fast enough D. is not a factor in how fast the computer runs 13
13. Being volatile is a property of A. data on a hard drive B. data in RAM C. a printout of a document D. a file burned on a CD 14
14. What does it mean to freeze a spreadsheet? A. the sheet is hung up and needs to be reloaded B. some columns and rows will not scroll when the rest of the sheet does C. all formulas are locked and cannot be altered D. an error has been found in a formula and it must be fixed before anything can be added 15
15. Secondary storage devices are A. Not necessary these days, we have plenty of RAM B. Useful because RAM is volatile and they are not C. Faster than RAM to access data D. Very sturdy, they can be handled roughly without problems 16
16. Which storage device would have problems with a magnet? A. A hard drive B. A memory stick (flash drive) C. A DVD D. An SD card 17
17. Cache memory A. Is between RAM and the keyboard B. Is used to hold data which is going to be used frequently or in the near future C. Holds data for a long time, it is not volatile D. None of these is true 18
18. An IF function in Excel A. has 3 parts: less than, greater than and equal to B. has 3 parts: condition, true and false C. has 4 parts: conditions, A, B and C D. has 2 parts: condition and test
19. A macro is A. a small program attached to a document B. a recording of actions that can be played back later C. vulnerable to virus attacks D. all of the above
20. A clustered column chart A. has a bar for each value charted, with height of bar proportional to the value represented B. represents the percentage of a whole that each value is C. shows the relationship of one set of values to another set of values
21. A macro in Excel will always be in a sheet with A. macro in the file name B.an extension of xlsm C.a chart D.numbers
22. Inserting a row or column into a spreadsheet A.has to be done one cell at a time B.will change any formulas which exist in the sheet only if they use absolute references C.will change a range in a formula if the insertion is inside the range or to the left of or above the formula with the range D.is not allowed once data has been entered into the sheet
23. The resolution of a printer is measured in A.Ppm B. Dpi C. Rpm D.Bytes 24
