MS Excel Test 3 Online Preparation MS Excel Test 3 Online Preparation With Answer Start Below 1234567891011121314151617181920Show paginator Hide paginatorComputer General 1. In Excel which of the following formulas is not entered correctly?=10+50=B7+14=B7*B110+50Question 1 of 20 Loading... 2. In Excel getting data from a cell located in a different sheet is calledReferencingUpdatingAccessingFunctioningQuestion 2 of 20 Loading... 3. In Excel what symbol is used before a number to make it a label?“ (quote)_ (underscore)= (equal)‘ (apostrophe)Question 3 of 20 Loading... 4. In Excel which of the following is not a worksheet design criterion?AditibilityClarityDescriptionEfficiencyQuestion 4 of 20 Loading... 5. In Excel to delete an embedded objects, firstSelect it and then press the delete keyDouble click the objectSelect the object by clicking itPress the Shift + Delete keysQuestion 5 of 20 Loading... 6. In Excel chart wizard term data series refers toA collection of chart data markersA data labelA chart legendA set of values you plot in a chartQuestion 6 of 20 Loading... 7. In Excel Chart wizard term data categories refers toA horizontal axisThe organization of individual values with a chart’s data seriesThe data range that supply chart dataA chart plot areaQuestion 7 of 20 Loading... 8. In Excel worksheet can have a maximum of …. Number of rows10243200025665535Question 8 of 20 Loading... 9. In Excel a fast way to add up this column of number is to click in the cell below the numbers and thenView the sum in the formula barClick the autosum button on the standard toolbar, then press enterAll of aboveClick subtotals on the data menuQuestion 9 of 20 Loading... 10. In Excel numeric value can be treated as a label value if it precedes withAmpersand (&)Exclamation (!)Apostrophe (‘)Hash (#)Question 10 of 20 Loading... 11. In Excel worksheet range is aA command used for data modelingA group of worksheetsA range of values such as from 23 to 234A group of cellsQuestion 11 of 20 Loading... 12. In Excel which of the following formulas will Excel not be able to calculate?=SUM(Sales)-A3=SUM(A1:A5)/(10-10)=SUM(A1:A5)-10=SUM(A1:A5)*.5Question 12 of 20 Loading... 13. In Excel the following is not an example of a valueMay 10, 200157&per cent;350Serial Number 50771Question 13 of 20 Loading... 14. In Excel which of the following is an absolute cell reference?#a#1$A$1!A!1A1Question 14 of 20 Loading... 15. In Excel typical worksheet has …. Number of columns2561281024512Question 15 of 20 Loading... 16. In Excel how many characters can be typed in a single cell?10243200025665535Question 16 of 20 Loading... 17. In Excel which symbol must all formula begin with?=+@(Question 17 of 20 Loading... 18. In Excel comments can be added to cells usingEdit > CommentsInsert > CommentsView > CommentsFile > CommentsQuestion 18 of 20 Loading... 19. In Excel Tab scrolling buttonAllow you to view additional sheets tabsAllow you to view additional worksheet rows downAllow you to view additional worksheet columns to the rightAllow you to view a different worksheetQuestion 19 of 20 Loading... 20. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?Click page setup on the file menu, click the page tab, click the options button, then enter your choices.All of aboveClick page setup on the final menu, click the sheet tab, and make a selection under the print heading.Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.Question 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