Prasanna

Students can Download Chapter 5 Accounting Software Package – GNUKhata Questions and Answers, Plus Two Accountancy Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Chemistry Chapter Wise Questions and Answers Chapter 5 Accounting Software Package – GNUKhata

Plus Two Accountancy Accounting Software Package – GNUKhata One Mark Questions and Answers

Question 1.
_________ is a free and open source software for accounting, developed by Digital Freedom Foundation.
Answer:
GNUKhata

Question 2.
The first step in GNUKhata is ________
(a) To create an organisation
(b) To create Ledger account
(c) Voucher entry
(d) None of these
Answer:
(a) To create an organisation

Question 3.
Write the path for starting GNUKhata
Answer:
Applications → Office → GNUKhata

Question 4.
Which among the following is not a level of users in GNUKhata
(a) Managing Director
(b) Admin
(c) Manager
(d) Operator
Answer:
(a) Managing Director

Question 5.
GNUKhata has ………… (a) …………… predetermined groups and ……… (b) ……….. subgroups
Answer:
(a) 13
(b) 16

Question 6.
Amount received by way of cash or cheque is recorded in GNUKhata by using ________ voucher type
Answer:
Receipt Voucher (F4)

Question 7.
Short cut keys for activating Credit Note is _______
(a) Ctrl + 1
(b) Ctrl + 2
(c) Ctrl + 3
(d) Ctrl + 3
Answer:
(d) Ctrl + 3

Question 8.
To clone a voucher means
(a) To delete a voucher
(b) To copy a voucher
(c) To edit a voucher
(d) To print a voucher
Answer:
(b) To copy a voucher

Question 9.
From ________ menu, we will enable to view Ledger,
Trial Balance, Balance sheet, Profit and Loss AC etc.
Answer:
Report menu

Question 10.
Which among the following is NOT a feature of GNUKhata?
(a) Free and open source accounting software
(b) Based on double entry book keeping
(c) Coding of Ledger account
(d) Linking of sales and purchase transactions to invoices
Answer:
(c) Coding of Ledger account

Question 11.
What is FOSS?
(a) Free and Open Security Software
(b) Financial Accounting Open Source Software
(c) Free and Open System Software
(d) Free and Open Source Software
Answer:
(c) Free and Open Source Software

Question 12.
Left side of the GNUKhata welcome screen shows __________
(a) Three buttons and dialog box
(b) Description about double entry principles
(c) Printer settings and network
(d) Description about the advantages and developer of GNUKhata
Answer:
(d) Description about the advantages and developer of GNUKhata

Question 13.
Short Cut keys Shift + Ctrl + R is used for ________
Answer:
Create Organisation

Question 14.
Choose the statement which is NOT True
(a) We can create a new group but a new sub group can not be created
(b) We can not create a new group but a new sub group can be created
(c) We cannot delete a group or a sub group
(d) We cannot create a sub group of a sub group
Answer:
(a) We can create a new group but a new sub group can not be created

Question 15.
______________ is prepared by an account holder to check whether all cheques deposited by him are cleared and all cheques
issued by him are presented on not.
(a) Bank Reconciliation statement
(b) Trading, Profit and Loss Account & Balance Sheet
(c) Cash Book and Pass Book
(d) Trial Balance
Answer:
(a) Bank Reconciliation statement

Question 16.
Sub Group “Sundry Debtors” coming under ________ Group
Answer:
Current Asset

Question 17.
Choose the right statement
(a) Once organisation is created, the financial year can be changed whenever necessary
(b) Once organisation is created, the financial year can not be changed.
Answer:
(b) Once organisation is created, the financial year can not be changed.

Question 18.
Create is mandatory in GNUkhata
(a) Internal Auditor
(b) Operator
(c) Manager
(d) Admin
Answer:
(d) Admin

Question 19.
Which one of the following is free and open source software for Accounting
(a) Tally
(b) PeechTree
(c) GNUKhata
(d) None of these
Answer:
(c) GNUKhata

Question 20.
Which accounting software can be easily transformed into Indian languages?
Answer:
GNUKhata

Question 21.
When we open GNUKhata for the first time, we will see ______
(a) Create Organisation window
(b) Voucher Entry window
(c) Welcome screen
(d) User name and Password window
Answer:
(c) Welcome screen

Question 22.
Which type of organisation can be created in GNUKhata?
(a) Profit Making Organisations
(b) Not for Profit Organisations
(c) (a) and (b)
(d) None of these.
Answer:
(c) (a) and (b)

Question 23.
Only ______ user can log in as ‘Admin’
(а) One
(b) Two
(c) Many
(d) None
Answer:
(a) One

Question 24.
Write path for deleting an organisation.
Answer:
Log in as ‘Admin user’ → Administration menu → Select ‘Delete Organisation’.

Question 25.
The sub Group ‘Plant and Machinery’ is coming under _______________ group.
Answer:
Fixed Assets

Question 26.
Which among the following is not a Profit and loss A/c Group in GnuKhata.
(a) Direct Income
(b) Direct Expenses
(c) Indirect Income
(d) None of these
Answer:
(d) None of these

Question 27.
There are system generated ledger accounts in GNUkhata
(a) One
(b) Two
(c) Three
(d) Four
Answer:
(d) Four

Question 28.
In GNUKhata, while creating a Ledger account, we have to enter opening balance only if _________
(a) The account belongs to Trading, P/La/c group
(b) The account belongs to a Balance sheet group
(c) It is a cash account
(d) It is a Liability account
Answer:
(b) The account belongs to a Balance sheet group

Question 29.
Contra Voucher is used to record.
(a) Deposits or withdrawals of cash from the bank
(b) Transfer of fund from one bank to another
(c) Transfer of cash to petty cash
(d) All the above
Answer:
(d) All the above

Plus Two Accountancy Accounting Software Package – GNUKhata Two Mark Questions and Answers

Question 1.
Write the Path to display Trial Balance.
Answer:
Report → Trial Balance → Enter Date → Select Trial Balance Type → Click on view button

Question 2.
What is BRS?
Answer:
A Bank Reconciliation Statement (BRS) is a Statement prepared by the depositor for the purpose of reconciling the cash book balance with the pass book balance on a certain date.

Question 3.
There are four levels of users in GNUKhata. Who are they?
Answer:

1. Admin
2. Manager
3. Operator.
4. IntemalAuditor.

Question 4.
Match the following
Group Name Sub-Group Name

Group Name	Sub-Group Name
(a) Fixed Assets	(i) Sundry Creditors
(b) Current Liability	(ii) Loans and Advances
(c) Investments	(iii) Furniture
(d) Current Assets	(iv) Fixed Bank Deposits

Answer:
(a)- (iii); (b) – (i); (c) – (iv); (d) – (ii)

Question 5.
List down the Income and Expenditure account groups in GNUKhata
Answer:

• Direct Income
• Direct Expenses
• Indirect Income
• Indirect Expenses

Question 6.
Identify the group and sub group under which the following ledger accounts are to be created.
(a) Depreciation
(b) Carriage inward
(c) Bills Receivable
(d) Drawings
Answer:

Question 7.
List down any two features of GNUKhata.
Answer:

1. It is free and open source accounting software.
2. It is based on double entry book keeping.
3. All financial reports can be prepared.
4. Display of dual ledger facility.
5. Attachment of source document to vouchers is possible.
6. Linking of sales ad purchases tranactions to invoice.
7. Export or import of data from spread sheet is possible.
8. It ensures password security and data audit facility.

Question 8.
Define Groups and Sub Groups in GNUKhata.
Answer:
Grouping of account is a method of organising the large number of ledger accounts into sequential arrangement. GNUKhata has 29 predefined Groups and Sub Groups. Out of these, 13 are Groups and 16are Sub Groups.

Question 9.
What are the three buttons in Right side of the GNUKhata welcome screen?
Answer:

1. Select Existing Organisation
2. Create Organisation
3. Language

Question 10.
What is the use of ‘Theme’ tab in GNUKhata Menu Bar?
Answer:
‘Theme’ tab is used to change the theme Background of the screen.

Plus Two Accountancy Accounting Software Package – GNUKhata Three Mark Questions and Answers

Question 1.
What are the specialities of system generated Ledger Accounts
Answer:

1. GNUKhata has four system-generated ledger account.
2. We cannot change the name of these accounts.
3. We can not delete these accounts.

Question 2.
What are the limitations of GNUKhata?
Answer:

1. Only trained employees can use GNUKhata.
2. Updations and additions in GNUKhata Software may seriously affect the accounting system.

Question 3.
Mr. Roby prepared a chart for grouping the ledger account. Some errors are identified by his teacher. Help him to rectify the errors.

Ledger Account	Group
(a) Office expenses	Direct Expenses
(b) Carriage Inward	Direct Expenses
(c) Salary	Indirect Expenses
(d) Sales Tax	Direct Expenses
(e) Purchases	Indirect Expenses

Answer:

Ledger Account	Group
(a) Office expenses	Indirect Expenses
(b) Carriage Inward	Direct Expenses
(c) Salary	Indirect Expenses
(d) Sales Tax	Indirect Expenses
(e) Purchases	Direct Expenses

Question 4.
Three options are available to view Trail Balance. What are they?
Answer:

1. Net Trial Balance
2. Gross Trial Balance
3. Extended Trial Balance

Question 5.
Define the following
(a) Credit note voucher
(b) Journal voucher
(c) Sales voucher
Answer:

(a) Credit note	For recording a reduction in the price charged to a customer. Function key: Ctrl + 3
(b) Journal	For recording rectifying entries, transfer entries, adjustment entries, purchase of fixed assets on credit and sale of fixed assets on credit. Function key: F9
(c) Sales	For recording the return of goods by a customer Function key: Ctrl + 1

Question 6.
Write the Debit and Credit for the following accounting Transactions
(a) Returned goods to Vinu Rs. 5000
(b) Price of goods sold to Mohan reduced by Rs. 500
(c) Vinu returned goods worth Rs. 3000
Answer:

Question 7.
What is the importance of ‘Admin’ user in GNUKhata?
Answer:

• Only one user can login as Admin
• The creator of organisation is always considered as Admin User
• The ‘Admin’ user can create the other users ‘Admin’ user

Question 8.
List down the major Sub Groups in the Group ‘Fixed Assets”?
Answer:

• Building
• Furniture
• Land
• Plant and Machinery

Question 9.
Match the following

Answer:
(a) → ii → x
(b) → iii → y
(c) → i → z

Question 10.
Rearrange the diagram in the right way

Answer:

Plus Two Accountancy Accounting Software Package – GNUKhata Four Mark Questions and Answers

Question 1.
How to record the opening balance amount in opening Stock Account?
Answer:
stage 1:

• Step 1 → Click on Master tab.
• Step 2 → Select Edit account option from the drop down list.
• Step 3 → Select Stock at the beginning from the edit account window.
• Step 4 → Click on Edit Button.
• Step 5 → Enter opening balance amount.
• Step 6 → Click on Save button to save the amount.

Stage 2:

• Step 1 → Click on Transaction tab.
• Step 2 → Select Journal option to activate Journal Voucher.
• Step 3 → Enter voucher number.
• Step 4 → Enter opening date.
• Step 5 → Select Opening stock a/c in Dr. Account and enter opening stock amount.
• Step 6 → Select stock at the beginning a/c in the Cr. account and enter the opening stock amount.
• Step 7 → Give narration.
• Step 8 → Click on Save button or Press Enter key.

Question 2.
What are the reasons behind the difference in pass book balance and cash book balance.
(a) Cheques issued to suppliers, but not cleared
(b) Cheques deposited, but not honoured
(c) Accounts directly deposited by customers in bank account through electronic transfer
(d) Charges levied by the bank
(e) Interest on deposits credited by the bank
Answer:
S

Question 3.
Give a brief explanation about Bank Reconciliation Statement in GNUKhata
Answer:

1. Bank Reconciliation Statement is done to identify why there is difference between the two balances (Cash Book balance and pass book balance)
2. The date of transaction is the Transaction Date
3. The date on which a particular transaction appears in a Pass Book is called the Clearance Date.
4. The period for which Bank Reconciliation is done is called Reconciliation Period.
5. The reconciliation is done by comparing the Trans-action Date and Clearance Date.

Question 4.
GNUKhata provides the facility to view Single Ledger Account and Dual Ledger Account. Explain.
Answer:
GNUKhata provides the facility to view two ledger accounts simultaneously for comparing entries. We can view side by side:

• Two different Ledger accounts for the same period.
• Two different ledger accounts, each for different period.
• Same ledger accounts for different periods.

Plus Two Accountancy Accounting Software Package – GNUKhata Five Mark Questions and Answers

Question 1.
What do you mean by ‘Year End Activities’?
Answer:
Year End Activities consists of the following Year End Activities

• Closing Ledger Accounts.
• Opening Ledger Accounts for the next year.

(A) Closing of Accounts:
GNUKhata has a module to Close books at the click of a mouse, when this module is activated, balances in all expenses and incomes accounts are transferred to Profit and Loss/ Income & Expenditure account and the accounts are closed. After Close
books is done, transactions cannot be recorded but ledger accounts can be viewed.

(B) Opening Ledger Accounts for the next year:
GNUKhata has a module to Roll over ledger accounts at the click of a mouse. This module opens accounts for the next year automatically and since it is automatic, it is error free. When Roll over is done.

• New organisation with the same name and type is created by GNUKhata for the next accounting year.
• Assets and liabilities accounts automatically open under its respective Groups and Sub Groups with opening balances.
• Expenses and income accounts are opened under their respective Groups and Sub Groups without opening balances
• The closing stock gets transferred to the next year as opening stock.

This module can only be activated after close Books is done.

Question 2.
Write the steps in the preparation of final accounts by using GNUKhata.
Answer:

• Step 1 – Creation of new organisation
• Step 2 – Creation of Admin and Login
• Step 3 – Creation of Sub Groups
• Step 4 – Creation of Ledger Accounts
• Step5 – Voucher Entry
• Step 6 – Editing opening stock and Closing stock account
• Step 7 – Display Ledger Accounts
• Step 8 – Display Trial Balance
• Step 9 – Display P & L Account
• Step 10 – Display Balance Sheet

Question 3.
What are the different vouchers in GNUKhata?
Answer:

Question 4.
Write the Journal entry, voucher Type and Short cut keys of the following transactions.

1. 1. Cash purchases worth Rs. 10,000
   2. Sold goods to Akhil Rs. 6, 000
   3. Akhil returned goods worth Rs. 2,000
   4. Price of goods sold to Akhil reduced by Rs. 500
   5. Credit Purchases from Linjo Rs, 8,000
   6. Returned goods to Linjo Rs. 3,000

1. Linjo reduced the price of goods sold to us by Rs. 1,000
2. Cash received from Akhil Rs.3,000
3. Cash paid to Linjo Rs. 4,000
4. Cash sales ₹ 800

Answer:

Question 5.
Menu Bar has several Tabs. Can you list down a few of them? Also, mention the short cut keys and activities of such Tabs.
Answer:
Menubar has the following Tabs, The shortcuts for and the activities included in these Tabs are:

Question 6.
Create an organisation with the following particulars.

• Name: JOSHWIN ZIAN Enterprises
• Accounting Year: 01-01-2018 to 31-12-2018
• Type of organisation: Profit Making
• Maintain Inventory: No
• Records Admin Name and Password: Appu, Appose
• Security Question & answer: Best friends name? Chikku
• Address: 1234, M. C. Road, Velappaya, Tcr.

Answer:

• Step1 – Start GNUKhata (Application → Office → GNUKhata)
• Step 2 – Click on “Create Organisation”.
• Step 3 – Enter Organisation Name (JOSHWIN ZIAN Enterprises), Press Enter/Tab
• Step 4 – Select the case, Use down arrow key to select any one of the case and press Enter
• Step 5 – Select organisation type – ‘Profit making’ and press Enter/Tab
• Step 6 – Enter From date – 01-01-2018, Press Enter
• Step 7- Skip the box of Inventory
• Step 8 – Click on Proceed or Press Enter to open Create Admin window
• Step 9 – Enter user Name – Appu, Password – Appose and Press Enter/ Tab
• Step 10 – Enter security Question – “Best friends’s Name’, Press Enter/Tab
• Step 11 – Enter Answer to security Question Chikku, Press Enter to Login as Admin
• Step 12 – Select Edit organisation particulars from Master Menu
• Step13 – Enter Organisation – 1234, MC Road, Velappaya, TCr, and Click on Save

Plus Two Accountancy Accounting Software Package – GNUKhata Practical Work Questions and Answers

Question 1.
Create an organisation with the following particulars

• Name: TALLMEN WELFARE ASSOCIATION
• Accounting year: 1-1-2018 to 31-12-2018
• Type of organisation: Not for profit
• Maintain Inventory Records: No
• Admin Name & password: Visal, TCR2018
• Security Question and Answer Mothers’maiden name? Meenakshy

Procedure:
Step 1 – Start GNUKhata
Applications → Office → GNUKhata

Step 2 – Create New Organisation
Click on ‘Create Organisation’ Tab Enter the following informations.

• Organisation Name: TALLMEN WELFARE ASSOCATION
• Case: As-Is
• Organisation type: Not for Profit
• Financial year: 1-1 -2018 to 31-12-2018
• Inventory: (Leave it blank)

Click on the Proceed button. Now the organisation is created

Step 3 – Create Admin and Login
Press Enter or Alt+Shift+P to Open Create Admin module.

• User Name: Visal
• Password: TCR2018
• Confirm Password: Retype the password
• Security Question: Mothers’ Maiden name
• Answer to the security Question: Meenakshy

Press enter to Login as Admin

Step 4 – Select Edit organisation Particulars from Master Menu. Enter the address of the organisation. Press Enter key to save the details.
Output:

Question 2.
Create an organisation with the following particulars:

• Name: Mahindra Enterprises
• Accounting year: 1-04-2018 to 31-3-2019
• Type of organisation: Profit-making
• Maintain inventory Records: No
• Admin Name & Password: Vinesh, Vinumon
• Security Question & answer: Best friend’s name? Rohit
• Address: 268, Poonkunnam, Thrissur

Procedure:
Step 1 – Start GNUKhata
Applications → Office → GNUKhata

Step 2 – Create New Organisation Click on ‘Create Organisation’ Tab
Enter the following informations.

• Organisation Name: Mahindra Enterprises
• Case: As-Is
• Organisation Type: Profit Making
• Financial year: 1-04-2018 to 31-3-2019
• Inventory : (Leave it blank)

Click on the Proceed button, is created. Now the organisation

Step 3 – Create Admin and Login
Press Enter or Alt+Shift+P to Open Create Admin module.

• User Name: Vinesh
• Password: Vinumon
• Confirm Password: Retype the password
• Security Question: Best friend’s name?
• Answer to the security Question: Rohit

Press enter to log in as Admin

Step 4 – Select Edit organisation Particulars from Master Menu. Enter the address of the organisation
Press Enter key to save the details.
Output:

Question 3.
Create the following ledger accounts of Najim Traders

procedure:
Step 1 – Create a New Organisation ‘Najim Traders’- Profit Making with other imaginary data.

Step 2 – Creation of Ledger Accounts
Master menu → Create Account
Analysis Table

Step 3 – Create all the ledger accounts and save the details

Step 4 – Display ledger Accounts Report → Ledger view
OR
Display Trial Balance ReportTrial balance → (Select the type of Trial balance) → view
Output:

Question 4.
Create the following Ledger accounts of Anusree agencies.

procedure:
Step 1 – Create New Organisation ‘Anusree Agencies’ – Profit Making with other imaginary data
Enter the following information.

Step 2 – Creation of Ledger Accounts
Master Menu → Create Account

Question 5.
Record the following transactions in appropriate vouchers

• 1/6/2018 – Riyas started a business with cash – Rs. 1,00,000
• 2/6/2018 – Opened a bank account with Canara Bank – Rs. 30,000
• 3/6/2018 – Bought furniture for cash – Rs.10,000
• 4/6/2018 – Purchase goods from Niyastores – Rs,25,000
• 5/6/2018 – Cash sales – Rs.12,500
• 6/6/2018 – Paid for stationery – Rs. 500
• 7/6/2018 – Cash paid to Niya stores – Rs. 20,000
• 8/6/2018 – Cash withdraw from Canara bank – Rs.10,000

Procedure:
Step 1 – Create a New Organisation – Profit Making – with imaginary data

Step 2 – Creation of Ledger Accounts
Master menu → Create Account
Analysis Table

Step 3 – Create all the ledger accounts and save the details

Step 4 – Enter all the transactions in appropriate vouchers

1. Select the appropriate voucher form Voucher menu
2. Enter the Voucher Number and date
3. Select the Debit account name and enter the amount, then press Enter
4. Select the credit account name and enter the amount
5. Enter narration and click on Save.

Output:

Question 6.
Enter the following transactions of Royal Enterprises and display Trial Balance

Procedure:
Step 1 – Open GNUKhata
Application Office GNUkhata

Step 2 – Create Organisation “Royal Enterprises – Profit making – with Imaginary data.

Step 3 – Create Admin
Enter the details (Imaginary)

Step 4 – Create appropriate Ledger Accounts
Master → Create account → Select Group → Sub Group → Type Account name → Save
Analysis Table

Step 5 – Enter all transactions in appropriate vouchers
Voucher menu → (appropriate voucher) → Enter voucher number → Date → Select Debit account → enter debit amount → Press Enter → Select Credit Account → Enter credit amount → Press Enters → Enter narration → Click on Save

Step 6 – Display Trial balance Report → Trial Balance
Output:

Question 7.
From the following Trial Balance, Prepare Trading Profit and loss account and Balance sheet of Athulya Ltd. as on 31/3/2018
Trial Balance as on 1/4/2017

Transaction during the year 2017 – 18 is given below

• Sales (Cash) – Rs. 51000
• Sales (Credit) – Rs. 34000
• Purchases (Credit) – Rs. 68000
• Office expenses – Rs. 2400
• Wages. – Rs. 1.600
• Cash received from Debtors – Rs. 16,000
• Cash paid to creditors – Rs. 35,000
• Discount received – Rs. 1000
• Salary – Rs. 5000
• Rent – Rs. 11,000
• Carriage Outward – Rs. 700
• Commission Paid – Rs. 500
• Insurance Premium – Rs. 4000

Other Adjustments:

• Salalry Prepaid – Rs. 1500
• Rent outstanding – Rs. 1000
• Wages Outstnading – Rs. 800
• Insurance Premium prepaid – Rs. 2000
• Closing stock – Rs. 3700
• Depreciation of Machinery – Rs. 10%

Procedure:
Step 1 – Create an organisation Athulya Ltd- Profit making for the year 1 -4-2017 to 31/3/2018 with imaginary data.

Step 2 – Creation of Ledger Accounts
Master → Create account
Analysis Table (Trail Balance)

Create all the ledger a/c under appropriate group and sub Group.

Step 3 – Voucher Entry
Enter all the transactions using appropriate voucher type
Voucher menu /Transaction menu → Select appropriate voucher type → Enter voucher number → Enter voucher Date → Enter Debit account and amount → Enter Credit account and amount → Save
Analysis Table (Transactions)

Analysis Table (Transactions)

Step 4 – Enter the value of opening stock and closing stock

1. Master menu → Edit Account → Select Stock at the beginning a/c → Click Edit Button
2. Enter 14000 as Opening Balance. Click on Save button
3. Enter the values of Opening Stock and closing stock through appropriate voucher

Voucher menu/Transaction menu → Journal
Analysis Table (Stock)

Step 5 – Display Trial Balance
Report → Trial Balance → Enter Date → Type → Click on the View button

Step 6 – Display Profit and loss Account
Report → Profit and loss → Enter Date → Click on View Button

Step 7 – Display Balance Sheet
Report → Balance sheet → Enter Date → Type → Click on View Button
Output:

Question 8.
Prepare a Bank Reconciliation Statement of Cili Traders, a Profit making organisation, for the period 1-1-2018 to 31-3-2018

While comparing with Cash book with Pass book, the following details were noted.

1. Clearance date of cheque No.7125 was on 7/4/18
2. Cheque No. 9614 cleared only on 2/4/2018
3. Cheque No. 7127 is cleared on 1/4/18
4. Clearance date of cheque No.4528 was on 12/2/18
5. Cheque No. 7129 was cleared on 19/3/2018
6. All other transaction’s clearance date is same as transaction date

procedure:
Step 1 – Start GNUKhata
Application → Office → GNUKhata

Step 2 – Create Organisation
Create an organisation → Cili Traders → Profit making → 1-1-18 to 31-12-2018 → Create admin with imaginary data.

Step 3 – Create Ledger accounts
Master Menu → Create Account → Select Group → SubGroup → Account Name → Save
Analysis Table

Step 4 – Voucher Entry
Transaction/Voucher → Select appropriate voucher → Number → Date → DebitCredit → Save

Step 5 – Preparation of Bank Reconciliation Statement Press Alt +R

OR

1. Master → Bank rEconciliation statement → Select Bank’s Name (Canara Bank) → Set Reconciliation period → Click on view button to view Bank reconciliation screen
2. Enter clearance date → Click on View statement button
3. To show the cleared Transactions, click on cleared items
4. To show the uncleared transactions, click on uncleared items

Output:

Question 9.
Enter the following transactions of Sibi Traders and Display Final Accounts as on 31/3/2018

procedure:
Step 1 – Open GNUKhata
Application Office → GNUKhata

Step 2 – Create Organisation
Click on Create organisation → Enter Details → Sibi Traders → Proft Making → 1-1-2018 to 31-12-2018

