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.
