Answer:
There are five work sheets in this excel file, they are equipment, company, company, person and computer. Excel worksheets are made up of cells, with the columns labelled alphabetically and the rows numbered.
Explanation:
The columns of a worksheet is called a field while row are called records. They are used to locate a cell in the worksheet. There are so many statistical, mathematical and engineering functions in excel. It is used to display the analysis of data.
The normal margin is 1 inch on all sides
I would say C- Priority List.
I hope this helps! :)
Before you create a pivot table, it is important to <em><u>Create a database</u></em>.
Option: A
<u>Procedure to create Pivot Table:
</u>
1. Select the cells and table in the sheet containing the data you want to use.
2. Go to the Insert tab and click the PivotTable command.
3. In the dialog box ‘Create PivotTable’ will appear. Choose your settings, then click OK. In our example, we will use Sheet1 as our source data and insert the PivotTable on a new worksheet.
4. The Field List and blank PivotTable will appear on a new worksheet.
5. Once you create a PivotTable, you have to decide which fields to add. Each field has a simple column header from the source data. In the PivotTable Field List, check the box for each field you want to add.
6. The selected fields will be added to one of the four areas below the Field List. In our example, the Salesman field has been added to the Rows area, while the Order Amount has been added to the Values area. Alternatively, you can click, hold, and drag a field to the desired area.
7. The PivotTable values will calculate and summarize the selected fields. In our example, the PivotTable shows the amount sold by each salesman.
Answer:
Yess the answer is correct
Explanation:
