IMPORTANT QUESTIONS OVER MICROSOFT EXCEL PART-2

                    IMPORTANT QUESTIONS OVER MICROSOFT EXCEL PART-2

1. Which of the following is not an option in the spelling dialogue box?


a. Edit


b. Ignore


c. Ignore all


d. Change


Answer: a






2. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu


a. Edit


b. View


c. Format


d. Tools


Answer: c






3. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu


a. Edit


b. Format


c. Tools


d. Data


Answer: c






4. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.


a. Edit


b. Insert


c. Format


d. Tools


Answer: d






5. Which of the following is not a worksheet design criterion?


a. Efficiency


b. Auditability


c. Description


d. Clarity


Answer: c






6. To copy cell contents using drag and drop, press the


a. End key


b. Shift key


c. Esc key


d. None of above


Answer: d






7. If you press …., the cell accepts your typing as its contents.


a. Enter


b. Ctrl + Enter


c. TAB


d. Insert


Answer: a






8. The autofill 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


Answer: a






9. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?


a. F3


b. F5


c. F7


d. F11


Answer: D






10. you can use the formula palette to


a. format cells containing numbers


b. create and edit formulas containing functions


c. entered assumptions data


d. copy a range of cells


Answer: b


11. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed


a. Format Report


b. Pivot Table


c. Refresh Data


d. Show Detail


Answer: c






12. 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:


Answer: A






13. “Qtr 1, Qtr 2, Qtr 3” is an example of a


a. Formula


b. Function


c. Series


d. Syntax


Answer: c






14. You can edit existing Excel data by pressing the


a. F1 key


b. F2 key


c. F3 key


d. F4 key


Answer: b






15. 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


Answer: d






16. 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 – Save As Type – Excel worksheet


b. Right click on the spreadsheet tab and select DELETE


c. Right click on the spreadsheet and select Insert – Entire Column


d. None of above


Answer: b






17. 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


Answer: d






18. what term describes a background that appears as a grainy, non smooth surface


a. gradient


b. pattern


c. solid


d. texture


Answer: a






19. MS office’s Excel is a


a. Graphic program


b. None of these


c. Word processor


d. A spreadsheet


Answer: d






20. 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





Answer: d