Presentation Skills

Please provide your name

1. Under which Excel menu/tab can spin buttons, scroll bars and options buttons be found?

Data menu/tab Developer menu/tab Automate menu/tab Formulas menu/tab

2. Which one of the following questions should specifically be asked when making sure you understand the audience while planning for a presentation?

How much does the audience already know about the subject? How should I ensure that I reach my goal? Which areas of this subject are the most important? What is my specific expertise on this subject?

3. How will a linked textbox be entered into Excel?

Activate the Draw menu/tab, use the line tool to draw a textbox, then specify that the textbox contains text Click on the Developer menu/tab, then on insert, and then choose Linked Textbox from the menu Use Visual Basic coding to programme inserting a textbox linked to an underlying cell Insert a textbox, click on the border of the textbox, type = and the cell link in the formula bar

4. Which one of the following statements is NOT true regarding your PowerPoint slides for a presentation?

A presentation should have long-winded sentences, or dense and wordy content Slides act as a visual summary to the audience and a reminder of your most important points When available, add diagrams or pictures, and rather opt for graphs or charts instead of words If calculations are shown, make sure the audience can follow

5. Which chart can show the cumulative effect of data, and also allows for a column to be "set as total"?

Treemap Waterfall Chart Sunburst Chart Histogram

6. Which one of the following is true regarding best practice during the presentation?

Actively engage with the audience and project enthusiasm for your topic Do not use hand gestures or make eye contact with audience members You can stand in front of the screen while presenting, or turn your back on your audience No note cards with bullet points are allowed during a presentation

7. What is a radar chart most often used for?

To show proportions of data relating to the whole To show the movements in share prices To show the steps of rate changes per day To show the comparison between two variables

8. Which one of the following is NOT true regarding handling the question and answer session?

It is impossible to prepare for any questions before the presentation Give relevant examples and supporting facts to motivate answers Listen to the question carefully, and clarify the question if needed Answer the question accurately and concise, and invite participation

9. Which one of the following combo charts can be used to show the progress of a project?

Gauge Chart Band Chart Sunburst Chart Scatter Chart

10. Which one of the following statements is NOT true regarding PivotTables and Pivot Charts?

Not all of the Excel charts will be available as Pivot Charts Slicers can be used to visualise and present the data in Pivot Charts Data within PivotTables are compatible with Treemaps and Sunburst charts PivotTables can be used to organise large data sets before visualisation