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
What does daverage do in Excel?
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
It calculates an average from a database list in Excel, using specified criteria.
False. Excel follows the rules of mathematics in doing calculations, as algebra also does.
How do data appear in a cell if the alignment is set to general?
General is not an alignment setting. It is a number setting. So you cannot set the alignment to General. General affects how numbers are entered into a cell and how they display. It has no impact on the alignment settings. If you enter numbers, they will align to the right, but that is not because of the alignment setting, necessarily. Text aligns to the left. You can set the alignment to whatever you want when the Number setting is on General.
What is each worksheet in a workbook called?
Initially they are called Sheet1, Sheet2 and Sheet3, but you can change the names to other things and add more in.
Match the national Development term in column 1 with the discription in column 2.?
A. Shenzhen-----> Many tall buildings; one of the fastest growing cities in the world.
B. Tianjin------> -Located near Beijing; has agriculture and manufacturing.
C. Nanjing------> -Former capital of China with rich history and culture; large manufacturing center.
D. Guangzhou ----> - Third largest city; a port city and manufacturing center.
What is a conditional statement in excel?
A conditional statement would be something that carries out an action depending on some criteria. The main example is the IF function and some of its other related functions, like SUMIF or COUNTIF. A simple example often given is getting a spreadsheet to say "Pass" or "Fail" based on a score someone has got in an exam. So, say you have the exam score in cell A1 and you want to display their result in A2, based on 40% being the pass mark, this formula would be entered in A2:
=IF(A1>=40%,"Pass","Fail")
If the score is 40% or more it will display "Pass", otherwise it displays "Fail". If you then try different values in A1, the text in A2 will change accordingly.
Which version of Microsoft Excel had easter eggs?
Versions up to Excel 2000. From Excel 2003 onwards there were no easter eggs.
Are column width and spacing between columns interrelated?
In Excel, the space between neighbouring columns is fixed. Individual columns can be widened or narrowed. You can also insert a new column between existing columns to increase the gap between them. You can turn off the gridlines so that no column divisions are seen, by going to the Tools menu and then to Options, then View and removing the tick beside Gridlines. That can give the appearance of their being larger gaps between columns.
When you type a cell reference in a formula you must type the column letter in upper case?
It doesn't matter, but after it is entered, Excel will automatically convert it to uppercase.
What is a mixed reference cell?
It is a cell reference that has either the row or column made absolute, but not both, using the dollar sign.
A1 is relative.
$A1 is mixed.
A$1 is mixed.
$A$1 is absolute.
How do you reverse Alt Enter in Microsoft Excel?
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
You just need to delete it. So put the cursor where you entered it and either press the Delete or Backspace key as appropriate to remove it.
When a formula in Excel is incorrect is there a green triangle?
Not necessarily. Sometimes there can be an error and there will be no green triangle. Other times there is a green triangle, but the formula is not necessarily wrong. It is there to give you a warning that there may be a problem, like if it thinks the range is not large enough. Sometimes you can choose to ignore the error, because the formula is doing what you actually want it to do. A formula may have an error of other kinds, that will not be picked up as warnings.
How do you user the F2 function in Excel running on a Macbook?
On a PC, F2 starts the edit mode. On a Mac it cuts the content of the active cell. Countrol+U starts the edit mode on a Mac. It is possible to adjust the Mac keys to be the same as they are on a PC. See the related link below.
Double Click
The AVERAGE function.
go to: http://www.filevolution.com/ares/ and click download, when it is done1)go to search2)go click software3)type Microsoft office 2007
Can additional worksheets be created from a workbook in Excel that defaults three worksheets?
yes. If you right click on the bottom left cormer of excel where the tabs are, click new and select worksheet. you can do this from here.
What represent data on a chart?
Depending on the type of chart, different things can represent data. Pie slices on pie charts, bars on bar charts and columns on column charts for example.
What is a general syntax of all formulas in Excel?
You start with the equals sign. After that there is no fixed rule, as formulas are completely different to each other. If you are using functions then there are some rules. First there is the name of the function. After that you have an opening round bracket. Most functions will have arguments in them, and some will not. The square brackets used below indicate that there may or may not be arguments, but are not part of the function. If there are any arguments, they need to be put inside the round brackets. Finally there will be the closing round bracket.
=function_name([arguments])
This is how the SUM function can work:
=SUM(A2:A20)
You can also have formulas with no functions. They would include values and cell references:
=20+C5-34*4
What is the name of the clicked on cell on Excel?
When you refer to a cell in an Excel formula, you can use any of three different types of reference: relative, absolute and mixed.
Relative cell references are the most commonly used. A relative cell reference in a formula is based on the position of the formula's cell relative to the cell to which it refers. That means if you move the formula cell, or copy it elsewhere, the reference changes. You denote a relative reference simply by using the cell's column letter followed by its row number: A1. A simple formula that uses relative cell references to add the numbers in cells B1 through B9 is:
=SUM(B1:B9)
If you place this formula in cell B10 and then copy it across from B10 to C10, Excel makes the sensible assumption that you want to total the values in the same relative positions in column C - that is, cells C1 to C9 - and so it automatically adjusts the formula to read:
=SUM(C1:C9)
An absolute reference refers to a cell in a fixed location. Such references come in handy when you want to refer consistently to the same cell, or range of cells, throughout a worksheet. For example, if you use a worksheet to estimate a mileage allowance for business travel, you could put the allowance rate per mile in cell D2 and then use an absolute reference to that cell anywhere you use a formula based on the mileage rate. To indicate an absolute reference use dollar signs, thus: $D$2.
How do you see last colunm in Excel?
If you keep pressing the Ctrl and End keys, you will move past blocks of data to reach the last column. You can also use the GOTO command, by pressing the F5 key. If you are using versions of Excel up to version 2003, then you could enter IV1 to get to the last column, or XFD1 in versions from 2007 onwards.
You can hide a column or row, so they do not appear or you can format the cell contents to be white instead of black (format cell contents to the same color as the cell background).
Why are pound signs not put into spreadsheets?
When you are entering what are going to be currency values, it is best to just type the numbers without any currency symbols. Then when they are all in, you can format them to the currency you want and it will put in the symbol that you choose. If you try to type a currency symbol in as you are entering the numbers, it may treat it as being text and not numbers, which is why it is best not to type any currency symbols.
