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
7000+ Subject Verb Agreement Exercises for Class 6, 7, 8, 9, 10 More
7000+ Tenses MCQ Questions for Class 6, 7, 8, 9, 10 More
7000+ Tenses English Grammar Exercises with Answers Pdf More
7000+ Simple Compound Words Quiz with Answers More
7000+ Compound Words Worksheet with Answers for Grade 10 More
Important Synonyms and Antonyms for IBPS Clerk Exam More
Top 100+ Prepositions Quiz with Answers 2019-2020 More
TNPSC Problems on Trains Questions & Answers Pdf More
100+ Number, Ranking &Time Sequence Test Questions Answers More
Top 50+ Advanced Java Interview Questions 2020-2021 More