MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


151. Except for the _______________________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result:

a. IF

b. AND,

C. OR,

d. NOT,

see answer

a. IF


152. Macros are “run” or executed from, the_____________________ menu.

a. Insert,

b. Format,

c. Tools,

d. Data,

see answer

c. Tools,


153. You can open the, consolidate dialog box by, choosing Consolidate from, the menu.

a. Insert,

b. Format,

C. Tools,

d. Data,

see answer

d. Data,


154. Each “excel file is called a workbook” because,

a. It can contain text and data

b. It can be modified

c. It can contain many sheets including worksheets and chart sheets

d. You have to work hard to create it

see answer

c. It can contain many sheets including worksheets and chart sheets


155. Which types of, charts can excel, produce?

a. Line graphs and pie, charts only

b. Only line graphs,

c. Bar charts, line, graphs and pie charts,

d. Bar charts, and line graphs only,

see answer

c. Bar charts, line, graphs and pie charts,


156. How are, data organized in a, spreadsheet?

a. Lines and spaces,

b. Layers and planes,

C. Rows and columns,

d. Height and width,

see answer

C. Rows and columns,


157. What does, the “VLOOKUP” function do?

a. Looks up text that, contain

b. Checks whether, text is the same in, one cell as in the next,

c. Finds related records,

d. All ,

see answer

c. Finds related records,


158. Gridlines:

a. May be turned, off for display but, turned on for printing,

b. May be turned, on or off for printing,

c. The be turned, off for display and, printing

d. a, b and c,

see answer

d. a, b and c,


159. You can print, only an embedded, chart by

a. Moving the chart, to a chart sheet before, you print.

b. Formatting, the chart before you, print

c. Selecting the, chart before you print,

d. a and c,

see answer

d. a and c,


160. Which of the, following is a correct, order of precedence in, a formula calculation?

a. Multiplication and division, exponential positive and, negative value

b. Multiplication and division, positive and negative values, addition and subtraction

c. Addition and subtraction, positive and negative values, exponentiation

d. None ,

see answer

d. None ,


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