MS Excel Microsoft Excel Questions Answers MCQs

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

View Answer
  (a) F1 

2.  Which key is used to edit in Ms Excel?
(a) F1
(b) F2
(c) F3
(d) None of these

View Answer
  (b) F2

3. Which key is used to Repeat last action in Ms Excel?
(a) F9
(b) F7
(c) F5
(d) F4

View Answer
(d) F4

4. Which key is used to “Goto” tab in Ms Excel?
(a) F9
(b) F7
(c) F6
(d) F5

View Answer
(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

View Answer
(c) Ctrl+o

 

Pages ( 1 of 10 ): 1 23 ... 10Next »

16
Leave a Reply

avatar
8 Comment threads
8 Thread replies
2 Followers
 
Most reacted comment
Hottest comment thread
15 Comment authors
Pata naiAuthorfahimmuteebilal Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Pata nai
Guest
Pata nai

ctrl+hift+: is to enter current time

Pata nai
Guest
Pata nai

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

xyx
Guest
xyx

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+;

Benjamin BJ
Guest
Benjamin BJ

You’re wrong bro. It’s ctrl + ;

bilal
Guest
bilal

he is right…
for date ctrl+:
for time ctrl+shift+;

mutee
Guest
mutee

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

Masroor Ahmed
Guest
Masroor Ahmed

42. Go to last cell in data region in Ms Excel : i think its CTRL + END is correct please cheque

MURAD
Guest
MURAD

YES GO TO LAST CELL CTRL+END

Khalil Ur Rehman
Guest
Khalil Ur Rehman

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.

Meesha
Guest
Meesha

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.

pkmcqs
Guest
pkmcqs

Good work

ashfaq
Guest

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/

Azaad
Guest
Azaad

Wonderful effort

Imran Ullah
Guest
Imran Ullah

sir cheque Q#17,,,,, Cntl+D and Cntl+” both are do the same function.

fahim
Guest
fahim

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 “