excelmcq

Share this page :

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

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

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

#4. you can use the formula palette to

#5. The number of rows in a worksheet is

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

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

#8. How do you insert a row?

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

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

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

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

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

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

#15. A circular reference is

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

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

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

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

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

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

#22. Documentation should include

#23. How are data organized in a spreadsheet?

#24. How we can view a cell comment?

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

#26. You can activate a cell by

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

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

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

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

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

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

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

#34. How can you delete a record?

#35. The chart wizard term data series refers to

#36. All worksheet formula

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

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

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

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

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

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

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

#44. Which symbol must all formula begin with?

#45. A worksheet range is a

#46. The number of columns in a worksheet is

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

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

#49. To view a cell comment

#50. Hyperlinks can be

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

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

#53. To create a formula, you first:

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

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

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

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

#58. Status indicators are located on the

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

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

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

#62. To delete an embedded objects, first

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

#64. To save a workbook, you:

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

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

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

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

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

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

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

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

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

#74. Concatenation of text can be done using

#75. Gridlines

#76. Text formulas:

#77. How do you select an entire column?

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

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

#80. Each excel file is called a workbook because

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

#82. Which types of charts can excel produce?

#83. You can print only an embedded chart by

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

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

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

#87. Excel is a

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

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

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

#91. Comments can be added to cells using

#92. Tab scrolling button

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

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

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

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

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

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

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

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

#101. Excel files have a default extension of

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

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

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

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

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

#107. In a worksheet you can select

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

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

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

#111. Rounding errors can occur

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

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

#114. You can edit a cell by

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

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

#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. Data can be arranged in a worksheet in a easy to understand manner using

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

#120. An excel workbook is a collection of

#121. How do you delete a column?

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

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

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

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

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

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

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

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

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

#131. Each excel file is called a workbook because

#132. You can copy data or formulas

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

#134. Comments put in cells are called

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

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

#137. The auto fill feature

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

#139. Which function calculates your monthly mortgage payment?

#140. When you copy a formula

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

#142. The autofill feature

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

#144. The name box

#145. You can use the formula palette to

#146. Right clicking something in Excel:

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

#148. What does the VLOOKUP function do?

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

#150. The auto calculate feature

Finish

Results

Share this page :

Congratulations

Share this page :
Share this page :

Try

Share this page :
Share this page :