{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

A short Excel Quiz - 91L

A short Excel Quiz - 91L - Question 5 The cell named F5...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
A short Excel Quiz Copy the following content into a Word file, fill it out, and submit via Blackboard. ________________________________________________________________ _____________________________ Please type in your name: Please fill in your 9-digit SJSU ID: The following is a short Quiz over Excel. Question 1) The advantage of using a spreadsheet is: Question 2) The intersection of a row and a column is called: Question 3) When you are typing a formula (i.e. math equation) into a cell the first thing that must be entered is Question 4) Labels are used in a spreadsheet to:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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

{[ snackBarMessage ]}