MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


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,


Previous page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15Next page

17 Comments

  1. 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.

  2. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button