Edit Game
Spreadsheet Revision
 Delete

Use commas to add multiple tags

 Private  Unlisted  Public



 Save

Delimiter between question and answer:

Tips:

  • No column headers.
  • Each line maps to a question.
  • If the delimiter is used in a question, the question should be surrounded by double quotes: "My, question","My, answer"
  • The first answer in the multiple choice question must be the correct answer.

 Import questions





 Save   9  Close
Explain this formula! "=IF(A1=5,A2*0.05,"No discount")".
Any relevant answer is acceptable.
Give me one formatting that had been applied in this spreadsheet model.
Any reasonable answer!
Cell C3 contains the formula =SUMIF($F$3:$F$23,A3,$G$3:$G$23) Using cell references explain what this formula does.
What would be displayed in cell A1 if it was formatted:
to 1 decimal place
A cell contains the function =COUNTIF($F$16:$F$26,"Master craftsman") Using cell references, explain what this function does.
It counts the number of times the text “Master craftsman” is stored in the cells between F16 and F26.
Explain, when using a spreadsheet, the term ‘function’.
A function has a pre-defined name which performs a calculation/operation.
Describe how you would display the formulae used in a spreadsheet rather than the values.
Select the Formulas tab. In the Formula auditing section. Click on the Show Formulas icon.
Explain the difference between absolute and relative cell references.
Absolute referencing for a cell will fix that cell name/address and Relative referencing will allow cell names/addresses to be changed when formula is copied.
Explain why you would create a data model.
to explore different possible answers
Your experience on this site will be improved by allowing cookies.