Step 3 – Create Admin
Enter imaginary data

Step 4 – Creation of Ledger accounts
Master Menu → Create account → Select Group → SubGroup → Type Account name → Save
Analysis Table

Step 5 – Voucher Entry (based on above Analysis Table)
Transaction menu/Voucher menu → Select appropriate voucher → Enter voucher No → Date → Debit account and amount → Credit account and amount → Narration → Save

Step 6 – Display Trial balance
Report → Trial balance
Display Profits and loss Account
Report → Profits Loss account

Step 8 – Display Balance Sheet
Report → Balance sheet
Output:

Question 10.
From the following transactions of Fijo and Joshy associates, prepare Trial Balance, Trading Profit, and Loss account and Balance Sheet.

Adjustments

1. Depreciation of Furniture Rs. 640
2. Closing stock valued at Rs.2900

Procedure:
Step 1 – Create Organisation
Click on create Organisation Tab Enter the details
Fijo and Joshy Associates – Profit Making- 1/1/2018-31/12/2018. Enter all other details with imaginary data.

Step 2 – Create Ledger Account
Master → Create Account
Analysis Table


Create all the above ledger accounts under appropriate Groups and Subgroups.

Step 3 – Voucher Entry
Enter the adjustment entries in appropriate voucher type
Voucher menu/Transaction menu → Select Voucher type → Number → Date → Debit & Credit → Save
Analysis Table (Adjustments)

Step 4 – Display Trial Balance
Report → Trial Balance

Step 5 – Display Profit & Loss Account
Reports → Profit & Loss Account

Step 6 – Display Balance Sheet
Report → Balance Sheet
Output:

Question 11.
Given below the Trial Balance of Akhil &Athulya associates as a 31/3/2018. Prepare Final Account for the year 2018-19

Other Information:

1. Depreciation of Machinery-4500
2. Rent outstanding-3000
3. Building depreciated at 1.0%
4. Salary Outstanding – 3500
5. Value of closing stock -18000
6. Value of Motor vehicle depreciated by 5%

Procedure:
Step 1 – Open GNUKhata
Applications → Office → GNUKhata

Step 2 – Create Organisation
Click on Create Organisation tab. Enter the details
Akhil and Athulya Associates – Profit making 1-4-2018 to 31-3-2019.

Step 3 – Create Admin & Login Use imaginary data.

Step 4 – Creation of new subgroup
Here we need to create a new Sub Group Vehicles under the Group Fixed Assets. Master → Create Account → Select Group Fixed Assets → Select New Sub Group in Sub Group Name → Enter the new Sub Group Name ‘Vehicles’ → Enter the Account Name Motor Vehicles in that Sub Groups Enter the Opening Balance Rs. 1,50, 000 → Save.

Step 5 – Create Ledger Account
Master → Create Account
Analysis Table (Trial Balance)

Create all the ledger accounts under ap¬propriate Groups and Sub Groups

Step 6 – Voucher Entry
Enter all adjustments in appropriate voucher type
Voucher menu/Transaction Menu → Select Voucher → Type → Number → Date Debit account and amount → Credit account and amount → Save.
Analysis Table (Adjustments)

Step 7 – Enter the value of opening stock and closing stock

1. Master Menu → Edit Account → Select stock at the beginning a/c → Click Edit button
2. Enter 15000 as opening balances click on. Save button
3. Enter the values of opening stock and closing stock through appropriate voucher

Voucher Menu/Transaction menu → Journal
Analysis Table (Stock)

Step 8 – Display Trial Balance
Report → Trial Balance

Step 9 – Display profit and loss Account
Report → Profit & Loss

Step 10 – Display Balance Sheet
Report → Balance Sheet
Output:

Question 12.
Enter the following transactions in appropriate vouchers of Jos & Rejina Enterprises and prepare Bank Reconciliation Statement
Step 1 – Open GNUKhata

Verification of the Cash Book with Bank Pass Book revealed that the Cheque Nos. 8117, 8238 & 5314 were cahsed only on 3^rd, 5^th and 8^th July respectively and the clearance date of all other transactions are same as transaction date.
Procedure:
Step 1 – Open GNUKhata
Application → Office → GNUKhata

Step 2 – Create Organisation
Click on Create Organisation → Enter Name → Jos & Rejina Enterprises – Profit Making → (other imaginary data)

Step 3 – Create Admin – Enter the details (imaginary Data)

Step 4 – Create Ledger Account
Master → Create account → Select Group → Sub Group → Type Account name → Save
Analysis Table


Step 5 – VoucherEntry
Transaction / Voucher → Select Appropriate → Enter details.

Step 6 – Preparation of Bank reconciliation statement Press Alt + R
OR

1. 1. Master → Bank Reconciliation statement → Select Bank’s Name (Union Bank) → Set Reconciliation period → Click on the View button to view Bank Reconciliation screen
   2. Enter clearance data Click on View Statement button
   3. To show the cleared Reconciliation click on cleared items
   4. To know the uncleared Transactions, Click on Uncleared items.

Students can Download Chapter 4 Web Technology Questions and Answers, Plus Two Computer Application Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Computer Application Chapter Wise Questions and Answers Chapter 4 Web Technology

Plus Two Computer Application Web Technology One Mark Questions and Answers

Question 1.
Specify an attribute of HTML tag.
Answer:
DIR: Indicates documents direction. It can take values rtl or Itr.
Eg. <HTML DIR= “rtl”> This specify that document is to read from right to left.

Question 2.
Mention the default value of size attribute of <BASEFONT>tag.
Answer:
3.

Question 3.
Name the tag which has ‘Noshade’ attribute.
Answer:
<HR> Tag

Question 4.
Maximum possible value of the size attribute of the <BASEFONT>tag?
Answer:
7.

Question 5.
Salim developed a personal website. In which he has to create an e-mail link. Can you suggest the protocol used to achieve this task?
Answer:
Mailto:
Eg. <A href= “Mailto:cgj@rediffmail.Com” >Mail to me</A>.

Question 6.
You want to connect your webpage to the web portal www.yahoo.com. Mention the tag that can be used for this.
Answer:
<A> Anchor Tag
Eg. <A href=”www.yahoo.com”>Yahoo</A>

Question 7.
Specify the main attribute of <IMG> tag used to include an image file in web page.
Answer:
SRC. It specify the name of the image file to be included in the page.
Eg. <IMG SRC=“C:/home,Jpg”>

Question 8.
Select the attribute associated with <IMG> tag from the following: (Name, size, Align, value)
Answer:
Align.

Question 9.
Write HTML code forgiving hyper link in webpage.
Answer:
<A HREF= “page2.htm”>Page2</A>

Question 10.
The default colour of Vlink is______.
(a) Blue
(b) Green
(c) Red
(d) Yellow
Answer:
(c) Red

Question 11.
The default colour of A link is______.
(a) Blue
(b) Green
(c) Red
(d) Yellow
Answer:
(b) Green

Question 12.
Saritha is assigned with a task of writing explana¬tory notes in an HTML code. Which tag she can utilize.
Answer:
Explanatory notes can be given using <comment> tag. Using two mark up elements. as<!—and →

Question 13.
Pick the odd man out.
(a) BODY
(b) HTML
(c) CENTER
(d) ALIGN
Answer:
(d) ALIGN, all others are tag.

Question 14.
Your school has a web site, www.myschool.org. You want to create a link to this site from your website. Write the code for implementing this.
Answer:
<A href=”www. myschool.org”>My School</A>

Question 15.
HTML was developed by_______.
Answer:
Tim Berners-Lee.

Question 16.
What are the two major sections of an HTML document?
Answer:
Head section and Body section.

Question 17.
An HTML file is saved with______extension.
(a) .vbp
(b) .mdb
(c) .htm
(d) .fnm
Answer:
(c) .htm or .html

Question 18.
The software used to view web page is______.
(a) Notepad
(b) Web Browser
(c) Web server
(d) Web Editor
Answer:
(b) Web Browser

Question 19.
The default alignment of image in HTML is______.
(a) Left
(b) Right
(c) Center
(d) Inline with content
Answer:
(a) Left

Question 20.
______is an alternative for centralizing a paragraph other than using <P> tag
(a) <ALIGN>
(b) <C>
(c) <CENTER>
(d) <CENTRE
Answer:
(d) <CENTER>

Question 21.
_______attribute of <A> tag specifies the URL of the hyper linked document.
(a) Name
(b) Target
(c) HREF
(d) SRC
Answer:
(c) HREF

Question 22.
What does HTML stands for?
Answer:
HyperText Markup Language.

Question 23.
Communication on web can be classified into_____and______.
Answer:
Client to Server and Server to Server

Question 24.
The protocol which is responsible for splitting the data into smaller packets is______.
Answer:
TCP

Question 25.
The protocol which is responsible for the routing of data packets through the correct destination is____.
Answer:
IP (Internet Protocol)

Question 26.
TCP / IP stands for_____.
Answer:
Transmission Control Protocol/lntemet Protocal.

Question 27.
Identify the protocol responsible fore-mail commu-nication.
(a) DNS
(b) HTTP
(c) TCP/IP
(d) SMTP
Answer:
(d) SMTP

Question 28.
In server to server communication, authentication is done with help of______.
(a) HTTP
(b) Digital certificate
(c) Client
(d) DNS
Answer:
(b) Digital certificate

Question 29.
Which server acts between merchant server and bank server for transferring data in encrypted format?
Answer:
Payment Gateway.

Question 30.
Identify the name of a place where servers and networking systems are placed with high security,
(a) Head office
(b) DNS
(c) Data centre
(d) IIS
Answer:
(c) Data centre

Question 31.
Identify the port number which request for the service of sending e-mail communication.
(a) 22
(b) 25
(c) 53
(d) 80
Answer:
(b) 25

Question 32.
The IP address corresponding to a domain name is present in____server.
Answer:
DNS

Question 33.
Programs embedded in HTML documents are termed as____.
Answer:
Scripts

Question 34.
Running of ______scripts can be blocked by the user.
(a) Client side
(b) Server side
(c) Both client side and server side
(d) None of these
Answer:
(a) Client side

Question 35.
A platform-independent server-side scripting language is_____.
Answer:
PHP

Question 36.
Which among the following tools is used for easy formatting and defining style of a document written in HTML?
(a) Ajax
(b) CSS
(c) JSP
(d) JavaScript
Answer:
(b) CSS

Question 37.
Pick the Odd one from the following list and give reason. (IMG, FONT, BR, ALIGN, PRE)
Answer:
ALIGN which is an attribute, all others are tags.

Question 38.
Choose the correct HTML statement to display an image with file name “kerala.jpg” as the background of the web page.
(a) <IMG src=”kerala.jpg”>
(b) <BODY src=”kerala.jpg”>
(c) <BODY bgcolor=”kerala.jpg”>
(d) <BODY background=”kerala.jpg”>
Answer:
(d) <BODYbackground=”kerala.jpg”>

Question 39.
Two ofthe following HTMLtags have same attribute Align’. Identify them. (<IMG>, <MARQUEE>, <B>, <P>, <BODY>)
Answer:
<IMG> AND <P>

Question 40.
Identify the correct HTML statement to draw a hori-zontal line with half the width of the screen.
(a) <HR width=“50%” size= “3″>
(b) <HR length=“50%” size= “3″>
(c) <HR size= “50%” width= “3″>
(d) <HR width= “50%” length= “3″>
Answer:
(a) <HR width=“50%” size= “3″>

Question 41.
A student wants to display a poem in a web page just like as he entered in the text editor. Which tag in HTML will help him?
Answer:
<PRE>tag

Question 42.
A student created a webpage about his school. The school name is displayed in the page. He wanted to change the style, colour, and size of the school name. Identify the most appropriate tag in HTML needed for that.
Answer:
<FONT> tag

Plus Two Computer Application Web Technology Two Mark Questions and Answers

Question 1.
A student developed a web page about India. He wanted to display a scrolling text moving from right side to left side with a background colour blue. The text is “I Love My Country”.

1. Identify the tag needed for it.
2. Write the HTML statement to do the task.

Answer:

1. <MARQUEE>
2. <MARQUEE direction-’left” bgcolor=”blue” > I Love My country </MARQUEE>

Question 2.
Write HTML statement for displaying the following text items:

1. A₂B³
2. A>B

Answer:

1. A<SUB> 2 </SUB> B <SUP>3</SUP>
2. A&gt;

Question 3.
Two HTML tags are given. They are <BODY> and <FONT>. Identify and write the attribute of each from the following list. (Size, Text, Link, Bgcolor, Color).
Answer:
The attributes of <BODY> tag are Text, Link and Bgcolor The attributes of <FONT> tag are size and color.

Question 4.
Write the use of Border and Aft attribute of <IMG> tag.
Answer:
Border: This attribute is used forgiving border to an image.

Alt: This attribute issued forgiving an alternate text. When there is no image in the specified location or the browser doesn’t support the image them this text will be displayed.

Question 5.
When a client send request to a server, the server must know which service is demanded by the client.

1. How does the server identify the type of service requested?
2. Write the name of any one of the services in the web server.

Answer:

1. Port number
2. Any service like FTP, SMTP, HTTP, etc.

Question 6.
Following are steps for searching the IP address of a domain name by a browser. Rearrange them in proper order.
(a) Look in the local memory of ISP
(b) Look in the DNS servers starting from the root server
(c) Look in the local memory of brower
(d) Look in the local memory of Operating System
Answer:
Correct order is c, d, a, b.

Question 7.
Categorise the following tags into Containertags and empty tags.
<B>, <BR>,<A> ,<FRAME>, <FRAMESET>,<LI>, <HR>
Answer:
1. Container tags:
<B>,<A> <FRAMESET>

2. Empty tags:
<BR>,<HR>,<LI>, <FRAME>.

Question 8.
Write the HTML statement to get the following output.

1. Commerce
2. Humanities

Answer:

1. <B>Commerce</B>
2. <l>Humanities</l>

Question 9.
Write the HTML statement to get the following output.

1. H₂S0₄
2. a² + b²
3. Computer

Answer:

1. H₂SO₄
2. a² + b ²
3. <b>Computer</b>

Question 10.
Write HTML code to display as follows. The <IMG> tag is used for placing images.
Answer:
The & lt IMG &gt tag is used for placing images.

Question 11.
Name some browsers.
Answer:

1. Internet Explorer
2. Netscape Navigator
3. Opera
4. Eudora

Question 12.
What is a website?
Answer:
A website is a collection of webpages. A webpage is created by using HTML tags.

Question 13.
What is the role of attributes in an HTML tag?
Answer:
Attributes are parameters for providing additional information within a tag. Attribute values specify certain characteristics of the tag.
Eg: <P align=”right”>

Question 14.
What is an HTML?
Answer:
HTML stands for Hyper Text Markup Language. It is used to create webpages. It has two types of tags empty and container. The important thing we have to remember in container tag is first opened tag must be closed last.

Question 15.
Name the main attributes of <HR> tag.
Answer:

1. Size: It specifies the line thickness.
2. Width: It specifies the length
3. Noshade: It specifies no shade is given for the line.
4. Color: It specifies the color.

Question 16.
Mary wants to display her name in various headings. Name the heading tags available in HTML.
Answer:
Heading can be given in six levels from <H1> to <H6>.The tag <H1 > produces big heading. The tag <H6> produces small heading. The heading size reduce from <H1> to <H6> sequentially.

Question 17.
Differentiate between <FONT>and<BASEFONT>tags.
Answer:
<BASEFONT>tag sets the normal font for the entire document text. The font specified will be taken as the default font for the entire document. The main attributes are size, face, and color.

The <FONT> tag defines the font characteristics of the text enclosed. <Font> tag change the font property of the text enclosed within <Font> and</Font> whereas <BaseForrt> tag specifies the default font characteristics.

Question 18.
Explain the different types of hyperlinks.
Answer:
The two types of Hyper Links are

1. External Hyper Link: This is used two connect the locations of two different web pages
2. Internal Hyper Link: This is used to connect the different locations of the same web page.

Question 19.
Write the HTML code to display the following list:

1. Form
2. TextBox
3. Label
4. Command Button

Answer:

Question 20.
The body section forms the content displayed in the browser window. Briefly explain any four attributes in the BODY tag.
Answer:

1. Bgcolor – It is used to set background colour.
2. Background – It is used to set a background picture.
3. Text – it is used to set the foreground colour.
4. Left margin – It is used to set the left margin.

Question 21.
HTML has the facility to provide External links as well as Internal links.

1. Which tag is used to include an External link?
2. How will you construct an Internal link?

Answer:
1. Anchor Tag i.e. <a href=”filename”>

2. Internal link is used to link two places of the same web page

Question 22.
Categorise the following tags in HTML and write the criterian for the categorisation.
<BR>, <P>, <BODY>, <B>, <HR>, <IMG>
Answer:

Empty_tag	Container tag
<BR>	<P>
<HR>	<BODY>
<IMG>	<B>

Question 23.
Differentiate empty tags and container tag with example.
Answer:
1. Empty tags: It has opening tag only, no closing tag
Eg: <hr>, <br> etc.

2. Container tag: It as both opening and closing tag.
Eg: <html> </html>
<body></body>etc.

Question 24.
Write True or False

1. Text is an attribute of <BODY> tag to insert a text matter in the web page.
2. <EM>tagfunctionssimilarto<l>tag.

Answer:

1. False
2. True.

Plus Two Computer Application Web Technology Three Mark Questions and Answers

Question 1.
Write and explain any four text formatting tags in HTML.
Answer:
Text formatting tags are given below.

1. <B> – This tag is based to make the text Bold Eg: <B> Computer application </B>
2. <l>: This tag is used to make the text in italics eg: <l> computer aplication</l>
3. <U>:This tag is used to underline the text eg: <U> computer aplication</U>
4. <S>: This tag is used for striking out the text eg: <S> computer aplication</S>

Question 2.
Match the following.

Answer:
Correct match as given below
<H2> -Heading-Align
<MARQUEE> – Scrolling text – Bgcolor
<IMG> – Inserting picture – Src.

Question 3.
Briefly explain the use of tags <Q>, <PRE> and <ADDRESS> tags.
Answer:

• <Q>: It is used to give text within double-quotes.
• <PRE>: This tag is used to display the content as we entered in the text editor.
• <ADDRESS>: This tag is used to provide information of the author or owner.

Question 4.
Write a HTML code to develop a web page about Kerala state as shown below:

KERALA STATE

God’s Own Country

Capital: Thiruvananthapuram

The specifications for the page are:

1. The main heading must be of bigger in size, centralised and bold.
2. Sub headings must be lesser size than main heading and in italics.
3. There should be a picture at the center of the page with file name“tree.jpg”.
4. The background colour of the page must me blue.

Answer:

Question 5.
PHP is a popular scripting language.

1. Write whether it is client side or server side.
2. Write a brief note on PHP.

Answer:

1. Server side
2. PHP (PHP Hypertext Preprocessor)
   • It is an open-source, general-purpose scripting language.
   • It is a server side scripting language
   • Introduced by Rasmus Lendorf
   • A PHP file with extension .php
   • It support data base programming the default DBMS is MySQL
   • It is platform-independent
   • PHP interpreter in Linux is LAMP(Linux, Apache, MySQL, PHP)

Question 6.
How client side scripting differs from server side scripting?
Answer:
Following are the differences

Client Side Scripting	Server Side Scripting
Script is copied to client browser	to the web server
Executed by the client	Executed by the server and result is get back to the browser window
Used for Client level validation	Connect to the database in the server
It is possible to block by the user	Cannot possible
Client side scripts depends the type and version of the browser	It does not depend the type and version of the browser

Question 7.
Briefly explain the two types of communication on the web.
Answer:
The two types of communication on the web are given below.
1. Client to Web server communication:
This communication is carried out between client to the web server (shopping site). The technology used to protect data that are transferred from client to web server is https.

2. Web sever to web server communication:
This communication is usually carried out between web .sever (seller) to another web server (normally bank). For the safe transaction. Digital certificate issued by third party web sites are used.

Question 8.
Compare static and dynamic web pages.
Answer:

Static web pages	Dynamic web pages
Content and layout is fixed	Content and layout is changed frequently
Never use database	Data base is used
Run by browser	It runs on the server and result get back to the client(browser)
Easy to develop	Not at all easy

Question 9.
Differentiate Empty tag and Containertag.
Answer:
There are two types of tags, opening tag, and closing tag

• Empty tag: It has only opening tag and no closing tag
  Eg: <br>, <hr>,..
• Container tag: It has both opening and closing tags. These tag contains some text data Eg:<html>,<head>,<body>,….

Question 10.
Create a webpage using HTML to display the following message. ‘The symbol H₂O represents water’.
Answer:

Question 11.
While designing a webpage Neena wants to explain the meaning of each step. Can you help her?
Answer:
Neena can use Comments while writing the code. It is a good programming practice. Comments improve readability. It is not the part of a program. Comments
<!—and — >

Question 12.
Complete the following table.

RGB code	Colour Name
#0000FF	_________
________	Yellow
#FF0000	_________
#00FF00	_________
________	White
________	Black

Answer:

RGB code	Colour Name
#0000FF	Blue
#FFFF00	Yellow
#FF0000	Red
#00FF00	Green
#FFFFFF	White
#000000	Black

Question 13.
Give HTML tag to display the sentence “WELCOME TO HTML” as centralized heading, having red colour.
Answer:

Question 14.
Explain the Main attributes of font tag.
Answer:
<FONT>tag defines the font properties of text enclosed
The main attributes are

1. Face-This specifies the type of font.
2. Color-This specifies the colour of the text enclosed
3. Size- This specifies the font size

Eg. <FONT Face= “Arial” size = “3” color= “magenta”>

Question 15.
John visited a website, it is found that when clicking on a particular text the browser open a new web page. Name the feature and Identify the tag used for this purpose. Write the HTML code to link to a file name “main.html”.
Answer:

1. Hyper Linking. By clicking on hypertext we can see or go to other webpages or to other section of same document.
2. <A> tag is used
3. <Ahref=”main.html”>Main</A>

Question 16.
Antony visited his school website, he could not see the picture of his school instead of that there is a text message “Your browser could not support images”. Why it is happened and write the html code for this.
Answer:
Because the browser he used cannot load the image. He can use Alt attribute of IMG Tag.
<IMG SRC =” D:\school.jpg” Alt=“Your browser could not support images”>

Question 17.
Suppose you want to display a picture named school.jpg located in the ‘Photos’ sub directory of the directory ‘My documents’ of C drive in your web page.

1. Name the tag used for this purpose.
2. Write HTML code for the web page.

Answer:
1. <IMG>tag. It is used to display images in webpage

2. <HEAD><TITLE>
</HEAD>
<Body>
<IMG SRC= ‘C;/My documents/Photos/School.jpg’>
</Body>
<html>

Plus Two Computer Application Web Technology Five Mark Questions and Answers

Question 1.
Explain the main list tags in HTML?
Answer:
HTML provides three basic types of lists-unordered, ordered and definition list.
1. Unordered list:
Unordered list arranges the list items with bullet symbols in front. <UL> and </UL> tag encloses an Unondered list. List items are specified by <LI> tag. The tag <UL> can take values square, circle or disc. The default type is disc.
Eg : <UL>
<LI>COMPUTER
<LI>BIOLOGY
</UL>

2. Ordered list:
In Ordered list, the list items are numbered in sequence. <OL> and </OL> tag encloses an Or-dered list. List items are specified by <LI> tag. The tag <OL> can take values as follows

• type = 1 for 1, 2, 3,….
• type = i for i, ii, iii,……
• type = I for I, II, III,……
• type = a for a, b, c,…
• type = A for A, B, C,…..

Eg :<OL>
<LI>COMPUTER
<LI>BIOLOGY
</OL>

3. Definition List:
It is formed by a group of definitions and their descriptions. No bullet symbol or number is provided for the list items. The <DL> and </DL> tags enclose the definition list. The <DT> tag contains the definition term and <DD> tag specifies the description.
Eg: <DL>
<DT>Eeheque
<DD>Electronic cheque
</DL>

Question 2.
Explain the use of <BODY> tag and list any four of its attributes
Answer:
Web page contents are given int the body section. Attributes of body tag are:

1. BGCOLOR-Specifies background color for the document Body
   Eg. <BODY BGCOLOR= “RED”>
2. BACKGROUND -Sets the image as background for the document body
   Eg. <BODY BACKGROUNG= “C:\result.jpg”>
3. TEXT-Specifies the color of the text content of the page
   Eg. <BODYTEXT= “Red”>
4. LINK- Specifies colour of the hyperlinks that are not visited by the user
5. ALINK-Specifies the colour of hyperlinks
6. VLINK-Specifies the color of hyperlinks which are already visited by the viewer.
   Eg. < BODY ALINK= “Cyan” LINK=” Magenta” VLINK= “Orange’’> *
7. Left margin and Right margin-Sets margin from left and top of the document window.

Students can Download Chapter 8 Database Management System Questions and Answers, Plus Two Computer Application Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Computer Application Chapter Wise Questions and Answers Chapter 8 Database Management System

Plus Two Computer Application Database Management System One Mark Questions and Answers

Question 1.
Select the property which is desirable for a database.
(a) Redundancy
(b) Inconsistency
(c) Integrity
(d) Complexity
Answer:
(c) Integrity

Question 2.
Pick the odd man out.
(a) Create
(b) Select
(c) Update
(d) Insert
Answer:
(a) Create

