Font size
WorksheetsM1 Final Test 2nd Term 2024
Total questions: 21
Worksheet time: 33mins
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
=
#
$
*
In a worksheet, the vertical spaces with the headings A, B, C and so on is called?
Cell
Column
Letters
Data
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on is called?
Column
Label
Row
Cell Address
The function that lets you add up a range of cells or values
AVERAGE
MIN
MAX
SUM
The function COUNT is specific for _________________
Counting Numbers
Counting Text
Counting Cells
Counting Tables
The bar where information appears as you input data is called ______________.
file bar
formula bar
help bar
window bar
Which function in Excel checks whether a condition is true or not ?
SUM
COUNT
IF
AVERAGE
In Excel, Columns are labelled as ___
A1, A2, A3, etc
1,2,3, etc
B1, B2, B3, etc
A, B, C, etc
In Excel, which one denoted a call range from B1 through E5.
B1:E5
B1,E5
B1;E5
B1/E5
Formula in Excel start with......
#
=
%
$
This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.
COUNTBLANK
COUNTA
COUNT
COUNTIF
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
Depending upon the result, one of two actions will be carried out.
COUNTIF
SUMIF
DATEIF
IF
A program using a table comprising of rows, columns and cells.
MS Excel
MS PowerPoint
MS Word
MS Outlook
The first cell in a worksheet is what?
B1
A1
1A
1B
What is the name of the cell that is colored blue?
A
B
B2
2B
In Excel, rows are identified by this
Letters
Alphanumeric
Question Mark
Numbers
Absolute cells reference looks like this....
$A$1
1$A$
A#1#
A$$1$$
Which symbol is being added for a relative cell to become an absolute cell?
-
=
#
$
Which of the following is not an arithmetic operator?
+
-
]
*
What button on your keyboard will you press to change a regular cell into an Absolute Cell?
F1
F2
F3
F4
Please write what will be the formula on cell B4 and the answer when you copy A4 which is an absolute formula.
