WorksheetsFunctions and Charts in MS Excel
Total questions: 14
Worksheet time: 11mins
What is MS Excel?(Hint- it comes under MS Office)
Application Software
Application
Operating System
Utility Program
FOSS
What will be the output of =UPPER("akshat")
AKSHAT
akshat
Akshat
AKKSHAT
Which option will convert AKSHAT into akshat?
=LOWER(AKSHAT)
=LOWER("AKSHAT")
LOWER("AKSHAT")
LOWER(AKSHAT)
What will be the answer of =LEN("GTA SA")
8
5
6
9
What will be the answer of =GCD(18;24)
(a)
What will be the answer of =DATE(1987,3,10)
(a)
What is the icon of current MS Excel
When does this error occur- #######
This is shown when a formula refers to the cell that is not valid.
This is shown when data in the cell is longer than width of the cell.
Are you enjoying the quiz?
Yes! a lot 😊
No. its boring 🥱
Its average
Needs more interesting questions
Which of the following formula shows 11:30 PM
=TIME(11;30;22)
TIME(11,30,22)
=TIME(23,30,22)
TIME(23;30;22)
=TIME(22;30;20)
What will be the answer be in G2 if we copy the formula of G1 and paste it in G2.
75
65
30
15
What will be the answer be in G2 if we copy the formula of G1 and paste it in G2.
45
65
35
30
What will be the cell color in G2 if I add conditional formatting to change cell color to green if P is written
The cell will become green.
The cell will remain white.
The cell will become red.
The cell will become yellow.
What is the use of line chart in Microsoft excel?
Used for data that may need to be compared.
Used to illustrate changes in a value over a period of time.
Used to compare individual items in a dataset.
