MS Excel MCQS

Microsoft Excel Multiple Choice Questions and Answers

171. To protect a worksheet, you can choose Protection, and the Protect Sheet from, the _________________ menu.

a. Edit,

b. Format,

c. Tools,

d. Data,

see answer

c. Tools,


172. You can open the, Highlight Changes “dialog box” by choosing Track Changes, from the ____ Menu.

a. Edit,

b. Insert,

C. Format,

d. Tools,

see answer

d. Tools,


173. Which of the, following is not, a worksheet design, criterion?

a. Efficiency,

b. Auditability,

c. Description,

d. Clarity,

see answer

c. Description,


174. To copy, cell contents using, drag and drop, press the,

a. End key,

b. Shift key,

c. Esc key,

d. None ,

see answer

d. None ,


175. If you, press____________________________the cell accepts your typing, as its contents.

a. Enter,

b. Ctrl + Enter,

c. TAB,

d. Insert,

see answer

a. Enter,


176. The auto, fill feature:

a. Extends a sequential, series of data

b. Automatically, adds a range of cell,

c. Applies a boarder, around selected cells,

d. None ,

see answer

a. Extends a sequential, series of data


177. What is the keyboard, shortcut (button or buttons, to be pressed) for creating ,a chart from the selected ceils?

a. F7,

b. F5,

c. F7,

d. F11,

see answer

d. F11,


178. You can use, the formula palette, to:

a. format cells containing, numbers

b. create and, edit formulas containing, functions

c. entered assumptions, data

d. copy a range, of cells

see answer

b. create and, edit formulas containing, functions


179. What Pivot Table, toolbar button updates the, data in a “Pivot Table or Pivot Chart” report if the source data, changed?

a. Format Report,

b. Pivot Table,

c. Refresh Data,

d. Show Detail,

see answer

c. Refresh Data,


180. What is an, expression that tells, how the numbers in a, determined set of cells are to, be calculated?

a. Formula,

b. Field,

c. Data,

d. Query Correct Answer:,

see answer

a. Formula,


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