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
Online Puzzle Test for Bank Exams More
Medical Microbiology MCQS with Answers Pdf More
Medical Microbiology Quiz Questions and Answers Pdf More
Microbiology Multiple Choice Questions and Answers Pdf More
Challenging Logic Puzzles Pdf with Answers More
100+ Classification Reasoning Online Test More
100+ General Knowledge Questions and Answers for Computer Science More
Top 50+ National Integration GK Questions with Answers More
Logical Reasoning Questions and Answers Pdf More
1000+ Chemical Engineering Fluid Mechanics MCQ Questions & Answers More