1. Panes created using the vertical split bar scroll together horizontally. ________________________
Answer
Correct Answer:
A relative cell reference instructs
Note: This Question is unanswered, help us to find answer for this one
2. The summary function that calculates the smallest data value in a pivottable report is ____.
Answer
Correct Answer:
Min
Note: This Question is unanswered, help us to find answer for this one
3. In pivottables, ____ fields correspond to columns in the original data.
Answer
Correct Answer:
Category
Note: This Question is unanswered, help us to find answer for this one
4. A(n) ____ is an entry in a cell that contains text such as 2016 sales or travel expenses.
Answer
Correct Answer:
Label
Note: This Question is unanswered, help us to find answer for this one
5. One of the benefits of live preview is that it _____.
Answer
Correct Answer:
Lets you see and evaluate different formats as you develop your workbook
Note: This Question is unanswered, help us to find answer for this one
6. The name peter is entered in cell b4. this is a ____.
Answer
Correct Answer:
Label.
Note: This Question is unanswered, help us to find answer for this one
7. The goal of a ______ is to convey the maximum amount of information within a very small space.
Answer
Correct Answer:
Sparkline
Note: This Question is unanswered, help us to find answer for this one
8. Voice and unified communications are ________ applications that use 64-byte ip packets.
Answer
Correct Answer:
Real-time
Note: This Question is unanswered, help us to find answer for this one
9. Viewing a pivottable report only for a subset that meets a selection criterion is known as ____.
Answer
Correct Answer:
Filtering
Note: This Question is unanswered, help us to find answer for this one
10. The ____ caption indicates a worksheet group.
Answer
Correct Answer:
Group
Note: This Question is unanswered, help us to find answer for this one
11. Text annotations are ____ that you can add to further describe the data in your chart.
Answer
Correct Answer:
Labels
Note: This Question is unanswered, help us to find answer for this one
12. The _____ alert accepts the invalid data but still allows you to cancel the data entry.
Answer
Correct Answer:
Information
Note: This Question is unanswered, help us to find answer for this one
13. If either ____ or sharing is enabled, excel enables the other by default.
Answer
Correct Answer:
Tracking
Note: This Question is unanswered, help us to find answer for this one
14. Goal seek uses a different approach from traditional _______ analysis.
Answer
Correct Answer:
What-if
Note: This Question is unanswered, help us to find answer for this one
15. When a mistake of fact occurs, ______ is absent.
Answer
Correct Answer:
Chervrons
Note: This Question is unanswered, help us to find answer for this one
16. Excel's ____ function is used to perform a test of independence.
Answer
Correct Answer:
CHISQ.DIST.RT
Note: This Question is unanswered, help us to find answer for this one
17. Excel treats ____ as graphic objects that can be moved, resized, and formatted.
Answer
Correct Answer:
Slicers
Note: This Question is unanswered, help us to find answer for this one
18. By default, excel keeps a change history of ____ days for a shared workbook.
Answer
Correct Answer:
30
Note: This Question is unanswered, help us to find answer for this one
19. ____ a shape within a smartart graphic means moving it to a lower level.
Answer
Correct Answer:
Demoting
Note: This Question is unanswered, help us to find answer for this one
20. When creating a pivottable report, the active cell should be positioned ____.
Answer
Correct Answer:
Anywhere in the range that contains the data
Note: This Question is unanswered, help us to find answer for this one
21. A subtotal row must contain at least one ________ function.
Answer
Correct Answer:
Aggregate
Note: This Question is unanswered, help us to find answer for this one
22. Importing ____ provides greater flexibility to manipulate text in excel.
Answer
Correct Answer:
Raw data
Note: This Question is unanswered, help us to find answer for this one
23. Click the save button on the ____ to overwrite a previously saved file.
Answer
Correct Answer:
Quick Access Toolbar
Note: This Question is unanswered, help us to find answer for this one
24. A(n) _______ is a limit that is placed on a solver problem
Answer
Correct Answer:
Constraint
Note: This Question is unanswered, help us to find answer for this one
25. Excel's __________ can be used to construct a frequency distribution for categorical data.
Answer
Correct Answer:
COUNTIF function
Note: This Question is unanswered, help us to find answer for this one
26. ____ makes it easier to enter repetitive text in cells.
Answer
Correct Answer:
AutoComplete
Note: This Question is unanswered, help us to find answer for this one
27. The ____ function calculates the number of entries in a table.
Answer
Correct Answer:
COUNT
Note: This Question is unanswered, help us to find answer for this one
28. A(n) _______ is a limit that is placed on a solver problem's solution.
Answer
Correct Answer:
Constraint
Note: This Question is unanswered, help us to find answer for this one
29. With the last quarter criteria filter, quarters are defined as, for example, ____.
Answer
Correct Answer:
April, May, June
Note: This Question is unanswered, help us to find answer for this one
30. To hide an entire workbook on an unattended computer, click the hide button on the ____.
Answer
Correct Answer:
(VIEW tab | Window group)
Note: This Question is unanswered, help us to find answer for this one
31. To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key
Answer
Correct Answer:
ESC
Note: This Question is unanswered, help us to find answer for this one
32. Excel supports all of the following types of sparklines except ____.
Answer
Correct Answer:
A true/false sparkline for help making decisions
Note: This Question is unanswered, help us to find answer for this one
33. To size a chart proportionately, hold down the ________ key and ________.
Answer
Correct Answer:
Shift; drag a corner sizing handle.
Note: This Question is unanswered, help us to find answer for this one
34. Charts can either be embedded in a worksheet or placed in a separate ____.
Answer
Correct Answer:
Chart sheet
Note: This Question is unanswered, help us to find answer for this one
35. You should create good ____ to ensure your workbooks are free of errors.
Answer
Correct Answer:
Test data
Note: This Question is unanswered, help us to find answer for this one
36. Setting the _____ to a1:l10 will print only data in those cells.
Answer
Correct Answer:
Print Area
Note: This Question is unanswered, help us to find answer for this one
37. Headers, footers, and margins are all ____ options.
Answer
Correct Answer:
Page setup
Note: This Question is unanswered, help us to find answer for this one
38. To copy the contents of a cell to the cell directly below it, click the target cell and press ____.
Answer
Correct Answer:
CRTL
Note: This Question is unanswered, help us to find answer for this one
39. The opposite of merging cells is splitting a merged cell. _________________________
Answer
Correct Answer:
Standard
Note: This Question is unanswered, help us to find answer for this one
40. Pressing the ____ key to complete an entry activates the adjacent cell to the right.
Answer
Correct Answer:
Left-aligned
Note: This Question is unanswered, help us to find answer for this one
41. Each worksheet has a sheet name that appears on a(n) ____ at the bottom of the workbook.
Answer
Correct Answer:
Sheet tab
Note: This Question is unanswered, help us to find answer for this one
42. You can drill all of the following down through a workbook except ____.
Answer
Correct Answer:
Groupings.
Note: This Question is unanswered, help us to find answer for this one
43. When excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
Answer
Correct Answer:
26
Note: This Question is unanswered, help us to find answer for this one
44. To paste copied cell contents, you can press the ____ keys.
Answer
Correct Answer:
CTRL+V
Note: This Question is unanswered, help us to find answer for this one
45. The following sequence, jan, feb, mar, etc., is an example of a ____ series.
Answer
Correct Answer:
Date
Note: This Question is unanswered, help us to find answer for this one
46. The first sort field in a sort is called the major sort field. ____________________
Answer
Correct Answer:
Secondary sort
Note: This Question is unanswered, help us to find answer for this one
47. The path to the format painter button is ____.
Answer
Correct Answer:
(HOME tab | Clipboard group).
Note: This Question is unanswered, help us to find answer for this one
48. Using autofill, what would be the extended series of the initial entry jan? ___
Answer
Correct Answer:
Feb, Mar, Apr
Note: This Question is unanswered, help us to find answer for this one
49. In a line chart, the data markers are the points connected by the line. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
50. Function(argument1, argument2, ...) is ____.
Answer
Correct Answer:
The general syntax of all functions.
Note: This Question is unanswered, help us to find answer for this one
51. A data ____ table describes the fields you plan to maintain in a table
Answer
Correct Answer:
Definition
Note: This Question is unanswered, help us to find answer for this one
52. You can apply font styles and alignment options using the ____ tab of the ribbon.
Answer
Correct Answer:
INSERT
Note: This Question is unanswered, help us to find answer for this one
53. A cell is referred to by its cell ____.
Answer
Correct Answer:
Reference
Note: This Question is unanswered, help us to find answer for this one
54. ____ format codes allow you to specify how a cell entry assigned a format will appear.
Answer
Correct Answer:
Custom
Note: This Question is unanswered, help us to find answer for this one
55. ____ order arranges labels in reverse alphabetical order, from a to z
Answer
Correct Answer:
Descending
Note: This Question is unanswered, help us to find answer for this one
56. A pie slice is a data marker that represents ____ from a data series
Answer
Correct Answer:
Only one value
Note: This Question is unanswered, help us to find answer for this one
57. In a clustered column chart, the names of each column are part of the ____ series.
Answer
Correct Answer:
Data
Note: This Question is unanswered, help us to find answer for this one
58. In pie charts, its best to make the slice colors as similar as possible. ___________
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
59. The ____ option button lists formatting options following an insertion of cells, rows, or columns.
Answer
Correct Answer:
Insert
Note: This Question is unanswered, help us to find answer for this one
60. Placing a chart in a ____ displays only the chart and no worksheet cells.
Answer
Correct Answer:
Chart sheet
Note: This Question is unanswered, help us to find answer for this one
61. On a pie chart, the ________ determines the size of each pie slice.
Answer
Correct Answer:
Data series
Note: This Question is unanswered, help us to find answer for this one
62. PMT(rate, nper, pv [, fv=0] [, type=0]) in the figure above, pv stands for the ____.
Answer
Correct Answer:
Present value of the loan
Note: This Question is unanswered, help us to find answer for this one
63. In a(n) _______ trend, the values change by a constant amount.
Answer
Correct Answer:
Linear
Note: This Question is unanswered, help us to find answer for this one
64. A chart that compares three set of values in a three-dimensional chart is _____.
Answer
Correct Answer:
Surface
Note: This Question is unanswered, help us to find answer for this one
65. You may use the ______________ settings as an easy way to align text in columns.
Answer
Correct Answer:
Alignment options
Note: This Question is unanswered, help us to find answer for this one
66. You can import data stored on a web site using a(n) ____.
Answer
Correct Answer:
Web query
Note: This Question is unanswered, help us to find answer for this one
67. Whenever a window contains information that is not in view, a(n) ________ will display.
Answer
Correct Answer:
Scroll bar
Note: This Question is unanswered, help us to find answer for this one
68. Validation rules are entered in the ____
Answer
Correct Answer:
Text box
Note: This Question is unanswered, help us to find answer for this one
69. Using ________ allows a cell to change appearance based on criteria.
Answer
Correct Answer:
Conditional formatting
Note: This Question is unanswered, help us to find answer for this one
70. Use ____ references when you want different formulas to refer to the same cell
Answer
Correct Answer:
Absolute
Note: This Question is unanswered, help us to find answer for this one
71. In ____ orientation, a page is taller than it is wide.
Answer
Correct Answer:
Portrait
Note: This Question is unanswered, help us to find answer for this one
72. Each time you create a conditional format, you are defining a conditional formatting _____.
Answer
Correct Answer:
Rule
Note: This Question is unanswered, help us to find answer for this one
73. Each copy of a workbook to be merged must have a different ____.
Answer
Correct Answer:
File name
Note: This Question is unanswered, help us to find answer for this one
74. Formulas created using the point-and-click method contain ____ references.
Answer
Correct Answer:
Absolute
Note: This Question is unanswered, help us to find answer for this one
75. Excel's ________ function retrieves the date and time from the computer's calendar and clock.
Answer
Correct Answer:
Now
Note: This Question is unanswered, help us to find answer for this one
76. Excel organizes fonts into theme and non-theme fonts. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
77. Excel measures row height in _____ and column width in _____.
Answer
Correct Answer:
Points; characters
Note: This Question is unanswered, help us to find answer for this one
78. Excel displays various ________ on the right to enable you to format different chart elements
Answer
Correct Answer:
Panes
Note: This Question is unanswered, help us to find answer for this one
79. Elements in a smartart graphic are grouped in ____.
Answer
Correct Answer:
Levels
Note: This Question is unanswered, help us to find answer for this one
80. Point mode allows you to ____, as shown in the accompanying figure.
Answer
Correct Answer:
Select cells for use in a formula using the mouse pointer
Note: This Question is unanswered, help us to find answer for this one
81. In goal seek, the ________ box contains the formula that calculates the information you seek.
Answer
Correct Answer:
Set cell
Note: This Question is unanswered, help us to find answer for this one
82. When using a spreadsheet, the expression =d8-d17 is called a ________.
Answer
Correct Answer:
Formula
Note: This Question is unanswered, help us to find answer for this one
83. In the accompanying figure, the split double arrow mouse pointer ____.
Answer
Correct Answer:
Is the result of moving the mouse pointer to the boundary between column heading A and column
Note: This Question is unanswered, help us to find answer for this one
84. The ____ button gives options for how to fill cells following a fill operation.
Answer
Correct Answer:
Auto Fill Options.
Note: This Question is unanswered, help us to find answer for this one
85. A form created from two tables that have a ____ relationship creates a main form and a subform.
Answer
Correct Answer:
One-to-Many Relationship
Note: This Question is unanswered, help us to find answer for this one
86. A report formatted where the page is taller than it is wide is formatted in ____.
Answer
Correct Answer:
Portrait orientation
Note: This Question is unanswered, help us to find answer for this one
87. To quickly jump to the last cell in a worksheet press ____.
Answer
Correct Answer:
[Ctrl][End].
Note: This Question is unanswered, help us to find answer for this one
88. The less precise way to move objects in report layout view is to ____.
Answer
Correct Answer:
Drag objects
Note: This Question is unanswered, help us to find answer for this one
89. In a worksheet the ____ is called the formula prefix
Answer
Correct Answer:
Equal sign (=)
Note: This Question is unanswered, help us to find answer for this one
90. In a pie chart, slices that are pulled away are said to be ____.
Answer
Correct Answer:
Exploded
Note: This Question is unanswered, help us to find answer for this one
91. Functions can be entered for formulas using all of the following methods except ____.
Answer
Correct Answer:
Typing the function argument
Note: This Question is unanswered, help us to find answer for this one
92. Excel recognizes an entry as a value if it is a number or it begins with ____.
Answer
Correct Answer:
All of the above.
Note: This Question is unanswered, help us to find answer for this one
93. Excel assigns the name ____ to the first excel table created in a workbook.
Answer
Correct Answer:
Table
Note: This Question is unanswered, help us to find answer for this one
94. Cooler colors tend to pull away from the reader. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
95. Before applying a conditional format in a report, the ____ box must be selected.
Answer
Correct Answer:
Field valued.
Note: This Question is unanswered, help us to find answer for this one
96. Autofill will fill a series when you establish a pattern ________.
Answer
Correct Answer:
With two or more cells
Note: This Question is unanswered, help us to find answer for this one
97. A ____ is an individual media file, such as art, sound, animation, or a movie.
Answer
Correct Answer:
Clip
Note: This Question is unanswered, help us to find answer for this one
98. ________ software is used to perform calculations and numerical analyses.
Answer
Correct Answer:
Spreadsheet.
Note: This Question is unanswered, help us to find answer for this one
99. Today is an example of a(n) ____________________ function.
Answer
Correct Answer:
Date
Note: This Question is unanswered, help us to find answer for this one
100. To switch to ____ mode, you double-click the cell.
Answer
Correct Answer:
Edit
Note: This Question is unanswered, help us to find answer for this one
101. To split a merged cell, select the cell and click the ____ button.
Answer
Correct Answer:
Merge and center
Note: This Question is unanswered, help us to find answer for this one
102. To select nonadjacent changing cells, press and hold the _______ key as you click each cell.
Answer
Correct Answer:
Ctrl
Note: This Question is unanswered, help us to find answer for this one
103. To rotate text in a worksheet, in the format cells dialog box, you can click and drag the ________.
Answer
Correct Answer:
Blue diamond
Note: This Question is unanswered, help us to find answer for this one
104. To resize an embedded chart, ____.
Answer
Correct Answer:
Select the chart and drag the corner sizing handle of the selection box
Note: This Question is unanswered, help us to find answer for this one
105. To perform a what-if analysis with more than two input cells, you _______.
Answer
Correct Answer:
Use only exchange values
Note: This Question is unanswered, help us to find answer for this one
106. To keep a workbook displayed in the recent files list in backstage view, you click the ________.
Answer
Correct Answer:
Pushpin icon
Note: This Question is unanswered, help us to find answer for this one
107. To create range names for multiple cells at once, use the ________ tool.
Answer
Correct Answer:
Create from selection
Note: This Question is unanswered, help us to find answer for this one
108. To center worksheet data horizontally and vertically on a page, use the ________ dialog box.
Answer
Correct Answer:
Margins
Note: This Question is unanswered, help us to find answer for this one
109. To add a sort field in the sort dialog box, click the ____ button.
Answer
Correct Answer:
Add Level
Note: This Question is unanswered, help us to find answer for this one
110. To add a blank table to a page, use the table button on the ____ tab.
Answer
Correct Answer:
INSERT
Note: This Question is unanswered, help us to find answer for this one
111. The worksheet is organized into individual cells. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
112. The report layout tools tabs are ____ tabs available only when working with report objects.
Answer
Correct Answer:
Contextual
Note: This Question is unanswered, help us to find answer for this one
113. The insert function dialog box has a(n) ____ option
Answer
Correct Answer:
Search
Note: This Question is unanswered, help us to find answer for this one
114. The formula bar displays the value or formula of the active cell. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
115. The find & select button is found in the editing group on the ____ tab on the ribbon.
Answer
Correct Answer:
HOME
Note: This Question is unanswered, help us to find answer for this one
116. The fields you use to order your data are called sort ____.
Answer
Correct Answer:
Fields
Note: This Question is unanswered, help us to find answer for this one
117. The default view for a worksheet is ____.
Answer
Correct Answer:
Normal view
Note: This Question is unanswered, help us to find answer for this one
118. The default border color around a chart title is ____.
Answer
Correct Answer:
Blue
Note: This Question is unanswered, help us to find answer for this one
119. The conditional formatting button provides access to the _____.
Answer
Correct Answer:
Manage Rules option
Note: This Question is unanswered, help us to find answer for this one
120. The code _____ will display the filename of the current workbook.
Answer
Correct Answer:
&[File]
Note: This Question is unanswered, help us to find answer for this one
121. The clear all option in the clear button removes the ____ from the active cell.
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
122. The best way to apply page setup options to multiple worksheets is to ________.
Answer
Correct Answer:
Group the worksheets
Note: This Question is unanswered, help us to find answer for this one
123. The amount of money being loaned is known as the ____.
Answer
Correct Answer:
Principal
Note: This Question is unanswered, help us to find answer for this one
124. The accounting number format assigns a floating dollar sign. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
125. The _____ sheet button allows you to add worksheets to a workbook.
Answer
Correct Answer:
New
Note: This Question is unanswered, help us to find answer for this one
126. The ____ is the typeface used to display and print data. it is measured in
Answer
Correct Answer:
Font: points
Note: This Question is unanswered, help us to find answer for this one
127. The ____ identifies which data markers are associated with each data series.
Answer
Correct Answer:
Legend
Note: This Question is unanswered, help us to find answer for this one
128. The ____ button allows you to move through a formula step by step.
Answer
Correct Answer:
Evaluate Formula
Note: This Question is unanswered, help us to find answer for this one
129. The ____ button allows you to erase recent cell entries.
Answer
Correct Answer:
Undo
Note: This Question is unanswered, help us to find answer for this one
130. The ____ aggregate function finds the smallest value.
Answer
Correct Answer:
Min
Note: This Question is unanswered, help us to find answer for this one
131. Select _______ to apply formatting to several cells at the same time.
Answer
Correct Answer:
A range
Note: This Question is unanswered, help us to find answer for this one
132. Print all, pages, and selected record(s) are options available from the ____ for printing forms.
Answer
Correct Answer:
Print dialog box
Note: This Question is unanswered, help us to find answer for this one
133. Placing a chart in a ____ dlls.
Answer
Correct Answer:
Chart sheet
Note: This Question is unanswered, help us to find answer for this one
134. Only images that are ____ are free for anyone to use without permission.
Answer
Correct Answer:
In the public domain
Note: This Question is unanswered, help us to find answer for this one
135. Normal view shows how the worksheet will appear when printed. _________________________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
136. Names are ____ to the workbook
Answer
Correct Answer:
Global
Note: This Question is unanswered, help us to find answer for this one
137. You would ________ a table if you wanted to display only data that matches specific criteria.
Answer
Correct Answer:
Filter
Note: This Question is unanswered, help us to find answer for this one
138. You should hold down the ____ key to select the nonadjacent cells.
Answer
Correct Answer:
CTRL
Note: This Question is unanswered, help us to find answer for this one
139. You can use _____ to reference cells within an excel table.
Answer
Correct Answer:
Cell and range addresses
Note: This Question is unanswered, help us to find answer for this one
140. You can use ____ to move around in a document that is too large to fit on the screen at once.
Answer
Correct Answer:
Scroll bars
Note: This Question is unanswered, help us to find answer for this one
141. You can switch to page layout view by clicking the page layout button ____.
Answer
Correct Answer:
On the status bar
Note: This Question is unanswered, help us to find answer for this one
142. You can replace a formula with its function so it remains constant.__________
Answer
Correct Answer:
True/Function
Note: This Question is unanswered, help us to find answer for this one
143. You can display the ____ tab to specify page setup options.
Answer
Correct Answer:
Page Layout
Note: This Question is unanswered, help us to find answer for this one
144. You can customize a format code in a cell entry to specify how ____ are displayed in a cell.
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
145. You can click the ____ button to undo an automatic correction.
Answer
Correct Answer:
AutoCorrect Options
Note: This Question is unanswered, help us to find answer for this one
146. You can add a text box using the chart tools ____ tab.
Answer
Correct Answer:
Format.
Note: This Question is unanswered, help us to find answer for this one
147. When you type text in a cell it is ________.
Answer
Correct Answer:
Left aligned
Note: This Question is unanswered, help us to find answer for this one
148. When you _______ data, you specify which records you want to retrieve using specific criteria.
Answer
Correct Answer:
Filter
Note: This Question is unanswered, help us to find answer for this one
149. When working with a large worksheet, you can split the window into ____ panes.
Answer
Correct Answer:
Two or four
Note: This Question is unanswered, help us to find answer for this one
150. When formatting a worksheet to be printed, ________ show where page breaks are located.
Answer
Correct Answer:
Dotted lines
Note: This Question is unanswered, help us to find answer for this one
151. When excel opens, a new blank ________ is displayed.
Answer
Correct Answer:
Workbook
Note: This Question is unanswered, help us to find answer for this one
152. When a cell is part of an active formula, it is surrounded with ________.
Answer
Correct Answer:
A colored border with small boxes on each side
Note: This Question is unanswered, help us to find answer for this one
153. When a cell contains a(n) ____ reference, it means that one of its defining values is itself.
Answer
Correct Answer:
Circular
Note: This Question is unanswered, help us to find answer for this one
154. Viewing and printing options for forms and records are available on the ____ tab.
Answer
Correct Answer:
PRINT PREVIEW
Note: This Question is unanswered, help us to find answer for this one
155. The date you change a file is an example of a(n) ____ property.
Answer
Correct Answer:
Automatically updated
Note: This Question is unanswered, help us to find answer for this one
156. ____ are named combinations of values that are assigned to variables in a model.
Answer
Correct Answer:
Scenarios
Note: This Question is unanswered, help us to find answer for this one
157. When you use a range check, you compare a variable to the _____ value in the range.
Answer
Correct Answer:
Lowest or highest
Note: This Question is unanswered, help us to find answer for this one
158. Pseudocode uses the end-structure statement ____ to clearly show where the structure ends.
Answer
Correct Answer:
Endif.
Note: This Question is unanswered, help us to find answer for this one
159. Like other block-level elements, you can ____ tables using the same styles you've already studied.
Answer
Correct Answer:
Both
Note: This Question is unanswered, help us to find answer for this one
160. By default, numbers appear in the _____ and generally display values exactly as you type them.
Answer
Correct Answer:
General format
Note: This Question is unanswered, help us to find answer for this one
161. You have a column of dog breeds that are in all capital letters. What function would you use to convert those dog breeds so that only the first letter of each word is capitalized?
Answer
Correct Answer:
Proper
Note: This Question is unanswered, help us to find answer for this one
162. Your transactions data set contains more than 10,000 rows. Some rows contain the same transaction. How would you remove the rows containing the identical transactions?
Answer
Correct Answer:
With your cursors in the data range, on Data tab click Remove Duplicates.
Note: This Question is unanswered, help us to find answer for this one
163. To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.
Answer
Correct Answer:
Insert
Note: This Question is unanswered, help us to find answer for this one
164. What is one way to center text in a cell?
Answer
Correct Answer:
Select the cell and, on the Home tab in the Alignment section, click Center (Windows) or Center Text (Mac).
Note: This Question is unanswered, help us to find answer for this one
165. A file extension of .xlsm indicates what type of workbook?
Answer
Correct Answer:
Macro-enabled workbook
Note: This Question is unanswered, help us to find answer for this one
166. To ensure that a collection of shapes are evenly spaced apart from left to right, select the shapes, click Page Layout > Align, and then click _.
Answer
Correct Answer:
Distribute Horizontally
Note: This Question is unanswered, help us to find answer for this one
167. Which chart type provides the best visual display of the relationship between two numeric variables?
Answer
Correct Answer:
XY scatter chart
Note: This Question is unanswered, help us to find answer for this one
168. What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?
Answer
Correct Answer:
Fill
Note: This Question is unanswered, help us to find answer for this one
169. To split text across cells without using Merge & Center, click Formt Cells. The, on ** Alignment** tab, click**_**.
Answer
Correct Answer:
Text control > Merge cells
Note: This Question is unanswered, help us to find answer for this one
170. How would you search an entire workbook with Find & Select?
Answer
Correct Answer:
On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Within drop-down to Workbook.
Note: This Question is unanswered, help us to find answer for this one
171. Cell A1 contains the number 3. Which formula returns the text Apple?
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
172. Which formula contains a valid absolute reference?
Answer
Correct Answer:
=B7*$G$3
Note: This Question is unanswered, help us to find answer for this one
173. What is the difference between a workbook and a worksheet?
Answer
Correct Answer:
An Excel file is a workbook. A workbook contains one or more worksheets.
Note: This Question is unanswered, help us to find answer for this one
174. How do you remove everything (values, formatting, etc.) from a cell?
Answer
Correct Answer:
Select the cell. On the Home tab, click Clear > Clear All.
Note: This Question is unanswered, help us to find answer for this one
175. What is the result of the formula =4&3?
Answer
Correct Answer:
43
Note: This Question is unanswered, help us to find answer for this one
176. How do you remove the background of an inserted image?
Answer
Correct Answer:
Select the image and, on the Picture Tools Format tab, click the Remove Background button.
Note: This Question is unanswered, help us to find answer for this one
177. Before publishing a document, you want to identify issues that may make it difficult for people with disabilities to read. Which feature should you use?
Answer
Correct Answer:
Check Accessibility
Note: This Question is unanswered, help us to find answer for this one
178. Columns D, E, and F are hidden in your worksheet. What is one way to unhide these columns?
Answer
Correct Answer:
Click and drag to select columns C and G, then right-click and select Unhide.
Note: This Question is unanswered, help us to find answer for this one
179. Which is a valid Excel formula?
Answer
Correct Answer:
=(A5+B5)*B7
Note: This Question is unanswered, help us to find answer for this one
180. How can you use Format Painter to apply the format of a single source cell to several nonadjacent destination cells?
Answer
Correct Answer:
C: Select the source cell. Double-click the Format Painter. Click each destination cell. Press Esc.
Note: This Question is unanswered, help us to find answer for this one
181. How can you drill down into a PivotTable to show details?
Answer
Correct Answer:
Select the cell into which you want to drill down and double-click.
Note: This Question is unanswered, help us to find answer for this one
182. What is the intersection of a worksheet row and column?
Answer
Correct Answer:
Cell
Note: This Question is unanswered, help us to find answer for this one
183. What is the difference between pressing the delete key and using the clear command in the Home tab's Editing group?
Answer
Correct Answer:
Deletes removes formulas, values and hyperlinks. clear removes formulas, values, hyperlinks, formats, comments and notes
Note: This Question is unanswered, help us to find answer for this one
184. In the worksheet shown below, cell C6 contains the formula=VLOOKUP(A6,$F$2:$G$10,2,FALSE). What is the most likely reason that #N/A is returned in cell C6 instead of mallory's ID (2H54)
Answer
Correct Answer:
A trailing space probably exist in cell A6 or F7
Note: This Question is unanswered, help us to find answer for this one
185. From which field list was the pivotTalble created?
Answer
Correct Answer:
Rows:donor, event / values: Sum of amount
Note: This Question is unanswered, help us to find answer for this one
186. Which function returns the number of characters in a text string in cell A1?
Answer
Correct Answer:
=LEN(A1)
Note: This Question is unanswered, help us to find answer for this one
187. Which formula calculates the total value of a single row of cells across a range of columns?
Answer
Correct Answer:
=SUM(C15:Y15)
Note: This Question is unanswered, help us to find answer for this one
188. What is Colors[Inventory] referring to here? =SUMIFS(Colors[Inventory],Colors[Colors],"Orange")
Answer
Correct Answer:
The Inventory column in the Colors table
Note: This Question is unanswered, help us to find answer for this one
189. An .xlsx workbook is saved into .csv format. What is preserved in the new .csv file?
Answer
Correct Answer:
Cell values only
Note: This Question is unanswered, help us to find answer for this one
190. In the formula =VLOOKUP(A1,D1:H30,3,FALSE), the lookup value (A1) is being looked for in _.
Answer
Correct Answer:
Columns D through H
Note: This Question is unanswered, help us to find answer for this one
191. Cell A2 contains the value 8 and cell B2 contains the value 9. What happens when cells A2 and B2 are merged and then unmerged?
Answer
Correct Answer:
Cell A2 contains the value 8 and cell B2 is empty.
Note: This Question is unanswered, help us to find answer for this one
192. The NOW() function returns the current date and time as 43740.665218. Which part of this value indicates the time?
Answer
Correct Answer:
665218
Note: This Question is unanswered, help us to find answer for this one
193. Which function returns TRUE if cell A1 contains a text value?
Answer
Correct Answer:
=ISTEXT(A1)
Note: This Question is unanswered, help us to find answer for this one
194. Which function returns the leftmost five characters in cell A1?
Answer
Correct Answer:
=LEFT(A1,5)
Note: This Question is unanswered, help us to find answer for this one
195. Which formula returns the value in cell A10 of the worksheet named Budget Variances?
Answer
Correct Answer:
='Budget Variances'!A10
Note: This Question is unanswered, help us to find answer for this one
196. In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?
Answer
Correct Answer:
Concatenation
Note: This Question is unanswered, help us to find answer for this one
197. How does the appearance of an array formula differ from that of a standard formula?
Answer
Correct Answer:
In the formula bar, an array formula appears surrounded by curly brackets.
Note: This Question is unanswered, help us to find answer for this one
198. What is the term for an expression that is entered into a worksheet cell and begins with an equal sign?
Answer
Correct Answer:
Formula
Note: This Question is unanswered, help us to find answer for this one
199. What does this formula do? =Sum(Sheet1:Sheet4!D18)
Answer
Correct Answer:
It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4
Note: This Question is unanswered, help us to find answer for this one
200. Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?
Answer
Correct Answer:
Conditional Formatting
Note: This Question is unanswered, help us to find answer for this one
201. For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?
Answer
Correct Answer:
AND (B3>=15,B3<=20)
Note: This Question is unanswered, help us to find answer for this one
202. Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?
Answer
Correct Answer:
3
Note: This Question is unanswered, help us to find answer for this one
203. To discover how many cells in a range contain values that meet a single criterion, use the _ function.
Answer
Correct Answer:
COUNTIF
Note: This Question is unanswered, help us to find answer for this one
204. If you start a date series by dragging down the fill handle of a single cell that contains the date 12/1/19, what will you get?
Answer
Correct Answer:
A series of consecutive days following the initial date
Note: This Question is unanswered, help us to find answer for this one
205. In Excel, what do most formulas begin with?
Answer
Correct Answer:
=
Note: This Question is unanswered, help us to find answer for this one
206. Which format setting does not change the background appearance of a cell?
Answer
Correct Answer:
Font color
Note: This Question is unanswered, help us to find answer for this one
207. When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _.
Answer
Correct Answer:
Median
Note: This Question is unanswered, help us to find answer for this one
208. What tool would you use to prevent the input in a cell of a date outside a specific range?
Answer
Correct Answer:
Data Validation
Note: This Question is unanswered, help us to find answer for this one
209. Which Excel add-in will help you find a target result by varying multiple inputs to a formula?
Answer
Correct Answer:
Goal Seek
Note: This Question is unanswered, help us to find answer for this one
210. After activating a chart, which sequence adds a trendline to the chart?
Answer
Correct Answer:
Right-click a data series and select Add Trendline.
Note: This Question is unanswered, help us to find answer for this one
211. Which formula correctly counts the number of numeric values in both B4:E4 and G4:I4?
Answer
Correct Answer:
=COUNT(B4:I4)
Note: This Question is unanswered, help us to find answer for this one
212. Which formula returns the value in cell A1 of the worksheet named MySheet?
Answer
Correct Answer:
=MySheet!A1
Note: This Question is unanswered, help us to find answer for this one
213. Which chart type can display two different data series as a different series type within the same chart?
Answer
Correct Answer:
XY chart
Note: This Question is unanswered, help us to find answer for this one
214. Which function returns the largest value amongst all values within the range H2:H30?
Answer
Correct Answer:
=MAX(H2:H30)
Note: This Question is unanswered, help us to find answer for this one
215. To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?
Answer
Correct Answer:
ROUNDUP
Note: This Question is unanswered, help us to find answer for this one
216. You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?
Answer
Correct Answer:
Data Validation
Note: This Question is unanswered, help us to find answer for this one
217. An organization chart, which shows the hierarchy within a company or organization, is available as _ that is included with Excel.
Answer
Correct Answer:
SmartArt
Note: This Question is unanswered, help us to find answer for this one
218. To ensure shapes and other objects are an equal left-to-right distance apart, select the shapes, click Page Layout > Align, and then click _.
Answer
Correct Answer:
Distribute Vertically
Note: This Question is unanswered, help us to find answer for this one
219. Of the four chart types listed, which works best for summarizing time-based data?
Answer
Correct Answer:
Line chart
Note: This Question is unanswered, help us to find answer for this one
220. You're working with columns whose width and font-size should not be changed. Yet the columns are too narrow to display all the text in each cell. What tool should you use to solve the problem?
Answer
Correct Answer:
Wrap Text
Note: This Question is unanswered, help us to find answer for this one
221. Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?
Answer
Correct Answer:
OFFSET
Note: This Question is unanswered, help us to find answer for this one
222. Which custom format will make the cells in column A appear like the corresponding cells in column B?
Answer
Correct Answer:
MMMM-YYYY
Note: This Question is unanswered, help us to find answer for this one
223. Which formula is NOT equivalent to all of the others?
Answer
Correct Answer:
=SUM(A3,A6)
Note: This Question is unanswered, help us to find answer for this one
224. When using Goal Seek, you can find a target result by varying _ at most.
Answer
Correct Answer:
One input
Note: This Question is unanswered, help us to find answer for this one
225. Which format will display the value 27,500,000 as 27.5?
Answer
Correct Answer:
###.0,,
Note: This Question is unanswered, help us to find answer for this one
226. What is the best way to activate the Excel Help system?
Answer
Correct Answer:
All of these answers.
Note: This Question is unanswered, help us to find answer for this one
227. When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?
Answer
Correct Answer:
The F4 (Windows) or Command+T (Mac)
Note: This Question is unanswered, help us to find answer for this one
228. If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?
Answer
Correct Answer:
The Death Of Chivalry
Note: This Question is unanswered, help us to find answer for this one
229. Which two functions check for the presence of numerical or nonnumerical characters in cells?
Answer
Correct Answer:
ISNUMBER and ISTEXT
Note: This Question is unanswered, help us to find answer for this one
230. Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?
Answer
Correct Answer:
Double-click the vertical boundary between columns C and D.
Note: This Question is unanswered, help us to find answer for this one
231. An answer report shows original and final values of the target cell and changing cells plus ____.
Answer
Correct Answer:
Constraints
Note: This Question is unanswered, help us to find answer for this one
232. PMT (rate, nper, pv, [fv=0], [type=0]
Answer
Correct Answer:
Optional arguments
Note: This Question is unanswered, help us to find answer for this one
233. When you enter a two-digit year that is less than 30, excel changes the year to ____.
Answer
Correct Answer:
20xx
Note: This Question is unanswered, help us to find answer for this one
234. To prevent round-off errors, use the ____ function.
Answer
Correct Answer:
ROUND
Note: This Question is unanswered, help us to find answer for this one
235. To organize large amounts of information, it is best to use ____.
Answer
Correct Answer:
Tables
Note: This Question is unanswered, help us to find answer for this one
236. The median function finds ________.
Answer
Correct Answer:
The middle value in a range of cells
Note: This Question is unanswered, help us to find answer for this one
237. The entry in cell b15 is =sum(b5:b14) which is a ____.
Answer
Correct Answer:
Formula
Note: This Question is unanswered, help us to find answer for this one
238. The ____ error code indicates that a cell reference in a formula is not valid.
Answer
Correct Answer:
#REF!
Note: This Question is unanswered, help us to find answer for this one
239. Circular errors are caused by adding the cell name of a/an _______ cell to a formula
Answer
Correct Answer:
Active
Note: This Question is unanswered, help us to find answer for this one
240. A cell containing a formula that references other cells is said to have ____.
Answer
Correct Answer:
Dependant
Note: This Question is unanswered, help us to find answer for this one
241. Referring to the figure above, the rectangular area to the right of the pie chart is the ____.
Answer
Correct Answer:
Legend
Note: This Question is unanswered, help us to find answer for this one
242. Double-clicking the column line to the right of a column activates the ____ feature for the column.
Answer
Correct Answer:
Autofit
Note: This Question is unanswered, help us to find answer for this one
243. By including worksheets in a ________, you can enter or edit data on them simultaneously.
Answer
Correct Answer:
Group
Note: This Question is unanswered, help us to find answer for this one
244. By default, excel aligns date entries at the ____ of the column.
Answer
Correct Answer:
Right edge
Note: This Question is unanswered, help us to find answer for this one
245. Dates in excel are stored as a serial number starting with ____ as 1 and increasing sequentially.
Answer
Correct Answer:
January 1, 1900
Note: This Question is unanswered, help us to find answer for this one
246. Data in date/time fields are automatically ____-aligned.
Answer
Correct Answer:
Right
Note: This Question is unanswered, help us to find answer for this one
247. Combining two or more selected cells into one cell is called ____ cells
Answer
Correct Answer:
Merging
Note: This Question is unanswered, help us to find answer for this one
248. Cells of the second line of defense called ________ recognize and kill virus-infected cells.
Answer
Correct Answer:
NK cells
Note: This Question is unanswered, help us to find answer for this one
249. Cell references that reference other sheets behind the summary sheet are known as ____ references.
Answer
Correct Answer:
3-d
Note: This Question is unanswered, help us to find answer for this one
250. Cell references in a formula are called ____.
Answer
Correct Answer:
Assumptions
Note: This Question is unanswered, help us to find answer for this one
251. Cell ____ are predesigned combinations of formats
Answer
Correct Answer:
Styles
Note: This Question is unanswered, help us to find answer for this one
252. Because a chart is _______, it can be dragged to another area of the worksheet.
Answer
Correct Answer:
A graphic
Note: This Question is unanswered, help us to find answer for this one
253. As a general rule, you should _____.
Answer
Correct Answer:
Center column titles, left-align text, and right-align numbers
Note: This Question is unanswered, help us to find answer for this one
254. Arrow a is indicating a(n) _____ protein.
Answer
Correct Answer:
Structural
Note: This Question is unanswered, help us to find answer for this one
255. Apa-style papers use ________ as the title of the list of sources.
Answer
Correct Answer:
References
Note: This Question is unanswered, help us to find answer for this one
256. An excel ____ allows data to be summarized and charted easily.
Answer
Correct Answer:
Worksheet
Note: This Question is unanswered, help us to find answer for this one
257. An example of a(n) ____ chart is a column chart with a line chart.
Answer
Correct Answer:
Combination
Note: This Question is unanswered, help us to find answer for this one
258. An adjacent range is a collection of separate ranges. _________________________
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
259. An absolute cell reference _____ change when copied to another cell.
Answer
Correct Answer:
Does not
Note: This Question is unanswered, help us to find answer for this one
260. An __________ is an object in a worksheet.
Answer
Correct Answer:
Embedded Chart
Note: This Question is unanswered, help us to find answer for this one
261. All of the following are options in the delete menu except ____.
Answer
Correct Answer:
Delete All
Note: This Question is unanswered, help us to find answer for this one
262. All functions begin with the formula prefix ____.
Answer
Correct Answer:
=
Note: This Question is unanswered, help us to find answer for this one
263. A(n) ________ refers to a cell by its fixed position in the worksheet.
Answer
Correct Answer:
Absolute cell reference
Note: This Question is unanswered, help us to find answer for this one
264. A(n) ________ is a worksheet where totals from other worksheets are summarized and displayed.
Answer
Correct Answer:
Summary sheet
Note: This Question is unanswered, help us to find answer for this one
265. A(n) _______ is a file that stores a collection of related data.
Answer
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
266. A(n) _____ chart is drawn on the same worksheet as the data.
Answer
Correct Answer:
Embedded
Note: This Question is unanswered, help us to find answer for this one
267. A(n) ____ reference is a formula that depends on its own value.
Answer
Correct Answer:
Circular
Note: This Question is unanswered, help us to find answer for this one
268. A(n) ____ identifies each data series in a chart, generally with a different color.
Answer
Correct Answer:
Legend
Note: This Question is unanswered, help us to find answer for this one
269. A(n) ____ contains little or no formatting.
Answer
Correct Answer:
Text file
Note: This Question is unanswered, help us to find answer for this one
270. A worksheet is made up of _____ organized in a grid of rows and columns.
Answer
Correct Answer:
Cells
Note: This Question is unanswered, help us to find answer for this one
271. A worksheet ____ is a collection of two or more selected worksheets
Answer
Correct Answer:
Group
Note: This Question is unanswered, help us to find answer for this one
272. A theme can be applied using the themes button in the themes group on the ____ tab on the ribbon.
Answer
Correct Answer:
Page Layout
Note: This Question is unanswered, help us to find answer for this one
273. A scatter chart ____.
Answer
Correct Answer:
Compares trends over uneven time or measurement intervals
Note: This Question is unanswered, help us to find answer for this one
274. A range of cells can be converted into an excel ________ so that the data can be analyzed.
Answer
Correct Answer:
Table
Note: This Question is unanswered, help us to find answer for this one
275. A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
Answer
Correct Answer:
Exploded
Note: This Question is unanswered, help us to find answer for this one
276. A macro name can be up to ____ characters long.
Answer
Correct Answer:
255
Note: This Question is unanswered, help us to find answer for this one
277. A lookup table organizes numbers or text into categories. _____________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
278. A field ____ uniquely identifies each column in a data source.
Answer
Correct Answer:
Name
Note: This Question is unanswered, help us to find answer for this one
279. A combination chart can add a(n) ____ axis to chart related data.
Answer
Correct Answer:
Secondary
Note: This Question is unanswered, help us to find answer for this one
280. A chart that is inserted directly in the current worksheet is called a(n) ____ chart.
Answer
Correct Answer:
Embedded
Note: This Question is unanswered, help us to find answer for this one
281. A _____ is a rectangular-shape block of cells in an excel worksheet.
Answer
Correct Answer:
Range
Note: This Question is unanswered, help us to find answer for this one
282. A ____ is used to display only certain records within a table that meet the specified criteria.
Answer
Correct Answer:
Filter
Note: This Question is unanswered, help us to find answer for this one
283. A ____ is text and graphics that print at the bottom of every page.
Answer
Correct Answer:
Footer
Note: This Question is unanswered, help us to find answer for this one
284. A ____ is an interactive view of worksheet data.
Answer
Correct Answer:
PivotTable report
Note: This Question is unanswered, help us to find answer for this one
285. A ____ in excel is like a notebook.
Answer
Correct Answer:
Workbook
Note: This Question is unanswered, help us to find answer for this one
286. A ____ file contains data fields separated by a selected character.
Answer
Correct Answer:
Delimited
Note: This Question is unanswered, help us to find answer for this one
287. _____ messages appear as screentips next to the active cell.
Answer
Correct Answer:
Input
Note: This Question is unanswered, help us to find answer for this one
288. _____ is a single cell that occupies more than one cell row and/or column.
Answer
Correct Answer:
Spanning cell
Note: This Question is unanswered, help us to find answer for this one
289. _____ are an example of conditional formats in excel.
Answer
Correct Answer:
Data bars
Note: This Question is unanswered, help us to find answer for this one
290. ____ is the amount added to the prinicpal of a loan by the lender.
Answer
Correct Answer:
Interest
Note: This Question is unanswered, help us to find answer for this one
291. A constant is a value in a formula that doesn’t change. _______________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
292. Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.
Answer
Correct Answer:
Styles
Note: This Question is unanswered, help us to find answer for this one
293. You should ____ a function name in the formula autocomplete list to select the function.
Answer
Correct Answer:
Double click
Note: This Question is unanswered, help us to find answer for this one
294. The columns and pie slices in the charts above are ____.
Answer
Correct Answer:
Data markers
Note: This Question is unanswered, help us to find answer for this one
295. ____provide descriptive text for the individual data markers, such as pie slices
Answer
Correct Answer:
Data labels
Note: This Question is unanswered, help us to find answer for this one
296. In excel, max and average are examples of ____.
Answer
Correct Answer:
Functions
Note: This Question is unanswered, help us to find answer for this one
297. You can use the ____ key(s) on the keyboard to navigate a worksheet.
Answer
Correct Answer:
Arrow
Note: This Question is unanswered, help us to find answer for this one
298. To move the insertion point to the next cell to the right in a table, you can ____.
Answer
Correct Answer:
Press the Tab key
Note: This Question is unanswered, help us to find answer for this one
299. To copy cell contents, you can select the cell and then press the ____ keys.
Answer
Correct Answer:
CTRL+C
Note: This Question is unanswered, help us to find answer for this one
300. The ____ feature is especially useful when working with very large worksheets.
Answer
Correct Answer:
Summary
Note: This Question is unanswered, help us to find answer for this one
301. To create a summary sheet requires navigation of ____________.
Answer
Correct Answer:
Summary sheet.
Note: This Question is unanswered, help us to find answer for this one
302. When you copy a formula that contains an absolute reference to a new location, the reference ____.
Answer
Correct Answer:
Does not change
Note: This Question is unanswered, help us to find answer for this one
303. To go to column a of the current row press ____
Answer
Correct Answer:
Home
Note: This Question is unanswered, help us to find answer for this one
304. The formula used to multiply cell a1 by cell c1 is ____.
Answer
Correct Answer:
=A1*C1
Note: This Question is unanswered, help us to find answer for this one
305. You can use predesigned, formatted files called ____ to create new worksheets quickly.
Answer
Correct Answer:
Templates
Note: This Question is unanswered, help us to find answer for this one
306. The range of cells receiving copied content is called the ____ area
Answer
Correct Answer:
Destination area
Note: This Question is unanswered, help us to find answer for this one
307. If you deselect an item from the filter menu, it is called the filter ____.
Answer
Correct Answer:
Criterion
Note: This Question is unanswered, help us to find answer for this one
308. You reference columns individually using the ____ element.
Answer
Correct Answer:
Note: This Question is unanswered, help us to find answer for this one
309. When you want to reference an entire column of data in a table, you create a column _____.
Answer
Correct Answer:
Qualifier
Note: This Question is unanswered, help us to find answer for this one
310. When you don’t want to associate a font with a particular design, you use a _____ font.
Answer
Correct Answer:
Non-theme
Note: This Question is unanswered, help us to find answer for this one
311. The ____ option helps fit the data on a single page without making changes to individual margins.
Answer
Correct Answer:
Scale to Fit
Note: This Question is unanswered, help us to find answer for this one
312. A _____ indicates a manual page break.
Answer
Correct Answer:
Solid Blue Line
Note: This Question is unanswered, help us to find answer for this one
313. A pie chart ____.
Answer
Correct Answer:
Compares sizes of pieces as part of a whole.
Note: This Question is unanswered, help us to find answer for this one
314. The default format for cells that meet a condition with conditional formatting is ____.
Answer
Correct Answer:
Light Red Fill with Dark Red Text
Note: This Question is unanswered, help us to find answer for this one
315. You relate tables to one another by using _______ fields.
Answer
Correct Answer:
Common
Note: This Question is unanswered, help us to find answer for this one
316. In producing a newsletter, you should develop ____ with as few words as possible.
Answer
Correct Answer:
Subheads
Note: This Question is unanswered, help us to find answer for this one
317. ____ is extremely useful for making large tables more manageable in size and appearance.
Answer
Correct Answer:
Outlinin g
Note: This Question is unanswered, help us to find answer for this one
318. Which of the following is a statistical function? _____
Answer
Correct Answer:
AVERAGE
Note: This Question is unanswered, help us to find answer for this one
319. Which of the following is a math & trig function? ____
Answer
Correct Answer:
INT
Note: This Question is unanswered, help us to find answer for this one
320. When using vlookup, the _____argument is optional.
Answer
Correct Answer:
Range_lookup
Note: This Question is unanswered, help us to find answer for this one
321. To hide a selected column, click the _____ button in the cells group on the home tab.
Answer
Correct Answer:
Format
Note: This Question is unanswered, help us to find answer for this one
322. The oracle string concatenation function is _____.
Answer
Correct Answer:
CONCAT.
Note: This Question is unanswered, help us to find answer for this one
323. The major difference between hlookup and vlookup functions is the way the lookup tables are _____.
Answer
Correct Answer:
Organized.
Note: This Question is unanswered, help us to find answer for this one
324. The general form of the vlookup function is ____
Note: This Question is unanswered, help us to find answer for this one
325. The countif function is sometimes referred to as a(n) _____ count.
Answer
Correct Answer:
Conditional
Note: This Question is unanswered, help us to find answer for this one
326. The ________ function returns one value if a condition is met, and a different value if it is not.
Answer
Correct Answer:
IF
Note: This Question is unanswered, help us to find answer for this one
327. The ____ of a cell determines how the labels and values look.
Answer
Correct Answer:
Format
Note: This Question is unanswered, help us to find answer for this one
328. Spreadsheets are particularly useful for ____.
Answer
Correct Answer:
What If analysis
Note: This Question is unanswered, help us to find answer for this one
329. In the formula =int(average(a1:a100)), which would occur first? ____
Answer
Correct Answer:
The average of the values in the range A1:A100 is added to the integer.
Note: This Question is unanswered, help us to find answer for this one
330. Cells and ranges in a worksheet can be formatted ____.
Answer
Correct Answer:
Before or after data is entered
Note: This Question is unanswered, help us to find answer for this one
331. By default, the pivottable report uses the ____ function for numbers in the values area.
Answer
Correct Answer:
SUM
Note: This Question is unanswered, help us to find answer for this one
332. All of the following are vertical alignment options except ____
Answer
Correct Answer:
Middle
Note: This Question is unanswered, help us to find answer for this one
333. A(n) ____________________ conveys a visual representation of data.
Answer
Correct Answer:
Chart
Note: This Question is unanswered, help us to find answer for this one
334. A(n) ____ is a group of cells in a rectangular block
Answer
Correct Answer:
Range
Note: This Question is unanswered, help us to find answer for this one
335. A(n) ____ is a built-in formula that uses arguments to calculate information
Answer
Correct Answer:
Function
Note: This Question is unanswered, help us to find answer for this one
336. ###### in a cell means that the ____
Answer
Correct Answer:
Column is too narrow to display the value completely
Note: This Question is unanswered, help us to find answer for this one
337. Values are evaluated using ________ operators.
Answer
Correct Answer:
Arithmetic
Note: This Question is unanswered, help us to find answer for this one
338. If is an example of a ________ function
Answer
Correct Answer:
Logical
Note: This Question is unanswered, help us to find answer for this one
339. Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
340. When you nest functions, you should have ____.
Answer
Correct Answer:
The same number of left and right parentheses
Note: This Question is unanswered, help us to find answer for this one
341. The ____ criteria filter requires the records displayed to have the specified text string anywhere.
Answer
Correct Answer:
Contains
Note: This Question is unanswered, help us to find answer for this one
342. ____ arguments may provide more control over the returned value.
Answer
Correct Answer:
Optional
Note: This Question is unanswered, help us to find answer for this one
343. A table name cannot include ____.
Answer
Correct Answer:
Underscores
Note: This Question is unanswered, help us to find answer for this one
344. A _______ is the cell containing the formula or value the selected cell refers to.
Answer
Correct Answer:
Precedent
Note: This Question is unanswered, help us to find answer for this one
345. The general format of a 3-d cell reference is ____.
Answer
Correct Answer:
WorksheetRange!cellrange
Note: This Question is unanswered, help us to find answer for this one
346. One way to structure text files is to use a(n) _______.
Answer
Correct Answer:
Delimiter
Note: This Question is unanswered, help us to find answer for this one
347. You can ____ a table field if the information stored in a field becomes unnecessary.
Answer
Correct Answer:
Remove
Note: This Question is unanswered, help us to find answer for this one
348. A ________can retrieve data from multiple fields in different tables in the data model
Answer
Correct Answer:
PivotTable
Note: This Question is unanswered, help us to find answer for this one
349. Functions can be selected by using the ________.
Answer
Correct Answer:
Insert Function dialog box
Note: This Question is unanswered, help us to find answer for this one
350. A ____ total sums all of the data in a row or column.
Answer
Correct Answer:
Grand.
Note: This Question is unanswered, help us to find answer for this one
351. In the following formula: =if(a1=""yes"", ""done"", ""restart""), what happens if a1= no? _____
Answer
Correct Answer:
The formula returns the text
Note: This Question is unanswered, help us to find answer for this one
352. The range of cells receiving the content of copied cells is called the ____.
Answer
Correct Answer:
Paste
Note: This Question is unanswered, help us to find answer for this one
353. The numbers, text, or cell references used by the function to return a value are called ____.
Answer
Correct Answer:
Arguments
Note: This Question is unanswered, help us to find answer for this one
354. The header and footer sections include a _____.
Answer
Correct Answer:
Left, right, and center section
Note: This Question is unanswered, help us to find answer for this one
355. The characters +, -, *, and / are examples of ____.
Answer
Correct Answer:
Arithmetic operators
Note: This Question is unanswered, help us to find answer for this one
356. Excel's __________ can be used to construct a crosstabulation.
Answer
Correct Answer:
PivotTable report
Note: This Question is unanswered, help us to find answer for this one
357. Excel remembers the last ____ actions you have completed
Answer
Correct Answer:
100
Note: This Question is unanswered, help us to find answer for this one
358. A ________ displays and summarizes totals from other worksheets.
Answer
Correct Answer:
Summary sheet
Note: This Question is unanswered, help us to find answer for this one
359. Which of the following is not a comparison operator? ____
Answer
Correct Answer:
=<
Note: This Question is unanswered, help us to find answer for this one
360. When you create a calculated column, you can use _____ references to create the formula.
Answer
Correct Answer:
Structured
Note: This Question is unanswered, help us to find answer for this one
361. Using ________ telephone marketing, marketers sell directly to consumers.
Answer
Correct Answer:
Outbound
Note: This Question is unanswered, help us to find answer for this one
362. To open the table styles gallery from the table styles group, click the ____ button.
Answer
Correct Answer:
Modify
Note: This Question is unanswered, help us to find answer for this one
363. The section breaks part of the breaks menu includes all of the following breaks except ____.
Answer
Correct Answer:
Page
Note: This Question is unanswered, help us to find answer for this one
364. Grouping is ________.
Answer
Correct Answer:
Joining rows or columns of related data into a single entity for analysis
Note: This Question is unanswered, help us to find answer for this one
365. _____ refers to cells not wide enough to display the entire entry.
Answer
Correct Answer:
####
Note: This Question is unanswered, help us to find answer for this one
366. Each slice in a pie chart represents a single value from a data series. ____________
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
367. All of the following are valid excel arithmetic operators except ____
Answer
Correct Answer:
>
Note: This Question is unanswered, help us to find answer for this one
368. Data catalogs _____.
Answer
Correct Answer:
Can be shared with everyone within a business
Note: This Question is unanswered, help us to find answer for this one
369. A ________ in a pie chart identifies the pie slices.
Answer
Correct Answer:
Data lable
Note: This Question is unanswered, help us to find answer for this one
370. The study of human interaction with machines in general is called ____.
Answer
Correct Answer:
Human-computer interaction
Note: This Question is unanswered, help us to find answer for this one
371. The if function's logical test returns _____ result.
Answer
Correct Answer:
Only a true or false
Note: This Question is unanswered, help us to find answer for this one
372. The format painter button is found in the ____ group on the home tab of the ribbon.
Answer
Correct Answer:
Clipboard
Note: This Question is unanswered, help us to find answer for this one
373. The following sequence, 2, 4, 6, etc., is an example of a ____ series.
Answer
Correct Answer:
Linear
Note: This Question is unanswered, help us to find answer for this one
374. The first step in creating an effective worksheet is to make sure you ____.
Answer
Correct Answer:
Understand what is required
Note: This Question is unanswered, help us to find answer for this one
375. The default number format is ________.
Answer
Correct Answer:
General
Note: This Question is unanswered, help us to find answer for this one
376. The advanced filter tool can ________.
Answer
Correct Answer:
Search for unique records, only
Note: This Question is unanswered, help us to find answer for this one
377. The ________, when outlined in black, indicates it is ready to accept data.
Answer
Correct Answer:
Active cell
Note: This Question is unanswered, help us to find answer for this one
378. The ________ group on the design tab is useful for adjusting the data source of a chart.
Answer
Correct Answer:
Data
Note: This Question is unanswered, help us to find answer for this one
379. The ________ displays the current cell mode, the page number, and the zoom buttons.
Answer
Correct Answer:
Status bar
Note: This Question is unanswered, help us to find answer for this one
380. The _____ error value means that a value is not available to a function or formula.
Answer
Correct Answer:
#N/A
Note: This Question is unanswered, help us to find answer for this one
381. The ____ function is useful when you want to assign a value to a cell based on a logical test.
Answer
Correct Answer:
IF
Note: This Question is unanswered, help us to find answer for this one
382. The ____ dialog box provides options for moving charts between worksheets and chart sheets.
Answer
Correct Answer:
Move chart
Note: This Question is unanswered, help us to find answer for this one
383. The ____ criteria filter requires the records displayed to have the current date.
Answer
Correct Answer:
Today
Note: This Question is unanswered, help us to find answer for this one
384. The ____ aggregate function finds the largest value.
Answer
Correct Answer:
Max
Note: This Question is unanswered, help us to find answer for this one
385. Tables are organized into rows, called ____.
Answer
Correct Answer:
Records
Note: This Question is unanswered, help us to find answer for this one
386. The underline format will underline ____
Answer
Correct Answer:
Only the characters in the cell
Note: This Question is unanswered, help us to find answer for this one
387. Which of the following is not a date function? ____
Answer
Correct Answer:
AND
Note: This Question is unanswered, help us to find answer for this one
388. You insert a comment in a worksheet by using a command on the ____ tab on the ribbon.
Answer
Correct Answer:
Review
Note: This Question is unanswered, help us to find answer for this one
389. You can split the worksheet window into ____ separate panes.
Answer
Correct Answer:
Two or four
Note: This Question is unanswered, help us to find answer for this one
390. You can insert a ____ at the bottom of a table.
Answer
Correct Answer:
Total row
Note: This Question is unanswered, help us to find answer for this one
391. You can enable or disable macros with options in the ____ dialog box
Answer
Correct Answer:
Excel Options
Note: This Question is unanswered, help us to find answer for this one
392. You can change, or ____, the contents of an active cell at any time.
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
393. You can apply the bold font style by pressing the ____ keyboard shortcut keys.
Answer
Correct Answer:
CTRL+B
Note: This Question is unanswered, help us to find answer for this one
394. You can access the find and replace feature by pressing the ____ key(s).
Answer
Correct Answer:
CTRL+H.
Note: This Question is unanswered, help us to find answer for this one
395. You can ____ the chart title text to select it.
Answer
Correct Answer:
Triple-click
Note: This Question is unanswered, help us to find answer for this one
396. Which of the following is not an excel function category? ____
Answer
Correct Answer:
Algebria
Note: This Question is unanswered, help us to find answer for this one
397. When you click the header & footer button on the insert tab, excel switches to _____ view.
Answer
Correct Answer:
Page Layout
Note: This Question is unanswered, help us to find answer for this one
398. Using the mouse to move or copy cells is called ____.
Answer
Correct Answer:
Drag and drop.
Note: This Question is unanswered, help us to find answer for this one
399. Using the excel spell checker, you can ____.
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
400. Using the _____ key allows you to select multiple items, including multiple worksheet tabs.
Answer
Correct Answer:
Ctrl
Note: This Question is unanswered, help us to find answer for this one
401. Using ________ enables you to select one or more rows or columns and lock them into place.
Answer
Correct Answer:
Freeze Panes
Note: This Question is unanswered, help us to find answer for this one
402. Use the ____ function to enter the system date into a cell in the worksheet.
Answer
Correct Answer:
=NOW()
Note: This Question is unanswered, help us to find answer for this one
403. To start a new line in a cell press the ____ keys
Answer
Correct Answer:
ALT+ENTER
Note: This Question is unanswered, help us to find answer for this one
404. To set a page break in excel, select the _____.
Answer
Correct Answer:
First cell below the row where you want to insert a page break
Note: This Question is unanswered, help us to find answer for this one
405. To make data easier to understand, use a ________ instead of a table of numbers.
Answer
Correct Answer:
Chart
Note: This Question is unanswered, help us to find answer for this one
406. To erase an entire entry in a cell and then re enter the data from the beginning press the ____ key
Answer
Correct Answer:
ESC
Note: This Question is unanswered, help us to find answer for this one
407. To enter data in a cell, you must first select the ____.
Answer
Correct Answer:
Cell
Note: This Question is unanswered, help us to find answer for this one
408. To design a form using the form wizard, begin by clicking on the ____ tab on the access ribbon.
Answer
Correct Answer:
CREATE
Note: This Question is unanswered, help us to find answer for this one
409. To create smartart, switch to the insert tab and use a button in the ____ group.
Answer
Correct Answer:
Illustrations
Note: This Question is unanswered, help us to find answer for this one
410. To ________ a table means to arrange all of the data in a specific order.
Answer
Correct Answer:
Sort
Note: This Question is unanswered, help us to find answer for this one
411. The ____ cell on the worksheet is the one into which you can enter data.
Answer
Correct Answer:
Active
Note: This Question is unanswered, help us to find answer for this one
412. The ____ category of excel functions returns (true-false) values.
Answer
Correct Answer:
Logical
Note: This Question is unanswered, help us to find answer for this one
413. The path to the comma style button is ____.
Answer
Correct Answer:
(HOME tab | Number group)
Note: This Question is unanswered, help us to find answer for this one
414. The percent style button formats selected cells as a percentage with ________.
Answer
Correct Answer:
Zero decimal places
Note: This Question is unanswered, help us to find answer for this one
415. The path to the sum button is ____.
Answer
Correct Answer:
Home tab / Editing
Note: This Question is unanswered, help us to find answer for this one
416. Sheet tab names are ________ when they are grouped.
Answer
Correct Answer:
Underlined
Note: This Question is unanswered, help us to find answer for this one
417. Rows are typically represented by _______ and contain data for individual records.
Answer
Correct Answer:
Numbres
Note: This Question is unanswered, help us to find answer for this one
418. Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.
Answer
Correct Answer:
F11
Note: This Question is unanswered, help us to find answer for this one
419. On a chart created in excel, the vertical axis is also called the ____.
Answer
Correct Answer:
Y-axis
Note: This Question is unanswered, help us to find answer for this one
420. Most software programs can both save and retrieve data in a(n) _______ file format.
Answer
Correct Answer:
Text
Note: This Question is unanswered, help us to find answer for this one
421. Make sure the header row option button is selected to indicate ____.
Answer
Correct Answer:
Not to include that row in a sort
Note: This Question is unanswered, help us to find answer for this one
422. Italic, bold, bold italic, and underline are examples of _____.
Answer
Correct Answer:
Font styles
Note: This Question is unanswered, help us to find answer for this one
423. In the figure above, if you only want to set one criterion for this filter, you will ____.
Answer
Correct Answer:
Leave the lower boxes empty
Note: This Question is unanswered, help us to find answer for this one
424. In the figure above, fv and type are ____.
Answer
Correct Answer:
Optional arguments
Note: This Question is unanswered, help us to find answer for this one
425. In excel, a number can contain the characters ____.
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
426. If all of the logical conditions are true, the and function returns the logical value _____.
Answer
Correct Answer:
TRUE
Note: This Question is unanswered, help us to find answer for this one
427. If a sheet tab has ________ you know that it is not selected.
Answer
Correct Answer:
Background color
Note: This Question is unanswered, help us to find answer for this one
428. Header and footer elements such as worksheet name, current date, and time are _____ elements.
Answer
Correct Answer:
Dynamic
Note: This Question is unanswered, help us to find answer for this one
429. Excel includes ____ types of smartart graphics.
Answer
Correct Answer:
9
Note: This Question is unanswered, help us to find answer for this one
430. Excel allows you to take a ____ of any open window and add it to a workbook.
Answer
Correct Answer:
Screen shot
Note: This Question is unanswered, help us to find answer for this one
431. Every ____ consists of an object that contains a button for each unique value in that field.
Answer
Correct Answer:
Slicer
Note: This Question is unanswered, help us to find answer for this one
432. Error messages begin with the _____ symbol.
Answer
Correct Answer:
#
Note: This Question is unanswered, help us to find answer for this one
433. Data in a form created from the primary table is contained in the ____.
Answer
Correct Answer:
Main form
Note: This Question is unanswered, help us to find answer for this one
434. Ctrl + g is used to access the ____.
Answer
Correct Answer:
Open Find and Replace Dialog box with activating Goto Tab
Note: This Question is unanswered, help us to find answer for this one
435. Columns and rows in a spreadsheet collectively are called a(n) ______.
Answer
Correct Answer:
Worksheet
Note: This Question is unanswered, help us to find answer for this one
436. Clicking the ____ opens the insert function dialog box.
Answer
Correct Answer:
Insert Function box in the formula bar
Note: This Question is unanswered, help us to find answer for this one
437. Clicking the ____ box completes an entry.
Answer
Correct Answer:
Enter
Note: This Question is unanswered, help us to find answer for this one
438. Center, left and right text justification are examples of ________.
Answer
Correct Answer:
Typographic alignment used in formatting a document
Note: This Question is unanswered, help us to find answer for this one
439. Category values are usually located in the ____ of the data source.
Answer
Correct Answer:
Either a or b
Note: This Question is unanswered, help us to find answer for this one
440. By default, excel worksheets appear in ____________ view.
Answer
Correct Answer:
Normal
Note: This Question is unanswered, help us to find answer for this one
441. By default, excel includes _______________ when copying or filling a series.
Answer
Correct Answer:
Formatting
Note: This Question is unanswered, help us to find answer for this one
442. Argument names that display in ________ are required; others are optional.
Answer
Correct Answer:
Bold
Note: This Question is unanswered, help us to find answer for this one
443. An error value begins with a(n) _____ followed by an error name that indicates the type of error.
Answer
Correct Answer:
Number sign
Note: This Question is unanswered, help us to find answer for this one
444. A screen ____ is a portion, usually of one object or section of a window, of the screen.
Answer
Correct Answer:
Clipping
Note: This Question is unanswered, help us to find answer for this one
445. A logical function is a function that works with values that are either ____
Answer
Correct Answer:
True or false
Note: This Question is unanswered, help us to find answer for this one
446. A header contains ____ boxes.
Answer
Correct Answer:
3
Note: This Question is unanswered, help us to find answer for this one
447. A formula can contain ____ and mathematical operators
Answer
Correct Answer:
Arithmetic
Note: This Question is unanswered, help us to find answer for this one
448. A chart sheet can contain ____.
Answer
Correct Answer:
Only one chart
Note: This Question is unanswered, help us to find answer for this one
449. A ________ identifies a worksheet in a workbook.
Answer
Correct Answer:
Sheet tab
Note: This Question is unanswered, help us to find answer for this one
450. A _______ refers to the entire excel file.
Answer
Correct Answer:
Workbook
Note: This Question is unanswered, help us to find answer for this one
451. A _______ is used to analyze and summarize your data without graphical support
Answer
Correct Answer:
PivotTable
Note: This Question is unanswered, help us to find answer for this one
452. A _______ describes the location of a cell based on its column and row location.
Answer
Correct Answer:
Cell address
Note: This Question is unanswered, help us to find answer for this one
453. A ____ is a reference to a cell or range of cells in another workbook.
Answer
Correct Answer:
Link
Note: This Question is unanswered, help us to find answer for this one
454. ________ is the process of arranging data in a specific order based on the value in a field.
Answer
Correct Answer:
Function
Note: This Question is unanswered, help us to find answer for this one
455. ____ shows you how a fill color will look before you apply it.
Answer
Correct Answer:
Live Preview
Note: This Question is unanswered, help us to find answer for this one
456.
This question is based upon the figure shown below.
Which of the following tools is used to format Excel worksheet data, as shown in the figure above?
Answer
Correct Answer:
SmartArt
Note: This Question is unanswered, help us to find answer for this one
457.
This question is based upon the figure shown below
Analyze the image shown. What would be the output when you use the following formula in an MS Excel 2010 worksheet? =SUM(A2:CHOOSE(2,A3,A4,A5))
Answer
Correct Answer:
80
Note: This Question is unanswered, help us to find answer for this one
458.
This question is based upon the figure shown below.
What does the icon marked with a red square in the figure above signify?
Answer
Correct Answer:
It signifies that the document contains digital signatures.
Note: This Question is unanswered, help us to find answer for this one
459.
This question is based upon the figure shown below.
With reference to the screenshot given, which of the following formulae CANNOT be used to calculate the average of the column 'Marks' in the cell 'E17'?
Answer
Correct Answer:
=AVERAGE(E6 to E15)
Note: This Question is unanswered, help us to find answer for this one
460.
This question is based upon the figure shown below.
In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. What will happen when this particular area is selected?
Answer
Correct Answer:
It will select the whole sheet
Note: This Question is unanswered, help us to find answer for this one
461.
This question is based upon the figure shown below
When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.
Answer
Correct Answer:
Worksheet
Note: This Question is unanswered, help us to find answer for this one
462.
State whether the following is true or false: Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
463.
State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
464.
Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members to be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?
Answer
Correct Answer:
Share 'report.xlsx' by saving it to a SharePoint site.
Note: This Question is unanswered, help us to find answer for this one
465.
This question is based upon the figure shown below
Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true?
Answer
Correct Answer:
All cloned copies of that slicer are also updated instantly.
Note: This Question is unanswered, help us to find answer for this one
466.
Excel can publish a workbook to the server only in ________ or ________ format.
Answer
Correct Answer:
.xlsx, .xslb
Note: This Question is unanswered, help us to find answer for this one
467.
You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?
Answer
Correct Answer:
4-Color Scale
Note: This Question is unanswered, help us to find answer for this one
468.
Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
Answer
Correct Answer:
Excel Web Access (EWA)
Note: This Question is unanswered, help us to find answer for this one
469.
What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Answer
Correct Answer:
It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
Note: This Question is unanswered, help us to find answer for this one
470.
Which among the following settings is the default macro security setting
Answer
Correct Answer:
Disable all macros except digitally signed macros. Disable all macros except digitally signed macros.
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
471.
Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
Answer
Correct Answer:
Version control and tracking is supported by PowerPivot.
Note: This Question is unanswered, help us to find answer for this one
472.
Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?
Answer
Correct Answer:
Gradient Fill
Note: This Question is unanswered, help us to find answer for this one
473.
State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false.
An Absolute cell reference consists of the column letter and row number.
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
474.
Analyze the syntax of LOOKUP function when used in vector form?
The values in the lookup_vector must be placed in ________ order.
Answer
Correct Answer:
Ascending
Note: This Question is unanswered, help us to find answer for this one
475.
Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
476.
Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Answer
Correct Answer:
If you delete the offline cube file for a report, still you can create a new offline cube file for the report.
Note: This Question is unanswered, help us to find answer for this one
477.
You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?
Answer
Correct Answer:
Scenarios
Note: This Question is unanswered, help us to find answer for this one
478.
Analyze the syntax of LOOKUP function when used in vector form?
Which of the following arguments of the LOOKUP function is optional?
Answer
Correct Answer:
result_vector
Note: This Question is unanswered, help us to find answer for this one
479.
How would you assign a macro to a graphic?
Answer
Correct Answer:
On a worksheet, right-click on the graphic, then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign.
Note: This Question is unanswered, help us to find answer for this one
480.
Which of the following statements is NOT true regarding import of data into PowerPivot?
Answer
Correct Answer:
The PowerPivot Import Wizard provides you with an SQL Query builder.
Note: This Question is unanswered, help us to find answer for this one
481.
Which of the following sorting options is NOT available under the Sort On option while sorting the data of a table in an Microsoft Excel 2010 worksheet?
Answer
Correct Answer:
Font Style
Note: This Question is unanswered, help us to find answer for this one
482.
Deleting a PivotChart report automatically deletes the associated PivotTable report.
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
483.
Microsoft Excel Services is a component of:
Answer
Correct Answer:
Microsoft SharePoint Technology
Note: This Question is unanswered, help us to find answer for this one
484.
State whether following statement regarding images in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
485.
Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
Answer
Correct Answer:
It is not possible to use the CTRL+Enter keyboard combination on formulas entered in multiple cells in a worksheet.
Note: This Question is unanswered, help us to find answer for this one
486.
Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Answer
Correct Answer:
Values
Note: This Question is unanswered, help us to find answer for this one
487.
What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
488.
Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.
Answer
Correct Answer:
Content that people with disabilities might find difficult to read.
Note: This Question is unanswered, help us to find answer for this one
489.
This question is based upon the figure shown below
Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?
Answer
Correct Answer:
A
Note: This Question is unanswered, help us to find answer for this one
490.
Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?
Answer
Correct Answer:
CTRL+SHIFT+ALT+F9
Note: This Question is unanswered, help us to find answer for this one
491.
When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
Answer
Correct Answer:
It enters the time as AM
Note: This Question is unanswered, help us to find answer for this one
492.
Which of the following options is not available on the Status bar?
Answer
Correct Answer:
Start mode
Note: This Question is unanswered, help us to find answer for this one
493.
State whether true or false:
When a part of a formula is replaced with its calculated value, it cannot be restored.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
494.
Which option would you choose to display a list of formula used in the current PivotTable report?
Answer
Correct Answer:
On the Options tab, in the Tools group, click on Formula, and then click 'List Formula'
Note: This Question is unanswered, help us to find answer for this one
495.
This question is based upon the figure shown below
Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
Answer
Correct Answer:
C
Note: This Question is unanswered, help us to find answer for this one
496.
Which of the following wildcard characters can be used as comparison criteria for Text Filters?
Answer
Correct Answer:
~
Note: This Question is unanswered, help us to find answer for this one
497.
State whether true or false:
No data is deleted when an outline is hidden or removed.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
498.
Which of the following is not true regarding naming a cell?
Answer
Correct Answer:
Names are case sensitive
Note: This Question is unanswered, help us to find answer for this one
499.
State whether true or false:
If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
500.
This question is based upon the figure shown below
What does the red icon indicate, as shown in the given picture?
Answer
Correct Answer:
It tells the user that the document contains Signatures
Note: This Question is unanswered, help us to find answer for this one
501.
This question is based upon the figure shown below
Refer to the given picture. Which option causes the last row in the table to appear and displays the word Total in the leftmost cell?
Answer
Correct Answer:
B
Note: This Question is unanswered, help us to find answer for this one
502.
This question is based upon the figure shown below
Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
Answer
Correct Answer:
B
Note: This Question is unanswered, help us to find answer for this one
503.
When does the error, as shown in the picture, occur?
Answer
Correct Answer:
It occurs when a column is not wide enough
Note: This Question is unanswered, help us to find answer for this one
504.
This question is based upon the figure shown below
Refer to the given image. What is the purpose of the cell denoted as 'A' in the worksheet?
Answer
Correct Answer:
It selects all the cells in the worksheet It selects all the cells in the worksheet
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
505.
This question is based upon the figure shown below
What is the purpose of using the Keep text flat option, as shown in the picture?
Answer
Correct Answer:
It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
Note: This Question is unanswered, help us to find answer for this one
506.
How will you find cells with data validation?
Answer
Correct Answer:
On the Home tab, in the Editing group, click the arrow next to Find & Select,, then click Go To Special. Click on Data Validation, and then click All
Note: This Question is unanswered, help us to find answer for this one
507.
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
Answer
Correct Answer:
Consolidate by position
Note: This Question is unanswered, help us to find answer for this one
508.
Which of the following options would you choose to clear a PivotChart report?
Answer
Correct Answer:
On the Options tab, in the Actions group, click on Clear, and then click 'Clear All'
Note: This Question is unanswered, help us to find answer for this one
509.
Which of the following is not true about an offline cube file?
Answer
Correct Answer:
The file format for an offline cube file is .CUE
Note: This Question is unanswered, help us to find answer for this one
510.
How can a chart be modified?
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
511.
Which file format is typically used to remove printer corruption?
Answer
Correct Answer:
SYLK format
Note: This Question is unanswered, help us to find answer for this one
512.
Which of the following methods would you follow to remove subtotals?
Answer
Correct Answer:
On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
Note: This Question is unanswered, help us to find answer for this one
513.
Which tab should be used to display or hide axes?
Answer
Correct Answer:
Layout tab
Note: This Question is unanswered, help us to find answer for this one
514.
How will you display the Go To dialog box?
Answer
Correct Answer:
You will press F5
Note: This Question is unanswered, help us to find answer for this one
515.
How would you select an entire PivotTable report?
Answer
Correct Answer:
On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
Note: This Question is unanswered, help us to find answer for this one
516.
What is the option on the Document Inspector that finds the content type information?
Answer
Correct Answer:
Document Properties and Personal Information
Note: This Question is unanswered, help us to find answer for this one
517.
State whether true or false:
For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
518.
Which of the following is not true about the Watch Window?
Answer
Correct Answer:
There can be two Watch Windows per cell
Note: This Question is unanswered, help us to find answer for this one
519.
Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?
Answer
Correct Answer:
Automatically updated properties
Note: This Question is unanswered, help us to find answer for this one
520.
This question is based upon the figure shown below
Refer to the given image. Which formula should be written on the given table to display "Nancy Davolio"?
Answer
Correct Answer:
=PROPER(A2)
Note: This Question is unanswered, help us to find answer for this one
521.
This question is based upon the figure shown below
Which Chart type is displayed in the given picture?
Answer
Correct Answer:
A surface chart
Note: This Question is unanswered, help us to find answer for this one
522.
This question is based upon the figure shown below
As shown in the image, the checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?
Answer
Correct Answer:
None of the above
Note: This Question is unanswered, help us to find answer for this one
523.
This question is based upon the figure shown below
What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?
Answer
Correct Answer:
It signifies that the cell contains a comment
Note: This Question is unanswered, help us to find answer for this one
524.
This question is based upon the figure shown below
What would be the result, when =T(A4) is applied on the given table?
Answer
Correct Answer:
Empty text is returned
Note: This Question is unanswered, help us to find answer for this one
525.
This question is based upon the figure shown below
Which part of the formula displays references in the given picture?
Answer
Correct Answer:
B
Note: This Question is unanswered, help us to find answer for this one
526.
This question is based upon the figure shown below
What does the screen tip displaying "Showing All" mean?
Answer
Correct Answer:
It means that Filtering has been enabled but not applied
Note: This Question is unanswered, help us to find answer for this one
527.
This question is based upon the figure shown below
When does the triangle appear in the top-left corner of the cell, as shown in the picture?
Answer
Correct Answer:
When there is an error in the formula
Note: This Question is unanswered, help us to find answer for this one
528.
This question is based upon the figure shown below
Refer to the given image. Which line style option should be used to specify the style used for the end of the line?
Answer
Correct Answer:
C
Note: This Question is unanswered, help us to find answer for this one
529.
Which of the following charts have no axes?
Answer
Correct Answer:
Both a and b
Note: This Question is unanswered, help us to find answer for this one
530.
Which of the given methods would you follow to add an alternative text to a picture?
Answer
Correct Answer:
Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
Note: This Question is unanswered, help us to find answer for this one
531.
State whether true or false:
A Macro project can be digitally signed.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
532.
Which database function estimates variance based on a sample from selected database entries?
Answer
Correct Answer:
DVAR
Note: This Question is unanswered, help us to find answer for this one
533.
Which of the following is not true regarding column width?
Answer
Correct Answer:
If the column width is set to 0, the column is hidden
Note: This Question is unanswered, help us to find answer for this one
534.
Where can the 'Show All Comments' command be found?
Answer
Correct Answer:
On the Review tab
Note: This Question is unanswered, help us to find answer for this one
535.
Which keyboard shortcut should be used to minimize or restore the ribbon?
Answer
Correct Answer:
CTRL+F1
Note: This Question is unanswered, help us to find answer for this one
536.
Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?
Answer
Correct Answer:
VLOOKUP
Note: This Question is unanswered, help us to find answer for this one
537.
How should blank cells be inserted on a Worksheet?
Answer
Correct Answer:
Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
Note: This Question is unanswered, help us to find answer for this one
538.
State whether true or false:
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
539.
Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?
Answer
Correct Answer:
Scoping by value field
Note: This Question is unanswered, help us to find answer for this one
540.
State whether true or false:
When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
541.
Which type of additional information is stored within the digital signature?
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
542.
State whether true or false:
Case-sensitive sorting of text in Excel2007 can be performed.
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
543.
Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
Answer
Correct Answer:
By selection
Note: This Question is unanswered, help us to find answer for this one
544.
Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?
Answer
Correct Answer:
CTRL+SHIFT+:
Note: This Question is unanswered, help us to find answer for this one
545.
When would the data validation command be unavailable on the data tab?
Answer
Correct Answer:
When data in a cell is entered
Note: This Question is unanswered, help us to find answer for this one
546.
Which method will you use to update table data from a Sharepoint list?
Answer
Correct Answer:
On the Design tab, in the External Data group, click Refresh
Note: This Question is unanswered, help us to find answer for this one
547.
State whether true or false:
When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
548.
Which chart displays axes but cannot display axis titles?
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
549.
How would you locate the last filled cell on a worksheet?
Answer
Correct Answer:
Click anywhere in the worksheet, and then press CTRL+END
Note: This Question is unanswered, help us to find answer for this one
550.
How will you reverse the direction of a SmartArt graphic?
Answer
Correct Answer:
Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
Note: This Question is unanswered, help us to find answer for this one
551. Which statement is incorrect?
Answer
Correct Answer:
The default value for an argument can be a global constant.
Note: This Question is unanswered, help us to find answer for this one
552.
What will be the result of calling the h() function in the following C++ code?
