NEW
Font size
WorksheetsExcel Review(formulas, lookups, formattings)
Total questions: 30
Worksheet time: 30mins
Which response best completes the following statement: A formula is used to?
perform calculations or other actions.
find averages.
locate a cell
One of these is a type of validation
Hardware
Emotional
List
Spreadsheet
Validation makes sure that data is
Correct
Suitable
Nonsense
Numerical
Verification is checking the data is
Secure
Correct
Suitable
From a list
A text length validation of up to 10 characters will not accept:
Timothy
Timothy James
Jamie
Paula
Why is Validation useful
It makes sure all the data is correct
It keeps data secure
It prevents errors typing data in
It keeps the data up to date
In VLOOKUP, the column # refers to the column in the:
table array
worksheet
workbook
list
What is the correct formula for this?
=HLOOKUP(A4, A1:F1,2, FALSE)
=VLOOKUP(B4, A1:F1,2, TRUE)
=HLOOKUP(A4, A1:F1,2, TRUE)
=VLOOKUP(A4, A1:F2,2, FALSE)
What formula is used to find East_01?
=HLOOKUP(A11, B1:B9,2, TRUE)
=VLOOKUP(A11, A1:B9,2, TRUE)
=HLOOKUP(A11, A1:B9,2, FALSE)
=VLOOKUP(A11, A1:B9,2, FALSE)
Jill wants to search her spreadsheet for a vaule in the first column of her tabel. What function should she use?
VLOOKUP
HLOOKUP
LOOKUP
SEARCH
What is the formula for this ?
INDEX=(A2:B5, MATCH(“Jim”,A2:A5,0),2)
INDEX=(A2:B5, MATCH(D2,A2:A5,-1),2)
INDEX=(A2:B5, MATCH(D2,A2:A5,0),2)
INDEX=(A2:B5, MATCH(D2,A2:A5,1),2)
What is the last argument for the MATCH function?
Lookup_value
Match_type
Lookup_array
Area_num
what is displayed when a data is not valid?
title
criteria
error
comment
What validation should be use where the user can only register from 8:00 to 14:30?
Whole number
Text length
Date
Time
What function is used to find price of Product_2?
HlookUp
Index
Match
VlookUp
What is the correct formula?
=VlookUp(A8, A1:B5, 2, FALSE)
= HlookUp(A8, A1:B5, 2, FALSE)
= VlookUp(A8, A1:B5, 2, TRUE)
What returns a position of a cell?
Index
Match
Column
Lookup
In Excel you can get validation on which tab?
Edit
Insert
Data
Formulas
What match type returns the exact value?
0(zero)
1(positive one)
-1(negative one)
2 (two)
What data validation should I write to ensure the car registration field is inputted correctly?
Text = 8
Text > 1
Text does not contain A
The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.
Array
Row Index Number
Price
Worksheet number
What is the syntax for index?
=index(row num, array, col num)
=index(array, row num, col num)
=index[array, row num, col num]
=index[ col num, array, row num]
What is the common way to identify a cell
reference is?
$A2
$A$2
D$2
D2$
What are columns in spreadsheet?
vertical
horizontal
upside down
downside
What are rows in spreadsheet?
vertical
horizontal
upside down
right
What is the first step to create a formula?
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you're about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
What validation should be use where grades of
75 to 100 will only be accepted?
text length
Whole number
Date
Time
