MS Excel 2000 Test 2015

1. What value is displayed if the formula =2+"$9.00" is entered into a cell?

Answers:

• $11

• 11

• 2+$9.00

• $11.00

2. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?

Answers:

• It is used to add a background color to the selected cell

• It is used to add a colored boundary around the selected cell

• It copies the format of a selected cell for applying to another cell

• It deletes the values of all the selected cells

3. Which of the following statements is true if the cell B1 contains the formula =$A$1?

Answers:

• The value of cell B1 contains the same number of characters as the value of cell B2

• There is an absolute reference to cell A1 so that the formula =$A$1 can be copied to other cells without changing the reference to A1

• There is a relative reference to cell A1 so the formula will change each time it is copied to other cells

• The value of cell B1 is equal to the value of the function in cell A1

4. The figure shows the AutoFit Selection menu option. What function does it perform?

Answers:

• It automatically resizes the column width to the minimum necessary to fit the contents of the selected cell

• It automatically resizes the column height to the minimum necessary to fit the contents of the selected cell

• It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

• It automatically compacts the text to fit into the original column size

5. What is conditional formatting used for? (It is available under the menu Format->Conditional Formatting)

Answers:

• It can format a cell depending upon whether the cell contains text or numeric characters

• It can format a cell depending upon the size of content in the cell

• It can format a cell depending upon values of the content in the cell

• It can format a cell depending upon the results of a function

6. How can you select all the blank cells in your worksheet?

Answers:

• This must be done manually as it is not automated through any built-in feature

• Choose Edit->Select->Blank under the main menu

• Choose blank in the Edit->Go To->Special menu option

• Choose blank in the View->Go To->Special menu option

7. The figure shows the Calculation tab under the Tools->Options menu. The option under Calculation has been checked as Automatic. What does this mean?

Answers:

• Excel will calculate the values for all formulas entered into cells when you click Calc Now on the calculation tab

• Excel will automatically calculate the values for all formulas before saving

• Excel will automatically calculate the values for all formulas as you change the values within cells

8. The figure shows an Excel worksheet. What does the red triangle in cell C2 signify?

Answers:

• The cell is locked

• The data entered in the cell will be validated to see if it matches the criteria set

• The cell has been marked so that it can be referred to in case of need

• There is a comment associated with the cell

9. You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Print What->Selection. What will happen?

Answers:

• The print area will be printed

• The selected area will be printed

• Excel will prompt you to de-select the selected area

10. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?

Answers:

• It calculates the mean deviation of the numbers in the selected cells

• It calculates the average value of the selected numbers

• It adds up the values in the selected cells

• It merges the selected cells

11. The figure shows the Text to Column menu option. What function does it perform?

Answers:

• It allows you to add comma separated text into various cells automatically

• It converts the selected text to a table

• It automatically resizes the cell size whenever a large text is added to the cell

12. State whether True or False.

When you clear the contents from a cell, the formatting of the cell is also lost.

Answers:

• True

• False

13. You have a worksheet that contains the first names of customers in column A and last names in column B. You want to enter a formula in column F that combines the first name and the last name and at the same time want to ensure that there is a space between the first and the last name. What would the correct formula be

Answers:

• =A1 & " " & B1

• =A1 &" "& B1

• =A1 + " " + B1

• =A1 & SPC & B1

14. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?

Answers:

• It is used to publish the worksheet on a web browser for viewing over the Internet

• It is used to make the worksheet universally shareable

• It is used to add a hyperlink

15. What should you add before a fraction to avoid entering it as a date, e.g. 1/3, in Excel?

Answers:

• F

• //

• 0 (zero)

• FR

• =

16. In Microsoft Excel, you select the row headings 10, 11 and 12 and then choose the menu option Insert -> Rows. What will happen?

Answers:

• 3 new rows will be inserted after row 12

• 1 new row will be inserted after row 12

• 3 new rows will be inserted after row 9

• 1 new row will be inserted after row 9

17. What is the quickest way to select all the columns of a worksheet in Microsoft Excel?

Answers:

• Click on the column heading of the first column, press Shift, and then click on the column heading of the last column

• Click on the column heading of the first column, press Ctrl, and then click on the column heading of the last column

• Choose Edit->Select all from the main menu

• Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

18. Which toolbar is shown in the figure?

Answers:

• Forms toolbar

• Standard toolbar

• Formatting toolbar

• Chart toolbar

• WordArt toolbar

19. Which of the following statements about the AutoFormat feature in Excel are correct?

Answers:

• AutoFormat can help you automatically convert your numerical data into graphs

• AutoFormat can automatically capitalize the first letters of the text you enter into cells

• AutoFormat resizes your Excel worksheets so that they become easy to print

• AutoFormat applies a distinctive format to the various elements in the range on a worksheet.

20. The figure shows an Excel worksheet. You are about to create a new column called Avg Sales in column G which will display the average sales for Jan to April. Which of the following are correct formulas for cell G2?

Answers:

• =sum(avg(B2.E2))

• =sum(B2-E2)/4

• =sum(B2.E2)/4

• =sum(F2/4)

21. Which of the following statements about the AutoCorrect feature in Excel are correct?

Answers:

• It can suggest other words for the word you are typing

• It can correct two initial capitals

• It can correct common typing errors as you type

• It can capitalize the first letter of the sentence

22. State whether True or False.

We can change the color of the worksheet tabs in our workbook?

Answers:

• True

• False

23. Which of the following formats will you use to enter the time, 3 P.M., in a cell?

Answers:

• 3:00

• 3:00 PM

• 3:00 P

• 3:00PM

24. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'J'?

Answers:

• It calculates the mean deviation of the numbers in the selected cells

• It calculates the average value of the selected numbers

• It adds up the values in the selected cells

• It displays a list of functions and allows you to set values

25. You are making a sales performance report in Excel which you would like to present to the top management. Some of the column headings are too large and look out of place in their cells. You decide to display the headings as slanted text to save space.How can this be achieved?

Answers:

• By selecting Slanted Text on the Font tab

• By altering the Text Orientation on the Alignment tab

• By selecting Superscript on the Font tab

• By choosing Center Across selection on the Alignment tab

26. Which of the following are appropriate date format when you want to enter data into a cell in Microsoft Excel?

Answers:

• 2/3/2003

• 6-aug-2003

• 5th-aug-2003

• 5-8-03

27. You would like to restrict the values that can be entered into a cell so that only whole numbers between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?

Answers:

• The Settings tab under the menu Data->Validation

• The Settings tab under the menu Data->Filter->Advanced Filter

• The Settings tab under the menu Format->Cells

• The Settings tab under the menu Format->Conditional Formatting

28. If you enter a Part Number for a product in Excel e.g. 6776736, and want Excel to treat it as text and not a number, what should you do?

Answers:

• Place the character T before the number e.g. T6776736

• Place the characters TX before the number e.g. TX6776736

• Enclose the number is brackets e.g. (6776737)

• Apply the Text Format to empty cells, and then type the numbers

29. How does the AutoComplete feature in Excel help you save time?

Answers:

• It automatically completes abbreviated words

• It completes text and numeric entries that match an existing entry in the same column

• It completes text entries that match an existing entry in the same worksheet

• It completes text entries that match an existing entry in the same column

30. The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Answers:

• Select the cells A2 to A6 and cells B1 to F1 and click on Freeze Panes under the menu Window->Freeze Panes

• Select the cell B2 and click on Freeze Panes under the menu Window->Freeze Panes

• Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

• Select the cells F1 and A6 and click on Freeze Panes under the menu Window->Freeze Panes

• None of the above