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 »

10
Leave a Reply

avatar
6 Comment threads
4 Thread replies
2 Followers
 
Most reacted comment
Hottest comment thread
10 Comment authors
MeeshaKhalil Ur RehmanBenjamin BJxyxMURAD Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
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 + ;

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.