MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


221. Which of the, following Excel screen components, can NOT be turned on, or off?

a. Formula Bar,

b. Status Bar,

C. Tool Bar,

d. None ,


222. What happens, when you press “Ctrl + X” after selecting some, cells in Excel?

a. The cell content of, selected cells disappear, from cell and stored, in clipboard

b. The cells selected, are marked for Cutting,

C. The selected, cells are deleted and the, cells are shifted left

d. The selected, cells are deleted and, cells are shifted up


223. Which of the following, option is not available in, Paste Special dialog,, box?

a. Add,

b. Subtract,

C. Divide,

d. SORT,


224. Which command, will you choose to convert, a column of data into, row?

a. Cut and Paste,

b. Edit >> Paste Special >> Transpose,

c. Both ,

d. None,


225. It is acceptable to, let long text flow into ,adjacent cells on a worksheet, when:

a. data will be entered, in the adjacent cells,

b. no data will, be entered in the adjacent cells,

c. there is no, suitable abbreviation for, the text

d. there is not ,time to format the text,


226. Which of the cell ,pointer indicates you that you can, make selection?

a. Doctor’s symbol (Big Plus),

b. small thin plus icon,

C. Mouse Pointer with anchor, at the tip

d. None ,


227. Which of the, cell pointer indicates that ,you can fill series?

a. Doctor’s symbol, (Big Plus)

b. Small thin plus, icon

c. Mouse Pointer with ,anchor at the tip,

d. None,


228. Which of the cell ,pointer indicate that you, can move the content to, other cell?

a. Doctor’s symbol (Big Plus),

b. small thin plus, icon

C. Mouse Pointer with, anchor at the tip

d. None,


229. You can auto, fit the width of column, by

a. double clicking on the, column name on, column header,

b. Double click on, the cell pointer in worksheet,

c. Double clicking on column, right border on column header,

d. Double clicking on, the column left border of column, header


230. Long text can be broken, down into many lines with, In a cell. You can do this ,through

a. Wrap Text in Format >> Cells,

b. Justify in Edit >> Cells,

C. Text Wrapping in, Format >> Cells, Layout tab

d. All ,


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