Some questions are asked by class 9 students related to Foundation of Information Technology

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:
Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. Help Reena in identifying the active cell on her screen.
Answer:
An active cell is a cell with heavy black color boundary.

Question 3:
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 4:
Elaborate the formatting necessary.
Answer:
With formatting, we can make some data to be bolder, rotated or in different color. So, basically formatting provides worksheet a neater and more legible outlook.

Question 5:
Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell?
Answer:
First row and ninth column address will be II.

Question 6:
How many ways are there for adding a new worksheet in an Excel workbook?
Answer:
There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.

Question 7:
In Excel, how many ways are there to express/format a number?
Answer:
Numbers in Excel can be expressed in many different formats like date, time, percentage or decimals.

Question 8:
Name the toolbar of spreadsheet which has all the options of changing the font properties.
Answer:
Formatting Toolbar

Question 9:
What do you mean by relative referencing?
Answer:
Cell referencing in which the cells are referred by their relative position in the worksheet relative to a particular cell is called relative referencing.

Question 10:
How many cells would be there in the cell range [A1 ; B2]?
Answer:
There would be 4 cells in the given cell range.

Question 11:
The cell A1 has value Monday. If you are asked to click and drag the Fill handle of A1 downside then what will be the contents of cell A2, A3, A4 and A5?
Answer:
Cells A2, A3, A4 and A5 will contain Tuesday, Wednesday, Thursday and Friday respectively.

Question 12:
If = 6 -5 *2 is entered in a cell, then what will be the cell content?
Answer:
-4 will be contained in cell as a result.

Question 13:
In a spreadsheet software, the formula =A1 +$A$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3?
Answer:
=B1+$A$2 will be copied into B3.

Question 14:
Write down the formula for adding values of cells A1 to A5.
Answer:
Formula for adding values of cells A1 to A5 would be =SUM(A1 : A5).

Question 15:
State difference between COUNT() and COUNTA() function.
Answer:
The only difference between the COUNT() and
COUNTA() function is that the COUNTA() function computes the numbers as well as text entries, while the COUNT() function counts only numbers.