akidszone.com – MCQs, Mock Tests | Computer Microsoft Excel MCQ Questions Part 5

1 ï»¿Which of the following format you can decide to apply or not in AutoFormat dialog box?

A Number format B Border format C Font format D All of above

✅ Correct Answer: 4

2 How can you remove borders applied in cells?

A Choose None on Border tab of Format cells B Open the list on Border tool in Formatting toolbar then choose first tool no border C Both of above D None of above

✅ Correct Answer: 3

3 Where can you set the shedding color for a range of cells in Excel?

A Choose required color form Patterns tab of Format Cells dialog box B Choose required color on Fill Color tool in Formatting toolbar C Choose required color on Fill Color tool in Drawing toolbar D All of above

✅ Correct Answer: 4

4 You can set Page Border in Excel from

A From Border tab in Format Cells dialog box B From Border tool in Formatting toolbar C From Line Style tool in Drawing toolbar D You can not set page border in Excel

✅ Correct Answer: 4

5 When all the numbers between 0 and 100 in a range should be displayed in Red Color apply

A Use =if function to format the required numbers red B Apply Conditional Formatting command on Format menu C Select the cells that contain number between 0 and 100 then click Red color on Text Color tool D All of above

✅ Correct Answer: 2

6 You can check the conditions against __________ when applying conditional formatting

A Cell value B Formula C Both of above D None of above

✅ Correct Answer: 3

7 Which of the following is not true regarding Conditional Formatting?

A You can add more than one condition to check B You can set condition to look for Bold and apply Italics on them. C You can apply Font border and pattern formats that meets the specified conditions D You can delete any condition from Conditional Formatting dialog box if it is not requried

✅ Correct Answer: 2

8 Which of the following is invalid statement?

A Sheet tabs can be colored B Some picture can be applied as a background of a sheet C You can set the column width automatically fit the amount of text D The width of a row and be specified manually or fit automatically

✅ Correct Answer: 4

9 You can use the formula pallette to

A format cells containing numbers B create and edit formula containing functions C enter assumptions data D copy a range of cells

✅ Correct Answer: 2

10 When a range is selected how can you activate the previous cell?

A Press the Alt key B Press Tab C Press Enter D None of above

✅ Correct Answer: 4

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

A 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 D Click on Merge and Center tool on formatting toolbar

✅ Correct Answer: 4

12 Tab scroll buttons are place on Excel screen

A towards the bottom right corner B towards the bottom left corner C towards the top right corner D towards the top left corner

✅ Correct Answer: 2

13 The Name box on to the left of formula bar

A shows the name of workbook currently working on B shows the name of worksheet currently working on C shows the name of cell or range currently working on D None of above

✅ Correct Answer: 3

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

A work sheet B chart sheet C module sheet D data sheet

✅ Correct Answer: 4

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

A Press the Alt key B Press the F2 key C Click the formula bar D Double click the cell

✅ Correct Answer: 1

16 You can merge the main document with data source in Excel. In mail merge operation Word is usually

A server B source C client D None

✅ Correct Answer: 3

17 How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

A F8 B F9 C F10 D F11

✅ Correct Answer: 2

18 You want to set such that when you type Baishakh and drag the fill handle Excel should produce Jestha Aashadh and so on. What will you set to effect that?

A Custom List B Auto Fill Options C Fill Across Worksheet D Fill Series

✅ Correct Answer: 1

19 Where can you change automatic or manual calculation mode in Excel?

A Double CAL indicator on status bar B Go to Tools >> Options >> Calculation and mark the corresponding radio button C Both of above D None of above

✅ Correct Answer: 2

20 How can you show or hide the gridlines in Excel Worksheet?

A Go to Tools >> Options >> View tab and mark or remove the check box named Gridline B Click Gridline tool on Forms toolbar C Both of above D None of above

✅ Correct Answer: 3

21 Which of the following Excel screen components can NOT be turned on or off?

A Formula Bar B Status Bar C Tool Bar D None of above

✅ Correct Answer: 4

22 What happens when you press Ctrl + X after selecting some cells in Excel?

A The cell content of selected cells disappear from cell and stored in clipboard B The cells selected are marked for cutting C The selected cells are deleted and the cells are shifted left D The selected cells are deleted and cells are shifted up

✅ Correct Answer: 2

23 Which of the following option is not available in Paste Special dialog box?

A Add B Subtract C Divide D SQRT

✅ Correct Answer: 4

24 Which command will you choose to convert a column of data into row?

A Cut and Paste B Edit >> Paste Special >> Transpose C Both of above D None of above

✅ Correct Answer: 2

25 It is acceptable to let long text flow into adjacent cells on a worksheet when

A data will be entered in the adjecent cells B no data will be entered in the adjacent cells C there is no suitable abbrevition for the text D there is not time to format the text

✅ Correct Answer: 2

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

