ECDL Spreadsheets
Authored by Jay Patel
Computers
8th - 10th Grade
Used 11+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
55 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function does this refer to? "Results are returned IF the data specified in an equation meets conditions set by the formula; conditional operators."
=NOW
=LEFT
=IF
=LOOKUP
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function does this refer to? "Returns the current date."
=NOW
=DAYS360
=VLOOKUP
=DATE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Used to assist in organising information.
NOW
Column Chart
List
Table
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A list that limits data entry to specific choices programmed into the function.
Validated
Non-Validated
Count
Graph
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A list that allows additional entries other than those provided in the drop-down menu.
CountA
CountIf
Non-Validated
Validated
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A chart used to represent the contribution of each component of one series of data to the whole, (percentages).
Pie Chart
Exploded Pie Chart
Line Chart
Column Chart
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A chart used to show trends or changes in data over time.
Stacked Bar Chart
Line Chart
Pie Chart
XY Scatter Chart
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
