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

	1. Text formulas
	A Replace cell references B Return ASCII values of characters C Concatenate and manipulate text D Show formula error value Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

2. How do you insert a row?

A Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu B Select the row heading where you want to insert the new row and select Edit >Row from the menu C Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	3. How do you select an entire column?
	A Select Edit > Select > Column from the menu B Click the column heading letter C Hold down the shift key as you click anywhere in the column. D Hold down the Ctrl key as you click anywhere in the column Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	4. How can you print three copies of a workbook?
	A Select File>Properties form the menu and type 3 in the Copies to print text box. B Select File >Print from the menu and type 3 in the Number of copies text box. C Click the Print button on the standard toolbar to print the document then take it to Kinko D Press Ctrl+P+3 Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	5. To create a formula, you first
	A Select the cell you want to place the formula into B Type the equals sign (=) to tell Excel that you C Enter the formula using any input values and the appropriate mathematical operators that make up your formula D Choose the new command from the file menu Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	6. To center worksheet titles across a range of cells, you must
	A Select the cells containing the title text plus the range over which the title text is to be centered B Widen the columns C Select the cells containing the title text plus the range over which the title text is to be enfettered D Format the cells with the comma style Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

7. How do you delete a column?

A Select the column heading you want to delete and select the Delete Row button on the standard toolbar B Select the column heading you want to delete and select Insert Delete from the menu C Select the row heading you want to delete and select Edit>Delete from the menu D Right click the column heading you want to delete and select delete from the shortcut menu Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	8. How can you find specific information in a list?
	A Select Tools > Finder from the menu B Click the Find button on the standard toolbar C Select Insert > Find from the menu D Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	9. When a label is too long to fit within a worksheet cell, you typically must
	A Shorten the label B Increase the column width C Decrease the column width D Adjust the row height Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	10. Which is used to perform what if analysis?
	A Solver B Goal seek C Scenario Manager D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	11. Hyperlinks can be
	A Text B Drawing objects C Pictures D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	12. Which button do you click to add up a series of numbers?
	A The auto sum button B The Formula button C The quick total button D The total button Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	13. To create a formula in MS Excel, you can use:
	A Values but not cell references B C ell references but not values C Values or cell references although not both at the same time D Value and cell references Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	14. Which of the following is the oldest spreadsheet package?
	A VisiCalc B Lotus 1-2-3 C Excel D StarCalc Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	15. Which of the following is a popular DOS based spreadsheet package?
	A Word B Smart cell C Excel D Lotus 1-2-3 Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	16. An excel workbook is a collection of
	A Workbooks B Worksheets C Charts D Worksheets and charts Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	17. In Excel, ____________ contains one or more worksheets.
	A Template B Workbook C Active cell D Label Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	18. A tuple is 1 -
	A Column of a Table B Two dimensional Table C Row of a Table D Key of a Table Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	19. Extensions of Excel 2003, Excel 2007 and Excel 2010 files are
	A xlsx, doc and xlsx B docx, doc and docx C xls, xlsx and xlsx D xls, xls and xlsx Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	20. Which of following Excel tools enables you to group and summarize information?
	A Conditional Formatting B Pivot Table C Sorting D Field Lists Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	21. The chart that shows the proportions of how one or more data elements relate to another data elements is
	A XY Chart B Line Chart C Pie Chart D Column Chart Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	22. Which chart is ideal for showing trends over time, where regular time intervals are plotted on the horizontal or x-axis?
	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

---

	23. In MS Excel a Data Series is defined as
	A A type of chart B A cell reference C A collection of related data D A division of result Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	24. The box on the chart that contains the name of each individual record is called the
	A Cell B Title C Axis D Legend Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	25. Tiny charts embedded in a cell that give a visual trend summary alongside your data are
	A Embedded Charts B Spark Lines C Chart Styles D Border Line Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	26. Which of the following Excel tools works backward from an objective to compute an unknown value?
	A Goal Seek B Custom Filter Function C Pivot Table D Boolean Operator Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	27. ACID`s Properties are
	A Atomicity & Consistency B Isolation & Durability C Atomicity, Consistency, Isolation & Durability D None of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	28. Which of the followings is the valid formula in MS Excel?
	A =POWER (2^3) B =POWER (2,3) C =POWER (2#3) D =POWER (2*3) Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	29. What are the expected results of the following formula in MS Excel? =IF (2<3, IF (4<3, 1+1, 2+2), 3+3)
	A 4 B 2 C 3 D None of the above. Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	30. Which of the following is not an arithmetic operator in MS Excel?
	A + (Plus) B * (Asterisk) C % (Percent) D = (Equals) Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	31. XML Stand for?
	A Excellent Markup Language B Extensible Markup Language C Extra Markup Language D Xerox Markup Language Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	32. Which of the following is the default view in MS Excel?
	A Page Layout View B Page Break View C Normal View D Custom View Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	33. You can add a hyperlink to your worksheet by pressing
	A Alt + K B Ctrl + H C Ctrl + K D Ctrl + Shift + K Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	34. The operation of combining two cells into a single cell in MS Excel is referred to as __________.
	A Join cells B Merge cells C Merge table D Join table Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	35. Which of the following term is used to refer a row?
	A Attribute B Tuple C Field D Instance Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	36. This is not a function category in Excel ________
	A Logical B Data Series C Financial D Text Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	37. Which of the following functions calculates the average or mean value of a group of numbers?
	A AVERAGE function B AVG function C SUM function D COUNT function Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

---