Advanced Excel Problems
Q1. How can close all documents which are opened in a window from excel?
Q2. How can I make a pdf file using excel?
Q3. How can I make a CSV file that is supported in phone book memory or outlook express.
Q4. How can I make a txt file that is supported in phone?
Q5. How can Print selected rows or columns?
Q6. How can I extract the last saved date and file information?
Q7. How can I use excel template to create a report or other documents.
Q8. How can I enter one sheet and other sheets get the same data?
Q9. How can I enter data in one column and it will appear in other columns?
Q10. How can I enter one column in a sheet and it will automatically updated in another sheet.
Q11. How can I enter one column in a sheet and it will automatically updated in another sheet without using any formula.
Q12. How can I have a view of all four different folder files in a single window that I can edit at a time?
Q13. I want to keep the multiple data in a clipboard that whenever I need those data I can insert very quickly?
Q14. Everyday my job is to calculate some columns, so I want to copy the formulae only. How can I do that?
Q15. How can I copy only formats?
Q16. How can I copy a comment only from a cell?
Q17. How can I copy only the validations from a spread sheet?
Q18. How can I make the rows as columns and columns as rows in a spreadsheet?
Q19. How can I copy all except borders from a spread sheets?
Q20. How can I copy column widths from one sheets to another sheets?
Q21. How can I copy values and number formats to another sheets?
Q22. I want to increase 10% value without using third column as records, How can I do that?
Q23. I want to increase 10% value with using third column as backup records, How can I do that?
Q24. I want to decrease 10% value without using third column as records, How can I do that?
Q25. I want to decrease 10% value with using third column as backup records, How can I do that?
Q26. I want to add Rs100/- value without using third column as records, How can I do that?
Q27. I want to subtract Rs100/- value without using third column as records, How can I do that?
Q28. I want to multiply Rs100/- value without using third column as records, How can I do that?
Q29. I want to divide Rs100/- value without using third column as records, How can I do that?
Q30. I want to copy only values except any blank data, How can I do that?
Q31. I want fill some cells with same values, How can I do that?
Q32. I want to fill some cells as 1,2,3……. How can I do that?
Q33. I want to fill some cells as 1,3,5,7…… How can I do that?
Q34. I want to fill some cells as 2,4,6,8….. How can I do that?
Q35. I want to make a table for a number. How can I do that?
Q36. I want to increase the date from a date to another date. How can I do that?
Q37. I want to increase the year from a date to another date. How can I do that?
Q38. I want to increase the month from a date to another date. How can I do that?
Q39. I want to select a range from keyboard. How can I do that?
Q40. I want to select a range of data from first to last by keyboard. How can I do that?
Q41. I want to select all data from first to last by keyboard. How can I do that?
Q42. I want to select only the empty cells. How can I do that?
Q43. I want to delete only the empty cells. How can I do that?
Q44. I want to delete only the empty rows. How can I do that?
Q45. I want to delete only the empty columns. How can I do that?
Q46. I want to select only the cells containing formula . How can I do that?
Q47. I want to select only the cells containing comments. How can I do that?
Q48. I don’t want to allow to change data in my selected area. How can I do that?
Q49. I don’t want to allow to change data by password in my selected area. How can I do that?
Q50. I don’t want to allow to change formula only in my selected area. How can I do that?
Q51. I don’t want to allow to change all data in my selected area. How can I do that?
Q52. How Can I lock down the empty cells only in excel?
Q53. I don’t want to allow to modify the file/data in excel. How can I do that?
Q54. I don’t want to allow to open data in excel. How can I do that?
Q55. When ever I tried to write something always there is percentage sign automatically applied. I want to get rid of this types of problems?
Q56. I want to delete the comments only at a time. How can I do that?
Q57. I want to delete the data but the colors and formats which I applied must not be altered. How can I do that?
Q58. I want to delete a whole column or cell or row. How can I do that?
Q59. I need to transfer/copy the sheet from one file to another file. How can I do that?
Q60. Without a print preview I want to show the printable area and pages acquired by the document. How can I do that?
Q61. Each day I need to write same text on every page. I want to do this automatically by excel. How can I do that?
Q62. I need to select multiple row and columns in different sheets and remember them. Is there any way to get the list of selected data and transfer to the next sheet?
Q63. I need to add a new cell or shifting a data cell to next cell. How can I do that?
Q64. I need to insert multiple rows. How can I do that?
Q65. I need to insert multiple columns. How can I do that?
Q66. I need to insert a datasheet. How can I do that?
Q67. I want to rearrange my datasheets. How can I do that?
Q68. Create a line chart for company progress report.
Q69. Create pie chart for company share percentage.
Q70. Create a line chart for comparing the progress of two companies.
Q71. I want to extract the day form date value in excel how can I do that?
Q72. I want to extract the exact month from a date of birth. How can do that?
Q73. I want to extract the year from an establishment date. How can I do that?
Q74. How can I subtract two dates as current exact age in excel?
Q75. I want to change my date into Microsoft Number format that could not be read by directly. How can I do that?
Q76. I want to add some days from today to make a new date.
Q77. I want to add some month to a day, How can I do that.
Q78. I want to know last data of a month. How can I do that ?
Q79. I want to increase only year. How can I do that.
Q80. I want to calculate the days between two dates. How can I do that?
Q81. I want to get the exact working dates between two dates which are excluding Sundays and Saturdays. How can I do that?
Q82. Whenever I calculate the exact working days excluding Sundays and Saturdays I also want to keep in mind about the holidays but if a holiday held on Sunday and Saturday then it should not be counted. How can I do that?
Q83. How can I get the current date and time on Excel Worksheet?
Q84. How can I get the current date only on Excel Worksheet?
Q85. Is there any way to get the day name by a date entered in Excel Worksheet?
Q86. I want to add few days to date excluding Sundays and Saturdays. How excel will help us?
Q87. I have three columns as day month and year. I want to make a date value, how can I do that?
Q88. I have three columns as hours minutes and second. I want to make a time value, how can I do that?
Q89. Make a sheet whenever I enter a date in a column, the day, month and year should be divided to three columns separately.
Q90. Make a sheet whenever I enter a time in a column, the hour, minute and second should be divided to three columns separately.
Q91. Make a result sheet using if statement to get the divisions.
Q92. I want to remove all minus sign for a minus value digit. How can I do it in excel?
Q93. How can I round up a number which must be perfect divisible by a number?
Q94. I need to express a value of a angle in degrees. How can I do this?
Q95. How can I express a degree of value in numbers in excel?
Q96. How to round up a number to the nearest even number in excel?
Q97. How can I calculate a factorial value of a number in excel?
Q98. How can I round down a number which must be perfect divisible by a number?
Q99. How to get greatest common divisor in excel. How can I do it?
Q100. How can I trim any decimal part of a real number in excel by formula. How can I do that?
Q101. How to get Least Common Divisor in excel. How can I do it?
Q102. How can I get the reminder of a division?
Q103. How can I get a year is Leap Year or not?
Q104. How to know a number is odd or even?
Q105. How can I get the nearest odd number to an integer Number?
Q106. How can I get value of a pi in excel function.
Q107. How can I calculate power to any number?
Q108. Calculate the estimated population of an area if current population is 1000 growth rate is 1.5% and Time is 3 years.
Q109. I want to multiply a range in excel. How can I do that?
Q110. I want to get the value of cos 60 degree in excel how can I do this?
Q111. I want to generate different number each time for a game in excel. how can I do this?
Q112. Is there any way to generate any unknown number in a range in excel? Show an example.
Q113. How can I write roman numbers instead for general numbers in excel.
Q114. How can I round a number to specified number of digits?
Q115. How can I round down a number towards – zero.
Q116. How can I round a up a number away form zero.
Q117. How can I get the value of sin 45 degree in excel?
Q118. How can I get the square root value of a given number in excel?
Q119. How can I add all numbers in a series in excel?
Q120. How can I add the numbers based on a condition in excel?
Q121. How can I add the numbers based on multiple conditions?
Q122. How can I add the multiplication of some numbers in excel?
Q123. How can I add the square of some numbers in excel?
Q124. How can I calculate the value of TAN 45 degree in excel?
Q125. How can I get rid of extra decimal numbers in a real number?
Q126. How can I get the character from a number which is based on ASCII chart?
Q127. How can I get the number from a character which is based on ASCII chart?
Q128. How can I remove the non printable characters from a text value in excel?
Q129. How can I join two texts from the different columns to a single column in excel?
Q130. How can I change the currency symbol using excel function?
Q131. How can I match two columns in excel to know if they are same or different.
Q132. How can I get the position of an alphabet in a word from a certain starting position?
Q133. How can I activate comma features in a number using excel function in excel?
Q134. How can I get the specific number of characters from a word in excel?
Q135. How can I get the exact number of characters in excel function.
Q136. I need to make a sheet where each alphabet with spaces will be charged @ Rs.2. How can I do that?
Q137. How can I convert the alphabets in small case by a function in excel?
Q138. How can I convert the alphabets in Upper case by a function in excel?
Q139. How can I convert the alphabets in proper case by a function in excel?
Q140. How can I get specific numbers of characters in a sentence based on starting position and length?
Q141. How can I replace some alphabets in a sentence with some new words in excel functions?
Q142. How can I repeat a word several time in excel?
Q143. How can I get the specific numbers of alphabet form a word in excel?
Q144. How can I get the number position of an alphabet in a sentence in excel?
Q145. How can I check a text is text or any thing else in excel?
Q146. How can I convert a text to a number in excel?
Q147. How can I calculate the grades for a student based on conditions?
Q148. Make a sheet where form amount will be automatically updated based on category as sc, st, obc and general.
Q149. Make a sheet where after 10th day of each month any submission of subscription will be charged Re1 for each day delay.
Q150. Make a sheet where after 10th day of each month any submission of subscription will be charged Re1 for each day delay and Rs 5 will be charged after 20th day the same month.
Q151. Make a sheet where after 10th day of each month any submission of subscription will be charged Re1 for each day delay and Rs 5 will be charged after 20th day the same month and registration will be cancelled after 30th day of the same month.
Q151. Make a salary sheet based on designation for a company.
Q152. How can I use two conditions and if the two conditions matches then I get a positive result.
Q153. How can I use two conditions and if any of the two conditions matches then I get a positive result.
Q154. How can I use true or false using a function?
Q155. How can I Search a value using Vlookup and HLookup?
Q.155. Create a function to calculate the simple interest in excel.
Q156. Create a function to calculate the area of a rectangle.
Q157. Create a function to calculate the perimeter of a rectangle.
Q158. Create a function to calculate the area of a circle.
Q159. Create a function to calculate the circumference of the circle.
Q160. Create a function to converse the temperature for Fahrenheit to Celsius.
Q161. How can I write a comment in function that I can remember the purpose of the function.
Q162. I can copy – paste the value in excel but I need a facility where after reboot or shutdown I will get the same facility in excel. How can I do that?
Q163. Is there any system that I can use other program within excel?
Q164. Is there any way to make list of excel files within excel that whenever I click on any file name it will open here.
Q165. Is there any to make a song list in excel that any one can be played from here.
Q166. Is there any way that I can make a website list and it will be connected automatically on click.
Q.167. whenever I write something in the cells it always appear in bottom. Is there any way that I can write this in middle of the cell?
Q168. I want to write the data vertically or by an angle in excel. Please show me an example.
Q169. When I write any long word it always overlap the cell. Is there any way that it will go to next line in a cell?
Q170. How can I make some sub column in excel?
Q171. How can make a system without changing the cell width fit the text within a cell in excel?
Q172. Is there anyway that whenever I design any bill I need to use different types of borders. How can I manage this in ms excel?
Q173. How can I use different types of colors with different types of gradients and patterns to show the data with attractive colors I Excel?
Q174. I want to adjust the row height according to the words and spaces I used. How can I do that?
Q175. I want to adjust the column width according to the words and spaces I used. How can I do that?
Q176. I want to set the same width for all columns. How can I do that?
Q177. How can I hide a column, row or entire sheet in excel?
Q178. Is there any way that I can give name on the sheets in excel. Please show me an example.
Q179. Is there any way that I can recognize the sheets by color without opening it in excel?
Q180. Is there any way that I can compare some data by colors in excel?
Q181. Is there any way to highlight the data based on greater than condition?
Q182. Is there any way to highlight the data based on less than condition?
Q183. Is there any way to highlight the data based on between condition?
Q184. Is there any way to highlight the data based on equal to condition?
Q185. Is there any way to highlight the data based on text that contains condition?
Q186. Is there any way to highlight the data based on a date occuring condition?
Q187. Is there any way to highlight the data based on duplicate value condition?
Q188. Is there any way to highlight the data based on top 10 items condition?
Q189. Is there any way to highlight the data based on top 10% condition?
Q190. Is there any way to highlight the data based on bottom 10 items condition?
Q191. Is there any way to highlight the data based on bottom 10% condition?
Q192. Is there any way to highlight the data based on above average condition?
Q193. Is there any way to highlight the data based on below average condition?
Q194. Is there any way to highlight the data based on Data Bars condition?
Q195. Is there any way to highlight the data based on Color schema condition?
Q196. Is there any way to highlight the data based on icon sets condition?
Q197. Is there any way to set the new rule to highlight the data based on their value?
Q199. Is there any way to set the new rule to highlight the data by formula on a formula column?
Q200. I have applied lots of rules on my excel sheet now I want to get rid from this mess. How can do that?
Q201. I have a problem that every time whenever I write something I am afraid that there is some mistake in my spelling. How can I check my spelling by Excel?
Q202. How can I know the meaning of a word by excel option?
Q203. Everyday I need to share my workbook to other employees of this company. My problem is that if somebody changes my data I cannot get back the previous data. Is there any way to keep the old data and new data also and can be easily recognized the changed cell?
Q204. Every time need to adjust the marks as grace number. Is there any way in excel to adjust quickly?
Q205. I want to insert multiple values within single cell. Is there any way in excel?
Q206. I have different scenarios on different pages. How can I bring them to my current worksheet?
Q207. I have to demonstrate on projectors. When I demonstrate I have to discuss the formula and the responsible cells. Please help to show the used cells with formula easily.
Q208. I need to color some cells even in different files for each day. Is there any shortcut process to do that.
Q209. How can I differ the data based on caste in an excel sheet?
Q210. My work is to check the spelling of the names entered by the customers. But the write different spellings for the same name. How can I get them serially ?
Q211. How can I extract the data or records based on certain criteria provided by an user?
Q212. How can I extract the data or records based on certain condition provided by an user?
Q213. Is there any way to make a new table from a table based on condition in excel?
Q214. I want to use automatic calculation without dragging any cell in excel. Please help me.
Q215. Is there any way to add group wise sales amount based on branches in excel.
Q216. I want to know the total numbers of the people who are living in each address.
Q217. I want to get the average of sales amount for each branch. How can I do that?
Q218. I want to find duplicate values without using conditional formatting. How can I do that?
Q219. I want to multiply the quantity of a product based on product group. How can I do that?
Q220. I do not want allow to enter the age below 18 in my excel sheet. How can I do that?
Q221. On the columns I do not want allow to put the data from my list only. Is there any way?
Q222. On the columns I do not want allow to put the data above a date. Is there any way?
Q223. On the columns I do not want allow to put the data below a date. Is there any way?
Q224. On the columns I do not want allow to put the data within a range of date. Is there any way?
Q225. On the columns I do not want allow to put the data within a range of time. Is there any way?
Q226. On the columns I do not want allow to put the data within a range character. Is there any way?
Q227. I want to customize the message in validation. Is there any way?
Q228. How can I make a table of numbers which can be read by the both direction.
Q229. How can I make a table with VAT for different for different states?
Q230. How can I use different percentage for simple interest with table?
Q231. Is there any way to make a date from arranged numbers?
Q232. I want to distribute all data from a cell to different columns. How can I do that?
Q233. I want to make a group of data for some purpose. Is there any help in excel?
Q234. How can I make a group of rows in excel?
Q235. There are lots of groups in a Excel sheets. How can I ungroup selected groups?
Q236. I want to discard all groups at once. How can do that?
Q237. How can I Use Pivot Table to represent the data?
Q238. How can I use Consolidate in excel?
Q239. How can I use Solver in Excel?
Q240. Is there any way to calculate the estimated price for proposed quantity for a product by solver?
Q241. I want to fix a row that even in scrolling that will be remain in same position. How can I do that?
Q242. Make a money receipt for a computer center and it will have two copies as “Office Copy” and “Student’s Copy”. If office copy edited the student’s copy will be updated automatically.
Q243. Make a system for Calculating Electricity Bill.
Q244. Make a system for calculating for a phone bill.
Q245. Make a system for a restaurant billing system.
Q246. Make a system for a currier service delivery system.
Q247. Make a system for an LIC agent to hold the money data for policy holders.
Q248. Make a system to calculate recurring amount with a certain percentage for a period.
Q249. Make a system for a TA bill.
Q250. Make a system for a students attendance in a school.
Q251. Make a system for a employee attendance system in a company.
Q252. Make a system for a Staff Leave planner system.
Q253. Make a system for Training Budget calculator for an institute.
Q254. Make a system for a Municipality Tax calculation.
Q255. Make a system for a Selling Flat and housing complex for a construction company.
Q256. Make a system for a Event Management system with visual representation charts.
Q257. Make a system for a Petrol Pump to calculate the date day wise.
Q258. Make a system for a Government Plan for to Distribute Tube Well Projects on different blocks.
Q259. Make a system for a visual representation on different sales zones.
Q260. Make a system for a visual representation on coal fields for country.
Q261. Make a system for a visual representation on Caste in an area.
Q262. Make a system for a visual representation on Rainfall in a state.
Q264. Make a system for a Mobile Repairing Service Center.
Q265. Make a system for a Mother Board Repairing Service Center.
Q266. Make a system for a Complain Log Book for a Service Center.
Q267. Make a system for a Hospital Management System.
Q268. Make a system for a book shop.
Q269. Make a system for a Travel Agency and their schedule.
Q270. Make a system for a Hospital Out Door Patient Data sheet System.
Q271. Make a system for to show the Price Value comparison chart for current processors.
Q272. Make a system for a to show employee strength and performance status
Q273. Make a system for a enrolment of Name, Age, Sex and Caste.
Q274. Make a system for a Criminal Case and progress report.
Q275. Make a system for a House hold budget planners.
Q276. Make a system for a Rejection of some product.
Q277. Make a system for a question and answer system to review.
Q278. Make a system for a project proposal.
Q279. Make a system for a Commission Payment on Selling Properties.
Q280. Make a system for a Commission Payment for Medicine.
Q281. Make a system for a action report details.
Q282. Make a system for a Blood samples test report.
Q283. Make a system for a eligibility criteria report for admission.
Q284. Make a system for maintaining go down and stocks.
Q285. Make a system for a TRP report for a TV channels.
No comments:
Post a Comment