Solved Exercise
Chapter-3
A. Multiple choice questions:1. Cell reference is also known as:
a. cell row b. cell number c. cell position d. cell address
Answer: Cell Address
2. The three types of cell references are relative reference, ______________ and mixed reference.
a. Ascending reference b. cell reference c. Absolute reference d. row reference
Answer: Absolute reference
3. Excel used four types of:
a. references b. operations c. addresses d. positions
Answer: Operations
4. Which operator return a True or false result?
a. comparison b. arithmetic c. reference d. text
Answer: Comparison
5. Which operator make no changes to constants or cell contents?
a. comparison b. arithmetic c. reference d. text
Answer: Reference
6. Which operator use (:) to reduce your work in formulas?
a. range b. text c. arithmetic d. comparison
Answer: Range
7. Mathematical functions are used to perform wide variety of ___________ or complex calculations.
a. compound b. imperative c. positive d. simple
Answer: Simple
8. Each rectangle in a worksheet is called is_______________.
a. row b. column c. cell d. text
Answer: Cell
9. To select a cell, you can also navigate through your worksheet and select a cell by using the __ keys.
a. arrow b. number c. alphabetical d. slash
Answer: Arrow
10. In excel, cells are formed by the intersection of rows and __________________.
a. numbers b. columns c. letters d. comments
Answer: Columns
B. Write T for true and F for false statements:
1. MS Excel is very useful, especially in financial applications. T
2. Rows are numbered A,B,C,D, and columns are named alphabetically as 1,2,3,4, and so on. F
3. If you copy the formula across rows or down columns, the formula value does not change. T
4. Operators are used in formulas to execute operations on the values taken by formulas. T
5. Round() function rounds a number to a specified number of digits. T
6. The syntax of ROUNDDOWN is ROUNDDOWN (number, num-digits). T
7. SQRT () returns a positive and negative square root of a number. F
8. A text is the intersection of rows and columns. F
9. Range operator uses(:) to reduce your work in formulas. T
10. Comparison operators return a true or false result. T
C. Fill in the blanks:
1. _______________ software allows you to organize data into rows and columns in a worksheet.
Answer: MS Excel
2. In Excel, cells are formed by the intersection of rows and _____________.
Answer: Columns
3. If there is no value in the cell, excel takes a ____________ value by default.
Answer: Null
4. ________ reference in a formula always refers to a cell in a specific location.
Answer: Absolute cell
5. To compare values, you can create formulas using ________ operators.
Answer: Comparison
6. If num-digits is greater than 0, then number is rounded to the specified number of ____ places.
Answer: Deciaml
7. ABS() function returns the ____________ value of a number.
Answer: Absolute
8. ___________ can contain letters, numbers and dates.
Answer: Text cells
9. Cell reference is also known as _____________.
Answer: Cell address
10. Joining text is known as __________________.
Answer: Concatenation
D. Answer the following questions in short:
1. How many operators are used in Excel? Name them.
Answer: Excel uses four types of operators:
1. Arithmetic, 2. Text, 3. Comparative, 4. Reference
2. What is the function of ROUNDUP? Explain with an example.
Answer: Roundup() function rounds a number up away from 0(zero).
Syntax: ROUNDUP(number, num-digits)
3. What is the function of ABS()?
Answer: ABS () function returns the absolute value of a number.
Syntax: ABS(num)
4. What is SQRT() function?
Answer: SQRT() returns a positive square root of a number.
Syntax: SQRT (num)
5. What do you mean by a cell?
Answer: Each rectangle in a worksheet is called a cell.
6. How do you compare values?
Answer: To compare values, you can create formulas using comparison operators. These operators return a true or false result.
E. Answer the following questions in detail:
1. What is cell reference?
Answer: In Excel, cells are formed by the intersection of rows and columns. They are identified by row and column names. In excel, a cell reference identifies the location of a cell or group of cells in the spreadsheet. Cell reference is also know as cell address.
There are three types of cell references.
1. Relative reference
2. Absolute reference
3. Mixed reference
2. What is MS Excel?
Answer: MS Excel is very useful, especially in financial applications. MS Excel allows you to organize data into rows and columns in a worksheet. Each worksheet has a total of 65,536 rows and 256 columns. It can also perform calculations like addition and subtraction on the data given in these rows and columns very fast.
3. What is Text concatenation operator? Explain with an example.
Answer: The ampersand (&) operator, joins text within quotation marks or text contained in reference cells. Joining text is known as concatenation.
Example: In excel sheet, Mona writes "Mr." in row 1 & column A and "Manoj" in row 1 & column B. Now she write a formula in formula bar: =A1&" "&B, press the enter.
The result will be: Mr. Manoj.
4. What is Reference operator? Explain with an example.
Answer: Reference operators make no changes to constants or cell contents. Instead, they control how a formula groups the cells and ranges of cells when the formula is made to calculate.
Example:
Operator :
Example SUM(A7:A11)
Type Range
Result Evaluate as a single reference the cells in the rectangular area between the two corners.
5. What are Mathematical functions? Explain with an example.
Answer: Excel 2010 includes many math functions. Mathematical functions are used to perform wide variety of simple or complex calculations such as totaling the value for a range of cells rounding of a number.
Example: Sum( ):
Add all the number in a range of cells.
Syntax: SUM (number1, number2......) Where number1, number2,..........are up to 255 arguments.
6. Write the steps to select a cell.
Answer:
1. Click on a cell to select it. When a cell is selected you will notice that the borders of the cell appear bold and the column heading and row heading of the cell are highlighted.
2. Release your mouse. The cell will stay selected until you click on another cell in the worksheet.
7. Explain mixed cell reference.
Answer: A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row.
Some other links:
No comments:
Post a Comment