Spreadsheets/Database Final Exam

Front

What is a Spreadsheet?

Back

A computer program that is used for storing, organizing and manipulating data.

Front

What is a worksheet?

Back

a single "sheet" or "tab" inside a spreadsheet.

Front

An individual box within a worksheet is known as?

Back

cell

Front

What do all calculations start with?

Back

=

Front

What symbol should be used to perform a multiplying calculation?

Back

*

Front

SUM, AVERAGE, MAX and VLOOKUP are examples of what?

Back

Functions

Front

When you key a formula in a spreadsheet what do you key in first?

Back

Equal Sign

Front

Which of the following is a valid formula? Options: =C7*C8, =(C7\C8), =(C7xC8), =AVERAGE(C7*C8)

Back

=C7*C8

Front

Which of the following is a valid function? =sum(A1:A6), sum=(A1:A6), =sum[A1:A6], =sum(A1,A6)

Back

=sum(A1:A6)

Front

You can present your data graphically, using a

Back

chart