Computer Capsule for Banking Exams MS Office MCQs Set 01

Multiple Choice Questions (MCQs) for Computer Science: Fundamentals of Computers

Access targeted multiple-choice questions for Fundamentals of Computers designed to align with the latest NCERT academic syllabus for Computer Science. These objective practice sets help students evaluate their conceptual understanding and improve exam readiness.

Practice Fundamentals of Computers MCQs for Computer Science

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

Fifty multiple choice questions with answers on MS Word, Excel and PowerPoint for banking exam computer papers. They cover formatting, page layout, mail merge, shortcut keys, formulas and functions, charts, slide shows and basic database terms.

Question 1: Which of the following is word processing software?
(a) Microsoft Word
(b) Microsoft Excel
(c) Microsoft Internet Explorer
(d) Microsoft Windows Explorer
Show Answer & Explanation

Answer: (a) Microsoft Word

Explanation:
1. Microsoft Word is the word processing program of the Office suite.
2. Excel is a spreadsheet and the other two are browsers or file managers.

Teacher's Note:
1. Word = documents, Excel = worksheets.
2. Explorer programs are not word processors.

Question 2: By default, how many worksheets are available in a new workbook in Excel 2007 and 2010?
(a) 3
(b) 8
(c) 255
(d) None of above
Show Answer & Explanation

Answer: (a) 3

Explanation:
1. A new workbook in Excel 2007 and 2010 opens with three worksheets (Sheet1 to Sheet3).
2. 255 is not the default and 8 is not used.

Teacher's Note:
1. Default sheets: 3 in classic Excel.
2. You can add more sheets as needed.

Question 3: When entering in a lot of text in capitals you should use the-
(a) Enter key
(b) Big letter key
(c) Num Lock key
(d) Caps Lock key
Show Answer & Explanation

Answer: (d) Caps Lock key

Explanation:
1. The Caps Lock key keeps all letters in capitals until it is pressed again.
2. The other keys do not lock capitals.

Teacher's Note:
1. Caps Lock = continuous capitals.
2. Shift gives capitals only while held.

Question 4: To move the text to the right side of the page you would use______
(a) Align left
(b) Align over one space
(c) Align right
(d) Align top
Show Answer & Explanation

Answer: (c) Align right

Explanation:
1. Align Right moves the text to the right side of the page.
2. Align Left does the opposite.

Teacher's Note:
1. Ctrl+R = align right.
2. Ctrl+L = left, Ctrl+E = centre.

Question 5: To save a file under a different name you should use______
(a) Save as
(b) Save
(c) Save all
(d) Save new
Show Answer & Explanation

Answer: (a) Save as

Explanation:
1. Save As lets you store a file under a new name or place.
2. Save only overwrites the existing file.

Teacher's Note:
1. Save As = new name or location.
2. Shortcut: F12.

Question 6: You would use the indent option when______
(a) You are in the middle of a document
(b) You are at the end of the document
(c) You are starting a new paragraph
(d) None of the above
Show Answer & Explanation

Answer: (c) You are starting a new paragraph

Explanation:
1. An indent moves the first line of a paragraph inward, so it is used when starting a new paragraph.
2. It has no use at the end of a document.

Teacher's Note:
1. Indent = space at the start of a paragraph.
2. Use the Tab key or the Indent button.

Question 7: To send the same document addressed to 10 different people you should use-
(a) Multiple merge
(b) Mail merge
(c) Merge
(d) None of the above
Show Answer & Explanation

Answer: (b) Mail merge

Explanation:
1. Mail Merge produces personalised copies of one document for many recipients.
2. The other options are not Word features.

Teacher's Note:
1. Mail merge = main document + data source.
2. Used for letters and labels.

Question 8: To ensure that you do not lose all of your files you should always make a
(a) Back up copy
(b) Back down
(c) Back over
(d) Back under
Show Answer & Explanation

Answer: (a) Back up copy

Explanation:
1. A backup copy keeps your files safe if the originals are lost.
2. The other phrases are meaningless.

