Microsoft Excel Basics

It is where you will find the basic commands such as open, save, print, etc

• Quick Access Toolbar

• Ribbon

• File Menu

• Tell me

It is designed to help you quickly find the commands that you need to complete a task

• Quick Access Toolbar

• Ribbon

• File Menu

• Tell me

To select an entire column in a worksheet, you should press ________.

• CTRL+SPACEBAR

• SHIFT+SPACEBAR

• CTRL+SHIFT+SPACEBAR

• SPACEBAR

These are not to be used in calculations which includes numerical information, such as phone numbers and zip codes

• Values

• Labels

• Cell Address

• Relative Referencing

These are numerical pieces of information that will be used for calculations.

• Labels

• Cell Address

• Values

• Cell Address

A formula starts with an equal sign (=)

• True

• False

• Maybe

• Insufficient information

It returns the number of values of the selected cells

• SUM

• MAX

• MIN

• COUNT

If you to select non-consecutive cells, then

• Press and hold CTRL while clicking column or row headers

• Click and drag across column or row headers

• Click the first cell in the range. Drag across the cells and release the mouse button

• Press and hold CTRL while clicking the celss

If you to select multiple columns, then

• Press and hold CTRL while clicking column or row headers

• Click and drag across column or row headers

• Click the first cell in the range. Drag across the cells and release the mouse button

• Press and hold CTRL while clicking the celss

You use this category when you want to enter a text description containing numbers or special characters

• Number

• General

• Text

• Accounting