Question 3.
______is the ability to modify a schema definition in one level without affecting the schema definition in the next higher level.
Answer:
Data Independance.

Question 4.
For accessing data from a database, provides an interface with programming languages.
Answer:
SQL (or DML)

Question 5.
Give an example for RDBMS package.
Answer:
Packages such as Oracle, My SQL, etc.

Question 6.
Name the key that acts as a candidate key but not a primary key.
Answer:
Alternate key

Question 7.
With the help of_______the process of storing, retrieving and modifying date are greatly simplified.
Answer:
DBMS

Question 8.
If______is controlled , DBMS can guarantee that database is never inconsistent.
Answer:
Redundancy.

Question 9.
The property of a DBMS that guarantees that the database is never inconsistent.
Answer:
Redundancy.

Question 10.
______and_____are the two types of integrity checks.
Answer:
Range checks, Value checks.

Question 11.
Which component of DBMS provides interfaces with programming Languages.
Answer:
DML

Question 12.
The level of database abstraction that describes how the data is actually stored in the storage medium.
Answer:
Physical level.

Question 13.
The level of database abstraction that describes what data are stored in the database.
Answer:
Logical level.

Question 14.
Data Base Administrators (DBA) are more concerned with level______of Abstraction.
Answer:
Logical level.

Question 15.
The programmers are connected with______level of abstraction.
Answer:
Logical level.

Question 16.
The teller at a bank sees only that part of the database that has information on customer accounts. Which level of Database abstraction he is at?
Answer:
View level.

Question 17.
As part of project work, Ashish defines the type of data and the relationship among them. He is at_______level of database abstraction.
Answer:
Logical.

Question 18.
_______is the other name for logical level.
Answer:
Conceptual level

Question 19.
If the modifications made on storage format does not affect the structure of data, then we achieve______data independence.
Answer:
Physical data independence.

Question 20.
Pick the odd one out.
(a) net work model
(b) hybrid model
(c) relational model
(d) hierarchical model
Answer:
(b) Hybrid model.

Question 21.
“I am a data model. My records can have more than one parent record” Who am I?
Answer:
Network model.

Question 22.
Name the language that enables user to access or manipulate data as organized by RDBMS.
Answer:
DBML

Question 23.
ADatabaseAdministratorisableto modify the structure a programmer changes data types and length of a database without affecting certain fields in a database of a bank and the program. Identify the data independence associated in it.
Answer:
Logical data Independence.

Question 24.
Name the language that used to define a database scheme.
Answer:
DDL

Question 25.
Name the person who has central control over the database and programs in DBMS
(a) Naive user
(b) Programmer
(c) Database Administrator
(d) System Analyst
Answer:
(c) Database Administrator.

Question 26.
Oracle DBMS package is based on______model.
Answer:
Relational

Question 27.
Match the following.

A	B
(a) Relation	(i)  Field
(b) Tuple	(ii)  Table
(c) Atribute	(iii)  Record

Answer:
(a) – (ii), (b) – (iii), (c) – (i).

Question 28.
Name the Relational operation which selects certain columns from the table while discarding others.
Answer:
Project.

Question 29.
How to define the Domain of a column ‘subject 1’ of MARKS relation.
Answer:
Range of values from 0 to 100.

Question 30.
State whetherTrue or False. A view is a kind of table whose contents are taken from other tables.
Answer:
True

Question 31.
State True or False. A view can be queried, inserted into, updated and deleted from.
Answer:
True.

Question 32.
Name an efficient way to provide only required data to users hiding other data from the database.
Answer:
View

Question 33.
Pick the key which can not be used to uniquely identify a tuple on a relation:
(Candidate Key, Primary Key, Alternate Key, Super Key, None of these)
Answer:
None of these.

Question 34.
π(pi) Greek letter is used to denote________operation in relational algebra.
Answer:
Project.

Question 35.
Which relational Algebra operation returns all possible combinations of tuples from two relations.
Answer:
Cartesian product.

Question 36.
Pick the odd one out.
(Select, Cartesian product, Union, intersection)
Answer:
Select – unary operator.

Question 37.
What will be the cardinality of the resultant table if after the following operation if the cardinality of STUDENT is 5 and INSTRUCTOR is 3?
Answer:
15

Question 38.
Consider two relations FOOTBALL AND CRICKET, How to get the names of players play only cricket not also FOOTBALL.
Answer:
CRICKET – FOOTBALL

Question 39.
Why we call a Foreign Key so?
Answer:
It is a candidate Key in another table, A foreigner.

Question 40.
_______is range of values from which actual values are appearing in a given columns are drawn.
Answer:
Domain

Question 41.
Name the table that does not contain data of its own, but is derived from a base table.
Answer:
view

Question 42.
Name a way to uniquely identify a tuple in a relation.
Answer:
By using primary key.

Question 43.
Give two Unary operations performed on a relation in Relational Algebra.
Answer:
Select, Project

Question 44.
Data redundancy is not a desirable property. But All redundancy can not or should not be eliminated. Do you agree with this statement. Justify.
Answer:
Yes. Because sometimes there can be technical or business reasons for maintaining several distinct copies of same data.

Question 45.
Anju is able to do all the internal operations in a DBMS. What type of user is she? What are the other type of users?
Answer:
DBA, Other type users are Appl Prograammer and Naive users.

Question 46.
Which of the following statements are true?

1. DBMS facilitates storage, retrieval, and management of databases.
2. We must keep more copies of the same data in databases.
3. Data inconsistency is eliminated in DBMS.
4. DBMS allows sharing of data, but does not ensure security.

Choose the correct option from the following:
(a) Both 1 and 3 are true
(b) Statements 1, 3 and 4 are true
(c) Statements 1, 2 and 4 are true
(d) All statements are true
Answer:
(a) Both 1 and 3 are true

Question 47.
Which of the following refers to duplication of data in files?
(a) Data redundancy
(b) Data inconsistency
(c) Data integrity
(d) Data security
Answer:
(a) Data redundancy

Question 48.
The following are some responsibilities of database users. Which of them belong to Database Administrator?

1. Design the conceptual schema of the database.
2. Develops programs to interact with the database.
3. Interacts with the database through queries.
4. Ensures authorised and secured access of data

(a) Both 1 and 3
(b) Except 2 and 3
(c) 1, 2 and 4
(d) All the four
Answer:
(b) Except 2 and 3

Question 49.
Which of the keys in a relation do not allow null values? Choose the most appropriate option from the following.
(a) Primary key
(b) Candidate key
(c) Both primary key and candidate key
(d) Either primary key or candidate key
Answer:
(c) Both primary key and candidate key

Question 50.
Choose the level of database abstraction that describes what data is stored in the database and what relationships exist among them.
(a) External
(b) Logical
(c) Physical
(d) View
Answer:
(b) Logical

Question 51.
Which of the following operations can extract the specified columns of a table?
(a) Selection
(b) Projection
(c) Intersection
(d) Set Difference
Answer:
(b) Projection

Plus Two Computer Application Database Management System Two Mark Questions and Answers

Question 1.
The schema of a table is EMPLOYEE(emp_code, emp_name, designation, salary). Write down the relational expressions for the following:

1. To get the name and designation of all employees.
2. To get the details of employees whose salary is above 25000.
3. To get the names of employees who designation is Manager.
4. To get the details of Managers with salary less than 25000.

Answer:

1. π_{name, designation} (EMPLOYEE)
2. σ_salary>25000 (EMLOYEE)
3. π_name( σ_{designation=”Manager”}(EMPLOYEE))
4. σ_{designation = “Manager” and salary < 25000} (EMLOYEE).

Question 2.
Data sharing is an essential feature of DBMS. How data sharing reduces the data inconsistency in a database? Data sharing is an essential feature of DBMS. How data sharing reduces the data inconsistency in a database?
Answer:
Instead of storing more than one copy of the same data, it stores only one copy. This can be shared by several users. If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

Question 3.
Pick the odd one out and justify your answer:
(a) Column
(b) Attribute
(c) Field
(d) Tuple
Answer:
(d) Tuple. The other three terminologies indicate the same characteristic of a table.

Question 4.
Suppose a table (relation) contains the details of customers in a bank. Which attribute of the customer will be set as primary key for the table? Give reason for your opinion.
Answer:
Account number can be set as primary key since account number is different for different customers. That is it is unique hence it can be set as primary key.

Question 5.
How many distinct tuples and attributes are there in a relation with cardinality 22 and degree 7. Answer:

• Cardinality is the number of rows (tuples)
• Hence number of tuples is 22
• Degree is the number of coloums (attributes)
• Hence number of attributes 7

Question 6.
Distinguish primary key and alternate key.
Answer:

1. Primary key: It is a set of one or more attributes used to uniquely identify a row Alternate
2. key: A candidate key other than the primary key.

Question 7.
Write an example for relational data model.
Answer:

Question 8.
Observe the following table and choose the correct match from the following options:

Column A	Column B
(1) Cardinality	(A) Row of a table
(2) Degree	(B) Table
(3) Relation	(C) Number of rows
(4) Tuple	(D) Number of columns
	(E) Attribute

(a) 1 → B, 2 → D, 3 → E, 4 → C
(b) 1 → C, 2 → D, 3 → E, 4 → A
(c) 1 → C, 2 → D, 3 → B, 4 → A
(d) 1 → D, 2 → C, 3 → B, 4 → E
Answer:
(c) 1 → C, 2 → D, 3 → B, 4 → A

Question 9.
Consider the table with the following fields Name, RollNumberand Mark for a set of students. Suggest a field among them, which is suitable for primary key. Justify your answer.
Answer:
field RollNumberis suitable for the primary key. The name and mark can have same values so they are not suitable for the primary key.

Question 10.
Raju is confused with the statement ‘logical data independence is more difficult to achieve than physical data independence’. How can you help Raju to understand the statement.
Answer:
Because Appl. Programs heavily dependent on the logical structure of data. So any change in structure means chance of rewriting Appl. Programs.

Question 11.
Match the following.

A	B
(a) DBA	(i) querying and updation
(b) Application programmer	(ii) ensures consistency
(c) Naive users	(iii) defines conceptual view

Answer:
(a) – (ii), (b) – (iii), (c) – (i)

Question 12.
Match the following.

A	B
(a) Hierarchical model	(i) data as tables
(b) Network model	(ii) Network as storage medium
(c) Relational model	(iii) Child record can have more than one parent
	(iv) Tree structure

Answer:
(a) – (iv), (b) – (iii), (c) – (i)

Question 13.
Your friend tells you that only relational model is used nowadays as DBMS. Will you agree with that? Justify.
Answer:
Yes. Other two models are complex. In RDMS, no redundancy and relationships can be formed easily.

Question 14.
The telephone number of Gokul is entered in Library file as 802111 and in admission register file as 802171.

1. Can you correlate this problem with a concept in DBMS
2. Can you propose a solution to avoid this.

Answer:

1. Consistency problem
2. Remove data redundancy.

Question 15.
What is a DBMS?
Answer:
A DBMS is used to store large volume of data and it is used to retrieve data whenever needed, edit the existing data, update the data and it is possible to delete also.

Question 16.
“View provides an excellent way to access data from data.” Do you agree with this statement? Justify your answer.
Answer:
Yes. Views can have data from more than one table, view can be queried, inserted into, deleted from and updated like a normal table.

Question 17.
A relation is given below.

Mark the following:
Tuple, Attributes, Cardinality, Degree
Answer:

• Tuple- It is the Rows
• Attributes – It is the columns
• Cardinality – 3(Number of Rows)
• Degree – 4 (Number of Columns)

Question 18.
State whetherTrue or False.

1. Primary key cannot be composite key.
2. Only a candidate key can become a Primary Key.
3. Foreign key of a table is a candidate key in another table.
4. Super key uniquely identifies a row in a relation.

Answer:

1. False
2. True
3. True
4. True

Question 19.
Explain the meaning of following operations.
Answer:
select the tuples whose department is sales and who have salary >5000.

Question 20.
Two relations are given below.
FOOTBALL

Name	Age
Jose	23
Raju	22

CRICKET

Name	Age
Jomon	22
Raju	22

Is it possible to find the players those who play both FOOTBALL AND CRICKET by applying any of the Relational Algebra Operations? Explain.
Answer:
Intersection operation.
FOOTBALL ∩ CRICKET.

Question 21.
How will you differentiate Primary key and Super Key? Answer:
Answer:

• primary key- one of the candidate keys chosen to uniquely identifies the rows of a table.
• Super key – Combination of a Primary key with any other attribute or group of attributes.

Question 22.
Cardinality of a table T1 is 10 and of table, T2 is 8 and the two relations are union compatible. If the cardinality of result T1 ∪ T2 is 13, then what is the cardinality of T1 ∩ T2? Justify your answer.
Answer:
Cardinally of table T1 is 10 means it has 10 rows Cardinally of table T2 is 8 means it has 8 rows Normally T1 ∪ T2 is 10 + 8 = 18 But Here T1 ∪ T2 is 13 means after eliminating duplication of 5 rows this happened. This means 5 rows are common. That is T1 ∩ T2 is 5.

Question 23.
Cardinality of a table T1 is 10 and of table, T2 is 8 and the two relations are union compatible.

1. What will be the maximum possible cardinality of T1 ∪ T2?
2. What will be the minimum possible cardinality of T1 ∩ T2?

Answer:
1. Degree(CD) -the number of Columns is the Degree
Cardinality (RC)-: the number of Rows is the Cardinality
T1 ∪ T2 = Sum of cardinalities of Table 1 and Table 2
i.e. T1 ∪ T2 = 10 + 8 = 18.

2. T1 ∩ T2 is the common rows(tuples) in T1 and T2 If there is no common tuples then T1 n T2 is 0 hence the cardinality is 0.

Plus Two Computer Application Database Management System Three Mark Questions and Answers

Question 1.
For catering to the needs of users, a database is implemented through three general levels. Name the three levels and discuss them.
Answer:

1. Physical Level is the lowest level.lt describes how the data is actually stored in the storage medium. At physical level complex low-level data structures are described in detail.
2. Logical level describes what data are stored in the database and what relationships exist among data. Here database is described in terms of simple structures. Records are defined in this level. Programmers work at this level.
3. View level is the highest level of data abstraction. It is concerned with the way in which the users view the database. It describes only part of the database.

Question 2.
Consider the following table and write relational algebra operations for the following DEPOSIT.

1. To display those tuples from DEPOSIT relation where amount is greater than 25,000.
2. To display only AccNo. and Amoun to fall depositors.

Answer:

1. σ_amount >25000 (Deposit)
2. π_{AccNo, amount} (deposit)

Question 3.

Show the output of the following relational operations.

1. R₁ – R₂
2. R₁ ∩ R₂
3. R₁ ∪ R₂

Answer:
1.

2.

3.

Question 4.
Developers hide the complexity of Database system three several levels of abstraction. What are they?
Answer:

1. Physical – (how data)
2. logical – (what data)
3. view level – (view data)

1. Physical Level is the lowest level. It describes how the data is actually stored in the storage medium. At physical level complex low-level data structures are described in detail.

2. Logical level describes what data are stored in the database and what relationships exist among data. Here database is described in terms of simple structure. Records are defined in this level. Programmers work at this level.

3. View level is the highest level of data abstraction. It is concerned with the way in which the users view the database. It describes only part of the database.

Question 5.
How data are organized in a database.
Answer:

1. Field: Smallest unit of data. Eg: RolINo, Name.
2. Record: Collection of related fields. Eg: The information of a particular student.
3. File: Collection of related records. Eg: The informations of 10 students.

Question 6.
Salih check his account details using an ATM machine.

1. Identify the levels of abstraction associated with this?
2. Specify other levels.

Answer:

1. View level
2. Logical level, Physical level

Question 7.
Match the following.

A	B
(1) Database Administrator	(a) Not concerned with or even aware of details of the DBMS
(2) Application Programer	(b) Person who has a central control over definition and DBMS
(3) Users	(c) Computer professionals who interact with the DBMS through Application programs

Answer:
(1) – (b), (2) – (c), (3) – (a)

Question 8.
Match the following.

A	B
Domain	Table
Tuple	No. of rows in a relation
Attribute	No. of columns in a relation
Cardinality	Rows in a relation
Degree	A pool of values
Relation	Column in a Table

Answer:

A	B
Domain	A pool of values
Tuple	Rows in a relation
Attribute	Column in a Table
Cardinality	No. of rows in a relation
Degree	No. of columns in a relation
Relation	Table

Question 9.
Explain the major components of DBMS.
Answer:
Components of DBMS:

1. Databases – It is the main component.
2. Data Definition Language (DDL) – It is used to define the structure of a table.
3. Data Manipulation Language (DML) – It is used to add, retrieve, modify and delete records in a database.
4. Users – With the help of programs users interact with the DBMS.

Question 10.
Categorise the users of DBMS and write their functions.
Answer:
Users of Database:

1. Database Administrator: It is a person who has a central control over the DBMS.
2. Application Programmer: These are computer professionals who interact with the DBMS through programs.
3. Naive users: He is an end user. He does not know the details of DBMS.

Question 11.
A table with three columns is given below. For each relational operation given in the 1^st column find the best matches from 2^nd and 3^rd columns.

Answer:

1. Select → c) σ → (ii)
2. Union → d) ∪ → (iv)
3. Set difference → b) → (i)

Question 12.
Observe the given table BOOK and write down the outputs of the following relational expressions:

Answer:
1. This query returns all the tuples(rows) that contain BPB in column Publisher.

2. This query returns the column Book_Title with price<200.
Book Title

• Computer Fundamentals
• C++ Programming
• Mystery of Chemistry

Plus Two Computer Application Database Management System Five Mark Questions and Answers

Question 1.
Cardinality of a table A is 10 and of table, B is 8 and the two relations are union compatible.

1. What will be the maximum possible cardinality of (A ∪ B) and (A ∩ B)?
2. What will be the minimum possible cardinality of (A ∪ B) and (A ∩ B)?

Give justifications for your answers.
Answer:
There are two possibilities:

1. Both relations contain different tuples (rows).
2. The 8 tuples (rows) of table B are same as that of table A.

Case 1.
If both relations contain different tuples then the maximum possible cardinality of A ∪ B is 10 + 8 = 18.

Case 2.
If 8 tuples of table B are same as that of table A then the maximum possible cardinality of A ⊂ B is 8.

Case 3
If 8 tuples of table B are same as that of table then the minimum possible cardinality of A ∪ B is 10.

Case 4.
If both relations contain different tuples then the minimum possible cardinality of A ∩ B is 0.

Question 2.
There are different data models of which one is currently used in all business transactions. Specify it and discuss in detail.
Answer:
Relational data model is currently used in all business transactions. It is based on the concept introduced by E F Codd. It is composed of one or more tables. Tables are made up of rows and columns.

Here tables are called relations, rows are called tuples and the columns are called attributes. The advantages of this model is neither data redundancy nor complexity. Eg:

Customer	Address
Gita	Add1
Lata	Add 2
Ram	Add3

Question 3.
You have to present a seminar on the topic “Keys in RDBMS”. Prepare the seminar report.
Answer:
1. Candidate Key:
It is a set of attributes that uniquely identifies a row. There may be more than candidate key and may be a combination of more than one attribute.

2. Primary Key:
A primary key is one of the Candidate Keys. It is a set of one or more attributes that can uniquely identify tuples in a relation.

3. Alternate Key:
The Candidate key that is not the primary key is called the alternate key.

4. Super Key:
A combination of a primary key with any other attribute or group of attributes is called a super key.

5. Foreign Key:
A single attribute or a set of attributes, which is a candidate key in another table, is called foreign key.

Question 4.

Consider the relations STUDENT and GRADE given above and predict the output of the following relational operations in table format.

1. σ (STUDENT)
   Score > 80
2. π (STUDENT)
   RegNo, Score
3. σ (GRADE)
   RegNo <103
4. σ (GRADE)
   Grade = ‘B+’
5. π_{RegNo, Name}( σ_{Scores >70}(STUDENT))

Answer:
1.

2.

RegNo	Scores
101	70
102	68
103	94
104	87
105	77

3.

4.

5.

RegNo	Name
103	Ruksana
104	Nancy
105	Anu

Question 5.
Explain any 4 Relational Algebra Operations.
Answer:
A. SELECT operation:
SELECT operation is used to select tuples in a relation that satisfy a selection condition. Greek letter σ (sigma) is used to denote the operation. Syntax,
σ_condition (relation)
eg. σ_{salary < 10000} (EMPLOYEE) – selects tuple whose salary is less than 10000 from EMPLOYEE relation.

B. PROJECT operation:
PROJECT operation selects certain columns from the table and discards the other columns. Greek letter π(pi) is used to denote PROJECT operation. Syntax,
π_condition (relation)
eg. π_{name, salary} (EMPLOYEE) displays only the name and salary of all employees.

C. UNION operation:
This operation returns a relation consisting of all tuples appearing in either or both of the two specified relations. It is denoted by U. duplicate tuples are eliminated.

Union operation can take place between compatible relations only, i.e., the number and type of attributes in both the relations should be the same and also their order.

e.g. SCIENCE ∪ COMMERCE gives all the tuples in both COMMERCE and SCIENCE.

D. INTERSECTION operation:
This operation returns a relation consisting of all the tuples appearing in both of the specified relations. It is denoted by n. It can takes place only on compatible relations, e.g. FOOTBALL ∩ CRICKET returns the players who are in both football and cricket teams.

Question 6.
Why should you choose a database system instead of simply storing data in conventional files?
Answer:
Advantages of DBMS over conventional files:
1. Data Redundancy:
It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.

2. Inconsistency can be avoided:
If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

3. Efficient data access:
It stored huge amount of data. efficiently and can be retrieved whenever a need arise.

4. Data can be shared:
The data stored in the database can be shared by the users or programs.

5. Standards can be enforced:
The data in the database follows some standards. Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.

6. Security restrictions can be applied:
The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized person.

7. Integrity can be maintained:
It ensures that the data is to be entered in the database is correct.

8. Crash recovery:
Some times all or a portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.

Question 7.
We have admission register, attendance register, marks register, etc. in our school to keep various details of students. Briefly describe how DBMS can replace these registers by stating any five merits.
Answer:
Advantages of DBMS:
1. Data Redundancy:
It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.

2. Inconsistency can be avoided:
If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

3. Data can be shared:
The data stored in the database can be shared by the users or programs.

4. Standards can be enforced:
The data in the database follows some standards. Eg : a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.

5. Security restrictions can be applied:
The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized person.

6. Integrity can be maintained:
It ensures that the data is to be entered in the databse is correct.

7. Efficient data access:
It stored huge amount of data efficiently and can be retrieved whenever a need arise.

8. Crash recovery:
Some times all or a portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.

Plus Two Computer Application Database Management System Let Us Assess Questions and Answers

Question 1.
Who is responsible for managing and controlling the activities associated with the database? (1 Mark)
(a) Database administrator
(b) Programmer
(c) Native user
(d) End user
Answer:
(a) Database administrator

Question 2.
In the relational model, cardinality is the (1 Mark)
(a) number of tuples
(b) number of attributes
(c) number of tables
Answer:
(a) number of tuples

Question 3.
Cartesian product in relational algebra is (1 Mark)
(a) a Unary operator
(b) a Binary operator
(c) a Ternary operator
(d) not defined
Answer:
(b) a Binary operator

Question 4.
Abstraction of the database can be viewed as (1 Mark)
(a) two levels
(b) four levels
(c) three levels
(d) one level
Answer:
(c) three level

Question 5.
In a relational model, relations are termed as (1 Mark)
(a) tuples
(b) attributes
(c) tables
(d) rows
Answer:
(c) tables

Question 6.
In the abstraction of a database system the external level is the (1 Mark)
(a) physical level
(b) logical level
(c) conceptual level
(d) view level
Answer:
(d) view level

Question 7.
Related fields in a database are grouped to form a (1 Mark)
(a) datafile
(b) data record
(c) menu
(d) bank
Answer:
(b) data record

Question 8.
A relational database developer refers to a record as (1 Mark)
(a) criteria
(b) relation
(c) tuple
(d) attribute
Answer:
(c) tuple

Question 9.
An advantage of the database management approach is (1 Mark)
(a) data is dependent on programs
(b) data redundancy increases
(c) data is integrated and can be accessed by multiple programs
(d) none of the above
Answer:
(c) data is integrated and can be accessed by multiple programs

Question 10.
Data independence means (1 Mark)
(a) data is defined separately and not included in programs
(b) programs are not dependent on the physical attributes of data
(c) programs are not dependent on the logical attributes of data
(d) both (b) and (c)
Answer:
(d) both (b) and (c)

Question 11.
Key to represent relationship between tables is called (1 Mark)
(a) primary key
(b) candidate Key
(c) foreign Key
(d) alternate Key
Answer:
(c) foreign key

Question 12.
Which of the folowing operations is used if we are interested only in certain columns of a table? (1 Mark)
(a) PROJECTION
(b) SELECTION
(c) UNION
(d) SELECT
Answer:
(a) PROJECTION

Question 13.
Which of the following operations need the participating relations to be union compatible? (1 Mark)
(a) UNION
(b) INTERSECTION
(c) SET DIFFERENCE
(d) All of the above
Answer:
(d) All of the above

Question 14.
Which database level is closest to the users? (1 Mark)
(a) External
(b) Irttemal
(c) Physical
(d) Conceptual
Answer:
(a) View level (External)

