Shyam Kumar started a thread in User Question Forum related to types of excel formula or in fact that was types of cell references. Because I feel I need to discuss it in more detail, I present the discussion here. Shyam pointed me to Operator Google book that classified the types of excel formula into [...]
Categorized as :
MS Excel
You must be busy with preparation of practical examination and some of my friends are really concerned now. I’m getting some good questions to solve in User Questions Forum. This post is in response to Shreeram’s question about Bill Calculation using MS Excel. The question also asks you to create a pie chart from two [...]
Categorized as :
MS Excel|
Practical Questions
I present the video demonstration of the solution of MS Excel question from Computer Operator Practical Exam Model Question Paper Set 02. Hope this will helpful for you to prepare practical examination. Please click on Videos link in menu at the top to find solution of other questions from model sets. The Excel question in [...]
Categorized as :
Computer Operator Exam Preparation|
Movies|
MS Excel
Here is another post to demonstrate how to solve the MS Excel question of Computer Operator Practical Examination Model Question Set 01. I hope this 17 minutes video demonstration will help you learn the correct method to solve the question and thus prepare practical exam better! The question carries 10 marks and contain 6 parts [...]
Categorized as :
Movies|
MS Excel|
Practical Questions
Following are the alphabetical list of shortcut keys used in MS Excel. It won’t be possible to remember all the key combination for every tasks, however, it is always useful to remember the shortcut keys used for most frequent tasks. The complete list is provided for the candidates for easy reference and verify. Task Keystroke Absolute/relative/mixed reference [...]
Categorized as :
MS Excel
Sometimes very simple looking problem can really tease you and make you realize what you’ve learned! Here is a simple problem Satish Jung sent me on Facebook page (http://facebook.com/ictTrends). There is a sheet given with arrival time, departure time. Now all you have to do is calculate how many hours each person worked and what [...]
Categorized as :
MS Excel
Madhab asked for the solution of a practical question from Excel via Facebook. This post is in response to his query. Create the following Table in Excel; RollNo Name Math English Science Total Result Division Note: Pass Marks Should be 50 and total, result should be computed using formula. Those who failed won’t have division [...]
Categorized as :
MS Excel|
Practical Questions
1. Worksheet size: 65,536 rows by 256 columns 2. Column width: 0 to 255 charcter 3. Row height: 0 to 409 points
Categorized as :
Computer Operator Exam Preparation|
MS Excel
This post is in response to the queries Khristine Acupido sent in email to shkhanal@gmail.com. I’ve tried to provide correct answers, please correct me if I am wrong anywhere: Questions: …can you answer this..please??? about Microsoft excel… Identify the word that makes the sentence complete and correct.
Categorized as :
MS Excel|
Questions and Answers
