MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 162 Mcqs, each offering curated multiple-choice questions to sharpen your MS Excel knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which among the following will not set text in selected cells to italics? |
| A. | Pressing Ctrl + I on the keyboard |
| B. | Using the Tools Wizard Web Form menu item |
| C. | Using the Format Cells Font menu item |
| D. | None of the above |
| Answer» C. Using the Format Cells Font menu item | |
| 2. |
Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros? |
| A. | On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. |
| B. | On the tools menu, click Add-Ins, and select the Euro Currency Tools check box |
| C. | Apply a selected background color |
| D. | All of above |
| Answer» C. Apply a selected background color | |
| 3. |
Which among the following methods can not 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 the enter button to the formula bar |
| Answer» D. Clicking the enter button to the formula bar | |
| 4. |
How should you print a selected area of a worksheet if a different area needs to printed ? |
| A. | On the file menu, point to print area, and then click set print area. |
| B. | On the file menu, click print, and then click selection under print what |
| C. | On the view menu, click custom views, then click add |
| D. | All of above |
| Answer» C. On the view menu, click custom views, then click add | |
| 5. |
What is a function inside another function is called ? |
| A. | Nested Function |
| B. | Round Function |
| C. | Sum Function |
| D. | Text Function |
| Answer» B. Round Function | |
| 6. |
Which among the following is a correct order of precedence in a formula calculation? |
| A. | Multiplication and division, exponential positive and negative value |
| 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. | |
| 7. |
What kind of charts can an excel produce ? |
| A. | Line graphs and pie charts only |
| B. | Only line graphs |
| C. | Bar charts, line graphs and pie charts |
| D. | Bar charts and line graphs only |
| Answer» D. Bar charts and line graphs only | |
| 8. |
You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu. |
| A. | Edit |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 9. |
To protect a worksheet, you can choose Protection and the Protect Sheet from the .. menu |
| A. | Edit |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» D. Data | |
| 10. |
You can quickly change the appearance of your work by choosing Auto Format from the . Menu |
| A. | Edit |
| B. | View |
| C. | Format |
| D. | Tools |
| Answer» D. Tools | |
| 11. |
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. | |
| 12. |
You can check the conditions against __________ when applying conditional formatting |
| A. | Cell value |
| B. | Formula |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 13. |
Which of the following is not true regarding Conditional Formatting? |
| A. | You can add more than one condition to check |
| B. | You can set condition to look for Bold and apply Italics on them. |
| C. | You can apply Font, border and pattern formats that meets the specified conditions |
| D. | You can delete any condition from Conditional Formatting dialog box if it is not requried |
| Answer» C. You can apply Font, border and pattern formats that meets the specified conditions | |
| 14. |
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 | |
| 15. |
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. | |
| 16. |
Where can you set the shedding 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. | |
| 17. |
How can you remove borders applied in cells? |
| A. | Choose None on Border tab of Format cells |
| B. | Open the list on Border tool in Formatting toolbar then choose first tool (no border) |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 18. |
Which of the following format you can decide to apply or not in AutoFormat dialog box? |
| A. | Number format |
| B. | Border format |
| C. | Font format |
| D. | All of above |
| Answer» E. | |
| 19. |
Special category of Number tab in Format Cells dialog box can be used to apply formats like |
| A. | Zip Code |
| B. | Phone Number |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 20. |
Which function will you use to enter current time in a woksheet cell? |
| A. | =today() |
| B. | =now() |
| C. | =time() |
| D. | =currentTime() |
| Answer» C. =time() | |
| 21. |
What is entered by the function =today() |
| A. | The date value for the day according to system clock |
| B. | The time value according to system clock |
| C. | Today s date as Text format |
| D. | All of above |
| Answer» B. The time value according to system clock | |
| 22. |
Formatting a cell in Number format you can t set |
| A. | Decimal Places |
| B. | Use 1000 separator |
| C. | Negative numbers |
| D. | Currency Symbol |
| Answer» E. | |
| 23. |
Formatting a cell in Currency, you can specify |
| A. | Decimal Places |
| B. | Currency Symbol |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 24. |
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from |
| A. | from Fromat >> Cells |
| B. | from Format >> Autoformat |
| C. | from Table >> Autoformat |
| D. | All of above |
| Answer» C. from Table >> Autoformat | |
| 25. |
Merge cells option can be applied from |
| A. | Format Cells dialog box Alignment Tab |
| B. | Formatting toolbar |
| C. | Both of above |
| D. | None of above |
| Answer» B. Formatting toolbar | |
| 26. |
Which of the following is not an option in the spelling dialog box? |
| A. | Edit |
| B. | Ignore |
| C. | Ignore all |
| D. | Change |
| Answer» B. Ignore | |
| 27. |
Can you set 0.5 inch left indentation for a cell in Excel? |
| A. | Excel does not have indentation feature |
| B. | You can specify indentation only if you turn the rulers on |
| C. | Indentation can be set from Format Cells dialog box |
| D. | The indentation can be specified only when printing |
| Answer» D. The indentation can be specified only when printing | |
| 28. |
You can automatically adjust the size of text in a cell if they do not fit in width by |
| A. | Double clicking on the right border of column header |
| B. | From Format choose Columns and then Autofit Selection |
| C. | From Format Cells dialog box mark Shrink to fit check box |
| D. | All of above |
| Answer» D. All of above | |
| 29. |
If you need a text to show vertically in a cell. How will you achieve this? |
| A. | Choose Vertical on Text alignment in Format Cells dialog box |
| B. | Choose 90 Degrees in Orientation of Format Cells dialog box |
| C. | Choose Distributed from the Vertical drop down list of Format Cells dialog box |
| D. | Choose Center Across Selection from Horizontal combo box in Format Cells dialog box |
| Answer» C. Choose Distributed from the Vertical drop down list of Format Cells dialog box | |
| 30. |
The spelling tool is placed on ______ toolbar |
| A. | Standard |
| B. | Formatting |
| C. | Drawing |
| D. | Reviewing |
| Answer» B. Formatting | |
| 31. |
Which of the following is not a valid Zoom percentage in Excel? |
| A. | 10 |
| B. | 100 |
| C. | 300 |
| D. | 500 |
| Answer» E. | |
| 32. |
Comments on a presentation can record who wrote them and when they were added. What's the automatic way in PowerPoint 2002? |
| A. | Use online collaboration |
| B. | Use comments |
| C. | Use the notes page |
| D. | All of the above |
| Answer» D. All of the above | |
| 33. |
Which of the following allow you to select more than one slide in a presentation? |
| A. | Alt + Click each slide |
| B. | Shift + drag each slide |
| C. | Shift + Click each slide |
| D. | Ctrl + Click each slide |
| Answer» D. Ctrl + Click each slide | |
| 34. |
In which format does the data appear When an Excel file is inserted in a Word document? |
| A. | Hyperlinked |
| B. | Placed in a word table |
| C. | Linked |
| D. | Embedded |
| Answer» C. Linked | |
| 35. |
Which of the following options in the printer dialog box would you select to print slides 5 and 12 in a presentation? |
| A. | Slides |
| B. | Custom shows |
| C. | Current slide |
| D. | All |
| Answer» B. Custom shows | |
| 36. |
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. | |
| 37. |
Concatenation of text can be done using |
| A. | Apostrophe (&lsquo |
| B. | Exclamation (!) |
| C. | Hash (#) |
| D. | Ampersand (& |
| Answer» E. | |
| 38. |
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 (!) | |
| 39. |
which function 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. | |
| 40. |
How many characters can be typed in a single cell in Excel? |
| A. | 256 |
| B. | 1024 |
| C. | 32,000 |
| D. | 65,535 |
| Answer» E. | |
| 41. |
Data marker on a chart are linked to data points in a worksheet, therefore, |
| A. | You can automatically apply formatting to a data series |
| B. | You can change the position of a data marker and automatically change the data point value in the worksheet |
| C. | You can change a data print value and automatically are draw the chart |
| D. | a and b |
| Answer» C. You can change a data print value and automatically are draw the chart | |
| 42. |
A typical worksheet has . Number of columns |
| A. | 128 |
| B. | 256 |
| C. | 512 |
| D. | 1024 |
| Answer» C. 512 | |
| 43. |
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 | |
| 44. |
Which of the following formulas is not entered correctly? |
| A. | =10+50 |
| B. | =B7*B1 |
| C. | =B7+14 |
| D. | 10+50 |
| Answer» E. | |
| 45. |
Which symbol must all formula begin with? |
| A. | = |
| B. | + |
| C. | ( |
| D. | @ |
| Answer» B. + | |
| 46. |
In a worksheet you can select |
| A. | The entire worksheet |
| B. | Rows |
| C. | Columns |
| D. | a, b, and c |
| Answer» E. | |
| 47. |
to activate the previous cell in a pre-selected range, press |
| A. | the Alt key |
| B. | the Tab key |
| C. | the Enter key |
| D. | none of above |
| Answer» E. | |
| 48. |
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. | |
| 49. |
To drag a selected range of data to another worksheet in the same workbook, use the |
| A. | Tab key |
| B. | Alt key |
| C. | Shift key |
| D. | Ctrl key |
| Answer» E. | |
| 50. |
You can add an image to a template by clicking the Insert Picture From File button on the . Toolbar. |
| A. | Standard |
| B. | Formatting |
| C. | Drawing |
| D. | Picture |
| Answer» E. | |