GKA CS6 - Spreadsheets Quiz

Which of these is NOT a good way to use a spreadsheet?

• Keep track of who is absent each week in a class

• Write down the cost of things you bought and add them all together

• Write a 1,000 word report on red pandas

• Write down your speed in the 50m dash for 10 tries and then make a graph

Which of these spreadsheet apps are owned by Microsoft?

• OpenOffice Calc

• Sheets

• Excel

• Numbers

The cells A4, A5, and A10 are all in the same _______.

• row

• column

• cell

If you have 26 columns in your spreadsheet, the last column will be called _________.

• Column Z

• Column 26

• Column X

• Column Omega

After Column Z, if you add a 27th column, it will get the name ________.

• You can't have more than 26 columns

• Column ZA

• Column AA

• Column AZ

A special spreadsheet command that can read the data in the cells and calculate them (for example, adding or counting) is called a ________.

• fungus

• funderbolt

• function

• funion

If you want to create a function in a cell, the first symbol must ALWAYS be the ______.

• slash key (/)

• pound key (#)

• dollar sign ($)

• equal sign (=)

Which of these functions is not real?

• =sum( )

• =redo( )

• =average( )

• =countif( )

One of these functions has a mistake in it. Carefully check them all and choose the function with the mistake.

• =add(A2:G2)

• =countif(B20:B40,"no")

• =countif(D20:F50,yes)

• =average(C3,C5,C7,C9)

What do you think the function =product(B2:D4) will do?

• Multiply the numbers in the cells

• Delete the cells

• Find the average of the numbers in the cells

• Subtract the numbers in the cells