Microsoft Excel Questions With Answers

Question 1). What is Microsoft excel used for?

Answer: Excel is an impressive magical tool to calculate any data whether is small or big. It has many features to handle the database in numbers and for text content as well.

Let's do a small practice like if we have small data or content to put in an excel sheet to calculate or work on, though it provides cells, rows, and columns to add more & more information in it as per our requirements.

Here we can see an image of what the same how does look like.

 

Once we open an MS excel it shows so many cells and rows, after seeing it we might get excited or confused as well like how we going to use it but there is nothing to worry about it.

Let’s learn the basics first about it so we will not get any issues while we work on it because if we get complete knowledge about it, we can enjoy working on it rather than be disturbed.



So let s first its interface below in an image.

This picture clearly shows some tabs at just the top of the image. This image that we can see above it has some tabs and we can see these tabs mentioned with names below to quite understand what exactly they are.

1). FILE

2). HOME

3). INSERT

4). PAGE LAYOUT

5). FORMULAS

6). DATA

7). REVIEW

8). VIEW

Now here we have to understand that it depends on us like how many tabs we want in total however currently we can see that we have eight tabs above in the image. We can make or add more tabs through the developer tab.

At this moment, let us check another page below for better and good learning.                                                     


2ndstep is now we see again some options in the image above that we have here.

1). INFO

2). SAVE

3). SAVE US

4). PRINT

5). SHARE

6). EXPORT

7). PUBLISH

8). CLOSE

9). ACCOUNT

9). OPTIONS

 On the right-hand side, we see these options below in the image


1). RECENT

2). OneDrive

3). This PC

4). Add a Place

5). Browse

The fourth step is straightforward here, let's see an image below for the same.

This sheet has more than 1 million cells or rows, which is quite good or impressive, and we need to appreciate Microsoft for making such a helpful tool for users.

In the excel sheet in left side corner, we can see here we have numbers that start from 1stto 1048576 and on top, it starts in alphabets from “A” to “XFD”

That is a basic thing about an excel sheet now if we want to add any data to the sheet, we have columns and rows in it and can customize it. 

If we want to create a workbook or excel then we can do this below that we did below.

HOME


In the HOME tab, we have these many options that we can use to customize our data as per our needs. we can put our data in colour and filters or whatever we want from this HOME tab and can apply these settings to make our data better to understand and attractive too.

INSERT

We will learn here few things from this tab, which is quite simple and lovely to know.

PAGE LAYOUT

In-Page Layout

We have several options or features to use, Print command also comes under this Page Layout tab and that is also important because sometimes we need to take a print of the workbook so in that case, we can use it.

FORMULAS

In formulas, we have some functions for basically financial, text, logic, math, etc. Let’s check the image below.


DATA

In the same way, we can see the next tab named DATA   and which has many functions to use like finding duplicate values etc.

REVIEW

In this tab, we get these features as mentioned below in the image. Once we going to start working on these options, we will get to know the importance of these features and understand them too.

VIEW

In this tab, we have some features like page break and zoom options and the most important is Macros. Macro is one of the most powerful tools in MS excel and how do we use it, let s understand that now but first we see these options in the image below.

Macro:- This tool we use to make our work burden as slow as. If we do any repeated task in excel again and again then we can use this tool to record the session of the excel workbook and play it. It will complete the job, as we need as per our choice.  It works well and it’s very helpful when we have too many repeating tasks to handle in an excel workbook.

So here we discussed all the basics things about MS excel like how it starts to work on it and what these options as tabs are available in it.


Microsoft Excel is like magic power that we got from Microsoft INC.

We can learn more about it and can learn all these basic functions practically.  Many people are teaching MS excel online and offline and on YouTube and anyone can take free classes on YouTube.

 

Some of them are providing paid classes also but this different thing so if anyone wants to learn for free, they can also do it from YouTube.