KFCP-Excel 1 - Demo

A spreadsheet developed by Microsoft for Windows, macOS, Android and iOS to features calculation, graphing tools, pivot tables, and a macro programming language.

• Google Sheet

• Tableau

• MS Excel

• OpenOffice Calc

Study the screenshot above. What function does this represent? Choose the most correct option.

• This is a Pivot Table Chart.

• This is a Pivot Table Filter.

• This is a Pivot Table Report.

• This is a Pivot Table.

What is a Pivot Table?

• A table containing data that is organized horizontally.

• A table used to calculate financial pivot values.

• A tool used to summarize data.

• A table containing only black, grey and white formatting.

Study the screenshot above. Under which tab and in which function group will you find the option to insert a Pivot Table?

• Under the Formulas tab in the Data Analysis group.

• In the Data group in the Pivot Tables group.

• Under the Insert tab in the Tables group.

• In the Data group in the Tables group.

Where is a Pivot Table inserted?

• Next to the last column of data in your worksheet.

• Below the last row of data in your worksheet.

• It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.

• Above the first row of data in your worksheet.

Which of the following is NOT a box in the PivotTable Fields List?

• Column Labels

• Formulas

• Values

• Report Filter

What is the first step for creating a Pivot Table?

• Clicking on the Insert Tab and inserting a Pivot Table.

• Deciding on which fields (column and row labels) to use to analyze the data.

• Create or select data that needs to be analyzed.

• None of the above options are correct.

Study the screenshot above. The tabs circled in yellow are not ordinarily visible. What do you need to do in order to access these tabs and the functions they contain?

• These are called contextual tabs. To display them click on the Pivot Table tab on the Ribbon.

• These are called PivotTable Tools tabs. To display them tick the PivotTable Tools tick box in the Tables group.

• These are called contextual tabs. To display them click anywhere within a Pivot Table.

• These are called PivotTable Tools tabs. To display them hover your mouse above the normal tabs on the Ribbon.

The Sum function is applied to values in a Pivot Table by default. How can I change this so that values are automatically counted and not summed?

• Change the format of the values in the Pivot Table to General Numbers.

• In the Calculations group, change the Summarize Values By to Count.

• Insert the COUNT formula (=Count()) into the PivotTable.

• All of the options listed above are correct.

After inserting a Pivot Table, the Pivot Table Field List does not automatically appear. How can you activate this area?

• Click on the Insert Pivot Table button and select PivotTable Fields List.

• Go to the Backstage View and in the Options dialogue box, click on the PivotTable tab. Check the box for PivotTable Fields List.

• Click on the Field List button in the Show group, under Options in the PivotTable Tools contextual tab.

• All of the options listed above are correct.