Set 5
1. Excel files have default extensions of XLS.
2. Lotus 1-2-3 is a popular DOS based spreadsheet package.
3. VisiCalc is the oldest spreadsheet package.
4. Files crated with Lotus 1-2-3 have extensions 123.
5. 65,535 characters can be typed in a single cell in Excel.
6. A Worksheet can have a maximum of 65,536 numbers of rows.
7. A typical worksheet as 256 numbers of columns.
8. Comments put in cells are called Cell Tip.
9. Comments can be added to cells using Insert > Comment.
10. Which menu option can be used to split windows into two Window >
11. Getting data from a cell located in a different sheet is called Referencing.
12. Number, Date/Time and Label are valid data type in Excel.
13. Objects, Contents and Scenarios are of a worksheet can be protected from accidental modification.
14. A numeric value can be treated as a label value if it proceeds with Apostrophe (‘).
15. Concatenation of text can be done using Ampersand (&).
16. Data can be arranged in a worksheet in an easy to understand manner using Auto Formatting, Applying Styles and Changing Fonts.
17. Formula bar area in an Excel window allows entering values and formulas.
18. Multiple calculations can be made in a single formula using Array Formula.
19. An Excel Workbook is a collection of Worksheets and Charts.
20. You can convert existing excel worksheet data and charts to an HTML document by using the Internet assistant wizard.
21. When integrating word and excel, word is usually the designation and client.
22. Hyperlinks can be Text, Pictures or Drawing objects.
23. To delete an embedded object, first select it and then press the delete key.
24. When you want to insert a blank imbedded excel object in a word document you can Click the object command on the insert menu.
25. You can drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing the CTRL key.
26. When you ink data maintained in an Excel workbook to a word document The word-document contains a reference to the original source application.
27. To edit in an embedded excel worksheet object in a word document Edit the data in a excel source application.
28. When you insert an excel file into a word document. The data are Linked.
29. You cannot link excel worksheet data to a word document With the copy and paste buttons on the standard toolbar.
30. Pressing the ESC key methods cannot be used to enter data in a cell.
31. You can use the horizontal and vertical scroll bars to View different rows and columns edit the contents of a cell.
32. When the formula bar is activated, you can see The edit formula button, The cancel button and The enter button.
33. Status indicators are located on the Formula bar.
34. You can activate a cell by Pressing the TAB, Clicking the cell and Pressing an arrow key.
35. Each excel file is called a workbook because It can contain many sheets including worksheets and chart sheets.
36. Save the workbook, Enter text and data and Modify the worksheet are basic step in creating a worksheet. But not Copy the worksheet.
37. Tab scrolling buttons Allow you to view additional sheet tabs.
38. The name box Appears to the left of the formula bar.
39. Documentation should include destination and users of the output data, source of input data and information on the purpose of the workbook.
40. Efficiency, Auditibility and Description are worksheet design criterion. But not Description.
41. To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered.
42. You can use the formula palette to Create and edit formulas containing functions.
43. You can select a single range of cells by Dragging over the desired cells.
44. Rounding errors can occurs When you use multiplication, division or exponentiation in a formula.
45. The auto calculates feature Provides a quick way to view the results of an arithmetic operation on a range of cells.
46. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu.
47. To copy cell, cell contents using drag-and-drop press the Ctrl key.
48. You can use the format painter multiple times before you turn it off by Double-clicking the format painter button.
49. It is acceptable to let long text flow into adjacent cells on a worksheet when No data will be entered in the adjacent cells.
50. You can use drag-and-drop method to Copy cell contents and Move cell contents. But not to Add cell contents.
51. Single, Double, Single accounting and Double Accounting are all underline option in the format cells dialog box. But not a Single Engineering.
52. Weight refers to The print density of characters.
53. Ignore, Ignore all and Change option are in the spelling dialog box. But don’t have the Edit option.
54. You can create only a horizontal page break by first selecting A row below the row where you want the page break to occur and A cell in a column a.
55. When working in page break preview, you can View exactly where each page break occurs, Add or remove page breaks and Change the print area.
56. When you work with the large worksheets, you may need to Size the worksheet to fit on a specific number of pages, Add and remove page breaks and Specify only certain print area.
57. Printer selection setup option cannot be set in the page setup dialog box.
58. When you print preview a worksheet, the active portion of the worksheet is displayed.
59. When crating a vertical page break, the active cell must be in row.
60. Gridlines May be turned off for display but turned on for printing, May be turned on or off for printing and may b turned off for display and printing.
61. You can print A range of cells by range name, An entire workbook and A single workbook.
62. The chart wizard Can only b used to create embedded charts.
63. Graphic objects on a chart are used to, Add emphasis to chart data, Add interest to a chart and Help explain the chart data.
64. When you use the fill effects in the format data series dialog box, you can select pattern; background and foreground color. But not have Rotate text on the chart.
65. You can inset labels for All the data markers on a chart, A data series and A selected data marker.
66. Chart tips can Show the formatting of a data label, name of a data series or value of a data point.
67. A data map is helpful To show a geographic distribution of data.
68. You can print only an embedded chart by Moving the chart to a chart sheet before you print and Selecting the chart before you print.
69. Data markers on a chart are linked to data points in a worksheet, therefore you can change position or a data marker and automatically change the data point value in the worksheet.
70. To select an individual data marker or data label, you must double click the marker or label.
71. Using the F11 shortcut key to create a chart sheet creates A 2-dimensional column chart.
72. You can crate hyperlinks from an excel workbook to A web page on a company intranet, A web page on the internet and Other excel workbooks.
73. To drag a selected range of data to another worksheet in the same workbook, use the Alt key.
74. You can group noncontiguous worksheets with the ctrl key and the mouse.
75. When you group worksheets you can print more than one worksheet at a time and You can enter common data, formulas and formats on multiple worksheets at one time.
76. The drag-and-drop method of copying or moving data can be used between worksheets.
77. A 3-D reference in formula Span worksheets.
78. Pressing Spacebar is NOT a way to complete a cell entry.
79. = is used before a number to make it a label.
80. Serial Number 50671 is NOT an example of a value.
81. Fastest way to getting to cell A1 in a spreadsheet is Press Ctrl+Home.
82. The auto sum button do you click to ad up a series of numbers.
83. The Paste Special command lets you copy and paste The resulting values of a formula instead of the actual formula.
84. $A$1 is an absolute cell reference.
85. $A1 is a mixed cell reference.
86. SUM (SHEET1! B4, SHEET2! B5) is a 3d reference.
87. A1, B6 type are relative cell reference.
88. The numbers in you worksheet look like this: 1000. You want them to look like this: $1,000.00. So click the Currency Style button on the Formatting Toolbar.
89. To copy formatting from one area in a worksheet and apply it to another area you would use: The format Painter button on the Standard toolbar.
90. You want to track the progress of the stock market on a daily basis, line chart should you use.
91. Page Orientation, Margins and Headers & Footers are located in the Page Setup dialog box. But not located Page Break Preview in same place.
92. =SUM(A1:A5)/(10-10), =SUM(A1:A5)-10, =SUM(A1:A5)*.5 are able to calculate in MS Excel but not =SUM(sales)-A3.
93. Select Data> Delete Record from the menu can delete a record.
94. Solver, Goal seek and scenario manager are used to perform what if analysis, but not using Auto Outline option.
95. Input cells are NOT information you can specify using the Solver.
96. A worksheet range is a group of cells.
97. When you copy a formula Excel edits cell references in the newly copied formula.
98. To create a formula, you first select the cell you want to place the formula into.
99. Excel worksheet cells work very similarly to Text boxes common element of the Windows GUI.
100. Text formulas Concatenate and manipulate text.
101. Excel probably considers the cell entry January 1, 2000 to be a value.
102. The ChartWizard term data series refers to a collection of chart data markers.
103. To create a formula you can use values and cell references.
104. All worksheet formula returns a formula result.
105. You can enter Labels, values and formulas types of data into worksheet cells.
106. A circular reference is a formula that either directly or indirectly depends on itself.
107. When a label is too long to fit within a worksheet cell, you typically must Increase the column width.
108. The ChartWizard term data categories refer to a horizontal axis.
109. Excel uniquely identifies cells within a worksheet with Column letters and row numbers.
No comments:
Post a Comment