NEW
Font size
WorksheetsMicrosoft Excel Functions & Formulas
Total questions: 15
Worksheet time: 8mins
1. The function that lets you add up a range of cells or values
SUM
MIN
AVERAGE
MAX
2. What function was used to find the lowest grade?
average
sum
min
max
3. What function was used to find the highest grade?
average
min
sum
max
4. SUM, AVERAGE, IF, MIN and MAX are examples of _______.
user-defined functions
table functions
online functions
predefined functions
5. All formulas used within the table are seen on the __________
cells
name box
cell reference
formula bar
6. The function COUNT is specific for ___________
counting cells
counting text
counting numbers
counting tables
7. To sort names in a worksheet, we can use this button.
8. In a worksheet, the vertical spaces with the headings A, B, C and so on
cell
column
row
data
9. To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
&
#
=
*
10. Microsoft Excel is categorize as ?
Database Software
Word Processing Software
Spreadsheet Software
Presentation Software
11. A function that automatically identifies and adds ranges of cells in your worksheet.
AutoSum
AutoFill
Cell Address
Function
12. The lines on your worksheet that separate the columns and rows.
Sheet Tabs
Functions
Formula Bar
Cell Grid
13. In Excel, Columns are labelled as ___
$A$1, $A$2, etc.
1,2,3 etc
A1, A2, etc
A, B, C, etc
14. Which is an example of a function?
=add(A1:A2)
A1+A2
=SUM(A1:A2)
=A1+A2
15. To find Maximum of B2 , C2 and D2 you would use :
=Max(B2:D2)
Max(B2:D2)
=Min(B2:D2)
Sum(B:D2)
