Loading…
Free Content10 MCQs
Imagine you have lots of toys and want to put them in different boxes to find them easily. MS Excel is like a super smart digital box (spreadsheet) where you can arrange all your numbers and words very neatly! It helps you count, add, and even draw pictures (charts) from your data. This makes working with lots of information super simple and fast, which is very helpful in many jobs.
When you need to add numbers quickly, instead of typing =SUM(), just select the cells you want to add. Then, press Alt + = on your keyboard. Excel will magically put the SUM formula in the next empty cell below or to the right!
Have a long list of names and want to copy a formula (like calculating grades) all the way down? Instead of dragging the fill handle (the small square) manually, just double-click on it! Excel will fill the formula down until it finds an empty row next to your data.
If you have names like 'Rahul Sharma' in one column and want to quickly get only 'Rahul' (first name) in another column, start typing the first name for the first entry. Then, press Ctrl + E. Excel will automatically fill the pattern for the rest of your list!
If you have a simple list of data, you can make it look professional and add cool features like sorting and filtering with just one click! Select any cell in your data and press Ctrl + T. Excel will turn your data into a proper table.
Sometimes you want to see all the formulas in your worksheet, not just the answers. This is super helpful for checking your work! Just press Ctrl + ~ (the tilde key, usually above Tab). All cells will show their formulas instead of their results.
Imagine a giant notebook where each page has many small boxes. That's a bit like MS Excel! It's a special computer program used to keep track of numbers and words. We call these pages worksheets, and the whole notebook is called a workbook. Each small box is called a cell, and you can put one piece of information in each cell.
Think of it like this: if you want to make a list of your monthly expenses, like how much you spend on food, clothes, and toys, Excel is perfect for it! You can write 'Food' in one cell, '500' in another, and then ask Excel to add everything up for you.
Every worksheet in Excel is made up of many cells arranged in rows and columns:
This is where Excel gets its superpower! You can make Excel do math for you using formulas. A formula always starts with an equals sign (=). For example, to add numbers in cells A1 and B1, you can type =A1+B1 in another cell. Excel will show you the answer!
There are also many ready-made formulas called functions. These are like magic words that tell Excel to do complex tasks quickly. Some common functions are:
=SUM(A1:A5) adds all numbers from A1 to A5.These functions save a lot of time and help avoid mistakes. You just tell Excel which cells to look at, and it does the hard work!
Excel is not just for numbers. You can also:
Learning MS Excel helps you manage any kind of list or numbers, whether it's your daily pocket money, exam scores, or even your favorite cricket team's performance. It's a skill that makes life easier and helps you get jobs too!
SUM Function
=SUM(range)AVERAGE Function
=AVERAGE(range)MAX Function
=MAX(range)MIN Function
=MIN(range)COUNT Function
=COUNT(range)| Feature | Description | Example Use |
|---|---|---|
| Cell | A single box to store data. | Entering 'Apple' in A1 |
| Row | A horizontal line of cells. | Row 5 has data for all fruits |
| Column | A vertical line of cells. | Column B lists all quantities |
| Worksheet | A single page of cells, rows, and columns. | Sheet1 for monthly expenses |
| Workbook | A collection of one or more worksheets. | My Budget.xlsx file with multiple sheets |
Q: You have a list of daily sales: Monday 100, Tuesday 150, Wednesday 75, Thursday 200, Friday 125. How would you find the total sales for the week using Excel?
Q: A teacher wants to find the average score of 5 students: 85, 92, 78, 65, 95. How can Excel help?
Q: You have a list of product prices: ₹120, ₹80, ₹250, ₹50, ₹180. You want to quickly find the most expensive item. How to do it in Excel?
Q: You need to count how many types of fruits you have in a list: Apple, Banana, Orange, Mango, (empty cell), Grape. How many numerical entries (fruits here are not numbers, so how to count actual numbers if they were there) are there in cells D1 to D6? (Assuming we use COUNT for numbers).
You want to track how much money you spend on snacks each week. You list Monday's snack cost as ₹30, Tuesday's as ₹25, and Wednesday's as ₹40. How can Excel tell you your total snack cost for these three days?
Your favorite cricket player scored 55, 102, 30, and 73 in four matches. You want to know his highest score in these matches. How will Excel help you find it fast?
Your class had a math test, and five friends scored 75, 80, 65, 90, and 70. Your teacher wants to know the average score of these friends. What Excel function is perfect for this?
You received gifts for your birthday. Some were toys, some books, and some clothes. You want to count how many gifts were 'toys'. If you list all gifts in a column, how can Excel help you count specific items?
Which of the following is NOT a valid cell address in MS Excel?
If you want to quickly copy a formula from cell C1 to cells C2, C3, and C4, what is the fastest way?
Which symbol must a formula always begin with in Excel?
You have numbers 10, 20, 30 in cells A1, A2, A3. What will be the result of =AVERAGE(A1:A3)?
1Which of the following is an electronic spreadsheet program?
2In Excel, a rectangular grid of cells is known as a:
3A collection of worksheets is called a:
4Which of the following is NOT a type of data that can be entered into an Excel cell?
5Which key is used to start a formula in Excel?
6What is the cell address of the cell at the intersection of the 4th row and 5th column?
7Which function is used to calculate the total of numbers in a range?
8To find the smallest value in a range of cells, which function would you use?
9What does the 'fill handle' in Excel do?
10Which shortcut key is used to convert data into an Excel Table?
When you need to add numbers quickly, instead of typing =SUM(), just select the cells you want to add. Then, press Alt + = on your keyboard. Excel will magically put the SUM formula in the next empty cell below or to the right!
Have a long list of names and want to copy a formula (like calculating grades) all the way down? Instead of dragging the fill handle (the small square) manually, just double-click on it! Excel will fill the formula down until it finds an empty row next to your data.
If you have names like 'Rahul Sharma' in one column and want to quickly get only 'Rahul' (first name) in another column, start typing the first name for the first entry. Then, press Ctrl + E. Excel will automatically fill the pattern for the rest of your list!
If you have a simple list of data, you can make it look professional and add cool features like sorting and filtering with just one click! Select any cell in your data and press Ctrl + T. Excel will turn your data into a proper table.
Sometimes you want to see all the formulas in your worksheet, not just the answers. This is super helpful for checking your work! Just press Ctrl + ~ (the tilde key, usually above Tab). All cells will show their formulas instead of their results.
=SUM(range)=AVERAGE(range)=MAX(range)+2 more formulas below