Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Final Computerized Midterm 2020

    Uploaded by

    ibrahim mohamed

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Final Computerized Midterm 2020

    Uploaded by

    ibrahim mohamed
    20 views15 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    20 views15 pages

    Final Computerized Midterm 2020

    Uploaded by

    ibrahim mohamed

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 15

    1. Which one of the following items is not found on a Balance Sheet?

    A. Cash B. Gross Profit C. Assets D. Liabilities

    2. Which would you find on an Income Statement?


    A. Expense B. Fixed Asset C. Liability

    3. An account receivable is:


    A. an Asset B. Owner’s Equity C. a Liability

    4. Which of the following is a basic accounting equation:


    a) Net Worth = Assets + Profits
    b) Gross Profit - Sales = Gross Profit Margin
    c) Assets = Liabilities + Equity

    5. Which of the following financial statements is prepared as of a specific date?


    a. Balance sheet. C. Income statement.
    b. Owner's equity statement. D. Statement of cash flows

    6. Net income will result during a time period when:


    a. assets exceed liabilities c. assets exceed revenues.
    b. expenses exceed revenues. D. revenues exceed expenses

    7. In which order are the financial statements usually prepared?


    a. Balance Sheet, Statement of Owner's Equity, Income Statement
    b. Income Statement, Statement of Owner's Equity, Balance Sheet
    c. Statement of Owner's Equity, Balance Sheet, Income Statement
    d. The financial statements can be prepared in any order.

    8. Excel is an example of what type of software?


    a. Spreadsheet Software
    b. Presentation Package
    c. Word Processor

    9. Which of the following is not part of the Ribbon?


    a. Home b. Data
    c. Tools d. insert

    10. In Excel, the following mouse pointer will allow us to


    a. Copy data b. Delete data
    c. Move data d. Select data

    11. Which types of charts can excel produce?


    a. Line graphs and pie charts only
    b. Only line graphs
    c. Bar charts, line graphs and pie charts
    d. Bar charts and line graphs only

    12. How are data organized in a spreadsheet?


    a. Lines and spaces
    b. Layers and planes
    c. Rows and columns
    d. Height and width
    13. Which of the following gives spreadsheet the main powerful features?
    a. Formula
    b. Cell
    c. Sort
    d. Hyperlink

    14. You can quickly change the appearance of your work by choosing Auto Format from
    the …….. Menu
    a. Edit
    b. View
    c. Format
    d. Insert

    15. If you press ……, the cell accepts your trying as its contents.
    a. Enter
    b. Ctrl + enter
    c. TAB
    d. Insert

    16. This type of software is similar to an accountant's worksheet


    a. Word processing
    b. Database
    c. Spreadsheets
    d. graphics

    17. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart
    from the selected cells?
    a. F3
    b. F5
    c. F2
    d. F11

    18. …………when row and column meet, defined through a column-row address.
    a. cell. b. box. c. title bar. d. formula bar.

    19. ………….. called raw data that the user had from source document.
    a. information. b. input. c. output. d. reports.

    20. ………….. is the function to Deleting cells, Clearing the content of the cell, Copying or
    Cutting cell content.
    a. Editing cells. b. dragging cells. c. moving cells. d. holding cells.

    21. hold the cell or the cells you want to copy function called ……………
    a. Editing cells. b. dragging cells. c. moving cells. d. holding cells.

    22. Write …… before the name of the column and name of row of a specified cell in the
    formula to make this absolute reference.
    a. #. b.$. c. &. e.%.

    23. …………………… means the function will never get an ended value because the function
    depends on the function itself [it will loop for no end]:
    a. Circular reference. b. Fixed range. c. Constants cells. e. Relevant range.
    Example
    A B C D E F
    1 Invoice Customer Date Units sold Unit price ?
    2 1001 Cairo Co. 05/05/2012 1,000 100 ?
    3 1002 Alex Co. 06/05/2012 2,000 200 ?
    4 1003 Tanta Co. 20/05/2012 3,000 300 ?
    5
    6 ? ?
    1- What is designed in the worksheet?
    a. Purchase Journal. b. Cash receipts journal. c. Cash disbursement journal. d. Sale journal.

    2- What explanation should be written in F1?


    a. Expenses. b. Assets. c. Sales. d. Liabilities.

    3. What is the formula (real content) for the cell F2?


    a. D2*E2 b. =SUM(D2:E2). c. =D2*E2. d. =d2*e2.

    4- What is the formula (real content) for F3?


    a. = D3 * E3. b. =D3+E3. c. =D3*E3. d. =D3-E3.

    5- We can apply calculation for all customers by?


    a. Copy & paste. b. Enter. c. insert. d. by using the fill handle tool and drag down.

    6- if the unit selling price is constant in E2 by $100 what formula should be in F2?
    a. =D2*$E$2. b. =SUM(D2:E2). c. =D2*E2. d. =d2*e2.

    7- …………. is used to calculate the total of any value written in column F.


    a. =SUM(F:F). b. =F+F. c. =F1+F2+F3+F4+F… d. =Total(F:F).

    8- What is the amount will be in F2?


    a. 100000. b. =SUM(D2:E2). c. =D2*E2. d. =d2*e2.

    9- What is the formula should be written in F6?


    a. =SUM(F2:F4). b. =Sum(F2:F4). c. =SUM(F2:F5). e. =F2+F3.

    10- - excel will …………………..if any new sales added.


    a. update value of sales& Total sales. b. update expenses. c. update Cash. e. Update inventory.

    11- What the amount of total sales of F6:


    a. 1400000. b. =SUM(F2:F4). c. =SUM(F:F). d. =(F2+F3+F4).

    12- what is written in


    a. Total sales. B. Total purchase. C. Total cost. D. Total memorandum

    What is the journal entry for this transactions?


    Dr Cr

    A/R 1400000

    Sales 1400000
    Use the following spreadsheet to answer questions 14-16.

    What is the real content of cell H46


    a. =SUM(G42:G45)
    b. +SUM(G42:G45)
    c. =(G42:G45)
    d. SUM(G42:G45)
    Which feature has been used to write A-Tech Company in more than a single cell:
    a. Warp text
    b. Merge & center
    c. Cell styles
    d. Split cells
    What is the real content of cell H47:
    a. =SUM(+H40-H46)
    b. =+H40:H46
    c. =+(H40-H46)
    d. =+H40-H46

    INCOME STATEMENT and Pie chart

    Cell Function Cell Function

    D10 =D6-D8 D14 =D10-D12

    G12 =SUM(G6:G11) J12 =SUM(J6:J11)

    Chart =SERIES(;Chart!$C$6:$C$14;Chart!$D$6:$D$14;1)
    Example

    What is the real content of cell H58:


    a. =H56:H55
    b. =H56+H57+H55
    c. SUM(H56:H55)
    d. SUM(H56+H57+H55)
    What is the real content of cell H60
    a. +H58+H59
    b. =+H58:H59
    c. =+H58+H59
    d. SUM+H58+H59

    what is the real content of cell F74:


    a. SUM (F69:F72)
    b. =SUM (F69:F72)
    c. =SUM (F69-F72)
    d. =SUM (F69:F72)
    what is the real content of cell L74:
    a. =SUM (L71:L73)
    b. =+L71+L73
    c. a and b
    d. none of the above
    amount in cell F74 must equal amount in cell(s):
    a. F69, F70, F71 and F72
    b. L74
    c. L71 and L73
    d. all of the above
    Error:
    #Name? invalid name error (not recognize text in formula).
    #Value? Error in value (the function has a text in such cell).
    #DIV/0? Divided number / zero.
    #######? The wide of the cell is too small for the text of the cell.
    Example

    Question Answer

    What the real content (formula) inserted in B5 ………………………… =B3+B4

    What the real content (formula) inserted in B6 ………………………… =B3-B4

    What the real content (formula) inserted in B8 ………………………… =B5/B7

    What the real content (formula) inserted in B10………………………… =B5/B9


    Example:-

    Question Answer

    What the real content (formula) inserted in F4 ………………………… =SUM(B4:E4)

    What the real content (formula) inserted in G4 ………………………… =AVERAGE(B4:E4)

    What the real content (formula) inserted in H4………………………… =MAX(B4:E4)

    What the real content (formula) inserted in I4………………………… =MIN(B4:E4)

    What the real content (formula) inserted in J4………………………… =F4*$J$1

    Or

    =F4*$J1

    How to copy the formula from F4 to the remaining cell Hold and drag
    Cell Function Cell Function

    J87 =J86+H87-I87 J88 =J87+H88-I88

    J89 =J88+H89-I89 J90 =J89+H90-I90

    J91 =J90+H91-I91 J92 =J91+H92-I92

    J93 =J92+H93-I93 J94 =J93+H94-I94

    You might also like