MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


231. MS Excel provides the, default value for step in, Fill Series dialog box

a. 0,

b. 1,

C. 5,

d. 10,


232. When a row of, data is to be converted, into columns

a. Copy the cells in row, select the same number of ,cells in row and paste

b. Copy the cells in, column then choose Edit >> Paste Special, then click Transpose, and OK

C. Copy the cells then ,go to Format >> Cells then on Alignment, tab click Transpose check, box and click OK

d. Select the cells ,then place the cell pointer ,on new cell and choose ,Edit >> Paste Special, mark Transpose check box ,and click OK.


233. “Ctrl + D” shortcut key in, Excel will is used ,for ___________________________.

a. Open the font, dialog box,

b. Apply double, underline for the active cell,

C. Fill down, in the selection,

d. None ,


234. The short cut, key Ctrl +R is used, in Excel to do _________________________.

a. Right align the, content of cell,

b. Remove the cell ,contents of selected cells,

c. Fill the selection, with active cells to the, right

d. None,


235. The command Edit >> Fill Across, Worksheet is active only, when

a. One sheet is ,selected

b. When many, sheets are selected,

C. When no sheet is, selected

d. None,


236. Which of the following, series type is not valid for, Fill Series dialog box?

a. Linear,

b. Growth,

C. Autofill,

d. Time,


237. Which of the, following you can paste, selectively using Paste, Special command?

a. Validation,

b. Formats,

C. Formulas,

d. All ,


238. Paste Special allows, some operation while you paste, to new cell. Which of the, following operation is, valid?

a. Square,

b. Percentage,

C. Goal Seek,

d. Divide,


239. Edit >> Delete, command

a. Deletes the content, of a cell

b. Deletes Formats ,of cell

c. Deletes the comment, of cell

d. Deletes, selected cells


240. To remove the content, of selected cells you must, issue command

a. Edit >> Delete,

b. Edit >> Clear >> Contents,

C. Edit >> Clear >> All,

d. Data >> Delete,


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