Computer Skills - Excel 3, Advanced

you added data to your source table and want to integrate them into an existing PivotTable, how do you do that

• use the CHANGE DATA SOURCE function in the ANALYZE tab, from there select the new table/range

• use the expand function in the analyze tab, it auto adds new records

• delete the existing PivotTable and make a new one

if you want to change the calculation function in a PivotTable, where do you do it

• filters

• values

• formulas

with which function is the subtotal of a PivotTable calculated by default

• count

• average

• sum

your PivotTable is a clumn chart and you want to turn it into a bar chart, where do you go

• in the FORMAT tab of the PivotTable tools

• in the FORMAT tab of the PivotTable tools in the group TYPE

• in the DESIGN tab of the PivotTable in the group TYPE

you have a table of the sales figures per branch and product, to better analyze the info you make a PivotTable. how do you do that

• INSERT tab, PivotTable, select data, activate option EXISTING WORKSHEET, click on LOCATION then on the cell where the PivotTable should be placed

• xx

you have grouped data from a PivotTable and want to undo the grouping, is that possible

• yes, rearrange the feilds by drag-and-drop to undo the grouping

• yes, click the group heading and select UNGROUP

• its not possible, must make a new one

which statements about a 'timeline' in Excel are true?

• a timeline is a filter which can be added to a PivotTable

• a timeline is a chart which can be added to a PivotTable

• you can adjust the interval of a timeline

what can you do using field buttons displayed in a PivotChart

• delete elements from a field

• filter the elements of a field

• duplicate elements of a field

what options does Excel have to update/change data in a PivotTable

• Automatically upon opening the file

• manually via the list box REFRESH in the ANALYZE tab of the PivotTable TOOLS

• Automatically upon saving the file

when are report layouts used

• to quickly modify the layout of a PivotTable

• to quickly modify the layout of a PivotChart