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

	1. When you insert an Excel file into a Word document, the data are
	A Hyperlinked B Placed in a word table C Linked D Embedded Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	2. Except for the __________ function, a formula with a logical function shows the word
	A IF B AND C OR D NOT Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	3. Macros are
	A Insert B Format C Tools D Data Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	4. You can open the consolidate dialog box by choosing Consolidate from the ___________ menu.
	A Insert B Format C Tools D Data Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	5. Each excel file is called a workbook because
	A It can contain text and data B It can be modified C It can contain many sheets including worksheets and chart sheets D You have to work hard to create it Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	6. Which types of charts can be created using MS Excel 2010?
	A Line charts and pie charts only B Only line charts C Bar charts, line charts and pie charts D Bar charts and line charts only Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	7. How data are organized in a spreadsheet?
	A Lines and spaces B Layers and planes C Height and width D Rows and columns Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	8. What does the VLOOKUP function do?
	A Looks up text that contain B Checks whether text is the same in one cell as in the next C Finds related records D All of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	9. Which of the following is a correct order of precedence in a formula calculation?
	A Multiplication and division, exponential positive and negative value B Multiplication and division, positive and negative values, addition and subtraction C Addition and subtraction, positive and negative values, exponentiation D None of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	10. A function inside another function is called a ___________ function.
	A Nested B Round C Sum D Text Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	11. How should you print a selected area of a worksheet, if you
	A On the file menu, point to print area and then click set print area. B On the file menu, click print and then click selection under print what C On the view menu, click custom views, then click add D All of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	12. Which function calculates your monthly mortgage payment?
	A PMT (payments) B NPER (number of periods) C PV (present value) D All of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	13. Which of the following methods cannot be used to enter data in a cell?
	A Pressing an arrow key B Pressing the tab key C Pressing the Esc key D Clicking the enter button to the formula bar Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	14. Which of the following will not set text in selected cells to italics?
	A Pressing Ctrl + I on the keyboard B Using the Tools C Using the Format D None of the above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	15. Which of the following methods cannot be used to edit the content of cell?
	A Pressing the Alt key B Clicking the formula bar C Pressing F2 D Double clicking the cell Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	16. You can activate a cell by
	A Pressing the Tab key B Clicking the cell C Pressing an arrow key D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	17. Which of the following setup options cannot be set in the page setup dialog box?
	A Printer selection B Vertical or horizontal placement C Orientation D Row and column titles Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	18. What term refers to a specific set of values saved with the workbook?
	A Range B Scenario C Trend line D What-if analysis Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	19. Which of the following describes how to select all the cells in a single column?
	A Right click on column and select Pick from list B Use data C Left click on the gray column title button D Pressing Ctrl + A on the keyboard Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	20. When you use the fill effects in the format data series dialog box, you can not
	A Rotate text on the chart B Select a fore ground color C Select a pattern D Select a background color Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	21. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
	A Rows and columns B Headings C Speed D None Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	22. Which of the following is not a basic step in creating a worksheet?
	A Save the workbook B Modify the worksheet C Enter text and data D Copy the worksheet Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

23. What

A Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows B Select the range you want, include both cells, point to fill on the Edit menu, and then click down. C Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special D All of above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	24. To insert three columns in MS Excel between columns D and E you would
	A Select column D B Select column E C Select columns E, F and G D Select columns D, E, and F Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	25. To center worksheet titles across a range of cell, you must
	A Select the cells containing the title text and use the fill handle to center the text across a range of cells B Widen the columns C Select the cells containing the title text and use the fill handle to center the text across a range of cells D Widen the column Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	26. When integrating MS Word and Excel, Word is usually the
	A Server B Source C Client D None Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	27. Charts tips can
	A Show the formatting of a data label B Show the name of a data series C Show the value of data point D B and C Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	28. The Name box in MS Excel
	A Shows the location of the previously active cell B Appears at the left of the formula bar C Appears below the status bar D Appears below the menu bar Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	29. How do you change column width to fit the contents?
	A Single-click the boundary to the left to the column heading B Double click the boundary to the right of the column heading C Press Alt and single click anywhere in the column D All of above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	30. When you work with large worksheets, you may need to
	A Size the worksheet to fit on the specific number of pages B Add and remove page breaks C Specify only certain print areas D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	31. Hyperlinks cannot be
	A Special shapes like stars and banners B Drawing objects like rectangles ovals C Pictures D All can be hyperlinks Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	32. You can use the horizontal and vertical scroll bars to
	A Split a worksheet into two panes B View different rows and columns C Edit the contents of a cell D View different worksheets Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	33. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
	A Spreadsheet program B Database program C Word processor program D Desktop publisher program Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	34. You can add an image to a template by clicking the Insert Picture From File button on the ______________ Toolbar.
	A Standard B Formatting C Drawing D Picture Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	35. To drag a selected range of data to another worksheet in the same workbook, use the
	A Tab key B Alt key C Shift key D Ctrl key Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	36. When creating a vertical page break
	A The active cell must be A1 B The active cell can be anywhere in the worksheet C The active cell must be in row 1 D The active cell must be in column A Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	37. When the formula bar is activated, you can see
	A The Edit Formula button B The Cancel button C The Enter button D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	38. In a worksheet you can select
	A The entire worksheet B Rows C Columns D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	39. You can group noncontiguous worksheets with
	A The group button on the standard toolbar B The shift key and the mouse C The ctrl key and mouse D The Alt + Enter key Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	40. Weight refers to
	A The print density of characters B The height of the printed character C Upright or slanted shape D The design and appearance of characters Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	41. When you link data maintained in Excel workbook to a Word document
	A The Word document cannot be edited B The Word document contains a reference to the original source application C The word document must contain a hyperlink D The word document contains a copy of the actual data Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	42. When you see a cell with a red triangle in the top right corner, what does this signify?
	A There is an error in the cell B There is a comment associated with the cell C The font color for text in the cell is red D A formula cannot be entered into the cell Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	43. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
	A Unfreeze panes command on the window menu B Freeze panes command on the window menu C Hold titles command on the edit menu D Split command on the window menu Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

44. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

A Use Ctrl to select all three cells, then click the paste button on the standard toolbar B Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify C Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to D All of above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	45. To edit data in an embedded Excel worksheet object in a Word document
	A Use the Excel menu bar and toolbars inside the word application B Edit the hyperlink C Edit the data in Excel source application D Use the Word menu bar and toolbars Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	46. Status indicators are located on the
	A Vertical scroll bar B Horizontal scroll bar C Formula bar D Formatting toolbar Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	47. You can open the scenario Manager Dialog box by choosing scenarios from the ___________ menu.
	A View B Insert C Format D Tools Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	48. You can open the Sort dialog box by choosing Sort from the ___________ menu
	A View B Format C Tools D Data Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	49. When working in the page break preview, you can
	A View exactly where each page break occurs B Add or remove page breaks C Change the print area D All of above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	50. A data map is helpful
	A When you have too much data to chart B To show a geographic distribution of data C To compare data points D To show changes in data over time Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

---