Microsoft Excel Course Mixed Topics MCQs Set 01

Practice MCQs for Computer Science MS Office

Review structured MCQ sets for Computer Science MS Office. Built according to official NCERT guidelines, these downloadable questions support daily revision and core concept reinforcement.

Access MS Office Questions and Solutions

Access the complete set of multiple-choice questions for MS Office below. This focused format allows students to isolate specific topics for thorough review and uninterrupted practice alongside official NCERT textbooks.

Thirty multiple choice questions with answers on the Excel 2007 course: the Excel window and navigation, formulas and order of calculation, formatting, functions and filling cells, printing, charts, and the SUMIF, COUNTIF, IF, AND, FREQUENCY, TREND and ZTEST functions.

Question 1: In Excel 2007 the button in the upper-left corner that opens a menu to create, open, save and print files is the
(a) Microsoft Office button
(b) Quick Access toolbar
(c) Status bar
(d) Name box
Show Answer & Explanation

Answer: (a) Microsoft Office button

Explanation:
1. The Office button menu holds the file commands.
2. The Quick Access toolbar holds frequently used commands.

Teacher's Note:
1. Office button = file menu.

Question 2: How many rows does an Excel 2007 worksheet have?
(a) 65,536
(b) 256
(c) 16,384
(d) 1,048,576
Show Answer & Explanation

Answer: (d) 1,048,576

Explanation:
1. Excel 2007 rows are numbered 1 to 1,048,576.
2. Columns run A to Z, AA, AB and so on.

Teacher's Note:
1. More than a million rows.

Question 3: Cell E10 is located in
(a) row E, column 10
(b) column 10, row E
(c) column E, row 10
(d) sheet E10
Show Answer & Explanation

Answer: (c) column E, row 10

Explanation:
1. The column letter comes first, then the row number.
2. A1 is the upper-left cell.

Teacher's Note:
1. Column letter plus row number.

Question 4: The Name box is located
(a) at the bottom of the window
(b) on the left side of the Formula bar
(c) on the Ribbon
(d) on the Title bar
Show Answer & Explanation

Answer: (b) on the left side of the Formula bar

Explanation:
1. It shows the address of the current cell.
2. Cell entries are shown on the right side of the Formula bar.

Teacher's Note:
1. Name box = cell address.

Question 5: Which bar at the bottom of the window shows the sum, average, minimum and maximum of selected numbers?
(a) Title bar
(b) Status bar
(c) Formula bar
(d) Quick Access toolbar
Show Answer & Explanation

Answer: (b) Status bar

Explanation:
1. The Status bar gives such information about the selected numbers.
2. The Title bar shows the workbook name.

Teacher's Note:
1. Status = summary at the bottom.

Question 6: Which key moves you to the beginning of the worksheet when pressed with Ctrl?
(a) Home
(b) End
(c) Page Up
(d) Tab
Show Answer & Explanation

Answer: (a) Home

Explanation:
1. Ctrl + Home goes to cell A1.
2. Page Up and Page Down move one page.

Teacher's Note:
1. Home = start.

Question 7: Which key opens the Go To dialog box?
(a) F2
(b) F8
(c) F4
(d) F5
Show Answer & Explanation

Answer: (d) F5

Explanation:
1. F5 or Ctrl + G opens Go To.
2. F2 edits a cell and F8 starts Extend mode.

Teacher's Note:
1. F5 to jump.

Question 8: Pressing F8 in a cell and then clicking another cell
(a) edits the cell
(b) deletes the cells
(c) selects the range between them
(d) prints the sheet
Show Answer & Explanation

Answer: (c) selects the range between them

Explanation:
1. F8 anchors the cursor and turns on Extend Selection.
2. Esc turns the highlighting off.

Teacher's Note:
1. F8 = extend.

Question 9: Which key edits the contents of the current cell?
(a) F5
(b) F8
(c) F2
(d) F1
Show Answer & Explanation

Answer: (c) F2

Explanation:
1. F2 puts the cell in edit mode.
2. Double-clicking the cell does the same.

Teacher's Note:
1. F2 = edit.

Question 10: Which button keeps long text inside a cell by showing it on several lines?
(a) Center
(b) Wrap Text
(c) AutoSum
(d) Cut
Show Answer & Explanation

Answer: (b) Wrap Text

Explanation:
1. Wrap Text is on the Home tab.
2. Without it the text overlaps the next cell.

Teacher's Note:
1. Wrap = fold the text.

Question 11: A formula in Excel must begin with
(a) an equal sign
(b) a plus sign only
(c) a quotation mark
(d) a colon
Show Answer & Explanation