Teacher's Note:
1. Always back up important files.
2. Keep a copy on another device.

Question 9: Landscape mode is when the paper is-
(a) Taller than it is wider
(b) Wider than it is taller.
(c) Smaller than normal
(d) Bigger than normal
Show Answer & Explanation

Answer: (b) Wider than it is taller.

Explanation:
1. In landscape orientation the page is wider than it is tall.
2. A taller page is portrait.

Teacher's Note:
1. Landscape = wide.
2. Portrait = tall.

Question 10: The ______ is an area in the top margin of each page in a document where you can insert text or graphics.
(a) Head note
(b) Top margin
(c) Footer
(d) Header
Show Answer & Explanation

Answer: (d) Header

Explanation:
1. The header is the area in the top margin of a page where text or graphics can be inserted.
2. The footer is the same at the bottom margin.

Teacher's Note:
1. Header on top, footer at bottom.
2. Used for titles and page numbers.

Question 11: To move a block of text you would use______
(a) Cut and copy
(b) Copy and paste
(c) Cut and paste
(d) Move block
Show Answer & Explanation

Answer: (c) Cut and paste

Explanation:
1. To move text you cut it from the old place and paste it at the new place.
2. Copy and paste would leave the original in its place.

Teacher's Note:
1. Cut = Ctrl+X, Paste = Ctrl+V.
2. Copy keeps the original.

Question 12: To see how a spreadsheet will print out, you should use-
(a) Page overview
(b) Page preview
(c) Page break
(d) Look at the page
Show Answer & Explanation

Answer: (b) Page preview

Explanation:
1. Page Preview (Print Preview) shows how a worksheet will look when printed.
2. The other names are not Excel features.

Teacher's Note:
1. Preview before printing.
2. Saves paper.

Question 13: What are the steps to changing the tab color in a spreadsheet?
(a) Right click on the sheet, select the color and click ok
(b) Right click on the menu bar, select the color and click yes
(c) Right click on the sheet tab, select tab color, select the color, click ok
(d) Right click and select the color.
Show Answer & Explanation

Answer: (c) Right click on the sheet tab, select tab color, select the color, click ok

Explanation:
1. Right-click the sheet tab, choose Tab Color, pick the colour and click OK.
2. The colour is set on the sheet tab, not on the menu bar.

Teacher's Note:
1. Sheet tab colour: right-click the tab.
2. It helps to group sheets.

Question 14: To keep table headings visible you can use-
(a) Hold panes
(b) Line panes
(c) Freeze panes
(d) Spreadsheet panes
Show Answer & Explanation

Answer: (c) Freeze panes

Explanation:
1. Freeze Panes keeps selected rows or columns visible while the rest of the sheet scrolls.
2. The other names do not exist.

Teacher's Note:
1. Freeze Panes is in the View tab.
2. Use it for headings.

Question 15: The values in cells A1 to A5 are all 10. If we used the Auto SUM function, what is the value of =SUM(A1:A5)?
(a) 5
(b) 50
(c) 500
(d) 100
Show Answer & Explanation

Answer: (b) 50

Explanation:
1. Five cells with 10 each add up to 5 x 10 = 50.

Teacher's Note:
1. SUM adds the values in the range.
2. A1:A5 means five cells.

Question 16: Which key deletes the character to the right of the cursor?
(a) End
(b) Home
(c) Backspace
(d) Delete
Show Answer & Explanation

Answer: (d) Delete

Explanation:
1. The Delete key erases the character to the right of the cursor.
2. Backspace erases the character to the left.

Teacher's Note:
1. Delete forward, Backspace backward.
2. Home and End move the cursor only.

Question 17: Which enables you to move directly to specific location in a document?
(a) Cross-references
(b) Outlines
(c) Subdocuments
(d) Bookmarks
Show Answer & Explanation

Answer: (d) Bookmarks

Explanation:
1. Bookmarks mark places in a document so that you can jump to them directly.
2. Cross-references and outlines do other jobs.

