This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Question 5) The cell named F5 refers to: a) row F column 5 b) column F row 5 c) functions available in cells d) Function key F4 Question 6) There are three types of data found in a spreadsheet. a) data, words, numbers b) formulas, data, numbers c) words, numbers, labels d) constants, formulas, labels Question 7) The formula =B2+A3 is located in cell B3 . If this was copied and pasted into cell D4 the resulting formula would be: A B C D 1 2 4 5 5 2 3 3 4 6 3 5 =B2+A3 3 8 4 4 3 4 ???????? a) =C2+C3 b) =D3+C3 c) =D3+C4 d) none of the above Question 8) The formula =$C$3*D3 is located in cell B1 . If this was copied and pasted into cell C1, what would the resulting formula be: A B C D 1 =$C$3*D3 ????????? 2 3 3 4 6 3 5 4 3 8 4 4 3 4 9 a) =$C$3*E3 b) =C3*E3 c) =$C$3*D3 d) 24 Question 9) A constant is another name for this type of data: a) number b) math equation c) formula d) description Question 10) I found this to be: a) too easy. b) not too bad. c) good. d) very good....
View Full Document
This note was uploaded on 09/08/2010 for the course BUS 91L at San Jose State University .