MS Excel Questions Answers for bank exams IBPS PO, IBPS RRB, NIACL, NICL, LIC, BOI, Bank of Baroda and other competitive exams
- Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?
A) NOT
B) OR
C) IF
D) AND
E) none of these
- Macros can be executed from the which of the following menu ?
A) format
B) home
C) insert
D) tools
E) none of these
- What function displays row data in a column or column data in a row ?
A) transpose
B) index
C) rows
D) hyperlinks
E) none of these
- You can convert existing Excel worksheet data and charts to HTML document by using the ?
A) internet assistant wizard
B) intranet wizard
C) import wizard
D) export wizard
E) None of these
- Which of the following is not a valid Zoom percentage in Excel ?
A) 10
B) 100
C) 300
D) 500
E) none of these
- MS-EXCEL can be used to automate
A) Financial statements, Business forecasting
B) Transaction registers, inventory control
C) Accounts receivable, accounts payable
D) Any of the above
E) none of these
- In Excel _______ may not contain in Formula
A) text constant
B) number constant
C) circular reference
D) all of them
E) none of these
- In Excel, by default Numeric Values appears in
A) left aligned
B) right aligned
C) center aligned
D) justify aligned
E) none of these
- What is the shortcut key to insert new sheet in current workbook?
A) F11
B) ALT+F11
C) CTRL+F11
D) SHIFT+F11
E) None of these
- What is the shortcut key to hide entire row?
A) CTRL+H
B) CTRL+R
C) CTRL+9
D) CTRL+ –
E) None of these
7/10 ty:)) Az
Thx az
8/10
Tnx
Thank you
9/10..ty Az..
I think 3rd should be ..Transpose
.question 3rd ans must be option no. one i.e. TRANSPOSE
shortcut key to insert new sheet in current workbook= alt+shift+F1
thank you team
thnxx
9/10
Thank u
Hello there, You’ve done a fantastic job. I?ll certainly digg it and personally recommend to my friends. I am sure they will be benefited from this site.
Good article. It is rather unfortunate that over the last one decade, the travel industry has already been able to to tackle terrorism, SARS, tsunamis, influenza, swine flu, as well as first ever real global tough economy. Through it the industry has proven to be powerful, resilient in addition to dynamic, obtaining new strategies to deal with misfortune. There are generally fresh problems and chance to which the sector must once more adapt and behave.
We’re a group of volunteers and starting a new scheme in our community. Your website provided us with valuable information to work on. You’ve done an impressive job and our whole community will be thankful to you.
Great blog here! Also your website loads up very fast! What host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol
Unquestionably imagine that that you said. Your favorite justification seemed to be at the web the simplest thing to understand of. I say to you, I definitely get irked while folks think about issues that they plainly do not realize about. You managed to hit the nail upon the top and outlined out the entire thing with no need side effect , people could take a signal. Will probably be again to get more. Thank you
I am so happy to read this. This is the kind of manual that needs to be given and not the accidental misinformation that’s at the other blogs. Appreciate your sharing this best doc.
Oh my goodness! an amazing article dude. Thank you Nonetheless I’m experiencing challenge with ur rss . Don?t know why Unable to subscribe to it. Is there anyone getting similar rss problem? Anybody who is aware of kindly respond. Thnkx
I believe this is among the most important info for me. And i’m satisfied studying your article. But wanna observation on some general things, The web site style is perfect, the articles is actually nice : D. Excellent task, cheers
Thank you for sharing superb informations. Your site is so cool. I’m impressed by the details that you?ve on this website. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found just the info I already searched all over the place and simply could not come across. What a great site.
It?s really a great and useful piece of information. I?m glad that you shared this useful information with us. Please keep us informed like this. Thanks for sharing.
What i don’t understood is actually how you’re now not really a lot more well-appreciated than you might be right now. You are very intelligent. You understand therefore significantly with regards to this topic, produced me in my view imagine it from numerous numerous angles. Its like men and women are not involved unless it?s something to accomplish with Girl gaga! Your personal stuffs outstanding. At all times take care of it up!
Great ? I should certainly pronounce, impressed with your website. I had no trouble navigating through all tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Excellent task..
I have taken notice that in video cameras, extraordinary detectors help to {focus|concentrate|maintain focus|target|a**** automatically. These sensors associated with some digital cameras change in in the area of contrast, while others use a beam associated with infra-red (IR) light, specially in low lighting. Higher standards cameras at times use a mixture of both systems and probably have Face Priority AF where the dslr camera can ‘See’ the face while keeping your focus only on that. Many thanks for sharing your notions on this blog site.
Thanks for any other informative web site. Where else may just I get that type of info written in such a perfect approach? I’ve a venture that I’m just now running on, and I’ve been on the glance out for such information.
hello there and thanks to your info ? I have definitely picked up something new from right here. I did on the other hand experience several technical points the usage of this website, since I skilled to reload the site many instances prior to I may get it to load properly. I had been brooding about in case your web host is OK? No longer that I am complaining, but sluggish loading circumstances times will often affect your placement in google and can damage your high quality rating if advertising and ***********|advertising|advertising|advertising and *********** with Adwords. Anyway I am including this RSS to my email and could look out for a lot more of your respective fascinating content. Make sure you update this once more very soon..
I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thank you again
We are the Worlds Largest Cannabis Seedbank with over 100,000 marijuana seed strains in stock.
Thanks for the several tips contributed on this blog site. I have realized that many insurance firms offer customers generous discount rates if they decide to insure more and more cars with them. A significant quantity of households currently have several cars these days, particularly those with older teenage young children still located at home, as well as savings upon policies can easily soon increase. So it is a good idea to look for a good deal.
I’m often to running a blog and i really respect your content. The article has really peaks my interest. I’m going to bookmark your site and maintain checking for brand new information.
I think this is one of the such a lot vital information for me. And i am satisfied reading your article. But want to statement on few common issues, The site style is wonderful, the articles is in reality nice : D. Excellent process, cheers
The very crux of your writing while sounding reasonable initially, did not really sit well with me personally after some time. Somewhere within the sentences you actually managed to make me a believer unfortunately just for a while. I however have got a problem with your jumps in assumptions and you would do nicely to help fill in all those breaks. If you actually can accomplish that, I could undoubtedly be amazed.
I?m no longer certain where you’re getting your information, however good topic. I needs to spend some time finding out more or working out more. Thank you for excellent info I was on the lookout for this information for my mission.
Thank you for the sensible critique. Me and my neighbor were just preparing to do a little research about this. We got a grab a book from our local library but I think I learned more clear from this post. I am very glad to see such fantastic information being shared freely out there.
An additional issue is that video games can be serious naturally with the main focus on finding out rather than leisure. Although, it has an entertainment aspect to keep your sons or daughters engaged, each and every game is generally designed to develop a specific skill set or course, such as math concepts or science. Thanks for your publication.
An impressive share, I just given this onto a colleague who was doing a little bit analysis on this. And he in fact bought me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading more on this topic. If possible, as you turn out to be expertise, would you mind updating your weblog with more particulars? It is highly useful for me. Massive thumb up for this blog put up!
Helpful info. Lucky me I discovered your site accidentally, and I am shocked why this accident did not came about earlier! I bookmarked it.
Magnificent goods from you, man. I have consider your stuff previous to and you are just too great. I really like what you have acquired here, really like what you’re saying and the best way by which you are saying it. You are making it entertaining and you still take care of to keep it sensible. I cant wait to read much more from you. That is actually a great website.
One other important component is that if you are a senior, travel insurance pertaining to pensioners is something that is important to really consider. The mature you are, a lot more at risk you will be for getting something awful happen to you while in foreign countries. If you are definitely not covered by many comprehensive insurance, you could have several serious difficulties. Thanks for discussing your ideas on this website.
Fantastic beat ! I wish to apprentice while you amend your site, how could i subscribe for a blog website? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear idea
I?ll immediately grab your rss as I can not find your e-mail subscription link or newsletter service. Do you have any? Please let me know so that I could subscribe. Thanks.
Unquestionably believe that that you said. Your favourite justification appeared to be at the internet the simplest factor to remember of. I say to you, I definitely get irked while other people think about concerns that they plainly do not know about. You controlled to hit the nail upon the highest and also defined out the entire thing without having side-effects , other folks could take a signal. Will probably be again to get more. Thank you
This web site is really a walk-by means of for the entire info you wished about this and didn?t know who to ask. Glimpse right here, and you?ll definitely discover it.
Good write-up, I?m normal visitor of one?s site, maintain up the nice operate, and It is going to be a regular visitor for a long time.
Hi! I know this is kinda off topic nevertheless I’d figured I’d ask. Would you be interested in trading links or maybe guest authoring a blog article or vice-versa? My blog covers a lot of the same subjects as yours and I think we could greatly benefit from each other. If you’re interested feel free to shoot me an e-mail. I look forward to hearing from you! Wonderful blog by the way!
Great information shared.. really enjoyed reading this post thank you author for sharing this post .. appreciated
It is indeed my belief that mesothelioma is most lethal cancer. It contains unusual qualities. The more I look at it the more I am confident it does not behave like a true solid flesh cancer. In the event mesothelioma is really a rogue virus-like infection, then there is the chance of developing a vaccine along with offering vaccination to asbestos exposed people who are at high risk connected with developing future asbestos associated malignancies. Thanks for sharing your ideas about this important ailment.
Hi there, I found your website via Google while looking for a related topic, your website came up, it looks good. I have bookmarked it in my google bookmarks.
I do not even understand how I ended up here, but I assumed this publish used to be great
Wow that was odd. I just wrote an extremely long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Anyways, just wanted to say great blog!
Hi there, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam remarks? If so how do you reduce it, any plugin or anything you can recommend? I get so much lately it’s driving me crazy so any support is very much appreciated.
One more issue is that video games are generally serious as the name indicated with the main focus on mastering rather than amusement. Although, it has an entertainment feature to keep your sons or daughters engaged, each one game is frequently designed to develop a specific skill set or programs, such as math or science. Thanks for your posting.
There is definately a lot to find out about this subject. I like all the points you made
I don?t even know the way I stopped up here, but I assumed this post was good. I don’t realize who you are however definitely you’re going to a famous blogger in the event you are not already 😉 Cheers!
Awesome! Its genuinely remarkable post, I have got much clear idea regarding from this post
Thanks for the article. I have always seen that a lot of people are needing to lose weight simply because they wish to look slim and attractive. However, they do not generally realize that there are more benefits so that you can losing weight as well. Doctors declare that fat people have problems with a variety of health conditions that can be directly attributed to the excess weight. The great thing is that people who are overweight along with suffering from different diseases are able to reduce the severity of the illnesses simply by losing weight. You possibly can see a constant but notable improvement with health as soon as even a bit of a amount of fat loss is attained.
I?m not sure where you’re getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for magnificent info I was looking for this information for my mission.
Have you ever considered creating an e-book or guest authoring on other blogs? I have a blog based on the same topics you discuss and would really like to have you share some stories/information. I know my subscribers would appreciate your work. If you’re even remotely interested, feel free to shoot me an email.
great post, very informative. I wonder why the other experts of this sector do not notice this. You should continue your writing. I am sure, you have a huge readers’ base already!
Awesome! Its genuinely remarkable post, I have got much clear idea regarding from this post
I really like your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to construct my own blog and would like to find out where u got this from. thanks
The things i have observed in terms of computer system memory is that there are technical specs such as SDRAM, DDR and the like, that must fit in with the specific features of the mother board. If the pc’s motherboard is pretty current and there are no computer OS issues, updating the storage space literally normally requires under an hour or so. It’s one of several easiest pc upgrade procedures one can imagine. Thanks for sharing your ideas.
hi!,I like your writing very a lot! share we communicate more approximately your post on AOL? I require a specialist in this area to unravel my problem. May be that’s you! Taking a look forward to see you.
Hi there, You’ve done a great job. I will definitely digg it and personally recommend to my friends. I am sure they will be benefited from this web site.
This design is wicked! You obviously know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job. I really loved what you had to say, and more than that, how you presented it. Too cool!
It’s best to take part in a contest for probably the greatest blogs on the web. I’ll suggest this site!
fantastic post, very informative. I wonder why the other specialists of this sector don’t notice this. You should continue your writing. I’m confident, you’ve a huge readers’ base already!
I’ve observed that in the world these days, video games are classified as the latest rage with children of all ages. There are occassions when it may be unattainable to drag your kids away from the video games. If you want the best of both worlds, there are various educational games for kids. Great post.
Howdy! I simply want to give a huge thumbs up for the good data you’ve gotten right here on this post. I will be coming back to your weblog for extra soon.
Excellent post. I was checking constantly this blog and I am impressed! Very useful info particularly the last part 🙂 I care for such info much. I was seeking this certain info for a very long time. Thank you and best of luck.
Hi, i believe that i noticed you visited my web site thus i came to ?return the desire?.I am attempting to to find issues to improve my web site!I guess its adequate to use some of your concepts!!
It?s really a nice and useful piece of information. I am glad that you shared this useful information with us. Please keep us up to date like this. Thanks for sharing.
Nice post. I was checking constantly this blog and I am impressed! Very helpful information specially the last part 🙂 I care for such information much. I was seeking this certain information for a very long time. Thank you and good luck.
I will right away grab your rss as I can not find your e-mail subscription link or e-newsletter service. Do you have any? Please let me know in order that I could subscribe. Thanks.
Useful info. Fortunate me I found your site accidentally, and I am stunned why this coincidence didn’t came about earlier! I bookmarked it.
Terrific work! This is the type of information that should be shared around the net. Shame on the search engines for not positioning this post higher! Come on over and visit my website . Thanks =)
Excellent blog you have got here.. It’s difficult to find excellent writing like yours these days. I honestly appreciate people like you! Take care!!
Thanks for this excellent article. One other thing is that most digital cameras can come equipped with a zoom lens so that more or less of the scene to become included by way of ‘zooming’ in and out. Most of these changes in {focus|focusing|concentration|target|the a**** length will be reflected inside viewfinder and on massive display screen right at the back of the very camera.
I don?t even know the way I ended up right here, but I assumed this submit used to be great. I do not realize who you are however definitely you are going to a well-known blogger should you aren’t already 😉 Cheers!
Thanks for the suggestions you have contributed here. On top of that, I believe there are many factors which really keep your car insurance policy premium all the way down. One is, to contemplate buying vehicles that are inside the good list of car insurance companies. Cars that happen to be expensive tend to be more at risk of being snatched. Aside from that insurance policies are also depending on the value of the car, so the higher priced it is, then higher this premium you spend.
magnificent points altogether, you just gained a new reader. What would you suggest about your post that you made a few days ago? Any positive?
I was able to find good info from your content.
Thanks for the guidelines shared on your blog. Yet another thing I would like to mention is that losing weight is not all about going on a dietary fad and trying to shed as much weight as you’re able in a set period of time. The most effective way to burn fat is by getting it slowly and right after some basic suggestions which can help you to make the most from your attempt to slim down. You may understand and be following some tips, yet reinforcing understanding never hurts.
You made some decent points there. I checked on the web for more info about the issue and found most individuals will go along with your views on this site.
I have figured out some new elements from your web-site about personal computers. Another thing I’ve always considered is that computers have become a product that each residence must have for several reasons. They provide convenient ways to organize households, pay bills, search for information, study, focus on music and in many cases watch tv programs. An innovative approach to complete many of these tasks has been a notebook computer. These pcs are mobile, small, potent and mobile.
I haven?t checked in here for some time as I thought it was getting boring, but the last few posts are good quality so I guess I?ll add you back to my daily bloglist. You deserve it my friend 🙂
What?s Happening i am new to this, I stumbled upon this I have discovered It positively useful and it has aided me out loads. I am hoping to contribute & assist different users like its helped me. Good job.
Heya i am for the primary time here. I found this board and I to find It truly useful & it helped me out much. I’m hoping to give one thing back and aid others such as you aided me.
You ought to be a part of a contest for one of the finest blogs on the net. I’m going to recommend this blog!
Your style is very unique compared to other folks I have read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I will just bookmark this site.
I can’t express how much I appreciate the effort the author has put into producing this outstanding piece of content. The clarity of the writing, the depth of analysis, and the plethora of information offered are simply impressive. His enthusiasm for the subject is evident, and it has certainly resonated with me. Thank you, author, for offering your insights and enlightening our lives with this extraordinary article!
It’s difficult to find well-informed people on this topic, but you seem like you know what you’re talking about! Thanks
I know this if off topic but I’m looking into starting my own weblog and was curious what all is needed to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet smart so I’m not 100 certain. Any tips or advice would be greatly appreciated. Cheers
Greetings! I’ve been following your blog for some time now and finally got the bravery to go ahead and give you a shout out from Kingwood Tx! Just wanted to mention keep up the great work!
Awesome blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your design. Thanks a lot
Pretty section of content. I simply stumbled upon your website and in accession capital to assert that I acquire actually loved account your weblog posts. Anyway I?ll be subscribing to your feeds or even I achievement you get entry to persistently rapidly.
Thanks a bunch for sharing this with all of us you actually know what you are talking about! Bookmarked. Please also visit my site =). We could have a link exchange arrangement between us!
You are so interesting! I do not think I’ve truly read a single thing like this before. So nice to find another person with original thoughts on this subject matter. Really.. thank you for starting this up. This website is one thing that’s needed on the internet, someone with a little originality.
This actually answered my drawback, thank you!
Really appreciate you sharing this blog post. Will read on…
Today, with all the fast way of living that everyone is having, credit cards have a huge demand throughout the market. Persons from every area of life are using credit card and people who aren’t using the credit cards have made arrangements to apply for 1. Thanks for revealing your ideas about credit cards.
I’m truly enjoying the design and layout of your website. It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a developer to create your theme? Great work!
You ought to take part in a contest for one of the most useful sites on the internet. I am going to recommend this web site!
Whoa! This blog looks exactly like my old one! It’s on a completely different subject but it has pretty much the same layout and design. Great choice of colors!
尼卡西奥公司 III 作弊者
Hmm is anyone else having problems with the images on this blog loading? I’m trying to find out if its a problem on my end or if it’s the blog. Any responses would be greatly appreciated.
Howdy! This post couldn’t be written much better! Going through this article reminds me of my previous roommate! He constantly kept preaching about this. I most certainly will forward this information to him. Pretty sure he’ll have a great read. I appreciate you for sharing!
Fantastic article post.Really looking forward to read more. Fantastic.
Howdy! I could have sworn I’ve been to this website before but after going through a few of the articles I realized it’s new to me. Regardless, I’m definitely happy I came across it and I’ll be bookmarking it and checking back frequently!
Really enjoyed this article post.Much thanks again. Keep writing.
Thank you for your article.Really looking forward to read more. Cool.
Im grateful for the post.Thanks Again. Really Great.
Very good article.Really thank you! Much obliged.
I loved your blog article.Really thank you! Awesome.
Hello There. I discovered your weblog the use of msn. That is an extremely smartly written article. I?ll make sure to bookmark it and return to read more of your helpful info. Thank you for the post. I will certainly return.
Major thankies for the blog post.Really looking forward to read more. Keep writing.
I beloved up to you will receive performed right here. The caricature is attractive, your authored subject matter stylish. nonetheless, you command get got an impatience over that you would like be handing over the following. in poor health certainly come more beforehand once more as exactly the similar just about a lot ceaselessly inside of case you shield this increase.
One more thing to say is that an online business administration training course is designed for college students to be able to well proceed to bachelor’s degree programs. The Ninety credit education meets the lower bachelor education requirements and once you earn your current associate of arts in BA online, you should have access to the latest technologies on this field. Some reasons why students want to be able to get their associate degree in business is because they are interested in the field and want to receive the general training necessary in advance of jumping to a bachelor education program. Thanks for the tips you provide as part of your blog.
This is one awesome article post.Really looking forward to read more. Will read on…
Thanks a lot for sharing this with all of us you actually know what you’re talking about! Bookmarked. Please also visit my site =). We could have a link exchange arrangement between us!
Another thing I’ve really noticed is for many people, low credit score is the reaction to circumstances above their control. As an example they may be really saddled with illness and as a consequence they have large bills going to collections. It may be due to a employment loss or even the inability to go to work. Sometimes divorce process can really send the money in an opposite direction. Thanks for sharing your opinions on this weblog.
I’m very happy to read this. This is the kind of manual that needs to be given and not the accidental misinformation that is at the other blogs. Appreciate your sharing this greatest doc.
Great post! We will be linking to this particularly great article on our website. Keep up the great writing.
I?m impressed, I have to say. Really rarely do I encounter a blog that?s both educative and entertaining, and let me inform you, you have got hit the nail on the head. Your idea is outstanding; the problem is something that not enough individuals are speaking intelligently about. I’m very blissful that I stumbled across this in my seek for something regarding this.
Im thankful for the post.Really looking forward to read more. Really Great.
Things i have observed in terms of computer system memory is the fact that there are technical specs such as SDRAM, DDR and the like, that must match the specs of the mother board. If the personal computer’s motherboard is very current and there are no main system issues, changing the storage space literally usually takes under one hour. It’s one of the easiest pc upgrade treatments one can visualize. Thanks for spreading your ideas.
hello there and thank you for your information ? I?ve definitely picked up anything new from right here. I did however expertise some technical points using this site, as I experienced to reload the site lots of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I am complaining, but slow loading instances times will often affect your placement in google and could damage your high-quality score if ads and marketing with Adwords. Anyway I?m adding this RSS to my e-mail and could look out for much more of your respective exciting content. Make sure you update this again very soon..
Your place is valueble for me. Thanks!?
This excellent website truly has all of the info I wanted about this subject and didn’t know who to ask.
I would also like to add when you do not actually have an insurance policy or you do not form part of any group insurance, you could well reap the benefits of seeking assistance from a health broker. Self-employed or people having medical conditions generally seek the help of one health insurance brokerage. Thanks for your post.
Im obliged for the blog.Really looking forward to read more.
Major thanks for the blog.Really thank you! Really Cool.
I have taken notice that in unwanted cameras, specialized detectors help to {focus|concentrate|maintain focus|target|a**** automatically. These sensors of some cameras change in in the area of contrast, while others work with a beam involving infra-red (IR) light, particularly in low light. Higher specification cameras oftentimes use a mixture of both models and probably have Face Priority AF where the digital camera can ‘See’ your face and focus only in that. Thank you for sharing your notions on this blog.
Its like you learn my mind! You seem to grasp a lot approximately this, like you wrote the e-book in it or something. I believe that you could do with a few p.c. to power the message home a bit, but other than that, that is fantastic blog. An excellent read. I will certainly be back.