Microsoft Excel 2000 test answer part 1

01. What Function does the ‘Compare Side by Side With’ command on the window menu perform?
Ans: It allows you to scroll through two or more workbooks simultaneously

02. Which of the following functions would return a value of 8?
Ans: round(8.4999,0)

03. What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given bellow?
B1:27
B2:22
B3:28
B4:21
Ans: 0

04. How can you select all the blank cells in your worksheet?
Ans: Choose blank in the Edit->Go to->special Menu option
The question is based upon the figure shown

05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Ans: Its adds up the values in the selected cells

06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
Ans: Use the wrap txt option in the Format->Cells>Alignment Menu

07. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans: #N/A

08. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get John_Smith in Cell C1?
Ans: = A1&”_”&B1

09. Which of the following date and time function will you use to return the serial number of the last day of the month before or after specified number of months?
Ans: EOMONTH

10. Which of the following shortcuts can be used to insert a new line in the same cell?
Ans: Alt+Enter

11. Which of the following function you will use to find the highest number in a series of numbers?
Ans: MAX(B1:B3)
12. State Whether True or false.
Ans: True
13. This question is based upon the figure bellow
What does the purple triangle at the bottom right corner of the cell signify?
Ans: Smart Tag

14. You have created a worksheet which consists a confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans: Select the cells, open the Window menu and click on Hide

15. This question is based upon the figure shown bellow
The figure shows an Excel worksheet. What does the read triangle in C2 signify?
Ans: There is a comment associated with the cell

16. You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans: 3 new rows will be inserted after row 9

17. The figure shows the calculation tab under the Tools->options menu. The option under Calculation has been checked as Automatic. What does this mean?
Ans:

18. Which of the following statements regarding the QUARTILE function is not true?
Ans: The function MEDIAN(array) and QUARTILEarray,2) will return different values when applied to the same array.

19. You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
Ans: Date

20. This question is based upon the figure shown below
What will be the value in the cell C2 as shown in the figure when we use formula = A2+B2?
Ans: 120

21. What is the quickest way to select all the columns on a worksheet?
Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

22. What does the NOW() function returns?
Ans: Returns the serial number of the current date and time

23. A smart tag will be removed from a cell whenﾅﾅﾅﾅﾅﾅ.
Ans: The data in the cell is changed or deleted

24. 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?
Ans: The setting tab under the menu Data->Validation

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

26. You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?
Ans: Hold down the CTRL key during startup

27. How does the AutoComplete feature in Excel help you save time?
Ans: It automatically completes abbreviated words

28. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Z?
Ans: It copies the formatting properties from one cell to another

29.The figure shows the AutoFit Selection menu option. What function does it perform?
Ans: : It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

30. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter A
Ans: It is used to add a hyperlink

31. Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans: Apply the Text Format to empty cells, and then type the numbers

32. What is the quickest way to select all the columns on a worksheet?
Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

33. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans: A_B

34. How can you select all the blank cells in your worksheet?
Ans: This must be done manually as it is not automated through any built-in feature
35. The figure shows an Excel worksheet. If you want to F the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

36. Which of the following functions would return a value of 8?
Ans: b and c

37. You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans: 3 new rows will be inserted after row 9

38. The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter X ?
Ans: It inserts a Diagram or Organization Chart in the worksheet

39.When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.
Ans: TRUE

40. You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans: Select the cells, open the Window menu and click on Hide

41. Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?
Ans: DATEVALUE

42. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Y?
Ans: It adds up the values in the selected cells

43.Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans: #N/A

44. Which of the following function you will use to find the highest number in a series of numbers?
Ans: MAX(B1:B3)

45. You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
Ans: Date]

46. What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?
Ans: #N/A

47. AutoFilter drop-downs are automatically added in the header row of a list when the list is created.
Ans: TRUE

48. What does the NOW() function returns?
Ans: Returns the serial number of the current date and time

49. Which toolbar is shown in the figure?
Ans: Forms toolbar

50. When you clear the contents from a cell, the formatting of the cell is also lost.
Ans: FALSE

51. 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->Selection. What will happen?
Ans: b

52. figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘Z’?
Ans: It copies the formatting properties from one cell to another

53. The multiplication arithmetic operator is represented by which of the following symbols
Ans: *

54. You can select the current row by pressing
Ans: Shift + Spacebar

55. Donelp you do this?
Ans: Select the cells, open the Window menu and click on Hide

56. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Y
Ans: It adds up the values in the selected cells

57. 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?
Ans: The selected area will be printed

58. By default, how is text horizontally aligned inside a cell in Excel?
Ans: Left aligned

