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:
Both Statement I and Statement II are false.
Let's analyze each statement to determine their validity:
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. We need to determine the contents of E11, E12, and E13.
When two cells with values forming an arithmetic sequence are selected and dragged, Excel continues the sequence. The sequence is in steps of 4 (from 4 in E9 to 8 in E10). Dragging this down:
- E11 will be 12;
- E12 will be 16;
- E13 will be 20.
Thus, Statement I is false as the values are not 9, 10, and 11.
Statement II: The formula \(A3*\$A\$\) is discussed.
In Excel, a relative reference changes when a formula is copied to another cell, while an absolute reference remains constant. Here, \($A\$\) indicates that Column A, Row 1 will remain constant, which is an absolute reference. \(A3\) is relative and will change depending on where the formula is copied.
Therefore, Statement II is also false as it incorrectly describes the reference types.
Thus, the correct answer is that both Statement I and Statement II are false.
Similar Questions
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:
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?
You need to use automatic calculations in preparing a budget. Which software application should be used?
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:
Important Questions from Types of Softwares
- Learning Management Systems (LMS) is a software application used for
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 ________
