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