WorksheetsMs Excel Functions
Total questions: 10
Worksheet time: 5mins
In a worksheet, the vertical spaces with the headings A, B, C and so on
Cell
Column
Row
Data
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
Column
Label
Row
Cell Address
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
&
#
=
*
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
In Excel, the name of the bar where information appears as you input data in called ?
File Bar
Help Bar
Formula Bar
Window Bar
Microsoft Excel is categorize as ?
Word Processing Software
Database Software
Spreadsheet Software
Presentation Software
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
The function COUNTA is specific for _________________
Counting text
Counting cells
Counting number
Counting tables
