Year 12 Spreadsheets
Authored by Sakina Abdulhamid
Computers
12th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
A (a) is a single unit on a spreadsheet formed due to an intersection of a column and a row.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=Sum(A1:A5) is a good example of a/an _________
function
formula
operator
expression
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The _______ function gives the current date and time.
=TIME()
=WEEKDAY()
=NOW()
=DATE()
4.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
Left, Right, Mid & Concatenate are examples of (a) functions.
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Macros in Excel are created in the ______ menu.
View
Developer
Formulas
Review
7.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
The ISTEXT function returns a (a) if the value is a number.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
