Everything you need to ace your GCSE exam. Includes two years of revision notes and an in-depth summary of GCSE Business Studies. Discussing everything business-related, you will learn the various elements and functions of business including operations, finance, marketing, human resources, manageme...
Microsoft Word
Mail Merge
Mail merge is a word processing feature that allows users to personalise letters with names
and addresses from a database.
The five main steps in setting up a mail-merged letter are:
1. create the database with fields for the names and addresses of the people to send
the letter to
2. write the letter using a word processing package and link the letter to the database
3. use a query to find a subset of relevant people and send a targeted letter to them
4. using the mail merge wizard, enter codes in the letter where the name and address
of the customers should appear
5. merge-print, taking the data from the database and inserting it in the letters,
producing one letter for each person in the subset of relevant people from the
database
, Spreadsheet
Spreadsheet structure
A spreadsheet consists of a table of cells arranged into columns and rows. Columns are
normally represented by letters and rows by numbers. Each cell, therefore, has an 'address'
and can be located by its column and row – C5 for example.
Cells commonly contain one of five different data types:
1. Boolean values: Boolean or logical values are either TRUE or FALSE. For example,
this could be Male/Female or Yes/No
2. Dates and times: Stores dates and times that can be used in calculations, such as
calculating ages from dates of birth, or wages from hours worked
3. Values: Numbers. Whole numbers (1, 2, 500) and decimals (1.5, 80.45 etc.) can be
used interchangeably within a spreadsheet. For example, a quantity in stock may be
represented by a whole number, while employee hours may be represented by a
decimal number
4. Text: Descriptive pieces of information such as names, addresses and post codes
5. Formula: Allows you to add, subtract, multiply or divide information in one cell by
the values in another cell. More complicated formulas containing algebraic
expressions and other mathematical equations can also be used
Functions and Formulas
Functions make more complex calculations. Simple and regularly used functions include:
=SUM – adds values in selected cells
E.g. =SUM(A1:A5)
=MIN – finds smallest value
=MAX – finds largest value
=AVERAGE – finds the average value
=IF – change the value of a cell if something is true
For example, to "pass" scores above 70:
=IF(A1>70,"Pass","Fail").
Symbols used in formulas
There are a number of symbols used in formulas or calculations. These are the most
common ones:
‘+’ add
‘-’ subtract
‘*’ multiply
E.g A:5*A:6
‘/’ divide
Like formulas, all functions start with an equals sign (=) followed by the function’s name, eg
SUM, MIN, MAX, etc.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller jesshutchinson. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.98. You're not tied to anything after your purchase.