Five questions about spreadsheets
Try these 5 multiple-choice questions ...
A copy of your results on this test will be e-mailed to the question-setter Gisle Kleppe (gisle.kleppe@hsh.no). Please provide your own
first-name
,
surname
and
e-mail
address before answering the questions:
...
first-name
...
surname
...
e-mail
Q1.
What is the point of spreadsheet software?
(a)
You can write down numbers in rows and columns and send this by e-mail to others
(b)
You can write down numbers in rows and columns and store this on the harddisk
(c)
You can write down numbers in rows and columns and define formulas that connect the numbers. Then you can find answers to "what-if" questions
Check one of
(a)
to
(c)
.
Q2.
What was the name of the first spreadsheet software?
(a)
VisiCalc
(b)
Lotus-1-2-3
(c)
Borland Quattro Pro
Check one of
(a)
to
(c)
.
Q3.
What were the names of the inventors of spreadsheet software?
(a)
Dan Bricklin, Bob Frankston
(b)
Brian W. Kernighan, Dennis M. Ritchie
(c)
Linus Torvalds, Konrad Zuse
Check one of
(a)
to
(c)
.
Q4.
How does this "what-if" issue work in practice?
(a)
When a number in the spreadsheet is changed, the entire spreadsheet is cleared and you can start over. Then you can analyze the new situation
(b)
When a number in the spreadsheet is changed, you can enter corresponding new numbers into the other cells in the spreadsheet. Then you can analyze the new situation
(c)
When a number in the spreadsheet is changed, the program finds the consequences of the change by re-calculating all the formulas that have been entered. Then you can analyze the new situation
Check one of
(a)
to
(c)
.
Q5.
Is it possible to extend the functionality of MS Excel spreadsheets?
(a)
No, you got to limit yourself to the functions that are built in. But there are many
(b)
Yes, you can link a spreadsheet with short programs ("macros") which are written in Visual Basic for Applications (VBA)
(c)
Yes, you can send suggestions for extensions to Microsoft
Check one of
(a)
to
(c)
.
Quiz devised by Gisle Kleppe, e-mail
gisle.kleppe@hsh.no
.
Generated by
WebTools
script
McQ.pl
on 7 September 2002 at 13:33
Try these 5 multiple-choice questions ...
Try these 5 multiple-choice questions ...