Quick Quiz
Questions ▼
Computer Science MCQ Practice Test with Answers. We covered all the Computer Science MCQ Practice Test with Answers in this post for free so that you can practice well for the exam.
Install our MCQTUBE Android app from the Google Play Store and prepare for any competitive government exams for free.
These types of competitive MCQs appear in exams like SSC, Railway, Bank, Delhi Police, UPSSSC, UPSC (Pre), State PCS, CDS, NDA, Assistant Commandant, and other Competitive Examinations, etc.
We created all the competitive exam MCQs into several small posts on our website for your convenience.
You will get their respective links in the related posts section provided below.
Related Posts:
- Free Computer MCQ Quiz for Practice
- Computer MCQ Practice Tests Online
- How to Prepare for Computer MCQ Exams
Computer Science MCQ Practice Test with Answers for Students
If you are working in English (US), Chinese, or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
(a) Point to Speech on the Tools menu & then click Show Text to Speech Toolbar
(b) Click Validation on the Data menu
(c) Point to Speech on the Tools menu & then click Speech Recognition
(d) All of the above
Option a – Point to Speech on the Tools menu & then click Show Text to Speech Toolbar
Which of the following methods cannot be used to enter data in a cell? ( Computer Science MCQ Practice Test with Answers )
(a) Pressing an arrow key
(b) Pressing the Tab key
(c) Pressing the Esc key
(d) Clicking the Enter button in the formula bar
Option c – Pressing the Esc key
When you insert an Excel file into a Word document, the data are:
(a) Hyperlinked
(b) Placed in a Word table
(c) Linked
(d) Embedded
Option c – Linked
Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result: ( Computer Science MCQ Practice Test with Answers )
(a) IF
(b) AND
(c) OR
(d) NOT
Option a – IF
Macros are “run” or executed from the ….. menu:
(a) Insert
(b) Format
(c) Tools
(d) Data
Option c – Tools
You can open the Consolidate dialog box by choosing Consolidate from the ….. menu:
(a) Insert
(b) Format
(c) Tools
(d) Data
Option d – Data
Each Excel file is called a workbook because: ( Computer Science MCQ Practice Test with Answers )
(a) It can contain text & data
(b) It can be modified
(c) It can contain many sheets, including worksheets & chart sheets
(d) You have to work hard to create it
Option c – It can contain many sheets, including worksheets & chart sheets
Which types of charts can Excel produce?
(a) Line graphs & pie charts only
(b) Only line graphs
(c) Bar charts, line graphs & pie charts
(d) Bar charts & line graphs only
Option c – Bar charts, line graphs & pie charts
How are data organized in a spreadsheet? ( Computer Science MCQ Practice Test with Answers )
(a) Lines & spaces
(b) Layers & planes
(c) Rows & columns
(d) Height & width
Option c – Rows & columns
What does the VLOOKUP function do?
(a) Looks up text that contains ‘v’
(b) Checks whether text is the same in one cell as in the next
(c) Finds related records
(d) All of the above
Option c – Finds related records
Gridlines: ( Computer Science MCQ Practice Test with Answers )
(a) May be turned off for display but turned on for printing
(b) May be turned on or off for printing
(c) Can be turned off for both display & printing
(d) (a), (b), & (c)
Option d – (a), (b), & (c)
You can print only an embedded chart by:
(a) Moving the chart to a chart sheet before printing
(b) Formatting the chart before printing
(c) Selecting the chart before printing
(d) (a) & (c)
Option d – (a) & (c)
Which of the following is the correct order of precedence in formula calculation?
(a) Multiplication & division, exponential, positive & negative values
(b) Multiplication & division, positive & negative values, addition & subtraction
(c) Addition & subtraction, positive & negative values, exponentiation
(d) None of the above
Option d – None of the above
A function inside another function is called a: ( Computer Science MCQ Practice Test with Answers )
(a) Nested function
(b) Round function
(c) Sum function
(d) Text function
Option a – Nested function
How should you print a selected area of a worksheet if you’ll want to print a different area next time?
(a) On the File menu, point to Print Area & then click Set Print Area
(b) On the File menu, click Print & then click Selection under Print What
(c) On the View menu, click Custom Views, then click Add
(d) All of the above
Option b – On the File menu, click Print & then click Selection under Print What
Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros? ( Computer Science MCQ Practice Test with Answers )
(a) On the Insert menu, click Symbol & from the Currency Symbols subset, select the Euro sign
(b) On the Tools menu, click Add-Ins & select the Euro Currency Tools check box
(c) Apply a selected background color
(d) All of the above
Option b – On the Tools menu, click Add-Ins & select the Euro Currency Tools check box
Which function calculates your monthly mortgage payment?
(a) PMT (payments)
(b) NPER (number of periods)
(c) PV (present value)
(d) All of the above
Option a – PMT (payments)
Got functions? No? You need the Insert Function dialog box. How do you get it? ( Computer Science MCQ Practice Test with Answers )
(a) Right-click a cell & then click Insert
(b) Click the Insert menu & then click Function
(c) Type = in a cell
(d) All of the above
Option b – Click the Insert menu & then click Function
Which of the following describes how to select all the cells in a single column?
(a) Right-click on the column & select Pick from List
(b) Use the Data → Text to Columns menu item
(c) Left-click on the gray column title button
(d) Press Ctrl + A on the keyboard
Option c – Left-click on the gray column title button
When you see a cell with a red triangle in the top-right corner, what does this signify? ( Computer Science MCQ Practice Test with Answers )
(a) There is an error in the cell
(b) There is a comment associated with the cell
(c) The font color for text in the cell is red
(d) A formula cannot be entered into the cell
Option b – There is a comment associated with the cell
To hold row and column titles in place so that they do not scroll when you scroll a worksheet, click the:
(a) Unfreeze Panes command on the Window menu
(b) Freeze Panes command on the Window menu
(c) Hold Titles command on the Edit menu
(d) Split command on the Window menu
Option b – Freeze Panes command on the Window menu
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? ( Computer Science MCQ Practice Test with Answers )
(a) Use Ctrl to select all three cells, then click the Paste button on the Standard toolbar
(b) Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify
(c) Click Format Painter on the Formatting toolbar twice, then click in each cell you want to copy the formatting to
(d) All of the above
Option c – Click Format Painter on the Formatting toolbar twice, then click in each cell you want to copy the formatting to
To edit data in an embedded Excel worksheet object in a Word document:
(a) Use the Excel menu bar & toolbars inside the Word application
(b) Edit the hyperlink
(c) Edit the data in the Excel source application
(d) Use the Word menu bar & toolbars
Option a – Use the Excel menu bar & toolbars inside the Word application
Status indicators are located on the: ( Computer Science MCQ Practice Test with Answers )
(a) Vertical scroll bar
(b) Horizontal scroll bar
(c) Formula bar
(d) Formatting toolbar
Option c – Formula bar
You can open the Scenario Manager dialog box by choosing Scenarios from the ….. menu:
(a) View
(b) Insert
(c) Format
(d) Tools
Option d – Tools
You can open the Sort dialog box by choosing Sort from the ….. menu:
(a) View
(b) Format
(c) Tools
(d) Data
Option d – Data
When working in the Page Break Preview, you can:
(a) View exactly where each page break occurs
(b) Add or remove page breaks
(c) Change the print area
(d) All of the above
Option d – All of the above
A data map is helpful:
(a) When you have too much data to chart
(b) To show a geographic distribution of data
(c) To compare data points
(d) To show changes in data over time
Option b – To show a geographic distribution of data
Rounding errors can occur:
(a) When you use multiplication, division, or exponentiation in a formula
(b) When you use addition & subtraction in a formula
(c) Because Excel uses hidden decimal places in computation
(d) When you show the results of formulas with different decimal places than the calculated results
Option a – When you use multiplication, division, or exponentiation in a formula
You can copy data or formulas:
(a) With the Copy, Paste & Cut commands on the Edit menu
(b) With commands on a shortcut menu
(c) With buttons on the Standard toolbar
(d) All of the above
Option d – All of the above
You can activate a cell by:
(a) Pressing the Tab key
(b) Clicking the cell
(c) Pressing an arrow key
(d) All of the above
Option d – All of the above
Which of the following setup options cannot be set in the Page Setup dialog box?
(a) Printer selection
(b) Vertical or horizontal placement
(c) Orientation
(d) Row and column titles
Option a – Printer selection
What term refers to a specific set of values saved with the workbook?
(a) Range
(b) Scenario
(c) Trend line
(d) What-if analysis
Option b – Scenario
You can use drag-and-drop to embed Excel worksheet data in a Word document:
(a) By dragging a range of Excel data to the Word button on the taskbar while pressing the Ctrl key
(b) By dragging a range of Excel data to the Word button on the taskbar while pressing the Shift key
(c) By dragging a range of Excel data to the Word button on the taskbar while pressing the Alt key
(d) None of the above
Option a – By dragging a range of Excel data to the Word button on the taskbar while pressing the Ctrl key
The Auto Calculate feature:
(a) Can only add values in a range of cells
(b) Provides a quick way to view the result of an arithmetic operation on a range of cells
(c) Automatically creates formulas & adds them to a worksheet
(d) A & C
Option b – Provides a quick way to view the result of an arithmetic operation on a range of cells
Excel uniquely identifies cells within a worksheet with a cell name:
(a) Cell names
(b) Column numbers & row letters
(c) Column letters & row numbers
(d) Cell locator coordinates
Option c – Column letters & row numbers
Tab scrolling button:
(a) Allows you to view a different worksheet
(b) Allows you to view additional worksheet rows down
(c) Allows you to view additional worksheet columns to the right
(d) Allows you to view additional sheets tabs
Option d – Allows you to view additional sheets tabs
A numeric value can be treated as a label value if it precedes with:
(a) Apostrophe (‘)
(b) Exclamation (!)
(c) Hash (#)
(d) Ampersand (&)
Option a – Apostrophe (‘)
Concatenation of text can be done using:
(a) Apostrophe (‘)
(b) Exclamation (!)
(c) Hash (#)
(d) Ampersand (&)
Option d – Ampersand (&)
Data can be arranged in a worksheet in an easy-to-understand manner using:
(a) Auto Formatting
(b) Applying Styles
(c) Changing Fonts
(d) All of the above
Option d – All of the above
You can select a single range of cells by:
(a) Clicking the upper-left cell in a group of cells & then pressing the Shift key while clicking the lower-right cell in a group of cells
(b) Pressing the Ctrl key while dragging over the desired cells
(c) Pressing the Shift key & an arrow key
(d) Dragging over the desired cells
Option d – Dragging over the desired cells
Which elements of a worksheet can be protected from accidental modification?
(a) Contents
(b) Objects
(c) Scenarios
(d) All of the above
Option d – All of the above
You can use the drag & drop method to:
(a) Copy cell contents
(b) Move cell contents
(c) Add cell contents
(d) A & B
Option d – A & B
It is acceptable to let long text flow into adjacent cells on a worksheet when:
(a) Data will be entered in the adjacent cells
(b) No data will be entered in the adjacent cells
(c) There is no suitable abbreviation of the text
(d) There is not enough time to format the text
Option b – No data will be entered in the adjacent cells
How can you delete a record?
(a) Delete the column from the worksheet
(b) Select Data > Form from the menu to open the Data Form dialog box, find the record, and click the Delete button
(c) Select Data > Delete Record from the menu
(d) Click the Delete button on the Standard toolbar
Option b – Select Data > Form from the menu to open the Data Form dialog box, find the record, and click the Delete button
The numbers in your worksheet look like this: 1000. You want them to look like this: $1,000. How can you accomplish this?
(a) None of these
(b) Select Format > Money from the menu
(c) Click the Currency Style button on the formatting toolbar
(d) Retype everything and manually add dollar signs, commas, and decimals
Option c – Click the Currency Style button on the formatting toolbar
Which of the following is not a valid data type in Excel?
(a) Number
(b) Character
(c) Label
(d) Date/Time
Option b – Character
Excel worksheet cells work very similarly to which common element of the Windows graphical user interface?
(a) Option buttons
(b) List boxes
(c) Text boxes
(d) Combo boxes
Option c – Text boxes
Which of the following options is not located in the Page Setup dialog box?
(a) Page Break Preview
(b) Page Orientation
(c) Margins
(d) Headers & Footers
Option a – Page Break Preview
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
(a) Pie chart
(b) Row chart
(c) Line chart
(d) Column chart
Option c – Line chart
Without using the mouse or arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
(a) Press Ctrl + Home
(b) Press Home
(c) Press Shift + Home
(d) Press Alt + Home
Option a – Press Ctrl + Home
Which of the following methods cannot be used to edit the contents of a cell?
(a) Press the Alt key
(b) Clicking the formula bar
(c) Pressing the F2 key
(d) Double-clicking the cell
Option a – Press the Alt key
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into the cell, you:
(a) Press the Erase key
(b) Press Esc
(c) Press the Enter button
(d) Press the Edit Formula button
Option b – Press Esc
To view a cell comment:
(a) Click the Edit Comment command on the Insert menu
(b) Click the Display Comment command on the Window menu
(c) Position the mouse pointer over the cell
(d) Click the Comment command on the View menu
Option c – Position the mouse pointer over the cell
When you want to insert a blank embedded Excel object in a Word document, you can:
(a) Click the Object command on the Insert menu
(b) Click the Office Links button on the Standard toolbar
(c) Click the Create Worksheet button on the Formatting toolbar
(d) Click the Import Excel command on the File menu
Option a – Click the Object command on the Insert menu
To save a workbook, you:
(a) Click the Save button on the Standard toolbar
(b) Press Ctrl + F5
(c) Click Save on the Windows Start button
(d) Select Edit > Save
Option a – Click the Save button on the Standard toolbar
You can edit a cell by:
(a) Clicking the Formula button
(b) Double-clicking the cell to edit it in-place
(c) Selecting Edit > Edit Cell from the menu
(d) None of the above
Option b – Double-clicking the cell to edit it in-place
We covered all the Computer Science MCQ Practice Test with Answers above in this post for free so that you can practice well for the exam.
Check out the latest MCQ content by visiting our mcqtube website homepage.
Also, check out:
