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.

401.

Which is not the function of "Edit, Clear" command?%!

A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer» D. Delete formats
402.

How do you display current date and time in MS Excel?%!

A. date ()
B. Today ()
C. now ()
D. time ()
Answer» D. time ()
403.

Long text can be broken down into many lines within a cell. You can do this through%!

A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer» B. Justify in Edit >> Cells
404.

The command Edit >> Fill Across Worksheet is active only when%!

A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above
Answer» C. When no sheet is selected
405.

To remove the content of selected cells you must issue ______ command%!

A. Edit >> Delete
B. Edit >> Clear >> Contents
C. Edit >> Clear >> All
D. Data >> Delete
Answer» C. Edit >> Clear >> All
406.

While Finding and Replacing some data in Excel, which of the following statement is valid?%!

A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer» B. Excel does not have option to match case for find
407.

When a range is selected, how can you activate the previous cell?%!

A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer» E.
408.

Which of the following is not the correct method of editing the cell content?%!

A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
Answer» B. Press the F2 key
409.

How can you show or hide the gridlines in Excel Worksheet?%!

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer» D. None of above
410.

*/*_Concatenation of text can be done using?

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

*/*_MS-EXCEL is based on .........??

A. WINDOWS
B. DOS
C. UNIX
D. OS/2
Answer» B. DOS
412.

*/*_Which is not the function of "Edit, Clear" command??

A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer» D. Delete formats
413.

*/*_How do you display current date and time in MS Excel??

A. date ()
B. Today ()
C. now ()
D. time ()
Answer» D. time ()
414.

*/*_The command Edit >> Fill Across Worksheet is active only when?

A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above
Answer» C. When no sheet is selected
415.

*/*_Long text can be broken down into many lines within a cell. You can do this through?

A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer» B. Justify in Edit >> Cells
416.

*/*_How can you show or hide the gridlines in Excel Worksheet??

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer» D. None of above
417.

*/*_Which of the following is not the correct method of editing the cell content??

A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
Answer» B. Press the F2 key
418.

*/*_When a range is selected, how can you activate the previous cell??

A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer» E.
419.

*/*_While Finding and Replacing some data in Excel, which of the following statement is valid??

A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer» B. Excel does not have option to match case for find
420.

*/*_To remove the content of selected cells you must issue ______ command?

A. Edit >> Delete
B. Edit >> Clear >> Contents
C. Edit >> Clear >> All
D. Data >> Delete
Answer» C. Edit >> Clear >> All
421.

*/*_Which of the following is not information you can specify using the solver??

A. Input cells
B. Constraints
C. Target cell
D. Changing cells
Answer» B. Constraints
422.

*/*_In the formula, which symbol specifies the fixed columns or rows??

A. $
B. *
C. %
D. &
Answer» B. *
423.

*/*_How many worksheets can a workbook have??

A. 3
B. 8
C. 255
D. none of above
Answer» E.
424.

*/*_You cannot link excel worksheet data to a word document?

A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer» E.
425.

*/*_To create a formula, you can use:?

A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
Answer» E.
426.

*/*_In a worksheet you can select?

A. The entire worksheet
B. Rows
C. Columns
D. All of the above
Answer» E.
427.

*/*_You can use the formula palette to?

A. Format cells containing numbers
B. Create and edit formulas containing functions
C. Enter assumptions data
D. Copy a range of cells
Answer» C. Enter assumptions data
428.

*/*_How do you insert a row??

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B. Select the row heading where you want to insert the new row and select Edit >Row from the menu
C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D. All of the above
Answer» B. Select the row heading where you want to insert the new row and select Edit >Row from the menu
429.

*/*_Which of the following methods cannot be used to enter data in a cell?

A. Pressing an arrow key
B. Pressing the Tab key
C. Pressing the Esc key
D. Clicking on the formula bar
Answer» D. Clicking on the formula bar
430.

*/*_A __________ is a grid with labeled columns and rows.?

A. Dialog box
B. Worksheet
C. Clipboard
D. Toolbar
Answer» C. Clipboard
431.

*/*_What are the tabs that appear at the bottom of each workbook called??

A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer» E.
432.

*/*_The name box?

A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Answer» C. Appears below the status bar
433.

*/*_To center worksheet titles across a range of cells, you must?

A. Select the cells containing the title text plus the range over which the title text is to be centered
B. Widen the columns
C. Select the cells containing the title text plus the range over which the title text is to be enfettered
D. Format the cells with the comma style
Answer» B. Widen the columns
434.

*/*_How many characters can be typed in a single cell in Excel??

A. 256
B. 1024
C. 32000
D. 65535
Answer» E.
435.

*/*_What symbol is used before a number to make it a label??

A. ” ( quote )
B. = ( equal )
C. _ ( underscore )
D. ‘ ( apostrophe )
Answer» E.
436.

*/*_When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply?

A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer» C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
437.

*/*_Which of the following is a correct order of precedence in formula calculation??

A. Multiplication and division exponentiation positive and negative values
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. None of above
Answer» E.
438.

*/*_Data can be arranged in a worksheet in a easy to understand manner using?

A. auto formatting
B. applying styles
C. changing fonts
D. all of above
Answer» E.
439.

*/*_A worksheet range is a?

A. A command used for data modeling
B. A range of values such as from 23 to 234
C. A group of cells
D. A group of worksheets
Answer» D. A group of worksheets
440.

*/*_When you want to insert a blank imbedded 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
Answer» B. Click the office links button on the standard toolbar
441.

*/*_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
Answer» D. Column chart
442.

*/*_Which of the following is the latest version of Excel?

A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer» E.
443.

*/*_Files created with Lotus 1-2-3 have an extension?

A. DOC
B. XLS
C. 123
D. WK1
Answer» D. WK1
444.

*/*_You can use the drag and drop method to?

A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. a and b
Answer» E.
445.

*/*_Documentation should include?

A. Destination and users of the output data
B. Source of input data
C. Information on the purpose of the workbook
D. All of the above
Answer» E.
446.

*/*_To copy cell contents using drag and drop press the?

A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer» D. Esc key
447.

*/*_Which of the following is an absolute cell reference??

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

*/*_A typical worksheet has ..... Number of columns?

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

*/*_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
450.

*/*_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