MS Excel MCQs

Which one cannot be used to enter data in a cell in MS Excel?

1. Pressing tab key
2. Pressing arrow key
3. Pressing Esc key
4. clicking the enter button to the formula bar

Which value remain unchanged in Ms Excel?

1. constant
2. variable
3. function
4. none

What is the purpose of inserting header and footer in the document?

1. To mark the starting of a page
2. To enhance the overall appearance of the document
3. To allow page headers and footers to appear on document when it is printed
4. To make large document more readable

Which among following wildcard characters are recognized by excel ?

1. +and -
2. ; and ^
3. * and ?
4. <and >

To select a group of worksheet we press and hold ____ key and select the sheet we want to add :

1. ctrl
2. shift
3. alt
4. None

The freezing row and column in Excel is in which pane

1. Freezing row
2. Freezing column
3. Freezing pane
4. None

The _____ option is used to show a specific row or column on every printed page.

1. print layout
2. print title
3. print view
4. none

In Excel data series is ?

1. A row or column of numbers that are plotted in a chart
2. Spreed sheet
3. Work sheet
4. None

Which would you choose to move selected text from one place to another?

1. copy and paste
2. delete and paste
3. move and paste
4. cut and paste

MS Excel is based on :

1. UNIX
2. DOS
3. WINDOWS
4. OS/2