Module 4.2 Spreadsheet

A.      It allows the data to be stored, organized and analyzed.

B. It gives the user the ability to create tables.

C. It enables users to record words and numbers.

D.    It is a software that allows input, editing, formatting and output of text.

        A. Long press Alt then click A1 then click D7.  

B. While pressing shift select the A1 then D7  

C. In the formula bar type A1:D7

D. Press Ctrl + A.

     A.  A7 - A8          

B. = A7 - A8  

C. A7 - A8 =      

D. =SUM (A7:A8)

A.      Select the cell or cells you want to edit then press Insert > Symbol > More Symbols. Scroll down and look for the peso sign then press insert.        

B. Select the cell or cells you like to add formatting. Press right click then click Symbol > More Symbols. Scroll down and look for the peso sign then press insert.  

C. In the ribbon, select the Home tab then click Format Cells. In the Number tab, click Currency then in the dropdown box search for the peso sign symbol.  

D. Select the cell or cells you like to add formatting press right click then Format Cells. Then in the Number tab, click Currency then in the dropdown box search for the peso sign symbol.

A.      Select the cell the press right click, select format cell then change height and width values.

B. In the Formula bar type (h[value]:w[value]).

C. Click the cell then in the ribbon select format cell then change height and width values.

D. Click and drag the column or row heading.

A. C1 + C10        

B. = C1 + C10  

          C. C1 + C10 =

D. SUM (C1:C3)

A.      Click the graph then click and drag any of the eight handles in the edges of the graph.  

B. Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired.

       C. Select the table the press Ctrl + Arrow Keys.

D. You can’t change the size of graphs. 

A.      Press right click then select rename, a window will appear then type “First Data”. 

B.     Press right click then select rename, a window will appear then type “First Data”. 

      C.    Press right click then select rename, a window will appear then type “First Data”. 

D. Press right click then select rename, a window will appear then type “First Data”. 

A.      It allows an easy to see input box for formula in a cell 

B.     It is a selection of shortcuts different formula in Microsoft Excel

C.    It is the formula that allows computation of values from different cells. 

D. The Formula Bar is a label below the cell that indicates the result of a formula

A.      In the ribbon, select Home>Tabs>Add Tabs then input how many tab you like to add. 

B. In lower portion of the work area, press the plus button besides the tabs.  

C. Press Ctrl + A then press Ctrl + Shift + N.

D.   You can’t add tabs in Microsoft Excel.