Excel Workbook: 160 Exercises with Solutions and Comments

Description
Biography
Title
Copyright
Table of Contents
PREFACE
PLAN OF THE WORKBOOK
SECTION 1. EXERCISES
	UNIT 1. EXCEL BASICS
		EXERCISE 1.1 - Quarterly sales
		EXERCISE 1.2 - Four elections
		EXERCISE 1.3 - Income
		EXERCISE 1.4 - Cinema
		EXERCISE 1.5 - Courses
		EXERCISE 1.6 - Population by age
		EXERCISE 1.7 - Sales data
		EXERCISE 1.8 - Exams
		EXERCISE 1.9 - Balance sheet
		EXERCISE 1.10 - TV shows
		EXERCISE 1.11 - Cigarettes
		EXERCISE 1.12 - Families
		EXERCISE 1.13 - Beer and wine
		EXERCISE 1.14 - Three elections
		EXERCISE 1.15 - Athletics
		EXERCISE 1.16 - Bills
		EXERCISE 1.17 - Turnover analysis
		EXERCISE 1.18 - US and foreign sales
		EXERCISE 1.19 - Rainfall
		EXERCISE 1.20 - UFO
		EXERCISE 1.21 - Accidents
		EXERCISE 1.22 - Music sales
		EXERCISE 1.23 - Seven dwarfs
		EXERCISE 1.24 - Expenses
		EXERCISE 1.25 - Three musketeers
		EXERCISE 1.26 - Murders
		EXERCISE 1.27 - City council
		EXERCISE 1.28 - Parliamentary groups
		EXERCISE 1.29 - Regional chief towns
		EXERCISE 1.30 - Population (summary exercise)
	UNIT 2. FROM SIMPLE FUNCTIONS TO NESTED FUNCTIONS
		EXERCISE 2.1 - Home loans
		EXERCISE 2.2 - Internet users
		EXERCISE 2.3 - Top sellers
		EXERCISE 2.4 - Alphabet Inc.
		EXERCISE 2.5 - Show
		EXERCISE 2.6 - Productivity
		EXERCISE 2.7 - Customer care
		EXERCISE 2.8 - Istat
		EXERCISE 2.9 - Planets (summary exercise)
		EXERCISE 2.10 - Home Sweet Home (summary exercise)
	UNIT 3. MATH FUNCTIONS AND ADVANCED CHARTS
		EXERCISE 3.1 - Drugstores
		EXERCISE 3.2 - Men at work
		EXERCISE 3.3 - Car Insurances
		EXERCISE 3.4 - Exam
		EXERCISE 3.5 - Clothing Store
		EXERCISE 3.6 - Beauty Business
		EXERCISE 3.7 - Cosmetics Shop
		EXERCISE 3.8 - International Education
		EXERCISE 3.9 - Dinner with classmates (summary exercise)
		EXERCISE 3.10 - Wages (summary exercise)
	UNIT 4. FINANCIAL FUNCTIONS AND WHAT-IF ANALYSIS
		EXERCISE 4.1 - Emerald
		EXERCISE 4.2 - Smart Courses
		EXERCISE 4.3 - Credits and debts
		EXERCISE 4.4 - Cloth Paradise
		EXERCISE 4.5 - Discount on rates
		EXERCISE 4.6 - Smart Investments Bank
		EXERCISE 4.7 - Garden Center (summary exercise)
		EXERCISE 4.8 - GreenBio (summary exercise)
		EXERCISE 4.9 - PhotoMagic (summary exercise)
		EXERCISE 4.10 - Bright Sun (summary exercise)
	UNIT 5. TEXT FUNCTIONS AND PIVOT TABLES
		EXERCISE 5.1 - IBAN codes
		EXERCISE 5.2 - Names
		EXERCISE 5.3 - Superstore
		EXERCISE 5.4 - Beauty
		EXERCISE 5.5 - Europe sales
		EXERCISE 5.6 - Erasmus
		EXERCISE 5.7 - Vitanic
		EXERCISE 5.8 - Office Line
		EXERCISE 5.9 - Greenwich Village (summary exercise)
		EXERCISE 5.10 - Black-yellow supporters (summary exercise)
	UNIT 6. MANAGING DATES AND TIMES
		EXERCISE 6.1 - Two hours
		EXERCISE 6.2 - Timesheet
		EXERCISE 6.3 - Date check
		EXERCISE 6.4 - Linguistic certifications
		EXERCISE 6.5 - Techno Building
		EXERCISE 6.6 - Hotel Booking
		EXERCISE 6.7 - My Friends
		EXERCISE 6.8 - Temporary workers
		EXERCISE 6.9 - Payments (summary exercise)
		EXERCISE 6.10 - Stationery (summary exercise)
	UNIT 7. LOOKUP & REFERENCE FUNCTIONS, DATA PROTECTION
		EXERCISE 7.1 - Rocky Sports
		EXERCISE 7.2 - Property Evaluation
		EXERCISE 7.3 - Copy shop
		EXERCISE 7.4 - Paper and related
		EXERCISE 7.5 - Purchasing Department
		EXERCISE 7.6 - DoReMi
		EXERCISE 7.7 - Thinkstore
		EXERCISE 7.8 - Print Service
		EXERCISE 7.9 - European University
		EXERCISE 7.10 - Consulteam
		EXERCISE 7.11 - Candidates selection
		EXERCISE 7.12 - MagicWood
		EXERCISE 7.13 - Phone calls (summary exercise)
		EXERCISE 7.14 - Box Office Star (summary exercise)
		EXERCISE 7.15 - Sunshine Events (summary exercise)
	UNIT 8. MACROS AND ELEMENTS OF VBA
		EXERCISE 8.1 - Students
		EXERCISE 8.2 - Tickets
		EXERCISE 8.3 - Product list
		EXERCISE 8.4 - Stores
		EXERCISE 8.5 - Household linens
		EXERCISE 8.6 - Arithmetic
		EXERCISE 8.7 - Airbnb
		EXERCISE 8.8 - Filtered data
		EXERCISE 8.9 - Deliveries
		EXERCISE 8.10 - Subtotals
		EXERCISE 8.11 - Table
		EXERCISE 8.12 - Worksheet protection
		EXERCISE 8.13 - Chart axis
		EXERCISE 8.14 - Table template
		EXERCISE 8.15 - Alternate rows
		EXERCISE 8.16 - Sales chart
		EXERCISE 8.17 - Add worksheets
		EXERCISE 8.18 - Sales pivot
		EXERCISE 8.19 - Insert rows
		EXERCISE 8.20 - Stock Exchange (summary exercise)
	UNIT 9. MORE FUNCTIONS AND SOLVER
		EXERCISE 9.1 - Hot deals
		EXERCISE 9.2 - Blue Vision
		EXERCISE 9.3 - Gold
		EXERCISE 9.4 - Personal loan
		EXERCISE 9.5 - New car
		EXERCISE 9.6 - Gluten-free products
		EXERCISE 9.7 - Condo fees
		EXERCISE 9.8 - Car purchase
		EXERCISE 9.9 - Promotional Campaign
		EXERCISE 9.10 - German course
		EXERCISE 9.11 - Overtime
		EXERCISE 9.12 - Home video
		EXERCISE 9.13 - Hotel Eden (summary exercise)
		EXERCISE 9.14 - TechMind contest (summary exercise)
		EXERCISE 9.15 - PluriPlast (summary exercise)
	UNIT 10. DATABASE FUNCTIONS AND CHART OPTIONS
		EXERCISE 10.1 - Payroll office
		EXERCISE 10.2 - Sport shoes
		EXERCISE 10.3 - Budget
		EXERCISE 10.4 - District competition
		EXERCISE 10.5 - Admission office
		EXERCISE 10.6 - Distributors
		EXERCISE 10.7 - Car dealer
		EXERCISE 10.8 - Fruit & Vegetables
		EXERCISE 10.9 - Albert Einstein
		EXERCISE 10.10 - SEFCO (summary exercise)
	UNIT 11. FINANCIAL APPLICATIONS
		EXERCISE 11.1 - Premium Bonds
		EXERCISE 11.2 - Coupon&Coupon
		EXERCISE 11.3 - FRN
		EXERCISE 11.4 - Reverse floater
		EXERCISE 11.5 - Capital budgeting
		EXERCISE 11.6 - Super Leasing
		EXERCISE 11.7 - Stock performance
		EXERCISE 11.8 - Stock analysis
		EXERCISE 11.9 - Regression
		EXERCISE 11.10 - Market Analysis (summary exercise)
	UNIT 12. DATA ANALYSIS AND REPORTING
		EXERCISE 12.1 - Turnover
		EXERCISE 12.2 - Orders
		EXERCISE 12.3 - Gifts
		EXERCISE 12.4 - Product IDs
		EXERCISE 12.5 - Counties and offices
		EXERCISE 12.6 - Variable period
		EXERCISE 12.7 - Choose your category
		EXERCISE 12.8 - Chart with bands
		EXERCISE 12.9 - Scroll bar
		EXERCISE 12.10 - Dashboard (summary exercise)
