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

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

Question: 3

The default font size in Excel worksheet is

(A) 10 points

(B) 12 points

(C) 14 points

(D) 16 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

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