USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Formatting as a table will only add color bands to your headers and rows. A PivotTable turns your data into a 3D graph.
|
|
|
Formatting your spreadsheet as a table will format all of your data in a separate worksheet. A PivotTable creates a table within your worksheet.
|
|
|
There is no difference.
|
|
|
Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.
|
Detailed explanation-1: -There is no difference. Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.
Detailed explanation-2: -The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you. This topic does not explain how to use a data form to enter data in worksheet.
Detailed explanation-3: -The three types of data you can enter into a cell are data, labels and formulas. Data – values, usually numbers but can be letters or a combination of both. Labels – headings and descriptions to make the spreadsheet easier to understand. Formulas – calculations that update automatically if referenced data changes.
Detailed explanation-4: -Go to Insert > PivotTable. Excel will display the Create PivotTable dialog with your range or table name selected. In this case, we’re using a table called “tbl HouseholdExpenses". In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.
Detailed explanation-5: -The true advantage of cell references is that they allow you to update data in your worksheet without having to rewrite formulas.