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: a) calculations can be done automatically. b) changing data automatically updates calculations (as long as Excel is not set to calculate manually). c) more flexibility d) all of the above Question 2) The intersection of a row and a column is called: a) data. b) a field. c) a cell. d) an fromula. Question 3) When you are typing a formula (i.e. math equation) into a cell the first thing that must be entered is a) the first cell referenced b) parenthesis c) quotation marks d) an equal sign Question 4) Labels are used in a spreadsheet to: a) tell the computer what we are doing. b) help us identify the information. c) do the calculations. d) set up the formulas.
Background image of page 1

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

View Full DocumentRight 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

This note was uploaded on 09/08/2010 for the course BUS 91L at San Jose State University .

Page1 / 2

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

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online