MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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.
| 501. |
__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 | |
| 502. |
__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. | |
| 503. |
__Which elements of worksheet can be protected from accidental modification__ |
| A. | Contents |
| B. | Objects |
| C. | Scenarios |
| D. | All of above |
| Answer» E. | |
| 504. |
_Which elements of a worksheet can be protected from accidental modification?$? |
| A. | Contents |
| B. | Objects |
| C. | Scenarios |
| D. | All of the above |
| Answer» E. | |
| 505. |
_An Excel Workbook is a collection of .......$? |
| A. | Workbooks |
| B. | Worksheets |
| C. | Charts |
| D. | Worksheets and Charts |
| Answer» E. | |
| 506. |
_To return the remainder after a number is divided by a divisor in EXCEL we use the function?$? |
| A. | ROUND ( ) |
| B. | FACT ( ) |
| C. | MOD ( ) |
| D. | DIV ( ) |
| Answer» D. DIV ( ) | |
| 507. |
_Which Chart can be created in Excel?$? |
| A. | Area |
| B. | Line |
| C. | Pie |
| D. | All of the above |
| Answer» E. | |
| 508. |
_What is the short cut key to replace a data with another in sheet?$? |
| A. | Ctrl + R |
| B. | Ctrl + Shift + R |
| C. | Ctrl + H |
| D. | Ctrl + F |
| Answer» D. Ctrl + F | |
| 509. |
_Ctrl + D shortcut key in Excel will$? |
| A. | Open the font dialog box |
| B. | Apply double underline for the active cell |
| C. | Fill down in the selection |
| D. | None of above |
| Answer» D. None of above | |
| 510. |
_Which of the cell pointer indicate that you can move the content to other cell?$? |
| A. | Doctor’s symbol (Big Plus) |
| B. | small thin plus icon |
| C. | Mouse Pointer with anchor at the tip |
| D. | None of above |
| Answer» D. None of above | |
| 511. |
_Which of the following option is not available in Paste Special dialog box?$? |
| A. | Add |
| B. | Subtract |
| C. | Divide |
| D. | SQRT |
| Answer» E. | |
| 512. |
_You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?$? |
| A. | Custom List |
| B. | Auto Fill Options |
| C. | Fill Across Worksheet |
| D. | Fill Series |
| Answer» B. Auto Fill Options | |
| 513. |
_The Name box on to the left of formula bar$? |
| A. | shows the name of workbook currently working on |
| B. | shows the name of worksheet currently working on |
| C. | shows the name of cell or range currently working on |
| D. | None of above |
| Answer» D. None of above | |
| 514. |
_Which of the following is invalid statement?$? |
| A. | Sheet tabs can be colored |
| B. | Some picture can be applied as a background of a sheet |
| C. | You can set the column width automatically fit the amount of text |
| D. | The width of a row and be specified manually or fit automatically |
| Answer» E. | |
| 515. |
_By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?$? |
| A. | Right click on Sheet Tab of third sheet and choose Delete from the context menu |
| B. | Click on Sheet 3 and from Edit menu choose Delete |
| C. | Both of above |
| D. | None of above |
| Answer» B. Click on Sheet 3 and from Edit menu choose Delete | |
| 516. |
_Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?$? |
| A. | Square |
| B. | Percentage |
| C. | Goal Seek |
| D. | Divide |
| Answer» E. | |
| 517. |
Which of following is Not one of Excel's what-if function?$? |
| A. | Goal seek |
| B. | Solver |
| C. | Scenario manager |
| D. | Auto Outline |
| Answer» E. | |
| 518. |
What does COUNTA () function do?$? |
| A. | counts cells having alphabets |
| B. | counts empty cells |
| C. | counts cells having number |
| D. | counts non-empty cells |
| Answer» E. | |
| 519. |
Which language is used to create macros in Excel?$? |
| A. | Visual Basic |
| B. | C |
| C. | Visual C++ |
| D. | Java |
| Answer» B. C | |
| 520. |
Rounding errors can occur$? |
| A. | When you use multiplication, division, or exponentiation in a formula |
| B. | When you use addition and 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 that the calculated results |
| Answer» B. When you use addition and subtraction in a formula | |
| 521. |
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 |
| Answer» C. Hold titles command on the edit menu | |
| 522. |
When the formula bar is active, you can see$? |
| A. | The edit formula button |
| B. | The cancel button |
| C. | The enter button |
| D. | All of the above |
| Answer» E. | |
| 523. |
Excel files have a default extension of in Excel-2003$? |
| A. | Xls |
| B. | Xlw |
| C. | Wk1 |
| D. | 123 |
| Answer» B. Xlw | |
| 524. |
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 |
| Answer» E. | |
| 525. |
B7:B9 indicates:$? |
| A. | Cells B7 and cell B9 only |
| B. | Cells B7 through B9 |
| C. | Cell B8 only |
| D. | None of the above |
| Answer» C. Cell B8 only | |
| 526. |
In Excel, the Fill Color button on the Formatting toolbar is used for what?$? |
| A. | To insert a background |
| B. | To add borders |
| C. | To select a distribution of figures |
| D. | To add shading or color to a cell range |
| Answer» E. | |
| 527. |
The first cell in EXCEL worksheet is labeled as$? |
| A. | AA |
| B. | A1 |
| C. | Aa |
| D. | A0 |
| Answer» C. Aa | |
| 528. |
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?$? |
| A. | XY Chart |
| B. | Line Chart |
| C. | Pie Chart |
| D. | Column Chart |
| Answer» D. Column Chart | |
| 529. |
When integrating word and excel, word is usually the$? |
| A. | Server |
| B. | Destination |
| C. | Client |
| D. | Both b and c |
| Answer» E. | |
| 530. |
How can you print three copies of a workbook?$? |
| A. | Select File > Properties form the menu and type 3 in the Copies to print text box |
| B. | Select File > Print from the menu and type 3 in the Number of copies text box |
| C. | Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made |
| D. | Press Ctrl+P+3 |
| Answer» C. Click the Print button on the standard toolbar to print the document then take it to Kinko‚Äö√Ñ√¥s and have 2 more copies made | |
| 531. |
Which of the following formulas will Excel Not be able to calculate?$? |
| A. | =SUM(Sales)-A3 |
| B. | =SUM(A1:A5)*.5 |
| C. | =SUM(A1:A5)/(10-10) |
| D. | =SUM(A1:A5)-10 |
| Answer» B. =SUM(A1:A5)*.5 | |
| 532. |
Which menu option can be sued to split windows into two$? |
| A. | Format > window |
| B. | View > window > split |
| C. | Window > split |
| D. | View > split |
| Answer» D. View > split | |
| 533. |
Where can you set the shading color for a range of cells in Excel?$? |
| A. | Choose required color form Patterns tab of Format Cells dialog box |
| B. | Choose required color on Fill Color tool in Formatting toolbar |
| C. | Choose required color on Fill Color tool in Drawing toolbar |
| D. | All of above |
| Answer» E. | |
| 534. |
You can enter which types of data into worksheet cells?$? |
| A. | Labels, values, and formulas |
| B. | Labels and values but not formulas |
| C. | Values and formulas but not labels |
| D. | Formulas only |
| Answer» B. Labels and values but not formulas | |
| 535. |
A numeric value can be treated as a label value if it precedes with$? |
| A. | Apostrophe (&lsquo |
| B. | Exclamation (!) |
| C. | Hash (#) |
| D. | Ampersand (& |
| Answer» B. Exclamation (!) | |
| 536. |
The chart wizard term data series refers to$? |
| A. | A chart legend |
| B. | A collection of chart data markers |
| C. | A set of values you plot in a chart |
| D. | A data label |
| Answer» C. A set of values you plot in a chart | |
| 537. |
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:$? |
| A. | Press the Erase key |
| B. | Press Esc |
| C. | Press the Enter button |
| D. | Press the Edit Formula button |
| Answer» C. Press the Enter button | |
| 538. |
Excel worksheet cells work very similarly to what common element of the windows graphical user interface$? |
| A. | Option buttons |
| B. | List boxes |
| C. | Text boxes |
| D. | Combo boxes |
| Answer» D. Combo boxes | |
| 539. |
Which of the following is not a worksheet design criterion?$? |
| A. | Efficiency |
| B. | Aditibility |
| C. | Description |
| D. | Clarity |
| Answer» D. Clarity | |
| 540. |
Right clicking something in Excel:$? |
| A. | Deletes the object |
| B. | Nothing the right mouse button is there for left handed people |
| C. | Opens a shortcut menu listing everything you can do to the object |
| D. | Selects the object |
| Answer» D. Selects the object | |
| 541. |
You can select a single range of cells by$? |
| A. | Clicking the upper-left cell in a group of cells and 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 and an arrow key |
| D. | Dragging over the desired cells |
| Answer» E. | |
| 542. |
Which of the following is not a valid data type in Excel? |
| A. | Number |
| B. | Character |
| C. | Label |
| D. | Date/Time |
| Answer» C. Label | |
| 543. |
Multiple calculations can be made in a single formula using ....... |
| A. | Standard Formulas |
| B. | Array Formula |
| C. | Complex Formulas |
| D. | Smart Formula |
| Answer» C. Complex Formulas | |
| 544. |
To select an entire column in MS-EXCEL, press? |
| A. | CTRL + C |
| B. | CTRL + Arrow key |
| C. | CTRL + S |
| D. | None of the above |
| Answer» E. | |
| 545. |
How do you rearrange the data in ascending or descending order? |
| A. | Data, Sort |
| B. | Data, Form |
| C. | Data, Table |
| D. | Data Subtotals |
| Answer» B. Data, Form | |
| 546. |
You can move a sheet from one workbook into new book by |
| A. | From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK |
| B. | From Edit menu choose Move of Copy then choose (Move to end) and click OK |
| C. | From Edit menu choose Move or Copy then select (new book) from To Book list and click OK |
| D. | None of above |
| Answer» D. None of above | |
| 547. |
When a row of data is to be converted into columns |
| A. | Copy the cells in row, select the same number of cells in row and paste |
| B. | Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK |
| C. | Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK |
| D. | Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK |
| Answer» E. | |
| 548. |
Which of the cell pointer indicates that you can fill series? |
| A. | Doctor’s symbol (Big Plus) |
| B. | small thin plus icon |
| C. | Mouse Pointer with anchor at the tip |
| D. | None of above |
| Answer» C. Mouse Pointer with anchor at the tip | |
| 549. |
What happens when you press Ctrl + X after selecting some cells in Excel? |
| A. | The cell content of selected cells disappear from cell and stored in clipboard |
| B. | The cells selected are marked for cutting |
| C. | The selected cells are deleted and the cells are shifted left |
| D. | The selected cells are deleted and cells are shifted up |
| Answer» C. The selected cells are deleted and the cells are shifted left | |
| 550. |
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? |
| A. | F8 |
| B. | F9 |
| C. | F10 |
| D. | F11 |
| Answer» C. F10 | |