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
When you save a document in Excel what does it save as?
It will save it with the name you specify and as the default type of workbook for the version of Excel you have. You should give the file a name, but if you don't it will call it Book1 and then add the appropriate extension. For the more modern versions, which is Excel 2007 onwards, that would be .xlsx, but if you are using an older version than Excel 2007, then it would be .xls instead.
That is true.
What happens when a user selects a record in a form in excel and presses delete?
It depends on if the delete key has been programmed to perform some specific function by a macro. If no special conditions have been set, the data in the selected field will be deleted, but you probably would not affect the rest of the record.
What is the name of a function in Excel that adds data that matched two or more criteria?
The SUMIFS function.
What is a context menu in Excel?
It is a menu with items that are relevant to what you are doing at that time. Shortcut menus from a right click on your mouse or the shortcut menu key on your keyboard normally show items that are relevant to what you are working in. In other words they are giving you options based on the context of your work.
Spreadsheet better than intergrated accounting package?
Both have advantages, depending on what you want to do. An accounts package can only do accounts, whereas a spreadsheet can do many kinds of things. An accounts package is specifically designed to do accounts, making it easier to set them up, whereas with a spreadsheet you would have to work out all the formulas yourself.
What are the functions of cementum?
Acellular extrinsic fiber cementum is for anchorage Cellular intrinsic fiber cementum is for adaptation and repair Mixed fiber cementum is for adaptation..
What is the value that excel assigns to a date?
It stores a date as a number which is the number of days starting on the 1st of January 1900 to the date being stored.
Formula for calculating 90 degree elbow?
The formula for calculating the 90 degree elbow is W+R*2*3.14/4*P=Meter Square . The area is computed by using the formula (W+R)_π/4_P.
What happens when you hover the mouse pointer over a cell that contains a comment?
You can see the comment.
What does the merge command in Microsoft Excel mean?
You can merge cells, bringing two or more cells together to form one big cell. It can be useful for putting a heading across more than one column or row.
How do you change number format?
Right-click and select format cell. Go to the section for number formats and select the format you like. If you do not like the format, you can change it to almost anything you like, including custom formats.
A set of characters with the same design?
A set of characters with the same design are called stock characters. They were used in Roman and Elizabethan drama.
You can use charts to do that, such as a line chart. You can also use tools like a Forecast Sheet. There are many other functions that can be of use, depending on what you need to do. Functions like TREND and FORECAST can be useful.
What is a spreadsheet application in the Microsoft Office 2003 suite of programs?
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Microsoft Excel.
Should you double click a function name in the formula autocomplete list to select the function?
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
How do you stop a number changing to a date in a cell in Microsoft Excel?
Select the Cell and press Control + 1 or find format cell. Select the option under the "Number" tab "Text"
A PICK Chart is used in Lean and Six Sigma as a way to prioritize ideas based on the Effort involved and expected Impact. Check it out here: http://www.hitdocs.com/pick-chart-xlsx/
How many sheet are insert in one Excel file?
The default number of sheets in a new file is 3. This is a configurable option which is set from the Tools -> Options -> General tab. The maximum number of sheets is limited by the available memory on your computer.
Info was from Excel 2003 Help "Excel specifications and limits"
What makes a good chart in Excel?
A good chart is one that displays the information to present a picture that accurately reflects the relationship of each data item relative to the whole data set.
