ENGR1412 Excel Basics

ENGR1412 Excel Basics - have Cells Data or Formula Cells...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel - Basics and Lab#1 Toolbars Right-clicking the mouse while in the region next to your toolbars brings up a list of all available Toolbars (this also works in most Microsoft programs, and many other programs as well). Menu Bar Toolbars Standard and Formatting toolbars shown Formula Bar Cell Name Box
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Cell Properties Formatting effects all selected cells. An example of changing the background of a group of cells to a light blue color is shown. Font type, font size, cell alignment, numerical format, bold, italic, underlines, etc are a few of the numerous cell properties (nearly all of these are available on the menu bar under the name Fo rmat or by using the Format toolbar shortcuts. Don’t forget, “right-click” is what? Right-clicking provides the most common shortcuts or options, the user might want to
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: have. Cells: Data or Formula. Cells can contain data (information, fixed values unless changed from the keyboard or by a VBA program/code). Editing of cell contents can be done in the cell or on the formula bar . The “=” denotes the beginning of a formula (tells Excel to evaluate the expression to the right of the equals symbol and show the result in the cell). Editing of cell contents can be done in the cell or on the formula bar . Built-In Functions: What are these? Well, the often used mathematics functions are available (sin, cos, log, ln, exp, etc) and many others (overall, there are something around 1,000 pre-built functions available for use). Clicking on the f X symbol on the formula bar provides this dialog box. Take a look around in there, there are a large number of very useful things....
View Full Document

Page1 / 4

ENGR1412 Excel Basics - have Cells Data or Formula Cells...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online