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.

Aug 9, 2021 - 13:01
Aug 9, 2021 - 13:01
 0  165

1. Rounding errors can occur

When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula

2. You cannot link excel worksheet data to a word document

With a hyperlink
With the copy and paste buttons on the standard toolbar.

3. Which of the following is a popular DOS based spreadsheet package?

Excel
Lotus 1-2-3

4. An excel workbook is a collection of

Charts
Worksheets and charts

5. Excel files have a default extension of

Xls
Xlw

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

7. You can use the formula palette to

Format cells containing numbers
Create and edit formulas containing functions

8. You can convert existing excel worksheet data an charts to an HTML document by using

FTP wizard
Internet assistant wizard

9. A circular reference is

A formula that either directly or indirectly depends on itself
Always erroneous

10. Which of following is Not one of Excel’s what-if function?

Scenario manager
Auto Outline

11. When you insert an excel file into a word document. The data are

Linked
Embedded

12. Which of the following is not information you can specify using the solver?

Input cells
Constraints

13. Each excel file is called a workbook because

It can be modified
It can contain many sheets including worksheets and chart sheets

14. Excel probably considers the cell entry January 1, 2000 to be a

Label
Value

15. You can enter which types of data into worksheet cells?

Labels, values, and formulas
Labe3ls and values but not formulas

16. All worksheet formula

Manipulate labels
Return a formula result

17. The Paste Special command lets you copy and paste:

Formatting options
The resulting values of a formula instead of the actual formula

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

19. Which of the following is not a valid data type in excel

Number
Character

20. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

List boxes
Text boxes

21. Which of the following options is not located in the Page Setup dialog box?

Page Break Preview.
Page Orientation

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

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

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

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

26. to view a cell comment

click the display comment command on the window menu
position the mouse pointer over the cell

like

dislike

love

funny

angry

sad

wow