MS Excel MCQs

While finding and replacing some data in Excel,which of following statement is valid

1. You can Find and Replace within the sheet or workbook
2. Excel does not have option to match case for find
3. All
4. None

Which tool you will use to join some cells and place the content at the middle of joined cell ?

1. From Format Cells dialog box click on Merge Cells check box B. From Format Cells dialog box select the Centered alignment C. From Format Cells dialog box choose Merge and Center check box
2. From Format Cells dialog box click on Merge Cells check box
3. Merge Cells check box
4. none

Which shortcut key is for auto sum ?

1. Alt + =
2. Ctrl + Shift
3. Alt + F1
4. Ctrl + =

which option is not avail.able in Paste special dialogue box ?

1. Subtract
2. Divide
3. SQRT
4. none

Which of the following EXCEL feature allows users to evaluate values and return a result?

1. Formula
2. Formating
3. Filters
4. None of these

Which of the cell pointer indicates you that you make selection ?

1. Mouse Pointer with anchor at the tip
2. Small thin plus icon
3. Doctor’s symbol (Big Plus)
4. None

Which of following series type is not valid for fill series dialogue box ?

1. Time
2. Autofill
3. Growth
4. All

Which of following is not the correct method of editing the cell content ?

1. Press the Alt key
2. Click the formula bar
3. Press the F2 key
4. none

Which of following is not true about find and replace in excel

1. You can search in formula too
2. You can search for bold and replace
3. You can search in formula too
4. None

Which of following is not a valid zoom percentage in Excel?

1. 10
2. 100
3. 300
4. 500