NEW
Font size
WorksheetsQuiz in Excel 2
Total questions: 10
Worksheet time: 8mins
Is a spreadsheet software
MS EXCEL
MS WORD
MS POWERPOINT
MS Outlook
The IF Statement takes a logical test and determines a result that is either True or False.
True
False
To combine text that is in two different cells, use the formula:
COMBINE
MATCH
CONCATENATE
SUBTOTAL
A sales manager has requested the highest sale for the first quarter. Which function will be used?
SUM
HIGHEST
MAX
TOTAL
Which functioning Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
None of these
Functions in MS Excel must begin with ___
An Equal Sign
A Plus Sign
A > Sign
An () sign
Finds minimum value among a range of cell from A4, A5, A6, A7 and A8 in MS-Excel?
=MIN(A4 to A8)
=MIN(A4-A8)
=MIN(A4:A8)
All of the above
What do you call the blank boxes on a excel sheet
cell
info
Squares
Spots
In Excel,what would be a correct formula for changing a text from lower case to upper case ?
=UPPER B1
=PROPER(B1)
=UPPER(B1)
UPPER(B1)
B2:B6 is called?
cell address
sum formula
cell range
