NEW
Font size
WorksheetsMastering Spreadsheet Essentials
Total questions: 20
Worksheet time: 10mins
What is the formula to add the values in cells A1 and A2?
`=A1+A2`
`=SUM(A1:A2)`
`=ADD(A1,A2)`
`=A1-A2`
Which of the following is a basic formula to subtract the value in cell B2 from B1?
`=B1+B2`
`=B1-B2`
`=SUBTRACT(B1,B2)`
`=B2-B1`
How do you multiply the values in cells C1 and C2?
`=C1*C2`
`=MULTIPLY(C1,C2)`
`=C1+C2`
`=C1/C2`
What is the formula to divide the value in cell D1 by D2?
`=D1*D2`
`=D1-D2`
`=D1/D2`
`=DIVIDE(D1,D2)`
Which function would you use to find the average of cells E1 to E5?
`=SUM(E1:E5)`
`=AVERAGE(E1:E5)`
`=MEAN(E1:E5)`
`=MEDIAN(E1:E5)`
How can you format a cell to display numbers as currency?
Change the font
Use the currency format option
Use the percentage format option
Use the text format option
Which of the following is a function to find the maximum value in a range of cells?
`=MIN()`
`=MAX()`
`=LARGEST()`
`=HIGHEST()`
What is the function to count the number of cells that contain numbers in a range?
`=COUNT()`
`=COUNTA()`
`=COUNTIF()`
`=COUNTBLANK()`
How do you apply bold formatting to a cell?
Use the italic button
Use the underline button
Use the bold button
Use the strikethrough button
Which function would you use to find the smallest number in a range?
`=MIN()`
`=MAX()`
`=SMALLEST()`
`=LOWEST()`
What is the function to count the number of non-empty cells in a range?
`=COUNT()`
`=COUNTA()`
`=COUNTIF()`
`=COUNTBLANK()`
How do you apply a border to a cell?
Use the fill colour option
Use the font colour option
Use the border option
Use the alignment option
How do you align text to the centre of a cell?
Use the left align button
Use the right align button
Use the centre align button
Use the justify button
Which function would you use to find the most frequently occurring number in a range?
`=AVERAGE()`
`=MEDIAN()`
`=MODE()`
`=FREQUENCY()`
What is the function to count the number of blank cells in a range?
`=COUNT()`
`=COUNTA()`
`=COUNTIF()`
`=COUNTBLANK()`
How do you italicise text in a cell?
Use the bold button
Use the underline button
Use the italic button
Use the strikethrough button
Which function would you use to round a number to the nearest whole number?
`=ROUND()`
`=TRUNC()`
`=CEILING()`
`=FLOOR()`
What is the formula to calculate the percentage of a number in cell H1?
`=H1/100`
`=H1*100`
`=H1%`
`=PERCENT(H1)`
How do you underline text in a cell?
Use the bold button
Use the italic button
Use the underline button
Use the strikethrough button
How do you merge two or more cells into one?
Use the split cells option
Use the merge cells option
Use the concatenate function
Use the join function
