Home MS Excel Test 2 Online Preparation MS Excel Test 2 Online Preparation MS Excel Test 2 Online Preparation With Answer Start Below 1234567891011121314151617181920Show paginator Hide paginatorComputer General 1. Files created with Lotus 1-2-3 have an extensionDOCXLS123WK1Question 1 of 20 Loading... 2. In Excel the auto calculate featureNone of the aboveProvides a quick way to view the results of an arithmetic operation on a range of cellsAutomatically creates formulas and adds them to a worksheetCan only add values in a range of cellsQuestion 2 of 20 Loading... 3. In Excel you can use the formula palette toEntered assumptions dataCreate and edit formulas containing functionsCopy a range of cellsFormat cells containing numbersQuestion 3 of 20 Loading... 4. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet whenThere is nt suitable abbreviation of the textData will be entered in the adjacent cellsNo data will be entered in the adjacent cellsThere is not time to format the nextQuestion 4 of 20 Loading... 5. In Excel which of the following is not a worksheet design criterionClarity Correct Answer:DescriptionEfficiencyAuditabilityQuestion 5 of 20 Loading... 6. In Excel to copy cell contents using drag and drop, press theNone of aboveShift keyEsc keyEnd keyQuestion 6 of 20 Loading... 7. What excel feature can you use if you want to work with one record at a time?Auto CompleteData FormSub TotalsAuto FilterQuestion 7 of 20 Loading... 8. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.ToolsFormatInsertEditQuestion 8 of 20 Loading... 9. In Excel you can use the drag and drop method to(A) and (B)Copy cell contentsMove cell contentsAdd cell contentsQuestion 9 of 20 Loading... 10. In Excel the auto fill featureAutomatically adds a range of cell valuesApplies a boarder around selected cellsNone of aboveExtends a sequential series of dataQuestion 10 of 20 Loading... 11. 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?Data markerCategory axisData pointGridlineQuestion 11 of 20 Loading... 12. In Excel if you press …….., the cell accepts your typing as its contents.Ctrl + EnterEnterInsertTABQuestion 12 of 20 Loading... 13. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menuEditFormatDataToolsQuestion 13 of 20 Loading... 14. In Excel Documentation should includeSource of input dataInformation on the purpose of the workbookDestination and users of the output dataAll of the aboveQuestion 14 of 20 Loading... 15. In Excel 3-D reference in a formulaCannot be modifiedLimits the formatting optionsSpans worksheetsOnly appears on summary worksheetsQuestion 15 of 20 Loading... 16. 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 buttonClick the Delete button on the Standard toolbarDelete the column from the worksheetQuestion 16 of 20 Loading... 17. Right clicking something in ExcelNothing the right mouse button is there for left handed peopleDeletes the objectSelects the objectOpens a shortcut menu listing everything you can do to the objectQuestion 17 of 20 Loading... 18. In Excel which elements of worksheet can be protected from accidental modification ?All of aboveContentsObjectsScenariosQuestion 18 of 20 Loading... 19. In Excel value used in a formula that does not change is called aRangeConstantFunctionCell addressQuestion 19 of 20 Loading... 20. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cellsF3F7F11F5Question 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