MS Excel MCQs

You use to create chart?

1. Wizard
2. Ms word
3. Excel
4. None

statistical calculation and preparation of tables and graphs can be done using

1. adobe photoshop
2. excel
3. notepad
4. powerpoint

___ is not a valid data type in excel

1. Number
2. Label
3. Character
4. none

Where can you set the shading color of a range of cells in excel ?

1. Choose required color on Fill Color tool in Formatting toolbar
2. Choose required color on Fill Color tool in Drawing toolbar
3. Choose required color form Patterns tab of Format Cells dialog box
4. All of these
5. None of these

We can set Page Border in Excel from:

1. From Border tab in Format Cells dialog box
2. From Border tool in Formatting toolbar
3. From Line Style tool in Drawing toolbar
4. we cannot set page border in Excel

You can move a sheet from one workbook into new book by

1. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
2. From Edit menu choose Move of Copy then choose (Move to end) and click OK
3. None of above
4. none

Which of the following is not an option in the spelling dialog box?

1. Ignore
2. Edit
3. Change
4. Ignore All
5. None of these

In MS-Excel, when the formula bar is activated, we can see:

1. Enter Button
2. Cancel Button
3. Edit Formula Button
4. None of these
5. All of these

In MS-Excel, the ZOOM option appears in:

1. Formula Bar
2. Status Bar
3. Title Bar
4. Scroll Bar
5. None of these

Each excel file is a book that contains different sheets. Which of the following can not be a sheet in a workbook .

1. Macro sheet
2. Chart sheet
3. Data sheet
4. none