Download Computer Concepts and Logic - Midterm 1 Answer Key | CS 105 and more Exams Computer Science in PDF only on Docsity!
September 28th, 2010
DO NOT START UNTIL INSTRUCTED TO DO SO. YOU WILL LOSE POINTS IF YOU START WORKING ON THE TEST BEFORE WE TELL YOU. THIS IS A 60 MINUTE EXAM.
Do not leave this blank—fill it in now:
Name: Discussion Section: TA:
FORM
A
On the scantron:
- Use only a #2 pencil; otherwise, your exam won't be graded.
- Bubble in the Form Letter above!!! Bubble in your name and your NetID !!!
- Write your TA's name (of the section you attend) in the instructor slot and your section number in the section slot. Your section number is in the table provided at the bottom of this page.
About the test:
- The exam consists of 14 pages (including this page). Check that your copy is complete, and ask for a replacement if it is not. Make sure you look at all the pages.
- You will have 60 minutes to FILL IN THE SCANTRON for the exam. You may not use any books, notes, or other references for this exam.
- NO QUESTIONS WILL BE ANSWERED DURING THE EXAM.
- At the end of the exam, stop writing and put down your pencil when time is called. Hand in both the scantron and all the pages of the exam booklet.
- NO CALCULATORS OR ELECTRONIC DEVICES OF ANY KIND ARE ALLOWED. TURN OFF CELL PHONES AND PAGERS. IF A CELL PHONE RINGS, DO NOT ANSWER IT!!
Discussion section numbers and name of the TA whose lab you attend: Time Wednesday Thursday Friday 9:00 am 105-Chia-Chi Lin 114-Yi-Shuan Chen 10:00 am 106-Aditya Zutshi 115-Yi-Shuan Chen 11:00 am 107-Aditya Zutshi 116-Kai Zhao 12:00 pm 108-Michael Turnley 117-Kai Zhao 1:00 pm 109-Michael Turnley 118-Manish Yadav 2:00 pm 110-Sharat Nagaraja 119-Manish Yadav 3:00 pm 101-Karthik Ananth 111-Chinmay Sapre 120-Muntasir Rahman 4:00 pm 102-Chaitanya Date 112-Karthik Ananth 121-Muntasir Rahman 5:00 pm 103-Ankeeth Ved 113-Chinmay Sapre 6:00 pm 104-Ankeeth Ved
Note: Always choose one answer, the most correct choice of the answers offered.
Computer Concepts and Logic
- Which of the following is the correct order of execution in a machine cycle?
a. decode / execute / fetch / store b. decode / store / fetch / execute c. fetch / execute / decode / store d. fetch / decode / execute / store
- Which of these following is NOT a permanent storage device?
a. DVD b. Hard Disk c. RAM d. Flash Drive
- Which one of the following is an example of software?
a. RAM b. Hard Disk c. Excel d. Microprocessor
- What is the binary equivalent of the sum of the binary numbers 10010011 + 00101101?
a. 11000001 b. 10111120 c. 10111112 d. 11000000
- What is the binary equivalent of the decimal number 90?
a. 1011100 b. 1000110 c. 1011010 d. 1001001
Use the following diagram for the NEXT TWO questions. (Remember: 0 = False, 1 = True).
0 1^0
A
B
OR
NOT
NOT
- Which logical operator must be placed in the hexagons marked A and B in order for the logic circuit to output 1 for the shaded rectangles?
A B a. OR AND b. AND OR c. OR OR d. AND AND
- Assuming that you answered the previous question correctly, what is the final output for the logic circuit above?
a. 2 b. 0 c. 1 d. None of the above
Excel
Use the following screenshot to answer the NEXT FOUR questions.
- What will be displayed in cell D1?
a. 28 b. 24 c. 16 d. 35
- What will be displayed in cell D2 if the formula used in D1 is copied and pasted into D2?
a. 24 b. 28 c. 1 d. 8
- What will be displayed in the cell D2 if we use the fill handle and drag it from D1 to D2?
a. 5 b. 8 c. 11 d. 1
- What kind of change will you encounter if you cut the cell D1 and paste it on cell D5?
a. The formula in D5 becomes =(B5B7)+((C6)^A7)A b. There is an error displayed in cell D1. c. The formula in D5 becomes =(B1B3)+((C2)^A3)A d. There is an error displayed in cell D5.
- Evaluate the following Excel formula based on the order of preference among arithmetic operators. = -3(4-2^3)+4/*
a. - b. 8 c. - d. 14
- A selection of one or more cells is called a ______________?
a. Group b. Reference c. Range d. Package
Use the following screenshot to answer the NEXT question.
- The screenshot above is an example of a(n) ____________________
a. Absolute Reference b. Formularizing c. Use of Functions d. Circular Reference
- When typed into a cell in an Excel spreadsheet, which one of the following data is NOT considered by Excel as a string?
a. People b. CS c. 1-217-441- d. 786.
- Which one of the following statements below will help you to get the current date in Excel?
a. =TODAY() b. =DATE() c. =MONTH() d. =DAY()
Use the following screenshot taken in formula view to answer the NEXT question.
- The picture above shows the formula view of the spreadsheet. In normal view, what will be the values displayed in cells E2, E3 and E4 , respectively?
a. 8, 8 and 8 b. 6, 6 and 8 c. 6, 8 and 6 d. 6, 8 and 8
- Three of the following IF statements would always produce the same result, one wouldn’t. Which IF statement is different?
a. =IF(A1<10, IF( A1>5, 0, 1), 0) b. =IF(A1>5, IF( A1<10, 1, 0), 0) c. =IF(AND(A1<10, A1>5), 1, 0) d. =IF(OR (A1<=5, A1>=10), 0, 1)
- Which of the following Excel formulas would give the same results as using the following formula? We assume that cell A1 contains valid numeric data.
=ABS(A1)
a. =IF(A1 = 0, A1, -A1) b. =IF(A1 < 0, A1, -A1) c. =IF(A1 > 0, A1, -A1) d. =IF(A1 = -A1, A1, -A1)
Use the following screenshot taken in formula view to answer the NEXT question.
- Referring to above figure, which of the following cells will display FALSE in normal mode?
a. A b. A c. A d. A
VBA
- Choose the line of VBA code which will produce an error.
a. Cells(1,1).Value = MsgBox("Quit Game?",vbOkCancel) b. MsgBox "Quit Game?", vbOkCancel, "?" c. MsgBox ("Quit Game?", vkOkCancel) = Cells(1,1).Value d. MsgBox "Quit Game?", ,"Confirm"
Use the following code fragment to answer the NEXT question.
Range("T1").Value = Range("A1").Value Range("A1").Value = Range("B1").Value Range("B1").Value = Range("T1").Value Range("T1").Value = ""
- The above code fragment ___________________________
a. clears cells A1 and B b. places the values of cell B1 in cell A1 and clears cell A c. creates a circular reference d. exchanges the values in cell A1 and cell B
- Which of the following statements about Visual Basic is TRUE?
a. We can use a Message Box statement to gather data from the user. b. The ClearContents method also clears the formatting of a cell. c. & concatenates two strings together. d. A function is the same as a subprocedure.
- Which code fragments below would clear entire column F?
a. Range("F1:F100").ClearContents b. Range("F").ClearContents c. Range(F1:F100).ClearColumn d. Range("F:F").ClearContents
- Which of the following is NOT a way to empty the contents of cell A1?
a. Range("A1").Value = "" b. Range("A1").ClearContents c. Range("A1").Clear d. Range("A1").ClearFormats
Use the following screenshot to answer the NEXT question.
- Which of the following will display the above screenshot?
a. Cells(1,1).Value = InputBox("Your name?", "Name") b. Cells(1,1).Value = InputBox("Your name?", "Name" , "Name") c. Cells(1,1).Value = MsgBox ("Your name?", "Name") d. InputBox "Your name?", "Name"
Use the following code segment to answer the NEXT question.
Cells(1,4).Value = ""
- Cells(1,4) in the statement above is a(n) __________________
a. Property b. Assignment c. Object d. Button
- In Excel, to use the accelerator, the user would hold down the ______ key and press the accelerator letter.
a. Esc b. Shift c. Ctrl d. Alt
Extra Credit
Extra Credit:
You will not lose any points if you get this question wrong. You will, however, gain points if you answer it correctly. The maximum score possible remains 160 points.
Use the following screenshot to answer the NEXT question.
- Using the value in the Totals column for Jake and the Grade Criteria table, what is the correct formula to display Jake’s course grade?
a. =VLOOKUP(E2, B7:F8, 1) b. =HLOOKUP(E2, B7:F8, 2) c. =VLOOKUP(E2, B7:F8, 2) d. =HLOOKUP(E2, B7:F8, 1)
z roG)coG, TF s @(,)^ O @l(r) TF
q @@eO(O
s @@o@@
TF
o@co@o
IF
z @@OOO
t?
s O@O@O
g @@@OG,l TF ro @@OO@ TF
rr @OO@€,
tr
tz @CO(OO
tr
rs @@O@G)
TF
ra@@OO@
rs @@O@O
tt ro (^) @OO@@ TF
rz @@OCO
TF
rsO@e @C
tr rs @@@O@ TF
zo@@O@O
tr
zr@@OOO
zz@@OOe
Its
zsO@O@O
TF e+@@O@€)
TC (^) IF t 13)iO,OC(,^ zSOr')('' i,, i ll-i!
I qg '.:.,'' ',,.rr'i:,r ti 50 \ A.)1.-)| r; ' 1'1' (, ; rlJ (^) ' ;,,?:- : ,: :., r,r'i' t: -i2 .-r.,.r.,.,.:';l.i ii)
. r;.\ /,1\ (^) -] 'r ': :)4 (^) '.r', i' r'\9/^ !, r_i ' 55 i.i)rii;,':)a-q.It )o (^) l_r r 5^ !,.:^ I /:.?D^ C-:i -, (^) i i7J':,-/\g/L-er,\i:/ rr: q^ ,;:1 /i./-l
dA ;\ (^) ':,r, rF' :'-- /,i\ lAt/ lf ri9 (n Ie',(S)(O(i 1{ r^nl (^) :,." r.^ .11_L/,cJ\51. ,-^ /: ---' iF s< t:. '.'i ',;: , 'an -.--.
6Z,.^,ia',O@G) 'rf A? ,\ p-r/i). - 1i, fi'-/ (^) --l IF anv- ia),'pt,';''-- -1 ::.: ''r; ./
65 ii)^ iit'i '!,,; (::.,(::; tr <n'.u':r':--.''-/ , ni (n\ a;' ;i ,A
o i^= f^,v'r ' 9i^ ;l^ /'^\l!.rI^ ':.,:.:'. rl..' ()6 (^) \l,r (^) ' d_/ (^) \v u (^) 1-h_) nor' r?r\t iH\ fi!.' n) /rl/ :, :n 6 /Fr 6\ f-,'-l : :.6_/ iF 71 n' (ii^ 17-r , j'1^ ,?r TF :r,^iI I (^) .', .:.rt (^) .:. ' (^) \L,r: ,'-,\t '
II r
SIDE 713 .:4.ir.i'ti; (^) tr ,O^ r 74 r3r^ i:'i r_c){:_)f.
zsi^)(p)G)O,3)
iF
;e €)tr.o Q.-rc
f. (^) i. 77Q,'.3,OOg IF ta, u (i,, (n' : , : r;i:/ ,-"' '-l ';,.-' i1e 79 1-t)(!,)€,CO G.; TF'
BoG)G)eOG)
TI:
s10r(r-r€,)a0c
82iD(.i)O'erC 83 /CG)G-,@tl) TF sqG)(l)OOG) lt.
ss(ryrG.;e O /O
!i:
86.ofi cco
Tr. B7@,,")(t O O it 68 ,3-)(t^ (i'.r,, :) rtr 63 .3,,i.,, .i) {91,t_r
s0@G)Oo,O
'T (^) r: st (DG:.)lO(u 6l 1r 92 I,r)(a)O O O T' e3f:,,^G)O (DO TF
s+(oG)@OO
iE:
gs.D(D9.o
rF 96'd e,'{.)'.',1e
(^26) e) r.,1.rOl.tir,: 2;:i1)r.rnO'"_/.t. TF ZAe. '.;;O',i) (^) " , Ii zg r!)::j:O^ f .i) 7r so6).;)O Q)r!, 1 3t ft)i1'OOfir 3zG.te:laJ Gr 33 (.. (i,.;.-c)(J rr, S+G.i'.,1:OOO Ti: 35at(tJro)t;', ir, 36COC:.@f(., lf gZ (1,(.g.t(f f ,.r; irl
saO (1.;(f G)',.r
TI:
sgrc)(DO !,.;':.,
40re;.nr,!,lOt-, ti: 41 6)O,a.:)r.-,;f:l Ti 42 G't.:;1q,.]i3'r'1)r TF
+aG)if:(c,,:a)')
TF 44 ia';iri; (f^ iC ti.; TF
qsG)(n)(Oaa,)t
Tj: 46 6,\€',ii,l':) i:', a 47.3,r@(tG)G) TF
4sa!)rt (r)O €.
