MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


161. A function inside another function is called a _______________________function.

a. Nested

b. Round

C. Sum

d. Text

see answer

a. Nested


162. How should you print, a selected area of a worksheet, if you’ll want to print a, different area next time?

a. On the file menu, point to print area, and then click set print area.

b. On the file menu, click print, and then click selection under print what

C. On the view menu, click custom views, then click add

d. All of above

see answer

b. On the file menu, click print, and then click selection under print what


163. You are German, supplier still invoices for parts in, deutsche marks. How can you have, Excel convert those sums, to Euros?

a. On the Insert menu, click Symbol and from the, currency symbols subset, select the Euro sign.

b. On the tools menu, click Add-Ins, and select the Euro, Currency Tools check, box

c. Apply a selected background color

d. All ,

see answer

b. On the tools menu, click Add-Ins, and select the Euro, Currency Tools check, box


164. Which “function calculates your monthly mortage” payment,?

a. PMT (payments),

b. NPER (number of periods),

c. PV (present value),

d. All,

see answer

a. PMT (payments),


165. If you are working, in English (US), Chinese or, Japanese, Excel 2002 can speak data as, you enter it, to’ help, you verify accuracy. How do you activate, this feature?

a. Point to speech on, the tools menu, and then click show, text to speech toolbar.

b. Click validation, on the data menu

C. Point to speech on, the tools menu, and then click speech, recognition

d. All ,

see answer

a. Point to speech on, the tools menu, and then click show, text to speech toolbar.


166. Which of the following, methods cannot be used to, enter data in a cell?

a. Pressing an arrow, key

b. Pressing the, tab key

c. Pressing, the Esc key

d. Clicking the enter, button to the formula bar,

see answer

c. Pressing, the Esc key


167. Which of the, following will not set text, in selected cells to, italics?

a. Pressing Ctrl + I on the, keyboard

b. Using the Tools- Wizard – Web Form menu, item

C. Using the, Format – Cells – Font menu, item

d. None ,

see answer

b. Using the Tools- Wizard – Web Form menu, item


168. Which of thè, following meth  cannot be used to edit ,the content of cell?

a. Pressing the, Alt key

b. Clicking the formula ,bar

C. Pressing F2,

d. Double clicking the, cell

see answer

a. Pressing the, Alt key


169. Which of the, following is not an, option in the spelling, dialog box?

a. Edit,

b. lgnore,

C. lgnore all,

d. Change,

see answer

a. Edit,


170. You can quickly change, the appearance of your work, by choosing Auto Format from, the Menu:

a. Edit,

b. View,

c. Format,

d. Tools,

see answer

c. Format,


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