MS Excel MCQs

Computer spreadsheet cell that is highlighted with a heavy border is a

(A). Active Cell

(B). Cell Containing A Formula

(C). Locked Cell

(D). None of These


Which shortcut can be used to switch between open workbooks?

(A). Ctrl + F2

(B). Ctrl + F6

(C). Ctrl + F8

(D). None of These


Shortcut to edit the selected cell?

(A). F3

(B). F8

(C). F2

(D). None of These


Merge cells option can be applied from?

(A). Formatting Toolbar

(B). Format Cells Dialog Box

(C). Both Of Above

(D). None of These


Style sheet formats can be applied from?

(A). Table > Autoformat

(B). Format > Autoformat

(C). Table > Cells

(D). None of These


Shortcut to enter current date?

(A). Home + ;

(B). Shift + ;

(C). Ctrl + ;

(D). NONE OF THESE


Which function in excel counts the numbers of characters in a cell?

(A). LENGHT

(B). LGT

(C). LEN

(D). None of These


To drag a selected range of data to another worksheet in the same workbook, use the?

(A). Ctrl Key

(B). Shift Key

(C). Alt Key

(D). None of These


To insert three columns between columns E and F you would

(A). Select Column E

(B). Select E And F

(C). Select F

(D). None of These


How can we set Page Border in Excel?

(A). From Edit Menu

(B). From Home

(C).  Cannot Set Page Border In Excel

(D). None of These


Leave a comment

× PPSC FPSC NTS CSS WhatsAp Group