{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

A short Excel Quiz - 91L

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

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

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:

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

View Full Document
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 ]}