Explain the process of creating a data table.

Asked by Last Modified  

1 Answer

Follow 1
Answer

Please enter your answer

Computers, Excel, Word, PowerPoint, Power BI – 20+ Years of Knowledge to Accelerate Your Growth!

Hi Saritha, To create a Data Table in Excel, Go to the "What-If Analysis" or "Data" menu, then select "Data Table" depending on your Excel version. The specific steps may vary slightly depending on Excel Version/Release, but the basic concept remains the same. You give the input values as per the...
read more
Hi Saritha, To create a Data Table in Excel,Go to the "What-If Analysis" or "Data" menu, then select "Data Table" depending on your Excel version. The specific steps may vary slightly depending on Excel Version/Release, but the basic concept remains the same. You givetheinput values as per the requirement, the formula to analyze, and Excel does the calculations to create the Data Table. read less
Comments

Related Questions

How do you deal with large data sets in Excel?
if data rows are greater than 10L then u will use MS. Access
Profile Photo
Ajay
0 0
View Comments5
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Profile Photo
Ramkumar
0 0
View Comments7
can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Profile Photo
Abdul

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...
Profile Photo

Shortcut of Excel for Selection
Select the whole column: CTRL + SPACE Select the whole row: SHIFT + SPACE Select table: SHIFT + CTRL + SPACE bar Select visible cells only: ALT + ; Select entire region: CTRL + A Select range from...
Profile Photo


VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...
Profile Photo

Excel Keyboard Shortcuts
Our day to day work involves excel and to complete our work fast we should have adequate knowledge of keyboard shortcuts. I am going to give you simple but useful tip which will helps you to navigate excel...
Profile Photo

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you