59. When using the AutoFill handle to quickly fill a range of cells with the same or consecutive data, the cells need not be adjacent as long as they are within the same sheet.
Ans: False
60. When the AutoSum button is clicked, Excel first looks for a range of numbers above the active cell.
Ans: True

61. A relative cell reference changes when a formula is copied or moved to other locations.
Ans: True
62. If cell entries are changed, the formula will automatically recalculate the values and insert the result in the cell containing the formula.
Ans: True

62. The Merge button on the Formatting toolbar will merge selected cells and right align data within the cells.
Ans: False

63. To move the insertion point down to the next cell, press:
Ans: Enter

64. The cell range A3 through G3 should be keyed in as:
Ans: A3:G3

65. A document created in Excel is referred to as a
Ans: workbook

67. Use this handle to automatically insert the next month in the series, January:
Ans: Fill

68. Which of these operators are in the correct order of operations?
Ans: ^,*,-

69. If the text you entered into a cell does not fit, Excel will display ##### to indicate that the text is too long
Ans: True

70. By default, data in a cell is centered
Ans: False

71. When a new row is added into an Excel worksheet, by default, this row will be inserted just below the active cell.
Ans: True

72. To insert a row, click Insert and then Rows
Ans: True
73. The Split option causes the worksheet to be split into two window panes.
Ans: False

74. A column is inserted immediately to the left of the column containing the active cell unless you choose otherwise
Ans: True

75. To delete a specific cell as well as the text within it, make the cell active and then
Ans: click Edit and then Delete

76. Which of the following is an absolute cell reference
Ans: $B3

77. To select nonadjacent cells, columns, or rows, you must
Ans: hold down the Ctrl key while clicking column, row header, or specific cells

78. When copying selected cells to a new location, you must position the mouse pointer on any border around the selected cells until it turns into a(n)
Ans: arrow pointer

79. When data is linked, a change made in a linked cell is automatically made to other cells in the link.
Ans: True

80. Selected cells and cell contents can be moved or copied within a worksheet but not between worksheets.
Ans: False

81. Time in a cell in Excel is stored as a decimal fraction representing a portion of the day
Ans:True

82. The PMT function is used to calculate a loan payment based on a variable interest rate, payment, and the time period.
Ans: False

83. The gridlines that appear on your worksheet will print as displayed.
Ans: False

84. The FV function is used to calculate the future value of an investment based on a periodic constant payment and interest rate
Ans: True

85. To apply page numbering to a worksheet page, which option in the Page Setup dialog box should you choose
Ans: Header/Footer

86. If a function is included in an argument within a function, it is called a
Ans: Nested Function

87. If you want row and column headings to print, which tab do you click from the Page Setup dialog box?
Ans: Header/Footer

88. A new workbook initially contains this many sheets
Ans: Three

89. An Excel workbook saved in HTML format allows Internet or intranet users to have access to workbook data even if they do not have Excel installed
Ans: True

90. Once the chart is created, data can only be changed in a chart located in the same worksheet as the changed cells
Ans: False

91. Certain chart elements automatically inserted in a chart created by Chart Wizard include a chart legend, labels for the x-axis and y-axis, and a chart title
Ans: False

92. You can double-click a chart element to display the appropriate formatting dialog box.
Ans: True

93. You can change the size of an image by using the white sizing handles.
Ans: True

94. To make the image taller or shorter, use the middle sizing handle at the left or right side of the image.
Ans: False

95. Which of the following is not a tab on the Chart Options dialog box?
Ans: Patterns

96. This chart is the default chart
Ans: Column Chart

97.Which of the following displays the contents of the active cell?
Ans: Formula bar

98. A worksheet is an individual page or tab in the workbook.
Ans: True

99. You can copy cell formats from one cell to another by using the
Ans: Format Painter

Twitter records of Sachin Tendulkar

Down to play his last Test performance in the field , as well as Indian batsman Sachin Tendulkar has set a record . The microblogging site Twitter Tweets Sachin rituitera in India , marking the record . A hearing at the Telegraph online .
100 tons in international cricket, Sachin Tendulkar , 34 thousand more than two decades of his career as well ranasaha numerous deeds Twitter record has been added . 00 th Test match at the legendary batsman wrote in his tweet , " I Am Really tacada with . Sachin tweets his gratitude to the fans . Later confirmed on Twitter India , Sachin had tweeted of record . In India, it is most commonly rituitera record .
Prior to joining Twitter in 010 phaloyarera record time of just 85 hours at 0 to Sachin Tendulkar .
Sachin Tendulkar tweets more than 600 of 10 rituita and each having six thousand more users as their favorite tweet it took very little to the global record . After winning the U.S. presidential election in 01 Barack Obama , who tweeted that it was seven and a half lakhabarera more rituita .
Tendulkar has almost 40 million Twitter phaloyara around .

