Microsoft Office Excel is used to store data and crunch numbers in all types of businesses. The spreadhseet program's power lies in Excel functions and Excel formulas, which allow all sorts of data analysis, from simple sums to standard deviations. Consider this Cheat Sheet your quick and easy Excel tutorial. Excel Functions You're Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function. Excel Function| Description|

SUM| Calculates the sum of a group of values|
AVERAGE| Calculates the mean of a group of values|
COUNT| Counts the number of cells in a range that contains numbers| INT| Removes the decimal portion of a number, leaving just the integer portion| ROUND| Rounds a number to a specified number of decimal places or digit positions| IF| Tests for a true or false condition and then returns one value or another| NOW| Returns the system date and time|

TODAY| Returns the system date, without the time|
SUMIF| Calculates a sum from a group of values, but just of values that are included because a condition is met| COUNTIF| Counts the number of cells in a range that match a criteria| Excel Text Functions You'll Find Helpful

Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description of what each function does: Function| Description|

LEFT| Extracts one or more characters from the left side of a text string| RIGHT| Extracts one or more characters from the right side of a text string| MID| Extracts characters from the middle of a text string; you specify which character position to start from and how many characters to include|...

...Microsoft Excel: Formulas, Formulas...
Northern New York Library Network 6721 US Hwy 11 Postdam, NY 13676 877-833-1674 or 315-265-1119 www.nnyln.org
Jim Crowley C3 - Crowley Computer Consulting 9148 State Highway 37 Ogdensburg NY 13669 315-394-7008 fax 315-394-7009 www.crowleycomputers.com jim@crowleycomputers.com
Description: Excel has hundreds of functions and nobody knows them all, but spend some time and learn to create more powerful formulas. Students will dive into decision making functions like if() and lookup() and make Excel work for them! Students will also explore efficient use of multiple sheets in a workbook, creating multi-sheet and multi-workbook formulas. Students will learn about: if() functions, lookup() functions, conditional formatting, and using multiple worksheets in a workbook. 1. Course objectives. a. To provide the class with an exploration of spreadsheet design. b. To develop computer and spreadsheet literacy. c. To address the class' questions. Schedule a. 9:00 Registration b. 9:30 Morning session c. 12:00 Departure Handouts available in Adobe Portable Document Format (PDF) for download at www.crowleycomputers.com/handouts.htm
2.
3.
1.
Formulas: All formulas begin with = or basic math function a. Simple operators Monthly weather (1) +...

...Option Explicit
'Main FunctionFunction SpellNumber(ByVal MyNumber)
Dim Rupees, Paisa, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
' String representation of amount.
MyNumber = Trim(Str(MyNumber))
' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")
' Convert Paisa and set MyNumber to Rupee amount.
If DecimalPlace > 0 Then
Paisa = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
"0", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber <> ""
Temp = GetHundreds(Right(MyNumber, 3))
If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Rupees
Case ""
Rupees = "No Rupees"
Case "One"
Rupees = "One Rupee"
Case Else
Rupees = Rupees & " Rupees only"
End Select
Select Case Paisa
Case ""
Paisa = ""
Case "One"
Paisa = ""
Case Else
Paisa = " and " & Paisa & " Paisa"
End Select
SpellNumber = Rupees '& Paisa
End Function
' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber =...

...You are already familiar with Microsoft Excel software. You have learnt some interesting and useful things that can be done in MS-Excel. Microsoft Excel is an electronic spreadsheet software which allows you to enter, calculate, manipulate, organize and analyze data in the form of tabular form. Let us learn more about data tools provide in Microsoft Excel.
* Data Tools
* Text to Columns
* Remove Duplicates
* Data Validation
* Consolidate
Data Tools
With the powerful data tools included within Microsoft Excel you have the ability to analyze large amounts of data that will influence decisions. Data Validation is a great way to limit what a user can enter into a worksheet cell. It may not stop a cell from being left empty, however. This tip explores why this is and how you can make sure that a cell contains a value. Microsoft Excel’s data consolidate capabilities allows you to summarize your data enhancing your ability to organize and structure your data. Remove Duplicates tool makes your data uniform by removing duplicate records.
Text To Column
If you copy data from another program and paste it into Microsoft Excel, Excel may summarize several columns of data to a single column. You can use the Text To Columns command on the Data menu to put each record in a separate column. The range that you convert may contain many rows, but you can only...

...Excel Homework Assignment 2
Due Date/Time: All Files completed for this assignment must be submitted to Blackboard before class begins on the due date. NOTE: Each file should be saved with your first initial last name followed by the filename instructed by the author. For example, for Problem 1 below, the file should be saved as: pgabriel Iowa Election Results
Assignment 2 problems are taken from your text in Tutorials 2 and 3
* Tutorial 2 – Case Problem 3 – Iowa Election Results
* Complete the steps for this problem as described by the author
* When complete save the files as instructed above
* Print the Iowa Election Results Documentation Worksheet and the data worksheet
* Tutorial 2 – Case Problem 4 – Life Managers Nutrition Table
* Complete the steps for this problem as described by the author
* Be sure to complete all of the design elements as described in step 4. In your documentation w/s identify where each of these elements can be found in your worksheet.
* When complete save the file as instructed above
* Print the documentation worksheet and the Life Managers Nutrition Table Worksheet
* Tutorial 3 – Case Problem 1 – Chemistry 303 – pages 153-154
* Complete the steps for this problem as described by the author.
* When complete save the file as instructed above.
* Print the documentation worksheet and the Chemistry worksheet
REMINDER – All three (3) files...

