Std VI | II Semester Revision | Lesson 7, Lesson 8 & Lesson 9

-
Std V Computer – Lesson 6 & 7
II Semester
Revision Work Sheet
Std VI

Lesson 7, Lesson 8 & Lesson 9 – All Questions & Answers

Lesson No. 7 – Formula and Functions in Excel

A) Answer the Following

Q1. What is a formula in Excel?
Ans: A formula is used to perform calculations in Excel and starts with (=).

Q2. State any one rule for writing a formula in Excel.
Ans: A formula must begin with an equal (=) sign.

Q3. What is cell referencing?
Ans: It is the method of referring to cells in a formula.

Q4. What is relative cell referencing?
Ans: It changes automatically when copied.

Q5. What is absolute cell referencing?
Ans: It remains fixed and uses the $ symbol.

Q6. Name any two types of functions in Excel.
Ans: Mathematical and Text functions.

B) True or False

  1. A formula in Excel always starts with (=) – True
  2. Cell referencing helps Excel identify the cell used in a formula – True
  3. Relative cell reference remains fixed when copied – False
  4. Absolute cell reference uses the dollar ($) sign – True
  5. Functions are used only for typing text – False
  6. Formulas can be copied using copy and paste – True
  7. Date and Time functions work without formulas – False

C) Match the Following

Column AAnswerColumn B
1. Formulag. Performs calculationa. Work with text
2. Relative referencee. Changes when copiedb. Duplicate calculation
3. Absolute referenced. Uses $ symbolc. Part fixed, part change
4. Mixed referencec. Part fixed, part changed. Uses $ symbol
5. Copy formulab. Duplicate calculatione. Changes when copied
6. Mathematical functionsf. Addition and subtractionf. Addition and subtraction
7. Text functionsa. Work with textg. Performs calculation

D) Full Forms

  • MS Excel – Microsoft Excel
  • CPU – Central Processing Unit
  • SUM – Summation Function
  • AVG – Average
  • IF – Logical If Function

Lesson No. 8 – Introduction to Small Basic

A) Short Answers

Q1. What is Small Basic?
Ans: Small Basic is a simple programming language for beginners.

Q2. Name any two elements of the Small Basic window.
Ans: Editor window and Toolbar.

Q3. How do you share a program in Small Basic?
Ans: Use the Publish option to share the program.

B) True or False

  1. Small Basic is suitable for beginners – True
  2. Small Basic programs are written using simple commands – True
  3. The Small Basic window has no toolbar – False
  4. A program must be saved before closing Small Basic – True
  5. Saved programs cannot be reopened – False
  6. Small Basic allows users to share programs online – True
  7. Small Basic is used only for typing documents – False

C) Match the Following

Column AAnswerColumn B
1. Small Basicg. Beginner programming languagea. Share program online
2. Editor Windowe. Area to type codeb. Opens saved program
3. Toolbarc. Contains command buttonsc. Contains command buttons
4. Save optionf. Stores the programd. Performs basic task
5. Open optionb. Opens saved programe. Area to type code
6. Simple programd. Performs basic taskf. Stores the program
7. Publish optiona. Share program onlineg. Beginner programming language

D) Full Forms

  • SB – Small Basic
  • GUI – Graphical User Interface
  • IDE – Integrated Development Environment
  • URL – Uniform Resource Locator
  • PC – Personal Computer

Lesson No. 9 – Popular Service on the Internet

A) Answer the Following

Q1. What is WWW?
Ans: WWW is a service on the Internet used to access web pages.

Q2. What is video conferencing?
Ans: It allows people to communicate using live video and audio.

Q3. What is E-commerce?
Ans: Buying and selling goods and services online.

Q4. What is chatting?
Ans: Sending and receiving instant messages.

Q5. What is E-learning?
Ans: Learning through the Internet.

Q6. What is Internet TV?
Ans: Watching TV programs online.

Q7. What are Newsgroups?
Ans: Online discussion groups.

B) True or False

  1. WWW is used to access web pages – True
  2. Video conferencing needs Internet – True
  3. E-commerce is only offline – False
  4. Chatting allows instant communication – True
  5. E-learning cannot be done from home – False
  6. Internet TV works without Internet – False
  7. Newsgroups are used for discussions – True

C) Match the Following

Column AAnswerColumn B
1. WWWc. Web pages on Interneta. Online buying and selling
2. Video Conferencinge. Live video communicationb. Online study system
3. E-commercea. Online buying and sellingc. Web pages on Internet
4. Chattingg. Instant messagingd. Online discussions
5. E-learningb. Online study systeme. Live video communication
6. Internet TVf. Watching programs onlinef. Watching programs online
7. Newsgroupsd. Online discussionsg. Instant messaging

D) Full Forms

  • WWW – World Wide Web
  • ISP – Internet Service Provider
  • URL – Uniform Resource Locator
  • E-mail – Electronic Mail
  • HTTP – HyperText Transfer Protocol

Comments

Post a Comment