The inclusion of women on the board of Twitter

Empowerment of women is happening in the world of technology . Yahoo , Microsoft , Facebook, Twitter became the site of one of the women members of the social yogayogeramarjari skaradino . Twitter has been added to the board of the publishing organization and former executive marjari skaradino piyarasanera . Reuters news agency reported .
Empowerment of women at the age of Twitter, a woman member of the board of an organization for a long time , as there was in the face of criticism of the company. Finally, the Board has included 5 December skaradinoke company.
That , however, is the new face of the organization to manage the marjari skaradino . In addition he is the chief executive of the Economist Group , Finland's Nokia cell phone নির্মাতাপ্রতিষ্ঠান served on the board .
Twitter is a public limited company as the SEC . All members of the Board of Directors in the share of men because of the company was under fire . Twitter chief executive Dick kastoloke Vivek oyadhaoya Fellow at Stanford University, was criticized on the matter .
Twitter officials said , as a member of the Board of Directors Audit Committee is in charge of skaradino Twitter will replace David rojenablatera . Joins Twitter skaradino getting a certain number of shares .

How they love!

Bill Gates

After a six- year relationship with girlfriend Melinda French Empire ruler of Microsoft Bill Gates thought it was one of the questions that arise . And then rent a whole plane to fly , he fell sakhike omahaya Nebraska state . In the absence of any passenger airliner is not going to say that is exactly what was on the bill melindake . However , this type of aircraft straight from the nemei into an elite jewelery stores . Attended the reception to tell them ? One of the world 's top bapheta Rich Warren . He had actually arranged dokanata open , so you can choose the engagement ring solitary pair of boyfriend . So the engagement ring , the wedding ceremony. The islands of Hawaii manale Bay hotelatai hired full swing to heal the marriage bill.

Mark jakarabarga

Billion Dollar Club member of the 9 -year -old Pricilla Chan jakarabarga but very sadamatabhabei serechilena wedding episode . For almost nine years at gariyechila Couple Romance Episode . When jakarabarga cyanake marriage proposal , then ruby engagement ring set with a diamond chosen . Ring the price of 5 dollars . Club planned to spend billions of dollars too awkward ! Couple had fun at marriage . Back at his home in Palo altote was uthonei wedding party. How many guests are invited to a graduation party, it is thought that Chan . But I was surprised by the jakarabarga Chan announced their wedding there .

Technology is less known, if a job!

Mobile phones , tabs , used laptop ? Ie , you have to involve yourself with the technology revolution . But have you ever wondered that this technology - skills in how to tinker with your work ? You might think that you do not know nothing about the technology , laptop - mobile or keys and there !
If you 're cakariprarthi , the technology - it is now more important than skill . Not knowing too much about the technology successfully technology now - you can apply the corresponding cakarigulote can quickly increase your skills .
The technology - researchers said , the technology sector is growing at a faster rate jobs . Myasebalera technical website statement , the use of technology is increasing day by day and has become the center of attraction of the area . So technology - a degree of skill or experience, if not directly employed in the case of a troop of himself . Prepare yourself mentally for the things that will make for quick learning .
In addition to the skills or experience in the field of technology , why think yourself qualified for such work :

Stealth technology is not an issue
Like other technology skills - skills can be learned to do the job . Job training is now a lot easier . In addition, monitoring the project and talk with colleagues - have the opportunity to engage in training caught .



Imagine yourself knowledgeable enough

Think smart or intelligent enough to quickly dominate any issues with that in mind . For an entry -level job to be able to think of yourself . Now most of the technology - is seeking candidates for its Business Business Intelligence Affairs . Such jobs can be a great opportunity to improve my skills in the field of technology . In addition, project manager , product developer or Business Analyst positions technology - have the opportunity to learn skills .



Yourself a chance to

Sinking like a machine all the time to keep yourself in the many benefits the technology has to work with . Works to develop new products or create new solutions to make the lives easier for technology - skills can be utilized . It is only a little time to work with the technology .



Create professional network

Prayuktisilpa still in the stage of development . No technology - the associated task in itself have the opportunity to create a strong networking community .



Will require hard work

Many organizations are working to recruit the anabhijnadera . If the purpose of the organization by training them to build efficient and competent . At the beginning of the staff behind the considerable investment institutions . Will utilize this opportunity . Mastered all the skills and hard work will take you through a training phase , which will be useful for the next time the big positions .



Three suggestions

If you wish to work in the field of technology could be used for the most important of the three suggestions . The first self-learning , learning in second and third person to make any concessions on wages Ghamanora head .



Learn manually

