Excel
The FIRST cell in an Excel worksheet is:
1. AA
2. A1
3.Ab
4.One
2.A1
A ________ consists of a grid made from columns and rows?
1. cell
2. ribbon
3. spreadsheet
4. formula
3. spreadsheet
In the "Lord of the Rings," who tells the Hobbits "You bow to no one?"
1. Gandalf
2. Gollum
3. Aragorn
4. Bilbo Baggins
3. Aragorn
Which comet can be seen every 75-76 years?
1. Halley
2. Hyakutake
3. Humason
4. Hale-Bop
1. Halley
(B10:B12) indicates :
1. cells B10 and cell B12 only
2. cells B10 through B12
3. cell B11
4.None of the above
2. cells B10 through B12
A function must always start with
1. fx
2. =
3. -
4. fx=
2. =
Which is the third Harry Potter book?
1. Harry Potter and the Chamber of Secrets
2. Harry Potter and the Goblet of Fire
3. Harry Potter and the Order of the Phoenix
4. Harry Potter and the Prisoner of Azkaban
4. Harry Potter and the Prisoner of Azkaban
What city is the Starbucks corpoarte headquarters located in?
1. Oak Brook, IL
2. Seattle, WA
3. Qunicy, MA
4.Portland, OR
2. Seattle, WA
Data validation will make data input more accurate and more uniform.
1. True
2. False
3. I don't do data inputs.
1. True
Which formula is wrong?
1. =sumif($A1:A10, C10, $B1:B)
2. =sumproduct(A20:A50, $B$20:$B$50)
3. =right(Z10,4)
4. =sum(B1,B10:$B$12,B$14)
1. =sumif($A1:A10, C10, $B1:B)
Can you name the 4 Teenage Mutant Ninja Turtles?
Leonardo, Donatello, Raphael and Michaelangelo
Which country won the FIFA World Cup in 2010?
1. Germany
2. Spain
3. Italy
4. France
2. Spain
Which formula resulted in this "ILove BATfor LIFE" assuming 5 cells from A1 to E1 contain(I/Love/BAT/for/LIFE)?
1.=A1&B1&C1&" "&D1&E1
2.=CONCATENATE(A1,B1)&" "&C1&D1&" "&E1
3.=CONCATENATE(A1:E1)
4. All of the above
2.=CONCATENATE(A1,B1)&" "&C1&D1&" "&E1
What function offers you the possibility to view different results depending on the entered condition?
1. =trim( )
2. =sum( )
3. =sumif( )
4. =counta( )
3. =sumif( )
Find an anagram to TWINKLES TEA that is a famous actress. The answer is one of her movies.
ETERNAL SUNSHINE of THE SPOTLESS MIND
AMERICAN BEAUTY
TITANIC
THE SOCIAL NETWORK
KATE WINSLET
How could a man go outside in the pouring rain without protection, and not have a hair on this head wet?
He was BALD