#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 :
Welcome Visitors. This website founded in 2019, headquartered at Hooghly, West Bengal, India. At Sahojpath.in we provide the educational information/exam news – related to computer subject/competitive exams/entertainment etc.
You can contact this website for any business related advertisement.
Contact for any kind of Website Development / Software Development.