What are the advantages and disadvantages of a picture graph?
One significant advantage of a picture graph is its ability to convey information in a way that almost anyone is able to comprehend. They are also great for utilizing in a learning environment.
What is horizontal alignment in Microsoft Excel?
Refers to the left-right position of contents in a cell
What 2 locations can a chart be placed?
They can be embedded in a worksheet or can be on their own chart sheet.
What is the difference between Paste and Paste Special in Excel?
In word programs, there is normal pasting which is normally done with images, text, etc, then there is special pasting which allows you to copy a section of text from word for example and past it into another word program as a picture eg.
It just allows you to copy one type of information and paste it as another.
What is the formula to convert bar to m?
Multiply the bar value by 1000.
12 bar = 12,000 mbar.
In an Excel spreadsheet, if you bar version was in cell A2, you could put the following formula in B2 to calculate the mbar value.
=A2*1000
When should you use Point mode to enter formulas?
You could use it at any time. It is useful when the cells you want to select are nearby. It is also handy for selecting the cells when you know them, without having to type addresses. There may be a risk of typing the wrong cells, so it can be handy to clearly select them with the mouse or the arrow keys.
How do you convert Microsoft Excel 2007 file to 2000?
open file in excel 2007 then press ribbon and go to Save as, you will see Excel 1997-2003 Workbook option, click on it and save file.
What to type to enter a new page in Microsoft Word?
When using ms 2007 all you have to do is press the insert tab the press new page and it will add the page where ever your courser is.
How do you copy Excel to PowerPoint?
On the PowerPoint slide where you want to show your Excel worksheet, you would insert and object (on the Insert tab in Excel 2007, select Object). In the Insert Object box, select what you would like to insert, in this case, select Microsoft Office Excel.
A way to automate the copy/paste from Excel to PowerPoint would be with some third party add-in. An option is EzPaste-xl2 anywhere that completely automates the operation with full control of its many aspects.
What is the purpose of columns in an excel sheet?
A row is a horizontal arrangement of cells. Each row is numbered. Often headings are put in rows, so there is one at the top of different columns. In this way a row can be used a a heading row or a title row. In the same way, a heading for each row can be put along a column, indicating what is in it.
How many functions can be nested with the same formula in MS Excel?
Excel 2003 = 8 levels of nesting
Excel 2007 = 64 levels of nesting
What menu contain the save document?
Go to the File menu, then click Save as... , a dialog box will show up where you can change where it's saved, the file format, and the name. Click save when you're done.
What are the different formats for displaying number in a cell?
Numbers can be formatted in far more than 3 ways. There are various number formats such as currency, percentage, fraction, general, scientific and others. Numbers can also be dates and times. Other forms of formatting include alignment such as left, right and center, and sizes and different colours and other kinds of formatting.
What is the most efficient way to make a row of text bold in every worksheet in a file?
There are different possibilities. You could use a Style to do it. You could also individually select each row you want to bold and apply the bold setting to it. You could do it using a macro.
What is a method used in referencing information from one worksheet to another?
You use the name of the worksheet, followed by the exclamation mark, followed by the cell you want. So if you are on Sheet2 and want to reference the cell C20 on Sheet1 your reference would be:
Sheet1!C20
What is a cell reference with two dollar signs?
If there is only one dollar used like $A1 or A$1 then it is known as a mixed reference. A relative reference has no dollars, like A1, and an absolute reference has two dollar signs, like $A$1.
Meaning of the '' sign in Excel?
When you see a cell full of number signs (#########) it means the cell is not wide enough to display all the content in that cell. Make the column wider to display all the content of the cell. If you like, you can click on the letter at the top of the column and select column auto width to ensure all cells are wide enough to display their contents.
How do you type the therefore symbol in Excel 2003?
To type the "therefore" symbol in Microsoft Word follow these steps:
1. Select the Symbol font
2. Hold down Alt key and type 0092 on the numerical keypad
What is a tab scrolling button?
When the tabs of the sheets in your workbook do not all fit in the area provided for them due to the combination of the number of sheets and the size of their names, you can scroll through the tabs using the buttons to the left of the tabs area. They look sort of like this: |â—„ â—„ â–º â–º|. The middle two buttons shift the visible tabs left and right one tab at a time. The far left button makes the first tab visible, and the far right button makes the last tab visible.
You can also jump to the next sheet by pressing PgDn while holding the Ctrl key, and you can jump to the previous sheet by pressing PgUp while holding the Ctrl key.
How to Determine How Much RAM You Need?
You calculate the size of RAM by going into your computer's control panel, looking up system information, and see how much RAM is there. If you're asking about the ACTUAL chips you can load up your computer's diagnostic program and it can tell you what slots hold what size RAM chips.