Question 15.
The result of the UNION operation between R1 and R2 is a relation that includes (1 Mark)
(a) all the tuples of R1
(b) all the tuples of R2’
(c) all the tuples of R1 and R2
(d) all the tuples of R1 and R2 which have common columns
Answer:
(c) All the tuples of R1 and R2 (eliminating the duplication)

Question 16.
A file manipulation command that extracts some of the records from a file is called (1 Mark)
(a) SELECT
(b) PROJECT
(c) JOIN
(d) PRODUCT
Answer:
(a) SELECT

Question 17.
An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true? (1 Mark)
(a) A is a candidate key
(b) A is not a candidate key
(c) A is a primary key
(d) Both (a) and (c)
Answer:
(a) A is a candidate key

Question 18.
How many distinct tuples are there in relation instance with cardinality 22? (1 Mark)
(a) 22
(b) 11
(c) 1
(d) none
Answer:
(a) 22

Question 19.
A set of possible data values is called (1 Mark)
(a) Attribute
(b) Degree
(c) Tuple
(d) Domain
Answer:
(d) Domain

Question 20.
Why should you choose a database system instead of simply storing data in conventional files? (5 Mark)
Answer:
Advantages of DBMS over conventional files:
1. Data Redundancy:
It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.

2. Inconsistency can be avoided:
If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

3. Efficient data access:
It stored huge amount of data efficiently and can be retrieved whenever a need arise.

4. Data can be shared:
The data stored in the database can be shared by the users or programs.

5. Standards can be enforced:
The data in the database follows some standards. Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.

6. Security restrictions can be applied:
The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized person.

7. Integrity can be maintained:
It ensures that the data is to be entered in the database is correct.

8. Crash recovery:
Some times all or a portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.

Question 21.
Explain the different levels of data abstraction in DBMS? (3 Mark)
Answer:
Levels of Database Abstraction:

1. Physical Level (Lowest Level): It describes how the data is actually stored in the storage medium.
2. Logical Level (Next Higher Level): It describes what data are stored in the database.
3. View Level (Highest level): It is closest to the users. It is concerned with the way in which the individual users view the data.

Question 22.
How are schema layers related to the concepts of logical and physical data independence? (3 Mark)
Answer:
Data Independence:
It is the ability to modify the scheme definition in one level without affecting the scheme definition at the next higher level.

1. Physical Data Independence: It is the ability to modify the physical scheme without causing application programs to be rewritten.
2. Logical Data Independence: It is the ability to modify the logical scheme without causing application programs to be rewritten.

Question 23.
Consider the instance of the EMPLOYEE relation shown in the following table. Identify the attributes, degree, cardinality, and domain of Name and Emp_code. (3 Mark)

Answer:

1. Attributes: These are column names, i.e, Emp_Code, Name, Department, Designation, and Salary.
2. Degree(CD): The number of Columns is the Degree i.e Degree is 5(Here 5 columns).
3. Cardinality (RC): the number of Rows is the Cardinality.

i.e. Cardinality is 4(Here 4 rows)
Domain is the pool of possible values. Domain of Name is a String(Sudheesh, Dhanya,
Fathima, Shajan.etc). Domain of Emp_Code is a number (1000,1001,1002, 1003, etc).

Question 24.
Identify primary key, candidate keys and alternate keys in the instance of EMPLOYEE relation in Question 23. (3 Mark)
Answer:
Candidate key: It is used to uniquely identify the row.

1. Emp_code and Emp_Code + Department (Composite) are the candidate keys:
   Primary key: It is a set of one or more attributes used to uniquely identify a row.
2. Emp_code is the primary key:
   Alternate key: A candidate key other than the primary key.

We set Emp_code as the primary key then Emp_code+ Department is the alternate key.

Question 25.
Consider the instance of the STUDENT relation shown in the following table Assume Reg_no as the primary key. (3 Mark)

1. Identify the candidate keys and alternate keys in the STUDENT relation
2. How are the primary key and the candidate key related?

Answer:

1. Reg_no and Reg_no+Batch are the candidate keys. We set Reg_no as the primary key hence Reg_no+Batch is the alternate key
2. Candidate Key: It is a set of attributes that uniquely identifies a row. There may be more than candidate key and may be a combination of more than one attribute.
3. Primary Key: A primary key is one of the Candidate Keys. It is a set of one or more attributes that can uniquely identify tuples in a relation.

Question 26.
What is a database? Describe the advantages and disadvantages of using DBMS. (5 Mark)
Answer:
A Database is a collection of large volume of data.
Advantages of DBMS:
1. Data Redundancy: It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.

2. Inconsistency can be avoided: If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

3. Efficient data access: It stored huge amount of data efficiently and can be retrieved whenever a need arise.

4. Data can be shared: The data stored in the database can be shared by the users or programs.

5. Standards can be enforced: The data in the database follows some standards. Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.

6. Security restrictions can be applied: The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized person.

7. Integrity can be maintained: It ensures that the data is to be entered in the database is correct.

8. Crash recovery: Some times all ora portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.

Question 27.
What is data independence? Explain the difference between physical and logical data independence. (3 Mark)
Answer:
Data Independence: It is the ability to modify the scheme definition in one level without affecting the scheme definition at the next higher level.

1. Physical Data Independence: It is the ability to modify the physical scheme without causing application programs to be rewritten.
2. Logical Data Independence: It is the ability to modify the logical scheme without causing application programs to be rewritten.

Question 28.
Enforcement of standard is an essential feature of DBMS. How are these standards applicable in a database? (3 Mark)
Answer:
There is a standard BIS (Bureau of Indian Standards) in the field of Gold and ISBN (International Standard Book Number) in the field of publication. Similarly here is also some standards like ANSI(American National Standards Institute), ISO (International Organization for standardization), etc.. For example a filed “Name” should have 40 characters is a standard.

Question 29.
Cardinality of a table T1 is 10 and of table, T2 is 8 and the two relations are union compatible. If the cardinality of result T1 ∪ T2 is 13, then what is the cardinality of T1 ∩ T2? Justify your answer. (3 Mark)
Answer:
Cardinalty of table T1 is 10 means it has 10 rows Cardinalty of table T2 is 8 means it has 8 rows Normally T1 ∪ T2 is 10 + 8 = 18 But Here T1 ∪ T2 is 13 means after eliminating duplication of 5 rows this happened. This means 5 rows are common. That is T1 ∩ T2 is 5.

Question 30.
Cardinality of a table T1 is 10 and of table, T2 is 8 and the two relations are union compatible.

1. What will be the maximum possible cardinality of T1 ∪ T2?
2. What will be the minimum possible cardinality of T1 ∩ T2? (3 Mark)

Answer:
1. Degree(CD): the number of Columns is the Degree.
Cardinality (RC)-: the number of Rows is the Cardinality
T1 ∪ T2 = Sum of cardinalities of Table1 and Table2
i.e. T1 ∪ T2 = 10 + 8 = 18.

2. T1 ∩ T2 is the common rows(tuples) in T1 and T2 If there is no common tuples then T1 ∩ T2 is 0 hence the cardinality is 0.

Question 31.
Consider the relations, City (city_name, state) and Hotel (name, address, city_name). Answer the following queries in relational algebra (5 Mark)

1. Find the names and address of hotels in Kochi.
2. List the details of cities in Kerala state.
3. List the names of the hotels in Thrissur.
4. Find the names of different hotels.
5. Find the names of hotels in Kozhikode or Munnar.

Answer:

1. π_{name, address} (σCity_name = “Kochi” (Hotel))
2. π_{city_name} (σstate = “Kerala” (City))
3. π_name (σcity_name = “Thrissur” (Hotel))
4. π_name (Hotel)
5. π_name(σcity_name = “Kozhikode” V city_name = “Munnar” (Hotel)).

Question 32.
Using the instance of the EMPLOYEE relation shown in question 23, write the result of the following relational algebra expressions. (5 Mark)

1. σ_{Departments=“Sales”}(EMPLOYEE).
2. σ_{salary> 20000 ∧ Department = “Sales”} (EMPLOYEE).
3. σ_{Salary>20000 ∨ Department = “Sales”} (EMPLOYEE).
4. π_{name, salary} (EMPLOYEE).
5. π_{name, salary} (σ_{Designations=“Manager”} (EMPLOYEE)).
6. π_{name, Department} (σ_{Designation = “Clerk” salary > 20000}(EMPLOYEE)).

Answer:
1.

2.

3.

4.

Name	Salary
Sudheesh	25000
Dhanya	25000
Fathima	12000
Shajan	13000

5.

Name	Salary
Sudheesh	25000
Dhanya	25000

6. No rows selected.

Question 33.
Consider the instance of the BORROWER and DEPOSITOR relations shown in following figure which stores the details of customers in a Bank. Answer the following queries in relational algebra. (5 Mark)

1. Display the details of the customers who are either a depositor or a borrower.
2. Display the name of customers who are both a depositor and a borrower.
3. Display the details of the customers who are d positors but not borrowers.
4. Display the name and amount of customer who is a borrower but not depositor.

Answer:
1.

Acc_No	Name
AC 123	Albin
AC105	Shabana
AC116	Vishnu
AC 108	Aiswarya
AC 103	Rasheeda
AC 106	Vishnu

2.

Acc_No	Name
AC123	Albin
AC108	Aiswarya

3.

Acc_No	Name
AC 105	Shabana
AC116	Vishnu

4.

Name	Amount
Rasheeda	25000
Vishnu	25000

Question 34.
Consider the instance of the CUSTOMER and BRANCH relations shown in the following table. Write the Cartesian Product of the two relations. (3 Mark)


Answer:

Students can Download Chapter 5 Continuity and Differentiability Questions and Answers, Plus Two Maths Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Maths Chapter Wise Questions and Answers Chapter 5 Continuity and Differentiability

Plus Two Maths Continuity and Differentiability Three Mark Questions and Answers

Question 1.
Consider the function g(x) = \(\frac{|x-2|}{x-2}\)

1. Find the domain and range of the function g(x). (2)
2. Check whether the g(x) is continuous at x = 2. (1)

