0
What function would you use to find the mean in a Microsoft Excel document?
Wiki User
∙ 10y ago
The AVERAGE function returns the average (arithmetic mean) of the numbers provided.
=AVERAGE(number1,number2,...number_n)
number1, number2, ... number_n are numeric values. They can be numbers, named ranges, arrays, or references to numbers. You can enter up to 30 values.
Wiki User
∙ 14y ago
Wiki User
∙ 10y agoYou would use the AVERAGE function.
Add your answer:
Earn +20 pts
How would a linked Excel Worksheet and Chart enhance a Word document?
The benefit of linking a chart from an Excel worksheet to a Word document is that the chart data will always be current. Excel is spreadsheet software from Microsoft.
Is an external Excel spreadsheet linked to a Word document a compound document?
Is an external excel spreadsheet linked into a word document considered a compoound document in the microsoft enviroment?
How do you answer interview questions about Microsoft office skills?
Certainly! Here are some interview questions related to Microsoft Word and Microsoft Excel that you might excel interview encounter during an interview: Microsoft Word Interview Questions: What is Microsoft Word used for, and how have you used it professionally? Explain the difference between "Save" and "Save As" in Microsoft Word. How would you create a bulleted list in a Word document? What is Track Changes, and how can it be useful in collaborative document editing? Describe how you would insert a table into a Word document. How can you change the page orientation from portrait to landscape in Microsoft Word? What is a header and footer in Word, and when might you use them? How would you adjust line spacing in a Word document? What is a mail merge, and how can it be used to personalize documents? Explain how to add page numbers to a Word document. Microsoft Excel Interview Questions: Why is Microsoft Excel important in the business context, and how have you used it professionally? Explain the purpose of cells, rows, and columns in Excel. How can you format cells to display currency values with two decimal places? What is the difference between a worksheet and a workbook in Excel? Describe how you would freeze panes in an Excel worksheet. How do you create a chart in Excel to visualize data? Explain the concept of relative and absolute cell references in Excel formulas. What is the SUM function, and how would you use it to add a range of numbers? How can you sort data in Excel based on a specific column? Explain what a PivotTable is and how it can be useful for data analysis. Remember that interview questions can vary based on the specific role and level of proficiency required for the job. Practice and familiarize yourself with these concepts to confidently address these questions during your interview.
What does today mean in Excel?
The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.
How do you use the REPT function in Microsoft Excel?
The REPT function repeats a piece of text a set amount of times. =REPT("A",4) The above function will repeat the A four times. The result would be: AAAA
What would you use the Excel Viewer for?
Microsoft Excel Viewer is a program that lets one view and print spreadsheets that were created in Microsoft Excel. The beauty of this program is that one can view the spreadsheets without having to have Microsoft Excel installed on one's computer.
Is inventorywpd a Microsoft Access document?
No. A wpd extension is not one from Microsoft Access. It would be a word processing document.
How do you create a documentation sheet in a workbook in Microsoft Excel?
That depends on what you mean by a documentation sheet. Excel can be used to lay out printed documents, though it is often better to use something like Microsoft Word. Although you can do tables in Word, sometimes Excel can be used to create structured document layouts in a simpler way.
When would you choose Microsoft Excel over Microsoft Word?
When creating spreadsheets or statistical papers.
Why must print titles in Microsoft Excel be contiguous and complete rows or columns?
Because that is the way Excel is designed. I suppose the programmers could have added a section to allow user configuration, but I suspect there was not much of a demand for that function. If you feel that is an important feature you would like to see in the next version of Excel, let Microsoft know. See related link for where you can send your product suggestions to Microsoft.
Is Microsoft Excel system software?
No. It would be applications software.
Can Microsoft Excel table be inserted into a Microsoft Word document?
If you are just talking about importing text then yes. On Microsoft Word you just highlight you text then copy it or (ctrl c) then you go to Microsoft Excel and paste it or (ctrl v). If that doesn't answer the question be more specific because that is how I interpreted your question.
