MS Excel Terms To Be Familiar With

Tweet

1.Workbook – file you work and store data

2.Worksheet – single page of workbook

3.Worksheet cell – intersection of row and

                       Column

4.Range  - group of worksheet cells

5.Column – fundamental part represented

                       by letters that runs vertically in

                       worksheet

6.Row – fundamental part represented by

                       numbers that runs horizontally

                       in worksheet

7.Cell Pointer – black border locating the

                       active cell.

8.Fill Handle – small black square at lower

                       right corner of cell pointer

                       used to copy cell content

EXCEL NUMBER OF ROWS & COLUMNS

In Excel 2007 & 2010 the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384 which is column XFD. That makes 17,179,869,184 cells. Excel 2010 has the same amount or rows and columns.

RIBBON

Ribbon - Commands that are more clearly visible and more readily available in one control center.

The three parts of the Ribbon are tabs, groups, and commands.  

Tabs: Tabs represent core tasks you do in Excel. There are seven tabs across the top of the Excel window.

Groups: Groups are sets of related commands, displayed on tabs.

Commands: A command is a button, a menu, or a box where you enter information.   

The Excel Mathematical Operators and the order in which they are evaluated are shown in the table below:

Operator	Action	Precedence (1=top; 3=bottom)
^	The power operator	1
*	The multiplication operator	2
/	The division operator	2
+	The addition operator	3
-	The subtraction operator	3

Excel Common Functions

Introduction

A function is a formula that is already created by Excel.  It can be used to perform a calculation on the data in your worksheet.

Common Functions

Here's a list of the common functions built into Excel.  There is also a description on how to use them.

Sum

What does it do?  Adds a list of numbers.

How do you use it?  =SUM(A1:A4)

This will add cells A1, A2, A3, and A4 and send the results to where you place the formula.

Average

What does it do?  Calculates the average of a list of numbers.

How do you use it?  =AVERAGE(A1:A4)

This will add A1, A2, A3, and A4 and divide it by four.  If you have more or less cells than what is listed, it will divide the sum of the cells by the number of cells.

Max

What does it do?  Find the largest value in a list of numbers.

How do you use it? =MAX(A1:A4)

This function will print the maximum value of the cells in the formula.

Count

What does it do?  Calculates the number of values in a list.

How do you use it?  =COUNT(A1:A4)

This function will calculate the number of values in the cells A1, A2, A3, and A4.

Min

What does it do?  Find the smallest value in a list of numbers.

How do you use it?  =MIN(A1:A4)

This function will print the smallest number of cells A1, A2, A3, and A4.

Round

What does it do?  Rounds a value from a cell to a specific number of digits.

How do you use it?  =ROUND(A1,2)

This function will take the value of A1, round it to 2 decimal places, and print the modified value into the cell where you have put this function.

Note:  All the cell names and other data in the functions can be changed.  We have shown them as they are just to give an example.