0
Which Excel feature would allow you to change the font and color of a cell based on its value?
Wiki User
∙ 10y ago
Conditional Formatting.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What Excel feature replicates or continues data in a series of numbers number and text combinations dates or time periods based on a pattern that you establish?
The Fill feature can do that.
What best describes Excel's Auto Fill feature?
On request, cells are automatically filled with data, usually based on cells above, or to the left.
How do you format and change cells color based on their changed values in Excel 2007?
You need to use Conditional Formatting.
What happens when you change a value in Excel on which a chart is dependent?
It will immediately redraw the chart based on the new value
When you change a value on which a chart is dependent excel immediately redraws the chart based on the new value?
Yes, unless the chart is generated by a VB macro.
Can Excel be web based?
You can export a spreadsheet to HTML to view on the Web, but you can not operate Excel from a web browser.
How do you export stream data to excel file from HySYS?
There is something called a workbook dump. It is excel-based, and can be used to export data from HySYS to excel.
How often does Excel recalculate a formula?
It is not time based. Normally Excel is in what is known as Automatic Recalculation mode. When this is the case Excel recalculates any time any change is made to the spreadsheet, like typing in a new number or a piece of text. If it is in Manual Recalculation mode, then it only recalculates when the user presses the F9 key.
What are disadvantages and advantages Excel charts over printed charts?
A chart in Excel is dynamic, meaning it will automatically change as the data changes. A paper based chart won't do that. Excel charts can have all sorts of features and can be customised to the way the user wants. Those are some of the advantages. A paper based chart can sometimes be more accurate than an Excel one in the way it is drawn, like X Y diagrams. It is much easier to add notes to the chart when it is printed. A user can handwrite on it to make important notes about it.
Does Excel have two types of conditional formatting?
You do Conditional Formatting based on a cell value or based on a formula.
What utility in excel can arrange the data based on any criterion?
Filter.
A formula that makes calculations based on stated conditions in excel?
An IF formula.
