MS Excel 2010

MS Excel 2010 Expected Practical Questions

  1. In the  given spreadsheet file, open sheet “Chart 1” change the column chart to a “Doughnut” chart. Use the default chart and show Legend at top
  2. Calculate and display Quantity Available in column H , also calculate the total of Quantity in cell H14 by using function
  3. Open the file Result.xlsx from the folder C:\Support and set the spreadsheet to that it prints the first row of the worksheet as a heading at the top of each page.
  4. Using logical function , apply as “Good” for student having total marks less than 600 and “Very Good” for student having total marks greater than or equal to 600
  5. Open the file “Time Table.xlsx” from the folder “C:\Support” and change the heading “Time Table” to “Time Table Summer 2012” in the table
  6. Open the file Result.xlsx from folder “C:\Support” and insert hyperlink to the heading “Student Result” and link this to http://www.google.com web site
  7. Change the background of cell range B1:C1 to red color and also apply “Strikethrough” font effect
  8. Change the font size to the cell “D2” to 16 and its highlight color to “Blue” also use “format Painter” copy the format of cell “D2” to cell “F2”
  9. Insert 1 row before 9th row and change the height of it “40”
  10. Insert the text “Take a challenge” in cell B8 and to find the4 left of the 4 letters in the cell B5 and display the result in the cell C10 using function
  11. Insert column after column “B” and change the width of the column B to “50.57”
  12. Rename the Sheet from “Product Template” to “Hardware Template” and change the tab color to “Purple”
  13. Display the Right 2 letters in B8 by using a function give the result in K4
  14. Fill the range A1:A5 with Jan-81-May-81
  15. Insert he text “Challenge” in cell B5 and to find the position of the letter g in the cell B5 and display the result in the cell D5 using function
  16. Cut the content from the cell range C2:C8 and paste it on to cell range H2:H8
  17. Insert the values 50, 100, 65, 96 in cells G7 G8 G9 G10 respectively. Calculate the sum of the cell range G7 to G10 and display the result in cell G13 using function
  18. Insert a worksheet in given MS-Excel workbook & name it as “Stationary”
  19. Display the minimum price in C4:C6 by using function and give the result in K4
  20. Change the pattern of the cells C6:C13 as “Thin Vertical stripe”
  21. In the given spreadsheet file, change column “J” so that all the text advertising can be seen
  22. Inset the number 12 in cell A10 and the number 15 in cell A11 and display their product in cell A12 and sum in cell A13
  23. Auto fill numbers 1 to 100 in column A starting from A1 column wise
  24. Insert the values 80, 65, 11 in cell G7, G8, G9 respectively. Multiplies the numbers in cell G7:G9 and display it in the cell G13 using Function
  25. Fill the column with the number 5001 to 5030 starting from K1
  26. Insert the date “15-May 2012” in cell “G5” and to find the month of the serial number in the cell G5 and display the result in the cell D5 using Function
  27. Fill up the cell range A4:A121 by month names starting with “July”
  28. Use the “year” function in cell K6 to find the year in the cell “G5”
  29. Fill the range A1:A5 with Jan-81-May-81
  30. Repeat the text “ERA5” five times in cell H1 by using function
  31. Change format of “Discount” column to number format up to 2 decimal places
  32. Capitalize the first letter in each word in cell C3 by using function and give result E3
  33. Format the cells “B3:B12” to horizontal “Right” alignment and vertical “Center” Alignment
  34. Calculate the total marks for English subject of all students and display the result in cell E17 using a function
  35. Open the file “Fees.xlsx” and save as “PDF” format
  36. Find the average marks of the students having name “Aseem Khan” and show it in the cell K6 using function
  37. In the given spreadsheet file sort the data range “E4:E13” in descending order by the column name
  38. Using LEN function, count the characters in B10 and display the result in B15 cell
  39. Open the file “Result.xlsx” from the folder C:\Suppor and sort the column “Roll Number” in Ascending order
  40. Using UPPER function convert the characters in cell B9 and display the result in B15 cell
  41. Open the file “Fees.xlsx” from the folder c:\ Folder and change the header “Fee Details” to “Payment Details” in the center section of the header
  42. Using LOWER function convert the characters in B9 cell and display the result in B15 cell
  43. Format the cells values from cell C5:G5 and C10: G10 as text alignment horizontal center
  44. Calculate and display total price of each particular by using a formula in cell range “E3:E9” also display stock quantity in cell range “H3:H9”
  45. Insert the date “11 –August - 2006” in a MS-Excel sheet in cell C2 and format it to ’31 March,2001’ type
  46. Calculate the percentage of Pass student out of Appeared students for the “Mumbai” region and display the result In the cell E14
  47. Sort “Qty In Stock” column in ascending order And then by “Product Name” column in descending order
  48. Calculate the “Bill Amt.” of item purchased without discount, amount and Display the answer in G15
  49. Insert numbers 55.5, 75.5, 85.5, 10, 12 in cell A1 to A5, Sort numbers in Descending order. Put the same in to the cell starting from H1 to H5 in ascending order
  50. Calculate the bill amount with discount for “Keyboard-iball” and display result in cell H12
  51. In the given file, clear format of the heading “Student Result” and Hide the Sheet1.
  52. Open the file Fees.xlsx from the folder “C:\ Support” Using MOD function in conditional formatting display value in Red color within range “F3:F7”
  53. Auto fill the cell range  I3 to I12 by Even number starting with zero
  54. Using IF statement, apply discount of 2.50% for items having unit price less then Rs. 50/- and 5.00% for items unit price greater than Rs. 50/-
  55. From the given MS-Excel cells “C6 to F6” and “C15 to F15” values prepare a chart type column with sub type “100% stacked column in 3D”
  56. Display the book name ,Author & Quantity in stock in C16 , D16, E16 respectively whose Quantity in stock is minimum by using function
  57. In the given Spreadsheet file, open sheet “Chart1” and apply chart style as “Chart8”
  58. Display the book name ,Author & Quantity in stock in C16 , D16, E16 respectively whose Quantity in stock is maximum by using function
  59. Insert numbers 55.5, 75.5, 85.5, 10, 12 in cell A1 to A5, Sort numbers in Descending order. Put the same in to the cell starting from H1 to H5 in ascending order
  60. Open the file Result.xlsx from the folder C:\Suppoer using IF statement, apply remark as “True” for marks of “Advertising” subject of all students greater than “50” or less than or equal to “50” apply Remark as False
  61. From the given MS-Excel set the current worksheet to fit on 3 pages wide by 2 pages tall also change Top And Bottom margins” 2 inch”
  62. Use the max function in cell E15 to find the highest marks in the cell range E4:E14

No comments:

Post a Comment