All Exams Test series for 1 year @ ₹349 only
Question

You need to use automatic calculations in preparing a budget. Which software application should be used?

This question was previously asked in
UGC NET 2019 Home Science Question Paper (04-Dec-2019) (Shift 2)
The correct answer is

Spreadsheet

Preparing a budget with automatic calculations calls for software that arranges data in rows and columns of cells and can compute values automatically using formulas and functions. This is exactly what a Spreadsheet application (such as Microsoft Excel, LibreOffice Calc or Google Sheets) is designed to do: it lets you enter figures, apply formulas like sums, totals, percentages and running balances, and it recalculates results instantly whenever any input changes.

Why the others are wrong: a Presentation package (like PowerPoint) is meant for creating slides for display, not for calculations; a Word processing program is designed for typing and formatting text documents and cannot automatically compute numeric relationships across cells; Desktop publishing software is used for page layout and designing brochures, newsletters and print material, not for arithmetic on budget data.

Only a spreadsheet provides the cell-based automatic calculation needed for budgeting.

Correct answer: Spreadsheet

Was this answer helpful?

Similar Questions

  1. Which of the following file formats contain exclusively the sound file format suitable for distribution across the Internet?

    A. AVI
    B. MIDI
    C. WMV
    D. WMA
    E. MP4

    Choose the correct answer from the options given below:

  2. Match List I with List II
     

    LIST I (Task)LIST II (Software Application)
    A. Combining video, audio, text and images I. Desktop publishing
    B. Creating a poster that advertises a school playII. Multimedia
    C. Recording the income and expenses of a small club III. Photo-editing
    D. Removing 'red-eye' from a family pictureIV. Spreadsheet

    Choose the correct answer from the options given below:

  3. Given below are two statements regarding MS-Excel:
    Statement I : Cell E9 contains the value 4 and E10 contains the value 8. You select both the cells and drag the fill handle down to E13. The contents of cells E11, E12 and E13 will be 9, 10 and 11, respectively.
    Statement II: The formula =A3*$A$1 has the reference to cell A1 set as a relative reference while the reference to cell A3 is an absolute reference.
    In the light of the above statements, choose the correct answer from the options given below:

  4. If you want to assess the students performance and want to give them immediate feedback, which software will you select?

  5. Which of the following applications A-C are built on top of open-source digital platforms?
    A. Google Earth
    B. DIKSHA
    C. MySQL
    Choose the correct answer from the options given below.

  6. Match List I with List II:

    List I (Software)List II (Description)
    (a) Web browser (i) Prepare written documents
    (b) Word processor(ii) Create and edit web pages
    (c) Spreadsheet(iii) Connect to websites and display web pages
    (d) Web authoring(iv) Analyze and summarize numerical data

    Choose your answer from the following options:

  7. Software that you can download for free, but have to pay to continue its use after a trial period is called:

  8. Which of the following is an example of proprietary system software?

  9. Select the true statement about an Operating System (OS)?

  10. The computer software that runs a computer, including scheduling tasks, managing storage and handling communication with peripherals is called:


Important Questions from Types of Softwares

  1. Learning Management Systems (LMS) is a software application used for
  2. Suppose that the class grade for a six-week period is based on three tests (T1, T2, T3), each of which counts for 15%, four quizzes (Q1, Q2, Q3, Q4), each of which counts for 10%. and a homework note book (HW), which counts for 15%. The grades are recorded in a spreadsheet similar to the one below.

    ABCDEFGHIJ
    1NameT1T2T3Q1Q2Q3Q4HWAVG
    2Jatin8792807679877490
    3Amit9185777888969092
    4Anil6572708081747780
    5Anita96889176911007498

    Which of the following formulae would NOT be a correct calculation of the six-week weighted average for Jatin?

  3. Consider the following spreadsheet:

    ABC
    143
    252
    37
    489
    59
    6

    If the formula = $A3 + B2 in cell C4 is copied to cell C5, then what is the value in cell C5?

  4. Given below are two statements:

    Statement I: Shareware is a software that the users can try out for a trial period only. before being charged.

    Statement II: Freeware is a software that the users can download free of charge. but they cannot modify the source code in any way.

    In the light of the above statements. choose the correct answer from the options given below  

  5. In MS-EXCEL, Cell B9 contains the value 3, and B10 contains the value 6. You select both the cells and drag the fill handle down to B13. The contents of the cell B11, B12, and B13 will be ________

Need Expert Advice?
Upcoming Exams
CTET
September 06, 2026
MH SET
September 06, 2026
Test Series
UGC NET img
Teaching
UGC NET Library and Information Science 2024 - 2025 Mock Test Series
66 Tests 4 Tests Free
719 Attempts
4.4(17)
English, Hindi

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App