1000+ Advanced Excel MCQ Questions and Answers Pdf - 1
Question: 1
What function displays row data in a column or column data in a row?
(A) transpose
(B) rows
(C) index
(D) hyperlink
Ans: A
transpose
Question: 2
What is the shortcut key to replace a data with another in sheet?
(A) Ctrl + F
(B) Ctrl + H
(C) Ctrl + Shift + R
(D) Ctrl + R
Ans: B
Ctrl + H
Question: 3
The default font size in Excel worksheet is
(A) 10 points
(B) 12 points
(C) 14 points
(D) 16 points
Ans: A
10 points
Question: 4
Tab scroll buttons are place on Excel screen
(A) towards the top left corner
(B) towards the top right corner
(C) towards the bottom left corner
(D) towards the bottom right corner
Ans: C
towards the bottom left corner
Question: 5
When you link data maintained in Excel workbook to a word document
(A) the word document contains a copy of the actual data
(B) the word document must contain a hyperlink
(C) the word document cannot be edited
(D) the word document contains a reference to the original source application
Ans: D
the word document contains a reference to the original source application
1000+ GRE Non Verbal Reasoning Questions and Answers Pdf More
1000+ Non Verbal Reasoning Grouping of Images Questions Pdf More
Non Verbal Reasoning Grouping of Identical Figures Questions More
1000+ Transformation of Sentences Worksheet with Answers Pdf More
1000+ Ethiopian Bank Interview Questions and Answers Pdf More
100+ Reasoning Questions for Railway Group D Pdf More
1000+ RRB MCQ Questions and Answers More
Top 150+ Computer Networks Quiz Questions More
1000+ Disk Operating System MCQ with Answers Pdf More
100+ Verbal Reasoning Classification Questions and Answers More