Answer:
1. The function is not defined at points where denominator is zero.
i.e., x – 2 = 0 ⇒ x = 2.
∴ domain is R – {2}.
g(x) = \(\frac{|x-2|}{x-2}\) = \(\left\{\begin{array}{c}{\frac{x-2}{x-2}, \quad x-2>0} \\{\frac{-(x-2)}{x-2}, \quad x-2<0}\end{array}=\left\{\begin{array}{ll}{1,} & {x>2} \\{-1,} & {x<2}\end{array}\right.\right.\)
∴ range is {-1, 1}

2. The function g(x) is not defined at x = 2. Therefore discontinuous.

Question 2.
(i) If f(x) = x+|x| + 1, then which of the follow represents f (x) (1)


(ii) Test whether f (x) is continuous at x=0. Explain. (2)
Answer:
(i) (b) Since, f(x) = \(\left\{\begin{array}{c}{x+x+1, x \geq 0} \\{x-x+1, \quad x<0}
\end{array}=\left\{\begin{array}{c}{2 x+1, x \geq 0} \\{1, x<0}\end{array}\right.\right.\)

(ii) We have ,f (0) = 1,

Continuous at x = 0.

Question 3.
Consider the function f(x) = \(\left\{\begin{array}{ll}{\frac{\sin x}{x}} & {, x<0} \\{x+1} & {, x \geq 0}\end{array}\right.\)

1. Find \(\lim _{x \rightarrow 0} f(x)\) (2)
2. Is f (x) continuous at x= 0? (1)

Answer:
1. To find \(\lim _{x \rightarrow 0} f(x)\) we have to find f(0^– )and f(0⁺)
f(0^–) = \(\lim _{x \rightarrow 0} \frac{\sin x}{x}=1\),
f(0⁺) = \(\lim _{x \rightarrow 0}\) + 1 = 0 + 1 = 1
f(0^–) = f(0⁺) = 1 .Therefore \(\lim _{x \rightarrow 0} f(x)\) = 1

2. Here, f (0) = 0 + 1 = 1 = f(0^–) = f(0⁺) = 1
Therefore continuous at x = 0.

Question 4.
Consider the figure and answer the following questions.

(i) Identify the graphed function. (1)


(ii) Discuss the continuity of the above function at x = 2. (2)
Answer:
(i) (b) f(x) = \(\left\{\begin{array}{ll}{\frac{|x-2|}{x-2},} & {x \neq 2} \\{0,} & {x=2}\end{array}\right.\)

(ii) From the figure we can see that
f(2^–) = 1, f(2⁺) = -1 and f(2) = 0
Therefore, f(2^–) = 1 ≠ f(2⁺) = -1 ≠ f(2) = 0. Discontinuous.

Question 5.
Consider f(x) = \(\left\{\begin{array}{ll}{2 x} & {\text { if } x<2} \\{2} & {\text { if } x=2} \\ {x^{2}} & {\text { if } x>2}\end{array}\right.\)
(a) Find \(\lim _{x \rightarrow 2^{-}} f(x)\) and \(\lim _{x \rightarrow 2^{+}} f(x)\) (2)
(b) f(x) is continuous. If not so, how can you make it continuous. (1)
Answer:


Therefore f(x) is not continuous at x = 2.
If f(2) = 4, then f(x) becomes continuous.

Question 6.
If y = log₁₀x + log_x10 + log_xx + log₁₀10. Find \(.
Answer:
y = log_e x log₁₀e + log_e10 log_xe + 1 + 1

Question 7.
Examine the continuity of the function

Answer:
In both the intervals x = 1 and x < 1 the function f(x) is a polynomial so continuous. So we have to check the continuity at x = 1.

f(1) = 2
Since

f(x) is continuous at x = 1.

Question 8.
Find [latex]\frac{d y}{d x}\) of the following (3 score each)

1. 2x + 3y = sinx
2. xy + y² = tanx + y
3. x³ + x²y + xy² + y³ = 81
4. sin²x + cos²y = 1
5. \(\sqrt{x}\) + \(\sqrt{y}\) = 1
6. x² + xy + y² = 7
7. x²(x – y) = y²(x + y)
8. xy² + x²y = 2
9. sin y = xcos (a + y)

Answer:
1. Given; 2x + 3y = sinx
Differentiating with respect to x;

2. Given; xy + y² = tanx + y
Differentiating with respect to x;

3. Given; x³ + x²y + xy² + y³ = 81
Differentiating with respect to x;

4. Given; sin²x + cos²y = 1
Differentiating with respect to x;

5. \(\sqrt{x}\) + \(\sqrt{y}\) = 1
Differentiating with respect to x;

6. x² + xy + y² = 7
Differentiating with respect to x;

7. x²(x – y) = y²(x + y)
Differentiating with respect to x;

8. xy² + x²y = 2
Differentiating with respect to x;

9. sin y = xcos (a + y)
⇒ x = \(\frac{\sin y}{\cos (a+y)}\)
Diff. with respect to y.

Question 9.
Find \(\frac{d y}{d x}\) of the following (3 score each)

(viii) x = a(t – sint), y = a(1 – cost)
(ix) y = e^t cost, x = e^t sint.
Answer:
(i) We know; y = sin^-1\(\left(\frac{2 x}{1+x^{2}}\right)\)
⇒ y = = 2 tan^-1(x)
Differentiating with respect to x;

(ii) We know; y = tan^-1\(\left(\frac{3 x-x^{3}}{1-3 x^{2}}\right)\)
Put x = tanθ ⇒ θ = tan^-1x

⇒ y = tan^-1(tan3θ)
⇒ y = 3 tan^-1(x)
Differentiating with respect to x;

(iii) We know; y = sin^-1\(\left(\frac{1-x^{2}}{1+x^{2}}\right)\)
Put x = tanθ ⇒ θ = tan^-1x

(iv) We know; y = sec^-1 = \(\left(\frac{1}{2 x^{2}-1}\right)\)
Put x = cosθ ⇒ θ = cos^-1x

⇒ y = sec^-1 sec2θ = 2θ
⇒ y = 2cos^-1(x)
Differentiating with respect to x;

(v) ∴ y = tan^-1\(\sqrt{\tan ^{2} x / 2}\) = tan^-1 tanx/2 = x/2
\(\frac{d y}{d x}=\frac{1}{2}\).

= π – 2tan^-1x
\(\frac{d y}{d x}=\frac{-2}{1+x^{2}}\).

(vii) Let x = sinθ and \(\sqrt{x}\) = sinφ

= sin^-1 (sinθcosφ + cosφsinφ)
= sin^-1 (sin(θ + φ)) = θ + φ
= sin^-1x + sin^-1\(\sqrt{x}\)
\(\frac{d y}{d x}=\frac{1}{\sqrt{1-x^{2}}}+\frac{1}{\sqrt{1-x}} \times \frac{1}{2 \sqrt{x}}\).

(ix) y = e^tcost ⇒ \(\frac{d y}{d t}\) = – e^t sin t + e^t
x = e^t sint ⇒ \(\frac{d x}{d t}\) = e^t cos t + e^t sin t

Question 10.
If y = log\(\left(\frac{1}{x}\right)\), Show that \(\frac{d y}{d x}\) + e^y = 0.
Answer:
Given, y = log\(\left(\frac{1}{x}\right)\) ? \(\left(\frac{1}{x}\right)\) = e^y …….(1)

Question 11.
If e^y (x+1) = 1. Show that

1. \(\frac{d y}{d x}\) = -e^y (2)
2. \(\frac{d^{2} y}{d x^{2}}=\left(\frac{d y}{d x}\right)^{2}\) (1)

Answer:
1. e^y (x+1) = 1
Differentiating e^y +e^y(x +1) \(\frac{d y}{d x}\) = 0

2.

Question 12.
(i) Evaluate \(\lim _{x \rightarrow 0} \frac{k \cos x}{\pi-2 x}\) (2)
(Hint: Put π – 2x = y , where Iris a constant)
(ii) Find the value of k if f (x) is a continuous function given by (1)

Answer:
(i) \(\lim _{x \rightarrow \pi / 2} \frac{k \cos x}{\pi-2 x}=k \lim _{x \rightarrow \pi / 2} \frac{\cos x}{\pi-2 x}\),
Put π – 2x = y when Put x → π/2, y → 0

(ii) Since f (x) is continuous

Question 13.
If f(x) \(f(x)=\left\{\begin{array}{cc}{x-[x]} & {, x<.2} \\{0} & {; x=2} \\{3 x-5} & {, x>2}
\end{array}\right.\)

1. Find \(\lim _{x \rightarrow 2} f(x)\) (2)
2. Is f(x) continuous at x = 2? (1)

Answer:
1. To find \(\lim _{x \rightarrow 2} f(x)\)
we have to find f(2^–) and f(2⁺)
f(2^–) = \(\lim _{x \rightarrow 2} x-[x]\) = 2 -1 = 1,
f(2⁺) = \(\lim _{x \rightarrow 2}\) 3x – 5 = 6 -5 = 1
f(2^–) = f(2⁺) = 1.
Therefore \(\lim _{x \rightarrow 2}\) f(x) = 1

2. Here, f(2) = 0 ≠ f(2^–) = f(2⁺) = 1.
Therefore discontinuity at x = 2.

Plus Two Maths Continuity and Differentiability Four Mark Questions and Answers

Question 1.
If x = 2cosθ; y = 3sinθ

1. Find \(\frac{d y}{d x}\).
2. Find \(\frac{d^{2} y}{d x^{2}}\)

Answer:
1. x = 2cosθ ⇒ \(\frac{d x}{d θ}\) = -2sinθ
y = 3sinθ ⇒ \(\frac{d x}{d θ}\) = 3cosθ

2.

Question 2.
If y = (tan^-1 x)², show that (x² +1)² y₂ + 2x(x² +1) y₁ = 2.
Answer:
y = (tan^-1 x)²
⇒ y₁ = 2(tan^-1 x) \(\frac{1}{1+x^{2}}\)
⇒ (1 + x²)y₁ = 2(tan^-1 x)
⇒ (1 + x²)y₂ + y₁2x = 2 \(\frac{1}{1+x^{2}}\)
⇒ (1 + x²)² y₂ + x(1 + x²)y₁ = 2.

Question 3.
Find \(\frac{d y}{d x}\) if y = sin^-1 \(\left(\frac{1-x^{2}}{1+x^{2}}\right)\), 0 < x < 1.
Answer:
Put x = tanθ

Question 4.
Let f(x) = \(\left\{\begin{array}{ll}{\cos x,} & {0 \leq x \leq c} \\{\sin x,} & {c<x \leq \pi}\end{array}\right.\)

1. Find the value of c if / is continuous on [0, π].
2. Show that is f not differentiable at the point c.

Answer:
1. Since f is continuous on [0, π], we have;
\(\lim _{x \rightarrow c^{+}}\) f(x) = \(\lim _{x \rightarrow c^{-}}\) f(x) = f(c)
⇒ \(\lim _{x \rightarrow c^{+}}\) sinx = \(\lim _{x \rightarrow c^{-}}\) cosx = cosc
⇒ sinc = cosc ⇒ c = \(\frac{π}{4}\).

2. \(f^{\prime}(x)=\left\{\begin{array}{ll}{-\sin x,} & {0 \leq x \leq c} \\{\cos x,} & {c<x \leq \pi}\end{array}\right. \)
Left derivative at \(\frac{\pi}{4}\) = – sin \(\frac{\pi}{4}\) = –\(\frac{1}{\sqrt{2}}\)
Right derivative at \(\frac{\pi}{4}\) = cos \(\frac{\pi}{4}\) = \(\frac{1}{\sqrt{2}}\)
Left derivative at \(\frac{\pi}{4}\) ≠ Right derivative at \(\frac{\pi}{4}\)
Therefore is not differentiable at the point c.

Question 5.

1. Find \(\frac{d y}{d x}\) if x = 2sinθ; y = 3cosθ
2. Which among the following functions is differentiable on R?

(a) |sinx|
(b) |cosx|
(c) cos|x|
(d) sin|x|
Answer:
1. \(\frac{d x}{d θ}\) = 2cosθ; \(\frac{d y}{d θ}\) = -3 sinθ ⇒ \(\frac{d y}{d x}\) = \(-\frac{3}{2}\)tanθ

2. (c) cos|x|
(Since cos x is an even function, it treats x and -x in the same way).

Question 6.
(i) Examine whether the function defined by \(f(x)=\left\{\begin{array}{ll}{x+5,} & {x \leq 1} \\{x-5,} & {x>1}\end{array}\right.\) is continuous or not. (2)
(ii) If x = ^sin-1t, y = ^cos-1t, a > 0, show that \(\frac{d y}{d x}=-\frac{y}{x}\)
Answer:

f(x) is not continuous.

Question 7.
(i) If \(f(x)=\left\{\begin{array}{ll}{1-x,} & {0 \leq x \leq 1} \\{1+x,} & {1<x \leq 2}\end{array}\right.\) then which of the following is not true (1)
(a) f is continuous in ( 0, 1 )
(b) f is continuous in (1, 2 )
(c) f is continuous in [ 0, 2 ]
(d) f is continuous in [ 0,1 ]
if \(\left\{\begin{array}{cc}{1,} & {x \leq 3} \\{a x+b} & {, \quad 3<x<5} \\{7,} & {5 \leq x}\end{array}\right.\)
(ii) Find f(3⁺) and f(5^–) (1)
(iii) Hence find the value of ‘a’ and ‘b’ so that f(x) is continuous. (2)
Answer:
(i) (c) Since f is not continuous at x = 1.

(iii) Since f (x) is continuous, it is continuous at x = 3 and x = 5
∴ f(3⁺) = f(3) ⇒ 3a + b = 1 ____(1)
and f(5^–) = f(5) ⇒ 5a + b = 7 ____(2)
(2) – (1) ⇒ 2a = 6, a = 3
(1) ⇒ b = 1 – 3 a ⇒ b = -8
∴ a = 3, b = – 8.

Question 8.
Consider f(x) = \(\left\{\begin{array}{ll}{2 x+3,} & {x \leq 2} \\{x+2 k,} & {x>2}\end{array}\right.\)

1. Find f(2) (1)
2. Evaluate \(\lim _{x \rightarrow 2^{+}}\)f(x) (1)
3. Find the value of k, if is continuous at x = 2. (2)

Answer:
1. f(2) = 2(2) + 3 = 7

2. Here, f(x) = x + 2k for x > 2.
\(\lim _{x \rightarrow 2^{+}}\)f(x) = \(\lim _{x \rightarrow 2}\)(x + 2k) = 2 + 2k.

3. Since f (x) is continuous at x = 2
We have, f(2) = \(\lim _{x \rightarrow 2^{+}}\)f(x)
⇒ 7 = 2 + 2k ⇒ k = \(\frac{5}{2}\)

Question 9.
Find \(\frac{d y}{d x}\) of the following (4 score each)

1. y = (logx)^cosx
2. x = 2at², y = at⁴
3. x = a(cosθ + θsinθ), y = a(sinθ – θcosθ)
4. y=x^x
5. y =(x log x)^log(logx)
6. y = \(\sqrt{\sin x \sqrt{\sin x+\sqrt{\sin x+\ldots .}}}\)
7. y^x = x^siny
8. y =(log x)^x + x^logx
9. y = (sinx)^x + sin^-1 \(\sqrt{x}\)

Answer:
1. Given; y = (logx)^cosx, taking log on both sides;
log y = cosxlog(logx),
Differentiating with respect to x;

2. Given; x = 2at² ⇒ \(\frac{d x}{d t}\) = 4at

3. Given; x = a(cosθ + θsinθ)
\(\frac{d x}{d \theta}\) = a(-sinθ + θcosθ + sinθ) = aθcosθ
y = a(sinθ – θcosθ)
\(\frac{d x}{d \theta}\) = a(cosθ – θ(-sinθ) – cosθ) = aθ sinθ
\(\frac{d y}{d x}=\frac{a \theta \sin \theta}{a \theta \cos \theta}=\tan \theta\)

4. y= x^x; Taking log on both sides;
log y = x log x

5. y = (x log x)^{log logx}
Taking log on both sides;
log y = (log log x) [log (xlogx)]

6. y = \(\sqrt{\sin x+y}\) ⇒ y² = sinx + y
⇒ y² – y = sinx

7. y^x = x^{sin y};
Taking log on both sides;
xlogy = siny log x

8. y = (log x)^x + x^logx = u + v

9. y = (sinx)^x + sin^-1\(\sqrt{x}\)
Let u = (sinx)^x ⇒ log u = x log sinx

Question 10.
Find \(\frac{d^{2} y}{d x^{2}}\) of the following

1. y = x² + 3x + 2 (2)
2. y = tan^-1x (2)

Answer:
1. Given; y = x² + 3x + 2
Differentiating with respect to x;
\(\frac{d y}{d x}\) = 2x + 3
Differentiating again with respect to x;
\(\frac{d^{2} y}{d x^{2}}\) = 2.

2. Given; y = tan^-1x
Differentiating with respect to x; \(\frac{d y}{d x}\) = \(\frac{1}{1+x^{2}}\)
Differentiating again with respect to x;
\(\frac{d^{2} y}{d x^{2}}\) = \(-\frac{1}{\left(1+x^{2}\right)^{2}} \cdot 2 x\).

Question 11.
Match the following. (4)

Answer:

Question 12.
If x – sint and y = sinmt show that
(i) y = sin(m sin^-1x) (1)
(ii) \(\frac{d y}{d x}\) (1)
(iii) (1 – x²) y₂ – xy₁ + m²y = 0 (2)
Answer:
(i) x = sint, y = sinmt
t = sin^-1x ⇒ y = sin(msin^-1x).


multiplying with \(\sqrt{1-x^{2}}\)
(1 – x²) y₂ – xy₁ = -m²y
(1 – x²) y₂ – xy₁ + m²y = 0.

Question 13.
Consider the function f(x) = x(x – 2), x ∈ [1, 3]. Verify mean value theorem for the function in[1, 3].
Answer:
f(x) = x(x – 2) = x² – 2x ⇒ f'(x) = 2x – 2.
As f is a polynomial, it is continuous in the interval [1, 3] and differentiable in the interval (1, 3).
Therefore two conditions of MVT are satisfied and so there exists c ∈ (1,3)such that.

Hence MVT is verified.

Question 14.
Verify Lagranges’ Mean value theorem for the function f(x) = 2x² – 10x + 29 in [2, 9]
Answer:
f(x) = 2x² – 10x + 29; f'(x) = 4x – 10.
As f is a polynomial, it is continuous in the interval [2, 9] and differentiable in the interval (2, 9).
Therefore two conditions of MVT are satisfied and so there exists c ∈ (2, 9) such that.

Hence MVT is verified.

Question 15.
Let f(x) = x(x – 1)(x – 2), x ∈ [0, 2]

1. Find f(0) and f(2) (1)
2. Find f'(x) (1)
3. Find the values of x when f'(x) = 0 verify Rolle’s theorem. (2)

Answer:
1. f(0) = 0, f(2) = 2(2 – 1)(2 – 2) = 0

2. We have, f(x) = x³ – 3x² + 2x
⇒ f'(x) = 3x² – 6x + 2.

3. f'(x) = 3x² – 6x + 2 = 0

Clearly all the three conditions of Rolle’s theorem are satisfied and 1 ± \(\frac{1}{\sqrt{3}}\) ∈ (0, 2).

Question 16.
Verify Rolle’s Theorem for the function
f(x) = x² + 2x – 8, x ∈ [-4, 2]
Answer:
f(x) = x² + 2x – 8, f'(x) = 2x + 2.
As f is a polynomial, it is continuous in the interval [-4, 2] and differentiable in the interval (-4, 2).
f(-4) = 16 – 8 – 8 = 0
f(2) = 4 + 4 – 8 = 0
f'(c) = 0 ⇒ 2c + 2 = 0 ⇒ c = -1 ∈ (-4, 2) Hence Rolle’s Theorem is verified.

Question 17.
Examine that Rolle’s Theorem is applicable to the following function in the given intervals, justify your answer.

1. f(x) = [x], x ∈ [5, 9]
2. f(x) = x² – 1, x ∈ [1, 2]

Answer:
1. The function f(x) = [x] is not differentiable and continuous at integral values. So in the given interval [5, 9] the function is neither differentiable nor continuous at x = 6, 7 ,8. Therefore Rolle’s Theorem is not applicable.

2. The function f(x) = x² – 1 is a polynomial function so differentiable and continuous.
f(1) = 1 – 1 = 0, f(2) = 4 – 1 = 3
f(1) ≠ f(2) . Therefore Rolle’s Theorem is not applicable.

Question 18.
Examine the continuity of the function
\(f(x)=\left\{\begin{array}{cc}{|x|+3,} & {x \leq-3} \\{-2 x,} & {-3<x<3} \\{6 x+2,} & {x \geq 3}\end{array}\right.\)
Answer:
In the intervals x ≤ -3, f(x) is the sum of a constant function and modulus function so continuous. In the intervals -3 < x < 3 and x ≥ 3the function f(x) is a polynomial so continuous. Hence we have to check the continuity at x = -3, x = 3.
At x = -3
f(-3) = 6

f(x) is continuous at x = -3.
At x = 3
f(3) = 6(3) + 2 = 20

Since \(\lim _{x \rightarrow 3^{-}}\)f(x) = f(3), f(x) is not continuous at x = 3.

Question 19.
Test continuity for the following functions.

Answer:

= 0 × a finite quantity between -1 and 1 = 0 Also f(0) = 0
Therefore f(x) is continuous at x = 0.

Therefore f(x) is discontinuous at x = 0

But f(1) = 2
∴ f(x) is discontinuous at x = 1.

Question 20.
If y = \(\frac{\sin ^{-1} x}{\sqrt{1-x^{2}}}\) prove that
(i) (1 – x²) y² = (sin^-1x)² (1)
(ii) (1 – x²)y₁ – xy = 1 (1)
(iii) (1 – x²) y₂ – 3xy₁ – y = 0 (2)
Answer:

(ii) Differentiating
(1 – x²) 2y.y₁ + y²x – 2x = \(\frac{2 \sin ^{-1} x}{\sqrt{1-x^{2}}}\)
(1 – x²)2yy₁ – 2xy² = 2y
(1 – x²) y₁ – xy = 1.

(iii) Again differentiating
(1 – x²) y₂ + y₁ x – 2x – xy₁ – y = 0
(1 – x²) y₂ – 3xy₁ – y = 0.

Question 21.
At what point on the curve y = x², x ∈ [-2, 2] at which the tangent is parallel to x-axis?
Answer:
Y = x², a continuous function on [-2, 2] and differentiable on [-2, 2] f(2) = 4 = f(-2). All conditions of Rolles theorem is satisfied. Given the tangent is parallel to x-axis.
f¹ (x) = 2x
f¹(c) = 2c
f¹(c) = 0 ⇒ 2c = 0 ⇒ c = 0 ∈ [-2, 2]
where c = 0, y = 0
Therefore (0, 0) is the required point.

Question 22.

is continuous in the interval [-1 1].
(a) Find \(\lim _{x \rightarrow 0}\)f(x) (2)
(b) Find f(0). (1)
(c) Find P. (1)
Answer:


(c) Since f is continuous in [-1 1] it is continuous at 0.
Therefore P = \(-\frac{1}{2}\).

Question 23.
If ax² + 2hxy + by² = 1

1. Find \(\frac{d y}{d x}\) (1)
2. Find \(\frac{d^{2} y}{d x^{2}}\) (3)

Answer:
1. We have, ax² + 2hxy + by² = 1 ___(1)
Differentiating w.r.t.x, we get,

2. Differentiating (2) w.r.tx, we get,

Question 24.
Consider the function y = x^x \(\sqrt{x}\)

1. Express the above function as logy = \(\left(x+\frac{1}{2}\right)\) logx (2)
2. Find \(\frac{d y}{d x}\) (2)

Answer:
1. Given, y = x^x \(\sqrt{x}\). Take log on both sides,

2. We have, logy = \(\left(x+\frac{1}{2}\right)\) logx
Differentiating w.r.t x, we get,

Plus Two Maths Continuity and Differentiability Six Mark Questions and Answers

Question 1.

1. Verify mean value theorem for the function f(x) = (x – 2)² in [1, 4].
2. Find a point on the curve y = (x – 2)² at which the tangent is parallel to the chord joining the points (1, 1) and (4, 2)
3. Find a point on the above curve at which the tangent is parallel to the x-axis.

Answer:
1. f(x) = (x – 1)², x ∈ [1, 4]
f(x) is continuous in [1, 4]
f'(x) = 2(x – 2) is differentiable in [1, 4]
Then there exists c ∈ [1, 4] so that

Hence Mean Value Theorem is verified.

2. c = \(\frac{5}{2}\) will be the x-coordinate to the point of contact of tangent and the curve, then y = (x – 2)² ⇒ y = (\(\frac{5}{2}\) – 2)² = \(\frac{1}{4}\)
Therefore the point is (\(\frac{5}{2}\), \(\frac{1}{4}\)).

3. The tangent parallel to x- axis will have
f'(c) = 0 ⇒ 2(c – 2) = 0 ⇒ c = 2
Then; x = 2 ⇒ y = (2 – 2)² = 0
Therefore the point is (2, 0).

Question 2.

1. Differentiate x^sinx w.r.t.x (2)
2. If x = at², y = 2at, then find \(\frac{d y}{d x}\) (2)
3. If y = sin^-1(cosx) + cos^-1(sinx), then find \(\frac{d y}{d x}\). (2)

Answer:
1. Let y = x^sinx, take log on both sides,
log y = sinx logx differentiate w. r.t.x, we get

2.

3. Given, y = sin^-1(cosx) + cos^-1(sinx)

Differentiate w.r.t. x, we get \(\frac{d y}{d x}\) = -2.

Question 3.

1. Differentiate \(\frac{x-1}{x-3}\) with respect to x.(2)
2. Differentiate \(\sqrt{\frac{(x-1)(x-2)}{(x-3)(x-4)(x-5)}}\) with respect to x. (4)

Answer:
1. Let y = \(\frac{x-1}{x-3}\) Differentiate w.r.t. x, we get;

2. Given, y = \(\sqrt{\frac{(x-1)(x-2)}{(x-3)(x-4)(x-5)}}\)
Take log on both sides;

Differentiate w.r.t. x, we get;

Question 4.
(i) Define |x|
(a) |x| = \(\sqrt{x^{2}}\)
(b) |x| = x
(c) |x| = -x
(d) |x| = x²
(ii) At which point \(\frac{d}{d x}\)|x| does not exist?
Find \(\frac{d}{d x}\) |x|. (2)
(iii) Find \(\frac{d}{d x}\)|x³ – 7x| . Also, find the point at which the derivative exists. (3)
Answer:
(i) (a) |x| = \(\sqrt{x^{2}}\).

(ii) At x = 0, \(\frac{d}{d x}\) |x| does not exist.


Does not exist at
x³ – 7x = 0 ⇒ x(x² – 7) = 0
⇒ x = 0, x² – 7 = 0 ⇒ x = ±\(\sqrt{7}\).

Question 5.
(i) Match the following (4)

(ii) If log (x² + y²) = 2 tan^-1\(\left(\frac{y}{x}\right)\), then, show that \(\frac{d y}{d x}=\frac{x+y}{x-y}\) (2)
Answer:
(i)

(ii) Given, log (x² + y²) = 2 tan^-1\(\left(\frac{y}{x}\right)\).
Differentiate w.r.to x, we get;

Question 6.
If x = a sec³θ and y = a tan³θ

Answer:
(i) Given, x = a sec³θ
Differentiate w.r.to θ, we get;
\(\frac{d x}{d \theta}\) = 3a sec²θ. secθ. tanθ = 3a sec³ θ. tan θ
Given, y = a tan³θ .
Differentiating w.r.to θ, we get
\(\frac{d x}{d \theta}\) = 3a tan² θ. sec²θ.

(iii) We have, \(\frac{d y}{d x}\) = sinθ
Differentiating w.r.to x, we get

(iv) We have,

Question 7.
Consider the function \(f(x)=\left\{\begin{array}{cc}{1-x} & {, \quad x<0} \\{1} & {x=0} \\ {1+x} & {, \quad x>0}\end{array}\right.\)
(i) Compete the following table. (2)

(ii) Draw a rough sketch of f (x). (2)
(iii) What is your inference from the graph about Its continuity. Verify your answer using limits. (2)
Answer:

Since, f (- 2) = 1 – (- 2) = 3, f (-1) = 1 – (-1) = 2,
f(1) = 1 + (1) = 2, f (2) = 1 + (2) = 3.

(ii)

(iii) From the graph we can see that there is no break or jump at x = 0. Therefore continuous.
From the figure we can see that
f(0^–) = 1 f(0⁺) = 1 and f(0) = 1
Hence, f(0^–) = f(0⁺) = f(0) = 1.
Therefore continuous.

Question 8.
Consider the equation \(\sqrt{1-x^{2}}+\sqrt{1-y^{2}}=a(x-y)\)
(i) Simplify the above equation to sin^-1x – sin^-1y = 2cot^-1 a by giving suitable substitution.
(ii) Prove that \(\frac{d y}{d x}=\sqrt{\frac{1-y^{2}}{1-x^{2}}}\)
Answer:

(ii) We have; sin^-1 x – cos^-1y = 2cot^-1a.
Differentiating w.r.t x, we get,

Question 9.
(i) Match the following. (4)

(ii) If y = e^{a cos-1x}, then show that (1 – x²)y₂ – xy₁ – a²y = 0 (2)
Answer:
(i)

(ii) Given, y = e^{a cos-1x} ____(1)
Differentiating w.r.to x,

Again differentiating w. r.to x

⇒ (1 – x²)y₂ – xy₁ = a². e^{a cos-1x}
⇒ (1 – x²)y₂ – xy₁ = a²y
⇒ (1 – x²)y₂ – xy₁ – a²y = 0.

Question 10.
(i) Match the following (3)

Differentiate the following
(ii) y =\(\frac{1}{5 x^{2}+3 x+7}\) (1)
(iii) y = 3cosec⁴(7x) (1)
(iv) y = e^{2log tan 5x} (1)
Answer:
(i)

(iii) Given,

(iv) Given,

Students can Download Chapter 1 The Solid State Questions and Answers, Plus Two Chemistry Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Chemistry Chapter Wise Questions and Answers Chapter 1 The Solid State

Plus Two Chemistry The Solid State One Mark Questions and Answers

Question 1.
The 14 possible three dimensional crystal lattices are called ____________.
Answer:
Bravais Lattices

Question 2.
Which of the following type of cubic lattices has maximum number of atoms per unit cell?
(a) simple cubic
(b) body centred cubic
(c) face centred cubic
(d) all have same
Answer:
(c) face centred cubic (4 atoms per unit cell)

Question 3.
F- centres in an ionic crystal are
(a) lattice sites containing electrones
(b) interstitial sites containing electrons
(c) lattice cites that are vacant
(d) interstitial sites containing electrones
Answer:
(a) lattice sites containing electrons

Question 4.
The colour imparted by excess potassium in KCl crystal is ________.
Answer:
Violet (or lilac)

Question 5.
Which of the following substances show anti-ferromagnetism?
(a) ZrO₂
(b) CdO
(c) CrO₂
(d) Mn₂O₃
Answer:
(d) Mn₂O₃

Question 6.
The number of tetrahedral and octahedral voids in a ccp array of 100 atoms are respectively.
Answer:
200 and 100

Question 7.
Potassium dichromate belongs to which crystal system.
Answer:
Triclinic

Question 8.
A solid compound contains XYZ atoms in a cubic lattice with X atoms occupying the corners, Y atoms in the body centred positions and Z atoms at the centres of faces of the unit cell. What is the empirical formula of the compound Answer:
XYZ₃

Question 9.
The empty space in body centred cubic lattice is
Answer:
32%

Question 10.
Which solid has the weakest intermolecular force
Answer:
ice

Question 11.
In crystalline solid, atoms, ions or molecules are held in an orderly array. But some point defect is observed in a crystal, when a vacancy is created by an atom or ion dislocated from its normal position to an interstitial site. What is the defect called?
Answer:
Frenkel defect

Plus Two Chemistry The Solid State Two Mark Questions and Answers

Question 1.

1. Write the names of A and B?
2. Identify and write the name of the shaded parts of A and B?

Answer:
1. Names of A and B are:

• Hexagonal close packing.
• Square close packing,

2. shaded parts of A and B are:

• Is octahedral void; in
• Is tetrahedral void.

Question 2.
Teacher said that Frenkel defect will not happen in alkali metal halides. Ramu asked the reason for this. Can you explain?
Answer:
Frenkel defect is favoured by the small size of cations. In alkali metal halides both cations and anions are of almost same size.

Question 3.
“Dielectric substances are related to conductors.”
“Dielectric substances do not conduct electricity at normal condition”
These are two arguments of a class discussion.

1. Do you agree with these arguments?
2. If yes, justify both statements?

Answer:

1. Yes.
2. Dielectric substances do not conduct electricity through them. But they can be made conductors either by heating the substances or by applying mechanical stress.

Question 4.

1. Identify A and B.
2. Explain them.

Answer:
1. A and B.

• A – Square close packed (scp) arrangement in two dimensions.
• B- Hexagonal close packed (hep) arrangement in two dimensions.

2. Explanation:

(a) A – Square close packed:
(scp) arrangement in two dimensions – particles of the second row are arranged just below the first row. Similarly, particles of third row are arranged just below the particles of the second row and so on. Here vertical as well as horizontal alignment is possible. In this arrangement each particle is in direct contact with four other particles and the coordination number is 4.

(b) B- Hexagonal close packed:
(hep) arrangement in two dimensions – In this arrangement, particles of second row are arranged in the depressions of the particles of the first row. Similarly the particles of the third row are arranged in the depressions of the particles of the second row. In this arrangement, each particle is in direct contact with six other particles and the coordination number is 6.

Question 5.

1. Name the unit of magnetic moment.
2. Match the following.
   • Paramagnetic – Fe₃O₄
   • Ferromagnetic – O₂
   • Antiferromagnetic – CrO₂
   • Ferrimagnetic – MnO

Answer:

1. Bohr magneton (μ_B)
2. Match
   • Paramagnetic – O₂
   • Ferromagnetic – CrO₂
   • Antiferromagnetic – MnO
   • Ferrimagnetic – Fe_3O4

Question 6.
All crystals exhibit imperfections.

1. Which law is related to this statement?
2. Draw the picture showing Frenkel defect.

Answer:
1. Third law of thermodynamics.

2.

Question 7.
What do you mean by Anisotropy how is it differ from isotropy
Answer:

Anisotropic	Isotropic
Physical properties have different values along different directions	Physical property would be same in any direction
Because they have different arrangement in different directions	Because arrangement is irregular in any direction

Question 8.
A cubic solid is made of two elements P and Q. Atoms of Q are at the corners of the cube and P at the body-centre. What is the formula of the compound? What are the coordination numbers of P and Q?
Answer:
The atom at the corner makes \(\frac{1}{8}\) contribution while atom at body centre makes 1 contribution to the unit cell.
No. of atoms of Q per unit cell = 8 × \(\frac{1}{8}\) = 1
No. of atoms of P per unit cell = 1 × 1 = 1 Therefore, formula of the compound is PQ.
The atom at the body centre would be in contact with all the atoms at the corners. Hence, the coordination number of P is 8.
Similarly, coordination number of Q is 8 because it is shared by 8 other atoms.

Question 9.
Packing efficiency differ for B.C.C, F.C.C and Simple cube what is packing efficiency?
Answer:
Packing efficiency is the % of total space filled by the particle.

OR

Packing efficiency = \(\frac{\text { Volume occupied by spheres in the unit cell }}{\text { Total volume of the unit cell }} \times 100[/latex ]

Question 10.
If NaCl is doped with 10^-3 mol % of SrCl₂, what is the concentration of cation vacancies?
Answer:
Every Sr²⁺ ion causes one cation vacancy (because two Na⁺ ions are replaced by one Sr²⁺ and it occupies the site of one Na⁺ ion and the other site remains vacant.) Therefore, introduction of 10^-3 moles of SrCl₂ per 100 moles of NaCl would introduce 10^-3 moles cation vacancies in 100 moles of NaCl.
No. of vacancies per mole of NaCl = [latex]\frac{10^{-3}}{100}\) × 6.02 × 10²³ = 6.02 × 10¹⁸

Question 11.
Even crystal, the substance which we consider as the most perfect solid, shows some defects or imperfections.

1. Which law in thermodynamics deals with this topic?
2. Explain the law.

Answer:

1. Third law of thermodynamics
2. Entropy of a perfectly crystalline substance is zero at absolute zero temperature.

Question 12.
Excess of Li makes LiCl crystal pink and excess of K makes KCl crystals lilac. Is this true? How will you account for the above processes?
Answer:
Yes. This is an example for metal excess defect due to anion vacancies. The colour is due to the presence of F – centre in the crystals.

Question 13.
What are the consequences of Schottky and Frenkel defects?
Answer:
Frenkel defect does not change the density of the crystal but Schottky defect decreases the density of the substance.

Question 14.
Calculate the number of atoms per unit cell of silver which crystallizes in fee lattice.
Answer:

• Contribution of particles from one corner = 1/8
• Contribution from 8 corners = 1/8 × 8 = 1
• Contribution from 6 face centres = 1/2 × 6 = 3
• Total number of particles present in the unit cell of the crystal = 1 + 3 = 4
• Number of atoms present in one unit cell of Ag = 4.

Question 15.
Explain the type of voids found in three-dimensional close packing in crystals.
Answer:
Two voids

Plus Two Chemistry The Solid State Three Mark Questions and Answers

Question 1.
In an answer paper a student wrote as “carborundum crystals are very soft.”

1. Do you agree with this?
2. What is your opinion?
3. In which crystal type carborundum is included?
4. Substantiate your view.

Answer:

1. No.
2. Carborundum crystals are very hard.
3. Covalent crystal.
4. In the case of covalent crystals the constituent particles are atoms and they are held together by strong covalent bond network. In carborundum covalent bond network is constituted by Si and C atom which are held very strongly at their positions. Hence, carborundum is a covalent crystal and is very hard.

Question 2.
During a seminar a student asked another student, “Can NaCl give flame test?”

1. Write your answer.
2. Write the colour of sodium during flame test.
3. Write the name of the point which is responsible for the colour of alkali metal halides having excess metal ions.

Answer:

1. Yes
2. Golden yellow
3. F-centre electron trapped anion vaccancy

Question 3.
Solids are classified into two types.

1. What are they?
2. Give two examples.
3. Give 3 features of them.

Answer:
1. Crystalline and amorphous.

2. Crystalline – NaCl, KCl. Amorphous-Plastic, rubber.

3.

Crystalline Solids	Amorphous Solids
1. Sharp melting point	1. Melting point is in a range of temperature
2. Long range order	2. Short range order
3. Anisotropic	3. Isotropic
4. Definite shape	4. Irregular shape

Question 4.
Teacher explained that due to a stoichiometric defect, the density of a crystal changes.

1. Name the defect.
2. What change can we observe?
3. Give an example.

Answer:

1. Schottky defect
2. Density decrease
3. NaCl

Question 5.
1. Packing efficiency is the percentage of total space filled by the particles. Which of the following lattices has the highest packing efficiency? Simple cubic lattice, body centered cubic lattice, hexagonal close packed lattice.

2. An element has a body centred cubic structure with a cell edge of 288 pm. The density of the element is 7.2 g/cm³. How many atoms are present in 208 g of the element?
Answer:
1. Hexagonal close packed lattice.

2. a = 288 pm = 288 × 10^-10 cm
Volume of the unit cell = (288 × 10^-10cm)³
= 23.9 × 10^-24cm³
Volume of 208 g of the element
\(\frac{208 \mathrm{g}}{7.2 \mathrm{g} \mathrm{cm}^{-3}}\) = 28.88 cm³
∴ Number of units cells in 208 g =
\(\frac{28.88 \mathrm{cm}^{3}}{23.9 \times 10^{-24} \mathrm{cm}^{3}}\) = 1.208 × 10²⁴
For bcc structure, number of atoms in one unit cell = 2
∴ Number of atoms in 208 g = 2 × 1.208 × 10²⁴
= 2.416 × 10²⁴

Question 6.
Derive packing efficiency of

1. ccp and hep structure
2. Body centered cubic
3. Simple cubic

Answer:
1. Packing Efficiency in ccp and hep Structures:
In the case of ccp and hep, the edge length

We know that each unit cell in ccp structure has 4 spheres.
Volume of sphere = \(\frac{4 \pi r^{3}}{3}\)
Volume of the cube = a³

2. Packing Efficiency of Body Centred Cubic Structures:
In this case radius of a sphere.

We know that bcc has 2 spheres in the unit cell.
∴ Packing efficiency = \(\frac{2 \times \frac{4}{3} \pi r^{3}}{\left[\left(\frac{4}{\sqrt{3}} r\right)\right]^{3}}\) × 100% = 68%

3. Packing Efficiency is Simple Cubic Lattice:
In simple cubic lattice edge length ‘a’ and radius of the sphere ‘r’ are related as,

We know that a simple cubic unit cell contains only one sphere.
∴ Packing efficiency = \(\frac{1 \times \frac{4}{3} \pi r^{3}}{(2 r)^{3}}\) × 100%
= 52.36%
= 52.4%

Question 7.
Iron (II) oxide crystallise in cubic structure with unit cell edge of 5.0 Å If the density of the oxide is 3.8 g cm^-3. Calculate the no.of Fe²⁺ and O^2- present in each unit cell, [atomic mass of Fe = 56, O = 16] (3)
Answer:
Cell edge a = 5.0Å = 5.0 × 10^-1 m = 5 × 10^-8 cm
Density = 3.8 g/cm³ Molecular mass of FeO = 56 + 16 = 72 u
N_A = 6.022 × 10²³
d = \(\frac{Z M}{N_{A} a^{3}}\)
Z = \(\frac{d N_{A} a^{3}}{M}=\frac{3.8 \times 6.022 \times 10^{23}}{72} \times\left(5 \times 10^{-8}\right)^{3}\)
= 3.97 = 4
Each cell contain 4 FeO molecule every FeO molecule contain one Fe²⁺ and one O^2- ion. So no. of Fe²⁺ ion =4 no.of O^2- ion = 4

Question 8.
Which are the two types of close packing in two dimension. What are its differences?
Answer:
1. Square close packing or AAA type.

• Coordination no.4. One sphere is in touch with 4 other spheres
• 2^nd raw placed exactly under the first raw

2. Hexagonal close packing or AB AB Type.

• Coordination no.6 ie. one spheres is in touch with other six spheres.
• 2^nd raw is placed in the depressions of first raw.

Question 9.
Classify the following solids as ionic, metallic, molecular, network (covalent) or amorphous.

• Tetraphosphorus decoxide (P₄O₁₀)
• Ammonium phosphate (NH₄PO₄)
• SiC
• I₂
• P₄
• Plastic
• Graphite
• Brass
• Rb
• LiBr
• Si

Answer:

• Tetraphosphorus decoxide (P₄O₁₀) – Molecularsolid
• Ammonium phosphate (NH₄PO₄) – Ionic solid
• SiC – Network(covalent) solid
• I₂ – Molecular solid
• P₄ – Molecular solid
• Plastic-Amorphous solid
• Graphite – Network(covalent) solid
• Brass – Metallic solid
• Rb- Metallic solid
• LiBr – Ionic solid
• Si – Network(covalent) solid

Question 10.
A substance A’ crystallizes in fee lattice.

1. Calculate the number of atoms present per unit cell of ‘A’.
2. In a crystalline solid AB, some vacancy is produced by missing of equal number of oppositely charged ions. What is the defect called?

Answer:

1. The number of atoms present per unit cell of ‘A’.
   • Contribution from 8 corners = 1/8 × 8 = 1
   • Contribution from centres of 6 faces = 1/2 × 6 = 3
   • Total number of atoms of A’ per unit cell = 1 +3 = 4
2. Schottky defect

Question 11.

1. What is meant by the term coordination number?
2. What is the coordination number of atoms:
   • In a cubic close-packed lattice?
   • In a body-centred cubic structure?

Answer:

1. The number of nearest neighbours in a packing is called coordination number.
2. The coordination number of atoms
   • In cubic-close packed structure each atom is in direct contact with 12 other atoms. Hence, its coordination number is 12.
   • In a body centred cubic structure coordination number is 8

Question 12.
Identify the crystal.

1. Write the name of the crystal.
2. How many particles are present the unit cell of this crystal?
3. Write the relation connecting edge length and radius of the particle.

Answer:

1. Face centred cubic crystal.
2. Particles are present the unit cell of this crystal.
   • Contribution from 8 corners = 1/8 × 8 = 1
   • Contribution from 6 face centers = 1/2 × 6 = 3
   • The total number of particles = 4
3. r = \(\frac{\sqrt{2} a}{4}=\frac{a}{2 \sqrt{2}}\).

Question 13.
1. The following diagram shows the alignment of magnetic moments for some magnetic properties.

• ↑↑↑↑↑↑
• ↑↓↑↓↑↓
• ↑↑↓↑↑↓

Identify the magnetic properties denoted by (a), (b), (c).

2. Examine the substances H₂O, NaCl, C₆H₆ and name the magnetic property common to them.
Answer:
1. The alignment of magnetic moments for some magnetic properties.

• Ferromagnetic
• Antiferromagnetic
• Ferrimagnetic

2. Diamagnetism

Question 14.
How many lattice points are there in one unit cell of the following lattices?

1. Face centred cubic
2. Body centred cubic
3. Simple cubic

Answer:

1. Face centred cubic – 4
2. Body centred cubic – 2
3. Simple cubic – 1

Plus Two Chemistry The Solid State Four Mark Questions and Answers

Question 1.

• Classify the following into crystalline and amorphous solids.
  1. NaCl
  2. Graphite
  3. Plastic
  4. Diamond
  5. Rubber
  6. KCl
  7. Wood
  8. CaCO₃
  9. Iodine
• Write any two properties of graphite.

Answer:

Crystalline solids	Amorphous solids
NaCl, Graphite	Plastic
Diamond, CsCl	Rubber
CaCO3, Iodine	Wood

• Two properties of graphite
  1. It is a good conductor of electricity.
  2. Graphite is a good solid lubricant.

Question 2.
Fill in the blanks.

Answer:

Question 3.

1. NaCl shows mainly Schottky defect and AgCl shows Frenkel defect. Do you agree with this statement? Justify.
2. Classify the following solids into isotropic and anisotropic.
   Polyvinylchloride, Rubber, Glucose, Glass

Answer:

1. Yes. In NaCl, both Na⁺ and Cl^– are of almost same size and hence it shows Schottky defect. But in AgCl, Ag+ is smaller than Cf. Hence, it shows Frenkel defect.
2. Anisotropic-Glucose
   Isotropic – Glass, Rubber, Polyvinylchloride

Question 4.
The common salt, sodium chloride is an example for a crystal system with edge length a = b = c and axial angles α = β = γ = 90°.

1. Identify the crystal system.
2. What happens when sodium chloride crystal is heated in presence of sodium?

Answer:

1. Cubic crystal
2. Gives yellow colour to the crystal due to F centre, ie. electron trapped anion vaccancy. It is a metal excess defect.

Question 5.
Stoichiometric defects are of two types such as vacancy defects and interstitial defects.

1. Which defect is basically a vacancy defect in ionic solids?
2. Which stoichiometric defect causes the decrease in density of solid?
3. On heating white ZnO it turns yellow. Which is the crystal involved here? Explain.

Answer:

1. Schottky defect
2. Schottky defect
3. It is due to metal excess defect caused by the presence of extra cations at interstitial sites. ZnO is white in colour at room temperature. On heating it loses oxygen and turns yellow.

The excess Zn²⁺ ions move to interstitial sites and the electrons to neighbouring interstitial sites. The yellow colour of non-stoichiometric ZnO (Zn_1+xO) is due to these trapped electrons.

Question 6.

1. Why is Frenkel defect not found in alkali metal halides?
2. A crystalline solid has simple cubic structure in which P atoms are present at the corners, Q atoms are present at the edge centres and R atoms are present at the centre of the unit cell. What is the formula of the compound?

Answer:
1. Frenkel defect is favoured by the small size of cations. In alkali metal halides both cations and anions are of almost same size.

2. Number of atoms of P = \(\frac{1}{8}\) × 8 = 1
Number of atoms of Q = \(\frac{1}{4}\) × 12 = 3 4
Number of atoms of R = 1
∴ Formula of the compound is PQ₃R

Question 7.

1. Classify each of the following solids as ionic, metallic, molecular, network or amorphous.
   • I₂
   • Plastic
   • LiBr
   • SiC
2. In terms of band theory differentiate Conductors, insulators & semi conductors

Answer:

1. Classification of solids as ionic, metallic, molecular, network or amorphous.
   • I₂ – Molecular
   • Plastic – Amorphous
   • LiBr – Ionic
   • SiC – Covalent
2. Differences between Conductors, insulators & semi conductors.
   • Conductors:
     The valence band overlaps with the conduction band or no energy gap exists between them.
   • Insulators:
     The energy gap between valance band and conduction band is very large. Hence electrons from valence band cannot move into the conduction band. Semi conductors have small energy gap between valence band and conduction band.

Question 8.
On the basis of nature of constituent particles crystals are classified into four types.

1. Which are they?
2. In which type does diamond belongs to? Why?
3. Can you say whether Iodine can be written as an example of ionic crystal? Why?

Answer:

1. Ionic crystals, Molecular crystals, Covalent crystals and Metallic crystals.
2. Diamond belongs to covalent crystals, because in diamond, the constituent particles are carbon atoms connected by strong covalent bonds.
3. No. In ionic crystal the constituent particles are ions. Since the constituent particles of iodine are molecules, it is a molecular crystal.

Question 9.

1. Distinguish between A and B?
2. Explain the defect in figure B.
3. Give two examples of crystals showing this defect.

Answer:

1. Fig. A – Ideal crystal. Fig. B – Frenkel defect.
2. Frenkel defect is due to the migration of cation from its original position to the void. This type of defect is favoured by the small size of cation. As a result of this defect, the neutrality, density and stoichiometry remain the same. But the conductivity increases.
3. AgCl, AgBr

Question 10.
The teacher explained crystal defects in classroom.

1. What are the different types of crystal defects?
2. Explain with the help of diagram the important difference between Schottky and Frenkel defects?

Answer:
1. Stoichiometric defects and Non-Stoichiometric defects.

2.

Question 11.
NaCl is an example for diamagnetic substance.

1. Write an example for paramagnetic substance.
2. What is the difference between ferromagnetic and anti ferromagnetic substances?
3. In case of ferri magnetic substances net magnetic moment is not zero. Justify.

Answer:
1. CuO
2. & 3.

Question 12.
The diagram of a cubic crystal whose molecular mass = M, edge length = a, density = ρ,  is given below. N is the Avogadro number.

1. From the above given details find the mass of this cube and also the mass of N particles?
2. By equating these two equations, try to find out a suitable equation for the density of this cube.

Answer:
1. Mass of cube = volume × density = a³ ρ ……………. (1)
Mass of N particles = N × Mass of one particle
= N × \(\frac{M}{N_{A}}\) (M = Gram Atomic Mass) …………. (2)

2. The equations (1) & (2) represent the mass of the cube.
i.e., a³p = N × \(\frac{M}{N_{A}}\)
∴ \(\rho=\frac{N \times M}{a^{3} \times N_{A}}\)

Question 13.

1. Classify each of the following as being either a p- type or a n-type semiconductor.
   • Ge dopped with In
   • Si dopped with B
2. A compound is formed by two elements P and Q. The element Q forms ccp and atoms of P occupy 1/3^rd of the tetrahedral voids. What is the formula of the compound?

Answer:
1. Either a p- type or a n-type semiconductor

• Ge dopped with In → p-type
• Si dopped with B → p-type

2. The formula of the compound
Q = 4
No. of tetrahedral voids = 2N = 2 × 4 = 8
P = 1/3 × 8 = 8/3
Q_8/3P₄ = Q₈P₁₂ = Q₂P₃

Plus Two Chemistry The Solid State NCERT Questions and Answers

Question 1.
Classify the following solids as ionic, metallic, molecular, network (covalent) or amorphous.

• Tetraphosphorus decoxide (P₄O₁₀)
• Ammonium phosphate (NH₄PO₄)
• SiC
• I₂
• P₄
• Plastic
• Graphite
• Brass
• Rb
• LiBr
• Si

Answer:

• Tetraphosphorus decoxide (P₄O₁₀) – Molecularsolid
• Ammonium phosphate (NH₄PO₄) – Ionic solid
• SiC – Network(covalent) solid
• I₂ – Molecular solid
• P₄ – Molecular solid
• Plastic-Amorphous solid
• Graphite – Network(covalent) solid
• Brass – Metallic solid
• Rb- Metallic solid
• LiBr – Ionic solid
• Si – Network(covalent) solid

Question 2.

1. What is meant by the term coordination number?
2. What is the coordination number of atoms:
   • In a cubic close-packed lattice?
   • In a body-centred cubic structure?

Answer:

1. The number of nearest neighbours in a packing is called coordination number.
2. The coordination number of atoms
   • In cubic-close packed structure each atom is in direct contact with 12 other atoms. Hence, its coordination number is 12.
   • In a body centred cubic structure coordination number is 8

Question 3.
How many lattice points are there in one unit cell of each of the following lattice?

1. Face-centred cubic
2. End-centred monoclinic
3. Body-centred

Answer:
1. A face-centred cubic unit cell has lattice points at the corners of the cube and at face centres. There are eight comers and six faces of the cube. Each atom at corner makes a contribution of \(\frac{1}{8}\) while each atom at face centre makes a contribution of \(\frac{1}{2}\) to the unit cell.

Therefore, the number of atoms per unit cell
= 8 × \(\frac{1}{8}\) + 6 × \(\frac{1}{2}\) = 1 + 3 = 4

2. A end-centred monoclinic unit cell has lattice points at the face centres of only one set (two) of faces, in addition to the lattice points at the comers of the unit cell.

Therefore, the number of atoms per unit cell =
8 × \(\frac{1}{8}\) + 2 × \(\frac{1}{2}\) = 1 + 1 = 2

3. A body centred cubic unit cell has lattice points at the comers of the cube and at the body centre.

Therefore, the number of atoms per unit cell
= 8 × \(\frac{1}{8}\) + 1 × 1 = 1 + 1 = 2

Question 4.
A cubic solid is made of two elements P and Q. Atoms of Q are at the corners of the cube and P at the body-centre. What is the formula of the compound? What are the coordination numbers of P and Q?
Answer:
The atom at the corner makes \(\frac{1}{8}\) contribution while atom at body centre makes 1 contribution to the unit cell.
No. of atoms of Q per unit cell = 8 × \(\frac{1}{8}\) = 1
No. of atoms of P per unit cell = 1 × 1 = 1 Therefore, formula of the compound is PQ.
The atom at the body centre would be in contact with all the atoms at the corners. Hence, the coordination number of P is 8.
Similarly, the coordination number of Q is 8 because it is shared by 8 other atoms.

Question 5.
If NaCl is doped with 10^-3 mol % of SrCl₂, what is the concentration of cation vacancies?
Answer:
Every Sr²⁺ ion causes one cation vacancy (because two Na⁺ ions are replaced by one Sr²⁺ and it occupies the site of one Na⁺ ion and the other site remains vacant.) Therefore, introduction of 10^-3 moles of SrCl₂ per 100 moles of NaCl would introduce 10^-3 moles cation vacancies in 100 moles of NaCl.
No. of vacancies per mole of NaCl = \(\frac{10^{-3}}{100}\) × 6.02 × 10²³ = 6.02 × 10¹⁸

Students can Download Chapter 7 Web Hosting Questions and Answers, Plus Two Computer Science Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations

Kerala Plus Two Computer Science Chapter Wise Questions and Answers Chapter 7 Web Hosting

Plus Two Computer Science Web Hosting One Mark Questions and Answers

Question 1.
The companies that provide web hosting services are called ______.
Answer:
Web Hosts

Question 2.
The service of providing storage space in a web server to make a website available on Internet is called
Answer:
web hosting

Question 3.
Which of the following is true in the case of dedicated hosting?
(a) It shares server with other websites.
(b) It is usually inexpensive.
(c) It does not guarantee performance.
(d) It offers freedom for the clients to choose the hardware and the software.
Answer:
(d) only

Question 4.
Choose the odd one out, and justify your answer.
(a) Shared hosting
(b) Dedicated hosting
(c) DNS
(d) Virtual Private Server
Answer:
(c) DNS others are types of web hosting.

Question 5.
______ is the service of providing storage space in a Webserver.

OR

Storing the web pages of a website in a server is popularly known as _____.
Answer:
Web hosting

Question 6.
The companies that provide web hosting services are called _______.
Answer:
Web hosts

Question 7.
Odd one out.
(a) Shared
(b) Dedicated
(c) VPS
(d) DNS
Answer:
(d) DNS means Domain Name System. The others are types of web hosting

Question 8.
VPS stands for _____ .
Answer:
Virtual Private Server.

Question 9.
From the following select the most commonly used web hosting.
(a) Shared
(b) Dedicated
(c) VPS
(d) DNS
Answer:
(a) Shared hosting

Question 10.
DNS stands for ____.
Answer:
Domain Name System

Question 11.
‘A record’ means ______ .
Answer:
Address record

Question 12.
FTP stands for _____ .
Answer:
File Transfer Protocol.

Question 13.
Odd one out.
(a) Mozilla Firefox
(b) FileZilla
(c) CuteFTP
(d) SmartFTP
Answer:
(a) Mozilla Firefox, it is a web browser, the others are popular FTP client software

Question 14.
______ hosting provides web hosting services free of charge.
Answer:
Free hosting

Question 15.
Give an example for Free web hosting services with sub-domain website address.
Answer:
www.bvmhsskalparamba.facebook.com

Question 16.
Give an example for Free web hosting services with directory service website address.
Answer:
www.facebook.com/bvmhsSkalparamba

Question 17.
CMS stands for ____.
Answer:
Content Management System

Question 18.
The term ‘responsive web designing’ was introduced by _____.
Answer:
Ethan Marcotte

Question 19.
The method of Flexible designing of web pages to suit the various types of screens is called _____.
Answer:
Responsive web design method

Question 20.
In dedicated hosting, if the client is allowed to place his own purchased web server in the service provider’s facility, then it is called _______.
Answer:
Co-location

Question 21.
What are the information contained in a ICANN database?
Answer:
Registered domain names/name, address, telephone number and e-mail address of the registrants.

Question 22.
What is‘A record’?
Answer:
‘A record’ is used to store the IP address and the corresponding domain name

Question 23.
Joomla is an example for ______ .
(a) CMS
(b) ISP
(c) DNS
(d) None of the above
Answer:
(a) CMS

Question 24.
The responsive web design feature that converts horizontal menu to a drop-down menu in mobile phones is called ______.
Answer:
Media queries

Question 25.
The organization that maintains the WHOIS database of domain names is ______.
Answer:
ICANN

Plus Two Computer Science Web Hosting Two Mark Questions and Answers

Question 1.
Consider that your school is planning to host a website. What are the factors that you will consider while choosing the type of web hosting?
Answer:
Following factors to be considered

1. Buying sufficient amount of memory space for storing our website files
2. If the web pages contain programming contents supporting technology must be considered
3. Based upon the programs select Windows hosting or Linux hosting

Question 2.
Emmanuel wishes to buy a suitable domain for his company. Unfortunately, the domain name he chose is already registered by someone else. Name the feature that will help him to find the current owner. List the details will he get.
Answer:
WHOIS
Name, address, telephone number and e-mail address of the registrant

Question 3.
What is the use of FTP client software? Give an example.
Answer:
FTP (File Transfer Protocol) client software:
When a client requests a website by entering website address. Then FTP client software helps to establish a connection between client computer and remote server computer. Unauthorised access is denied by using user name and password hence secure our website files for that SSH(Secure Shell) FTP simply SFTP is used.

Instead of http://, it uses ftp://. By using FTP client s/w we can transfer(upload) the files from our computer to the web server by using the ‘drag and drop’ method. The popular FTP client software are FileZilla, CuteFTP, SmartFTP, etc.

Question 4.
Haseena has decided to host her new website using free hosting facility; her friend Rinisha is against this move. Can you guess her argument against the utilization of free hosting facility?
Answer:
In free web hosting service, the expense is meet by the advertisements. Some service providers allow limited facilities such as limited storage space, do not allow multimedia (audio and video) files.

Plus Two Computer Science Web Hosting Three Mark Questions and Answers

Question 1.
Priya has developed a website for her shop. She has purchased a domain name and hosting space.

1. Name the software that will help her to transfer her files from her computer to the webserver.
2. List the requirements in that software that are necessary to connect to the webserver.

Answer:

1. FTP software such as FileZilla, Cute FTP, Smart FTP
2. Following are the requirements to connect to the Webserver
   • Domain name /IP address
   • User name.
   • Password

Question 2.
Explain the advantages of using SFTP protocol in FTP client software.
Answer:
Unauthorized access is denied by using username and password hence secure our website files, for this SSH (Secure Shell) FTP simply SFTP is used. It encrypts and sends usernames, passwords, and data to the webserver.

Question 3.
Merin plans to create a website for their family without spending money.

1. List some of the limitations that Merin will face regarding the hosting space for website.
2. How will she provide a domain name for the website?

Answer:
1. In free web hosting service, the expense is meet by the advertisements. Some service providers allow limited facilities such as limited storage space, do not allow multimedia (audio and video) files.

2. Usually, two types of free web hosting services as follows.

• As a directory service: service provider’s website address/ our website address
  eg: www.facebook.com/bvmhsskalparamba
• As a subdomain: Our website address. service providers website address
  eg: www.bvmhsskalparamba.facebook.com

Question 4.
Recently more and more people are using Content Management Systems (CMS) for developing professional websites. What can be the reasons for this?
Answer:
CMS means Content Management System. Do you heard about Data Base Management System (DBMS). DBMS is a software (collection of programs) used to create, alter, modify, delete and retrieve records of a DataBase. Similarly CMS is a collection of programs that is used to create, modify, update and publish website contents.

CMS can be downloaded freely and is useful to design and manage attractive and interactive websites with the help of templates that are available in CMS. WordPress, Joomla, etc. are the examples of CMS.

Question 5.
Suggest a hosting type for the following websites given below. Justify.

1. Website for a medical shop in your city.
2. Website for Public Service Commission (PSC) of Kerala.
3. Website for an online shopping facility.

Answer:

1. Shared hosting
2. Dedicated/VPS
3. Dedicated/VPS

Question 6.
Consider that a college in your locality plans to shift its website from shared type of hosting to VPS hosting. List the advantages that the website will gain from this change.
Answer:
Virtual Private Server (VPS):
A VPS is a virtual machine sold as a service by an Internet hosting Service. A VPS runs its own copy of an OS(Operating System) and customers have super level access to that OS instance, so they can install almost any s/ w that runs on that OS.

This type is suitable for websites that require more features than shared hosting but less features than dedicated hosting.
Eg: It is similar to owning a Condo

Question 7.
Mr. Mohan wants to host a personal website with minimal cost. Which type of web hosting would you advise for him? Justify your answer.
Answer:
Shared Hosting:
This type of hosting sharing re-sources, like memory, disk space, and CPU hence the name shared. Several websites share the same server. This is suitable for small websites that have less traffic and it is not suitable for large websites that have large bandwidth, large storage space and have large volume of traffic.

Eg: Shared hosting is very similar to living in an Apartment(Villas) complex. All residents are in the same location and must share the available resources(Car parking area, Swimming pool, Gymnasium, playground, etc) with everyone.

Question 8.
A supermarket in a city wishes to take its business online. It plans to accept orders for its products through a website and receive payments online.

1. Which type of hosting is suitable for this website?
2. Explain the reason for your choice.

Answer:
1. Dedicated Hosting

2. A web server and its resources are exclusively for one website that have large volume of traffic means large volume of requests by the visitors. Some Govt, departments or large organizations require uninterrupted services for that round the clock power supply is needed. It is too expensive but it is more reliable and provides good service to the public.

Eg: It is similar to living in an Our own house. All the resources in your house is only for you. No one else’s account resides on the computer and would not be capable of tapping into your resourses

Question 9.
Emil wishes to purchase the web hosting space required to host a website for his medical shop. List the features to be taken into consideration while buying hosting space on a web server.
Answer:
Following factors to be considered:

1. Buying sufficient amount of memory space for storing our website files
2. If the web pages contain programming contents supporting technology must be considered
3. Based upon the programs select Windows hosting or Linux hosting

Question 10.
How can we connect a website hosted in a Web server to a domain name?
Answer:
Millions of websites are available over Internet so that our website must be registered with a suitable name. Domain Name registration is used to identify a website over Internet. A domain name must be unique(i.e. no two websites with same name is available).

So you have to check the availability of domain name before you register it, for this www.whois.net website will help. If the domain name entered is available then we can register it by paying the Annual registration fees online. Consider a Post Office, it has two addresses one string address (Irinjalakuda) and one numeric(pin) code (680121).

Just like this the website has also two addresses a string address, for example, www.agker.cag.gov.in and a numeric address (http:/ /210.212.239.70/). We are following string address, hence this domain name has to be connected to the corresponding IP address of the webserver. This is done by using ‘A record’(Address record) of the domain. ‘A record’ is used to store the IP address and the corresponding domain name.

Question 11.
What is the advantage of using SFTP protocol in FTP software?
Answer:
FTP(File Transfer Protocol) client software:
When a client requests a website by entering website address. Then FTP client software helps to establish a connection between client computer and remote server computer. Unauthorised access is denied by using username and password hence secure our website files for that SSH(Secure Shell) FTP simply SFTP is used.

Instead of http://, it uses ftp://. By using FTP client s/w we can transfer(upload) the files from our computer to the web server by using the ‘drag and drop’ method. The popular FTP client software are FileZilla, CuteFTP, SmartFTP, etc.

Question 12.
Raju wishes to host a website for his family. What are the advantages that free web hosting companies provide?
Answer:
The name implies it is free of cost service and the expense is meet by the advertisements. Some service providers allow limited facilities such as limited storage space, do not allow multimedia(audio and video) files. A paid service website’s address is as follows:
Eg: www.bvmhsskalparamba.com

Usually two types of free web hosting services as follows:
1. As a directory service:
Service provider’s website address/ our website address.
eg: www.facebook.com / bvm hss kalparambu.

2. As a Sub domain:
Our website address.service providers website address.
eg: www.bvmhsskalparamba.facebook.com Earlier web hosting services are expensive but nowadays it is cheaper hence reduced the need for free web hosting.

Question 13.
What is CMS? What are the features of CMS? Give Examples.
Answer:
CMS means Content Management System. Do you heard about Data Base Management System (DBMS)? DBMS is a software(collection of programs) used to create, alter, modify, delete and retrieve records of a DataBase. Similarly, CMS is a collection of programs that is used to create, modify, update and publish website contents.

CMS can be downloaded freely and is useful to design and manage attractive and interactive websites with the help of templates that are available in CMS. WordPress, Joomla, etc. are examples of CMS.

Plus Two Computer Science Web Hosting Five Mark Questions and Answers

Question 1.
Explain different types of web hosting?
Answer:
Types of web hosting:
Various types of web hosting services are available. We can choose the web hosting services according to our needs depends upon the storage space needed for hosting, the number of visitors expected to visit, etc.

1. Shared Hosting:
This type of hosting sharing resources, like memory, disk space, and CPU hence the name shared. Several websites share the same server. This is suitable for small websites that have less traffic and it is not suitable for large websites that have large bandwidth, large storage space and have large volume of traffic.

Eg: Shared hosting is very similar to living in an Apartment(Villas) complex. All residents are in the same location and must share the available resources(Car parking area, Swimming pool, Gymnasium, playground, etc) with everyone.

2. Dedicated Hosting:
A web server and its resources are exclusively for one website that have large volume of traffic means large volume of requests by the visitors. Some Govt, departments or large organizations require uninterrupted services for that round the clock power supply is needed. It is too expensive but it is more reliable and provides good service to the public.

Eg: It is similar to living in an Our own house. All the resources in your house is only for you. No one else’s account resides on the computer and would not be capable, of tapping into your resources.

3. Virtual Private Server (VPS):
A VPS is a virtual machine sold as a service by an Internet hosting Service. A VPS runs its own copy of an OS (Operating System) and customers have super level access to that OS instance, so they can install almost any s/what runs on that OS. This type is suitable for websites that require more features than shared hosting but less features than dedicated hosting.
Eg: It is similar to owning a Condo

Question 2.

1. What is responsive web design?
2. Why is it gaining importance recently?

Answer:
1. The home page is displayed differently according to the screen size of the browser window (different screen sized devices mobile phone, palmtop, tablet, laptop, and desktop) we used. The website is designed dynamically (flexibly) that suit the screen size of different device introduced by Ethan Marcotte.

Before this, companies have to design different websites for different screen sized devices. By responsive web design, companies have to design only one website that suitably displayed according to the screen size of the devices. It is implemented by using flexible grid layout, images, and media queries.

• Flexible grid layouts: It helps to set the size of the web page to fit the screen size of the device.
• Flexible image and video: It helps to set the image or video dimension to fit the screen size of the device.
• Media queries: There is an option (settings) to select the size of the web page to match our device, this can be done by using media queries inside the CSS file.

A well known Malayalam daily Malaysia Manorama launched their responsive website.

2. Instead of using desktops or laptops many people nowadays visit websites using tablets and mobile phones. Portability is the main reason for this.

Question 3.
Today, we visit websites using tablets and mobile phones also. You might have noticed that the same website is displayed in a different layout in different devices.

1. Name the concept used for this.
2. List and explain the technologies used for implementing this concept

Answer:
1. Responsive web design.

2. It is implemented by using flexible grid layout, images, and media queries:

• Flexible grid layouts: It helps to set the size of the web page to fit the screen size of the device.
• Flexible image and video: It helps to set the image or video dimension to fit the screen size of the device.
• Media queries: There is an option (settings) to select the size of the web page to match our device, this can be done by using media queries inside the CSS file.

A well known Malayalam daily Malayala Manorama launched their responsive website.

Question 4.

1. What is responsive web design?
2. How is responsive web design implemented?

Answer:
1. The home page is displayed differently according to the screen size of the browser window (different screen sized devices mobile phone, palm top, tablet, laptop and desktop) we used. The website is designed dynamically (flexibly) that suit the screen size of different device introduced by Ethan Marcotte.

Before this, companies have to design different websites for different screen sized devices. By responsive web design, companies have to design only one website that suitably displayed according to the screen size of the devices.

2. It is implemented by using flexible grid layout, images, and media queries:

• Flexible grid layouts: It helps to set the size of the web page to fit the screen size of the device.
• Flexible image and video: It helps to set the image or video dimension to fit the screen size of the device.
• Media queries: There is an option (settings) to select the size of the web page to match our device, this can be done by using media queries inside the CSS file.

A well known Malayalam daily Malayala Manorama launched their responsive website.

Students can Download Chapter 2 Spread Sheet Questions and Answers, Plus Two Accountancy Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Accountancy Chapter Wise Questions and Answers Chapter 2 Spread Sheet

Plus Two Accountancy Spread Sheet One Mark Questions and Answers

Question 1.
The best way to get started in Libre Office calc is _____
Answer:
Application → Office → LibreOffice Calc

Question 2.
___________ is a configuration of rows and columns
Answer:
Spread sheet

Question 3.
A spread sheet is also known as ____________
(a) Work book
(b) Work area
(c) Work sheet
(d) Spread book
Answer:
(c) Work sheet

Question 4.
____________ in spread sheet are horizontal vectors while ______ are vertical vectors
Answer:
Rows, columns

Question 5.
Spread sheet is used to
(a) Record data
(b) Calculate data
(c) Compare data
(d) All the above
Answer:
(d) All of the above

Question 6.
Each cell value can either be an independent (basic) value or it may be derived on the basis of ____________.
Answer:
Arithmetic expression or a function.

Question 7.
A file in LibreOffice Calc is known as a ______
(a) Work sheet
(b) Page
(c) Work book
(d) All the above
Answer:
(c) Work book

Question 8.
A work book is a collection of a number of ______
Answer:
Work Sheets

Question 9.
Where is the address of the active cell displayed?
(a) Row heading
(b) Status Bar
(c) Name Box
(d) Formula Bar
Answer:
(c) Name Box

Question 10.
Which command reverses the last action performed in the worksheet?
(a) Cut
(b) Undo
(c) Redo
(d) Paste
Answer:
(b) Undo

Question 11.
__________ is a text or special character or descriptive information for rows or columns.
Answer:
Label

Question 12.
A formula must starts with a ___________ sign
(a) =
(b) >
(c) *
(d) {}
Answer:
(a) =

Question 13.
_______ Function is commonly used to get the addition of various numbers orthe contents of various cells.
Answer:
Autosum (Σ)

Question 14.
The cell A5 indicate Column _______ and Row _____
Answer:
Column A & Row 5

Question 15.
The dark box which distinguishes the active cell is called _______
Answer:
Cell Pointer

Question 16.
One or more cells selected is called ______
Answer:
a range

Question 17.
Without the equal sign, the entry in a cell is treated as _________
(a) Text
(b) Label
(c) TextorLabel
(d) None of the above
Answer:
(c) Text or Label

Question 18.
Libre Office calc has three type of cell entries, they are _______ , ______and _______
Answer:
Value, Label and Formula.

Question 19.
Which command allows you to reverse an undo command?
(a) Redo
(b) Repeat
(c) Reset
(d) Reverse
Answer:
(a) Redo

Question 20.
Which cell alignment is assigned to most values by default?
(a) Right
(b) Left
(c) Centre
(d) None of the above
Answer:
(b) Left

Question 21.
Which function automatically totals a column or row of Values?
(a) TOTAL
(b) ADD
(c) SUM
(d) AVG
Answer:
(c) SUM

Question 22.
Which Mathematical Operator is represented by an asterisk (*)
(a) Exponentiation (square)
(b) Addition
(c) Subtraction
(d) Multiplication
Answer:
(d) Multiplication

Question 23.
How many blank work sheets are shown when a new workbook is created?
(a) One
(b) Two
(c) Three
(d) Four
Answer:
(c) Three

Question 24.
The cell co-ordinate in the formula are known as ………….
Answer:
cell references

Question 25.
IF function is …………….
Answer:
Logical function

Question 26.
The cell references for cell range of G2to M12 is …………….
(a) G2.M12
(b) G2: M12
(c) G2; M12
(d) G2 – M12
Answer:
(c) G2: M12

Question 27.
If 4/6 entered in a cell without applying any format, LibreOffice Calc will treat this as
(a) Fraction
(b) Number
(c) Text
(d) Date
Answer:
(d) Date

Question 28.
The cell labelled F5 refers to …………….
(a) Row F column 5
(b) Column F row 5
(c) Function available in cells
(d) Function key F5
Answer:
(b) Column F row 5

Question 29.
LibreOffice Calc is a FOSS. What is FOSS?
Answer:
Free and Open Source Software.

Question 30.
Which among the following is not a spreadsheet software.
(a) MS Office Excel
(b) Open Office Spredsheet
(c) Libre Office Calc
(d) MS Office Word
Answer:
(d) M S Office Word

Question 31.
How many worksheets can be made as active worksheet at a time?
(a) 1
(b) 2
(c) 3
(d) 4
Answer:
(a) 1

Question 32.
The name of the worksheet will be shown in the ______ at the bottom left of the windows.
Answer:
Sheet Tab

Question 33.
To add column in a worksheet, click __________, there we get an option to add column.
Answer:
Column Header

Question 34.
A ………… is identified by a combination of a column header (letter) and a row header (number)
Answer:
cell

Question 35.
_______ is a group of adjacent cells that forms a rectangular area.
Answer:
Range

Question 36.
Which among the following is used as the range operator
(a) ;
(b) :
(c) /
(d) #
Answer:
(b) :

Question 37.
One ENTER key stroke means
(a) One cell down
(b) One cell up
(c) One cell right
(d) One cell left
Answer:
(a) One cell down

Question 38.
………………. Function counts the number of cells which contain any value.
(COUNT, COUNTA, COUNT BLANK, COUNTIF)
Answer:
COUNTA

Plus Two Accountancy Spread Sheet Two Mark Questions and Answers

Question 1.
Match the following

A	B
1. Rows	1. Intersection of a row & a column
2. Columns	2. Numerical numbers from top to bottom
3. Cell	3. Unique identification code of a cell
4. Cell address	4. Alpha characters from left to right

Answer:

A	B
1. Rows	1. Numerical numbers from top to bottom
2. Columns	2. Alpha characters from left to right
3. Cell	3. Intersection of a row & a column
4. Cell address	4. Unique identification code of a cell

Question 2.
What do you mean by spreadsheet?
Answer:
Spreadsheet:
Spreadsheet application is a computer program that allows to record, calculate and compare numerical or financial data. Using a spreadsheet program. We can store a lot of data in the worksheet and also arrange and analyse the data by using different functions and formulae for the meaningful object.

It is used to establish relationship between two or more sets of data. Libre Office Calc, MS Office Excel, Open Office Spreadsheet etc. are examples of spreadsheet software.

Question 3.
Give a short note on

1. Work book
2. Work sheet

Answer:
1. Workbook:
A file in spread sheet is known as a workbook. A work book is a collection of a number of work sheets.

2. Work sheets:
The work area which consists of rows and columns in a spreadsheet is called a worksheet. By default three work sheets-sheet 1, sheet -2, sheet -3 are available in work book.

Question 4.
Explain about rows and columns in Libre Office Calc?
Answer:
1. Rows:
Rows are the horizontal vectors in the worksheet. These are numbered numerically from Top to Bottom.

2. Columns:
Columns are vertical vectors in the worksheet. These are referred by alpha characters from left to right such as A, B, C, …, AA, AB, AC …etc.

Question 5.
What do you mean be Relative cell Reference?
Answer:
1. Relative Cell references:
By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location.

Question 6.
Define the following

1. Label
2. Formula

Answer:
1. Labels:
Descriptive information for rows or columns in the form of a text or a special character is called Label.
Eg: Name, Roll No, Address.

2. Formula:
The formula means a mathematical calculation on a set of cells. The formula must start with an = (equal to) sign. When a cell contains a formula, it often contains reference to other cells. Eg:= Basic pay + DA + HRA

Question 7.
List down any two features fo Spreadsheet.
Answer:

• A spreadsheet is a configuration of rows and columns.
• A spreadsheet is also known as worksheet.

Question 8.
Name the different spreadsheet software available.
Answer:
LibreOffice Calc, MS Office Excel, Open Office Spreadsheet.

Question 9.
Briefly explain any two Date and Time functions availabe in LibreOffice Calc
Answer:
1. TODAY():
It is the function for today’s date in the worksheet. This helps to update the date value when we reopen the spreadsheet or modify the values of the document
Syntax: =TODAY()

2. NOW ():
It is the function for today’s date and present time. This helps to update the date and the time value when the cell value is modified.
Syntax: =NOW()

Question 10.
Give the Syntax for

1. YEAR()
2. DATE()

Answer:
1. YEAR()
Syntax: = YEAR (Date value) OR = YEAR (“Date”)

2. DATE()
Syntax: = DATE (Year, Month, Day)

Question 11.
Complete the table by using ROUNDUP()

Answer:

1. 1880
2. 1900

Question 12.
What are the Text Manipulation Function in LibreOffice Calc
Answer:

• TEXT
• CONCATENATE

Question 13.
Give the explanation of the following errors
Error Message

1. # DIV/o!
2. VALUE!

Answer:

1. # DIV/0! → When a number is divided by zero
2. VALUE! → When a wrong argument is given in a fromula

Question 14.
Spot the correct pairs by observing the nature of software, and give justification
(a) Microsoft Excel and LibreOffice Calc
(b) Linux and Tata Ex.
(c) Windows and MS Office
(d) GINUGhata and Microsoft Access
Answer:
(a) Microsoft Excel and LibreOffice Calc. Both are spread sheet packages.

Plus Two Accountancy Spread Sheet Three Mark Questions and Answers

Question 1.
What are the advantage of Libre Office Calc?
Answer:

1. It is both free software and open source software.
2. It can be used to calculate, analyse and manage data.
3. Libre Office Calc is available for a variety of platforms including Linux, OSX, Microsoft windows and Free BSD.

Question 2.
Give the cell address or range reference in the following situations.

1. Cell at 10^th column and 6^th row.
2. Cell at 27th column and 15^th row.
3. Range starting from 5^th column, 9^throw and spread till 12^th column and 15^th row.

Answer:

1. Cell at 10^th column and 6^th row = J6.
2. Cell at 27^th column and 15^th row = AA15.
3. Range starting from 5^th column, 9^th row and spread till 12^th column and 15^th row = E9: L15.

Question 3.

1. What is FOSS?
2. What are the benefits of using FOSS?

Answer:

1. FOSS means Free and Open Source Software
2. The benefits of using FOSS:
   • Decreased software costs.
   • Increased Security and stability.
   • Any one can use, copy, study and change the software in any manner.
   • Source code is openly shared.

Question 4.
How can we save Libre Office Calc file?
Answer:
Step 1: Go to the File menu
File menu

Step 2: Click on Save
Save

OR

Step 1: & Step 2 – Press Ctrl + S
Ctrl + S

Step 3: Type the file in the name field instead of default name Untitled 1
Name field

Step 4: Choose the place where we want to save the new file.

Step 5: Click on Save

Question 5.
Write the steps to be followed to

1. Rename a worksheet
2. Delete a worksheet
3. Copy a worksheet

Answer:
1. Rename a worksheet:
Step – 1 Select the work sheet in the Sheet Tab which we want to Rename.

Step – 2 Right click and select Rename sheet from the drop up menu

Step – 3 Type new name in the Name field and press OK button

2. Delete a worksheet:
Step – 1 Select the worksheet in the Sheet Tab which we want to delete

Step – 2 Right click and select Delete sheet from the drop up menu

Step – 3 Click on Yes to the conformation question.

3. Copy a worksheet:
Step – 1 Click on blank rectangle Top left corner of the worksheet (Range Adress A1: AM J1048576)

Step – 2 Move the curser inside the worksheet and Right click the mouse.

Step – 3 Click on Copy from the dropdown menu.

Step – 4 Open the worksheet where we want to copy the sheet

Step – 5 Right click on cell A1. Click on Paste.

Question 6.
Give the cell address or range reference in the following situations.

1. Cell of 10th column and 9^th row
2. Range starting from 2^nd column 4^th row and spread till 8^th column 12^th row
3. Range starting from 4^th column 5^th row and spread till 10^thcolumn 15^th row

Answer:

1. J9
2. B4: H12
3. D5: J15

Question 7.
What is the purpose of the COUNTIF function?
Answer:
COUNTIF():
This function counts the number of cells within a given that meet the criteria or condition.
Syntax: = COUNTIF (Range, Criteria)

Question 8.
Write the command to calculate the State Life Insurance Premium (SLI) of an employee using IF Function. The condition is SLI Premium Rs. 500/-below Basic Pay (BP) of Rs. 15000/- and for others Rs. 800/- (BP is given in cell C3)
Answer:
= IF(C3 < 15000, 500, 800)

Question 9.
4 numbers are entered in Libre Office Calc spreadsheet starting from cell A1 to A4. Write any two formulae for getting total of those numbers in the cell A5

Answer:

1. A5 = A1 + A2 + A3 + A4
2. A5 = Σ(A1 : A4)

Question 10.
For preparation of Payslip of an employee, Govind entered Basic Pay in cell B2 of a worksheet in LibreOffice calc. The D.A. is 76% of Basic Pay and Gross Salary is the sum of Basic Pay and DA. In order to calculate the amount of DA in cell C2 and Gross salary in cell D2, what entries are to be made?
Answer:
Basic Pay → B2
DA → C2
Gross salary → D2
C2 = B2 * 76%
D2 = B2 + C2

Question 11.
Consider the following features of a software tool. Identify the software.

1. It can be used as a text editor
2. List out the important uses of this software

Answer:

1. LibreOffice calc has the above mentioned features.
2. Importance of LibreOffice calc.
   • It can be used for the preparation of statement of depreciation.
   • It can be used for preparation of Payroll of employees.
   • It can be used for the preparation of the loan re-payment schedule.

Question 12.
Complete the following.

1. One cell down → arrow key
2. One cell up → …………………………
3. One cell left → …………………………
4. One cell right → ………………………

Answer:

2. Up arrow key
3. Left arrow key
4. Right arrow key

Question 13.
Can you give some key navigations and short cut in LibreOffice calc?
Answer:
Spreadsheet navigation:
We can move around a worksheet through four arrow keys

1. Left-arrow key
2. Right arrow key
3. Up arrow key
4. Down arrow key

The mouse can also be used for navigation in a spreadsheet except for data entry. Some common operations/navigations are listed below:

Movement	Keystroke (Press Key)
One cell up	Up arrow key/ Shift + Enter key
One cell down	Down arrow key/ Enter key
One cell right	Right arrow key/ Tab key
One cell left	Left arrow key / Shift + Tab key
Top of sheet (Cell A1)	Ctrl + Home Key
Move to last cell containing data	Ctrl + End Key
Move to beginning of the Row	Home Key or Ctrl + Left arrow key
Move to last filled cell in column	End key

Question 14.
What commands are used to insert a column and delete a column in LibreOffice Calc?
Answer:
1. To insert a column:
To insert a column click a cell in the column immediately to the right of where you want to insert the new column. Then on the Insert menu, click Columns.

2. To delete a column:
Select the column you want to delete. On the Edit menu, click Delete.

Question 15.
Give the procedure to insert a new worksheet and to delete a worksheet.
Answer:
To insert a new worksheet, right click the worksheet, select ‘insert’. To delete a worksheet, select the sheet you want to delete and ‘click delete sheet’ on the edit menu.

Question 16.
Give the cell address or range reference in the following situations.

1. Cell at 12^th Column and 8^th row.
2. Range starting from 6^th Column 10^th row and spread till 12^th Column and 16^th row.

Answer:

1. L8.
2. F10: L16

Question 17.
Name the appropriate Statistical functions.

1. Number of cells contain numbers.
2. Number of cells contain any value.
3. Number of empty cell.
4. Number of cells that meet the given criteria.

Answer:

1. COUNT
2. COUNTA
3. COUNTBLANK
4. COUNTIF

Question 18.
What is the use of financial function ACCRINT in LibreOffice Calc
Answer:
ACCRINT ():
This function returns the accrued interest for a security that pays periodic interest.
Syntax: = ACCRINT(Issue, First_Interest, settlement, rate, Par, frequency, basis, calc_method)

Question 19.
Explain the difference between relative cell reference and absolute cell reference?
Answer:
1. Relative Cell references:
By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location.

2. Absolute Cell reference:
The absolute cell reference consists of the column letter and row number surrounded by dollar ($) signs. Eg $A$5. An absolute cell reference is used when we want a cell reference to stay fixed on a specific cell.

Question 20.
What is the use of PIVOT TABLE?
Answer:
Preparation of reports using Pivot Tables:
A Pivot Table is a way to present information in a report format. A Pivot Table report provides enhanced layout, attractive and formatted report with improved readability. There are two types of data table.

1. One-Variable Data Table (One – Variable )
2. Two-Variable Data Table (Two-Variable)
   • The one variable Data Table allows us to identify a single decision variable in our model and see how changing the values for that variable affects the values calculated by one or more formulas in our model.
   • The two variable Data table allows us to specify two decision variables and a variety of inputs and only a single formula.

Plus Two Accountancy Spread Sheet Five Mark Questions and Answers

Question 1.
Define the following

1. Cell
2. Range
3. Worksheet
4. Workbook

Answer:
1. Cell:
The intersection of a row and a column is called a cell. A cell is identified by a combination of an alpha – numeric character eg: A1, B6, C10, etc. This alpha numeric character is called cell address. Hence each cell has a unique address.

2. Ranges:
Range is a group of adjacent cells that forms a rectangular area. A range is specified by giving the address for first cell in range and the last cell in the rage, eg: range starting from A10 to A20 is written as A10: A20 where colon (:) is the range operator.

3. Work sheets:
The work area which consists of rows and columns in a spreadsheet is called worksheet. By default three worksheets-sheet 1, sheet -2, sheet -3 are available in work book.

4. Workbook:
A file in spread sheet is known as a workbook. A work book is a collection of a number of work sheets.

Question 2.
What are the different spreadsheet reference functions in Libre Office Calc?
Answer:
Spreadsheet Reference Functions:
The important spreadsheet reference functions are

1. LOOKUP () functions:
The LOOKUP function returns a value either from a one-row or one-column range or from an array. The lookup function has two syntax forms: Vector form and Array form.

The vector form of LOOUP looks in a one-row or one column range (known as a vector) for a value, and then returns a value from the same position in a second one-row or one-column range.

The array form of LOOKUP looks in the first row or column of an array for the specified value, and then returns a value from the same position in the last row or column of the array.

LOOKUP (Vector from)
Syntax: = LOOKUP (search criterion, Search vector, Result vector)
LOOKUP (Array form)
Syntax: =(LOOKUP (lookup_value, array)

2. VLOOK UP ():
VLOOK UP is the vertical LOOKUP function. Use VLOOK UP to search the first column (columns are vertical) of a block of data and return the value from another column in the same row.
Syntax: = VLOOKUP (Search criterion; Array; Index; Sort Order)

3. HLOOKUP ( ):
It is the Horizontal LOOKUP function, searches for a value in the first row of a table array and returns the corresponding value in the same column from another row of the same table array.
Syntax: HLOOKUP (search criteria; index; sorted)

Question 3.
Give the cell address or range reference in the following situations.

1. Cell at 10^th Column and 9^th row.
2. Range starting from 2^nd Column 4^th row and spread till 8^th Column and 12^th row.

Answer:

1. J9.
2. B4: H12

Question 4.
What are the logical functions in LibreOffice Calc
Answer:
Logical Functions:
Logical functions are used for comparison and checking a test condition. The major logical functions are IF, AND and OR.

Question 5.
Explain the steps involved to insert a new work sheet in LibreOffice Calc
Answer:
Steps involved to insert a new work sheet in LibreOffice Calc.
Step 1 – Click on the [+] button in the sheet Tab

OR

Step 1 – Click on the work sheet in the sheet Tab Sheet Tab

Step 2 – Right click the mouse

Step – 3 Select insert sheet from the Drop up menu box
Drop up

Step 4- Add number of sheets and give name, press
OK

Question 6.
You are required to prepare a rank list for admission to the B.Com course. The Index mark is calculated as follows.
Sum of mark secured in Plus 2, Mark obtained in Accountancy and -25% of Mark obtained in Business studies. Give the entries in Libre Office Calc to get the index mark.
Answer:

• A1 → Total Mark
• B1 → Mark in Accountancy
• C1 → Mark in Business Studies
• D1 → Index Mark
• A2 → Enter the Marks
• B2 → Enter the Marks
• C2 → Enter the Marks
• D2 → =A2 + B2 + (C2 * 25%)

Question 7.
Match the following:

A	B
1. One cell to the left	1. Right arrow key
2. To cell A1	2. Ctrl + End
3. One cell to the right	3. Ctrl + Home
4. To the last cell in the worksheet that contains data	4. Shift + Tab

Answer:

A	B
1. One cell to the left	1. Shift + Tab
2. To cell A1	2. Ctrl + Home
3. One cell to the right	3. Right arrow key
4. To the last cell in the work sheet that contains data	4. Ctrl + End

Question 8.
The monthly sales of a company for the first six months are given below:

A	B
1. January	25000
2. February	15000
3. March	28000
4. April	32000
5. May	20000
6. June	30000

7. Find the total sales for the six months
8. Find the average sales of the six months
9. Find the lowest sales of the six months
10. Find the highest sales of the six months

Answer:

A	B
7. Total sales	= SUM (B1:B6)
8. Average sales	= Average (B1:B6)
9. Lowest sales	= MIN (B1:B6)
10. Highest sales	= MAX(B1:B6)

Question 9.
Give the range reference in the following cases.

1. Range beginning from 1^st column, 1^st row and ending 16^th column, 8^th row
2. Range beginning from 5^th column, 7^th Row and ending 27^th column, 37^th row

Answer:

1. A1: P8
2. E7: AA37

Question 10.
Match the following:

A	B
a) Today	a) Today’s date & Time
b) Now	b) Convert date into corresponding value
c) Day	c) Today’s date
d) Date value	d) Day of the data referred in the formula

Answer:

A	B
a) Today	a) Today’s date
b) Now	b) Today’s date & time
c) Day	c) Day of the date referred in the formula
d) Date value	d) Convert date into corresponding value

Question 11.
Give the cell address or range reference in the following situations

1. Cell at 8^th column and 10^th row
2. Cell at 27^th column and 6^th row
3. Range starting from 5^th column, 9^th row and spread till 12^th column and 15^th row

Answer:

1. H10
2. AA6
3. E9: L15

Question 12.
What are the steps to be followed for naming cells and ranges.
Answer:
Step 1 – Select the cells or ranges that are to be named.

Step 2 – Select Define Range from the Data menu Data.

Step 3 – This will display a dialogue box us “Define Database Range”. It will provide a place to enter “Name”.

Step 4 – Click OK on the dialogue box.

Plus Two Accountancy Spread Sheet Practical Lab Work Questions and Answers

Question 1.
The following marks are obtained by 8 students in an examination.

Ascertain the grade obtained by students based on the following criteria

Procedure:
Step 1 – Open Libre Office Cal work sheet
Applications → Office → Libre Office calc

Step 2 – Enter the data in the given cells

Step 3 – Enter the following formula in cell D2
= IF(C2 < 30, “FAIL”, IF(C2 < 40, “D+”, IF(C2 < 50, “C”, IF(C2<60, “C+”, IF(C2 < 70, “B”, IF (C2 < 80, “B+”, IF(C2 < 90, “A”, IF(C2 < 100, “A+”))))))))

Step 4 – Drag the formula to D9
Output:

Question 2.
The sales made by 6 salesmen during three months are given below. You are required to prepare a statement showing the total sales of each salesman and total sales of the firm.

Procedure:
Step 1 – Open LibreOffice calc worksheet
Applications → Office → LibreOffice Calc

Step 2 – Enter the following data in the given cells

Step 3 – Enter the given formula in cell E2 = B2 + C2 + D2

Step 4 – Drag the formula to E7 to get the total sales of each salesman

Step 5 – Enter the given formula in cell E8 to get the total sales of the firm = SUM (E2: E7)
Output:

Question 3.
The monthly production of a company are given below

Month	Production (Units)
January	25000
February	20000
March	22000
April	18000
May	19000
June	24000

 

1. Find the total production for the six months
2. Find the average production of the six months
3. Find the number of months during the period
4. Find the lowest production of the six months
5. Find the highest production of the six months

Procedure:
Step 1 – Open LibreOffice Calc worksheet
Applications → Office → LibreOffice Calc

Step 2 – Enter the following data in the given cells

Step 3 – Enter the following formula in the given cells

B8	= SUM (B2:B7)
B9	= AVERAGE(B2: B7)
B10	= COUNT (B2:B7)
B11	= MIN (B2:B7)
B 12	= MAX (B2:B7)

Output:

Question 4.
For the recruitment of managers in different departments of a company, Applicant’s age should be greater than 35 and less than 45 as on 31/03/2018. Write the Spreadsheet statement to test when a candidate is eligible for recruitment or not, when his/ her date of birth is entered in a cell as input
Procedure:
Step 1 – Open LibreOffice Calc Spread sheet.
Applications → Office → LibreOffice Calc

Step 2 – Enter the given data in the following cells

Step 3 – Enter the date of birth in cell B2

Step 4 – Enter the following formula in cell B3 = Round ((B1-B2)/365,0). Then the age will display in the cell B3.

Step 5 – Enter the following formula in cell B4 to test the eligibility of the candidate = IF(B3<35, “Not eligible”, IF(B3>45, “Not eligible”, “Eligible”)

OR

= IF (AND (B>34, B3<46), “Eligible”, “Not eligible”)
Note: The data value entered in cell B2 and B3 are to be formatted as “Date”

Question 5.
The given table shows name of employees, Designation and monthly salary paid for different employees in Jose Traders.

Find out the following:

1. The total monthly salary by naming range (TOTAL SALARY)
2. The total monthly salary paid to marketing managers (MM) in the firm
3. The name of employees with a monthly salary of Rs.30000 by using LOOK UP function.

Procedure:
Step 1 – Open LibreOffice Calc worksheet
Applications → Office → LibreOffice Calc

Step 2 – Enter the data in the appropriate cells

Step 3 – Naming a range
Select the range which shows monthly salary ie C2: C7 click on “Data” from the menu bar. Select “Define Range” Type the name “TOTAL_SALARY” in the name box and press OK or Enter key

Select the Range (C2: C7) → Data → Define Ranges Type TOTAL_SALARY. Press OK/Enter Key

Step 4 – Enter the following formulas in respective cells .

B8	= SUM (TOTAL_SALARY)
B9	= SUMIF(B2:B7, “MM”, C2:C7)
B10	= LOOKUP(30000, C2:C7, A2:A7)

Output:

Question 6.
The following Data is given in the form of a Table.

• How many cells contain numbers only?
• How many cells contain any value?
• Count the number of cells containing the value exceeding 500.
• How many blank cells are there in the table?

Procedure:
Step 1 – Open LibreOffice Calc
Applications → Office → LibreOffice Calc

Step 2- Enter the given details in appropriate cells.

Step 3 – Enter the given details and formula in the Following cells.

Step 3 – Enter the given details and formula in the

Output:

Question 7.
The following details are given

Find out

• Find the name of student whose admission number is 8267
• Look up value 8136 and locate the fee paid status by using VLOOKUP
• Look up the name of student against admission number 8124
• Ad. No. of student who paid fee Rs. 580

Procedure:
Step 1 – Open LibreOffice Calc worksheet
Application → Office → LibreOffice Calc.

Step 2 – Enter the details in the given cells

Step 3 – Enter the given details and formula in the following cells

	A
8	Name of student Ad.No.8267
9	Fee paid status of Ad No.8136
10	Name of student Ad. No.8124
11	Ad.No. of student, paid Rs.580

	B
8	= LOOKUP(8267,A2:A7,B2:B7)
9	= VLOOKUP(8136,A2:C7,3,0)
10	= LOOKUP(8124,A2:A7,B2:B7)
11	= VLOOKUP (8370,A2:C7,3,0)

Output:

Question 8.
The marks in Accountancy of some students are given below.

Name	Mark
Priya	89
Indira	-ab-
Sindhu	56
Reny	64
Beena	49
Bindhu	50
Resmi	-ab-

Calculate:

1. Number of students in the class
2. Number of students appeared in the Accountancy examination
3. Total marks in Accountancy examination
4. Average Marks in Accountancy examination
5. Lowest mark in Accountancy
6. Highest mark in Accountancy

Procedure:
Step 1 – Open LibreOffice Calc Work sheet
Application → Office → LibreOffice Calc.

Step 2 – Enter the given data in appropriate cells.

Step 3 – Enter the following details and formula in the given cells

Output:

Question 9.
Mark summary of some students are given below.

Calculate

1. Number of cells containing 90 marks
2. Count the number of paper scored less than 40
3. Find the result of each student. (Pass or Fail) minimum mark required to pass is 30

Procedure:
Step 1 – Open LibreOffice Calc worksheet
Application → Office → LibreOffice calc

Step 2 – Enter the given data in appropriate cells

Step3 – Enter the following details and formula in appropriate cells

A8	Number of cells containing 90 mark
B8	= COUNTIF(B2: G7, “90”)
A9	Count the number of paper scored less than 40 Mark
B9	= COUNTIF(B2: G7, “40”)

Step4 – Find the result of the student

1^ststep – Count the number of marks less than 30 scored by each student For this,
Enter the formula in H2 =COUNT IF (B2: G2, “<30”)
Drag the equation to H7

2^nd step – Based on the result in H2: H7 range, we can find out the result in I2 cell by giving the following formula
=IF(H2 = 0, “PASS”, “FAIL”)
Drag (Copy) the formula to I7
Output:

Question 10.
List of debtors and creditors, and the amount due from them are given below

Calculate the total amount of receivables and payables using SUMIF functions.
Procedure:
Step -1 Open Libre Office Calc worksheet
Applications → Office → LibreOffice calc

Step 2 – Enter the details in the given cells.

Output:

Question 11.
Calculate Income Tax of following employees based on the following criteria.

Conditions

1. Tax rate is 40% of Total taxable Income.
2. For male, standard deduction is 150,000 3 For female, if taxable income is less than or equal to Rs.4,00,000, then the standard deduction is 2,00,000, otherwise 1,50,000

Procedure:
Step 1 – Open LibreOffice Calc worksheet
Application → Office → LibreOffice calc

Step 2 – Enter the given details in the given range

Step 3 – Calculation of Tax
Enter the formula in D2 cell and drag with the fill handle up to D8
= IF(B2 = “Male”, (C2 – 150000)*40%, IF (AND(C2 = “Female”, C2 <= 400000), (C2 – 200000)*40%, (C2 – 150000)*40%))
Output:

Name of Employee	Tax
Manoj	60,000
Praveena	1,20,000
Naveen	2,20,000
Riya	2,08,000
Rohit	1,40,000
Latha	80,000
Arya	2,84,000

Question 12.
For SI selection in Kerala polices there is a physical test, which consists of three items. A candidate has to qualify ANY ONE of the three tests to qualify for the final. The standard for the physical test is given below.

• Shot put: 5 meters or above.
• Ball throws 50 meters.
• 500-meter race within 5 minutes.

The following data is furnished:

Check whether the candidates quality or not.
Procedure:
Step 1 – Open LibreOffice Calc worksheet
Application → Office → LibreOffice calc

Step 2 – Enter the details in the form of a Table

Step 3 – Enter the following formula in F2 and drag with fill up to F6 = IF(OR(C2>=5, D2>=50, E2<=5), ‘‘Qualified”, “Not Qualified”)
Output:

Chest No.	Result
203	Qualified
216	Qualified
275	Qualified
304	Not Qualified
361	Qualified

Question 13.
Calculate DAY, MONTH and YEAR of 36525 Procedure:
Step 1 – Open LibreOffice Calc worksheet.

Step 2 – Enter the details in appropriate cells.

Output:

Question 14. Calculate the Date value of 28/10/1978/
Procedure:
Step 1 – Open LibreOffice calc work sheet
Application → Office → LibreOffice Calc

Step-2 – Enter the given details in Cell A1 = DATEVALUE (“28/10/1978”)
Output:

Question 15.
Find the age of Resi Jos based on her date of birth and today’s date Date of birth 06-05-1981.
Procedure:
Step 1 – Open Libre office Calc work sheet Application officer LibreOffice calc

Step 2 – Enter the following details in appropriate cells.

Output:

Question 16.
Below is given the table showing the name, department, and salary paid for different employees

• Find number of employees in the firm.
• Find number of employees in Production Department.
• Find the total monthly salary paid in Purchase Department.
• Find the total monthly salary paid in Finance Department.

Procedure:
Step 1 – Open a new blank work sheet in LibreOffice Calc.

Step 2 – Enter the following details as given below.

Step 3 – Enter the following text in different cells as given below.

Cell	Text
A9	No. of employees in the firm
A10	No. of employees in the production department
A11	Total monthly salary paid in purchase depart­ment
A12	Total monthly salary paid in finance depart­ment

Step 4 – Enter the following formula in different cells as given below.

Cell	Formula
B9	= COUNTA(A2: A8)
B10	= COUNTIF(B2: B8, “Production”)
B11	= SUMIF (B2: B8, “Purchase”, C2: C8)
B12	= SUMIF (B2: B8, “Finance”, C2: C8)

Output:

Question 17.
Below is given the table showing the Name, Department, and Salary paid for different employees.

• Name the employee name column as “Emp Name”, Department column as “Dept” and monthly salary column as “Salary”.
• Find the total monthly salary.

procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc.

Step 2 – Enter the following details in respective cells.

Step 3 – Select the range A2: A6, From the Data tool menu, select “Define Range” and – give name as “ Emp Name” and click (OK) button.

Step 4 – Select the range B2: B6, From the Data tool menu, select “Define Range” and give name as “Dept” and click (OK) button.

Step 5 – Select the range C2: C6, From the Data tool menu, select “Define Range” and give name as “Salary” and click (OK) button.

Step 6 – Enter the following formula to find out the total monthly salary.

Cell	Text / Formula
A 7	Total Monthly Salary
B 7	= SUM (Salary)

Output:

Total Monthly Salary

12500

Question 18.
Below is given the table showing the Name, Class, and Fees due to different students.

• Find out the total fees due from the students.
• Find the average amount of fees
• Find the highest amount of fees
• Find the lowest amount of fees

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following details in the worksheet as follows.

Step 3 – Enter the following text in respective cells.

Cell	Text
A9	Total Fees due
A10	Average Fees
A11	Highest amount of fees
A12	Lowest amount of fees

Step 4 – Enter the following formula in respective cells

Cell	Formula
B9	= SUM (D2: D8)
B10	= Average (D2: D8)
B11	= Max (D2;D8)
B12	= Min (D2: D8)

Output:

Total Fees Due	2700
Average Fees	386
Highest Amount of Fees	625
Lowest Amount of Fees	60

Question 19.
From the given values, calculate the following:

• Find the number of values
• Find the total sum of the values
• Find the average
• Find the largest value
• Find the smallest value

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the values in the work sheet as follows.

Step 3 – Enter the following text in the respective cells.

Cell	Text
A8	Number of values
A9	Sum of the values
A10	Average
AH	Largest value
A12	Smallest value

Step 4 – Enter the following formula in the respective cells.

Cell	Formula
B8	= COUNT (A1: A7)
B9	= SUM(A1: A7)
B10	= AVERAGE/A1: A7)
B11	= MAX/A1: A7)
B12	= MIN(A1: A7)

