MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


211. Which tool you will, use to join some cells, and place the content, at the middle of joined, cell?

a. From Format Cells, dialog box click on Merge, Cells check box

b. From Format Cells, dialog box select the, Centered alignment

c. from Format, Cells dialog box choose Merge, and Center check box

d. Click on Merge, and Center tool on formatting, toolbar

see answer

d. Click on Merge, and Center tool on formatting, toolbar


212. Tab scroll buttons, are place on Excel, Screen

a. towards the bottom right, corner

b. towards the bottom, left corner

c. towards the, top right corner

d. towards the top left corner,

see answer

b. towards the bottom, left corner


213. The Name box, on to the left of, formula bar:

a. shows the name, of workbook currently, working on

b. shows the, name of worksheet currently, working on

c. shows the, name of cell or range, currently working on,

d. None,

see answer

c. shows the, name of cell or range, currently working on,


214. Each “excel file is a workbook” that contains different, sheets. Which of the following, cannot be a sheet in, workbook?

a. work sheet,

b. chart sheet,

c. module sheet,

d. data sheet,

see answer

d. data sheet,


215. Which of the, following is not the, correct method of editing, the cell content?

a. Press the Alt ,key

b. Press the F2 key,

c. Click the, formula bar

d. Double click the, cell

see answer

a. Press the Alt ,key


216. You can merge, the main document with, data source in Excel. In mail merge operation, Word is usually:

a. server,

b. source,

c. client,

d. none,

see answer

c. client,


217. How can you update, the values of formula, cells if Auto Calculate, mode of Excel is ,disabled?

a. F8,

b. F9,

c. F10,

d. F11,

see answer

b. F9,


218. You want to set, such that when you type, Baishakh and drag the fill handle, Excel should produce, Jestha, Aashadh, and so on. What will you set to, effect that ?

a. Custom List,

b. Auto Fill Options,

c. Fill Across Worksheet,

d. Fill Series,

see answer

a. Custom List,


219. Where can you, change automatic or manual, calculation mode in,, Excel?

b. Go to Tools >> Options >> Calculation and, mark the corresponding,

a. Double CAL indicator, on status bar radio, button

c. Both,

d. None,

see answer

b. Go to Tools >> Options >> Calculation and, mark the corresponding,


220. How can you, show or hide the gridlines, in Excel Worksheet?

a. Go to Tools >> Options >> View tab and, mark or remove the check box, named Gridline

b. Click Gridline tool, on Forms toolbar,

c. Both a & b ,

d. None,

see answer

c. Both a & b ,


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