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

	1. Rounding errors can occur
	A When you use multiplication, division or exponentiation in a formula B When you use addition and subtraction in a formula C Because Excel uses hidden decimal places in computation D When you show the results of formulas with different decimal places than the calculated results Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	2. You can copy data or formulas
	A With the copy, paste and cut commands on the edit menu B With commands on a shortcut menu C With buttons on the standard toolbar D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	3. You can zoom a worksheet
	A With the mouse pointer in Print Preview B With the zoom button on the Print Preview toolbar C With the Zoom command on the view menu D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	4. You cannot link Excel worksheet data to a Word document
	A With the right drag method B With a hyperlink C With the copy and paste special commands D With the copy and paste buttons on the standard toolbar Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	5. This type of software is similar to an accountant
	A Word processing B Database C Spreadsheets D Graphics Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	6. Data marker on a chart are linked to data points in a worksheet, therefore
	A You can automatically apply formatting to a data series B You can change the position of a data marker and automatically change the data point value in the worksheet C You can change a data print value and automatically are draw the chart D A and B Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	7. You can use the format painter multiple times before you turn it off by
	A You can use the format painter button only one time when you click it B Double clicking the format painter button C Pressing the Ctrl key and clicking the format painter button D Pressing Alt key and clicking the format painter button Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	8. The default header for a worksheet is
	A Your name B The date and time C None D The sheet tab name Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	9. Which of the following is an absolute cell reference?
	A !A!1 B $A$1 C #a#1 D A1 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	10. Which of the following formulas is not entered correctly?
	A =10+50 B =B7*B1 C =B7+14 D 10+50 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	11. A typical worksheet has __________ Number of columns
	A 128 B 256 C 512 D 1024 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	12. Which of the following is not an example of a value?
	A 350 B May 10, 2001 C 57% D Serial Number 50771 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	13. The chart wizard term data series refers to
	A A chart legend B A collection of chart data markers C A set of values you plot in a chart D A data label Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	14. The Chart wizard term data categories refers to
	A A chart plot area B A horizontal axis C The organization of individual values with a chart D The data range that supply chart data Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	15. A worksheet range is a
	A A command used for data modeling B A range of values such as from 23 to 234 C A group of cells D A group of worksheets Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	16. Tab scrolling button
	A Allow you to view a different worksheet B Allow you to view additional worksheet rows down C Allow you to view additional worksheet columns to the right D Allow you to view additional sheets tabs Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	17. Concatenation of text can be done using
	A Apostrophe ( B Exclamation (!) C Hash (#) D Ampersand (&) Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	18. Data can be arranged in a worksheet in an easy to understand manner using
	A Auto formatting B Applying styles C Changing fonts D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

19. You can use drag-and-drop to embed excel worksheet data in a word document

A By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key B By dragging a range of excel data to the word button on the taskbar while pressing Shift key C By dragging a range of excel data to the word button on the taskbar while pressing Alt key D None of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	20. The auto calculate feature
	A Can only add values in a range of cells B Provides a quick way to view the result of an arithmetic operation on a range of cells C Automatically creates formulas and adds them to a worksheet D A and c Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	21. Excel uniquely identifies cells within a worksheet with a cell name
	A Cell names B Column numbers and row letters C Column letters and row numbers D Cell locator coordinates Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	22. To view a cell comment
	A Click the edit comment command on the insert menu B Click the display comment command on the window menu C Position the mouse pointer over the cell D Click the comment command on the view menu Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	23. When you want to insert a blank imbedded excel object in a word document you can
	A Click the object command on the insert menu B Click the office links button on the standard toolbar C Click the create worksheet button on the formatting toolbar D Click the import excel command on the file menu Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	24. To save a workbook, you:
	A Click the save button on the standard toolbar from the menu B Press Ctrl+F5 C Click Save on the Windows Start button D Select Edit>Save Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	25. You can edit a cell by
	A Clicking the formula button B Double clicking the cell to edit it in-place C Selecting Edit>Edit Cell from the menu D None of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	26. You can select a single range of cells by
	A Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells B Pressing the Ctrl key while dragging over the desired cells C Pressing the Shift key and an arrow key D Dragging over the desired cells Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	27. Which elements of worksheet can be protected from accidental modification?
	A Contents B Objects C Scenarios D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	28. You can use the drag and drop method to
	A Copy cell contents B Move cell contents C Add cell contents D A and B Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	29. Right clicking something in Excel:
	A Deletes the object B Nothing the right mouse button is there for left handed people C Opens a shortcut menu listing everything you can do to the object D Selects the object Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	30. Documentation should include
	A Destination and users of the output data B Source of input data C Information on the purpose of the workbook D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	31. Files created with Lotus 1-2-3 have an extension
	A DOC B XLS C 123 D WK1 Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	32. To delete an embedded objects, first
	A Double click the object B Select the object by clicking it C Press the Shift + Delete keys D Select it and then press the delete key Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	33. Comments can be added to cells using
	A Edit > Comments B Insert > Comments C File > Comments D View > Comments Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	34. When you copy a formula in MS Excel
	A Excel erases the original copy of the formula B Excel edits cell references in the newly copied formula C Excel adjusts absolute cell references D Excel doesn Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	35. Which menu option can be used to split windows?
	A Format > window B View > window > split C Window > split D View > split Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	36. You can convert existing excel worksheet data an charts to an HTML document by using
	A FTP wizard B Internet assistant wizard C Intranet wizard D Import wizard Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	37. A circular reference is
	A Geometric modeling tool B A cell that points to a drawing object C A formula that either directly or indirectly depends on itself D Always erroneous Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	38. Excel probably considers the cell entry January 1, 2000 to be a
	A Label B Value C Formula D Text string Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	39. You can enter which types of data into worksheet cells?
	A Labels, values, and formulas B Labe3ls and values but not formulas C Values and formulas but not labels D Formulas only Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	40. All worksheet formula
	A Manipulate values B Manipulate labels C Return a formula result D Use the addition operator Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	41. The Paste Special command lets you copy and paste:
	A Multiply the selection by a copied value B Cell comments C Formatting options D The resulting values of a formula instead of the actual formula Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	42. The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?
	A None of these B Select Format > Money from the menu C Click the Currency Style button on the formatting toolbar D You have to retype everything and manually add the dollar signs, commas, and decimals. Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	43. Which of the following is not a valid data type in excel
	A Number B Character C Label D Date/time Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	44. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
	A Option buttons B List boxes C Text boxes D Combo boxes Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	45. Which of the following options is not located in the Page Setup dialog box?
	A Page Break Preview B Page Orientation C Margins D Headers and Footers Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	46. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
	A Pie chart B Row chart C Line chart D Column chart Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	47. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
	A Press Ctrl +Home B Press Home C Press Shift + Home D Press Alt + Home Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	48. If you begin typing an entry into a cell and then realize that you don
	A Press the Erase key B Press Esc C Press the Enter button D Press the Edit Formula button Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	49. Which of the following will not cut information?
	A Pressing Ctrl + C B Selecting Edit>Cut from the menu C Clicking the Cut button on the standard D Pressing Ctrl + X Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	50. Which of the following is not a way to complete a cell entry?
	A Pressing enter B Pressing any arrow key on the keyboard C Clicking the Enter button on the Formula bar D Pressing spacebar Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

---