excelmcq

Share this page :

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

#2. Each excel file is called a workbook because

#3. How we can view a cell comment?

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

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

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

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

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

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

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

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

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

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

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

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

#16. Each excel file is called a workbook because

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

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

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

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

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

#22. Excel files have a default extension of

#23. To save a workbook, you:

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

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

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

#27. you can use the formula palette to

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

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

#30. Rounding errors can occur

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

#32. How do you select an entire column?

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

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

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

#36. Gridlines

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

#38. You can print only an embedded chart by

#39. The name box

#40. All worksheet formula

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

#42. How do you delete a column?

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

#44. Right clicking something in Excel:

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

#46. How can you delete a record?

#47. The auto calculate feature

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

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

#50. You can use the formula palette to

#51. What does the VLOOKUP function do?

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

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

#54. The number of rows in a worksheet is

#55. Comments can be added to cells using

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

#57. A circular reference is

#58. Status indicators are located on the

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

#60. Comments put in cells are called

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

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

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

#64. The autofill feature

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

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

#67. An excel workbook is a collection of

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

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

#70. In a worksheet you can select

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

#72. The auto fill feature

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

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

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

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

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

#78. The number of columns in a worksheet is

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

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

#81. Excel is a

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

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

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

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

#86. Text formulas:

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

#88. When you copy a formula

#89. Documentation should include

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

#91. Tab scrolling button

#92. How do you insert a row?

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

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

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

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

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

#98. You can edit a cell by

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

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

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

#102. To create a formula, you first:

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

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

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

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

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

#108. Concatenation of text can be done using

#109. To delete an embedded objects, first

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

#111. Which symbol must all formula begin with?

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

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

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

#115. Which function calculates your monthly mortgage payment?

#116. You can activate a cell by

#117. Hyperlinks can be

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

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

#120. A worksheet range is a

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

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

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

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

#125. How are data organized in a spreadsheet?

#126. To view a cell comment

#127. You can copy data or formulas

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

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

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

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

#132. The chart wizard term data series refers to

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

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

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

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

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

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

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

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

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

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

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

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

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

#146. Which types of charts can excel produce?

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

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

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

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

Finish

Results

Share this page :

Congratulations

Share this page :
Share this page :

Try

Share this page :
Share this page :