MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers


181. “Qtr 1, Qtr 2, Qtr 3” is an example of

a. Formula,

b. Function,

c. Series,

d. Syntax,

see answer

c. Series,


182. You can “edit existing Excel” data by pressing, the

a. F1 ,

b. F2,

c. F3,

d. F4,

see answer

b. F2,


183. The cell reference, for a range of cells that, starts in cell B1 and goes, over to column G, and down to row 10, is:

a. G1-G10,

b. B1.G10,

c. B1,G10,

d. B1:G10,

see answer

d. B1:G10,


184. A user wishes to remove, a spreadsheet from a, workbook. Which is the correct ,sequence of events that, will do this?

a. Go to File-Save, As – Save As Type Excel, worksheet

b. Right click on, the spreadsheet tab and, select DELETE

C. Right click on, the spreadsheet and select, Insert Entire Column

d. None,

see answer

b. Right click on, the spreadsheet tab and, select DELETE


185. What feature enables, you to adjust or back, solve the value in a cell, to reach a desired outcome, in a formula?

a. Goal Seek,

b. Scenario Summary, report

c. Forecasting,

d. Trend line,

see answer

d. Trend line,


186. What term, describes a background, that appears as a grainy, non-smooth surface?

a. gradient,

b. pattern,

C. solid,

d. texture,

see answer

a. gradient,


187. “Excel” is a _______________________

a. Graphic program,

b. None of these,

C. Word processor,

d. A spreadsheet,

see answer

d. A spreadsheet,


188. To create an, interactive “Pivot Table” for the web, you use a, Microsoft Office Web, component called

a. HTML,

b. Pivot Table Field, List

C. Pivot Table List,

d. Pivot Table Report,

see answer

d. Pivot Table Report,


189. Which of the, following is not a, valid Zoom percentage, in Excel?

a. 10,

b. 100,

c. 300,

d. 500,

see answer

d. 500,


190. The “spelling tool” is placed on, toolbar:

a. Standard,

b. Formatting,

C. Drawing,

d. Reviewing,

see answer

a. Standard,


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