Teacher's Note:
1. Bookmark = named location.
2. Insert tab, Bookmark.

Question 18: How do you add a clip-art picture into your slide in MS PowerPoint 2007?
(a) File, insert, picture
(b) Insert, Picture
(c) Insert, Clipart
(d) Insert, Picture, Clipart
Show Answer & Explanation

Answer: (c) Insert, Clipart

Explanation:
1. In PowerPoint 2007 you choose the Insert tab and then Clip Art.
2. The other paths are not how clip art is added.

Teacher's Note:
1. Insert tab: Picture, Clip Art, Shapes.
2. Clip Art task pane appears on the side.

Question 19: How do you add animation/ effects to your presentation?
(a) File, Slide, Animation
(b) File, Animation
(c) Slide Show, Animation
(d) Slide Show, Custom Animation
Show Answer & Explanation

Answer: (d) Slide Show, Custom Animation

Explanation:
1. In older PowerPoint the Slide Show menu has the Custom Animation command for effects.
2. Newer versions use the Animations tab.

Teacher's Note:
1. Slide Show, Custom Animation (PowerPoint 2003).
2. Animations tab in 2007 and later.

Question 20: Which option can be used to set custom timings for slides in a presentation?
(a) Slider Timings
(b) Slider Timer
(c) Slide Show Setup
(d) Rehearsal.
Show Answer & Explanation

Answer: (d) Rehearsal.

Explanation:
1. Rehearse Timings records how long each slide stays on screen.
2. The other names do not exist.

Teacher's Note:
1. Rehearse Timings = custom slide timing.
2. Found on the Slide Show tab.

Question 21: Which key on the keyboard can be used to view Slide show?
(a) F1
(b) F2
(c) F5
(d) F10
Show Answer & Explanation

Answer: (c) F5

Explanation:
1. F5 starts the slide show from the first slide.
2. F1 opens Help and F2 edits a name.

Teacher's Note:
1. F5 = start slide show.
2. Shift+F5 starts from the current slide.

Question 22: You can print-
(a) An entire workbook
(b) A range of cells by range name
(c) A single worksheet
(d) All of the above
Show Answer & Explanation

Answer: (d) All of the above

Explanation:
1. Excel can print an entire workbook, a selected range or a single worksheet.
2. All the listed options are possible.

Teacher's Note:
1. Print what: selection, active sheets, entire workbook.
2. Define a print area for a range.

Question 23: What is the function of the autofit ?
(a) Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
(b) A way of arranging data in a particular order
(c) A symbol that represents a specific action
(d) None of the above.
Show Answer & Explanation

Answer: (a) Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

Explanation:
1. AutoFit changes the width of a column to fit the longest entry or the height of a row to fit the font.
2. The other options describe sorting and macros.

Teacher's Note:
1. Double-click the column border to AutoFit.
2. AutoFit saves manual resizing.

Question 24: When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
(a) Changes the cell format to currency with a dollar sign as the default
(b) Allows only numbers to be input into the cell
(c) Generates an error
(d) Creates an absolute reference.
Show Answer & Explanation

Answer: (d) Creates an absolute reference.

Explanation:
1. A reference like $A$1 is an absolute reference that does not change when copied.
2. It does not add currency formatting.

Teacher's Note:
1. $ locks row and column.
2. F4 cycles through reference types.

Question 25: What does the LEN() function do?
(a) All of the choices
(b) Splits the Cell contents
(c) Counts the number of characters in a cell
(d) Deletes Trailing spaces
Show Answer & Explanation

Answer: (c) Counts the number of characters in a cell

Explanation:
1. LEN counts the number of characters in a cell, including spaces.
2. Trimming spaces is done by TRIM.

Teacher's Note:
1. LEN = length.
2. TRIM removes extra spaces.

Question 26: What is the keyboard shortcut for creating a chart from the selected cells?
(a) F11
(b) F7
(c) F9
(d) F3
Show Answer & Explanation

