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
If you want to open the offfice assistant in Microsoft Excel what key do you press?
Press the key combination Alt - H - O and it will open if it is in the version if Excel you have.
What is the ab button in excel?
The ab button, with the diagonal arrow from the bottom left to top right, is the Orienation button. It allows you to do things like slant your text or make it vertical.
Anything you enter into a cell, apart from formulas, like text, numbers, dates etc. is data. Formulas process the data, resulting in information.
Which references would indicate that the Excel column would not change when copied?
A dollar symbol before the column reference will prevent the column reference changing when it is copied. Having $A1 for example will prevent the A changing when a formula with it in it is copied. The 1 could change unless it is also preceded by a $ symbol.
Can you move datasheet columns by dragging the field name left or right?
No.
Insert a blank column where you want the old column to be (otherwise you will overweight existing data)
Highlight the entire column to be moved, then right click and choose cut. Click on the new blank column and then right click and choose paste.
How can you add a vlookup formula and an if formula in same cell?
There are lots of ways, but it depends on what they are both doing and what your overall formula needs to do. One function could be nested in another. If they were both returning numbers, you could do calculations with them, so they could be connected by mathematical operators. You could be concatenating their results. Both might be used with other functions too. So there are lots of ways of doing it, depending on what it is that you want to do.
Data that is currently available to be used. The program has it stored where it can readily get at it rather than having it stored out of easy reach.
What data could a travel agent use a spreadsheet for?
Prices, amounts of passengers, amount of hotels, revenue, sales, seats of flights, dates of holidays, and many, many other things.
Does Excel series name only have one data series?
Each series has one name. If you want more than one series, then each will have its own name. A series can have a lot of values in it, but can only have one name for that series.
How can you arrange text into multiple columns?
That depends on the nature of the text and what way you want it to be in columns. If it is just a large block of text that you want into newspaper-styled columns, then word processors and desktop publishers have the facility to do that. If you want text that is data, like names and addresses etc. and you want to break the data up so that all the names are in a column and the addresses are in columns, then you do something different. You separate the components on a line with commas and put each new set of data on a new line. Then it can be imported into a database or spreadsheet and the data will be split into columns based where the commas are.
How does applying themes differ from applying formatting features individually?
It is quicker than doing the elements one by one. It helps you standardise the look of the sheets. It is predefined, so you can choose from the different themes available. As a theme is a full set, you don't have to worry about leaving something out. So there are lots of advantages.
First save your file as another file so that you won't lose the original file.
One way to try and open it is opening it from Excel (use 2007 version and above).
Using delimiter, excel can export it to its version for you to view.
I have tried this technique before and it worked.
Hope this helped.
J.
An external document usually is a document that was not created by the application you are using, or a completely separate document to the one you are using. You may want to link to it in some way or import some of its data into your current document.
Where can I find this worksheet online?
Unless there is a URL at the bottom of the page it might be hard to find the worksheet again. If it is from a specific workbook you might need to order another or see if the school has one on file.
What is the purpose of an alumina column?
Column chromatography is generally used as a purification technique: it isolates desired compounds from a mixture.
Column chromatography is separated into two categories, depending on how the solvent flows down the column. If the solvent is allowed to flow down the column by gravity, or percolation, it is called gravity column chromatography. If the solvent is forced down the column by positive air pressure, it is called flash chromatography, a "state of the art" method currently used in organic chemistry research laboratories The term "flash chromatography" was coined by Professor W. Clark Still because it can be done in a "flash."
Why is it important to have a separate column for GST?
It is important, so that you can see just how much money you are giving to centrelink.
How do you change a long dash into a hyphen throughout a text using Find and Replace?
- Change the long dash to a hyphen one time manually.
- Open the replace option (by whatever method works for your application).
- Copy and paste the long dash into the Find Whatbox.
- Copy and paste the hyphen into the Replace Withbox.
- Clik Replace All.
What is the definition of list in Microsoft Excel?
It is like the ordinary understanding of a list, in that it is a set of values that are listed in your spreadsheet. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel. If you type in any day of the week or any month of they year into a cell, and then click and drag on the fill handle, it will fill out subsequent days or months. You will find Custom Lists under the Tools menu under Options.
What is the keyboard shortcut for header and footer?
Header and Footer comes under the View menu.
To shortcut to Header and Footer: Alt v h (Alt + V + H).
Remember, you can use Alt in combination with any underlined letter in a menu bar or menu. Even if the shortcut letter isn't underlined, still give the most appropriate-looking letter a try with Alt and see what happens.
Don't be afraid of mucking up something: you can always shortcut Ctrl z to Undo, or Alt e u (Alt + E + U) or Redo (Repeat): Ctrl y, or Alt e r (Alt + E + R), or Alt + shift + backspace.
Experiment with your keyboard: you usually won't break anything and you'll save heaps of time. The great thing with keyboard shortcuts, too, is you can key ahead: you can't do that with a mouse, and of course, the more you switch between keyboard and mouse, the more you challenge your concentration, which is tiring and distracts you from the work at hand.
It's well worth taking a few hours to learn to touch-type. Doesn't mean you mustn't ever look at the keys, unless you're aiming to become a top-flight super secretary; it just means your fingers will forever after remember which key is where, so you can devote most of your attention to your onscreen work instead of fishing for the right key.
Some people will insist they're fantastically fast just pecking away with one or two fingers, and don't lose any concentration that way. They're dead wrong, and also will suffer, if they use a keyboard regularly, from tendon and skeletal problems years down the track.
Doesn't seem important when you're younger, but ask one of the older generation who's been two-finger pecking for decades whether they're experiencing any mobility problems with their hands. Trust me, they are, and this can be terribly disabling for those who do fine, concentrated work with their hands for work or hobbies. I know people from jewellers and violinists to tailors and cake decorators who curse those decades-back keyboards.
For the same reason, it's a good idea to use a left/right mouse, so you can regularly switch hands for mousing. One higher-tech mouse for highly mouse-driven work, plus another basic model for working mainly with text, is great if you can acquire both.
At school or work it's in the school's or the employer's interests to keep things ergonomic; you can always approach admin or management and discuss ways to keep hands healthy.
Incidentally, the numberpad is designed to operate by touch: the '5' key has a raised indicator to tell you where to rest the middle finger of your right hand, just as the main keyboard has raised indicators on the 'f' and 'j' keys to show you where to rest your index fingers. It takes only minutes practice to learn to operate the numberpad by touch; you can still look at the keys if you like, but after a while you won't need to.
It's a worry to be in a bank or at a checkout and see operators pecking with one or two fingers at the numberpad, or, worse, at the main keyboard's number row. For home computer users it should be a priority to learn touch-operation and for workers it should be the employer's responsibility to ensure they know, or are taught by the employer, to work by touch. As I say, we're not talking no-glance at-the-keyboard, super-speed stuff here: just the basics required to maintain good health.
I personally wouldn't hire someone who might even just occasionally use a keyboard without being sure they had the basic skills to work by touch, or were willing to learn these skills during work time.
Can you change the way data in table format is displayed?
This question is in many categories that may require different answers. In Excel you can use many formats to display your data and change whenever you like.
