MS Excel Test 2 Online Preparation MS Excel Test 2 Online Preparation With Answer Start Below 1234567891011121314151617181920Show paginator Hide paginatorComputer General 1. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.ToolsInsertFormatEditQuestion 1 of 20 Loading... 2. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menuFormatDataEditToolsQuestion 2 of 20 Loading... 3. In Excel Documentation should includeDestination and users of the output dataSource of input dataAll of the aboveInformation on the purpose of the workbookQuestion 3 of 20 Loading... 4. In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?Category axisGridlineData markerData pointQuestion 4 of 20 Loading... 5. In Excel to copy cell contents using drag and drop, press theEnd keyShift keyEsc keyNone of aboveQuestion 5 of 20 Loading... 6. In Excel which elements of worksheet can be protected from accidental modification ?ScenariosAll of aboveContentsObjectsQuestion 6 of 20 Loading... 7. In Excel you can use the drag and drop method toCopy cell contentsAdd cell contents(A) and (B)Move cell contentsQuestion 7 of 20 Loading... 8. In Excel value used in a formula that does not change is called aRangeConstantFunctionCell addressQuestion 8 of 20 Loading... 9. In Excel the auto fill featureAutomatically adds a range of cell valuesNone of aboveExtends a sequential series of dataApplies a boarder around selected cellsQuestion 9 of 20 Loading... 10. In Excel if you press …….., the cell accepts your typing as its contents.InsertCtrl + EnterEnterTABQuestion 10 of 20 Loading... 11. Right clicking something in ExcelSelects the objectDeletes the objectNothing the right mouse button is there for left handed peopleOpens a shortcut menu listing everything you can do to the objectQuestion 11 of 20 Loading... 12. Files created with Lotus 1-2-3 have an extensionXLSDOC123WK1Question 12 of 20 Loading... 13. In Excel the auto calculate featureAutomatically creates formulas and adds them to a worksheetCan only add values in a range of cellsProvides a quick way to view the results of an arithmetic operation on a range of cellsNone of the aboveQuestion 13 of 20 Loading... 14. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cellsF11F5F3F7Question 14 of 20 Loading... 15. In Excel which of the following is not a worksheet design criterionAuditabilityClarity Correct Answer:DescriptionEfficiencyQuestion 15 of 20 Loading... 16. In Excel you can use the formula palette toCopy a range of cellsCreate and edit formulas containing functionsEntered assumptions dataFormat cells containing numbersQuestion 16 of 20 Loading... 17. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet whenNo data will be entered in the adjacent cellsThere is not time to format the nextThere is nt suitable abbreviation of the textData will be entered in the adjacent cellsQuestion 17 of 20 Loading... 18. In Excel how can you delete a record?Select Data > Delete Record from the menuSelect Data > Form from the menu to open the Data dialog box, find record and Click the Delete buttonDelete the column from the worksheetClick the Delete button on the Standard toolbarQuestion 18 of 20 Loading... 19. In Excel 3-D reference in a formulaCannot be modifiedOnly appears on summary worksheetsLimits the formatting optionsSpans worksheetsQuestion 19 of 20 Loading... 20. What excel feature can you use if you want to work with one record at a time?Sub TotalsAuto CompleteAuto FilterData FormQuestion 20 of 20 Loading... Loading... Related Study Posts:Excel Labs Medical Report Result OnlineMDCAT Test English Test Online PreparationMDCAT Test Physics Test Online PreparationMDCAT Test Biology Test Online PreparationMDCAT Test Chemistry Test Online PreparationMath Test Preparation OnlineASF Written Test Preparation Online McqsPAF Test Preparation Books Download Online PdfOnline ECAT Test Preparation McqsFPSC SST Test Preparation Mcqs Online