Answer: (a) F11

Explanation:
1. F11 creates a chart on a new sheet from the selected cells.
2. F7 is spell check and F9 recalculates.

Teacher's Note:
1. F11 = chart sheet.
2. Alt+F1 = embedded chart.

Question 27: The view that puts a blue line around each page that would be printed is the ______.
(a) Print Preview
(b) Normal
(c) Page Break Preview.
(d) Split View
Show Answer & Explanation

Answer: (c) Page Break Preview.

Explanation:
1. Page Break Preview shows a blue line around each page to be printed.
2. Normal view has no such lines.

Teacher's Note:
1. Page Break Preview: blue lines.
2. Dashed line = automatic break.

Question 28: 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) B1-G10
(b) B1.G10
(c) B1;G10
(d) B1:G10
Show Answer & Explanation

Answer: (d) B1:G10

Explanation:
1. A range is written with a colon between the first and the last cell, so B1 to G10 is B1:G10.
2. Hyphen, dot and semicolon are not used.

Teacher's Note:
1. Range uses a colon.
2. Example: A1:A5.

Question 29: If you have data that runs across five columns, from column A to column E, one way to centre a title across the top of the data would be to:
(a) Type the data in A1 and Merge cells A1:A5
(b) Type the data in A1 and Merge cells A1:E1.
(c) Type the data in C1
(d) Choose Centre from the Format menu
Show Answer & Explanation

Answer: (b) Type the data in A1 and Merge cells A1:E1.

Explanation:
1. Type the title in A1 and merge A1:E1 so that it spans all five columns.
2. Merging A1:A5 would join vertical cells.

Teacher's Note:
1. Merge and Centre on the Home tab.
2. Use it for headings.

Question 30: Which function converts miles to kilometers, kilograms to pounds, and so on?
(a) Product
(b) Change
(c) Convert.
(d) All of above.
Show Answer & Explanation

Answer: (c) Convert.

Explanation:
1. The CONVERT function changes a value from one unit of measure to another, such as miles to kilometres.
2. Product and Change are not conversion functions.

Teacher's Note:
1. CONVERT(number, from_unit, to_unit).
2. Works for length, weight and more.

Question 31: You can select the current Row by pressing-
(a) Alt spacebar
(b) Shift + spacebar.
(c) Control + spacebar
(d) Shift + Tab
Show Answer & Explanation

Answer: (b) Shift + spacebar.

Explanation:
1. Shift+Spacebar selects the current row.
2. Ctrl+Spacebar selects the current column.

Teacher's Note:
1. Shift+Space = row.
2. Ctrl+Space = column.

Question 32: A function inside another function is called a ______ function.
(a) Complex
(b) Nested
(c) Round
(d) None of the above
Show Answer & Explanation

Answer: (b) Nested

Explanation:
1. A function placed inside another function is a nested function.
2. Complex and Round are not terms for this.

Teacher's Note:
1. Nested = function inside function.
2. Example: IF(SUM(A1:A5)>50,"Yes","No").

Question 33: What is the correct formula to calculate an average between cells B3 and B6?
(a) =AVERAGE(B3:B6).
(b) =AVE(B3+B4+B5+B6)/4
(c) =AVERAGE(B3+B4+B5+B6)/4
(d) =AVE(B3:B6)
Show Answer & Explanation

Answer: (a) =AVERAGE(B3:B6).

Explanation:
1. =AVERAGE(B3:B6) averages the four cells in the range.
2. AVE is not a valid Excel function.

Teacher's Note:
1. AVERAGE adds and divides by count.
2. Use a range for cells in a series.

Question 34: Which function does not exist in Excel's function library?
(a) Lower
(b) Proper
(c) Upper
(d) Uppercase.
Show Answer & Explanation

Answer: (d) Uppercase.

Explanation:
1. Excel has LOWER, PROPER and UPPER but no UPPERCASE function.
2. UPPERCASE does not exist.

