Excel Mod 1

Question 1

When was Microsoft Excel launched

Answer 1

1985

Question 2

Why did Microsoft develop Excel

Answer 2

Wanted to be better than Lotus 1-2-3

Question 3

Six advantages of Excel

Answer 3

Integral Charts
Graphing
Rudimentary database capability 
Graphical interface
Pull Down menus
Use mouse to click onto actions

Question 4

How does Excel analyse data

Answer 4

Quick Analysis helps create charts and tables

Question 5

What is conditional formatting

Answer 5

Conditional Formatting Can change the appearance of the cells using colours, fonts, bold and italics

Question 6

Name four areas of business that commonly use Excel

Answer 6

Human Resources
Finance and Accounting
Sales
Marketing and Public Relationships

Question 7

Why is Excel a perfect tool for small businesses

Answer 7

Helps keep track of sales, stock and orders.

Flexible inventory that informs you when to reorder stock

Question 8

What do business and accounting offices use Excel for?

Answer 8

Budgeting
Invoicing
And preparing financial statements

Question 9

How do PR professionals use Excel

Answer 9

Managing contact lists
Scheduling interviews 
Developing editorial 
Managing budgets
Managing media

Question 10

How might Excel be used in recruitment

Answer 10

Scheduling 
Offers
Appointment letters
Extension of probation periods
Calculate salary costs to company (CTC)