0
What else can I help you with?
What indicates which workbook cells are included in a formula calculation?
The name of the workbook will be enclosed in square brackets, indicating it is another workbook.
How do you link to another excel file in a formula?
Include the external workbook (surrounded by []) and worksheet names (followed by !) in the formula:=SUM([workbook.xls]worsheet!A1:A23)
Which of the following is an external reference indicator in a formula?
It is a reference in one workbook to a cell or range in another workbook. So the reference is outside, or external to, the current workbook. To do it involves having the name of the workbook in square brackets, then the name of the sheet, then an exclamation mark and then the cell reference. So it could be something like this: =[Invoices.xlsx]Sheet3!C14
What are formula results that are updated each time a workbook is opened?
Refreshed
Which bar displays entries as they are made and edited in the Excel workbook window?
formula barformula bar!
What type of cell reference is required if a formula containing a cell reference requires that the referenced cell remain the same even if the formula is moved to another cell position?
An absolute reference.
What examines the formulas in a workbook in manner similar to the way the spell checker examines a workbook for misspelled words?
As you are typing it in, formulas are checked for errors of syntax. If a formula is working, you can see how it works in stages. It is known as being evaluated. A formula can be evaluated using a built-in facility.
What is a background formula checking in Excel?
Excel continually reviews the workbook for errors in formulas as you create or manipulate it
How do you create a formula on the totals sheet that will automatically pull the correct cell on a new sheet that you add on to the workbook?
You have to add it into the formula box and then there is a button on the top that can do it for u
Write the chemical formula for the ionic compound containing calcium and fluorine?
The chemical formula for the ionic compound containing calcium and fluorine is CaF2.
What displays entries as they are made and edited in the Excel workbook window?
The Formula bar will do that and you will also see them in the actual cell.
What is the symbol of oxide?
The symbol for oxide is O. Oxides are chemical compounds containing one or more oxygen atoms bonded to another element.