Teacher's Note:
1. UPPER, LOWER, PROPER change text case.
2. Names must be exact.

Question 35: What is the keyboard shortcut for Edit a Cell in MS Excel ?
(a) F2
(b) F7
(c) F3
(d) F9
Show Answer & Explanation

Answer: (a) F2

Explanation:
1. F2 puts the active cell into edit mode.
2. F7 is spell check and F3 pastes names.

Teacher's Note:
1. F2 = edit cell.
2. F4 repeats the last action.

Question 36: Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?
(a) =SUM J:1-8
(b) =J:1+J:8
(c) =ADD(J1-J8)
(d) =SUM(J1:J8)
Show Answer & Explanation

Answer: (d) =SUM(J1:J8)

Explanation:
1. =SUM(J1:J8) adds the cells J1 to J8.
2. The other forms are not valid syntax.

Teacher's Note:
1. SUM(range).
2. Functions need brackets.

Question 37: What is the short key to enter the current date in a cell?
(a) CTRL+ ; (semicolon.)
(b) CTRL+SHIFT+: (colon)
(c) CTRL+F10
(d) None of these
Show Answer & Explanation

Answer: (a) CTRL+ ; (semicolon.)

Explanation:
1. Ctrl+; (semicolon) enters the current date in the cell.
2. Ctrl+Shift+: enters the current time.

Teacher's Note:
1. Date = Ctrl+; and time = Ctrl+Shift+:.
2. The date stays fixed once entered.

Question 38: What is the short key create a new line within a cell?
(a) CTRL+ Enter
(b) Alt + Enter
(c) CTRL+F10
(d) None of these
Show Answer & Explanation

Answer: (b) Alt + Enter

Explanation:
1. Alt+Enter starts a new line within the same cell.
2. Ctrl+Enter fills the selected cells with the same entry.

Teacher's Note:
1. Alt+Enter = line break in a cell.
2. Enter alone moves to the next cell.

Question 39: To format a cell like an already formatted one you can use --------- .
(a) The Fill down command
(b) The Format Painter command.
(c) The Autosum command
(d) None of the above.
Show Answer & Explanation

Answer: (b) The Format Painter command.

Explanation:
1. The Format Painter copies the formatting of one cell to another.
2. Fill Down copies data, and AutoSum adds numbers.

Teacher's Note:
1. Format Painter: brush icon.
2. Double-click to apply many times.

Question 40: Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
(a) Tab
(b) Formula Bar
(c) Ribbon
(d) None of the above
Show Answer & Explanation

Answer: (c) Ribbon

Explanation:
1. The Ribbon holds the commands and buttons grouped under tabs.
2. The Formula Bar shows the cell contents.

Teacher's Note:
1. Ribbon replaced menus and toolbars in 2007.
2. Tabs: Home, Insert, Page Layout.

Question 41: You can use an operator to concatenate (join) text from two cells into one cell. Which operator is that?
(a) + (Plus)
(b) $ (Dollar)
(c) Alt spacebar
(d) & (ampersand).
Show Answer & Explanation

Answer: (d) & (ampersand).

Explanation:
1. The ampersand (&) joins text from two cells.
2. The plus sign adds numbers.

Teacher's Note:
1. & = concatenate.
2. CONCATENATE function does the same.

Question 42: To open the Format Cells dialog box, press-
(a) Alt + 1
(b) Ctrl + 1
(c) Ctrl + Shift + 1
(d) F1
Show Answer & Explanation

Answer: (b) Ctrl + 1

Explanation:
1. Ctrl+1 opens the Format Cells dialog box.
2. F1 opens Help.

Teacher's Note:
1. Ctrl+1 = Format Cells.
2. Right-click, Format Cells also works.

Question 43: What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2 ( A1=5 and A2=2 )
(a) Multiply the value in A1 by the value in A2
(b) A2 is the power of A1
(c) Change cell values in A1 and A2 to text
(d) Compare the values in A1 and A2 and display the larger one
Show Answer & Explanation

