CHAPTER 2
EXCEL BASICS
CHAPTER 2 QUESTIONS
1. To put data into a cell, you must first select the cell by clicking on it. As you type, the data is also
automatically entered into the formula bar.
2. Text entries into cells are often referred to as labels, while numbers or formula entries are
referred to as values.
3. The # signs indicate the column width is too small to display the cell value.
functions.
8. The SUM function argument contains a reference to a series of cells you want summed.
9. Parentheses specify the order of calculation in a formula. The inner most set of parentheses are
calculated first, followed by the next inner most set of parentheses etc.
10. AutoFill allows you to quickly copy a formula down or across a series of cells on a worksheet. If
the cells have relative references the formula changes as it is replicated.
11. Absolute references would be used in a formula so that when it is replicated, either by using the
CHAPTER 2 ASSIGNMENTS
1. WHAT SUP TRIAL BALANCE FOR MARCH 31, 2016
a.
b.
2. WHAT SUP SALES WORKSHEET
a.
b.
CHAPTER 2 CASES
1. Kelly’s Boutique
a.
b.
c.
3. Wine Depot
a.
b.
c.
d.
4. Snick’s Board Shop
a.
c.
d.
5. Rosey’s Roses
a.
b.