Output:

Number of values	7
Sum of the values	3000
Average	429
Largest value	700
Smallest value	200

Question 20.
Prepare a statement showing advance tax collected form the employees @ 10% of the yearly salary from those who receive Rs. 500000 or more.

Employees	Yearly salary
Fijo	855000
Joshy	650000
Roby	720000
Bose	425000
Prince	570000
Binoy	380000

Procedure:
Step 1 – Open a new blank worksheet in LiberOffice Calc.

Step 2 – Enter the following details in respective cells.

Step 3 – Select the range A2: A7, From Data Tools menu, select ‘Name a Range’ and give name as “Employees” and click (OK) button.

Step 4 – Enter the text /formula in the following cells.

	C
1	Advance Tax
2	= IF (B2>=500000, B2*10%, 0)
3
4
5
6
7

Step 5 – Copy formula to C3: C7 to the last employee.

Step 6 – Enter “Total Advance Tax” in cell B8 and enter the formula ‘‘SUM C2: C7” to get total amount.
Output:

Fijo	85500
Joshy	65000
Roby	72000
Prince	57000

Question 21.
Mrs. Leela, the class teacher is analysing the performance of her students in a class test.

Find out

• Total number of students
• Number of students appeared in the class test
• Number of students with no grade
• Number of A+ holders
• Number of B grade holders.