Answer: (a) an equal sign

Explanation:
1. Formulas start with =.
2. Then operators such as + - * / ^ are used.

Teacher's Note:
1. No = no formula.

Question 12: In Excel the operator for exponentiation is
(a) *
(b) /
(c) %
(d) ^
Show Answer & Explanation

Answer: (d) ^

Explanation:
1. The caret ^ raises a number to a power.
2. * is multiplication.

Teacher's Note:
1. Caret for power.

Question 13: What is the result of =3+3+12/2*4?
(a) 36
(b) 24
(c) 90
(d) 30
Show Answer & Explanation

Answer: (d) 30

Explanation:
1. Division and multiplication come first: 12/2*4 = 24.
2. Then 3 + 3 + 24 = 30.

Teacher's Note:
1. Multiply and divide first.

Question 14: What is the result of =(3+3+12)/2*4?
(a) 30
(b) 24
(c) 36
(d) 18
Show Answer & Explanation

Answer: (c) 36

Explanation:
1. Parentheses first: 18.
2. Then 18 / 2 * 4 = 36.

Teacher's Note:
1. Brackets change the order.

Question 15: By default, numbers typed in a cell are aligned
(a) to the left
(b) to the right
(c) at the centre
(d) at the top
Show Answer & Explanation

Answer: (b) to the right

Explanation:
1. Text aligns left and numbers align right.
2. Alignment can be changed from the Home tab.

Teacher's Note:
1. Numbers right, text left.

Question 16: To delete columns F and G you click the Delete arrow in the Cells group and choose
(a) Delete Sheet Columns
(b) Delete Sheet Rows
(c) Delete Cells
(d) Delete Sheet
Show Answer & Explanation

Answer: (a) Delete Sheet Columns

Explanation:
1. After selecting the two columns this command removes them.
2. Delete Sheet Rows removes rows.

Teacher's Note:
1. Match the command to columns.

Question 17: Long text typed in A6 is cut off when
(a) cell B6 contains an entry
(b) B6 is empty
(c) A6 is bold
(d) the sheet is saved
Show Answer & Explanation

Answer: (a) cell B6 contains an entry

Explanation:
1. Text spills over only into empty cells.
2. The full text is still seen in the Formula bar.

Teacher's Note:
1. Neighbour has data, text is cut.

Question 18: The range reference A1:C3 includes how many cells?
(a) 3
(b) 6
(c) 12
(d) 9
Show Answer & Explanation

Answer: (d) 9

Explanation:
1. It covers 3 columns and 3 rows.
2. 3 x 3 = 9 cells.

Teacher's Note:
1. Columns times rows.

Question 19: The reference A7,B8:B10,C9,10 is an example of
(a) a range reference only
(b) an error
(c) a union reference
(d) a name
Show Answer & Explanation

Answer: (c) a union reference

Explanation:
1. Commas join several references or numbers.
2. A colon makes a range.

Teacher's Note:
1. Comma = union.

Question 20: What is the result of =SUM(B1:B3) when B1, B2 and B3 hold 12, 27 and 24?
(a) 51
(b) 63
(c) 36
(d) 24
Show Answer & Explanation

Answer: (b) 63

Explanation:
1. 12 + 27 + 24 = 63.
2. AVERAGE of the same cells is 21.

Teacher's Note:
1. Add them.

Question 21: What is the result of =AVERAGE(B1:B3) for 12, 27 and 24?
(a) 63
(b) 21
(c) 27
(d) 12
Show Answer & Explanation

Answer: (b) 21

Explanation:
1. 63 divided by 3 is 21.
2. MIN is 12 and MAX is 27.

Teacher's Note:
1. Sum / count.

Question 22: In the fill exercise, the small black square at the lower-right corner of the selection is called the
(a) fill handle
(b) Name box
(c) context tab
(d) AutoSum
Show Answer & Explanation

Answer: (a) fill handle

Explanation:
1. Dragging the fill handle fills a series.
2. Typing Sun and dragging gives the days of the week.

Teacher's Note:
1. Handle = drag.

Question 23: If Section 1 is typed in cell E1 and the fill handle is dragged down, the cells show
(a) Section 1 only
(b) 1, 2, 3
(c) Sunday, Monday
(d) Section 1, Section 2, Section 3 and so on
Show Answer & Explanation

Answer: (d) Section 1, Section 2, Section 3 and so on

Explanation:
1. Excel increases the number in text that ends with a number.
2. Typing 1 and 2 and dragging gives 1, 2, 3.

Teacher's Note:
1. Text plus number continues.

