Microsoft Excel Multiple Choice Questions and Answers
![](https://sabaqasaan.com/wp-content/uploads/2022/10/Excel-cover-1.jpg)
201. Which of the following, format you can decide, to apply or not in, Auto “Format dialog” box?
a. Number format,
b. Border format,
c. Font format,
d. All,
see answer
d. All,
202. HoW can you remove, borders applied in cells,?
a. Choose None,on Border tab of Format, cells
b. Open the list on, Border tool in Formatting, toolbar then choose first, tool (no border)
c. Both,
d. None ,
see answer
c. Both,
203. Where can you, set the shedding color, for a range of cells, in Excel?
a. Choose required, color form Patterns tab, of Format Cells dialog box,
b. Choose required, color on Fill Color tool, in Formatting toolbar,
c. Choose required, color on Fill Color tool, in drawing toolbar,
d. All ,
see answer
d. All ,
204. You can set, Page Border in Excel, from
a. From Border, tab in Format Cells, dialog box
b. From Border, tool in Formatting, toolbar
c. From Line Style, tool in Drawing toolbar, You cannot set page, border in Excel
see answer
b. From Border, tool in Formatting, toolbar
205. When all, the numbers between, 0 and 100 in a range, should be displayed ,in Red Color, apply
a. Use =ifv() function to, format the required, numbers red
b. Apply Conditional, Formatting command on, Format menu
c. Select the cells, that contain number, between 0 and 100 then click, Red color on Text, Color tool
d. All ,
see answer
b. Apply Conditional, Formatting command on, Format menu
206. You can check ,the conditions against, when applying conditional, formatting:
a. Cell value,
b. Formula,
c. Both ,
d. None,
see answer
c. Both ,
207. Which of the, following is not ,true regarding “Conditional Formatting”?
a. You can add more, than one condition to, check
b. You can set, condition to look for Bold, and apply Italics on, them.
c. You can apply, Font, border and pattern, formats that meets the, specified conditions
d. You can delete, any condition from Conditional, Formatting dialog box, if it is not required
see answer
b. You can set, condition to look for Bold, and apply Italics on, them.
208. Which of, the following is “invalid statement”?
a. Sheet tabs can be, colored
b. Some picture, can be applied as a background, of a sheet
c. You can set the, column width automatically, fit the amount of text,
d. The width of a, row and be specified, manually or fit automatically,
see answer
d. The width of a, row and be specified, manually or fit automatically,
209. You can use, the formula palette to,:
a. format cells, containing numbers,
b. “create and edit” formula containing, functions
c. enter assumptions ,data
d. copy a range of cells,
see answer
b. “create and edit” formula containing, functions
210. When a range is selected, how can you activate, the previous cell?
a. Press the Alt key,
b. Press Tab,
c. Press Enter,
d. None,
see answer
d. None,
Plenty of money-making opportunities – As more people join a community, you get to know about a lot of money-making opportunities.
The outfit is perfect 💯 https://brainsclub.at/
The long tail of the Internet gave us blogging as a communication tool. https://feeshop.cc/.
Fresh look! ’m so grateful that you’re in my car shipping ife.
toward the winners’ circle Tuesday night, including Glenn Ivey, a Democrat who crushed his opponent in car shipping Maryland, and Republican Mark Alford,
Hey, honestly your site is coming along :-), but I had a question – it’s a bit slow. Have you thought about using a different host like propel? It’d help your visitors stick around longer = more profit long term anyway. There’s a decent review on it by this guy who uses gtmetrix to test different hosting providers: https://www.youtube.com/watch?v=q6s0ciJI4W4 and the whole video has a bunch of gold in it, worth checking out.
Hi there and Happy Holidays!! It’s the season of giving and I just a quick question, are you looking to supplement your income? Maybe you’re stuck in the rat race and blogging isn’t working out too well? Or perhaps you’re retired and need a little income boost to help you cover some bills? I really think there is an AWESOME opportunity that could really help you out which I came across: https://incomecommunity.com I’ve been working from the comfort of my home this winter and supplementing my income :-). Okay, translating isn’t always the easiest, but it’s consistent and reliable. The thing I like about it is that you basically choose how much you want to work. As long as you can find 45 minutes per day, this will be worth your time. https://incomecommunity.com Hope it helps, and I hope you have a GREAT 2023!
We’ve been friends for so long I briansclub an’t We are allbriansclub Love this for you.
Your articles are very helpful to me. May I request more information?
Hello What type of information do you want from SabaqAsaan?
May I have information on the topic of your article?
Sir This website is MCQs based, and developed for preparation of different type of tests and interviews.
Thanks for posting. I really enjoyed reading it, especially because it addressed my problem. It helped me a lot and I hope it will help others too.
We must work together to create a culture of zero tolerance forWomen Safety App harassment.
The government, community, and individuals must take responsibility for ensuring safety from harassment in Women Safety AppPakistan.
I want to thank you for your assistance and this post. It’s been great.
Digital digital marketing Consultant can help small businesses create effective influencer digital marketing Consultant campaigns.