NEW
Font size
S
M
L
XL
WorksheetsFormulas & Function in Excel 2021
Total questions: 10
Worksheet time: 3mins
Name
Class
Date
1.
Any text entered in excel is called a ________.
a)
Number
b)
Formula
c)
Cell
d)
Label
2.
By default numeric values are always ____________.
a)
Strings
b)
Integers
c)
Right-aligned
d)
Left-aligned
3.
A formula in excel begins with ____________.
a)
= (Equal Sign)
b)
x (Multiplication Sign)
c)
+ (Plus Sign)
d)
- (Minus Sign)
4.
A group of selected cells is called a __________.
a)
Range
b)
Group
c)
Cluster
d)
Selection
5.
A ________ is a cell address that can be used in a formula to denote a specific cell.
a)
Cell Reference
b)
Cell Number
c)
Cell Location
d)
Cell Pointer
6.
A _________ sign used as a prefix before the column and row for locking a cell.
a)
Dollar
b)
Percentage
c)
Ampersand
d)
Hash
7.
A _______ is a predefined formula in excel.
a)
Function
b)
Cell
c)
Spreadsheet
d)
Workbook
8.
Which of the following functions finds the specified number of values from a given set of values?
a)
COUNT() function
b)
FIND() function
c)
TOP() function
d)
SUM() function
9.
Which of the following is an arithmetic operator
a)
^
b)
&
c)
<>
d)
==
10.
TODAY() function returns the current date.
a)
True
b)
False
c)
It returns the current time
d)
It returns the current month
Reset
