Premium Essay

Sam Document

In:

Submitted By shambhu
Words 2652
Pages 11
Excel 2007
Formulas and Functions

For additional help with this or other software programs, contact the Center for
Teaching and Learning (ctl@mcmail.maricopa.edu)
480-461-7690

Mesa Community College

Christine Held

1

This manual was created using excerpts from Introduction to Excel 2002, created by the
Technology Training Services department at the Maricopa Community College District Office.
Other portions of this manual were created by Christine Held, BPC/CIS Faculty at Mesa
Community College.
Some picture excerpts were supplied by Thomson-Course Technology 2007.
Some text and pictures were inserted directly from the Microsoft Excel Help feature.

Mesa Community College

Christine Held

2

Learning Objectives:
Adding Comments to Cells
Absolute vs. Relative Cell References
Creating multiple worksheets and adding 3D references
Creating Conditional formatting
Grouping Worksheets
Date Functions
Using If Functions
Naming Ranges
Round Function
Using Min, Max and Average functions
Auditing Formulas

Mesa Community College

Christine Held

3

Review Exercise: Create the following worksheet
1. Create the following worksheet and used the formulas as displayed below. Name the sheet “Quarter 1”.
2. Save as Quarterly Budget.

Formulas to be used:

Mesa Community College

Christine Held

4

ADDING COMMENTS TO CELLS
Excel has a useful feature call COMMENTS. The comments are notes attached to a specific cell in a worksheet. They are useful as references or as a help to others who use the worksheet.
When a note is attached to a cell, a small triangular marker displays at the top right corner of the cell. These markers, as well as the comments, do not automatically print.
Using the Review Tab, this is what the comment menu choices are:

Add
Comments
to a Cell

Add Comments to a Cell
1. Select the cell to

Similar Documents

Free Essay

Status of Books in Modern Society

...Books are symbolic of learning, and the educated. For years now, having a home library was the luxury few could afford. The lucky few who had one were immeasurably proud of it, and rightly so. Today, not only are books beginning to lose the value that they once had in the eyes of Man, their place in society has been increasingly challenged by the newborns of the digital age. New trends such as the increasing pace of life, the accelerating rate at which new information is being pedalled forth, and the ubiquity of the effects of capitalism have driven people to become more efficient. The by-product of such phenomena is that Man is taken as its slave, and only the interests of the market are considered, instead of the individual. Unfortunately, this has dealt a severe blow to the significance of the book in modern society. All indicators seem to point out that the book is unworthy of its more efficient counterparts like the personal computer or tablet. Yet, the book holds a special place in our hearts: its final trump card. We should not be too quick to oust the book out of our lives even with the proliferation of suitable alternatives, for there is still indeed worth of the hard copy even in the frenzy of modern society. Evolution seems to have taken mankind back to square one, where the modern man (like his ancestors thousands of years ago) worries about his next meal, appointment or payment. "Next" seems like the buzzword of modern society, with people constantly looking for...

Words: 1027 - Pages: 5

Free Essay

Qm0682 Ed a

...1. Which document should the clerk compare with the DCR to find the omitted item? The change document The shortage annex The hand receipt The MTOE 2. After identifying which item has been omitted, you should ensure that the clerk does which of the following BEFORE ordering a new item and posting the document number to the shortage annex: WRONG Destroy the existing documents Add the item to the Document register Make no changes to the documents Place the item number on the shortage annex 3. You have been furnished three documents (maintenance section hand receipt DA Form 2062, MTOE and PCN: ALV-151) (figures below). Using the documents, determine the authorized quantity for LIN# W33004 for the Maintenance section. 29 28 20 25 4. You are preparing to conduct an inventory on the unit?s organization property. What do you refer to in order to get the latest updates on technical manuals, supply catalogs (SC) and supply bulletins? WRONG AR 25-400-2 FEDLOG AMDF DA PAM 25-30 Figure 5-1. 5. SSG Brown just issued the Generator set, LIN: G74711, NSN: 6115-01-275-5061, Sn: G472221 to Paul J. Sfransky on the Temporary Hand Receipt in the figure above. Where does Paul J. Sfransky sign the DA Form 3161? Signature not required 1 3 2 6. How would you verify that equipment is being issued to the intended user, and determine if the individual is still assigned to the unit? Use the unit personnel roster and...

Words: 1156 - Pages: 5

Free Essay

Safasafsf

