M S EXCEL I 11/8/2023

 Question 1:

Define the term workbook.
Answer:
A workbook is a collection of worksheets. By default, there are three worksheets in every workbook.

Question 2:
What is the default alignment of number, text and formula in a spreadsheet?
Answer:
Default alignment of text or label entry is left alignment and for numbers and formula it is right alignment.

Question 3:

Explain the concept of cell referencing alongwith its various types.

Answer:
Excel supports three types of cell referencing, which are as follows:

  1. Relative Every relative cell reference in formula automatically changes when the formula is copied down a column or across a row. As the example illustrated here shows, when the formula is entered (= B4 — C4) in Cell D4 then this formula copied in D5 then it will change into (= B5 — C5) related to cell.
  2. Absolute An absolute cell reference is fixed. Absolute references do not change if you copy a formula from one cell to another. Absolute references have dollar sign ($) like $S$9. As the shows, when the formula =C4*$D$9 is copied from row, the absolute cell reference remains as $D$9. ‘
  3. Mixed A mixed cell reference has either an absolute column and a relative row, or an absolute row and a relative column, e.g. $A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes.

Question 4:

Suggest the appropriate function for the following situations:

  1. Selecting the maximum value out of a range A1 to B20.
  2. Calculating average of marks entered in cells E5, F5, G5, H5 and 15.
  3. Determining whether the student has passed (if scored > = 40) or not from the marks stored in cell J10.

Answer:

  1. = MAX(A1 : B20)
  2. = AVG(E5:15)
  3. =IF(J10 >= 40, “Pass”, “Fail”)
PRACTICAL QUESTIONS -











Comments

Post a Comment

Popular posts from this blog

computer ethics class 8

Image
  CHAPTER 10 COMPTUER ETHICS MCQ 11. C Protecting password 22. B. software piracy 33.   B. Plagiarism 44. B. firewall 55. A. spamming B fill in the blanks 1. Computer ethics 2. Hacking means unauthorized access to someone’s computer for viewing, copying or creating data on it. 3. Emails 4. Spamming 5. Footprint c. Match the following- 1.      d. cyberbullying 2.      c. copyright 3.      e. Phishing 4.       b. hacking 5.       a. digital fooprint   SHORT QUESTION ANSWER 1.  Intellectual property rights are the rights given to a person over their creation. IPR protects an individual’s or a company’s ideas and creations, such as research work, product, art, logo, trademark, registration etc.   2.  Renting means lending or renting out software without the permission of...
Read more

ORGANISING AND ENCANCING WEBPAGES CLASS VIII

  Lists are an important part of a document. Whether it is a word document or pdf document or web document. It adds functionality to understand the contents clearly. In textbook there is list of questions, points are listed in numbers or symbols!   This information makes your text and document contents more attractive and readable. Types of Lists in HTML HTML support three types of lists basically. They are: Ordered (Numbered) Lists –  A list with numbers.  Unordered (Bulleted) Lists –  A list with symbols or bullets Description (Definition) Lists  – A list to write definitions or terminologies Ordered (Numbered) Lists To generate order lists in HTML following tags are used: OL:  The ordered lists always starts with <ol> and ends with </ol>.  LI:  LI tag specifies list items and written between <ol> and </ol>. For a number of the list items, the same number of <li> tags are required. Q1. Write HTML code to create...
Read more

INTERENT BASICS multiple choice questions 16 AUG 2023

  1)  ARPANET stands for …………………………………… a) After Releasing Project At Network b) Advanced Research Project Agency Network c) At Residential Project Area Network d) None of these 2)  …………………. is interconnection of world wide computer networks, i.e network of networks. a) Web browser b) Search engine c) Network d) Internet 3)  A …………………… is a set of rules established which determines that how the data is transmitted between different computers in a network. a) Protocol b) WWW c) URL d) Hyperlink 4)  It is a computer program with a graphical user interface for displaying and navigating between webpages is to be termed as ……………………………………………………. a) WWW b) Web Browser c) Protocol d) None of these 5) A ……………….. is a collection of one or more webpages, containing images, audio/video files, databases etc. that are stored on a webserver. a) Website b) WWW c) Protocol d) URL 6) It is nothing but a visible element in webpages...
Read more