...[Not for Circulation]
Advanced Formulas and Functions in Microsoft Excel
This document provides instructions for using some of the more complex formulas and
functions in Microsoft Excel, as well as using absolute references in formulas.
Opening Comments
Formulas are equations that perform calculations on values. A formula starts with an equal
sign (=) and follows the order of operations (parentheses, exponents, multiplication & division,
addition & subtraction).
For example, the following formula multiplies 2 by 3 and then adds 5 to the result.
=5+2*3
A function is a preset formula. Like formulas, functions begin with an equal sign ( = ) followed
by the function’s name and its arguments. The function name tells Excel what calculation to
perform. The arguments are contained inside round brackets.
For example, the most used function in Excel is the SUM function, which is used to add together
the data in selected cells. The SUM function is written as =SUM(A1:A6)
Here the function adds the contents of the cell range A1 to A6.
Formulas and functions can be entered directly into a cell or into the Formula Bar.
Enter a...

...Student ID: 21709822
Exam: 038229RR - Microsoft Excel
When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you
hit Submit Exam. If you need to exit before completing the exam, click Cancel Exam.
Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page
break, so be sure that you have seen the entire question and all the answers before choosing an answer.
1. The order of precedence is very important when building formulas in Excel. Which of the following
formulas will produce 778 as the result?
A. =25*(27/9 + 5) + 309*2
B. =25*27/9 + 5 + 309*2
C. =25*((27/9 + 5) + 309*2)
D. =(25*(27/9) + 5 + 309)*2
2. Which of the following identifies the patterns used for each data series in a chart?
A. The horizontal and vertical axes
B. Data series
C. Legend
D. Data point
3. Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot
table?
A. When Helga created the pivot table, Excel automatically put the fields to the appropriate cells of the pivot table. There aren't
two ways to set up a pivot table.
B. Helga can check the field or type in the data in the pivot table.
C. Helga can drag the fields to the four boxes in the pivot table field list or right-click a field name and choose its location from
the shortcut menu.
D. Helga can slide cells to...

...Started in Excel
Many of the editing tools that you use in Excel are similar to Word and PowerPoint
You will need to become familiar with a few new things for Excel: Rows, Columns, Various Formulas, and Charts just to name a few
When you see a reference such as A7, A is the column and 7 is the row, this will give you the particular cell that is being referenced.
You will learn that you can click or enter in information when it comes to cells and formulas. Everyone will have their own preference on how to do this and one way is not better than the other.
Basic calculations can be done as follows:
=SUM(A1:A7)
=A1+B2
=4+3
Once you have entered a formula for a cell – if the following cells require the same formula you can click and drag your mouse to copy the formula to adjacent cells
Once you have entered a formula you can change one of the numbers used in the formula and it will automatically adjust the results of the formula!! This allows you to use spreadsheets repeatedly without having to redo everything.
There are several display options for the way the numbers will appear (accounting, general, etc.)
For formulas just think back to the basic operations of math (parenthesis, adding, subtracting, dividing, etc.) – Excel does what you tell it to.
If you find your numbers are not...

...Week 6
Excel
PF008 A14
Introduction to Spreadsheets
A spreadsheet is an electronic file that contains a
grid of columns and rows used to organize related
data and perform calculations.
Excel is a spreadsheet program used to create and modify
electronic spreadsheets.
An electronic spreadsheet makes data-entry changes easy,
and if the formulas are correctly constructed, the results
recalculate automatically and accurately.
A worksheet is a single spreadsheet that typically contains
descriptive labels, numeric values, formulas, functions, and
graphical representations of data.
A workbook is a collection of one or more related
worksheets contained within a single file. Each worksheet
is identified by a sheet tab. By default, new workbooks
have three worksheets.
The whole file is a workbook
Worksheet
Planning Structure of Worksheets
1. State the purpose of the worksheet
2. Decide what input values are needed
An input area is a range of cells containing values
3. Decide what outputs are needed
An output area is a range of cells containing
results
4. Assign the worksheet inputs and results
Use rows and columns
5. Enter the labels, values, and formulas
6. Format the numerical values
7. Format the descriptive titles and labels
8. Document the worksheet
9. Save the completed workbook
Exploring the Excel Window
• Worksheet rows lie horizontally
• Worksheet columns lie...

456 Words |
19 Pages

Share this Document

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":37191916,"categoryName":"Software Development","categoryParentId":"5","currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":3,"pageRange":"1-3","totalPages":3}},"access":"premium","title":"Excel Formula and Function","additionalIds":[3,17,83,9],"additional":["Business \u0026 Economy","Literature","Computer Science\/Domains","Entertainment"],"loadedPages":{"html":[],"text":[1,2,3]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/Excel-Formula-And-Function-1471764.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.8","language":"en_US"}}