You need to use automatic calculations in preparing a budget. Which software application should be used?
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
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:
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 play | II. Multimedia |
| C. Recording the income and expenses of a small club | III. Photo-editing |
| D. Removing 'red-eye' from a family picture | IV. Spreadsheet |
Choose the correct answer from the options given below:
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:
If you want to assess the students performance and want to give them immediate feedback, which software will you select?
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.
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:
Software that you can download for free, but have to pay to continue its use after a trial period is called:
Which of the following is an example of proprietary system software?
Select the true statement about an Operating System (OS)?
The computer software that runs a computer, including scheduling tasks, managing storage and handling communication with peripherals is called:
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.
| A | B | C | D | E | F | G | H | I | J | |
| 1 | Name | T1 | T2 | T3 | Q1 | Q2 | Q3 | Q4 | HW | AVG |
| 2 | Jatin | 87 | 92 | 80 | 76 | 79 | 87 | 74 | 90 | |
| 3 | Amit | 91 | 85 | 77 | 78 | 88 | 96 | 90 | 92 | |
| 4 | Anil | 65 | 72 | 70 | 80 | 81 | 74 | 77 | 80 | |
| 5 | Anita | 96 | 88 | 91 | 76 | 91 | 100 | 74 | 98 |
Which of the following formulae would NOT be a correct calculation of the six-week weighted average for Jatin?
Consider the following spreadsheet:
| A | B | C | |
| 1 | 4 | 3 | |
| 2 | 5 | 2 | |
| 3 | 7 | ||
| 4 | 8 | 9 | |
| 5 | 9 | ||
| 6 |
If the formula = $A3 + B2 in cell C4 is copied to cell C5, then what is the value in cell C5?
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
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 ________