Explore topic-wise MCQs in Computer Fundamentals.

This section includes 615 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.

451.

*/*_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
Answer» D. click the comment command on the view menu
452.

*/*_Which elements of worksheet can be protected from accidental modification?

A. Contents
B. Objects
C. Scenarios
D. All of above
Answer» E.
453.

*/*_Which of the following action removes a sheet from workbook??

A. Select the sheet, then choose Edit >> Delete Sheet
B. Select the sheet then choose Format >> Sheet >> Hide
C. Both of above
D. None of above
Answer» B. Select the sheet then choose Format >> Sheet >> Hide
454.

*/*_Edit >> Delete command?

A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
Answer» E.
455.

*/*_The short cut key Ctrl + R is used in Excel to?

A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above
Answer» D. None of above
456.

*/*_You can auto fit the width of column by?

A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer» D. Double clicking on the column left border of column header
457.

*/*_Which command will you choose to convert a column of data into row??

A. Cut and Paste
B. Edit >> Paste Special >> Transpose
C. Both of above
D. None of above
Answer» C. Both of above
458.

*/*_Where can you change automatic or manual calculation mode in Excel??

A. Double CAL indicator on status bar
B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
C. Both of above
D. None of above
Answer» C. Both of above
459.

*/*_Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook??

A. work sheet
B. chart sheet
C. module sheet
D. data sheet
Answer» E.
460.

*/*_You can use the formula pallette to?

A. format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells
Answer» C. enter assumptions data
461.

*/*_What will be the output if you format the cell containing 5436.8 as '#,##0.00' ??

A. 5430
B. 5436.80
C. 5436.8
D. 6.8
Answer» C. 5436.8
462.

*/*_Comments can be added to cells using ......?

A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View –> Comments
Answer» C. File -> Comments
463.

*/*_A numeric value can be treated as label value if ...... precedes it.?

A. Apostrophe ( ‘ )
B. Exclamation ( ! )
C. Hash ( # )
D. Tilde ( ~ )
Answer» B. Exclamation ( ! )
464.

*/*_What do you mean by a Workspace??

A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
Answer» E.
465.

