Skip to main content

Posts

Practicals -1

    Step 1: Enter your data | Region | Salesperson | Sales | | :----- | :---------- | ----: | | East   | John        |   500 | | West   | Mary        |   300 | | East   | Alex        |   200 | | West   | John        |   400 | | North  | Mary        |   350 | | South  | Alex        |   250 | | North  | John        |   450 | --- Step 2: Select your data Click and drag to select **all your data including the headers** (A1:C8 in this case). *Step 3: Create a Pivot Table (for grouping) 1. Go to    `Data → Pivot Table → Create…` 2. In the dialog box, choose **“Current Selection”** and click **OK**. --- Step 4: Arrange the fields In the Pivot Table layout dialog: * Drag **`Region`** to the **Row Fields** area...
Recent posts

Top 10 MCQ's and Q&A's

  1. Which of the following is NOT a category of styles in LibreOffice Writer? a) Page Style b) Character Style c) Image Style d) Table Style Answer: c) Image Style 2. What is the shortcut key to open the Styles window in LibreOffice Writer? a) F10 b) F11 c) Ctrl + S d) Alt + F Answer: b) F11 3. Which feature in LibreOffice Writer helps track modifications in a document by multiple users? a) Style Manager b) Track Changes c) Page Layout d) Text Formatting Answer: b) Track Changes 4. What is the purpose of the "Table of Contents" in a document? a) To organize text in rows and columns b) To display a summary of headings and subheadings c) To insert footnotes d) To create numbered lists Answer: b) To display a summary of headings and subheadings 5. Which option allows a user to save a document as a template in LibreOffice Writer? a) File > Save As b) File > Templates > Save c) Edit > Save As Template d) View > Save Template Answer: b) File > Templates > Save...

Top 10 MCQ's and Q&A

  Unit -4 . Which of the following is a common workplace hazard? (a) Physical hazards (b) Chemical hazards (c) Biological hazards (d) All of the above ✅ Answer: (d) All of the above 2. What should be the first step in case of a fire at the workplace? (a) Evacuate patients and staff (b) Call the fire department (c) Activate the fire alarm procedures (d) Use water to put out the fire ✅ Answer: (c) Activate the fire alarm procedures 3. Why are electrical outlets not supposed to be overloaded in hospitals? (a) It may cause a short circuit and fire (b) It can increase electricity consumption (c) It may affect other equipment functioning (d) It can make the wires look messy ✅ Answer: (a) It may cause a short circuit and fire 4. Which agency provides global recommendations for controlling hospital infections? (a) WHO (b) UNESCO (c) NASA (d) FDA ✅ Answer: (a) WHO 5. Which of the following is NOT a part of patient care safety measures? (a) Identifying patients at risk (b) Preventing falls (...

Notes on Spreadsheet & DBMS & DigiDOc

  Electronic Spreadsheet Question Answer What do you mean by Open Office? Explain. Open Office is a powerful program within the spreadsheet environment . It assists us in working with and storing data. Through Open Office, you can perform powerful calculations, create charts, and generate reports. The program includes 65536 rows and 1024 columns. What is the difference between Workbooks and Worksheets? A Workbooks is a multi-page document . A Worksheet is one page within that document. Many worksheets combined together form a workbooks. A worksheet is constructed using rows and columns. What do you mean by Range? A range is a group of consecutive cells . What do you mean by Data Consolidation? Data consolidation allows you to gather together data from separate worksheets into a master worksheet . The function also allows an analyst to combine information from multiple workbooks into one place. What is Subtotal? Subtotal is used to create a group where you can perform different t...

Paper -1

 Students, please go through these  ------------------------------------------------------------------------------------------------------------- Q. Database Management System 1. Create table EMPLOYEE (EMPID Char(4), EMPNAME Varchar(15), DESIGN Varchar(20), SALARY Decimal). 2. What is a primary key? 3. Categorize the following commands as DDL and DML: SELECT, ALTER, INSERT, DROP. 1.   Multiple-Choice Questions (MCQs)    1. What is the importance of effective communication in a workplace? (a) Reducing office expenses (b) Enhancing team collaboration and productivity (c) Increasing employee vacation days (d) Improving office aesthetics 2. High expectations from self can leave with chronic anxiety and stress, thus leading to stress. (a) Physical (b) Emotional (c) Social (d) Financial 3. John notices that the cost of raw materials is lower in a different supplier's location compared to his current supplier. He decides to switch to the new supplier to save money...

Unit 4: Entrepreneur and Entrepreneurship

  Entrepreneurial Skills --------------------------------- # Definition and Scope *   What is Entrepreneurship?  It is a type of self-employment where an individual runs a business to satisfy people's needs and seeks ways to improve the business and make profits. *   Career Options: There are two main ways a person can earn a living: Self-employment (e.g., a doctor running their own clinic) or Wage employment (e.g., a doctor working for a hospital). # Qualities of Successful Entrepreneurs Successful entrepreneurs demonstrate several key traits: *   Confidence and Belief: They are confident and believe in themselves and their abilities. They must believe in themselves and be confident in taking business decisions. *   Patience and Optimism: They are patient. They should also be patient and optimistic. *   Creativity and Innovation: They are creative and think differently about business ideas. They must have a creative and differ...

Unit 5: Sustainable Development

1. Write the difference between the conventional approach to address environmental issues and sustainable development. Ans. Conventional Approach: Focuses only on economic growth and industrial development without considering long-term environmental impacts. Sustainable Development: Balances economic growth, social equity, and environmental protection to meet present needs without compromising the needs of future generations. 2. How is food one of the major problems related to sustainable development? Discuss briefly. Ans. Food is a major problem because of unequal distribution, wastage, and overuse of resources in production. While some people suffer from hunger, others waste food. Unsustainable farming practices also harm soil, water, and biodiversity. 3. What is the major purpose of the SDGs? Ans. The main purpose of Sustainable Development Goals (SDGs) is to end poverty, protect the environment, promote equality, and ensure peace and prosperity for all by 2030. ...