MS Excel Skills Test Practice Online Quiz Test

MS excel mcqs with solved answers. All excel practical test questions with Answers are here for the students and also for the teachers. Excel assessment practice test with Quiz help. If you can not want to take quiz test then all of these questions are solved here for the test preparations. MS excel mcqs with answers pdf are also available for the students.


You Scored:

Ranking:





Past Papers MS Excel Questions Answers




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

Combo boxes

Option buttons

Text boxes (Answer)

List boxes

 

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

Character (Answer)

Label

Number

Date/time

 

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

 

Press Ctrl +Home (Answer)

Press Shift + Home

Press Alt + Home

Press Home

 

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

Not

IF (Answer)

OR

AND

 

5. To save a workbook, you?

 

Click Save on the Windows Start button

Click the save button on the standard toolbar from the menu (Answer)

Select Edit>Save

Press Ctrl+F5

 

6. All worksheet formula?

Manipulate labels

Return a formula result (Answer)

Use the addition operator

Manipulate values

 

7. How are data organized in a spreadsheet?

Rows and columns (Answer)

Layers and planes

Lines and spaces

Height and width

 

8. What does the VLOOKUP function do?

Looks up text that contain ‘v’

All of above

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

Finds related records (Answer)

 

9. Which types of charts can excel produce?

Bar charts, line graphs and pie charts (Answer)

Only line graphs

Bar charts and line graphs only

Line graphs and pie charts only

 

10. To view a cell comment?

click the comment command on the view menu

position the mouse pointer over the cell (Answer)

click the display comment command on the window menu

click the edit comment command on the insert menu

 

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

Row chart

Column chart

Line chart (Answer)

Pie chart

 

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

Index

Rows

Transpose (Answer)

Hyperlink

 

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

Click the Currency Style button on the formatting toolbar (Answer)

Select Format > Money from the menu

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

None of these

 

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

Double clicking the cell

Press the Alt key (Answer)

Pressing the F2 key

Clicking the formula bar

 

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

Embedded

Hyperlinked

Linked

Placed in a word table (Answer)

 

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

Format

Tools

Insert

Data (Answer)

 

17. You can edit a cell by?

None of above

Selecting Edit>Edit Cell from the menu

Clicking the formula button

Double clicking the cell to edit it in-place (Answer)

 

18. Macros are “run” or executed from the ------------ menu?

Data

Tools (Answer)

Format

Insert

 

19. 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 (Answer)

Addition and subtraction, positive and negative values, exponentiation

Multiplication and division exponentiation positive and negative values

 

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

The resulting values of a formula instead of the actual formula (Answer)

Cell comments

Multiply the selection by a copied value

Formatting options

 

21. Each excel file is called a workbook because?

It can be modified

You have to work hard to create it

It can contain many sheets including worksheets and chart sheets (Answer)

It can contain text and data

 

22. 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 object command on the insert menu (Answer)

Click the create worksheet button on the formatting toolbar

Click the office links button on the standard toolbar

 

23. Gridlines?

The be turned off for display and printing

May be turned off for display but turned on for printing

May be turned on or off for printing

A, b and c (Answer)

 

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

Page Orientation

Margins

Page Break Preview (Answer)

Headers and Footers

 

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 Enter button

Press the Edit Formula button

Press the Erase key

Press Esc (Answer)




Most important past papers ms office mcqs pdf format. MS Excel Test All ms office mcqs with answers with excel questions and answers pdf solutions. Most ms office mcqs with answers pdf are very helpful.