NEW
Font size
WorksheetsGKA CS6 - Spreadsheets Quiz
Total questions: 10
Worksheet time: 30mins
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
