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
Which keys must be pressed to insert an uppercase k at the insertion point?
An insertion point is the flashing line which indicates where you will be typing. Therefore, the keys that would be pressed are the 'k' key, and the shift key.
In Excel what is the difference between filtering and sorting?
Sorting put data in order, like alphabetical order or date order or numeric order etc. Filtering excludes some data so you see just what you want. You might want to show dates from a certain year or numbers over a certain value or particular product names. You can define the filtering criteria that you want.
How do you change the width if multiple column to have equal width?
Select all the columns you want to adjust the width for. Then through the menu or ribbons set the column width that you want. It will be applied to all of the selected columns.
Which situation use in hlookUP function in excel?
If you want to look up data that has been laid out in a horizontal manner. Vlookup is for vertical data. See the related question below for more information.
Banded Rows
you just need to enclose your equation like this:
\begin{figure*}
\begin{equation}
%
%
\end{equation}
\end{figure*}
Which type of object can be created directly in Excel?
A chart is the type of object that can be created directly in Excel.
What is the code that Excel enters in a header or footer when the Sheet Name button is clicked?
&[Tab] is the code that is used.
Advantages of using Word over Excel when creating tables?
Word has specific facilities to create tables, which Excel does not. Excel is already in a tabular format, with its columns and rows, but Word allows you to do a table of a specific amount of rows and columns. It will also automatically allow you to have borders on it. If your table is purely for text, then Word is better. Word can do calculations in tables, something many people do not realise, but Excel is better for doing them. You can copy and paste a table with calculations from Excel into Word. You can then use Word to add some extra elements in formatting. Word is good for having more formatting for text that you may have in a table. If you want to mix a table with large amounts of text, such as having a report that includes some tables in it, then Word can deal with that very well. You can position the table within the document in whatever way you want. By just having some borders showing, you can use Word's tables facility to design different kinds of diagrams and charts that have a structured layout. So unless you have a large amount of numbers and calculations in your table, Word is a better option than Excel.
When you save a workbook with external reference formulas, Excel will save the most recent results. When the file is next opened, it will update itself based on the other files.
What is the default file for Excel file?
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
The default file is Book1 when you start. The extension is .xls for versions of Excel up to 2003 and from version 2007 onwards it would be .xlsx as the extension.
How do you switch the worksheet back to Normal view?
Go to the view section and click on normal view.
What organizations use spreadsheets?
Just about any organisation you can think of can use spreadsheets. Thousands and thousands of them, all around the world, so it would be impossible to list them all.
What format can you use to change a text from calibri to arial?
The format you can use to change a text is called font.
Click on "insert" tab, click shape, find arrow you want to add and select it. Right click on the shape (after you've added it), format shape.
When do you use with a cell address in Excel?
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
What is pivet table and how to chart it?
A pivot table is used to summarize a spreadsheet full of data. It is a tool that enables quick and simple summary and analysis of the data. Once you've created the pivot table you can create a chart using the "insert>chart" command.
If you use a function alone it always begins with the formula prefix?
All formulas in Excel must begin with the equals sign, and that includes ones that just use functions. Without the equals sign, it will be treated as a piece of text.
Armstrong numbers are the sum of their own digits to the power of the number of digits. Here are all the possible Armstrong Numbers up to six digits:
1, 2, 3, 4, 5, 6, 7, 8, 9, 153, 370, 371, 407, 1634, 8208, 9474, 54748, 92727, 93084, 548834
EXAMPLE: 153 = 13 + 53 + 33
Sometimes, the simple solutions are better than complicated elegant solutions. Just compare your number to the list. If your number is on the list, it is an Armstrong Number.
Designing a spreadsheet formula to compare all numbers 1-6 digits to determine if they are one of twenty possible numbers does not make sence. However, in the spirit of education (even though using this solution does not pass the common sense test), here are two methods you can use to solve this problem.
SOLUTION #1 (easy): Compare against a look-up table.
=IF(ISERROR(VLOOKUP(A1,C1:C20,1,FALSE)),"No","Yes")
- Reserve A1 for entry of the number to be evaulated.
- In B1, enter this formula: =IF(ISERROR(VLOOKUP(A1,C1:C20,1,FALSE)),"No","Yes")
- In column C (C1:C20), enter the first twenty Armstrong Numbers [see list above].
- Enter a number in A1 and observe "Yes" or "No" in B1.
SOLUTION #2 (difficult): Brute force calculation.
=IF(LEN(F1)=6,IF(MID(F1,1,1)^6+MID(F1,2,1)^6+MID(F1,3,1)^6+MID(F1,4,1)^6+MID(F1,5,1)^6+MID(F1,6,1)^6=F1,"Yes","No"),"Not 6 places")
Here is an example for 6-digit numbers (use the same procedure for other size numbers or write a macro that will count the characters and loop through as many times as necessary):
- Reserve A1 for entry of the number to be evaulated.
- In B1, enter this formula:
=IF(LEN(F1)=6,IF(MID(F1,1,1)^6+MID(F1,2,1)^6+MID(F1,3,1)^6+MID(F1,4,1)^6+MID(F1,5,1)^6+MID(F1,6,1)^6=F1,"Yes","No"),"Not 6 places")
- In B1, observe "Yes" or "No" (if you have not entered a 6-digit number, you will see "Not 6 places.")
