MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


251. Which menu option, can be used to split, windows into two?

a. Format -> Window,

b. View -> Window-> Split,

c. Window -> Split,

d. View-> Split,


252. Getting data, from a cell located in a, different sheet is, called..

a. Accessing,

b. Referencing,

c. Updating,

d. Functioning,


253. Which of the, following is not a valid, data type in Excel?

a. Number,

b. Character,

C. Label,

d. Date/Time,


254. Which elements of a, worksheet can be protected, from accidental modification?

a. Contents,

b. Objects,

c. Scenarios,

d. All ,


255. A numeric value, can be treated as, label value if. Precedes, it.

a. Apostrophe (),

b. Exclamation (!),

c. Hash (#),

d. Tilde (),


256. Concatenation ,of text can be done, using:

a. Apostrophe (),

b. Exclamation (!),

c. Hash (#),

d. Ampersand (&&),


257. Which area in an, Excel window allows, entering values and, formulas?

a. Title Bar,

b. Menu Bar,

C. Formula Bar,

d. Standard Tool Bar,


258. Multiple calculations, can be made in a single, formula using:

a. Standard Formulas,

b. Array Formula,

c. Complex Formulas,

d. Smart Formula,


259. An “Excel Workbook” is a collection, of?

a. Workbooks,

b. Worksheets,

c. Charts,

d. Worksheets and Charts,


260. What do you, mean by a Work, Space?

a. Group of Columns,

b. Group of Worksheets,

C. Group of Rows,

d. Group of Workbooks,


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