A short Quiz over Excel

Please type in your name?:
Please type in your complete e-mail address?: (I will not give away or sell this to anyone.)

---

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 equation.

Question 3)

When you are typing an 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 equations.

Question 5)

The cell labeled 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) equations, data, numbers
c) words, numbers, labels	d) numbers, 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) equation

c) formula

d) description

Question 10)

I found this to be:

a) too easy.	b) not too bad.
c) good.	d) very good.