Procedure:
Step 1 – Open a new blank worksheet in LiberOfficeCalc

Step 2 – Enter the following details in the respective cells.

Step 3 – Enter the text /formula in the corresponding

Output:

Total number of students	8
Students appeared in-class test	6
Students with no grade	2
Number of A+ holders	2
Number of B grade holders	1

Question 22.
The monthly sales effected by 6 salesmen are given below.

Calculate the commission earned by each salesman on the basis of the following rules.

Total sales	Commission
Less than 8000	Nil
8000- 10000	5%
10000- 12000	8%
More than 12000	10%

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following details in the respective cells.

Step 3 – Enter the formula = SUM (B2: D2) in cell E2 to get the total sales. Copy the formula to the last employee.

Step 4 – Enter the formula = IF (E2 >= 12000, E2 * 10%, IF (E2 >= 10000, E2*8%, IF(E2 >= 8000, E2 * 5%,0)))
Copy the formula to the last employee.
Output:

Question 23.
ABC Ltd categorises their salesmen into four on the basis of sales targets achieved in each quarter. The criteria and sales are given below.

Performance criteria
Total sales – Grade
More than 100000 – Excellent
50000-100000 – Good
30000-50000 – Average
Less than 30000 – Bad
Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following details in the respective cells.

Step 3 – Enter the formula in E2 to get total sales = SUM (B2: D2)
Copy the formula to the last employee.

