WorksheetsYear 12 Spreadsheets
Total questions: 20
Worksheet time: 14mins
A (a) is a single unit on a spreadsheet formed due to an intersection of a column and a row.
=Sum(A1:A5) is a good example of a/an _________
function
formula
operator
expression
The _______ function gives the current date and time.
=TIME()
=WEEKDAY()
=NOW()
=DATE()
Left, Right, Mid & Concatenate are examples of (a) functions.
The following formula extracts the ___________ of an email address in A1.
=RIGHT(A1,LEN(A1)-FIND("@",A1))
the @ symbol
domain name
username before the @ symbol
None of the above
Macros in Excel are created in the ______ menu.
View
Developer
Formulas
Review
The ISTEXT function returns a (a) if the value is a number.
The ______ function finds a value based on its position within a table.
=MATCH
=VLOOKUP
=INDEX
=XLOOKUP
An IF functions contains _________ elements.
one
two
three
not known
Write a formula in B1 to retrieve data from A1 as shown.
(a)
Identify the following type of test data. Test data of 100% for testing a cell that contains student marks in percent.
Normal
Extreme
Abnormal
None of the above
Identify the correct structure of the find formula looking for letter Z.
=FIND("Z",A1)
=FIND("",A1)
=FIND(A1,"Z")
=FIND(text,A1)
Which formula will NOT work in B2 to show pass or fail if pass mark is 60.
=IF(A2<=60,"Fail","Pass")
=IF(A2>=60,"Pass","Fail")
=IF(B2>=60,"Pass","Fail")
=IF(A2>59,"Pass","Fail")
The <> symbol in Ms. Excel mean:
Equal to
Not Equal to
Both
Neither
What-if analysis is located on the _____ menu in Ms. Excel.
Review
Developer
View
Data
To calculate the length of cell A1, I type (a) in cell A2.
Which of the following is NOT an advantage of a simulation.
Changes to the model can be made very quickly and effectively
Expensive prototypes do not need to be created in order to experiment with different variations
The way a simulation reacts is only as good as the model it is based on.
Equipment does not suffer from wear and tear.
The (a) function gives the number of the day of the week.
Cell A1 contains 78569345.
Write a formula in A2 to retrieve the digits 693.
(a)
To concatenate the data from two cells in to a third cell, a user can use the ____ symbol.
+
$
" "
&
