Applied Computers

Excel, Worksheet 1-1

Name:

Period:

 

Read MS Excel, Project 1, pp. 1.4 – 1.61 and answer the following questions as completely as possible. Be sure to read each page entirely. Many answers will be found in the purple "More About…" rectangles.

  1. What are the three major parts of Excel?

    2.  

  2. According to the Case Perspective on p. 1.6, why does the president of the Computer Discount Company want you to use a worksheet and chart to show daily sales?

    3.  

     

     

     

  3. According to Figure 1-1, how many printers were sold by telephone?

    4.  

  4. What is a Web query according to p. 1.7? (Be sure to read the WHOLE page.)

    5.  

     

     

  5. List and fully describe at least 3 features of the Excel window.

    6. A/

     

     

    B/

     

     

    C/

     

     

  6. How many active cells are found at one time within a worksheet and describe how an active cell can be recognized?

    7.  

     

  7. What key can be pressed to erase ALL of the characters in a cell before entering them there?

    8.  

  8. What feature of Excel completes an entry for you automatically after you type the first few letters of an entry in a cell?

    9.  

  9. What value does the Scientific formatted number, 2.68E7, equal?

    10.  

  10. In general, how many font types and font styles should you use in a single worksheet?

    11.  

     

  11. Describe what the range C6:E6 means.