*/*_Which function is not available in the Consolidate dialog box??

A. Pmt
B. Average
C. Max
D. Sum
Answer» B. Average
466.

_ A numeric value can be treated as label value if ...... precedes it.$?

A. Apostrophe ( ‘ )
B. Exclamation ( ! )
C. Hash ( # )
D. Tilde ( ~ )
Answer» B. Exclamation ( ! )
467.

_ What do you mean by a Workspace?$?

A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
Answer» E.
468.

_ Which function is not available in the Consolidate dialog box?$?

A. Pmt
B. Average
C. Max
D. Sum
Answer» B. Average
469.

_ What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?$?

A. 5430
B. 5436.80
C. 5436.8
D. 6.8
Answer» C. 5436.8
470.

_ Comments can be added to cells using ......$?

A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View –> Comments
Answer» C. File -> Comments
471.

_ The short cut key Ctrl + R is used in Excel to$?

A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above
Answer» D. None of above
472.

_ You can auto fit the width of column by$?

A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer» D. Double clicking on the column left border of column header
473.

_ Which command will you choose to convert a column of data into row?$?

A. Cut and Paste
B. Edit >> Paste Special >> Transpose
C. Both of above
D. None of above
Answer» C. Both of above
474.

_ Where can you change automatic or manual calculation mode in Excel?$?

A. Double CAL indicator on status bar
B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
C. Both of above
D. None of above
Answer» C. Both of above
475.

_ Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?$?

A. work sheet
B. chart sheet
C. module sheet
D. data sheet
Answer» E.
476.

_ You can use the formula pallette to$?

A. format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells
Answer» C. enter assumptions data
477.

_ Which of the following action removes a sheet from workbook?$?

A. Select the sheet, then choose Edit >> Delete Sheet
B. Select the sheet then choose Format >> Sheet >> Hide
C. Both of above
D. None of above
Answer» B. Select the sheet then choose Format >> Sheet >> Hide
478.

_ Edit >> Delete command$?

A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
Answer» E.
479.

_ When you insert an excel file into a word document. The data are$?

A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
Answer» C. Embedded
480.

_ What is the short cut key to highlight the entire column?$?

A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
Answer» E.
481.

_ Which of the following is not a term of MS-Excel?$?

A. Cells
B. Rows
C. Columns
D. Document
Answer» E.
482.

_ You can copy data or formulas$?

A. With the copy, paste and cut commands on the edit menu
B. With commands on the shortcut menu
C. With buttons on the standard toolbars
D. All of the above
Answer» E.
483.

_ To edit in an embedded excel worksheet object in a word document$?

A. Use the excel menu bar and toolbars inside the word application
B. Edit the hyperlink
C. Edit the data in a excel source application
D. Use the word menu bar and toolbars
Answer» B. Edit the hyperlink
484.

_ To copy formatting from one area in a worksheet and apply it to another area you would use:$?

A. The Edit > Copy Format and Edit>Paste Format commands form the menu
B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
C. There is no way to copy and apply formatting in Excel – You have to do it manually
D. The Format Painter button on the standard toolbar
Answer» E.
485.

_ You can use the format painter multiple times before you turn it off by$?

A. You can use the format painter button on ly one time when you click it
B. Double clicking the format painter button
C. Pressing the Ctrl key and clicking the format painter button
D. Pressing the Alt key and clicking the format painter button
Answer» C. Pressing the Ctrl key and clicking the format painter button
486.

_ Text formulas:$?

A. Replace cell references
B. Return ASCII values of characters
C. Concatenate and manipulate text
D. Show formula error value
Answer» D. Show formula error value
487.

_ The Cancel and Enter buttons appear in the:$?

A. Title bar
B. Formula bar
C. Menu bar
D. Sheet tabs
Answer» C. Menu bar
488.

_ In help menu of Excel, which of the following tabs are found?$?

A. Contents tab
B. Answer Wizard tab
C. Index tab
D. all of the above
Answer» E.
489.

_ What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)$?

A. An absolute cell address is created
B. Cell address will change when it is copied to another cell
C. The sheet tab is changed
D. The status bar does not display the cell address
Answer» B. Cell address will change when it is copied to another cell
490.

_ The spelling dialog box can be involved by choosing spelling from ________ menu.$?

A. insert
B. file
C. tools
D. view
Answer» D. view
491.

_ When a label is too long to fit within a worksheet cell, you typically must$?

A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer» C. Decrease the column width
492.

_ To create a formula, you first:$?

A. Select the cell you want to place the formula into
B. Type the equals sign (=) to tell Excel that you’re about to enter a formula
C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D. Choose the new command from the file menu
Answer» C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
493.

__A typical worksheet has ..... Number of columns__

A. 128
B. 256
C. 512
D. 1024
Answer» C. 512
494.

__Which of the following is an absolute cell reference?__

A. !A!1
B. $A$1
C. #a#1
D. A1
Answer» C. #a#1
495.

__You can set Page Border in Excel from__

A. From Border tab in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From Line Style tool in Drawing toolbar
D. You can not set page border in Excel
Answer» E.
496.

__All worksheet formula__

A. Manipulate values
B. Manipulate labels
C. Return a formula result
D. Use the addition operator
Answer» D. Use the addition operator
497.

__Concatenation of text can be done using__

A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer» E.
498.

__The Chart wizard term data categories refers to;__

A. A chart plot area
B. A horizontal axis
C. The organization of individual values with a chart’s data series
D. The data range that supply chart data
Answer» C. The organization of individual values with a chart‚Äö√Ñ√¥s data series
499.

__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
Answer» D. click the comment command on the view menu
500.

__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 and Footers
Answer» B. Page Orientation