MS-Excel Questions and Answers

Q.1 Which among following is associated with excel?

(A) Graphic program

(B) Spreadsheet

(C) Microsoft office

(D) None of these

Q.2  A Spreadsheet contains?

(A) columns

(B) rows

(C) rows and columns

(D None of these

Q.3  Top open an existing workbook, click the open button on the…………toolbar?

(A) form

(B) standard

(C) Drawing

(D) Formatting

Q.4  Which among following is not associated with spelling dialogue box?

(A) Change

(B) Ignore All

(C) Ignore

(D) open

Q.5  b7 cell address represents

(A) first row and fifth column

(B) Second row and seventh column

(C) second row and fourth column

(D) None of these

Q.6 Formula palette is used to?

(A) format cells containing number

(B) created and edit formulas containing functions

(C) entered assumption data

(D) Copy all cells

Q.7  The cell reference for a range of cells that starts in cell b5 and goes over to column I and down to row 9 is?

(A) b5:9I

(B) 5b:I9

(C) b5:I9

(D) b5:I:9

Q.8  thicker border around a active cell is known as………

(A) Cell Pointer

(B) Assistant Wizard

(C) Cell Border

(D) Export Wizard

Q.9  Formula Bar shows the ………of a result.

(A) Table

(B) List

(C) Formula

(D) result

Q.10  What function displays row data in a column or column data in a row?

(A) Hyperlinks

(B) Rows

(C) Index

(D) Transpose

Share :

Facebook
Twitter
WhatsApp
Email

Join Us

Subscribe

Leave a Reply

Your email address will not be published. Required fields are marked *

More Himachal GK Question