Answer: (b) A2 is the power of A1

Explanation:
1. The caret (^) is the power operator, so A1^A2 is A1 raised to the power A2: 52 = 25.
2. It does not multiply or compare.

Teacher's Note:
1. ^ = exponent.
2. 52 = 25.

Question 44: Most database systems make it very easy to create a database via ?
(a) A command prompt
(b) A user interface
(c) Tabs
(d) Speech recognition
Show Answer & Explanation

Answer: (b) A user interface

Explanation:
1. Most database systems offer a user interface that makes creating a database easy.
2. Typing commands is the harder route.

Teacher's Note:
1. Access gives a graphical user interface.
2. Forms and wizards help.

Question 45: The column that contains the unique identifier is referred to as the?
(a) Secondary key
(b) Product Key
(c) Primary Key
(d) Delete Key
Show Answer & Explanation

Answer: (c) Primary Key

Explanation:
1. The primary key column holds the unique identifier of each record.
2. A secondary key need not be unique.

Teacher's Note:
1. Primary key = unique identifier.
2. No duplicates, no blanks.

Question 46: Which tab on the ribbon shows what fonts are available for use?
(a) View
(b) Page Layout
(c) Home
(d) Gate
Show Answer & Explanation

Answer: (c) Home

Explanation:
1. The Home tab has the Font group with the font list.
2. View and Page Layout do not hold the font list.

Teacher's Note:
1. Home tab = font group.
2. Font name, size, bold, italic.

Question 47: Using the ribbon, where would you go to activate the Ruler on your document?
(a) View> Toolbars
(b) File> Open
(c) View> Ruler.
(d) Insert>Reference
Show Answer & Explanation

Answer: (c) View> Ruler.

Explanation:
1. The Ruler check box is on the View tab.
2. The other paths do not turn the ruler on.

Teacher's Note:
1. View, Ruler.
2. Ruler is in the Show group.

Question 48: On what tab can you find the "columns" feature for your text?
(a) Home
(b) Insert
(c) Page Layout.
(d) View
Show Answer & Explanation

Answer: (c) Page Layout.

Explanation:
1. The Columns button is in the Page Layout tab (Page Setup group).
2. Home and Insert do not hold it.

Teacher's Note:
1. Page Layout: columns, margins, orientation.
2. Used for newspaper-style text.

Question 49: In order to select a single word in Word, how many times must you click it?
(a) 1
(b) 2
(c) 3
(d) 4
Show Answer & Explanation

Answer: (b) 2

Explanation:
1. Double-clicking a word selects it.
2. Three clicks select a paragraph.

Teacher's Note:
1. 2 clicks = word, 3 clicks = paragraph.
2. Ctrl+A selects all.

Question 50: Which bar is usually located below that Title Bar that provides categorized options?
(a) Status Bar
(b) Scroll bar
(c) Menu bar.
(d) Tool bar
Show Answer & Explanation

Answer: (c) Menu bar.

Explanation:
1. The menu bar below the title bar provides categorised options.
2. Status bar and scroll bar do other jobs.

Teacher's Note:
1. Title bar, then menu bar.
2. Status bar at the bottom.

Practice MCQs for Computer Science Fundamentals of Computers

Computer Science Fundamentals of Computers Objective Test Questions

Test your conceptual understanding of Fundamentals of Computers with these targeted multiple-choice questions. Designed in alignment with the latest NCERT curriculum for Computer Science, these problem sets build accuracy and prepare students for objective exams.

NCERT-Aligned Objective Questions and Solutions

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

Next Steps in Your Exam Preparation

Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.

FAQs

Where can I access latest Computer Capsule for Banking Exams MS Office MCQs Set 01?

You can get most exhaustive Computer Capsule for Banking Exams MS Office 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 Computer Capsule for Banking Exams MS Office 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 Computer Capsule for Banking Exams MS Office 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 Computer Capsule for Banking Exams MS Office 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 Computer Capsule for Banking Exams MS Office MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.