MS Excel Quiz Online Test Mcqs Questions with Answers Objective Type PDF

Question 1 of 25

Uncategorized

1. You can edit a cell by?

Selecting Edit>Edit Cell from the menu

Clicking the formula button

Double clicking the cell to edit it in-place

None of above

Question 1 of 25

Question 2 of 25

2. Which of the following methods can not be used to edit the contents of a cell?

Pressing the F2 key

Double clicking the cell

Clicking the formula bar

Press the Alt key

Question 2 of 25

Question 3 of 25

3. How are data organized in a spreadsheet?

Lines and spaces

Height and width

Rows and columns

Layers and planes

Question 3 of 25

Question 4 of 25

4. When you insert an Excel file into a Word document, the data are?

Embedded

Hyperlinked

Linked

Placed in a word table

Question 4 of 25

Question 5 of 25

5. The Paste Special command lets you copy and paste?

Multiply the selection by a copied value

The resulting values of a formula instead of the actual formula

Cell comments

Formatting options

Question 5 of 25

Question 6 of 25

6. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Line chart

Pie chart

Row chart

Column chart

Question 6 of 25

Question 7 of 25

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

Label

Number

Character

Date/time

Question 7 of 25

Question 8 of 25

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

Page Orientation

Headers and Footers

Page Break Preview

Margins

Question 8 of 25

Question 9 of 25

9. Gridlines?

May be turned off for display but turned on for printing

The be turned off for display and printing

A, b and c

May be turned on or off for printing

Question 9 of 25

Question 10 of 25

10. 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

Press Alt + Home

Press Shift + Home

Question 10 of 25

Question 11 of 25

11. 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 Esc

Press the Erase key

Press the Enter button

Press the Edit Formula button

Question 11 of 25

Question 12 of 25

12. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

None of these

You have to retype everything and manually add the dollar signs, commas, and decimals

Click the Currency Style button on the formatting toolbar

Select Format > Money from the menu

Question 12 of 25

Question 13 of 25

13. All worksheet formula?

Return a formula result

Manipulate labels

Use the addition operator

Manipulate values

Question 13 of 25

Question 14 of 25

14. Each excel file is called a workbook because?

You have to work hard to create it

It can contain many sheets including worksheets and chart sheets

It can be modified

It can contain text and data

Question 14 of 25

Question 15 of 25

15. What function displays row data in a column or column data in a row?

Index

Rows

Transpose

Hyperlink

Question 15 of 25

Question 16 of 25

16. You can open the consolidate dialog box by choosing Consolidate from the ….. menu?

Insert

Tools

Format

Data

Question 16 of 25

Question 17 of 25

17. When you want to insert a blank imbedded excel object in a word document you can?

Click the import excel command on the file menu

Click the create worksheet button on the formatting toolbar

Click the object command on the insert menu

Click the office links button on the standard toolbar

Question 17 of 25

Question 18 of 25

18. To view a cell comment?

click the display comment command on the window menu

click the comment command on the view menu

click the edit comment command on the insert menu

position the mouse pointer over the cell

Question 18 of 25

Question 19 of 25

19. Which types of charts can excel produce?

Bar charts, line graphs and pie charts

Line graphs and pie charts only

Bar charts and line graphs only

Only line graphs

Question 19 of 25

Question 20 of 25

20. To save a workbook, you?

Click Save on the Windows Start button

Select Edit>Save

Click the save button on the standard toolbar from the menu

Press Ctrl+F5

Question 20 of 25

Question 21 of 25

21. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?

AND

IF

OR

Not

Question 21 of 25

Question 22 of 25

22. What does the VLOOKUP function do?

All of above

Checks whether text is the same in one cell as in the next

Looks up text that contain ‘v’

Finds related records

Question 22 of 25

Question 23 of 25

23. Which of the following is a correct order of precedence in formula calculation?

Multiplication and division, positive and negative values, addition and subtraction

All of above

Multiplication and division exponentiation positive and negative values

Addition and subtraction, positive and negative values, exponentiation

Question 23 of 25

Question 24 of 25

24. Macros are “run” or executed from the ….. menu?

Data

Frmat

Tools

Insert

Question 24 of 25

Question 25 of 25

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

Option buttons

List boxes

Text boxes

Combo boxes

Question 25 of 25

Test Instructions
Test Name	:	Microsoft Excel MCQs
Subject	:	Computer General
Test Type	:	Mcqs
Total Question	:	25
Total Marks	:	50
Total Time	:	20 Minutes

Gotest

MS Excel Quiz Online Test Mcqs

Test Instructions

MS Excel Quiz Online Test Mcqs Questions with Answers Objective Type PDF

Uncategorized

Check Other Related Topics

Newspaper Jobs in Pakistan




All Daily Jobs in Pakistan click here