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
When a cell is selected what is it called?
It can be referred to as the current cell or the active cell or just the selected cell.
You will be making changes to the Registry. It is recommended that you create a backup from your registry or system restore before following these steps: # Run registry editor by typing in regedit in the Run box from the start menu. # Find the following address: HKEY-CURRENT-USER \ Software \ Microsoft \ Windows \ CurrentVersion \ Policies \ System # Create a new DWORD with the value of 1 and:
a.) to disable ScreenSaver tab name it NoDispScrSavPage
b.) to disable Desktop tab name it NoDispBackgroundPage
c.) to disable Themes tab name it NoThemesTab
d.) to disable Setting tab name it NoDispSettingsPage
e.) to dsable Appearance and Themes tabs name it NoDispAppearance
f.) to disable Display Properties name it NoDispCpl
Is A worksheet is a page within a spreadsheet?
You could say that. A workbook contains multiple worksheets, with tabs at the bottom of the screen to allow you to select them.
What function determines the lowest number in a range in Excel?
The MIN Function is the main way. If you wanted to find the smallest value in the range from cell A2 to cell A20, the formula would be:
=MIN(A2:A20)
You can also use the SMALL function, though it is normally used for find values that are not the actual lowest, but other low values, like the second or third lowest. The number used at the end is number position from the lowest value. So to get the lowest value you would use it this way:
=SMALL(A2:A20,1)
What chart is a type of chart used to show the relationship or proportion of parts to a whole?
A pie chart can be used to do this. You could also use a stacked bar chart.
It is the reference to the cell formed where column B meets row 20.
Which type of chart is best for charting data that is a percentage of a whole?
a pie a pie chart compares from a whole known and 100.
Why would a salesman use a spreadsheet?
A salesman would use a spreadsheet as it is easy to arrange the data because there are column and rows.
Spreadsheet is the best software for offices. It is very easy to use, retrieve and store there.
What is a freeze pane in Excel?
If you have a large spreadsheet and scroll down, the upper lines will disappear. If you want a row to stay in place, for example the titles of several columns, you can "freeze" it. So when you scroll down, the uppermost line (for example) will always stay in place. This comes in handy if you have multiple columns.
How are data organised in spreadsheet?
You can organize data horizontally or vertically. You can use the data to create a chart to display the data. You can alphabetize the data list or sort in a variety of ways.
What is meant in a spreadsheet by the term variable?
A variable is a symbol that stands for a value that may vary.
It only changes if you edit a value of something else
For example, in the formula "=CONVERT(A2,"C","F")" (Convert cell "A2" from degrees Celsius to Fahrenheit), "C" and "F" are variables with specific meanings. As second variable could also be "C" or "F", it's value varies.
How many A2 sheets fit into A1?
A2 is larger than A3. An A1 sheet can be exactly divided into 2 A2 sheets, and A2 sheet can be exactly divided into to A3 sheets, etc.
What is the default file extension for an Excel 2010 workbook?
The default file ext for Excel 2010 default install is .xlsx as it was in 2007. 2003 was the last version with a different extension, which was .xls for workbooks.
Te default file ext may be changed by going into File-> Options -> Save -> Save in this format.
If there is a group policy in place, Excel will inherit the default file extension specified.
Why does the patient need to be assigned a chart number in medisoft?
Is another way of identifying a person; you could have two patients on Medisoft with the same or very similar name.
What do you do to emphasize a cell or make it stand out from the rest of the cells on Excel?
There are all sorts of simple formatting you could do. Change the colour of the cell. Change the colour of the contents. Bold the contents. Put it into Italics. Increase the font size. Underline it. Put a border around it. You could use any of these or a combination of them. You will find all of these options on the Formatting Toolbar or through the Format Menu and Cells.
What is included in Excel Function Library Group?
On the Formulas tab you have the Function Library group, which consists of the various categories of functions that Excel provides. You can click on one of these to open a category and find a function that you want to use.
What is the benefits using cell reference instead of cell values when creating a formula?
You can use the same formula for different sets of cells. If you had to type the values each time, you would have to retype the formula every time you want to use it for a different set of cells. But with relative cell references, when you copy a cell containing a formula, the cell references are updated automatically. For example, if the formula in A1 is =B1+C1 and you copy A1 to E5, the formula in E5 will be =F5+G5.
How do you write an OR statement in Excel?
The OR function contains at least two logical statements. If at least one is true, then it will return a TRUE result. If not, it returns a FALSE result.
=OR(10>2, 3>5)
Obviously 10 is greater than 2, so the above function will give a TRUE result. The OR function is usually used in conjunction with an IF function, to allow a particular action to be taken based on the result of the OR function. The OR function will be in the condition part of the IF function, which is the first part.
What key should be used to change the content of cell?
F2 Key, the 2nd function key on the top row of the keyboard
What is scale to fit in excel?
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
In Excel which format should you use in a formula to show a range of cells from B3 to H3?
The format will depend on the type of data. If they were dates you would use a different format than if it was percentages for example. You would put a formula into the cell and then format the cell as appropriate. Your formula itself would specify the range, by putting a colon between the two cells. So a formula to sum the values in the range would be:
=SUM(B3:H3)
Why the formula use in MS Excel?
it means a sequence of numbers and letters to send you to a specific location.
(I had this question as homework at school)