...lecturer one. so, i will confirm with u the finalize version. Qianqi Liew pls update this one also.. if u know how to do annual cycle inventory, tell me about it.. Q2.docx Document DownloadPreviewUpload Revision 23 hours ago Comment Seen by everyone View 3 more comments Erica Lee then how should we do Q2? because they call us give recommendation.. recommendation based on Q1 lor.. so, i just take a bit from Q1 and explain 7 hours ago · Like Qianqi Liew Im not sure... Charles Kang what do u think ? 6 hours ago · Like Charles Kang Write a comment... Charles Kang 1st Question - YES, You need to to explore & explain new plans and please do cost comparisons (calculations) for both EG151 & DB032 2nd Question - After analysis pls do specify your recommendation on which is better system for EG151 & DB032 and explain why? From Dr. Affendy on Thursday Comment Seen by everyone Jing Wei ? Whats your question again? 8 November at 09:25 via mobile · Like Qianqi Liew Which mean Q2 is more on explaining the recommendations? COnfuse.. 7 hours ago · Like · 1 Charles Kang Write a comment... Qianqi Liew uploaded a new version of Case4.Q1.Completed.docx. Here's the completed version for Q1 from me and erica. Case4.Q1.Completed.docx Document DownloadPreviewUpload RevisionHistory (2) 7 hours ago Comment Seen by 3 Erica Lee...

Words: 1380 - Pages: 6

Premium Essay

Records Format

...Summarize in 250-300 words the differences among source-oriented records, problem-oriented records, and integrated records. Include how you think the advantages and disadvantages of each record format affect every day work- remember to think about retrieving records as well as filing them. Source-oriented records (SOR) maintain reports according to source of documentation. This means that whomever the document is generated by, whether it being a nurse, radiology, or a physician each has their own section in the patient records. Problem-oriented records (POR) or problem-oriented medical records (POMR) is a way of record keeping that focuses on a specific problem that a patient may be having, which uses four components database, problem list, initial plan, and progress notes to identify problems. In a POR patients are assigned one or more problems and notes are documented for each problem using the SOAP structure. SOAP is defined as subjective, objective, assessment, and plan. Subjective is a patient’s statement about how she/he feels. Objective is the observation of the patient. Assessment is the judgment, opinion, or evaluation made by the health care provider. Plan is the diagnostic, therapeutic, and educational plan to resolve the patient’s problem. Integrated records format is the arranging of reports in a chronological date order. This allows observation on how the patient is progressing according to test results and how well the patient is responding to treatment based...

Words: 353 - Pages: 2

Free Essay

Records Organization

...Week 6 –Records Organization Tamara Tate HRC/210 Patient Record: Keeping it Real (Axia) March 12, 2014 Lisa Owens Records Organization Records Organization There is variances and parallels amongst small, medium, and large facilities regarding how patient's records are organized. There are also differences in how loose paper records are maintained. Likewise, I have noticed the majority of facilities prefer that their loose records are anchored in their charts. This makes sense to me because it prevents the loose reports from coming up missing or lost. However, the size of facility seems to regulate how the facility systematizes its patient's files. The most prevalent methods of organization I have seen include chronologically, form numbers, report types, and categories. While reviewing the interview threads, I observed many similarities and many differences in how patient files are controlled. For example, the medium and large facilities are most likely to use electronic documenting than paper ones, thus eliminating the threat of misplaced records. The most common variance I perceived was in whether or not the facilities use paper files versus electronic files. Almost all of the medium and large facilities are using electronic files with all records immediately filed with the patient's main file. In contrast, the smaller facilities seem more likely to use paper files. Records are filed with the patient's main record right away or by the end of the day. This makes it easier...

Words: 268 - Pages: 2

Premium Essay

Term Paper from Web

...Term Paper Format Format for Term Papers ________________________________________ Below are some links and a general outline on how to write your term papers. Depending on your topic you may want to rely on the scientific report style or literature review styles, or a combination of the two. The choice is yours. Links to these styles can be accessed by the buttons below. Below the three buttons I outline the scientific report style. More details can be found by clicking the scientific format button below. Click here for how to write a reseach paper Click here to gain a more detailed view of the scientific report format described below or, Click here to gain a description of how to write a literature review ________________________________________ Format for a Scientific Report Abstract Short (three-quarters of a page) description of the paper. Describe what the issue or problem is, why it is important or interesting, and your findings Introduction • What is the issue or problem? • Literature review: what is current thinking, findings, and approaches on the problem? • What is the significance of the problem? • How do you plan to deal with the problem? What is your solution? Methods • How did you search for information or data on the topic? • What is your impression of the ulility, relevance, or quality of the data you collected? • What special steps did you take to select or utilize the data? Results • What are your findings? • Are their problems...

