Welcome to your MS-OFFICE-IV DATE:February 18, 2025 Name of Student 1.Conditional Formating is use for formationg of those cell/row/coumns that does not satisfy the certain condition True False None 2.In MS Excel how to insert a worksheet Home ---> insert --> Insert sheet Insert ---> insert --> Insert sheet View ---> insert --> Insert sheet Review ---> insert --> Insert sheet None 3.In MS Excel we can sort the Data into 4 different field True False None 4.In MS Excel we can sort the data on only one field True False None 5.Which is not a part of General option Currency Date and Time Percent None of above None 6.In Ms Excel _____________ number of chart it can support 10 11 12 13 None 7.which is of then are the chart type in MS Excel 2007 Line Column Bar All of above None 8.Which of them are the types of chart in MS Excel XY Scatter Doughtnut Radar All of above None 9.Which of them is not a type of chart Radar Bubble Network XY Scatter None 10.In Header and Footer of a Worksheet we can insert Date and Time Page No Sheet Name All of above None 11.In MS Excel Header and Footer we not Insert any of the following Option No of Pages WorkBook Name File path None of above None 12.Print Area is available in _________________- Ribbon of MS Excel 2007 Home Page Layout Insert View None 13.Break option of the page Layout Ribbon is __________ option Page Break Remove Page Break Both Above None of above None 14.Formula in Worksheet is started by __________ = # $ * None 15.Which of them is a type/ Group of Function Maths & Trig Statastics Logical All of Above None 91.Which of them is a type of Function category in Ms Excel Logical Text Date and Time All of Above None 17.Which of them is not a category of function Relational Financial Recently used Look up and Reference None 18.Define Name option is use to give the name to the range of cells in MS Excel Worksheet True False None 19.Which of is true about Name option in Ms Excel Define the name of range of cells used in the place of cell name of range Both above We can not edit the name from the range of cells None 20.There are _______________type of Sorting in MS Excel 2 3 4 1 None 21.Sorting Order Ascending sort the element from higher to lower True False None 22.Sorting Order Ascending arrange the element in Lower to Higher value True False None 23.Sroting Order Descending order arrange the element in lower number to heigher number True False None 24.Sorting order Descending arrange the element in higher to lower numbers True False None 25.Protect Worksheet will allow to make the changes in the content of the worksheet True False None
Add a Comment