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

	1. Merge cells option in MS Excel can be applied from
	A Format Cells dialog box Alignment Tab B Formatting toolbar C Both of above D None of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	2. Pre-made sheet formats like Simple, Classic and Accounting, Colorful etc. can be applied from
	A From Format >> Cells B From Format >> Auto format C From Table >> Auto format D All of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	3. Which of the following format you can decide to apply or not in Auto Format dialog box?
	A Number format B Border format C Font format D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

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

---

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

---

	6. 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 cannot set page border in Excel Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

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

---

	8. You can check the conditions against __________ when applying conditional formatting
	A Cell value B Formula C Both of above D None of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

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

---

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

---

	11. Which of the following is invalid regarding the Protection in Excel?
	A Protect Sheet B Protect Workbook C Protect Workspace D All of above are valid Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	12. The Trace Precedence on Auditing shows
	A Which cells are used in current formula B In which formula the current cell is used C Which cells are used in this formula and in which formula this cell is used D None of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	13. The Trace Dependence in auditing shows
	A Which cells are used in current formula B In which formula the current cell is used C Which cells are used in this formula and in which formula this cell is used D None of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	14. The arrows created by Auditing can be removed by
	A Click on the arrow and press Delete B Click on Remove All arrows on Formula Auditing toolbar C Both of above D None of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	15. Which of the following options is not available to remove arrows of Formula Auditing?
	A Remove all precedent arrows B Remove all dependent arrows C Remove all arrows D Remove all arrows for this cell Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	16. Excel is a good application for What IF analysis. Which of the following tool help you for this?
	A Formula Auditing B Research C Track Change D Goal Seek Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	17. Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?
	A Formula Auditing B Research C Track Change D Goal Seek Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	18. To apply Goal Seek command your cell pointer must be in
	A The Changing cell whose value you need to find B The Result Cell where formula is entered C The cell where your targeted value is entered D None of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	19. Which of the following is not What IF analysis tool in Excel?
	A Goal Seek B Scenarios C Macros D None of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	20. You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?
	A F9 B F5 C F8 D F11 Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	21. By default the cell pointer moves down when you press Enter. From where can you change this setting?
	A Tools >> Options >> View tab B Tools >> Options >> Calculation tab C Tools >> Options >> Edit tab D Tools >> Options >> Transition tab Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	22. When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as
	A AutoFill B AutoCorrect C AutoComplete D AutoFormat Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	23. How many recent files you can display on File menu at maximum?
	A 4 B 6 C 9 D 12 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	24. The default and maximum number of sheets for a new workbook in Excel 2003 is
	A 3 and 255 B 3 and 256 C 1 and 255 D 1 and 256 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	25. When you enter Sunday and fill right, Excel fill it with Monday, Tuesday and so on. From where Excel knows what to fill in next?
	A AutoComplete B AutoFormat C Custom List D Calculation Automatic Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	26. The minimum and maximum value you can set for Save Auto Recovery Info in Excel are
	A 1 and 120 minutes B 0 and 120 minutes C 2 and 60 minutes D 1 and 10 minutes Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	27. Which of the following cannot be hidden from Tools >> Options then View tab?
	A Startup Task Pane B Formula bar C Status bar D Scroll Bar Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	28. What happens if you remove the check mark from Row & Column headers on Options dialog box?
	A This will remove row headings and column headings of your data B This will remove the column headings A, B, C, C This will remove row and column heading of chart D This will remove row and column heading of table Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	29. The default font size in Excel Worksheet 2010 is
	A 11 points B 12 points C 14 points D None of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	30. The default font used in Excel 2010 is
	A Calibri B Algerial C Times New Roman D Preeti Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	31. Which of the following is not an option in the spelling dialog box?
	A Edit B Ignore C Ignore all D Change Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	32. You can quickly change the appearance of your work by choosing Auto Format from the ___________ Menu
	A Edit B View C Format D Tools Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	33. To protect a worksheet, you can choose Protection and the Protect Sheet from the ___________ menu
	A Edit B Format C Tools D Data Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	34. You can open the Highlight Changes dialog box by choosing Track Changes from the ___________ Menu.
	A Edit B Insert C Format D Tools Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	35. Which of the following is not a worksheet design criterion?
	A Efficiency B Auditability C Description D Clarity Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	36. To copy cell contents using drag and drop, press the
	A End key B Shift key C Esc key D None of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	37. If you press ___________ the cell accepts you
	A Enter B Ctrl + Enter C TAB D Insert Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	38. The auto fill feature
	A Extends a sequential series of data B Automatically adds a range of cell values C Applies a boarder around selected cells D None of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	39. What is the keyboard shortcut for creating a chart from the selected cells?
	A F3 B F5 C F7 D F11 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	40. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?
	A Format Report B Pivot Table C Refresh Data D Show Detail Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	41. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
	A Formula B Field C Data D Query Correct Answer: Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	42.
	A Formula B Function C Series D Syntax Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	43. You can edit existing Excel data by pressing the
	A F1 key B F2 key C F3 key D F4 key Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	44. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
	A G1-G10 B B1.G10 C B1;G10 D B1:G10 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	45. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
	A Go to File-Save As B Right click on the spreadsheet tab and select DELETE C Right click on the spreadsheet and select Insert D None of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	46. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
	A Goal Seek B Scenario Summary report C Forecasting D Trend line Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	47. What term describes a background that appears as a grainy, non-smooth surface?
	A Gradient B Pattern C Solid D Texture Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	48. Excel is a
	A Graphic program B None of these C Word processor D A spreadsheet Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	49. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
	A HTML B Pivot Table Field List C Pivot Table List D Pivot Table Report Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	50. What function displays row data in a column or column data in a row?
	A Hyperlink B Index C Transpose D Rows Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

---