Spreadsheet Knowledge Quiz

Which of the following is an example of "publishing" a spreadsheet?

• All of these are true

• A PDF file version of the sheet

• A printed copy of the sheet

• A web page that displays the sheet

What do we call a smaller area that can be printed from a larger spreadsheet?

• A print area

• A page layout

• A report

• This is not possible with any spreadsheet software

Sharing an online spreadsheet with viewing rights means ____________________?

• Other users can see, but not edit your work

• This is not a valid right or permission for sharing spreadsheets online

• Other users cannot see nor edit your work

• Other users can see and edit your work

To add the values in cells A2, A3, A4 and A5, you could use either of the following formulas: =SUM(A2:A5) - =A2+A3+A4+A5

• True

• False

Which of the following is a valid formula that will add the contents of cell A1 and cell B1?

• =A1+B1

• A1:B1

• A1*B1

• A1+B1=C1

Which of the following ranges will select the first three columns in the second row of a spreadsheet?

• A2:C2

• Row2:Column3

• A0:C3

• 2A2C

What do we call a guess about what will happen in the future, based on existing data?

• A prediction

• An estimate

• An inference

• A trend

What do we call a conclusion you reach about existing data?

• An inference

• A trend

• A predication

• Information

Once your chart is added, you can no longer customize the text, colors, labels and other properties.

• False

• True

Which type of chart will show data in the form of rectangular blocks?

• A bar chart

• A line chart

• A pie chart

• A block chart