answersLogoWhite

0

You might want to read data from the web and use it in formulas. It would be particularly when it is values that are likely to change quickly, like stock prices or currency exchange rates.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you create a query in Excel?

You do not really query in excel. If you need to do a lot of queries, use a database. However, you can replicate the effect by using the filter option. Highlight a column and turn on the filter, then select the item you would like to see.


How to change a field to Uppercase in a query?

Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.


Which tool do you use to create a query object?

tables


Which tool do you use to create a query object in access?

database


Which tool in Excel should you use if you know the answer but you don't know the input value?

You would use Goal Seek.


What creates a lower level paragraph in Excel?

Excel does not use paragraphs and is the wrong tool for writing letters or any kind of academic writing. I would recommend MS Excel instead.


How do you create a query using Microsoft Excel I need it for my ICT coursework and I can't figure it out any ideas?

You can search for something using Excel, but you would want to use Access to create a query. Please evaluate your requirements and ask the question again, using more specific terms of what you want to do.


How do you record the use of baking supplies by using accounting principles?

An Excel spreadsheet would be a good tool to record the use of baking supplies.


What query do you use to extract data from two tables?

You would use a JOIN query for this.


Do you use Excel or Access in pivot tables?

Pivot Tables are used in Excel. Access has a type of query known as a Crosstab Query, which works in a similar way. If your data is mainly numeric, then you use Excel. Non-numeric data is more suited to Access. So if you have the names, genders and departments of employees and wanted to find out how many males and females are in each department, then that would be good for Access. If you had a load of sales in different regions listed with their dates and wanted to find the total sales in each month for each region, then Excel would be better.


Which Excel tool would you use to help you find just the right word?

The right word for what?? Excel is a spreadsheet used to crunch numbers and get results by using formulas, if you want to write a paper use Word.......


What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Name the tool that a user of Ms Excel 2010 can use to enlarge and reduce the size of the spreadsheet view.