Advanced excel exercises for me

Advanced Excel full course 


Propagating cell contents


Practical based question


Fill a cell with ‘Nitai’. 


  1. Propagate (paste) ‘Nitai’ to 3 the cells below this cell. 

Use the keyboard only, do not use the mouse. 


Hint : Ctrl + D


  1. Propagate (paste) ‘Nitai’ to 3 the cells right to this cell. 

Use the keyboard only, do not use the mouse. 


Hint : Ctrl + R


  1. Propagate (paste) ‘Nitai’ to 3 the cells above this cell. 

Use the mouse only, do not use the keyboard. 


Hint: The mouse pointer goes to the bottom right corner of the cell and changes into a ‘+’ sign. 


  1. Propagate (paste) ‘Nitai’ to 3 the cells left to this cell. 

Use the mouse only, do not use the keyboard. 


Hint: The mouse pointer goes to the bottom right corner of the cell and changes into a ‘+’ sign. 


State true or false:


Ctrl + D allows you to propagate the value from one cell to the next cell below it. Hence, if you write ‘Nitai’ in B2, you can also propagate this value to cell B4 without filling this value to cell B3.  


Think and answer


You want to propagate ‘Nitai’ to 100 cells below this cell. If you use Ctrl + D option, it will be too time-consuming. So, how should you propagate this value?




Cut, Copy, Paste, Move Data



Question: When you cut or copy data from one cell to another cell, an animated moving margin appears around the cell. How will you remove the animation?


Ans: Press the Esc key. 



Practical based question


  1. In a cell, E3 write ‘Nitai’. Then copy it to another cell, F8.


  1. In a cell, E4 write ‘Nitai’. Then move it to another cell, F9.




Inserting rows and columns


Question: You selected column I and using the right-click option, inserted another column. 

Which of these cases is true?


  1. This new column will now be called column I and the previous column I will be shifted to the right.  


  1. This new column will now be called column J and the previous column J will be shifted to the right and become the new column K.  


  1. Either a or b is true


Question: You selected row 5 and using the right-click option, inserted another column. 

Which of these cases is true?


  1. This new column will now be called row 5 and the previous row 5 will be shifted downward.


  1. This new row will now be called row 6 and the previous row 6 will be shifted downward and become the new row 7.  


  1. Either a or b is true



Practical based question


  1. You have to insert a column between column I and column J. 

  2. You have to insert a row between row C and row D. 



Comments

Post a Comment

Popular posts from this blog

The complete banking awareness for bank exams

Image
   Here are the complete banking awareness notes for all bank exams.  What is banking? Banking is an activity. The activity involves the following: Accept deposits from the public: The bank accepts money from us, the public. Many people deposit their money with banks. When you deposit your money with the bank, you are the depositor. You deposit money means you lend money to the bank. The bank pays you interest for this loan.  Give loans: Banks give loans to the public. When you accept loans from the bank, you become a borrower. You have to pay interest to the bank. Bank will give loan to the depositor from the borrower’s money.  The bank will charge more rate of interest from the borrower than what it pays to the depositor (or lender). The surplus money will remain with the bank. It is how banks earn. The bank will now use the surplus money to pay its employees, build infrastructure, etc.  Issue cards and provide services: Banks issue debit cards and credit...
Read more

The complete banking awareness for bank exams

Image
   Here are the complete banking awareness notes for all bank exams.  What is banking? Banking is an activity. The activity involves the following: Accept deposits from the public: The bank accepts money from us, the public. Many people deposit their money with banks. When you deposit your money with the bank, you are the depositor. You deposit money means you lend money to the bank. The bank pays you interest for this loan.  Give loans: Banks give loans to the public. When you accept loans from the bank, you become a borrower. You have to pay interest to the bank. Bank will give loan to the depositor from the borrower’s money.  The bank will charge more rate of interest from the borrower than what it pays to the depositor (or lender). The surplus money will remain with the bank. It is how banks earn. The bank will now use the surplus money to pay its employees, build infrastructure, etc.  Issue cards and provide services: Banks issue debit cards and credit...
Read more

The Kulfi Seller

  short story blog blogs to read daily short story Indian short stories Indian blogger Indian blogs  THE KULFI SELLER I am a kulfi seller. I make these kulfis at my home. My wife helps me in the process. Some full fat milk and some wheat flour cooked for about an hour over the oven and the milk gets dense and thick and creamy. Then frozen in cylindrical moulds overnight. To get a cool and sweet milk dessert, the Indian version of ice cream. Then on a van I place my mud pot, cover it with a red cloth that I will keep soaking wet throughout the day. It keeps my kulfi moulds cool and frozen. And with many leaf bowls and small wooden spoons I move around the city. The sun goes up and it is hot and I am all sweaty. I ring my bell and push my van and move through the roads daily of a harsh and busy city. Children wait for my sound to ring and they come running through the balconies and doors, with pocket money coins shimmering in their hands ready to buy them kulfis. I bring smiles ...
Read more