A Doctorâ€™s symbol (Big Plus) B small thin plus icon C Mouse Pointer with anchor at the tip D None of above

✅ Correct Answer: 1

27 Which of the cell pointer indicates that you can fill series?

A Doctorâ€™s symbol (Big Plus) B small thin plus icon C Mouse Pointer with anchor at the tip D None of above

✅ Correct Answer: 2

28 Which of the cell pointer indicate that you can move the content to other cell?

A Doctorâ€™s symbol (Big Plus) B small thin plus icon C Mouse Pointer with anchor at the tip D None of above

✅ Correct Answer: 3

29 You can auto fit the width of column by

A double clicking on the column name on column header B Double click on the cell pointer in worksheet C Double clicking on column right border on column header D Double clicking on the column left border of column header

✅ Correct Answer: 3

30 Long text can be broken down into many lines within a cell. You can do this through

A Wrap Text in Format >> Cells B Justify in Edit >> Cells C Text Wraping in Format >> Cells Layout tab D all of above

✅ Correct Answer: 1

31 MS Excel provides the default value for step in Fill Series dialog box

A 0 B 1 C 5 D 10

✅ Correct Answer: 2

32 When a row of data is to be converted into columns

A Copy the cells in row select the same number of cells in row and paste B Copy the cells in column then choose Edit >> Paste Special then click Transpose and OK C Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK D Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special mark Transpose check box and click OK.

✅ Correct Answer: 4

33 Ctrl + D shortcut key in Excel will

A Open the font dialog box B Apply double underline for the active cell C Fill down in the selection D None of above

✅ Correct Answer: 3

34 The short cut key Ctrl + R is used in Excel to

A Right align the content of cell B Remove the cell contents of selected cells C Fill the selection with active cells to the right D None of above

✅ Correct Answer: 3

35 The command Edit >> Fill Across Worksheet is active only when

A One sheet is selected B When many sheets are selected C When no sheet is selected D None of above

✅ Correct Answer: 2

36 Which of the following series type is not valid for Fill Series dialog box?

A Linear B Growth C Autofill D Time

✅ Correct Answer: 4

37 Which of the following you can paste selectively using Paste Special command?

A Validation B Formats C Formulas D All of above

✅ Correct Answer: 4

38 Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A Square B Percentage C Goal Seek D Divide

✅ Correct Answer: 4

39 Edit >> Delete command

A Deletes the content of a cell B Deletes Formats of cell C Deletes the comment of cell D Deletes selected cells

✅ Correct Answer: 4

40 To remove the content of selected cells you must issue ______ command

A Edit >> Delete B Edit >> Clear >> Contents C Edit >> Clear >> All D Data >> Delete

✅ Correct Answer: 2

41 The Delete key of keyboard is assigned to which command in Excel?

A Edit >> Clear >> Contents B Edit >> Clear >> All C Edit >> Delete D All of above

✅ Correct Answer: 1

42 If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed) you must

A From Edit menu choose Clear and then Formats B From Edit menu choose Delete C Click on Remove Formatting tool on Standard Toolbar D Double click the Format Painter and then press Esc key in keyboard

✅ Correct Answer: 1

43 By default Excel provides 3 worksheets. You need only two of them how will you delete the third one?

A Right click on Sheet Tab of third sheet and choose Delete from the context menu B Click on Sheet 3 and from Edit menu choose Delete C Both of above D None of above

✅ Correct Answer: 1

44 Which of the following action removes a sheet from workbook?

A Select the sheet then choose Edit >> Delete Sheet B Select the sheet then choose Format >> Sheet >> Hide C Both of above D None of above

✅ Correct Answer: 1

45 While Finding and Replacing some data in Excel which of the following statement is valid?

A You can Find and Replace within the sheet or workbook B Excel does not have option to match case for find C Both are valid D None are valid

✅ Correct Answer: 1

46 Which of the following is not true about Find and Replace in Excel

A You can search for bold and replace with italics B You can decide whether to look for the whole word or not C You can search in formula too D You can search by rows or columns or sheets

✅ Correct Answer: 4

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

A From Edit menu choose Move or Copy sheet mark the Create a ccopy and Click OK B From Edit menu choose Move of Copy then choose (Move to end) and click OK C From Edit menu choose Move or Copy then select (new book) from To Book list and click OK D None of above

✅ Correct Answer: 3

48 What is the short cut key to replace a data with another in sheet?

A Ctrl + R B Ctrl + Shift + R C Ctrl +H D Ctrl + F

✅ Correct Answer: 3

49 Comments put in cells are called â€¦..

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

✅ Correct Answer: 2

50 Comments can be added to cells using

A Edit -> Comments B Insert -> Comment C File -> Comments D View â€“> Comments

✅ Correct Answer: 2

Computer — Learn

Microsoft Excel MCQ Questions Part 5