Skip to main content

Formulas and Functions in Excel 2013

Formulas and Functions in Excel 2013
Spreadsheets: Functions

Fill in the blanks with the correct words.
1. The ✓ button on the Formula bar works as Enter key.
2. $B7 is an example of mixed referencing.
3. Joining two strings is called concatenation.
4. Formulas can be entered on the Formula bar or in the cell.
5. The multiplication (*) and division (/) arithmetic operators have the same order of evaluation.

Write T for the true statement and F for the false one. Correct the false statement(s).
1. By default, Excel creates a relative cell reference in a formula. (T)
2. The Cancel button present near the Formula bar works as the Enter key. (F) (The Cancel button present near the Formula bar works as the Esc key)
3. The error ‘#####’ appears if the formula contains an invalid operation. (F) (The error ‘#####’ appears if the column is not wide enough to display the value)
4. All cells in rows 5 through 9 are referred as 5:9. (T)
5. In the order of evaluation, the addition operator (+) has higher precedence than the exponent operator (^). (F) (The addition operator (+) has lower precedence than the exponent operator (^))

Choose the correct option.
1. If cell B1 has the formula = A1 * $C$1 and the formula is copied to cell B2, then which of these will be the formula in B2?
a. = A2 * $C$1 b. = A1 * $C1 c. = A! * C$1 d. None of these
2. In absolute referencing, the row and column references ________ when you copy a formula.
a. change b. do not change c. sometimes change d. none of these
3. Which of these functions is used to add the values of several cells?
a. AVERAGE b. MAX c. MIN d. SUM
4. If you copy the formula = $B7 to another cell, which of these options will you observe in the result?
a. The row part remains the same.
b. The column part remains the same.
c. Both row and column parts remain the same.
d. Both row and column parts change.
5. In mixed referencing, if the row reference is relative, the column reference will be ________.
a. relative b. absolute c. either relative or absolute d. none of these

Answer the following.
1. What is the difference between the three types of cell referencing?
In relative cell referencing, the row and column references can change when we copy the formula to another cell. It is the default cell referencing.
In absolute referencing, the row and column references do not change when we copy a formula because the reference points to a fixed cell address. The $ sign is used for absolute referencing.
In mixed referencing, if the row reference is relative, the column reference will be absolute and vice versa.

2. How will you refer to the cell in column B and row 2?
We will refer to the cell in column B and row 2 as B2.

3. What do you mean by concatenation?
Concatenation is the process of joining text values.

4. When would you get the error ‘#####’ in Excel?
The ‘#####’ error indicates that the column is not wide enough to display the value.

5. Explain how to use the Insert Function in Excel 2013.
Following are the steps to use the Insert Function in Excel 2013:
a) We click on the cell in which we want to enter a formula.
b) Then we click the Insert Function option on the Formula bar.
c) Then we select the required function from the dialog box that appears.
d) We then also enter the required values that the function requires.
e) Finally, we click OK.
Labels:

Comments

Post a Comment

This site is all about helping you kids study smart because for Gen Z, studying "hard" is not enough. If you feel there is any way I could improve my posts or if you have any random suggestion that might help make this more kid friendly, please don't hesitate to drop in a comment!

Be sure to check back for my response if you've asked me a question or requested a clarification through the comment section because I do make every effort to reply to your comments here.

Popular posts from this blog

Tenses: Correct Form of the Verb Exercises: ICSE English Language

Tenses: Correct Form of the Verb Exercises: ICSE English Language ** [For other Important Links related to English Language, click here 👇 https://english-language-important-links ( It is advisable to first try and solve the answers on your own, write it down in your copies and once you're done with all the questions, check from the solutions and rectify your mistakes. This practice enables you to learn from your mistakes and helps your brain retain a vivid memory and enhances your ability of language acquisition)  In the following passage, fill in each of the numbered blanks with the correct form of the word given in brackets. Do not copy the passage, but write in correct serial order the word or phrase appropriate to the blank space. (answers below). Exercise I (0) disappeared The sun (0)_______ (disappear) behind the clouds and the sky turned grey. The wind (1)____(pick) up and a few drops of rain fell on the old tin roof. Jose (2)_____(run) inside and (3)_____(cl...
1 comment
Read more

Do as Directed: ICSE English Language

ICSE English Language: Do as Directed: Exercises with Answers for Practice  ** [If you're unable to solve some of these questions or feel the need to revise the basics and rules, click here for an easy-to-follow guideline👇 https://transformation-of-sentences-complete-guide ( It is advisable to first try and solve the answers on your own, write it down in your copies and once you're done with all the questions, check from the solutions and rectify your mistakes. This practice enables you to learn from your mistakes and helps your brain retain a vivid memory and enhances your ability of language acquisition)  1. It is probable that he will never come back. (Begin: In …) 2. He said to me, ‘Where are you going?’ (Begin: He asked me …) 3. As soon as the chief guest had arrived, the play began. (Begin: No sooner ….) 4. I was surprised at his behaviour. (Begin: His …) 5. He will certainly succeed. (Begin: He is …) 6. He is the best student in the class. (Use better inste...
Post a Comment
Read more

Class 7 Physics all Chapters

 Class 7 Selina Concise Physics Important Links: [ Click on the links alongside the given chapters to go to the post] **For notes on other subjects, Click here👉 Class 7 all Chapter Notes   **For Corrected Class Notes for Quick Revision click here:  http://class-7- all chapters-physics-corrected-class-notes Physical Quantities and Measurement:  http://physical-quantities-and-measurement Motion:  https://novakidhs.blogspot.com/2022/04/chapter-2-motion-selina-concise-for.html Energy:  http://energy-class-7-physics -Light Energy:  https://novakidhs.blogspot.com/2022/01/light-energy-concise-selina-class-7.html - Heat:  http://novakidhs.blogspot.com/2022/01/selina-concise-physics-class-7-chapter.html - Sound:  http://novakidhs.blogspot.com/2022/01/sound-selina-concise-physics-class-7.html - Electricity and Magnetism:  http://novakidhs.blogspot.com/2022/01/electricity-and-magnetism-selina.html
Post a Comment
Read more