Microsoft Excel Basic MCQs (Long Quiz) (Part 3)
This is the quiz about basics of Microsoft Office Excel. Students and new learner's can test their knowledge.
1. Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Correct Answer
Wrong Answer
2. You cannot link excel worksheet data to a word document
With a hyperlink
With the copy and paste buttons on the standard toolbar.
Correct Answer
Wrong Answer
3. Which of the following is a popular DOS based spreadsheet package?
Excel
Lotus 1-2-3
Correct Answer
Wrong Answer
4. An excel workbook is a collection of
Charts
Worksheets and charts
Correct Answer
Wrong Answer
5. Excel files have a default extension of
Xls
Xlw
Correct Answer
Wrong Answer
6. You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Correct Answer
Wrong Answer
7. You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Correct Answer
Wrong Answer
8. You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Correct Answer
Wrong Answer
9. A circular reference is
A formula that either directly or indirectly depends on itself
Always erroneous
Correct Answer
Wrong Answer
10. Which of following is Not one of Excel’s what-if function?
Scenario manager
Auto Outline
Correct Answer
Wrong Answer
11. When you insert an excel file into a word document. The data are
Linked
Embedded
Correct Answer
Wrong Answer
12. Which of the following is not information you can specify using the solver?
Input cells
Constraints
Correct Answer
Wrong Answer
13. Each excel file is called a workbook because
It can be modified
It can contain many sheets including worksheets and chart sheets
Correct Answer
Wrong Answer
14. Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Correct Answer
Wrong Answer
15. You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labe3ls and values but not formulas
Correct Answer
Wrong Answer
16. All worksheet formula
Manipulate labels
Return a formula result
Correct Answer
Wrong Answer
17. The Paste Special command lets you copy and paste:
Formatting options
The resulting values of a formula instead of the actual formula
Correct Answer
Wrong Answer
18. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
Correct Answer
Wrong Answer
19. Which of the following is not a valid data type in excel
Number
Character
Correct Answer
Wrong Answer
20. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
List boxes
Text boxes
Correct Answer
Wrong Answer
21. Which of the following options is not located in the Page Setup dialog box?
Page Break Preview.
Page Orientation
Correct Answer
Wrong Answer
22. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Row chart
Line chart
Correct Answer
Wrong Answer
23. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Ctrl +Home
Press Home
Correct Answer
Wrong Answer
24. Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Correct Answer
Wrong Answer
25. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Press the Erase key
Press Esc
Correct Answer
Wrong Answer
26. to view a cell comment
click the display comment command on the window menu
position the mouse pointer over the cell
Correct Answer
Wrong Answer
What's Your Reaction?
