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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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").
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
Free study material for Computer Science
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
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.
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.
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.
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.
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.