SECTION 2. COMMENTS AND FUNCTIONS
	COMMENTS AND FUNCTIONS UNIT 1
		EXERCISE 1.1 - Quarterly sales (commented)
		EXERCISE 1.2 - Four elections (commented)
		EXERCISE 1.3 - Income (commented)
		EXERCISE 1.4 - Cinema
		EXERCISE 1.5 - Courses (commented)
		EXERCISE 1.6 - Population by age (commented)
		EXERCISE 1.7 - Sales data (commented)
		EXERCISE 1.8 - Exams (commented)
		EXERCISE 1.9 - Balance sheet
		EXERCISE 1.10 - TV shows
		EXERCISE 1.11 - Cigarettes
		EXERCISE 1.12 - Families
		EXERCISE 1.13 - Beer and wine
		EXERCISE 1.14 - Three elections
		EXERCISE 1.15 - Athletics (commented)
		EXERCISE 1.16 - Bills
		EXERCISE 1.17 - Turnover analysis
		EXERCISE 1.18 - US and foreign sales (commented)
		EXERCISE 1.19 - Rainfall (commented)
		EXERCISE 1.20 - UFO
		EXERCISE 1.21 - Accidents
		EXERCISE 1.22 - Music sales (commented)
		EXERCISE 1.23 - Seven dwarfs
		EXERCISE 1.24 - Expenses (commented)
		EXERCISE 1.25 - Three musketeers
		EXERCISE 1.26 - Murders
		EXERCISE 1.27 - City council (commented)
		EXERCISE 1.28 - Parliamentary groups
		EXERCISE 1.29 - Regional chief towns (commented)
		EXERCISE 1.30 - Population (commented)
	COMMENTS AND FUNCTIONS UNIT 2
		EXERCISE 2.1 - Home loans (commented)
		EXERCISE 2.2 - Internet users (commented)
		EXERCISE 2.3 - Top sellers (commented)
		EXERCISE 2.4 - Alphabet Inc.
		EXERCISE 2.5 - Show
		EXERCISE 2.6 - Productivity
		EXERCISE 2.7 - Customer care
		EXERCISE 2.8 - ISTAT (commented)
		EXERCISE 2.9 - Planets (commented)
		EXERCISE 2.10 - Home Sweet Home (commented)
	COMMENTS AND FUNCTIONS UNIT 3
		EXERCISE 3.1 - Drugstores (commented)
		EXERCISE 3.2 - Men at work (commented)
		EXERCISE 3.3 - Car insurances (commented)
		EXERCISE 3.4 - Exam
		EXERCISE 3.5 - Clothing Store
		EXERCISE 3.6 - Beauty Business
		EXERCISE 3.7 - Cosmetics Shop
		EXERCISE 3.8 - International Education
		EXERCISE 3.9 - Dinner with classmates (commented)
		EXERCISE 3.10 - Wages (commented)
	COMMENTS AND FUNCTIONS UNIT 4
		EXERCISE 4.1 - Emerald (commented)
		EXERCISE 4.2 - Smart Courses (commented)
		EXERCISE 4.3 - Credits and debts (commented)
		EXERCISE 4.4 - Cloth Paradise
		EXERCISE 4.5 - Discount on rates
		EXERCISE 4.6 - Smart Investments Bank
		EXERCISE 4.7 - Garden Center (commented)
		EXERCISE 4.8 - GreenBio
		EXERCISE 4.9 - PhotoMagic (commented)
		EXERCISE 4.10 - Bright Sun
	COMMENTS AND FUNCTIONS UNIT 5
		EXERCISE 5.1 - IBAN codes (commented)
		EXERCISE 5.2 - Names (commented)
		EXERCISE 5.3 - Superstore (commented)
		EXERCISE 5.4 - Beauty (commented)
		EXERCISE 5.5 - Europe sales
		EXERCISE 5.6 - Erasmus
		EXERCISE 5.7 - Vitanic
		EXERCISE 5.8 - Office Line
		EXERCISE 5.9 - Greenwich Village
		EXERCISE 5.10 - Black-yellow supporters (commented)
	COMMENTS AND FUNCTIONS UNIT 6
		EXERCISE 6.1 - Two hours (commented)
		EXERCISE 6.2 - Timesheet (commented)
		EXERCISE 6.3 - Date check (commented)
		EXERCISE 6.4 - Linguistic Certifications
		EXERCISE 6.5 - Techno Building
		EXERCISE 6.6 - Hotel booking (commented)
		EXERCISE 6.7 - My friends
		EXERCISE 6.8 - Temporary workers (commented)
		EXERCISE 6.9 - Payments (commented)
		EXERCISE 6.10 - Stationery (commented)
	COMMENTS AND FUNCTIONS UNIT 7
		EXERCISE 7.1 - Rocky Sports (commented)
		EXERCISE 7.2 - Property evaluation (commented)
		EXERCISE 7.3 - Copy shop
		EXERCISE 7.4 - Paper and related (commented)
		EXERCISE 7.5 - Purchasing Department
		EXERCISE 7.6 - DoReMi
		EXERCISE 7.7 - Thinkstore
		EXERCISE 7.8 - Print Service
		EXERCISE 7.9 - European University
		EXERCISE 7.10 - Consulteam
		EXERCISE 7.11 - Candidates selection
		EXERCISE 7.12 - MagicWood
		EXERCISE 7.13 - Phone calls (commented)
		EXERCISE 7.14 - Box Office Star
		EXERCISE 7.15 - Sunshine Events (commented)
	COMMENTS AND FUNCTIONS UNIT 8
		EXERCISE 8.1 - Students (commented)
		EXERCISE 8.2 - Tickets (commented)
		EXERCISE 8.3 - Product list (commented)
		EXERCISE 8.4 - Stores (commented)
		EXERCISE 8.5 - Household linens
		EXERCISE 8.6 - Arithmetic (commented)
		EXERCISE 8.7 - Airbnb (commented)
		EXERCISE 8.8 - Filtered data (commented)
		EXERCISE 8.9 - Deliveries (commented)
		EXERCISE 8.10 - Subtotals
		EXERCISE 8.11 - Table (commented)
		EXERCISE 8.12 - Worksheet protection (commented)
		EXERCISE 8.13 - Chart axis (commented)
		EXERCISE 8.14 - Table template (commented)
		EXERCISE 8.15 - Alternate rows (commented)
		EXERCISE 8.16 - Sales chart (commented)
		EXERCISE 8.17 - Add worksheets (commented)
		EXERCISE 8.18 - Sales pivot (commented)
		EXERCISE 8.19 - Insert rows (commented)
		EXERCISE 8.20 - Stock Exchange (commented)
	COMMENTS AND FUNCTIONS UNIT 9
		EXERCISE 9.1 - Hot deals (commented)
		EXERCISE 9.2 - Blue Vision (commented)
		EXERCISE 9.3 - Gold (comment)
		EXERCISE 9.4 - Personal loan (commented)
		EXERCISE 9.5 - New car
		EXERCISE 9.6 - Gluten-free products
		EXERCISE 9.7 - Condo fees
		EXERCISE 9.8 - Car purchase
		EXERCISE 9.9 - Promotional campaign (commented)
		EXERCISE 9.10 - German course
		EXERCISE 9.11 - Overtime
		EXERCISE 9.12 - Home video
		EXERCISE 9.13 - Hotel Eden (commented)
		EXERCISE 9.14 - TechMind contest
		EXERCISE 9.15 - Pluriplast
	COMMENTS AND FUNCTIONS UNIT 10
		EXERCISE 10.1 - Payroll office (commented)
		EXERCISE 10.2 - Sport shoes (commented)
		EXERCISE 10.3 - Budget (commented)
		EXERCISE 10.4 - District competition (commented)
		EXERCISE 10.5 - Admission office
		EXERCISE 10.6 - Distributors
		EXERCISE 10.7 - Car dealer
		EXERCISE 10.8 - Fruit and vegetables
		EXERCISE 10.9 - Albert Einstein
		EXERCISE 10.10 - SEFCO (commented)
	COMMENTS AND FUNCTIONS UNIT 11
		EXERCISE 11.1 - Premium Bonds
		EXERCISE 11.2 - Coupon&Coupon
		EXERCISE 11.3 - FRN
		EXERCISE 11.4 - Reverse floater
		EXERCISE 11.5 - Capital budgeting
		EXERCISE 11.6 - Super leasing
		EXERCISE 11.7 - Stock performance (commented)
		EXERCISE 11.8 - Stock analysis
		EXERCISE 11.9 - Regression
		EXERCISE 11.10 - Market Analysis (commented)
	COMMENTS AND FUNCTIONS UNIT 12
		EXERCISE 12.1 - Turnover
		EXERCISE 12.2 - Orders
		EXERCISE 12.3 - Gifts
		EXERCISE 12.4 - Product IDs
		EXERCISE 12.5 - Countries and offices
		EXERCISE 12.6 - Variable period
		EXERCISE 12.7 - Choose your category
		EXERCISE 12.8 - Chart with bands
		EXERCISE 12.9 - Scroll bar
		EXERCISE 12.10 - Dashboard (commented)
AUTHORS