Accounting Regs

Basic Excel Skills Exam                                  Business 91L                                      Summer 2013
 
1.       If you wanted to add a border to some cells you would select the cells and then click on the icon labeled in the picture with:
a.       B
b.      H
c.       FP
d.      FC
Answer: the borders icon is marked with the letter B. It looks like a window with 4 panes.
 
2.       If you wanted to add a background color to some cells you would select the cells and then click on the icon labeled in the picture with:
a.       B
b.      H
c.       FP
d.      FC
Answer: the background colors icon is marked with the letter H. It looks like a paint can.
 
3.       You select a cell and will copy its format into other cells. Your next step would be to click on the icon labeled in the picture with:
a.       the letter B.
b.      the letter H.
c.       the letters FP.
d.      the letters FC.
Answer: the Format Painter icon is marked with the letters FP. It looks like a paintbrush.
 
4.       If you wanted to open the Functions dialog box you would select a cell and then:
a.       Click on the FX icon found next to the formula bar in the picture above.
b.      Click on the dropdown menu next to the SUM icon and choose More Functions.
c.       Click on the Formulas tab of the ribbon and click on the FX icon.
d.      All of these options will work.
Answer: All of these options will work.
 
5.       To create a name for a range (a rectangle shaped group) of cells you would select the cells and:
a.       Right-click and choose Define Name
b.      Click in the name box, type in a word to describe the range, and press Enter.
c.       Click on the Formulas Tab of the ribbon and click on the Name Manager icon.
d.      All of these options will work.
Answer: All of these options will work.
 
6.       Which of these functions is not listed as an option on the AutoSum icon dropdown menu?
a.       SUM
b.      ROUND...