QUIZ 4 -- MICROSOFT EXCEL

FPrint this page or write answers on a sheet of paper.

1.    A worksheet is better than calculations by hand because:

        a.    The worksheet finds the answers faster.

        b.    The worksheet is more accurate.

        c.    The worksheet recalculates the results whenever you change a number in the cell.

        d.    All of the above

 

2.    The cell where the second column and third row cross has the cell address:

        a.    B3

        b.    3B

        c.    C2

        d.    2C

 

3.    What will happen if you type F5+F6 into a cell without a beginning equal sign?

 

        a.    The entry is the same as the formula =F5+F6

        b.    The cell will display the information cell F5 plus F6

        c.    The entry will be treated as a text entry and F5+F6 will show in the cell.

 

4.    The Open command:

 

        a.    Brings a workbook from a file onto the screen.

        b.    Brings a workbook from a file onto the screen, then erases the workbook from the file.

        c.    Saves the workbook on a disk or in a file.

        d.    Saves the workbook on a disk or in a file, then erases the workbook from the screen.

 

5.    The save command:

 

        a.    Brings a workbook from a file onto the screen.

        b.    Brings a workbook from a file onto the screen, then erases the workbook from the file.

        c.    Saves the workbook on a disk or in a file.

        d.    Saves the workbook on a disk or in a file, then erases the workbook from the screen.

 

6.    The entry =(A4+A5+A6)/3:

 

        a.    Will not work.

        b.    Finds the total of cells A4, A5, and A6.

        c.    Finds the average of cells A4, A5, and A6.

 

7.    If cell A1=10 and cell A2=5, what number will show in a cell with the following formula:

        =A1*A2.

 

        a.    15

        b.    5

        c.    20

        d.    50

 

8.    If cell A1=10 and cell A2=5, what number will show in a cell with the following formula:

        =A1+A2

 

        a.    15

        b.    5

        c.    20

        d.    2

 

9.    If cell A1=10 and cell B1=10, what number will show in a cell with the following formula:

        =(A1+B1)/2

 

        a.    9

        b.    12

        c.    8

        d.    10

 

10.    If cell A1=22 and cell B1=10, what number will show in a cell with the following formula:

         =A1-B1

 

        a.    9

        b.    10

        c.    12

        d.    8

 

11.    What type of chart is this?

 

       

 

        a.    bar

        b.    column

        c.    area

        d.    pie

 

 

Click to check your answers

 

[Home] [Welcome Page] [Curriculum] [Requirements] [Useful Information] [Dictionary/Thesaurus] [Test Your Knowledge] [Keyboarding Test] [Calendar] [Virus Info] [Links] [Contact]