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 do you reserve for a spreadsheet title in Excel?
You can give your spreadsheet any title you like. There is nothing in a spreadsheet that is exclusive to a title. Usually, people like to reserve the first row for the location to place a spreadsheet title.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
It is a relative cell reference.
How do you reference SIGN guideline?
To reference the SIGN (Scottish Intercollegiate Guidelines Network) guidelines, include the authoring body, year of publication, title of the guideline, and the publication number. For example: Scottish Intercollegiate Guidelines Network. (Year). Title of the guideline. SIGN publication number. Available at: URL (if accessed online). Ensure to follow the specific citation style required (e.g., APA, MLA, etc.) for formatting details.
How do you create a freqency table in excel?
You need your actual values that you are getting your frequencies from first. Then you need a table of the category ranges that you want to get the frequencies within, such as having 10, 20, 30 etc., to see the amount of values within each range. Arrange these in a column. Then select the blank cells beside that column. With those blank cells still selected, in the first of them start the formula by typing =FREQUENCY( and then select the cells that you are trying to get frequencies for. Then press the comma key and then select the range with the categories. Then press the ) key. Then press Ctrl - Shift and Enter and the formula will fill out into the selected cells.
What is the reason to create an everything i know chart before reading?
To organize your thoughts and questions before reading a text
An excel workbook has the file extension xmlx?
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
No. It has xls for versions up to 2003 or xlsx for versions from 2007 onwards.
When dragging the fill handle what activates the auto-fill feature in excel?
It will copy the formula to other cells. If the cell references are relative, they will change. If they are mixed, they may or may not change, depending on which way the cells are referenced and the direction the cells are being filled. If they are absolute, they will not change.
What is the round function in excel used for?
ROUND is a function that returns a number rounded to a specified number of digits.
Syntax: =ROUND( number, digits )
number is the number to round
digits is the number of digits to round the number to
EXAMPLES:
=ROUND(1/3,2) will return 0.33
=ROUND(1/6,2) will return 0.17
It is hard to describe a pivot table in a simple manner, without showing one. It is a good reporting tool which can sort, sum and count data, amongst other things, independent of the original data. It is a way to extract data from a long list of information, and present it in a readable form.
So you could have a list of data, with common types of information that you want to analyse more clearly and do things like get totals from it and subtotals, and count values and so on. You could use your list and with its data create a pivot table. You would still have the original data and then also have the pivot table. Once you have it you can manipulate it quickly in lots of ways, to get all sorts of information from it.
You could have something like a list of salesmen who work in a number of different areas and sell different kinds of products. There could be more than one in each area, and more than one selling each kind of product. You might want to find out things like how many of each product was sold in total, or how much money was made from all sales in one area, or how many salesmen sell each product. There are all sorts of things that a pivot table will allow you to do very quickly and allow you to change very quickly.
To create one, first you need you list of original data. Then you would select that data, and go to the Data menu. There you will find the options for creating the pivot table. Excel will give a little assistance in the process of creating one. They are a bit complicated to start with, but with a bit of practice, you will get used to using them and know how and when to use them. Check out the link below from Wikipedia which has a simple example on it. You will also find help in Excel itself and there are lots of resources and examples on the internet about them.
Conditional formatting means that a cell will be formatted differently based on values. So when values change, the formatting may changed. Formatting will not be suppressed, just changed, which is the whole point of conditional formatting.
How do you tell if the worksheet has a hidden row?
Look at the row numbers to the left of the screen. If there are gaps in the number sequence (e.g. 1 2 3 7 8 9), the numbers that are not displayed represent hidden rows. In this example, rows 4, 5, and 6 are hidden.
What ribbon tab do I use if I need to insert a footnote to cite a quotation in my research paper?
To insert a footnote in your research paper, use the "References" tab in Microsoft Word. Within this tab, look for the "Footnotes" group, where you can click on "Insert Footnote." This will automatically add a footnote at the bottom of the page for your citation.
Allows you to create or modify a worksheet while viewing how it will look in printed format?
Which view allows you to create or modify a worksheet while viewing how it will look in printed format.
Correct Answer:Page Layout View
The Page Layout View
How do you insert sheet In Excel?
What i would do is make a topic,put a place to put a child's name and make some problems for them to do based on their grde level. Here's an example.
Name______________ Math Doubles
Answer the problems.
1. 6+6=___
2. 5+5=___
3. 3+3=___
What are 5 common business uses for electronic spreadsheets?
Forecasting how a business might do in the future.
Calculating tax.
Doing basic payrolls.
Calculating Revenues.
Producing charts.
--Going past 5--
Inventory tracking
Very (VERY) basic CRM for small businesses
Many free tools are available which leverage the versatility of spreadsheets. See related links for a handful that come to mind:
Will the Sparklines inside Excel update if the data is changed in the worksheet?
Yes, when data is changed in worksheet, sparklines automatically update. There are three types of sparklines: line, column and win/loss.
What does format mean in Excel?
When you format a cell in Excel, you change the appearance of a number without changing the number itself. You can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).
You can save Excel in many different formats. To save as HTML you select File|Save As. When the Save As window opens, look toward the bottom of the window for the "Save as type:" drop down. From the drop down selection click on "Web Page (*.htm; *.html). Navigate to the location in the Documents Library where you want to save the file, type the file name you want in the "File name:" box, and click the Save button at the bottom right of the Save As window.
See response in the "Expert box."
How can you show only specific data on a worksheet in a workbook?
It depends on what you are trying to do. Here are some ways you can show specific data:
- Delete the data you do not want to show.
- Hide the row or column of data you do not want to show.
- Change the font color to the same color of the cell background (usually white).
- Put your calculations and data on one worksheet and display the results on another worksheet. You then can hide the worksheet you do not want anyone to see.
Might pasting in excel with relative references ever produce the wrong result?
Yes. It depends on the formula and what you want the formula to do. So it is easy to have the wrong formula and paste it, or have the correct formula initially, but when it is pasted elsewhere it does not use the correct values. Normally if you have your worksheet set up correctly then once the initial formula is correct, pasting it to the right place should not cause any problems.
What is the purpose of the adjustments column in the worksheet?
The purpose of the adjustments column in the worksheet is for the necessary adjustments for supplies and pre-paid insurance. It is also used the adjustment of merchandise inventory accounts to begin a new fiscal year.
Which key do you press to group two or more nonadjacent worksheets?
You use the Ctrl key with the mouse to do it.
A workbook with 12 worksheets would be saved as how many files?
It would depend on how much data was on the sheets and if they were related. Normally, yes.
What is used to move down one cell in an Excel 2010 worksheet?
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
The down arrow key.
Can embedded chart be moved by dragging?
To resize or move an embedded chart, select the chart. To resize it, position or point the mouse to a sizing handle. The pointer will change into a double-headed arrow which can be used. To move the chart, simply drag the chart to a chosen blank area on selecting.
