Microsoft Excel and PowerPoint 2016 Lecture Notes

These flashcards cover key concepts related to Microsoft Excel and PowerPoint from the provided lecture notes.

What is Microsoft Excel primarily used for?

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

What are rows and columns in a spreadsheet?

Rows are horizontal lines of cells, and columns are vertical lines of cells used to organize and categorize data.

What types of calculations can spreadsheets perform?

Spreadsheets can perform simple arithmetic calculations as well as complex automated calculations and analysis.

What is the purpose of a spreadsheet in the accounting field?

In accounting, spreadsheets are used for preparing budgets, balance sheets, trial balances, managing cash flows, and payroll.

How can scientists use spreadsheets?

Scientists can use spreadsheets to perform statistical computations, calculate regression coefficients, and analyze data.

In what ways can data be graphically represented in spreadsheets?

Data in spreadsheets can be graphically represented using pie charts, histograms, line graphs, etc.

What is the function of a formula in Excel?

A formula in Excel is used to perform calculations using cell references, operators, and functions.

What is the difference between relative and absolute cell references?

Relative references change when a formula is copied to another cell, while absolute references remain constant regardless of where the formula is copied.

What is the significance of the AutoComplete feature in Excel?

The AutoComplete feature allows users to easily enter repeated text items without retyping them.

How can you create a new presentation in Microsoft PowerPoint?

You can create a new presentation in PowerPoint by selecting 'New' then 'Blank Presentation' from the File tab or using a template.

What is the purpose of placeholders in PowerPoint slides?

Placeholders are areas on a slide that contain text or other elements and provide formatting structures for content.

What are themes in PowerPoint, and how do they function?

Themes in PowerPoint are predefined combinations of colors, fonts, and effects that enhance the visual appeal of presentations.

How can animation effects be applied to text and objects in PowerPoint?

Animation effects can be applied by selecting the text or object, choosing the Animations tab, and selecting an animation from the available options.

What is the default view in PowerPoint for creating and editing slides?

The default view for creating and editing slides in PowerPoint is called Normal View.

How do you print a PowerPoint presentation?

To print a PowerPoint presentation, select the File tab, then Print, and choose your print settings before clicking the Print button.

What is the function of the slide sorter view in PowerPoint?

Slide sorter view displays miniature slides allowing you to easily reorder slides in your presentation.