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.
Question 1 / 26
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Question 2 / 26
You cannot link excel worksheet data to a word document
With a hyperlink
With the copy and paste buttons on the standard toolbar.
Question 3 / 26
Which of the following is a popular DOS based spreadsheet package?
Excel
Lotus 1-2-3
Question 4 / 26
An excel workbook is a collection of
Charts
Worksheets and charts
Question 5 / 26
Excel files have a default extension of
Xls
Xlw
Question 6 / 26
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
Question 7 / 26
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Question 8 / 26
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Question 9 / 26
A circular reference is
A formula that either directly or indirectly depends on itself
Always erroneous
Question 10 / 26
Which of following is Not one of Excel’s what-if function?
Scenario manager
Auto Outline
Question 11 / 26
When you insert an excel file into a word document. The data are
Linked
Embedded
Question 12 / 26
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Question 13 / 26
Each excel file is called a workbook because
It can be modified
It can contain many sheets including worksheets and chart sheets
Question 14 / 26
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Question 15 / 26
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labe3ls and values but not formulas
Question 16 / 26
All worksheet formula
Manipulate labels
Return a formula result
Question 17 / 26
The Paste Special command lets you copy and paste:
Formatting options
The resulting values of a formula instead of the actual formula
Question 18 / 26
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
Question 19 / 26
Which of the following is not a valid data type in excel
Number
Character
Question 20 / 26
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
List boxes
Text boxes
Question 21 / 26
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview.
Page Orientation
Question 22 / 26
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
Question 23 / 26
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
Question 24 / 26
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Question 25 / 26
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
Question 26 / 26
to view a cell comment
click the display comment command on the window menu
position the mouse pointer over the cell
What's Your Reaction?
Like
0
Dislike
0
Love
0
Funny
0
Wow
0
Sad
0
Angry
0
Comments (0)