MS Excel Mcqs Test Online

Q: How can I prepare for MS Excel Mcqs Test Online?

You can prepare for MS Excel Mcqs Test Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

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

Answer

Press the Alt key

Answer

Pressing the F2 key

Answer

Clicking the formula bar

Answer

Double clicking the cell

Question 2

2. To save a workbook, you?

Answer

Click Save on the Windows Start button

Answer

Select Edit>Save

Answer

Press Ctrl+F5

Answer

Click the save button on the standard toolbar from the menu

Question 3

3. You can edit a cell by?

Answer

Selecting Edit>Edit Cell from the menu

Answer

None of above

Answer

Double clicking the cell to edit it in-place

Answer

Clicking the formula button

Question 4

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

Answer

Column chart

Answer

Line chart

Question 5

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

Question 6

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

Answer

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

Answer

Multiplication and division exponentiation positive and negative values

Answer

Addition and subtraction, positive and negative values, exponentiation

Answer

All of above

Question 7

7. What does the VLOOKUP function do?

Answer

All of above

Answer

Looks up text that contain ‘v’

Answer

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

Answer

Finds related records

Question 8

8. All worksheet formula?

Answer

Return a formula result

Answer

Manipulate labels

Answer

Use the addition operator

Answer

Manipulate values

Question 9

9. How are data organized in a spreadsheet?

Answer

Layers and planes

Answer

Height and width

Answer

Lines and spaces

Answer

Rows and columns

Question 10

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

Answer

Placed in a word table

Answer

Hyperlinked

Question 11

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

Answer

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

Answer

Select Format > Money from the menu

Answer

Click the Currency Style button on the formatting toolbar

Answer

None of these

Question 12

12. Gridlines?

Answer

May be turned off for display but turned on for printing

Answer

A, b and c

Answer

The be turned off for display and printing

Answer

May be turned on or off for printing

Question 13

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

Question 14

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

Answer

Cell comments

Answer

Multiply the selection by a copied value

Answer

Formatting options

Answer

The resulting values of a formula instead of the actual formula

Question 15

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

Answer

Click the object command on the insert menu

Answer

Click the office links button on the standard toolbar

Answer

Click the import excel command on the file menu

Answer

Click the create worksheet button on the formatting toolbar

Question 16

16. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Answer

Press Ctrl +Home

Answer

Press Shift + Home

Answer

Press Home

Answer

Press Alt + Home

Question 17

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

Question 18

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

Answer

Option buttons

Answer

List boxes

Answer

Text boxes

Answer

Combo boxes

Question 19

19. To view a cell comment?

Answer

click the display comment command on the window menu

Answer

click the edit comment command on the insert menu

Answer

position the mouse pointer over the cell

Answer

click the comment command on the view menu

Question 20

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

Question 21

21. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you?

Answer

Press the Enter button

Answer

Press the Edit Formula button

Answer

Press the Erase key

Question 22

22. Which types of charts can excel produce?

Answer

Bar charts and line graphs only

Answer

Line graphs and pie charts only

Answer

Bar charts, line graphs and pie charts

Answer

Only line graphs

Question 23

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

Answer

Page Orientation

Answer

Page Break Preview

Answer

Headers and Footers

Question 24

24. Each excel file is called a workbook because?

Answer

It can be modified

Answer

You have to work hard to create it

Answer

It can contain text and data

Answer

It can contain many sheets including worksheets and chart sheets

Question 25

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

Question 26

Loading...

Total Questions:	25
Time Allowed:	15 Minutes
Total Marks:	25
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	Computer Test Competitive exam Forces test PPSC/Fpsc/SPSC/KPPSC Test Entry test Recruitment test

MS Excel Mcqs Test Online

MS Excel Mcqs Test

MS Excel Mcqs Test Practice Online

Study Plan for MS Excel Mcqs Test Online

How to Use GoTest for Preparation:

More Related Resources

Maan Ali

2 Comments

Leave a Reply Cancel reply