Bissoy.com
Doctors Medicines MCQs Q&A

What is the main function of the electronic spread sheet?

What is the main function of the electronic spread sheet? Correct Answer All of Above

The correct answer is All of Above.

Key Points

  • An electronic spreadsheet can be used to automatically perform numerical calculations.
  • Spreadsheet programs are usually set up in the form of a table with rows and columns. 
  • Each row and column intersects to form a cell in which data may be stored.
  • These data may be a text label, a number, or a formula that combines data from other cells.
  • The spreadsheet software allows cells, rows and columns to expand, merge, be inserted and deleted. This helps when we are using lengthy text and equations.
  • The Excel sort function is useful for rearranging data. When working in Excel sorting data can quickly reorganize content too.
  • Filtering data in a spreadsheet allows only certain data to display. This function is useful when we want to focus on specific information.

[ alt="F1 Savita Engineering 25-5-22 D1" filter function dynamic filtering with formulas ablebits.com src="//storage.googleapis.com/tb-img/production/22/05/F1_Savita_Engineering_25-5-22_D1.png" style="width: 414px; height: 269px;">

Related Questions

A right angled triangle was cut from a rectangular sheet of length 20 cm whose perimeter is same as a square of side 30 cm. If height of the triangle is same as breadth of rectangular sheet and base is 1/4th of length of sheet then, the area of the remaining sheet is what percent of area of the whole sheet?
Consider the following statements regarding electronic voltmeter. 1) The detection of low-level signals is not possible using the electronic voltmeter 2) MOSFET is used at the input of the electronic voltmeter 3) Vacuum tube voltmeters (VTVM) consumes more power as compared to any non-electronic voltmeter. Which of the following is / are incorrect?
Match the columns. C commands Description 1. getch(); a. This command terminates the C program (main function) and returns 0. 2. return 0; b. This indicates the end of the main function 3. } c. This is the main function from where execution of any C program begins. 4. int main() d. This command waits for any character input from the keyboard.
Four paint brushes-A, B, C and D are used to paint or distort a sheet. A is twice as fast as B, C is twice as fast as D and B is 3/2 as fast as C. A distorts (1/8)th of the sheet, B distorts (1/4)th, C paints (3/8)th and D paints the rest. Only one paint brush can work at a time. It takes a total of 120 hours to paint the sheet. What is the time taken by C and D to paint the sheet?
Which of the following events after the balance sheet date would normally qualify as adjusting events according to AS-4 (Events after balance sheet date)? (A) The insolvency of a customer on the balance sheet date (B) A decline in the market value of investments (C) The declaration of an ordinary dividend (D) The determination of the cost of assets purchased before the balance sheet date Choose the most appropriate answer from the options given below:
Consider the following statements: 1. In India, the Himalayas are spread over five States only. 2. Western Ghats are spread over five States only. 3. Pulicat Lake is spread over two States only. Which of the statements given above is/are correct?
Consider the following statements regarding the spread of Jainism 1. Mahavira believed in organized Sanghas that would spread his teachings. 2. Jainism spread across Western India and Karnataka. Which of the above statements is correct?
Two statements are given followed by two conclusions as responses. You have to consider the statements to be true even if they seem to be at variance from the commonly known facts. You have to decide which of the given conclusion(s) can definitely be drawn from the given statements. Statements: Swine flu is spread by the outbreak of Influenza virus. The Government is taking a rigorous action to control the spread of Swine flu. Conclusions: Swine flu is a fatal disease. The Government needs to control the spread of Influenza virus.
Consider the following statements and choose the correct answer:
1. Every species of animal and plant tends to produce more offspring than can survive within the normal range of the organism
2. There is a strong population pressure tending to force the individuals of each species to spread out and become established in new territories
3. The spread of a species is prevented by highways, such as land connections between continents
4. The spread of species is facilitated by geographical barriers, such as oceans, mountains, deserts and large rivers
An example of an electronic spread sheet package is -