Performing Calculations
Quiz by Lisa DeCastillia
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- 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
12 questions
Show answers
- Q1The ____ category of Excel functions returns (true-false) values.Math & TrigStatisticalInformationLogical30s
- Q2Which of the following is a Statistical function?ROUNDINTRANDAVERAGE30s
- Q3=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.ComplexNestedLogicalAbsolute30s
- Q4The numbers, text, or cell references used by the function to return a value are called ____.ArgumentsExpressionsDataValues30s
- Q5In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= “NO”?The formula returns the text “NO”.The formula returns the text “RESTART”.The formula returns the text “DONE”.d. The formula returns the text “NO, RESTART”.30s
- Q6Use ____ references when you want different formulas to refer to the same cellMixedRelativeAbsoluteFixed30s
- Q7Another name for the middle value is the ____ value.ModeRelativeMedianCenter30s
- Q8FUNCTION(argument1, argument2, ...) is ____.the general syntax of all functionsthe general syntax of all formulasan example of a formulathe syntax of writing optional arguments30s
- Q9Excel functions are organized into ____ categories810131130s
- Q10When you nest functions, you should have ____.the equal signthe same number of left and right parenthesesat least two functionsthe correct number of brackets30s
- Q11A logical function is a function that works with values that are either ____.right or wrongabsolute or relativepositive or negativetrue or false30s
- Q12______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.LookupSumFindAverage30s