MS Excel Test 3 Online Preparation MS Excel Test 3 Online Preparation With Answer Start Below 1234567891011121314151617181920Show paginator Hide paginatorComputer General 1. In Excel worksheet range is aA command used for data modelingA group of cellsA group of worksheetsA range of values such as from 23 to 234Question 1 of 20 Loading... 2. 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 enterClick subtotals on the data menuAll of aboveQuestion 2 of 20 Loading... 3. In Excel the following is not an example of a value350May 10, 200157&per cent;Serial Number 50771Question 3 of 20 Loading... 4. In Excel comments can be added to cells usingFile > CommentsView > CommentsInsert > CommentsEdit > CommentsQuestion 4 of 20 Loading... 5. 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.Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.Click page setup on the final menu, click the sheet tab, and make a selection under the print heading.All of aboveQuestion 5 of 20 Loading... 6. In Excel worksheet can have a maximum of …. Number of rows32000655352561024Question 6 of 20 Loading... 7. In Excel which of the following is not a worksheet design criterion?DescriptionAditibilityEfficiencyClarityQuestion 7 of 20 Loading... 8. In Excel how many characters can be typed in a single cell?65535102432000256Question 8 of 20 Loading... 9. In Excel getting data from a cell located in a different sheet is calledFunctioningReferencingAccessingUpdatingQuestion 9 of 20 Loading... 10. In Excel which of the following formulas is not entered correctly?=B7*B1=10+50=B7+1410+50Question 10 of 20 Loading... 11. In Excel what symbol is used before a number to make it a label?“ (quote)= (equal)‘ (apostrophe)_ (underscore)Question 11 of 20 Loading... 12. In Excel to delete an embedded objects, firstDouble click the objectSelect it and then press the delete keyPress the Shift + Delete keysSelect the object by clicking itQuestion 12 of 20 Loading... 13. In Excel which of the following is an absolute cell reference?!A!1#a#1$A$1A1Question 13 of 20 Loading... 14. In Excel typical worksheet has …. Number of columns2565121024128Question 14 of 20 Loading... 15. In Excel Tab scrolling buttonAllow you to view additional worksheet rows downAllow you to view additional worksheet columns to the rightAllow you to view a different worksheetAllow you to view additional sheets tabsQuestion 15 of 20 Loading... 16. In Excel numeric value can be treated as a label value if it precedes withApostrophe (‘)Ampersand (&)Hash (#)Exclamation (!)Question 16 of 20 Loading... 17. In Excel chart wizard term data series refers toA set of values you plot in a chartA chart legendA data labelA collection of chart data markersQuestion 17 of 20 Loading... 18. In Excel which of the following formulas will Excel not be able to calculate?=SUM(A1:A5)/(10-10)=SUM(Sales)-A3=SUM(A1:A5)*.5=SUM(A1:A5)-10Question 18 of 20 Loading... 19. In Excel which symbol must all formula begin with?=@+(Question 19 of 20 Loading... 20. In Excel Chart wizard term data categories refers toThe data range that supply chart dataA horizontal axisThe organization of individual values with a chart’s data seriesA chart plot areaQuestion 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 PdfFPSC SST Test Preparation Mcqs OnlineOnline ECAT Test Preparation Mcqs