Words: 278 - Pages: 2

Free Essay

Jjjjjj

...International Trade Documents & Logistics Assignment- 1 Submitted to- Submitted by - Ms. Supriya Lamba Karan Patwari Enroll no.-A1802014028 Ques.-Describe ADS(Aligned Documentation System) & what are its objectives? Ans.-Under Aligned Documentation System, different forms used in the International trade transaction are printed on the paper of the same size and in such way that the common items of information are given the same relative slots in each of the documents. With the effect from 1.10.1991, the new standardized documents came into effect. This is referred to as The Aligned Documentation System based on the U.N. layout key. The documents are aligned in such a manner that the common items of information are given in the same relative slots. This system also helps to prepare one" Master Documents" embodying information common to all documents, and xerox all the aligned documents by suitable and reproduction techniques. Accordingly the standardized documents for Indian exports are · Invoice · Exchange Control Declaration (GR) Form · Shipping Bill (Dock challan\ Duty Draw back and Port Trust Copy) · Bill of Lading Aligned DocumentationSystem is based on the U.N. layout key. Deriving national...

Words: 261 - Pages: 2

Free Essay

Erb for Business Management

...Republic of the Philippines CAVITE STATE UNIVERSITY Don Severino de las Alas Campus Indang, Cavite ( (046) 862-0939 / 862-0940 www.cvsu.edu.ph CvSU ERB FORM 01. PROTOCOL PACKAGE RECEIPT STUDY CODE: TITLE: PROPONENT: To the principal investigator/research proponent: Kindly arrange the required (with bullets) and other documents in your protocol package according to the following order. Write NA if the document is not applicable. | | | | |Original plus 7 copies of the ff: |NA |DATE Received at ERB with Proponent/Investigator/Representative| | | |and ERB secretariat initials | |Endorsement Letter from the research grant if applicable | | | |Accomplished ERB Form 02 -Request for Review of Protocol | | | |Accomplished ERB Form 03- Permit to Conduct the Study and | | | |Informed Consent (English and Filipino) | | | |Accomplished ERB Form 04 – Ethics Review Board Ethical...

Words: 298 - Pages: 2

Premium Essay

Laboratory Information Management System (Lims)

...2010) The main feature of a laboratory information management system is the management of registering and tracking if samples and test that take place in the laboratory. After the sample container arrival and registration, the LIMS tracks it and records its location. This may involve printing barcodes to identify the sample containers. However, it is also used to increase the amount of integration with instruments and applications what is done by creating files which will lead the operations on the sample; and to record and exchange electronic information what can be done through Oracle, SQL and Microsoft Access database. (Nicola 2012) Alongside the main functions mentioned above, a LIMS also manages the communication with clients, documents related to the samples and the personnel and workload. List of the main types of information that would need to be stored on a laboratory information management system: 1. Control of Substances Hazardous to Health (COSHH) records. 2. Scientific data. 3. Scientific apparatus. 4. Waste disposal. 5. Health and safety checks. 6. Training records. 7. Quality assurance. 8. Report records. 9. Specification levels. 10. Sample throughput. 11. Management. How information could be entered onto a laboratory information system: Information can be entered onto a laboratory management system using...

Words: 448 - Pages: 2

Free Essay

Untitled

...Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello ...

Words: 258 - Pages: 2

Free Essay

Rlyt Task 1

...with 12 offices in the western United States stretching from Oregon to California and inland to New Mexico. Simple Gateways focuses on travel to island vacations around the world. They are challenged with poor performing Information Systems (IS). Simple Gateway IS produce multiple versions of documents utilized by staff to make poorly informed business decisions. This paper is an analysis of the challenges to the key Simple Getaways stakeholders, actual performance and desired performance. A technological solution is defined and supported to address the alignment of the IS to the Simple Gateways business objectives. Simple Getaways, Inc. Request for Proposal Response 3 Simple Getaways, Inc. Request for Proposal Response The current implemented IS in the Simple Gateways is designed to provide control benefits. The IS was intended to facilitate information to provide the stakeholder the ability to make better decisions and actions. (Chew & Gottschalk, 2009) The current IS produces multiple versions of the same documents used by the office staff. The offices are segregated from each other with their own file servers making e-mail channels the current means to share documents from one store to another. The multiple versions does not assure the information to be accurate or up to date. The staff is then left with misinformation to make decisions. The Simple Gateways IS does not provide a process to perform administrative tasks like approving sick leave or vacation...