Question 24: Which tab holds the Margins, Orientation and Size options?
(a) Insert
(b) Data
(c) Page Layout
(d) Review
Show Answer & Explanation

Answer: (c) Page Layout

Explanation:
1. They are in the Page Setup group.
2. Wide margins and Landscape are examples.

Teacher's Note:
1. Print setup is Page Layout.

Question 25: In which group of the Page Layout tab are the Margins, Orientation and Size options?
(a) Editing
(b) Cells
(c) Page Setup
(d) Chart Layout
Show Answer & Explanation

Answer: (c) Page Setup

Explanation:
1. Page Setup group.
2. Editing and Cells belong to the Home tab.

Teacher's Note:
1. Page Setup for pages.

Question 26: The default page size of Excel is
(a) A3
(b) 8 1/2 by 11
(c) 5 by 7
(d) legal 8 1/2 by 14
Show Answer & Explanation

Answer: (b) 8 1/2 by 11

Explanation:
1. Most business correspondence uses 8 1/2 by 11 paper.
2. It can be changed with the Size option.

Teacher's Note:
1. Letter size default.

Question 27: Which chart types are available on the Insert tab?
(a) Column, line, pie, bar, area and scatter
(b) Only column
(c) Only pie
(d) Only line and bar
Show Answer & Explanation

Answer: (a) Column, line, pie, bar, area and scatter

Explanation:
1. A variety of chart types is offered.
2. Each type has sub-types.

Teacher's Note:
1. Many types.

Question 28: The three Chart Tools context tabs are
(a) Home, Insert and Data
(b) File, Edit and View
(c) Review, View and Add-Ins
(d) Design, Layout and Format
Show Answer & Explanation

Answer: (d) Design, Layout and Format

Explanation:
1. They appear when a chart is clicked.
2. They are context tabs, shown only when needed.

Teacher's Note:
1. Design, Layout, Format.

Question 29: To move a chart to its own sheet you use the Move Chart button in the
(a) Type group
(b) Chart Styles group
(c) Page Setup group
(d) Location group
Show Answer & Explanation

Answer: (d) Location group

Explanation:
1. Move Chart is in the Location group of the Design tab.
2. Choose New Sheet and type a name.

Teacher's Note:
1. Location = where the chart lives.

Question 30: Which SUMIF formula result is correct: =SUMIF(A2:A5,">160000",B2:B5) with property values 100000 to 400000 and commissions 7000 to 28000?
(a) 900000
(b) 21000
(c) 63000
(d) 28000
Show Answer & Explanation

Answer: (c) 63000

Explanation:
1. The values above 160000 are 200000, 300000 and 400000.
2. Their commissions are 14000 + 21000 + 28000 = 63000.

Teacher's Note:
1. Add the matching commissions.

MS Office Objective Questions & Solutions for Computer Science

Chapter MCQs with Answers for Computer Science

Review structured objective questions for Computer Science MS Office. Built according to official NCERT guidelines, these MCQ sets support daily revision and core concept reinforcement.

Expert Practice Material for Computer Science

Cross-reference your completed choices with comprehensive NCERT solutions for Computer Science to ensure absolute clarity across all sub-topics in this chapter.

Complete Your Chapter Revision

Explore our broader library of printable assignments, chapter notes, and mock tests designed to support continuous revision and secure higher marks in NCERT assessments.

FAQs

Where can I access latest Microsoft Excel Course Mixed Topics MCQs Set 01?

You can get most exhaustive Microsoft Excel Course Mixed Topics MCQs Set 01 for free on StudiesToday.com. These MCQs for Computer Science are updated for the 2026-27 academic session as per examination standards.

Are Assertion-Reasoning and Case-Study MCQs included in the Computer Science [current-page:node:field_class] material?

Yes, our Microsoft Excel Course Mixed Topics MCQs Set 01 include the latest type of questions, such as Assertion-Reasoning and Case-based MCQs. 50% of the paper is now competency-based.

How do practicing Computer Science MCQs help in scoring full marks in [current-page:node:field_class] exams?

By solving our Microsoft Excel Course Mixed Topics MCQs Set 01, students can improve their accuracy and speed which is important as objective questions provide a chance to secure 100% marks in the Computer Science.

Do you provide answers and explanations for Microsoft Excel Course Mixed Topics MCQs Set 01?

Yes, Computer Science MCQs for have answer key and brief explanations to help students understand logic behind the correct option as its important for 2026 competency-focused exams.

Can I practice these Computer Science [current-page:node:field_class] MCQs online?

Yes, you can also access online interactive tests for Microsoft Excel Course Mixed Topics MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.