Basic Functions

Card 1 of 26 0 got it 0 still learning

Question

TapClick or press space to see the answer

Answer

All 26 cards in this set

Why is =SUM(J4:J34) usually better than writing =J4+J5+J6+ ... +J34?: It is much shorter and easier to check
Cell A1 contains Sun and cell A2 contains day. What does =CONCATENATE(A1,A2) show?: Sunday
Cell A2 contains jOHN smith. What does =PROPER(A2) show?: John Smith
Cells A1 to A5 contain 4, 9, 2, 7 and 5. What does =AVERAGE(A1:A5) show?: 5.4
Cells B1 to B5 contain the payments 12, 30, 8, 45 and 20. Which function gives the lowest payment?: =MIN(B1:B5)
A teacher wants the highest score from the test scores in cells C2 to C31. Which function should be used?: =MAX(C2:C31)
Cells A1 to A6 contain 12, Apple, 8, an empty cell, Pear and 5. What does =SUM(A1:A6) show?: 25
Cells A2 to A30 of a register contain the names of members. Which function counts how many names are in the list?: =COUNTA(A2:A30)
The price each customer paid is in column L, with the heading Price in L1. Which function counts how many customers paid a price?: =COUNT(L:L)
Which of these entries is a function rather than a formula?: =SUM(A1:A5)
The sales totals for 12 items in a school snack shop are in cells D2 to D13. Which function shows the shop's total revenue?: =SUM(D2:D13)
The ratings from a holiday survey are in cells H2 to H50. Which function shows the average rating?: =AVERAGE(H2:H50)
Cells A1 to A6 contain 12, Apple, 8, an empty cell, Pear and 5. What does =COUNT(A1:A6) show?: 3
Cells A1 to A5 contain 4, 9, 2, 7 and 5. What does =MAX(A1:A5) show?: 9
Which term describes a ready-made calculation that is built into a spreadsheet and can work on a group of cells at once?: Function
What is meant by the function SUM?: It adds together the numbers in a range
Which function adds up the numbers in a range and then divides by how many numbers there are?: AVERAGE
What is meant by the function COUNTA?: It counts the cells in a range that are not empty
Which function changes text so that the first letter of each word is a capital and the remaining letters are lowercase?: PROPER
What is meant by a range in a spreadsheet?: A group of cells from a first cell to a last cell
In =CONCATENATE(A1,A2), what does the comma do?: Separates the cells the function should use
In the function =AVERAGE(L:L), what does L:L mean?: Every cell in column L
What is meant by the function CONCATENATE?: It joins the contents of several cells into one piece of text
In =SUM(A1:A5), what do the brackets show?: Which cells the function should work on
In the function =MAX(C2:C31), which part tells the spreadsheet what to do?: MAX
Cells A1 to A5 contain 10, 20, Apple, 30 and an empty cell. What does =AVERAGE(A1:A5) show?: 20

Basic Functions

Round complete