Uses Advance Functions and Formulas in an Electronic Spreadsheet
Quiz by EVANGELINA A. SABUAD
Feel free to use or edit a copy
includes Teacher and Student dashboards
Track each student's skills and progress in your Mastery dashboards
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
This is a tool designed with functions and formulas that can perform advanced numerical calculations.
MS Word
MS Excel
MS PowerPoint
MS Publisher
30sTLEIE6-0f-12 - Q2
It is a function that counts numbers in a series of cells.
AVERAGE
SUM
COUNT
LEN
30s - Q3
It is a function that adds two or more numbers together.
AVERAGE
COUNT
LEN
SUM
30s - Q4
It is a function that is used to return the length of an entry or string.
COUNT
AVERAGE
SUM
LEN
30s - Q5
These are calculations that return a result.
FORMULA
SUM
FUNCTION
FEEDBACK
30s - Q6
It is a function that calculates the average of a series of numbers.
LEN
AVERAGE
FORMULA
SUM
30s - Q7
Used to count the number of cells that have numbers and/or any other characters in them.
SUM
FORMULA
COUNTA
COUNT
30s - Q8
Formulas always start with an equal sign.
truefalseTrue or False30s - Q9
Most commonly used spreadsheets by individuals and businesses to perform much-needed calculations and operations.
Users re-arrange answers into correct orderJumble30s - Q10
Used to calculate values in an electronic spreadsheet program.
FORMULA
AVERAGE
COUNTA
LEN
30s