Preview

06 - Functions in Excel

 1. A function is a predefined formula that performs calculations using specific values in a particular order.

  FALSE

  TRUE

 2. Excel includes many common functions that can be used to quickly find the sum, average, count, _____________________ for a range of cells

  maximum value, and minimum value

  legal suggestions

  ethical considerations

  None of the given options are valid

 3. The basic syntax for a function is the equals sign (=), the function name (SUM, for example), and one or more arguments. Arguments contain ________________________.

  the formulas themselves

   the information you want to calculate

  the cells you wish to delete

  a graphical version of the formula

 4. Multiple arguments must be separated by a comma. For example, the function =SUM(A1:A3, C1:C2, E1) will add the values of all of the cells in the _______________.

  two arguments

  single argument

  multiple formulas

  three arguments

 5. The "functions" ribbon can be found under 'Formulas'. To find the average score of 10 scores, which function might be suitable? (select from these options)
functions_in_excel_1.png

  Answer: AVG(FUNCTION)(A1:A10)

  Answer: FUNCTION(AVG)=A1:A10)

  Answer: =AVERAGE(A1:A10)

  Answer: =SUM+AVERAGE(1,2,3,4,5,6,7,8,9,10)

 6. Here we have used an _____ function. In this example, the result of the function will mean that cell B10 will say: _____.
functions_in_excel_2.png

  FUNC / NO - It's all gone

  AVG / YES

  IF / YES

  IF / No - It's all gone

 7. This function determines the highest cell value included in the argument.

  HIGHEST

  COUNT

  MIN

  MAX

 8. Cell D5 should count up the number of times "Chinese" has been listed in the list A2:A16. What should the function be in this case?
functions_in_excel_3.png

  Answer: =COUNTALL(A4:A18)>CHINESE

  None of these answers are valid

  Answer: =COUNTIF("Chinese", COUNT from A2 to A16)

  Answer: =COUNTIF(A2:A16,"Chinese")

 9. Unlike COUNT, COUNTA can be used to tally cells that contain data of any kind, not just numerical data.

  TRUE

  FALSE

 10. Excel has ______ functions that include the IF, OR and NOT functions.

  exponential

  logical

  legal

  ethical