Microsoft Excel (MS Excel) Questions and Answers
– Multiple Choice Questions:
1. Which key is used for help in Ms Excel?
(a) F1
(b) F2
(c) F3
(d) None of these
(a) F1
2. Which key is used to edit in Ms Excel?
(a) F1
(b) F2
(c) F3
(d) None of these
(b) F2
3. Which key is used to Repeat last action in Ms Excel?
(a) F9
(b) F7
(c) F5
(d) F4
(d) F4
4. Which key is used to “Goto” tab in Ms Excel?
(a) F9
(b) F7
(c) F6
(d) F5
(d) F5
5. Which keys are used to Open tab in Ms Excel?
(a) Ctrl+u
(b) Ctrl+p
(c) Ctrl+o
(d) Ctrl+g
(c) Ctrl+o
ctrl+hift+: is to enter current time
17. Which of these keys are used in Ms Excel to copy value from above cell?
(a) Ctrl+ ”
(b) Ctrl+ ;
(c) Ctrl+ :
(d) Ctrl+ D
ctrl+d answer
Uppercase D will not work there so the answer is right. Thanks
16. Which of these keys are used in Ms Excel to Insert current date in workbook?
(a) Ctrl+ ”
(b) Ctrl+ ;
(c) Ctrl+ :
(d) Ctrl+ D
View Answer
(b) Ctrl+ ;
the Correct answer is ctrl+shift+;
You’re wrong bro. It’s ctrl + ;
he is right…
for date ctrl+:
for time ctrl+shift+;
o bhai answers thk diye hue hn exel p ja kl chk kr lo.. ctrl+; date ……………….ctrl+: time k lye ha shift ap ” ; ” ko ” : ” mn convert krne k lye use krty hn
42. Go to last cell in data region in Ms Excel : i think its CTRL + END is correct please cheque
YES GO TO LAST CELL CTRL+END
No dear, the answer is CTRL+HOME, the question is bit tricky it say last cell of the region not end cell of the region; for example you work in Cell A1 and then move to next cell B1 right below to it, now your last cell where you worked is A1 the very first cell so in order to move to your last cell (first cell) you need to press CTRL+HOME and as you press it , you will be on CELL A1 i-e last cell/first cell….Question is tricky other wise answer is fully OK.
What If I started worked in B1 cell then in c1, then still this ctrl+home gives me the same result??? I don’t think so. Besides you can search on google. Ctrl+home is used to move to cell A1 wherever you are working in the worksheet and ctrl+end is used to move to the last cell of the region. there’s no such thing like go to end cell.
Good work
Excellent work. A lot of posts like this are next to worthless, but in this one, you’ve set out a realistic, accurate account of what you did and how others might be able to pursue the suit. I assume lots of people take encouragement from this.
http://www.gkone1.com/
Wonderful effort
sir cheque Q#17,,,,, Cntl+D and Cntl+” both are do the same function.
what about cnntl+’ .. which is incorrect for above cell value and for formula as well its cntl+” . and is impossible to print ‘ with control, if u press cntl+’ result will be this “