ELECTRONIC SPREADSHEET (ADVANCED)

 ELECTRONIC SPREADSHEET (ADVANCED)

1. What is the use of data consolidation?

Data Consolidation is used to gather together our data from separate worksheets into a master worksheet. 

2. Define Subtotal.

SUBTOTAL is used to total/add data arranged in an array i.e., a group of cells with labels for columns and/or rows. 

3. What is Scenario?

Scenarios are a tool to test “what-if” questions. It is essentially a saved set of cell values used for calculations 

4. What is Goal Seek?

Goal seeking is the process of finding the correct input value when only the output is known. 

5. What is Solver?

Solver is a more elaborate form of Goal Seek.  It deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that has been defined.

6.  Define cell reference.

A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that we want the formula to calculate. 

7. Name the ways in which we can create reference to a sheet.

The ways in which we can create reference to a sheet are by mouse and by keyboard. 

8. What is the use of hyperlink in Calc?

Hyperlinks are used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites. 

9. What is the difference between absolute hyperlink and relative hyperlink?

An absolute hyperlink will stop working only if the target is moved while A relative hyperlink will stop working only if the start and target locations change relative to each other. 

10. State the advantages of sharing a spreadsheet.

Advantages of sharing a spreadsheet are

·         Speed up data entry as Multiple people can enter data in the spreadsheet simultaneously

·         Simply make things easier for collaboration purposes.

 

11. Explain Macro.

Macros help in saving time in cases when the same set of tasks are to be done repeatedly like formatting or applying a similar formula in a similar range of data. It can be used to name and record a set of actions or set of actions.

 

 

Popular posts from this blog

ENTREPRENEURSHIP SKILLS - II

 ENTREPRENEURSHIP SKILLS - II 1. What is Society? Society is described as an aggregate of people living together in a community, who associate for various engagements including business. 2. What does an Entrepreneur do? An entrepreneur combines factors in a creative manner in order to generate value for customers and create wealth. 3. What are the positive impacts of Entrepreneurship on Society? The positive impacts of Entrepreneurship on Society are Emphasize economic Growth Fosters Creativity Stimulates Innovation and Efficiency Creates Jobs and Employment Opportunities Solves the problems of the society Encourages welfare of the society   4. What role does Society plays in boosting entrepreneurship? Society plays the following roles in boosting entrepreneurship: Creates needs and demands Provides raw materials Enables financial support Creates a need for education Catalyses policy formation and reform Facilitates networking Supports infrastructure developm...
Read more

SELF MANAGEMENT SKILLS - II

SELF MANAGEMENT SKILLS – II   1. What is Self-management? Self-management, also referred to as self-control is the ability to control one’s emotions, thoughts and behavior effectively in different situations. It also includes motivating oneself and setting goals.   2. What are the Basics of Self-management? The basics of Self-management are Self-awareness Responsibility Time Management Adaptability   3. What is Stress? Stress can be defined as our emotional, mental, physical and social reaction to any perceived demands or threats.   4. What are stressors? These demands or threats which are the reasons for causing stress are called stressors.   5. What is Stress Management? Stress Management refers to the method of managing stress properly.   6. Explain the ABC of Stress Management. The ABC of stress management is as follows: A: Adversity or the stressful event B: Beliefs or the way you respond to the event C: Conseque...
Read more
  WEB APPLICATIONS AND SECURITY   1. What is Computer Accessibility? Computer Accessibility refers to the user friendliness of a computer system for all regardless of their disability.   2. Name the numerous types of impairment that impact computer usage. The numerous types of impairment that impact computer usage are Cognitive impairments and learning disabilities, such as dyslexia, attention deficit-hyperactivity disorder (ADHD) or autism. Visual impairment such as low-vision, complete or partial blindness, and color blindness. Hearing impairment including deafness. Motor or dexterity impairment such as paralysis, cerebral palsy, or carpal tunnel syndrome and repetitive strain injury. 3. What is the function of Sticky Keys? StickyKeys is an accessibility feature to help computer users with physical disabilities, but it is also used by others as a means to reduce repetitive strain   4. What is the use of Filter Keys? FilterKeys is an accessib...
Read more