Microsoft Excel and PowerPoint 2016 - Lecture Review

These flashcards cover essential concepts from the Microsoft Excel and PowerPoint 2016 lecture, focusing on functionalities, features, and usage tips.

What is Microsoft Excel commonly used for?

Microsoft Excel is commonly used as a spreadsheet application for storing, manipulating, and analyzing data.

What functionalities can spreadsheets perform?

Spreadsheets can perform arithmetic calculations, complex data analysis, and graphical data representation.

Name one advantage of using formulas in Excel.

Formulas automatically recalculate results when cell values change.

What are the types of cell references in Excel?

The types of cell references are relative, absolute, and mixed references.

How do you start the Microsoft Excel application?

You can start Excel by clicking the Start button, locating Excel, and clicking on it, or by using a desktop shortcut.

What is the purpose of the formula bar in Excel?

The formula bar displays the formula in a selected cell and allows users to edit the formula.

What is a characteristic of a pie chart?

A pie chart shows the contribution of each value as a percentage of the whole.

What does the AutoSum feature in Excel do?

AutoSum automatically adds up a range of cells.

What is a SmartArt graphic in PowerPoint?

SmartArt graphics are visual representations of information and ideas that can be used to enhance slides.

How do you insert a new slide in PowerPoint?

Click the New Slide button in the Slides group on the Home tab.

What is the difference between animations and transitions in PowerPoint?

Animations refer to the effects applied to objects within a slide, while transitions are effects applied when moving from one slide to another.

How can you protect a workbook with a password in Excel?

You can protect a workbook by going to File, Info, and selecting Protect Workbook, then choose 'Encrypt with Password'.