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
You do a standard copy and paste. If you paste a link, then it will change in the Word or Excel document when you change the other document. If you do not paste a link, then there is no ongoing connection to the original source and so changing the data in Word has no effect on the source.
What is a drag-and-drop method in Excel?
To drag and drop is a way of moving something with the mouse. You are effectively dragging it from its current position and moving it and then dropping it into its new position. It is done visually, so you can see it happening, unlike when you do the same thing using Cut and Paste commands.
To toggle between the different views, press CTRL + ` (single left quotation mark, not the apostrophe). In other words, hold down the CTRL key while pressing the ACCENT Mark (the key under the tilda in the top left corner).
What is The process of correcting errors?
Proofreading is the process of finding and correcting errors.
What keys select the entire worksheet?
Hold down the Ctrl key as you click the cells you would like to select.
What are symbols that display mathematical operations such as addition or subtraction in Excel?
The plus sign does adding and the minus sign does subtraction in Excel:
=A10+B2
=A2-50
The * is used for multiplication. The / is used for division:
=A2*A3
=A6/40
Where in Excel 2007 is the function categories stored?
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
On the formulas ribbon.
What is the Function of Microsoft excel?
There are many functions of Excel but this can be generalised by saying it is used for numerical analysis and manipulation. So you are mainly dealing with working on calculations on numbers for a huge amount of potential reasons. Just about anything you want to do with numbers you can do in a spreadsheet. There is a lot more that you can do too, like graphs and diagrams.
Is the Range automatically selected by Excel always right?
No, the range automatically selected by Excel isn't always right. Excel doesn't know what the user wants to select, but chooses what might be appropriate, like the column of numbers above a SUM function. The user can go with what Excel has chosen, or choose their own cells.
What kind of information is best conveyed in particular chart types?
What kind of information is best conveyed in particular chart types?
How can you press tab and a yellow box?
you look to the very left of the keyboard and look at the fourth one up and motion your and down and point you finger down and complete.
Where is the active cell indicated?
In the name box toward the top left of the screen, to the left of the format bar.
How do you identify an active cell spreadsheet?
- The cell is highlighted.
- The cell usually contains the cursor insertion symbol (I-beam).
- The cell reference is in the cell address box (top left corner, to the left of the formula bar).
What is copy in Microsoft Excel?
Copy initiates a store string command and a write command once you hit "Paste"
Basically, Copy creates an identical duplicate of whatever you copied, be it a few words, or an entire hard drive.
Where do you go in Excel to concatenate?
Concatenating is joining bits of data together, like two separate pieces of text into one piece. There is a function called CONCATENATE or you can use the & symbol. Both of these will do the same thing:
=CONCATENATE( "ABC" , "DEF" )
="ABC" & "DEF"
What is the individual pages of an excel document called?
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
Worksheets.
What is Autofilter in Microsoft Excel?
The Autofilter function looks at all the contents in a column and allows you to select only those entries you want to see. It provides a drop down list containing one copy of each of the different values. You can then select which ones you want to see by clicking on the values in the drop down list.
A feature which allows many documents to be created with the same layout?
That is a template. It creates a 'standard' document layout.
How do you calculate upper quartile in Excel?
Use the QUARTILE function, specifying the data you want in an array, and use 3 to represent the upper quartile. Say your data is in the cells from A5 to A30, you would do it as follows:
=QUARTILE(A5:A30,3)
What are rows and columns in Excel called?
They are called gridlines. These are not to be confused with borders, which are the heavier lines that users can put in with different colours and styles. Gridlines are purely used to clearly show the columns and rows.
They are called gridlines.
