[Your Survey Title]

1
The formula to add 10 numbers in Column C would be:
=sum(c1:c10)
=c1+c2+c3
= add(c column
Cannot be done.
2

If you want to add up the values that are over 100 in column B:

=SUM(B1:B10)
=ADD(B COLUMN)
= SUMIF(">100",B1:B10)
=SUMIF(B1:B10,">100")
3

What are the two types of Cell Reference in Formulas.

Relatives and Uncles
Relative and Absolute
Relationship and Range
Relative and Remote
4

What is a good way to count all the salesmen values over 400?

=countif( )
=sumif( )
= sum
=if()
5

The best way to find the average for the values in C1, C2, C3, C4

=average(c1:c4)
=sumif(c1:c4)
=sum(c1:c4)
=sum(c1:c4)/5
6

A good way to copy formulas.

Click and Drag Fill Handle
Copy and Paste
Cut and Paste
Type in the Formulas
7

Dragging the Fill Handle on a Cell called "jan" will

Produce an Error
Create cells filled with sequential months.
Create more cells with "Jan" in them.
Create a Sum of all January Sales
8

The function that will tally all of the cells in its range.

Count()
CountIF()
SumIf()
Sum()
9

B1 =   500       C1 = 20

B1 is the total value of a Shopping Item.

C1 is the percentage discount

Create a formula to give the new sale Price

= B1 + B1 * C1
= B1 - (B1 * C1)
= C1/B1
= B1/ C1
10

4 Salesmen sell products for XYZ Company.  What kind of Chart will show who sold the most over the past year?

An Excel Spreadsheet with sales dollars for each salesmen over 12 months.
A Column Chart that shows each salesman total by month.
A Column Chart that shows Total Sales Summary for each salesman for the year.
A Pie chart that shows percentage of total monthly revenue.
11

An Absolute reference is good for this.

If you need to add up all the sales for each month.
If you need a detail percentage of the total value.
If you want the average of a monthly sales.
If you want the detail sales for every salesman.