There are 23 questions in this test.
(Only a correct response on the first attempt will increase your score.)
Question 1 |
Identify good reasons for naming ranges.
|
|
You can remember names more easily than arbitrary addresses
|
|
You can select a range by choosing its name from a list
|
|
There is no advantage in naming ranges
|
|
Both A and B
|
|
|
  |   |
Question 2 |
What submenu of the 'Insert' menu do you use to name a range?
|
|
'Name'
|
|
'Chart'
|
|
'Macro'
|
|
None of these
|
|
|
  |   |
Question 3 |
Which two commands can be used to name Ranges
|
|
INSERT NAME DEFINE
|
|
INSERT NAME CREATE
|
|
neither of the above
|
|
both of the above
|
|
|
  |   |
Question 4 |
Which option most closely defines an Excel Window
|
|
a method for viewing several applications simultaneously
|
|
a method for locking L shaped parts of the screen in place
|
|
a method for viewing different parts of the worksheet
|
|
none of the above
|
|
|
  |   |
Question 5 |
Window synchronisation represents the ability?
|
|
of visible parts of the worksheet to remain static
|
|
of titles to change with the changes in the active window
|
|
of windows in the worksheet to change together
|
|
none of the above
|
|
|
  |   |
Question 6 |
In which menu can you find the 'Protection' submenu?
|
|
'Insert'
|
|
'Format'
|
|
'Tools'
|
|
'Data'
|
|
|
  |   |
Question 7 |
An inbuilt formula is called a
|
|
a range name
|
|
the status bar
|
|
a function
|
|
a value
|
|
|
  |   |
Question 8 |
What values are calculated from the following
=avg(b2..b4), =avg(b2,b4), =int(avg(b2:b4))
given B2=9,B3=5,B4=7
|
|
7, 8, 7
|
|
10.5, 10.5, 10
|
|
21, 16, 21
|
|
none of the above
|
|
|
  |   |
Question 9 |
In correct order what are the arguments in an =IF function?
|
|
condition, false result, true result
|
|
true result, false result, condition
|
|
condition 1, condition 2, condition 3
|
|
none of the above
|
|
|
  |   |
Question 10 |
Write a function to test if A1>10 or < 5
|
|
=IF(A1>10,IF(A1<5,correct, incorrect), incorrect)
|
|
=Or(A1>10,A1<5)
|
|
=IF(A1>10 and A1<5,correct, incorrect)
|
|
=And(A1>10,A1<5)
|
|
|
  |   |
Question 11 |
What arguments are used in a Lookup function ?
|
|
table range, offset, column
|
|
offset,selector, column
|
|
column, table range, selector
|
|
offset, selector, table range
|
|
|
  |   |
Question 12 |
What are the two types of Lookup function ?
|
|
horizontal and selector
|
|
offset and vertical
|
|
choice and vertical
|
|
horizontal and vertical
|
|
|
  |   |
Question 13 |
When the lookup value in the function does not match the one
in the table, which value is used ?
|
|
next highest in the offset range
|
|
next lowest in the offset range
|
|
next lowest in the table range
|
|
next lowest in the selector range
|
|
|
  |   |
Question 14 |
How is the Choose function different from the Lookup function.
|
|
it isn't
|
|
it doesn't use a selector value
|
|
it is limited to eight values
|
|
its data table is contained within the function
|
|
|
  |   |
Question 15 |
In the criterion range, setting criteria on different rows allows
|
|
OR conditions to be tested
|
|
AND conditions to be tested
|
|
NOR conditions to be tested
|
|
NOT conditions to be tested
|
|
|
  |   |
Question 16 |
Which command puts the data in your list into alphabetical order?
|
|
'Sort'
|
|
'Filter'
|
|
'Form'
|
|
'Subtotal'
|
|
|
  |   |
Question 17 |
After choosing DATA FORM which button lets you specify search criteria
|
|
'New'
|
|
'Find Next'
|
|
'Criteria'
|
|
'Close'
|
|
|
  |   |
Question 18 |
What is a Macro ?
|
|
a large micro computer
|
|
a series of stored keystrokes
|
|
is short for macropod
|
|
none of the above
|
|
|
  |   |
Question 19 |
In which programming language does Excel 5 store your macros
|
|
Fortran
|
|
Visual C
|
|
VAX BASIC
|
|
Visual Basic for Applications
|
|
|
  |   |
Question 20 |
You can use macros to:
|
|
Create custom functions.
|
|
Automate routine tasks.
|
|
Create menus and dialog boxes for custom applications.
|
|
All of the above
|
|
|
  |   |
Question 21 |
When using buttons on your worksheet you can
|
|
assign a macro to a button
|
|
format the text in a button
|
|
move or size a button.
|
|
all of the above
|
|
|
  |   |
Question 22 |
From which menu can you open the 'Record Macro' submenu?
|
|
'Insert'
|
|
'Format'
|
|
'Tools'
|
|
'Data'
|
|
|
  |   |
Question 23 |
With Excel you can
|
|
change the toolbars or create new toolbars
|
|
change the toolbars only
|
|
create new toolbars only
|
|
toolbars cannot be customized or created
|
|
|
  |   |
  |
|