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
Is there Microsoft Excel in Samsung Galaxy Tab?
With ThinkFree software on your Galaxy Tab, you open, view and edit Word, PowerPoint and Excel files without being tied to your desk. You can also view PDFs - handy for that restaurant menu or those directions you downloaded.
What is the difference between macros and sub routine?
A macro is just short hand. A subrountine is "called."
Subroutines can save memory by reducing repeated code, but take more time because you have to push arguments and return addresses, and push the result and pop back.
A macro is the code literally inserted where you put it. It doesn't save any memory but is as fast as the bit of code you put there, saves typing, and is easier to read.
For example, if I define a macro
#define TOGGLE_PIN1 PORTD.1=0;PORTD.1=1;PORTD.1=0
and put it in my code like so
putsf("I'm going to toggle PIN1 now");
TOGGLE_PIN1;
putsf("PIN1 was toggled");
it would be exactly the same, to the processor, as
putsf("I'm going to toggle PIN1 now");
PORTD.1=0;PORTD.1=1;PORTD.1=0;
putsf("PIN1 was toggled");
j.
What is the AUTO SUM function in excel?
Autosum allows you to automatically insert the SUM function into a cell. It will then also automatically select a group of cells to add if there are cells with numbers in them nearby. If you do it at the bottom of a column of numbers, it will automatically select the ones above to sum and if you put it at the end of a row of numbers, it will automatically select the numbers in that row to sum. You still have the option of choosing a different range of cells to sum. Autosum also gives you the option to do other common operations such as MAX, MIN, AVERAGE, COUNT and COUNTA instead of using SUM.
SUM is the total of a range of numbers.
EXAMPLE:
=SUM(A1:A12) [Adds all of the numbers in cells A1 through A12.]
What is an active cell in Microsoft Excel?
It is the cell selected at the current time. If you start typing, what you type will appear in that cell. Only one cell can be the active one, even when you have lots of cells selected. It will always be a different colour to other selected cells if others are selected.
What are the default names of a new worksheet in Excel?
There are 3 sheets when you open a new excel worksheet and they are labelled Sheet1, Sheet2, and Sheet3.
Where is the formula keyed in spreadsheets for Excel?
In the cell and on the formula bar at the top of the screen, just below the menu bar or ribbon.
Give 5 functions of formulas in Excel?
Built-in formulas in Excel are known as functions. Here are five common ones:
SUM
AVERAGE
COUNT
MIN
MAX
In excel where a row and a column meet is called?
The area formed by the intersection of rows and column is called "cell".
Is Microsoft word and word processor are different?
There is no difference in the Ms. word and word processor. If you want to create a new document and edit the file. or paragraph spell chick and other feature option ave-able in the word document.
How would you remove only the contents of a selected row or column in Excel?
You highlight the row and then click Delete. You can also, after highlighting the row, go to the Menu under Format and there will an option to remove the row. If you goof, there is a two way circular arrow that you can click to undo the action.
How do you split single column to multiple columns in Excel?
A cell can be in only one row. You can add additional lines within a cell, by pressing ALT+Enter to start another line within the cell. If two cells in two rows had already been merged into one cell, then they can be split by turning off the Merge and Center option. That can be done in the Format Cells dialog, which you can quickly get by pressing Ctrl - 1. A single cell cannot be split any further.
How many arguments (input fields) does the COUNTIF function require?
Two, the range you wish to interrogate and the criteria on which to count.
=COUNTIF(A1:F30, 3)
For example, this would count every instance of the number 3 in the A1:F30 range. (Note this is a count function not a sum function, so it is not adding them up, but simply counting how many of them are present)
How do to rotate cells in Excel?
Cells themselves cannot be rotated. The content in a cell can be rotated. This can be done through the Orientation option, which is one of the alignment settings. Press Ctrl - 1 and you can get to the Format Cells dialog box and you can then go to the Alignment tab where you can do it.
What is the apple equivalent to Microsoft Word and Excel?
The closest equivalent would be Pages, although it doesn't have quite as many features as Microsoft Word.
Click on the Insert Sheet Rows button.
Why do you use a spreadsheet model?
Because you can experiment with figures to see what will happen in different situations. Businesses can use spreadsheets to see what happens if they run their business in different ways, like invest more money in one area of their business, or increase prices or produce more goods or whatever. By changing the numbers on the spreadsheet, it will immediately give them new totals or new statistics. They can create a model of what will happen if they do these things and see if it is good to actually do it for real.
If you have data on Sheet1 and Sheet2 that you want to display on Sheet3, do the following.
Assume you want to show B23 from both Sheet1 and Sheet2 on Sheet3. Go to Sheet3 to the cells where you want to display the data and enter the formulas in two different cells on Sheet3: =Sheet1!B23 and =Sheet2!B23
To reference another worksheet in the same workbook, preface the formula with the Sheet name (located on the tab below the worksheet -- you can change this name by right-clicking on the tab and changing name) and an exclamation point (!). In the example above =B23 would reference cell B23 on the same worksheet, but =Sheet!B23 will reference the cell B23 on Sheet1.
How are Microsoft Word Excel PowerPoint used in work environment?
Microsoft Word is used on a daily basis in the working world to document reports in the medical field, its used to create letters, flyers and notices in business offices, word is used in IT to create reports for networks, databases and other pertinent information. Most commonly used for business letters or flyers.
Can you sort more than one column at a time using Excel?
No, you can sort multiple columns or rows if you hightlight a range, but all columns or rows will need to be sorted with the same criteria (e.g. lowest to highest).
You can sort an entire row by clicking on the row number at the left of the screen, then sort, as desired. You also can do the same for columns by clicking on the column letter at the top of the screen.
How do you delete a character in a document?
To delete an incorrect character in a document, simply click next to the incorrect character and then press BACKSPACE to erase to the left of the insertion point. You can also click next to the incorrect character and click DELETE to erase to the right of the insertion point.
