Microsoft Excel Overview

These flashcards cover fundamental concepts, features, and functions of Microsoft Excel to help in exam preparation.

What is Microsoft Excel primarily used for?

To enter and organize data in a computer spreadsheet program.

What is the difference between a workbook and a worksheet in Excel?

A workbook is an Excel file that contains multiple worksheets.

What is a cell in Excel?

The intersection of a column and a row; cell address can be seen in the name box.

What are the 7 command tabs in Excel?

Home, Insert, Page Layout, Formulas, Data, Review, and View.

What does the Office button in Excel do?

Used to create new workbooks, open and save workbooks, and print documents.

How is text aligned in an Excel cell?

Text is aligned to the left.

What symbol is used for addition in Excel formulas?

The plus sign (+).

What is relative cell referencing?

Any cell with formulas that adjusts automatically when copied to a new location.

What does absolute cell referencing involve?

It involves assigning specific cell addresses using a dollar sign, e.g., =$E$4*B8.

Name one method to view formulas in an Excel worksheet.

Press Ctrl + ` or click Formula > Show Formula.

What types of functions does Excel offer?

Financial, Date & Time, Mathematical & Trigonometric, Statistical, and Logical functions.

What is the purpose of creating charts in Excel?

To provide a graphical representation of data in a worksheet.