MSExcel

Share this page :

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

#2. Text formulas:

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

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

#5. Which function calculates your monthly mortgage payment?

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

#7. You can print only an embedded chart by

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

#9. Rounding errors can occur

#10. Documentation should include

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

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

#13. How we can view a cell comment?

#14. Concatenation of text can be done using

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

#16. Comments can be added to cells using

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

#18. Hyperlinks can be

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

#20. Comments put in cells are called

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

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

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

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

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

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

#27. The chart wizard term data series refers to

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

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

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

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

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

#33. What does the VLOOKUP function do?

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

#35. Excel files have a default extension of

#36. To view a cell comment

#37. An excel workbook is a collection of

#38. All worksheet formula

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

#40. Right clicking something in Excel:

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

#42. How do you delete a column?

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

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

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

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

#47. You can copy data or formulas

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

#49. Which symbol must all formula begin with?

#50. In a worksheet you can select

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

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

#53. How do you insert a row?

#54. You can edit a cell by

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

#56. To save a workbook, you:

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

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

#59. The auto fill feature

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

#61. To create a formula, you first:

#62. You can use the formula palette to

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

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

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

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

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

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

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

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

#71. The auto calculate feature

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

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

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

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

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

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

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

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

#80. you can use the formula palette to

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

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

#83. To delete an embedded objects, first

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

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

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

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

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

#89. 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 ….

#90. Tab scrolling button

#91. How do you select an entire column?

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

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

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

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

#96. When you copy a formula

#97. Each excel file is called a workbook because

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

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

#100. How are data organized in a spreadsheet?

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

#102. A circular reference is

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

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

#105. The number of rows in a worksheet is

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

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

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

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

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

#111. The autofill feature

#112. Which types of charts can excel produce?

#113. How can you delete a record?

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

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

#116. Status indicators are located on the

#117. Excel is a

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

#119. The name box

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

#137. A worksheet range is a

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

#139. You can activate a cell by

#140. Gridlines

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

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

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

#144. The number of columns in a worksheet is

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

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

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

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

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

#150. Each excel file is called a workbook because

Finish

Results

Share this page :

Congratulations

Share this page :
Share this page :

Try

Share this page :
Share this page :