Technology to improve the efficiency of self-learning option . In case you can collaborate online . Many online courses you 'll need . From here you can learn the basic of all things . When you have completed the required online courses can specify them with your bios . But just because a job is in technology , fits in your marketing , social media , finance , human resources , etc. You can try the case .



No discount is in learning

Technology - the skills necessary for achieving the greatest enthusiasm , the spirit of learning is not spared . Mentality to everything needed for your desired job will forward you a great deal .



Do not bother about the salary Ghamanora

Beginning with the way things might disrupt learning head start Ghamanora . Usually technology - it takes skill to be made ​​. When the efficiency of the technology and do not need the money drudgeries . But with enough patience to master skills will phelatei off a few things from the head .



Prayuktisilpa branches - branches are ready to welcome new employees to the expansion . You now have the necessary skills , it still will not be able to stick to anything . Just wait your legs extended . Adapt yourself with the technology revolution . Wait for what ?

Became one of oDesk and ilyansa

Online Marketplace is oDesk and ilyansa assembles . The two organizations will work together to set up a new company in the online marketplace may lead . Ilyansa today announced the formation of new companies and associated oDesk has signed a contract with . These two online platforms in more than 180 countries, more than one million are working freelance . All Things Digital says the technology website . Deputy Country Manager in Bangladesh Mamun Khan confirmed ilyansa .

Two of the leading online marketplace in the world , known as ilyansa and oDesk . These two companies unanimously developing a new type of online work in the present value of the benefit will work together to bring some of the services . Freelancers and companies to do business in a further benefit . The structure of the new company , but for the time being , however, the company is one of the two oDesk ilyansa pm Wednesday and will continue to operate as a separate platform .

Ilyansa recommends the online features that will enhance the work of the new organization . One billion of the world as a single institution will find phrilyansarera platform . Are the responsibility of the chief executive of the new organization is currently ilyansa staying as Executive Chairman , Chief Executive Fabio Rosa and the current executive chairman Thomas leyatana Desk . Current CEO Gary soyarata Desk will serve as a strategic advisor . The attachment of the new company name will be announced after the completion of all formalities .

Ilyansa dot lows CEO Fabio Rosa said , ' We are going to do one of two plyatapharmake , who come to work in a place where the world financial and economic development of the believer and always wants to go to work . Finding Work Desk assembles and means ilyansa online freelancer and work around the various benefits the donor will bayaradera .

The oDesk CEO Gary soyarata said , " This combination will become a milestone in creating the work . This moment .7 billion people around the world are connected online , for those who freely choose a job and are hungry to be together from different places . 4 Twenty billion dollars of international job market is now ready to be re-built . Approximately 10 times more speed than the other work to proceed rapidly changing online at work to bring the authority oDesk ilyansa thrilled to be associated with . "



Ilyansa contact

Ilyansa the popular online marketplace where people can work in several ways . Ilyansa Popular Marketplace for freelance work . Ilyansa Currently 170 countries are using 8 million buyer and freelancer 30 million . Each year more than 13 million jobs were posted ilyanse .



About oDesk

Online work platform oDesk popular . Odesk nearly 10 million businesses and approximately 50 million are freelancers . In 2013 , according to the data , a total of more than 100 million dollars has been done to the oDesk platform .

Power Tips for outsourcing jobs

Many jobs are outsourced over the Internet , while others are about to start . Some are easy to find online jobs outsourcing strategies gone . Below are some strategies such .

 Many who four - five jobs ( job ) without applying for a job ( work ) to get . Get others to do the job without having to apply 100 . It depends on how much you lower prices ( rates ) on the application .
Buyer that the buyer make a payment method  bheriphayeda jabe do not apply . Because , any contractor ( freelancer ) to rent or hire in bheriphayeda is the payment method .

 After a post a job as soon as it is likely to apply .

 The more time you're online ( Freelancing Marketplace ) is likely to be more than your chances of getting the job done . Because there are some jobs , which is one of the post - is to submit completed within two hours . Such as voting and voting on Facebook or any other site that collects ; Again, it's just that suddenly has a problem with the website , etc. . So the more time and try to stay online . So the buyer can give you a reply with a message sending .

 See marketplace new jobs being posted every minute , to apply them . Jabe any contractor who has been interviewed , browsed the application is not advised . If the buyer is getting a contractor other than the contractor of choice in the profile will not check .
And those who have given jabe

 If you do not meet the conditions of the application is not advised .
Odesk who

 Two - three worked , now want to apply at more value , they will apply the job down jabatite see that the buyer has paid jabagulora list . If the buyer sees another contractor with his previous work done jabagulote more dollars , then you can apply . Jabagulote more dollars than the previous works karayani the buyer , it is not advised to apply their jabe higher rates .