Sample exam

Part I -- Lab Material
___________________

Questions like you will find in a mid-level or capstone exercise.
Amount of material: about two mid-level exercises worth.


Part II
____________________

Not this many questions, but to give you a sampling of types of questions.

1) Make a table with a list of (three) car models and their average highway and city-street mileage. In a separate part of your spreadsheet, have three cells where one fills in the car model, how many miles you need to travel, and what percentage will be on the highway. Based on that, calculate the number of gallons for the entire trip. Use Functions, Absolute, and Relative references where appropriate.

2) What is the R1C1 reference formula for a relative reference, one cell up and three cells to the right?

3) Name a range A1:B6, whose scope is limited only to Sheet1.

4) Let us say you have five word sentence in A1. Using as many cells as you want, calculate for me how many words are longer than 3 letters. I should be able to switch the sentence, and your formulas should still work.

5) The rules for Pig Latin:
http://en.wikipedia.org/wiki/Pig_Latin

My simple rules are as follows: Basically, if a word begins with a consonant, strip off that consonant, give me the rest of the word, and add 'ay' to the end. Thus, 'pig' will become 'igpay' and 'latin' will become 'atinlay'. If a word begins with a vowel, just add 'way' to the end. Thus, 'eye' will become 'eyeway'.

Iway ovelay otay peaksay inway igpay atinlay
is the Pig Latin of
I love to speak in pig latin

Write a formula, or a series of formulas, which will take a single word and make it into its Pig Latin equivalent.

6) Calculate a date which will be 2 years and 35 days from today. By today, I mean TODAY().

7) Write a formula which will tell me if the year of a specific Serial Number contains two zeros in it.