Food
Which of these is a specialty rice dumpling that is particularly popular during the Dragon Boat Festival in the summer?
1. Char Siu
2. Zongzi
3. Har Gau
2. Zongzi
The FIRST cell in an Excel worksheet is:
AA
A1
A01
A1
A ________ consists of a grid made from columns and rows?
1. cell
2. ribbon
3. spreadsheet
4. formula
3. spreadsheet
Which country won the FIFA World Cup in 2010?
1. Germany
2. Spain
3. Italy
4. France
2. Spain
Which of the following does not come from a cow?
1. Ice Cream
2. Honey
3. Cheese
2. Honey
(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. -
2. =
Which comet can be seen every 75-76 years?
1. Halley
2. Hyakutake
3. Humason
4. Hale-Bop
1. Halley
What ingredient makes bread rise?
1. Multi purpose Flour
2. Yeast
3. Egg
2. Yeast
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
Azuki, Mung and Lima are all types of what?
1. Seeds
2. Beans
3. Spices
2. Beans
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( )
Who was the gymnast who scored a perfect score of 10 in the 1976 Montreal Olympics?
Nadia Comaneci