Step 4 – Enter the formula in F2 to get the commission = IF(E2 >= 100000, “EXCELLENT”, IF (E2 >= 50000, “GOOD”, IF (E2 >= 30000, “AVERAGE”, “BAD”)))
Copy the formula to the last employee.
Output:

Ramesh	BAD
Suresh	GOOD
Mahesh	AVERAGE
Rajesh	GOOD
Sukesh	GOOD

Question 24.
Below is given the name and address of some students. Combine and show details in an address format using CONCATENATE function.

Procedure:
Step 1 – Open a new blank worksheet in LiberOffice Calc
Application → Office → LibreOffice Calc

Step 2 – Enter the following details in appropriate cells

Step 3 – Enter the following formula in F2 cell = CONCATENATE (A2, “ ”, B2, “ ”, C2, “ ”, D2, “ ”, E2)

Step – 4 Copy down the formula up to the row of the last employee.
Output:

Address

Sanjan Kollannur Kechery 680579.

Shaji Amala Bhavan Ollur 680514 Thrissur.

Nithin MRA/258 Mannuthy 680007 Ernakulam.

Question 25.
Mr Venugoapl is planning to invest Rs. 10000 in the beginning of each year in an annual investment scheme. The interest rate is 8% and the term of the scheme is 10 years. Using FV function, find out how much amount he will get at the expiry of the scheme.
Procedure:
Step 1 – Open a new blank worksheet in LiberOffice Calc

Step 2 – Enter the given detials and formula in diffemt cells

Output:

Future value

156454.87

Question 26.
Anakha Ltd. wants to select one machinery, out of the two alternatives available on the basis of net present value. The cost and inflows of these machineries are given below.

Assuming annual interest rate of 10%, find out net present values of these two machineries.
Procedure:
Step 1 – Open a blank work sheet in LiberOffice Calc

Step 2 – Enter the following details in respective cells.

Step 3 – Enter the formula = NPV (10%, C2:F2) – B2 in G2 to get the net present value of semi automatic machinery.
Copy the formula to G3
Output:

Machinery	NPV
Semi-Automatic	4683.42
Fully Automatic	52891.2

Question 27.
Calculate Net Present Value (NPV) from the following data

Cost of Machinery	2000000
Cash inflows -1 year	60000
Cash inflows – II year	80000
Cash inflows – III year	82000
Cost of capital	12%

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following details in the respective cells.

Step 3 – Enter the formula in B6 = NPV (12%, B2:B4)-B1 to get NPV
Output:

Net Present value

24287.08

Question 28.
Write the Libre Office Calc formula to multiply a given number entered in a cell with the following conditions

• If the cell value is less than 20, then multiply by 1
• If the cell value is greater than or equal to 20 but less than 40, then multiply by 2
• If the cell value is greater than or equal to 40 but less than 80, then multiply by 3
• If the cell value is greater than or equal to 80 but less than 100, then multiply by 4.
• If the cell value is greater than or equal to 100, then display “Enter a value less than 100” Use nested IF function.

Procedure:
Step 1 – Open a blank work sheet in LibreOffice Calc

Step 2 – Enter the following details in respective cells.

Step 3 – Enter any value in cell A2; then the result will be in cell B2.
Output:

Cell value	Result
18	18
37	74
115	Enter value less than 100
85	340

Question 29.
Salary detail of 8 employees are given below.

Develop a formula to compute tax under the following conditions.
1. Tax rate-20%

2. For males, Rs. 2,00,000 is allowed as standard deduction. For females, if taxable income is less than or equal to Rs. 5,00,000, then Rs. 3,00,000 is allowed as standard deduction, otherwise Rs. 2, 50,000. Use suitable logical function.
Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following details in respective cells.

Step 3 – Enter the formula in cell E2 and copy it to the last employee.
=IF (C2 = “MALE”, (D2-20Q000)*20%, IF (AND(C2 = “FEMALE”, D2<=500000), (D2 – 300000) * 20%, (D2-250000)*20%))
Output:

Name	Tax
Elsy	40,000
Jose	90,000
Rosily	20,000
Rejina	40,000
Antony	1,00,000
Jessy	30,000
George	80,0000
Baby	60,000

Question 30.
The recruitment process of language teachers in a school consists of three items like interview, group discussion and paper presentation. A candidate has to qualify any one of the three tests to qualify for the written test. The prescribed standard for the items are given below.

• Interview – 16 score out of 20.
• Group Discussion – 25 score out of 30.
• Paper Presentation – 40 score out of 50

Other informations are also available.

Write a formula using OR function to check whether a candidate qualify or not.
Procedure:
Step 1 – Open a blank work sheet in LiberOffice Calc.

Step 2 – Enter the available data in work sheet

Step 3 – Enter the formula in F2 and copy it to the last candidate
= IF(OR (C2>=16, D2>=25, E2>=40) “Qualified for the written Test”, “Not Qualified”)
Output:

Question 31.
Business studies, Accountancy and Economics are commerce subjects. Write a formula to check whether text is a commerce subject. If yes, print **** is a commerce subject, otherwise print **** is not a commerce subject. Write procedure based on the available hints
Procedure:
Step 1 – Open a blank work sheet in LiberOffice Calc

Step 2 – Enter the text in the following cells.

Step 3 – Enter the name of subject in A2 and type the formula in B2 and drag it
= IF (OR (A2= “Business studies”, A2 = “Accountancy”, A2= “Economics”), A2 & “is a” & “Commerce Subject”, A2 & “is” & “not a commerce subject”)
Output:

Subject	Remarks
Malayalam	Malayalam is not a commerce subject
Business studies	Business studies is a commerce subject
Chemistry	Chemistry is not a commerce subject
Mathematics	Mathematics is not a commerce subject
Accountancy	Accountancy is a commerce subject.

Question 32.
ABC company issued a security with par value Rs. 50000 on 1/1/2013. The first interest date is 1-4-2013, the settlement date is 31-12-2015 an the annual coupon rate is 6%. The security’s payments are made quarterly, and a US (NASD) 30/360 day count basis is used. Use ACCRINT() function to calculated the accrued interest of a security that pays periodic interest.
Procedure:
Step 1 – Open a blank new worksheet in LibreOffice Calc.

Step 2 – Enter the data in the following cells.

Step 3 – Enter the formula in B9 = ACCRINT (B2, B3, B4, B5, B6, B7, B8)
Output:

Accrued Interest

9000

Question 33.
Prince took a loan of Rs. 500000 from banks @ 12% interest p.a. repayable after 15 years. Compute interest payable at the end of (a) First year (b) Second year (c) Fifth year and the last year.
procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the given details in respective cells

Step 3 – Enter the given formula in respective cells.

• B8 = CUMIPMT(B3/12, B2*12, B4, B5, B6, B7)
• C8 = CUMIPMT(C3/12, C2*12, C4, C5, C6, C7)
• D8 = CUMIPMT(D3/12, D2*12, D4, D5, D6, D7)
• E8 = CUMIPMT(E3/12, E2*12, E4, E5, E6, E7)

Output:

Year	Interest
First year	59316.92
Second year	57707.11
Fifth year	51545.84
Last year	4470.16

Question 34.
Calculate the present value of an annuity that pays Rs. 3000 per month for a period of 5 years. The interest is 11.5% per annum and each payment is made at the end of the month.
Assume the payments are made.

• At the beginning of each month
• At the end of each month

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following data/ Formula in respective cells.

Step 3 – Enter the formula as follows
B6 = PV (B2/12, B3*12, B4, B5)
C6 = PV(C2/12, C3*12, C4, C5)
Output:

Present value – at the beginning	136409.4
Present value – at the end	136410.04

Question 35.
The table given below shows the First name, Middle name and Last name of some employees. Show their Full name in the next column using CONCATENATE Function.

Procedure:
Step 1 – Open a new blank worksheet in Liber Office Calc
Application → Office → Libre Office Calc

Step 2 – Enter the following details in appropriate cells

Step 3 – Enter the following formula in D2 cell = CONCATENATE (A2, “ ”, B2, “ ”, C2)

Step 4 – Copy down the formula up to the row of last employee.
Output:

FULL NAME

Roby Antony Alappatt

Hema Gangadharan Menon

Cili Jose Vazhappilly

Santhosh Jacob Kannanaikal