Home MS Excel Test 3 Online Preparation MS Excel Test 3 Online Preparation MS Excel Test 3 Online Preparation With Answer Start Below 1234567891011121314151617181920Show paginator Hide paginatorComputer General 1. In Excel chart wizard term data series refers toA set of values you plot in a chartA chart legendA collection of chart data markersA data labelQuestion 1 of 20 Loading... 2. 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 2 of 20 Loading... 3. In Excel getting data from a cell located in a different sheet is calledUpdatingAccessingReferencingFunctioningQuestion 3 of 20 Loading... 4. In Excel which of the following is an absolute cell reference?$A$1A1#a#1!A!1Question 4 of 20 Loading... 5. In Excel which of the following formulas is not entered correctly?=B7*B1=B7+1410+50=10+50Question 5 of 20 Loading... 6. In Excel which symbol must all formula begin with?=(+@Question 6 of 20 Loading... 7. In Excel the following is not an example of a value57&per cent;May 10, 2001Serial Number 50771350Question 7 of 20 Loading... 8. In Excel what symbol is used before a number to make it a label?“ (quote)= (equal)‘ (apostrophe)_ (underscore)Question 8 of 20 Loading... 9. In Excel Chart wizard term data categories refers toThe organization of individual values with a chart’s data seriesThe data range that supply chart dataA chart plot areaA horizontal axisQuestion 9 of 20 Loading... 10. In Excel Tab scrolling buttonAllow you to view additional sheets tabsAllow you to view additional worksheet columns to the rightAllow you to view a different worksheetAllow you to view additional worksheet rows downQuestion 10 of 20 Loading... 11. In Excel numeric value can be treated as a label value if it precedes withHash (#)Exclamation (!)Apostrophe (‘)Ampersand (&)Question 11 of 20 Loading... 12. In Excel worksheet range is aA range of values such as from 23 to 234A group of worksheetsA command used for data modelingA group of cellsQuestion 12 of 20 Loading... 13. In Excel which of the following is not a worksheet design criterion?AditibilityEfficiencyDescriptionClarityQuestion 13 of 20 Loading... 14. In Excel to delete an embedded objects, firstDouble click the objectPress the Shift + Delete keysSelect the object by clicking itSelect it and then press the delete keyQuestion 14 of 20 Loading... 15. In Excel comments can be added to cells usingFile > CommentsInsert > CommentsView > CommentsEdit > CommentsQuestion 15 of 20 Loading... 16. In Excel worksheet can have a maximum of …. Number of rows32000655352561024Question 16 of 20 Loading... 17. In Excel typical worksheet has …. Number of columns2561024512128Question 17 of 20 Loading... 18. In Excel how many characters can be typed in a single cell?65535320001024256Question 18 of 20 Loading... 19. 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 final menu, click the sheet tab, and make a selection under the print heading.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 file menu, click the sheet tab, and enter the row that contains these column headings under print titles.Question 19 of 20 Loading... 20. In Excel a fast way to add up this column of number is to click in the cell below the numbers and thenClick subtotals on the data menuView the sum in the formula barAll of aboveClick the autosum button on the standard toolbar, then press enterQuestion 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