0
No. You can only have the focus on one at a time. You could have formulas in cells in the second one that make their values equal to the corresponding cells in the first or do some other calculation with them. As you entered the data in one, data would also appear in the second. However, that is not really having the data being entered simultaneously as the formulas would have had to have been entered first, and the formulas rather than the data would be in those cells and it would only go in when you pressed the Enter key or clicked on the tick on the formula bar to enter it.
What else can I help you with?
How do you draw a nomogram in Excel?
You can not draw shapes or objects in Excel. Excel is used for spreadsheets and organizing many forms of data.
What type of data can be entered into a cell?
It is Label, Value, and Rule.There are lots of them:TextNumbersDatesTimesLogical
What MS Excel stores?
It stores data. Mainly that data is numbers, but it can also be text, dates or logical data. Excel also stores the formulas that are entered and the formatting of data that is entered.
Excel displays data in a special document called?
Microsoft Excel displays data in Worksheets, also called spreadsheets, or as a group of worksheets known as a Workbook.
What types of spreadsheets are used in accounting?
Accountants use spreadsheets to collect and analyze data. The types of spreadsheets that are used in accounting include Microsoft Excel, Sage and Google Docs.
Replace manual ledgers and are easier to edit and are more accurate if data is entered correctly?
Spreadsheets
What data types can be input into Microsoft Excel 2000 Spreadsheets?
text and numbers formatted in a variety of ways
Can you use Microsoft PowerPoint to open a file created with Excel?
Powerpoint is not designed to directly open Excel documents. Powerpoint can import spreadsheets and charts and you can copy data from Excel into Powerpoint. Powerpoint also has a built in feature for creating very simple spreadsheets and charts.
Why is an excel file is called a workbook?
A workbook in Excel is a collection of worksheets. A worksheet is an arrangement of rows and columns, making up cells into which various types of data and formulas can be entered. Each row is numbered. Each column is headed by a letter or combination of letters.An Excel workbook is basically an Excel file, containing one or more Worksheets. They are individual spreadsheets in your document.
What components are provided by a SharePoint Report Center site?
Sharepoint Report Centre is part of MOSS and is the home for Business Intelligence data.The main components of a Report Centre are: -Dashboards: - These are aspx Pages containing Scorecards and Reports.Scorecards: -These are sharepoint lists displaying KPIs or Key Performance Indicators.Reports: - These are spreadsheets displayed using Excel services. The data connections are maintained in a separate data connection library.Scorecards can use manually entered data, sharepoint lists, Analysis services cubes and excel spreadsheets for KPIs.
What can be entered into spreadsheets?
Three types of data may be entered into a spreadsheet or worksheet: (1) values or numbers, (2) names or labels, and (3) formulas for calculation.
How is company data stored?
Company data, such as employee salaries, expenses, etc are usually recorded in Microsoft Word (documents), Excel (spreadsheets), or Access (databases) files.
