0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
How do you open attachments without having to go to Excel?
It depends on what program or webmail service you're using. Most webmail services will automatically display any email attachments that are images directly in the email itself. If it's some other file type, you need the appropriate program or software to open the file, such as an audio player for mp3 files, image program for images, Word for Word documents, and so forth. Look for a small paper clip icon on the email's window. Some programs, by clicking on the paper clip, a drop down list will pop open and you just click on the filename and it will download onto your computer.
What is a lookup list in Excel?
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
What is a correct way to gain access to Microsoft Excel?
You have to buy it. Go to the Microsoft website and download it from there.
When you insert a row what new row automatically inherits the format?
The new row is blank and the values and formulas in the existing row are pushed down by one. So if you had a formula in row 10 and inserted a new row to replace row 10, row 11 would now contain what was in row 10.
What is the last cell of Excel?
In Excel 2007, I got XFD1048576.
In Excel 2003, I got IV65536.
In Excel 2002, I got IV65536.
NOTE: You can open MS Excel, click a cell, then press Ctrl + Right arrow, Ctrl + Down arrow to get the result.
In Which scenario would spreadsheet software be most useful?
The word processing application would be most useful when writing a script or a letter. It would also be useful when writing a report. WRONG WRONG WRONG
Shows which toggle keys are engaged?
There is no longer any indicators built into Excel to indicate the status of a toggle key, such as the caps lock. Older versions (especially DOS versions) used to have an indicator bar at the bottom of the screen, but that was removed a long time ago; I do not know which version changed that procedure. Now, you need to look at your keyboard or other indicator to tell the state of the keys. Some verisons of Excel pop up a small box at the bottom right corner of the screen letting you know when you change the state of a toggle key, but the box remains only for a few seconds.
How do you do an outline worksheet?
First create your spreadsheet, laying out in a structured manner, like having the figures in columns and totals at the bottom of each column. Select the figures, including the formulas, like totals at the bottom of the columns. Then go to the Data menu, pick Group and Outline and then Auto Outline.
What is the first argument required by Excel's built-in IF function?
For my example you have a number '2' in cell D4
The first argument would be: Logical Test.
Example of IF Argument: =IF(Logical Test, True, False)
So the logical test is what you are testing, IF Cell D4=2, the value would be true, if it didn't equal 2 the value would be false.
What is the meaning of cell in excel?
A cell is a box . Referenced by its row and column. In each cell there can be values (numbers or text or formulae etc.)
How do you return to the top left cell in Excel?
Pressing the Shift key and hitting the Enter or Return key, will move you one cell up. Pressing the Shift key and hitting the Tab key, will move you one cell to the left.
Response Sept 2012 - to above answer. I wish folks who "attempt" to answer these questions, note the quotes around attempt, for that's all they are, feable attempts at most, would first learn how to READ the question. The question is one I have been searching for the past week, with no luck. It may require a VBA program to accomplish, but at this time I have found no combination of keys that will return you to the immediately previous cell you were in. Let's assume for the moment we are on the same worksheet. By going back to the previous cell I'm sure the questions means if I'm in cell B 12, and then scroll down to cell P 154 and enter something, how do I get back to cell B 12 without having to cursor up and over to it or hitting the "goto" icon on the upper left of the worksheet and typing in B 12.
What are the sheet tabs in Microsoft Excel?
A sheet tab appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its colour. This can be done by right clicking on it and picking the option from the shortcut menu that appears. By clicking a sheet tab, you can make that sheet the active sheet so that you can work on it. You can click on the sheet tab to move its position by dragging on it, or also from the shortcut menu.
In Excel a collection of worksheets is referred to as a?
WORKBOOK
Workbook.
Assuming all of the worksheets are in the same file, the term is workbook.
A workbook.
workbook
well a spreadsheet is what your making, spreadsheet mode is the view
What is displayed to identify the rows of a spreadsheet?
Rows are identified by numbers. The numbers appear down the left side of the spreadsheet. When a row is selected, or any cells in a row are selected, the row header changes colour to indicate that.
What is the maximum MB file size of an Excel 2007 file?
Current spreadsheet size is 165MB, no problems yet and includes extensive code/macros and colors.
Why should you save a spreadsheet?
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
Click on the disk icon to save, or press and hold the Ctrl key and then press the S key.
What Excel function is used to add numbers in a range of cells?
The syntax is... sum(start:end) - where 'start' is the first cell in the range and 'end' is the last.
When you press the enter key without entering text after the automatic bullet character?
Press the ENTER key to turn off automatic bullets as your type. REF-Microsoft Office 2010 WD 187
What is Microsoft Excel used for in the banks?
Microsoft Excel is one of the fundamental computer programs used for accounting and financial services. It allows banks to respond more quickly to customer and client needs, to have better knowledge of the status of their financial assets, and allows a banker to service more clients with less work.
- Data Entry and Automation
Banks make their money off of accurate record-keeping of financial assets. By using several features in Excel, including entering formulas once and cutting and pasting to new cells, and making cells with formulas that are read-only, Excel greatly reduces the time to make those records and the likelihood of errors.
Excel has a number of functions that are designed around invoicing, such as DATE, and EDATE. These functions allow banks to track when payments are due on loans and when to send out statements. They also can be used to track maturity dates on certificates of deposit.
While Excel's functions (like EDATE) are very flexible, Excel also comes with Visual Basic for Applications, which allows automation of routine tasks, such as end of business day copying of data from workstations to a centralized accounting check point. Most banks have built thousands of macros and customized programs on top of Excel's functionality, which would cost millions of dollars to replace if they were done again from scratch.
