Microsoft Excel Mcqs with Answers for Test Preparation

Which of these will not select all the cells in a document ?

A. Using the Edit – Select All menu
B. Pressing Ctrl + A on the keyboard
C. Clicking three times with the right mouse button in the spreadsheet
D. None of These

In a computer spreadsheet rows are labeled ________ ?

A. by letters
B. by numbers
C. by cell references
D. by symbols

Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?

A. workbook
B. column
C. row
D. cell

Which of these keys are used in Ms Excel to copy formula from above cell?

A. Ctrl+ ”
B. Ctrl+ ;
C. Ctrl+ :
D. Ctrl+ ‘

Which of these keys are used in Ms Excel to copy value from above cell?

A. Ctrl + “
B. Ctrl+ E
C. Ctrl+ E
D. Ctrl+ D

Which key is used for help in Ms Excel?

A. F1
B. F2
C. F3
D. None of these

See also  Basic Computer MCQs with Answers For Test Preparation

Which one is example of spreadsheet software?

A. MS WORD
B. MS EXCEL
C. MS POWERPOINT
D. None of these

With which of the following all formulas in excel starts ?

A. /
B. *
C. $
D. =

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?

A. Smart tip
B. Soft Tip
C. Web Tip
D. Cell Tip

In MS Excel to delete duplicate values which menu is used?

A. Data
B. Tools
C. Formatting
D. Layout

How many rows are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

How many columns are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

Pages ( 9 of 15 ): « Previous1 ... 8 9 10 ... 15Next »

Leave a Comment