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
What are the types of filter in Microsoft Excel?
Filters allow you to show rows of data based on the content of cells and conditions applied to them. If you had a list of salesmen and their total sales made you could do something like show all the salesmen that had made a total sales above a certain amount, or ones that had made sales under a certain amount or ones that had sales of an exact level. You can also do combinations of conditions across different ranges. So if you also had the names of the offices that they were working in, you could find all the salesmen who made over a certain amount of sales and worked in a particular office. A filter allows you to bring in some databasing operations into a spreadsheet. You can also do things like sorting values.
You can use an Auto-filter which can do quick filters based on what cells are already there and their values. You can select various columns to be used as the filter and do things like already mentioned and do things like show a set amount of values, like the top 10 values. There is also a feature called an Advanced Filter which allows you to set up more complex criteria and do things like get the values that result from the filter and put them into another part of the spreadsheet.
In Excel dividing a cell into more than one cell is called?
I checked out my Excel 2007 software and it looks like the closest answer would be 'unmerging' the cell. Here is direct text for their help website though:
You can't split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it. For example, you want to split cell A2 into three cells that will appear, side-by-side, under cell A1 (you want to utilize cell A1 as a heading). It is not possible to split cell A2, but you can achieve a similar effect by merging cells A1, B1, and C1 into one, single cell. You then enter your data in cells A2, B2, and C2. These three cells appear as if they are split under one larger cell (A1) that acts as a heading.
What happens when you press Ctrl and the Home keys?
Ctrl + Home takes you to the beginning or top of a document.
What do you click to display a shortcut menu?
You right click on the icon and click add shortcut........
OR
you go to menu and drag a program on to your desktop then do that again and there should be a shortcut
On the start, at the bottom left corner of your computer screen their are a list of icons that are listed you can; right click each icon, and send each one to your desktop or start bar at the bottom of your screen. In addotion when you download a program it offers you to add a shortcut to you desktop or to your start bar.
Which is the correct process for selecting consecutive rows in a worksheet?
Press and hold the Shift key and click on the sheet tabs. All sheets between the first and last you click on will be selected. Pressing on the Ctrl key when you click on the sheet tabs can select ones which are not beside each other.
What do you use to display information in rows and columns?
The tech that is used to store info in columns and row is a matrix in programs. Unless your thinking of Microsoft PowerPoint which you can store graphs and data in columns and row. Or you can be talking about a mapping cordnates you question is a vage question it hard to answer without a specific question.
a table or a graph
A worksheet containsns at least one workbook is it true?
False. It is the other way around. A workbook contains at least one worksheet.
The most common kind of visuals in Excel are charts. There are lots of types of charts in Excel. Excel also allows you to do other visual things. You can create drawings using the Drawing tools. You can create your own graphics for Excel that way. You can use Smart Art to create lots of kinds of specialised charts and diagrams, such as Organisational Charts. You can bring pictures in from other applications and insert or paste them into Excel. A very creative user could do lots of things with Excel in terms of visuals with all these possibilities.
Features of data validation in Excel?
Data validation allows you to apply more control over values that are going into a spreadsheet. It reduces the errors made. For example, if you had a cell that you only wanted values between 1 and 100 to go into, you could set up a validation rule to ensure that happens. It would stop you putting in values outside of that and warn you that the values must be between 1 and 100. There are a whole range of types of validation that you can apply.
How do you add a blank line in a spreadsheet?
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
How often should you save your work on a computer?
well obviously if your even worrying about this than why not after every sentance, its not gonna make a difference. Just save after you type somthing you dont want to lose
By default where does the Excel aligns values?
Text will align to the left and numbers and dates align to the right.
An organization will define data input policies and procedures to ensure that high quality data is gathered. Quality control tasks, such as a sample data integrity check and time tracking software, are methods that are used to ensure data input meets designated timelines and organizational requirements.
What is a cell address in Microsoft Excel?
A letter or letters to represent a column and a number to represent the row. The following are examples:
A5
C23
CF235
D8
IA4
H12300
Either (or both) of the letter or number can be preceded by a dollar sign ($) to make the reference absolute so that if the cell address is copied to another cell that part does not change - an example of this being useful is if a cell (or column or row) contains a conversion which needs to be applied to lots of different cells using a formula. Examples of absolute addresses are:
$A5 (this is a column address - if the reference is copied to another column, it will always point to column A)
A$5 (this is a row address - if the reference is copied to another row, it will always point to row 5)
$A$5 (this is a cell address - if the reference is copied to any other cell, it will always point to cell A5)
Where can I learn MS Excel for free?
There are lots of websites with information on Excel. You would also get a lot of information in the Excel category on WikiAnswers. There are online tutorials. You won't always understand them, and there isn't someone there to explain them. A better way of learning Excel is to get someone to show you. A course will cost you, but someone that you know who is good at Excel could show you.
How do you link an Excel file to word 2007?
The answer is quite complicated but there is a link on the internet my website, where you can learn this. www.bytesizeoffice.co.uk
It is a sheet that only contains a chart and has no columns or rows. It shows a chart completely on its own sheet instead of being embedded in a worksheet.
What is a formula in a cell that makes a reference back to itself?
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed so the formula is invalid, as it creates infinity.
The View buttons appear near the bottom of the screen. You use the View buttons to change between Normal view, Slider Sorter view, and the Slide Show view. Normal View Normal view splits your screen into three major sections: the Outline and Slides tabs, the Slide pane, and the Notes area. The Outline and Slides tabs are on the left side of your window. They enable you to shift between two different ways of viewing your slides. The Slides tab shows thumbnails of your slides. The Outline tab shows the text on your slides. The Slide pane is located in the center of your window. The Slide pane shows a large view of the slide on which you are currently working. The Notes area appears below the Slide pane. You can type notes to yourself on the Notes area. Slide Sorter View Slide Sorter view shows thumbnails of all your slides. In Slide Sorter view, you can easily add, delete, or change their order of your slides. Slide Show Use the Slide Show view when you want to view your slides, as they will look in your final presentation. When in Slide Show view: MY SOURCE: http://www.baycongroup.com/powerpoint2007/01_powerpoint.htm
To move the insertion point to the previous cell what key should you press?
The best know shortcut key to go back to your previous cell in microsoft excel would depend on what cell you are in. You would either press up, down, left or right
What are some application for excel workbooks and worksheets in both the field of accounting and for an NFL team
What are two methods of applying the same format to different ranges in Excel?
You can use the Format Painter to copy the formatting from one range to another. You could copy a range and then using Paste Special, pick the Formats in the options. You can also just select the two ranges at the same time, and then apply the formatting to both ranges. Select the first range as normal, then press and hold the Ctrl key and use the mouse to select the second range.
Initially it is just Book1 and it will have Sheet1 opened in it first. It only uses those names because no other names have been given. It is the same in other applications, like having Document1 in Word for example. When you go to save the Excel Workbook it will give you a chance to give it the name you want or else it will save it as Book1. When you are saving a workbook, or any kind of computer file, you should give it a proper name.
