|
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. |
| |
|
|