MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 23 Mcqs, each offering curated multiple-choice questions to sharpen your Common Topics in Competitive and Entrance exams knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004 |
| A. | Workday |
| B. | Date |
| C. | Networkdays |
| D. | All of the above |
| Answer» E. | |
| 2. |
In Excel this type of software is similar to an accountant s worksheet |
| A. | Word processing |
| B. | Database |
| C. | Spreadsheets |
| D. | Graphics |
| Answer» D. Graphics | |
| 3. |
In Excel the following is not a basic step in creating a worksheet |
| A. | Save the workbook |
| B. | Modify the worksheet |
| C. | Enter text and data |
| D. | Copy the worksheet |
| Answer» E. | |
| 4. |
In Excel which of these will not select all the cells in a document? |
| A. | Clicking three times with the right mouse button in the spreadsheet |
| B. | Using the Edit Select All menu |
| C. | Pressing Ctrl + A on the keyboard |
| D. | Pressing Ctrl + A on the keyboard |
| Answer» B. Using the Edit Select All menu | |
| 5. |
If the values in A1 is MCQ and B1 is Questions , which function will return in cell C1? |
| A. | =A1 + @ + B1 |
| B. | =A1 # @ # B1 |
| C. | =A1 & @ & B1 |
| D. | =A1 $ @ $ B1 |
| Answer» D. =A1 $ @ $ B1 | |
| 6. |
In Excel without using the mouse or the 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 |
| Answer» B. Press Home | |
| 7. |
In Excel to name a constant, you use the dialog box |
| A. | Create name |
| B. | Define name |
| C. | Paste name |
| D. | Format cells |
| Answer» C. Paste name | |
| 8. |
In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell |
| A. | Count |
| B. | Average |
| C. | Sum |
| D. | None of above |
| Answer» D. None of above | |
| 9. |
In Excel To select several cells or ranges that are not touching each other, you would while selecting |
| A. | hold down the Ctrl key |
| B. | hold down the Shift key |
| C. | hold down the Alt key |
| D. | hold down Ctrl + Shift key |
| Answer» B. hold down the Shift key | |
| 10. |
In Excel to select a column the easiest method is to |
| A. | Double click any cell in the column |
| B. | Drag from the top cell in the column to the last cell in the column |
| C. | Click the column heading |
| D. | Click the column label |
| Answer» D. Click the column label | |
| 11. |
Files created with Lotus 1-2-3 have an extension |
| A. | DOC |
| B. | XLS |
| C. | 123 |
| D. | WK1 |
| Answer» D. WK1 | |
| 12. |
In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values? |
| A. | Category axis |
| B. | Data marker |
| C. | Data point |
| D. | Gridline |
| Answer» E. | |
| 13. |
In Excel to copy cell contents using drag and drop press the |
| A. | End key |
| B. | Shift key |
| C. | Ctrl key |
| D. | Esc key |
| Answer» E. | |
| 14. |
In Excel getting data from a cell located in a different sheet is called |
| A. | Accessing |
| B. | Referencing |
| C. | Updating |
| D. | Functioning |
| Answer» C. Updating | |
| 15. |
In Excel how do you change column width to fit the contents? |
| A. | Single-click the boundary to the left to the column heading |
| B. | Double click the boundary to the right of the column heading |
| C. | Press Alt and single click anywhere in the column |
| D. | All of above |
| Answer» C. Press Alt and single click anywhere in the column | |
| 16. |
In Excel when the formula bar is activated, you can see |
| A. | The Edit Formula button |
| B. | The Cancel button |
| C. | The Enter button |
| D. | All of above |
| Answer» E. | |
| 17. |
In Excel which symbol must all formula begin with? |
| A. | = |
| B. | + |
| C. | ( |
| D. | @ |
| Answer» B. + | |
| 18. |
In Excel you can open the scenario Manager dialog box by choosing scenarios from the .. menu. |
| A. | View |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 19. |
In Excel worksheet can have a maximum of . Number of rows |
| A. | 256 |
| B. | 1024 |
| C. | 32,000 |
| D. | 65,535 |
| Answer» E. | |
| 20. |
In Excel on an Excel sheet the active cell in indicated by |
| A. | A dark wide border |
| B. | A dotted border |
| C. | A blinking border |
| D. | None of above |
| Answer» B. A dotted border | |
| 21. |
In Excel say that you want to paste a formula result but not the underlying formula to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next? |
| A. | Click the Paste button on the standard toolbar |
| B. | Click the arrow on the paste button on the standard toolbar, then click formulas |
| C. | Click the arrow on the paste button on the standard toolbar, then click values. |
| D. | All of above |
| Answer» D. All of above | |
| 22. |
In Excel to hold row and column titles in places 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 | |
| 23. |
In Excel when integrating Ms-Word and Excel, Word is usually the |
| A. | Server |
| B. | Source |
| C. | Client |
| D. | None |
| Answer» D. None | |