Spread Sheet (MS-EXCEL) MCQs > FREE SET - 5

	1. What is the default column width of MS Excel?
	A 5.5 B 2.98 C 8.43 D 6.49 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	2. You can use the formula palette to
	A Format cells containing numbers B Create and edit formula containing functions C Enter assumptions data D Copy a range of cells Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	3. 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 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	4. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	5. 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	6. Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?
	A Work Sheet B Chart Sheet C Module Sheet D Data Sheet Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	7. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	8. 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 of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	9. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	10. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	11. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	12. 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	13. 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 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	14. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	15. Which of the following option is not available in Paste Special dialog box?
	A Add B Subtract C Divide D SQRT Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	16. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	17. It is acceptable to let long text flow into adjacent cells on a worksheet when
	A Data will be entered in the adjacent cells B No data will be entered in the adjacent cells C There is no suitable abbreviation for the text D There is not time to format the text Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	18. Which of the cell pointer indicates you that you can make selection?
	A Doctor B Small thin plus icon C Mouse Pointer with anchor at the tip D None of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	19. Which of the cell pointer indicates that you can fill series?
	A Doctor B Small thin plus icon C Mouse Pointer with anchor at the tip D None of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	20. Which of the cell pointer indicate that you can move the content to other cell?
	A Doctor B Small thin plus icon C Mouse Pointer with anchor at the tip D None of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	21. 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	22. 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 Wrapping in Format >> Cells, Layout tab D All of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	23. MS Excel provides the default value for step in Fill Series dialog box
	A 0 B 1 C 5 D 10 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

24. 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. Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	25. 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	26. 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	27. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	28. Which of the following series type is not valid for Fill Series dialog box?
	A Linear B Growth C Auto fill D Time Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	29. Which of the following you can paste selectively using Paste Special command?
	A Validation B Formats C Formulas D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	30. 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 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	31. In Excel 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 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	32. 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 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	33. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	34. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	35. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	36. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	37. 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 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	38. 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 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	39. 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 copy 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	40. 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 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	41. Which of the following is not a valid Zoom percentage in Excel?
	A 10 B 100 C 300 D 500 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	42. The spelling tool is placed on ___________ toolbar
	A Standard B Formatting C Drawing D Reviewing Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

43. If you need a text to show vertically in a cell. How will you achieve this?

A Choose Vertical on Text alignment in Format Cells dialog box B Choose 90 Degrees in Orientation of Format Cells dialog box C Choose Distributed from the Vertical drop down list of Format Cells dialog box D Choose Center Across Selection from Horizontal combo box in Format Cells dialog box Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	44. How you can set 0.5 inch left indentation for a cell in Excel?
	A Excel does not have indentation feature B You can specify indentation only if you turn the rulers on C Indentation can be set from Format Cells dialog box D The indentation can be specified only when printing Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	45. You can automatically adjust the size of text in a cell if they do not fit in width by
	A Double clicking on the right border of column header B From Format choose Columns and then Auto fit Selection C From Format Cells dialog box mark Shrink to fit check box D All of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	46. Formatting a cell in Currency, you can specify
	A Decimal Places B Currency Symbol C Both of above D None of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	47. Formatting a cell in Number format you can
	A Decimal Places B Use 1000 separator C Negative numbers D Currency Symbol Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	48. What is entered by the function = today()
	A The date value for the day according to system clock B The time value according to system clock C Today D All of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	49. Which function will you use to enter current time in a worksheet cell?
	A =today() B =now() C =time() D =currentTime() Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	50. Special category of Number tab in Format Cells dialog box can be used to apply formats like
	A Zip Code B Phone Number C Both of above D None of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

---