Computer Quiz

1.What does this button mean?

oA. Align the text on the borders of the page.

oB. Extend the content on the entire length of the cell.

oC. Merge and center

2. If you copy the formula =$B$38 into another cell, the result will be:

oA.The column part will remain the same

oB. Both the column and row will remain the same

oC. Both will change

3. An Excel spreadsheet is primarily used for

oA. Writing formulas

oB. Making tables

oC. Making charts

oD. All of the above

4. All forumulas in Excel begin with the following symbol =

oA. True

oB. False

5. Which of the following option is a formula?

oA. =SUM(A1:A5)

oB. Add A1 - A5

oC. A1 = A5

6. The cell address in a formula is known as:

oA. Cell reference

oB. Cell mathematics

oC. Formularizing

1.What does this button mean?

oA. Align the text on the borders of the page.

oB. Extend the content on the entire length of the cell.

oC. Merge and center

2. If you copy the formula =$B$38 into another cell, the result will be:

oA.The column part will remain the same

oB. Both the column and row will remain the same

oC. Both will change

3. An Excel spreadsheet is primarily used for

oA. Writing formulas

oB. Making tables

oC. Making charts

oD. All of the above

4. All forumulas in Excel begin with the following symbol =

oA. True

oB. False

5. Which of the following option is a formula?

oA. =SUM(A1:A5)

oB. Add A1 - A5

oC. A1 = A5

6. The cell address in a formula is known as:

oA. Cell reference

oB. Cell mathematics

oC. Formularizing

7. Which formula below will add the value of B2 to the value of C3

oA. =B2+C3

oB. =6+4

oC. =B+C

8. A ____________ is the basic unit of a worksheet into which you enter

data.

oA. Cell

oB. Tab

oC. Chart

9. If i want to display the number as currency i should

oA. Insert the symbol of the currency in the cell

oB. Type the suitable currency symbol from the keyboard

oC. Format the number as currency

10. When you copy a formula with relative cell references down a

row,____________.

oA. the row references change in the formula

oB. The column references change in the formula

oC. No references are changed in the formula