MSExcel

Share this page :

#1. Which of the following is not a way to complete a cell entry?

#2. With which of the following all formulas in excel starts?

#3. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

#4. When you insert an Excel file into a Word document, the data are ______.

#5. Macros are “run” or executed from the ….. Menu.

#6. The number of columns in a worksheet is

#7. You can activate a cell by

#8. Which menu option can be sued to split windows into two

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

#10. Which of the following formulas will Excel Not be able to calculate?

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

#12. The number of rows in a worksheet is

#13. To copy cell contents using drag and drop press the

#14. How can you find specific information in a list?

#15. A numeric value can be treated as a label value if it precedes with

#16. When you link data maintained in an excel workbook to a word document

#17. How do you insert a row?

#18. In a worksheet you can select

#19. Which of the following is not a worksheet design criterion?

#20. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

#21. A circular reference is

#22. You can use the format painter multiple times before you turn it off by

#23. If you press …., the cell accepts your typing as its contents.

#24. How are data organized in a spreadsheet?

#25. You cannot link excel worksheet data to a word document

#26. To delete an embedded objects, first

#27. When you want to insert a blank embedded excel object in a word document you can

#28. How many characters can be typed in a single cell in Excel?

#29. What term describes a background that appears as a grainy, non smooth surface

#30. Each excel file is called a workbook because

#31. You can use the horizontal and vertical scroll bars to

#32. Which area in an excel window allows entering values and formulas

#33. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

#34. A features that displays only the data in column (s) according to specified criteria

#35. Tab scrolling button

#36. What function displays row data in a column or column data in a row?

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

#38. The auto fill feature

#39. The Paste Special command lets you copy and paste:

#40. To create a formula, you first:

#41. When a label is too long to fit within a worksheet cell, you typically must

#42. Which button do you click to add up a series of numbers?

#43. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

#44. How do you delete a column?

#45. Text formulas:

#46. The autofill feature

#47. Getting data from a cell located in a different sheet is called

#48. You can convert existing excel worksheet data an charts to an HTML document by using

#49. A typical worksheet has …. Number of columns

#50. What Pivot Table toolbar button updates the data in a Pivot Table ?

#51. The auto calculate feature

#52. Which types of charts can excel produce?

#53. Hyperlinks can be

#54. When the formula bar is active, you can see

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

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

#57. You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu.

#58. To create a formula, you can use:

#59. You can use drag-and-drop to embed excel worksheet data in a word document

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

#61. Rounding errors can occur

#62. Status indicators are located on the

#63. Comments put in cells are called

#64. Which elements of worksheet can be protected from accidental modification

#65. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

#66. Files created with Lotus 1-2-3 have an extension

#67. To save a workbook, you:

#68. To center worksheet titles across a range of cells, you must

#69. When you copy a formula

#70. Which of the following is an absolute cell reference?

#71. You can edit a cell by

#72. To edit in an embedded excel worksheet object in a word document

#73. you can use the formula palette to

#74. How do you select an entire column?

#75. Data can be arranged in a worksheet in a easy to understand manner using

#76. When integrating Word and Excel, Word is usually the

#77. The Chart wizard term data categories refers to;

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

#79. Each excel file is called a workbook because

#80. Which symbol must all formula begin with?

#81. Which of the following is not an option in the spelling dialog box?

#82. If you press ___, the cell accepts your typing as its contents?

#83. To view a cell comment

#84. The chart wizard term data series refers to

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

#86. Right clicking something in Excel:

#87. To copy cell contents using drag and drop, press the

#88. You can edit existing Excel data by pressing the

#89. What symbol is used before a number to make it a label?

#90. Excel uniquely identifies cells within a worksheet with a cell name

#91. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

#92. Documentation should include

#93. Which of these will not select all the cells in a document?

#94. Which of the following will not set text in selected cells to italics?

#95. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

#96. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

#97. You can copy data or formulas

#98. Which is used to perform what if analysis?

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

#100. To activate the previous cell in a pre-selected range, press

#101. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

#102. The default style for new data keyed in a new workbook is ?

#103. Which of the following methods cannot be used to enter data in a cell

#104. Comments can be added to cells using

#105. Which of the following is the oldest spreadsheet package?

#106. Gridlines

#107. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

#108. Which of the following formulas is not entered correctly?

#109. Which of the following methods cannot be used to enter data in a cell?

#110. When integrating word and excel, word is usually the

#111. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

#112. Which of the following is not a valid data type in excel

#113. A worksheet range is a

#114. What term describes explanatory text attached to a cell?

#115. A function inside another function is called a ….. Function.

#116. You can use the formula palette to

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

#118. Which of the following is not a basic step in creating a worksheet?

#119. How we can view a cell comment?

#120. Statistical calculations and preparation of tables and graphs can be done using

#121. It is acceptable to let long text flow into adjacent cells on a worksheet when

#122. “Qtr 1, Qtr 2, Qtr 3” is an example of a

#123. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

#124. All worksheet formula

#125. To copy formatting from one area in a worksheet and apply it to another area you would use:

#126. Which of the following is not a worksheet design criterion?

#127. What does the VLOOKUP function do?

#128. Which of the following methods cannot be used to edit the content of cell?

#129. Which of following is Not one of Excel’s what-if function?

#130. Which of the following is a popular DOS based spreadsheet package?

#131. Excel probably considers the cell entry January 1, 2000 to be a

#132. You can enter which types of data into worksheet cells?

#133. How can you print three copies of a workbook?

#134. You can print only an embedded chart by

#135. Excel is a

#136. You can select a single range of cells by

#137. When you insert an excel file into a word document. The data are

#138. An excel workbook is a collection of

#139. Which of the following is the latest version of Excel

#140. Concatenation of text can be done using

#141. On an excel sheet the active cell in indicated by ?

#142. Which function calculates your monthly mortgage payment?

#143. You can use the drag and drop method to

#144. How can you delete a record?

#145. Multiple calculations can be made in a single formula using

#146. Excel files have a default extension of

#147. Which of the following is not information you can specify using the solver?

#148. Which of the following will not cut information?

#149. Which of the following is not an example of a value?

#150. The name box

Finish

Results

Share this page :

Congratulations

Share this page :
Share this page :

Try

Share this page :
Share this page :