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 insert on Excel file into a Word document the data is?
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
The data is put into a table. Depending on how you paste it in, it may be linked. If it is, then when the data changes in the the Excel file, it will also change in the Word document.
Why is a chart a good way to organize information?
Charts are helpful because:
- Data is easier to read
- It keeps track of everything you do
- & because it is easy to use
What is auto sum button and how does it work?
There is a Sigma "∑" buton available on the standard toolbar on the top of the Excel sheet or on the ribbon. It starts the SUM function in a cell, which will select cells to sum up and also allow you to change the selection. So it automatically sums values.
In what format does Excel store dates?
They are actually stored as numbers, where dates are represented by the amount of days since the 1st of January 1900 inclusive. So the 1st of January 1900 is stored as 1. By storing them as numbers it makes doing date calculations, like finding out the amount of days between two dates, very simple. Dates can then be formatted to be displayed in many different ways, showing numbers or words and using the styles of dates used in different parts of the world.
What are some advantages of using a spreadsheet over a calculator?
You can look back at all your working out and check they are right.
It is much quicker.
It looks more impressive. ;-)
Select the situations in which conditional formatting would be effective?
to format the product lines with the weakest sales to identify the employees that made the most sales to highlight all cells with figures above $50,000
How do you erase all the columns in Excel?
It depends on if you want to delete only the contents of the column or remove the entire column from the worksheet. If you want to remove the entire column, right-click on the column heading and click on the delete menu option. If you want to leave the column, and delete only the contents, right-click on the column heading and press the Delete key.
How many columns in microsoft 2007?
The last cell in Excel 2007 is
XFD 1,048,576
There are 16,384 columns and 1,048,576 rows.
What toolbar is located on top in Microsoft Excel?
A toolbar is a dockable child window that contains icons that activate program features.
In later versions, toolbars are known as ribbons. The default configuration in Excel 2010 has File, Home, Insert, Page Layout, Formulas, Data, Review and View as ribbon titles. In those ribbons, you will find commands that are generally related to the ribbon title.
When you save a workbook each worksheet will have a different file name?
No.
The workBOOK is saved as a single file including every workSHEET.
True.
True.
True.
True.
True.
True.
True.
True.
True.
True.
True.
How do you format dates in an Excel spreadsheet?
You can enter dates by typing them in. You can enter today's date by pressing and holding the Ctrl key and then pressing the ; key. The function TODAY() can be used to show today's date. The DATE function can be used to display any date, by specifying the year, month and day as numbers like this:
=DATE(1980,12,25)
What symbols do you use when you want to add a set of numbers togather?
The only mathematical symbol you can use is the plus symbol. However, there are functions built into applications, most notably spreadsheets, that enable numbers to be added together. The most common one of these is the SUM function. It can be used in many ways to add numbers, without using a plus symbol. It can be used referencing numbers directly, or through cell references and cell ranges. So you can do something like this:
=SUM(10,2,5,11,30)
That will add the listed numbers together. If those numbers were in the cells A1, A2, A3, A4 and A5, then you could sum them in either of the following ways:
=SUM(A1,A2,A3,A4,A5)
=SUM(A1:A5)
Goal Seek! Good luck with your BI class!
List the functions for the category 'Logical' in Microsoft Excel 2003?
A logical function is one that can return a true value or a false value. They are usually used in doing comparisons and seeing if things are equal to each other or not, or which is higher or lower. The logical functions that Excel provides are:
TRUE
FALSE
AND
OR
NOT
IF
Where can you place a data label in an Excel chart?
Data labels appear on charts. If your right click on an item in a chart, such as a bar or a pie or a line, you can choose Format Data Series and then you can choose Data Labels. You have a choice of various types of data labels to put in, such as the actual value or the percentage.
How do you change a text orientation in Excel?
- Select the cell or range you want to change.
- In the Format Cells section, click on the Alignment tab.
- Move the Orientation pointer (right side of Format Cells | Alignment window) to the orientation you want.
- Click OK.
How do get the get the column and row lines to print in a spreadsheet?
I like to use the MOD() function and conditional formatting to apply formatting like that. If you've never used conditional formatting you will probably want to read up on it. This formula: "=MOD(ROW(),2)>0" will test for the row and see if it is an odd-number row. That is the condition. If the condition is true, you state what the formatting ought to be if it is...You would apply this to the entire spreadsheet by selecting all of the cells by clicking on the upper left row-column header cell (that lights up all of the cells).
That conditional formula is not, though, going to give you an underline under each row--it will underline every other row...To underline every row, light up all of the cells and do a right click in the middle of the sheet. Select "format cells" and from the menu, click "border" on the tab. Select the mid border and bottom border and click "OK".
How do you change capital letters to small letters in Excel?
It would be different in different applications. In Word and Powerpoint, select the text and press Shift-F3 to change between different cases. In Excel and Access use the UPPER function, to convert text.