Words: 1040 - Pages: 5

Premium Essay

Quality Management Systems

...4.0 - QUALITY MANAGEMENT SYSTEMS Section Description 4.1 Quality System Processes Rev: A --- 01/1/04 --- New Bids, Quotations, Orders and Contracts CUSTOMER REQUIREMENTS CUSTOMERS Human Resources Plant, Facility and Equipment Information Resources (Document Control) Communication Customer RESOURCE MANAGEMENT Planning of Product Realization Purchasing and Receiving Production MANAGEMENT RESPONSIBILITY Measuring/Monitoring Devices PRODUCT REALIZATION Management Policies, Planning and Commitments Management Review MEASUREMENT ANALYSIS AND IMPROVEMENT Monitoring/Measurement of Products Monitoring/Measurement of Quality System (QMS) Monitoring Customer Satisfaction CONTINUAL IMPROVEMENT Shipping and Delivery CUSTOMERS Feedback 1.0 Process Approach 1.1 The quality management system is designed as a system of interrelated processes. All main activities in the company are defined as Quality System Processes (QSPs) and are grouped into the following six categories (refer to the diagram at the top of this section): Customer Requirements, Product Realization, Page 1 of 6 4.0 - QUALITY MANAGEMENT SYSTEMS Section Description Measurement, Analysis and Improvement, Management Responsibility, Resource Management, and Continual Improvement, And are organized into a Plan-Do-Check-Act loop. 1.2 The sequence and interrelation between the six groups and individual QSPs are illustrated in a diagram at the beginning of this section (Quality...

Words: 1672 - Pages: 7

Free Essay

Social

...M1 compare the purposes of different documents used in the selection process Application form: This can be seen as a form that is filled in by the applicant to the business they are applying for. This will inform the business on what skills they have and how it is relevant to the job they are applying for this is will give the business an insight on what the applicant is god for and the skills and qualifications they have. Document | What it does | Application form | Application form: This can be seen as a form that is filled in by the applicant to the business they are applying for. This will inform the business on what skills they have and how it is relevant to the job they are applying for this is will give the business an insight on what the applicant is god for and the skills and qualifications they have. For example Christ the king | Person spec/job description | The person spec is seen as the requirement that the business want for the job, these are things that the applicant will need to have in order to get the job. | Information for candidates | This is the information that the candidates will need to know about the job such as the money it will pay where it is and the person spec. | Reference request | This is when the business you are applying for a job and the employer ask for someone who knows you and they tell them how you act. | Short listing grid | This is when the employers go through a list and check the person who is best suited for the job...

Words: 520 - Pages: 3

Premium Essay

Koofers Notes: A Case Study

...The audio summary is a new product for the market. These is no direct competitor because we are the only audio summary in the market currently. However, the competitions are still existed since there are substitutes for our product. The substitutes include document summary and video review for textbooks. It is obvious that there are many different documental summary for textbooks in the market right now. For example, Koofers Notes is a website that allowed students to upload these course materials for others students, but the materials are delayed and unorganized. It has hundreds relative files for one course, and many of them are insignificant. It will take a great amount of time for students to find the information they want. In addition,...

Words: 329 - Pages: 2

Premium Essay

Nt1330 Unit 3 Assignment 1 Shell Script

...In this introduction, I provide any overview of the concepts regarding shell scripts. Explaining what is a shell script is and describing several common shells. Later, a tutorial is made available for demonstration how to backup a file or folder using a tool to accomplish these tasks. The SNTbackup is a shell script backup tool that gives users the option to select to select a file or folder to be backed up. A detail demonstration with screenshots is provided as a visual aid to readers. I used a simple Linux shell script to back-up the home directory of my system. The script uses the tar command to execute this task. SNTback is a simple, effective, fully customizable backup script that protects your folder by creating a duplicate of the specific folder. The duplicate of the selected folder is the place in a location of the user’s preference. Users will find the SNTbackup as a resource which allows folders such as directories to be back-up in no time. First, you must understand what shells are before to grasp the concept of the shell scripting and programming. Most people are aware know the computer reads information in binary language, which are 0’s and 1’s. The operating system shell allows users to interact with it by reading commands, which are inputted by the keyboard. The output of the command entered by the user will be displayed on the screen. Shell scripting can be used to create and customize the system administration task. Users can monitor their system, network, users...

Words: 1666 - Pages: 7