1. What company distributes Excel?
2. Your PivotTable shows 20 products listed down column A. How can you make only the first 10 visible, and the rest of the products hidden?
3. Which button allows you to copy cell formats from one cell to another?
4. If there are duplicate items in a list, the COUNT function will not include the duplicates in the total count of items.
5. Identify all the arguments and the correct order of arguments needed to execute the IF() function.
6. A red triangle at the top right corner of a cell indicates what?
7. The definition of a macro is:
8. What is the correct forumla to calculate an average between cells B3 and B6?
9. The Doughnut chart type
10. Which worksheet function converts a time in the form of text to a serial number?
11. Are you able to do spell check in Excel?
12. How do you close a formula?
13. How to search text in Excel?
14. How do you ensure that the person using a spreadsheet can always see the column headings?
15. The 'Merge & Center' button does what?
16. If you have an error, how can you find ways to fix it?
17. In the formula =sum(B1:B5), what does the ':' represent?
18. A pivot table allows you to:
19. What is a cell?
20. Data can be arranged in a worksheet in an easy to understand manner by
21. A Name can be applied to a range of non-contiguous cells.
22. Which is a type of operator?
23. In order to multiply items in Excel, you would use which symbol?
24. Can Excel spreadsheets contain images?
25. Which types of charts can excel produce?
26. You have two columns summing your account totals. The first column looks exactly right but the second one is not displaying the way you want. How do you make the two columns look the same?
27. Can you print only a selected part of your workbook?
28. It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?
29. Which formula below will add the value of B2 to the value of C3
30. What is the short cut for saving a file in Excel?
31. What is one way to get a new workbook?
32. Is there a way to share your spreadsheet and allow someone to change it?
33. You can create a connection to a SQL Server Analysis Services Cube in Excel.
34. The value in a cell that contains the formula =RAND() changes every time any change is made to the workbook.
35. How do you change text's alignment within a cell?
36. You can save any Excel document as a web page.
37. A user can sort a maximum of...
38. A sparkline usually shows trend information.
39. The data can be typed in either the cell or in the Formula bar.
40. You can convert your Excel document into a Google doc.
41. Excel will recognize patterns in data and automatically enter formulas where the patterns continue.
42. You can protect a single worksheet and leave the others with full access.
43. Excel has trigonometry functions built into it.
44. A pivot table is a 'dynamic summary report generated from a database.'
45. You can add new commands to the QAT.
46. Numbers in Excel can assume many different formats: date, time, percentage, or decimals.
47. Can you save a .xlsx file as a .xls file?
48. Is it possible to sort by the color of a cell in the most recent version of excel?
49. Which of the following is not a term of MS-Excel?
50. How do you create a table on excel?
51. True or False: Formulas can be edited across multiple worksheets at the same time.
52. It is possible to password protect content of selected cells so that cannot be modified
53. Can a macro save a file?
54. The following functions are listed when the office button is selected:
55. To change column width in MS Excel, put cursor on the right side of the cell in that column, in the first row. Click and hold and drag to desired width.
56. How does one change the font style of the selected cell to *bold*.
57. It is possible to have a folder of templates in Excel to make it easier to access them.
58. Can the Match & Index Functions be combined together to perform a lookup?
59. You can create a two-input data table.
60. Charts from Excel can be pasted into Power Point.
61. Is it possible to determine the day of the week for a particular date?
62. True of False? Excel 2013 will let you save a file into a cloud service, like Microsoft OneDrive or Sharepoint.
63. Which format can you decide to apply in the AutoFormat dialog box?
64. You can customize your toolbars and menus.
65. Can you create Macros on excel?
66. A formula in Excel must begin with the operator:
67. Excel has the capability to sort horizontally from left to right or right to left.
68. How to compute a sum?
69. There are three worksheets with every new workbook. You can change that automatic number if you want to.
70. A Name can be applied to a single cell or a range of cells.
71. Excel can retrieve external data from which of the following sources?
72. How many conditions can be set for an individual cell's conditional formatting?
73. a formula is always started with what symbol?
74. What-If analysis functionality in Excel includes:
75. You can delete data in a cell by hitting the delete key in the keyboard.
76. The Quick Access Toolbar (QAT) is useful for adding popular commands.
77. The functions AVERAGEIF and SUMIF both use cell values that match specified criteria.
78. It is possible to access Outlook, Word or other Microsoft products through Excel.
79. Is SmartArt available in Excel?
80. What does the function DATE(year, month, day) do?
81. It is possible to sort information both vertically (by columns) and horizontally (by rows)
82. Each location in an Excel spreadsheet is called a:
83. Can you insert images from ClipArt into Excel?
84. Where do you find the picture icon?
85. When you write up a lookup formula to look up the text 'budget', the formula considers any of the following a match: BUDGET, Budget, or BuDgEt. Is it possible to perform a case-sensitive lookup?
86. Which symbol is used as a reference operator?
87. When you record a macro in Excel, you are actually creating a VBA program.
88. You can enter three types of data in a cell these are?
89. You can convert an existing shape to a Freeform Shape.
90. How would you rename the tabs at the bottom of the spreadsheet?
91. lookup _value argument is the value that is searched for in the first column of the table array
92. Which of the following is a 'Lookup and Reference' function?
93. What does the function FV stand for?
94. True or False: Frequency is an array function.
95. All forumulas in Excel begin with the following symbol
96. You can change the color of the following in Excel:
97. Which of the following is NOT a way to align a cell?
98. What is the formula used to multiply cell A1 by cell C1?
99. The standard name of each cell is based on its ___________ and __________
100. Currency figures in Excel can be changed from US Dollars to the:
101. Where can you insert a text box in Excel?
102. All functions begin with the equals sign.
103. What does Live Preview allow the user to do?
104. How can an interactive chart be created?
105. What happens when you double click on a cell?
106. A ________________ consists of spreadsheets.
107. To calculate trig functions in degrees, you must convert them, or Excel will calculate them in radians.
108. A ________________ consists of a grid made from columns and rows?
109. How do you make sure that a formula's result will always fit into the cell?
110. Which of the following formulas is not entered correctly?
111. What is the home position in an Excel worksheet?
112. Clipart can be found under what menu?
113. You can sort rows by:
114. ____ calculates the average of a range of cells.
115. What is a logical function?
116. Can you add borders to cells without having a border for the workbook?
117. Which solver method will change variable cells to meet an objective cell?
118. What do you use to create a chart?
119. This counts the number of chosen data in a range of cells.
120. You can edit a cell by
121. A collection of worksheets contained within a single file is called a ____ .
122. Once cells are merged in Excel, they can never be un-merged.
123. How do you insert saved images?
124. Cells D3 through Z3 list sales total for various months. What does the equation '=SUM(D3:Z3)' show?
125. A pivot table must have column headers.
126. How can you change the date format of a cell or group of cells?
127. True or False: Sparklines are also often called 'micro charts.'
128. What is the purpose of the Σ button?
129. True or False: You cannot insert comments for individual cells.
130. The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
131. If you want to set the print area which ribbon should you use?
132. Which keyboard shortcut copies cell data?
133. How do you make a chart?
134. The formula =NOW() displays:
135. In order to change page margin, which menu would you choose to select 'Margins'?
136. A fixed dollar sign appears to the far left in the cell often with spaces between it and the first digit. Whereas a floating dollar sign appears immediately to the left of the first digit with no spaces.
137. Which would you choose to create a bar diagram?
138. Which one of the following formulas cannot be calculated by Excel?
139. What is the correct formula to calculate the total of cell B3 and B4?
140. How do you view the 5th decimal place when calculating costs?
141. How do you turn data from rows into columns in Excel?
142. What is the proper shortcut for 'Refresh All'?
143. If there is text in a column and you try to sort the entire column:
144. How does one save the active workbook without altering the file or folder name.
145. An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they form little boxes called ____
146. Cells B3 through B121 list several values. What equation shows the average of those values?
147. Right clicking on a cell then selecting insert from the cell menu allows you to do what?
148. What does this formula do? =IF(E6=G6;'Nice';'Not so Nice')
149. Sparklines are a new part of Excel 2010/2011 and are not available in previous versions.
150. How can you launch a regression in excel 2010?
151. What is a function of data markers?
152. You can filter an Excel Pivot chart so that it shows only the information you want it to show.
153. How do you keep others from changing the values on a worksheet?
154. What is the keyboard shortcut for Undo?
155. When a formatted number does not fit within a cell, what does the cell display?
156. An example of a range address.
157. Which function will return the largest value within the range?
158. Where do you change the default font for new workbooks?
159. How to you create a pivot table?
160. If you would like to count the number of cells within a range that fit a specific criteria, which function would use?
161. Which worksheet function returns the F probability distribution?
162. Where do you place a MACRO that is supposed to run automatically after every entry on a worksheet?
163. If you want to highlight a row of numbers by less than, greater than or equal to, what should you use?
164. You can download content from the net directly into Excel.
165. What tool allows you to summarize and analyze data in various categories?
166. ____ adds a range of cells together.
167. How do you control which cells are printed?
168. Your spreadsheet is printing, but the grid lines aren't showing up. What is most likely the problem?
169. You can never open any workbook that has previously been saved and given a name.
170. How do you change the orientation of a spreadsheet from portrait to landscape?
171. The cell reference of a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
172. What is the best formula to use to calculate 12 to the 4th power?
173. What tool is used to split the window into different parts of the same worksheet?
174. When you insert a row, you have to reset all the equation references because:
175. Which keyboard shortcut pastes copied information?
176. You have a table of data listing each sales person in one column and their territory in a second column. Each sales person is only listed once but there are hundreds of sales people. What function could you use to quickly display a salesperson's territory by typing in their name?
177. To create another worksheet that is exactly the same as the current worksheet you would...
178. The Freeze Panes function allows the user to:
179. In which tab is the page breaks preview located?
180. Pressing CTRL-Home moves the cursor to:
181. Identify the error: When entering 325 in a cell, the result shows up as 3.25.
182. How do you create Word Art?
183. Does delete button remove cell?
184. How are columns named?
185. What is a circular reference?
186. If $34 is entered into a cell, Excel will interpret it as:
187. What does an asterisk signify in a formula?
188. If you choose a larger font size, the height of the row is automatically made taller.
189. When number signs (#####) are displayed in the cell, it means:
190. To ensure a worksheet will print all on one page, adjust the settings in the:
191. To unhide a sheet and make viewable with other tabs in the current window:
192. A function inside another function is called a _____ function.
193. If a set of numbers has an even number of items, the MEDIAN function will return:
194. Spell check can be found in the _______ menu
195. Excel 2003: _________ allow you to move to another worksheet in an Excel workbook. They are used to display the first, previous, next, or last worksheets in a workbook.
196. The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called?
197. What is one easy method to see if your spreadsheet will print on one page?
198. What is a column on a worksheet?
199. It is possible to upload a SWF file into Excel.
200. Which function returns the highest value of a range of cells?
201. Excel 2003: Also called a spreadsheet, the _____ is a unique file created by Excel.
202. What makes Ln fuction in excel?
203. In Excel a ____ is an instruction in a spreadsheet to carry out a calculation
204. What will the formula =A1*C1 return?
205. Which worksheet function returns the individual term binomial distribution probability?
206. In a large data set with 121,005 rows, You are on the top row (row 1) of the data set. What is the fastest way to get to row 121,005?
207. Can Excel open two documents with the same file name simultaneously?
208. After typing data or a formula into a cell and hitting ENTER, the default action is:
209. Which function repeats text a given number of times?
210. The Solver in MS Excel is used for what?
211. To insert a link to another worksheet, workbook or file, what dialog box do you use?
212. Rather than creating a new, blank workbook by clicking the File tab, selecting New, then clicking Blank, what's the keyboard shortcut?
213. How could one delete an embedded object?
214. Where can you print comments?
215. In a bar graph the horizontal axis is the:
216. Which cannot be included in a header/footer?
217. Excel's data validation feature enables you to...
218. Data being typed does not appears in both the active cell and Formula bar.
219. You probably have Excel 2013 on your computer if you have any of the following installed, EXCEPT:
220. The formula =4>6 returns:
221. When entering formulas and functions in Excel, the symbols *, /, +, and - are called:
222. How do you create a reminder to follow up on a document?
223. Which is not a lookup function in Excel?
224. What does the equation =TODAY() show?
225. What is the purpose of the BIN2HEX function?
226. Using a cell address in a formula is known as:
227. Double-clicking column separators will do what?
228. What do you click on to navigate between worksheets in a workbook?
229. How do you make sure that a MACRO won't automatically run on a spreadsheet you've downloaded?
230. The Remove Duplicates command:
231. There is only ONE way to group a pivot table item.
232. How do you change all positive numbers in a sheet to negatives?
233. In Sheet1, column A is January's sales numbers. In Sheet2, column A is February's sales numbers. Which equation on Sheet 3 totals both columns, in row 5?
234. To insert a character that is not part of an alphabetic font sent (such as copyright ©) use the:
235. Which worksheet function returns the average of selected database entries?
236. Which function would you use to find the largest number of a selected range?
237. How can you delete a worksheet?
238. What is the answer for this formula? =if(A1>=B1,'Good','Not Good') ---> A1=90 , B1=90
239. When a list is filtered (showing only rows that meet the criteria) and highlighted, the copy command will result in:
240. What is the difference between a workbook and a worksheet?
241. What kind of formatting allows you to create a set of rules to format cells based on a cell value or another cell?
242. Which worksheet function returns the minimum value in a list of arguments?
243. If you place the cursor in cell A2 which contains text and press the keystrokes CTRL-B / CTRL-I / CTRL-U the result will be:
244. What would the following formula do? =Sheet1!D9+Sheet1!E9
245. Which function copies data from a row into a column or vice versa?
246. How can you rename a worksheet?
247. You want to lock rows 1:2 and column A in place as you scroll through a large spreadsheet. Which command should you use?
248. When working in Page Break Preview, we can do which of the following?
249. What type of chart would you create in order to present how much each component comprise the whole?
250. In a Excel spreadsheet, It's possible to select multiple non-adjacent ranges of cells.
251. What does the 'V' in 'VLOOKUP' stand for?
252. In the Find and Replace function it is NOT possible to replace what you've searched for with an alternative at the same time.
253. What term describes explanatory text attached to a cell ?
254. Where can you see the contents of an active cell?
255. Attaining data from a cell located in a different sheet is called what?
256. When you split the screen horizontally or vertically, why might you want to immediately freeze the top or left pane?
257. What can be protected from accidental modification?
258. You have a list of names and addresses, and it's filtered to show only the rows from 7 of 9 states. How can someone else tell with a quick glance that the list is filtered by the State column?
259. Why is it a good idea to keep track of numbers, projects and lists in Excel, rather than in text files?
260. When is an absolute cell reference used?
261. What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?
262. Data displays in the ____ as you type.
263. Which one is NOT a column chart type?
264. Formatting a cell in Currency, you can specify...
265. To speed up the calculations of a data table on a worksheet,
266. How do you translate a time into a decimal value.
267. Which worksheet function returns the one-tailed probability of the chi-squared distribution?
268. How can you set 0.5 inch left indentation for a cell in Excel?
269. Which keyboard shortcut can be used to embolden text?
270. An array range that includes both rows and columns is known as____?
271. What's one way of unhiding a column that you've hidden?
272. To view a cell comment, do which of the following?
273. When the string 12345678910 is contained in Cell B3, which formula below returns the last 5 digits of the string?
274. The best way to automate a complex, repetitive task within a worksheet, is to create:
275. Cell A1 contains a text string Apple, Cell A2 contains a value 5. What will be the result of the formula: =A1*A2
276. What is the keyboard shortcut for moving the cursor to the first cell in the current worksheet (assuming no frozen panes, this would be cell A1)?
277. How are rows named?
278. Excel 2003: True or False: Excel 2003 will not prompt you to save information if anything new has been typed between the last save and the time you close the file.
279. Let's say you have a large sheet of expenses and want to highlight those that are higher than 100 or less than 5. How would you do this?
280. On an excel sheet the active cell in indicated by ?
281. How can you remove borders applied in cells?
282. What would you use to only view the rows in a spreadsheet that meet the criteria you want?
283. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
284. Quickest way for renaming a sheet:
285. In an alphabetical sort, if two cell contents are identical, Excel sorts by:
286. If you see a small red triangle in the top right corner of a cell, it means there is something 'attached' to the cell. What is it?
287. The difference between centering text in a cell and centering a number is:
288. It is the intersection of a column and row.
289. If the source of sparkline data contains non-numeric data, they are neglected while plotting the sparklines.
290. Which worksheet function returns covariance, the average of the products of paired deviations?
291. The logic for the formula in cell B2: =IF(A2>5,.2,0) is expressed as:
292. When you widen a column that results in excess row height, you can eliminate the excess row height by:
293. Which function searches for a value in a specified table array?
294. Can macros close currently open worksheets?
295. True or False: The formula =((A2+B5)*5% is valid.
296. Which language is used to create macros in Excel?
297. Does conditional formatting override the formatting set in a cell?
298. Which is an INCORRECT formula for sum of cells A1 to A5?
299. If you don't see the Solver button on the Ribbon, how can you get it?
300. What's the function for calculating variance?
301. In the formula, which symbol specifies the fixed columns or rows?
302. What character is used in a formula cell reference so that it can be copied elswhere but still refer to the same cell or cells?
303. When multiplying A1 and B1, where A1=4.33 and B1=6.111, what is the formula to achieve an answer rounded to the closest tenth?
304. Data can be arranged in ascending or descending order by using:
305. Which group under the Home tab contains the 'Clear' command
306. How do you copy paste only a number from a cell and not the formula that goes with it?
307. Applying a $ to a cell reference in a formula:
308. What are two ways of hiding a row or column?
309. =AVG(B3:B10, C3:C10) have exactly how many arguments?
310. What does letter H stands for in HLOOKUP formula?
311. The function =VLOOKUP('Widget',D4:E9,2,False) is correct format
312. How do you make a long sentence fit into the column size?
313. Under which tab would you access Visual Basic?
314. Cell A1 contains the number 3, Cell A2 contains the number 4. If Cell A3 contains the formula =IF(A1>A2, 'true', 'false') what solution will Excel return?
315. The formula ISERROR(A1) returns TRUE if A1 is :
316. What is the operator for concatenating two text strings together?
317. Which worksheet function returns the correlation coefficient between two data sets?
318. Which formula correctly references cell A1 on Sheet2?
319. What is the correct syntax of the worksheet function “RANK”?
320. Which character always appears in formulas with external references?
321. Concatenation of text can be done using
322. What is the fastest way to retrieve more than one comment?
323. Which can format cell contents according to predetermined conditions?
324. Using formulas, how could I combine text resulting in 'Check # 1234 paid 02/15/2013 - pending cash application'? Cell B4 refers to the date.
325. If you have a worksheet that's several pages long, how can you get the column headers across row 5 to print at the top of each page?
326. What would the function '=Large(DataRange, 2)' return?
327. True or False: The SUMIF function adds values in a range that cannot be defined by the user.
328. What is the function used for removing all non-printable characters from a string in Excel?
329. Which Excel feature allows a user to split apart values in a text string into separate fields?
330. What 'Insert' option should you use for a PDF?
331. When you're sharing a workbook with someone, how often does the workbook get updated?
332. In Excel 2010, you can open the Highlight Changes dialog box by choosing Track Changes from which menu?
333. Which function provides similar functionality to using the & symbol in a formula?
334. How do you select noncontiguous cells?
335. When you write a formula in Excel, the references in the formula are limited to that worksheet only.
336. Column A contains an apartment number, column B is the street number, and column C contains the street name. I would like all these values to be in the same cell; what function could I use to accomplish this?
337. If you want to enter the days of the week across a row, how can you save a lot of typing?
338. A formula with brackets such as {sum((C2:C1)*(D2:D11))} is called:
339. Function used to join several text strings to one is:
340. If cell A1 contains the value '32.96' and you format the cell to show only 1 decimal place, which value is displayed?
341. Which of the following is correct syntax for typing a function into a cell?
342. The Quick Access toolbar does which of the following?
343. In which tab is located the Proofing group?
344. When a cell containing a formula is copied and then pasted into a new cell, Excel:
345. Which command locates values in a worksheet?
346. At the bottom of column C, you have a simple total formula. You want to reuse it with the values in column D, so you copy and paste. What must you do with the formula after pasting?
347. Which of the following functions returns the greatest numeric value?
348. The accounting style shows negative numbers in
349. You drew a triangle on the page and want to place an exact duplicate to the right. You want to make certain that the duplicate isn't any higher or lower on the page. How can you do this?
350. What's a quick way of rearranging the order of the worksheet tabs?
351. To get all rows and columns of data to print on one sheet, you can adjust the page breaks in Page Break Preview or:
352. Which is NOT a method to calculate A1 to the power of B1
353. Where can I find formulas in excel without having to type it?
354. How can you insert a chart from selected data?
355. A _______ is a predefined formula that helps perform common mathematical functions.
356. Which of the following formulas shows the correct syntax of a VLOOKUP() formula in the 3rd column?
357. Imported data appears entirely in column A. How do you separate the data into individual columns?
358. Let's say that for 100 cells down column B, you have a dozen varieties of olives listed, some of them appearing multiple times. How can you use the COUNTIF function to find the number of times the Greek variety is listed?
359. To show a '-' instead of a zero in cells with zero value, you must adjust the settings in what way?
360. Which character denotes a text entry?
361. Which of the following is an absolute cell reference?
362. How to open VBA coding pane?
363. What does the Mod function do in an equation?
364. What would you enter first in a cell to show formula text?
365. You can use a template on Excel by going to...
366. True or false? An absolute reference is designated in the formula by the addition of a pound sign (#).
367. The two types of cell references are:
368. To control the display of the numbers along the horizontal axis of a line graph, adjust the:
369. Does changing the number of displayed decimals change the value Excel is storing?
370. What is the Programming Language we use to write the macros in Excel?
371. How can you replicate only the formatting of a graph onto other graphs in your workbook?
372. Which is NOT a function?
373. What should be the file type of a saved excel macro file
374. If you didn't assign a macro to a button, keystroke or to run automatically, how can you run the macro?
375. What is the correct way to refer the cell A10 on sheet3 from sheet1?
376. If you created a macro by recording your keystrokes, how can you modify it?
377. How can you make the width of a column automatically adjust to the widest item in the column?
378. Cell G20 contains the grand total for the current year's sales. You want the total for next year to be 10% higher. What formula will calculate that number?
379. The transpose action in Excel is found in:
380. How do you create a cell featuring a drop down list of values?
381. Suppose cell A1 has value '1' and cell B1 has value '2'. After merging cell A1 and B1, what will be the value of Cell A1?
382. How can you write an IF statement so that it has more than one criterion?
383. Which of the following is a concatenating operator?
384. What formula returns the number of cells in column A that are greater than 50?
385. In the formula =VLOOKUP(a2,c2:d100,2,false) the final argument indicates:
386. How would you find the absolute value of A1?
387. Cell A1 contains the string 'Tom Jones' (two blank spaces before the name Tom). To remove the two blank spaces, the formula is:
388. When a cell is entered in a formula without using the $ symbol, what type of reference occurs?
389. If A1=6 and B1=4, then what is =A1&B1?
390. A 'frequency distribution' is a summary table that shows the frequency of each value in a ___?
391. What function would you use to extract a portion of a text string from the center of the string?
392. Cell A1 has the number '3' in it. Cell A2 has the value '5' in it. If you merge these two cells together, what is left in the merged cell?
393. How do you debug a formula by looking at each part of the formula individually?
394. Cell A1 contains 'Chang', and cell A2 contains 'Pie'. What is the result of the formula: =CONCATENATE(A1,' ','and',' ',A2)
395. What does the VALUE function do?
396. Let's say your workbook has 5 worksheet tabs, and you want to group only the 1st, 3rd, and 5th sheets. How can you do this?
397. Which formula will provide the same result as the following: =CONCATENATE('Smarter','er')
398. Cell A2 has the name DAVID HAWLEY in it. Which formula extracts the first name from the cell?
399. How do you generate random numbers 1-100?
400. In the following formula, where is the Table Array located? =VLOOKUP(A5:A19,[RegionalSales]FY2012!$D$2:$J$31,7,FALSE)
401. The function DAY(date)
402. If A1=7 and B1=7 what will the formula '=A1=B1' return?
403. If you want to print only from A1 to F20 of a much larger worksheet, and print that range several times, how could you make it the area that gets printed?
404. Which feature quickly copies and adjusts a formula down a column or across a row?
405. When you assign a password to a worksheet, what are the rules or restrictions for what the password can be?
406. Which formula allows the retrieval of information in any relative direction?
407. Column A lists a long string (example:A3= 1234Smith1740.434.21) where the first four digits are the employee number. What formula in B3 will extract only the employee number from the string in cell A3?
408. Column A contains first names and Column B contains last names. What formula would output in the format 'Last, First' in cell C7?
409. When a formula references cells that are affected by the same formula, what type of error results?
410. What's the best type of chart to track the progress of numbers over time?
411. The Format Painter can be deactivated by:
412. How many arguments exist in the IF function?
413. Which worksheet function counts all cells with numerical and text values?
414. The SUMIF function is very useful for single-criterion sum formulas. The SUMIF function takes three arguments NOT including:
415. What conclusion could you reach if Cell B13 contained the text Apple and the formula =LEN(B13) returned 6?
416. When using the PERMUT (number,number_chose) function, what syntax error will occur if the number_chosen is non-numeric?
417. You finish editing Excel's default document, called Book1. But instead of using the Save As command, you click the Save button or press the equivalent keyboard shortcut. How does Excel respond?
418. Which of the following types of files preserves cell properties, formulas, graphics, and other formatting?
419. Which function calculates your monthly mortage payment?
420. What happens to a "relative" cell when it is copied to a new cell?
421. If I have a date Jan/01/2014 in cell A1 than what will be the formula to have date after 6 months in cell B2
422. The value in a cell that contains the formula =RAND() only changes when the file is resaved.
423. Which is not a type of Cell Format?
424. If the Ribbon is taking up too much space on your screen, what can you do?
425. Using IF(), to test if a number in cell D2 was between 10 and 1000 the correct function would be:
426. Opening a workbook or switching from one sheet to another is an example of what?
427. Which worksheet function counts the number of cells containing data (either numbers or labels) in a selected range?
428. What does the function PV do?
429. Each column in Excel has a corresponding number. To extract this number you can use the following formula:
430. If you encrypt a workbook with a password and forget what it is, how can you open the workbook?
431. A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.
432. What is the effect of adding an apostrophe before the equals sign in the cell entry =(98-42)^0.5?
433. What is a group of cells that form a rectangle on the screen?
434. Quick keyboard combination for launching VBA:
435. The fill formula method allows you to copy a formula and fill it into only two different consecutive cells at the same time.
436. Which feature lets you scroll through two worksheets simultaneously, making it easier to check one sheet against another?
437. Which worksheet function returns the rank of a number in a list of numbers?
438. The functions =SUMIFS(E1:E5,D1:D6,A1,C1:C5,A2) will results as an error is:
439. To compare B14 and C12 and return the value of C12 if it is less than the value of B14, write: =IF(____, B14, C12)
440. If you're searching for the word 'glass', but don't want the Find or Replace dialog to find 'eyeglasses', what can you do?
441. Which function returns the Student's t-distribution?
442. Which is NOT one of Excel’s what-if functions?
443. Functions like MATCH, INDEX, VLOOKUP and HLOOKUP require absolute cell references for the data range. What feature can make those references easier to read and understand?
444. How can you zoom in and out of a worksheet, just by using your mouse?
445. Which worksheet function returns the k-th smallest value in a data set?
446. Which of the following is mixed cell reference with a fixed row address?
447. When tracking changes to a workbook, what restrictions can you apply?
448. If the Formula bar is too short to see all its contents, how can you enlarge it?
449. Which allows you to find a desired result when you don't know the input value that will return it?
450. If A1 contains the text 'Red' =OFFSET(A1,0,0) will return
451. Identify the function that does not require the use of any argument(s):
452. What is a shortcut to minimize or maximize the ribbon?
453. =SUM(B3:B10) has exactly how many arguments?
454. Selecting the Rows 5 & 6 then choose Insert->Row
455. Where is conditional formatting located?
456. What are two ways of creating a PivotChart?
457. If you choose Find & Replace All when the cursor is in one cell, it will result in:
458. When entering a formula, what key or combination of keys can be hit to quickly make a cell an absolute reference?
459. What does it mean when the 'marching ants' border around selected cells disappears?
460. From the Scenario Manager dialog, what can you do with the results?
461. The formula QUARTILE(a1:a100,1) returns:
462. True or False: Converting a table back to a range will maintain the table style used
463. Why will Excel return an error for the formula =HLOOKUP(A1,B2:E6,6,0)?
464. Two common wildcard characters that Excel recognizes are
465. Under what tab can the Scenario Manager be found?
466. How can you remove an icon from the Quick Access Toolbar?
467. A green flag will appear on the upper right-hand side of a cell when it contains:
468. A cell with a numerical value has a green corner. What does this mean?
469. What is the first thing before launching subtotal function?
470. Can you set 1-inch left indentation for a cell in Excel?
471. Which chart would be best used to illustrate a proportional relationship?
472. Which worksheet function returns the most common value in a data set?
473. What function would you use if you want to find the 3rd largest value in a set of data?
474. What's the recalculate shortcut?
475. Given range of cells A1:A100, select the formula that would return the 3rd lowest value from the selected range.
476. In Excel 2010, to protect a worksheet, choose Protection and then Protect Sheet from which menu?
477. A formula to show the date for the previous Sunday could be:
478. To share your workbook with another user, what must they have?
479. The formula EXACT('Fish''fish') returns:
480. What is the function to display only the current date?
481. Which Function should be used to count all the cells which are not empty?
482. Which worksheet function returns the average of its arguments, including numbers, text, and logical values?
483. Which worksheet function returns a value along a linear trend?
484. When using a Lookup to extract data, what is the meaning of the true/false argument?
485. Which worksheet function extracts from a database a single record that matches the specified criteria?
486. You can undo several recent actions at once.
487. Cell C3 contains a value 100, what formulla you will use to make it 10% smaller in Cell C1
488. Cell A1 contains the string 'tom jones'. To transform the contents to 'Tom Jones' the formula is:
489. Which worksheet function returns the k-th largest value in a data set?
490. Which feature allows you to display multiple copies of your worksheet in side-by-side windows?
491. What does the 1 represent in this formula: =Now()+1
492. True or False: The print area cannot be set to discontinuous ranges.
493. What is the main difference between a Sumif equation and a Sumifs equation?
494. If you want to make a text box transparent, you should:
495. The quickest ways to save as:
496. You're separating a column of full names into a column of first names and a column of last names. Excel should treat the column as what type of data?
497. Where does the 'Track Changes' feature highlight changes?
498. What Tab do you use to create a background Graphic?
499. What does COUNTA () function do?
500. How can you shift a cell's value into the center of a group of cells, without merging it?
501. The difference between the COUNT function and the COUNTA function is:
502. When you use the Freeze Panes command, Excel freezes all of the columns and rows:
503. How would you determine how many blanks are in the range of cells between A2 and A35?
504. What is the function of DEGREES?
505. Which is a keyboard shortcut to insert current date into a cell?
506. What combination of keys do you need to use for an array formula to work?
507. What happens if you copy a cell containing the formula =G5/$F5 and paste it into another cell?
508. What is the correct syntax for the first line of code of a basic macro?
509. What does a “Green Triangle” in the top-left corner of a cell indicate?
510. What does the keyboard shortcut F12 do?
511. How would you ensure that B1 divided by A1 always equals zero when the value of A1 is zero?
512. Which of these characters is not allowed as part of a tab name?
513. Cell A1 contains the text string 'X489Smith1740'. To determine the number of characters in the text string, use the formula:
514. What is a quick way of viewing the underlying data of any cell of a PivotTable?
515. What is a sparkline in Excel?
516. How do you know a range is active?
517. An Excel formula can reference cells on other worksheets in the:
518. I'm trying to work out percentage increases but when one of the cells has 0 in it its giving me DIV/0 error, How do i stop this?
519. You want a drop down list with a blank space between 'apple' and 'banana'. How do you do this?
520. The visual basic editor can be used even when Excel is not running
521. Double clicking the currently-selected tab on The Ribbon will do what?
522. Sometimes, data that you're charting may be missing one or more data points. Excel offers three ways to handle the missing data. All of the following are ways to handle missing data EXCEPT:
523. Under which ribbon item can you find protection options?
524. What function returns information about the formatting, location or contents of a cell?
525. Where do you enable/disable the Developer Tab?
526. True or False: Zero values are not plotted using sparklines.
527. If A1 contains the text 'Red' and B2 contains 'Blue' then =OFFSET(A1,1,1) returns
528. What function do you use to insert the current date and time into a cell?
529. Cell B1 contains the text 'A1'. What function do you enter in cell C1 that refers to B1 and as a result shows the value in cell A1?
530. If you want to freeze the top row and first column which cell must you highlight before clicking Freeze Panes?
531. A custom list gives you the ability to:
532. What does CTRL(CMD)+D do?
533. What is the keyboard shortcut to display the Format Cells dialog box?
534. Cell A1 has this information 'Current Value: $10.00' Which function extracts 'Value:' from 'Current Value: $10.00'?
535. To remove extra space from a cell, use the formula:
536. You have entered data in a cell B2. You want cells B3:B16 to have the same data. What is the fastest way?
537. The formula QUARTILE(a1:a100,4) returns:
538. The displayed value of cell A1=FALSE. The formula in cell A2=ISLOGICAL(A1) returns:
539. How can you bring up the built-in Help?
540. Where is located 'Name manager'?
541. How can you cause text to display vertically in a cell?
542. What does the Remove Duplicates command consider to be a match?
543. Which formula should be used to find the row that 'Steven' appears in and return his phone number? (Sheet contains Names in Column A and Phone Numbers in Column B)
544. All of the following are recognized file extensions in Excel except:
545. You have a range of cells selected and want to place a duplicate of that range elsewhere on the page. How can you do this?
546. If you aren't sure what type of chart to use for your data, how can Excel help?
547. What are the two syntaxes for the AGGREGATE function?
548. When creating a dual-substitution data table, where must you put the formula that the table is based on?
549. What will be the result of this formula =MOD (40, 0) ?
550. Which function lets you reference a cell or range (that hasn't been named) using text values?
551. One of the major differences between the inStr function in VBA and the Excel Search function is that...
552. Which is false regarding Conditional Formatting?
553. Cell A1 has text in the format YYYYMMDD. How do you convert this to a valid Excel date?
554. what is the function key for creating a chart for a given table?
555. What is the benefit of using Slicers?
556. What function converts a text string into a cell reference?
557. When you protect a worksheet, all users will still be able to:
558. In a selected column-layout PivotChart, what's one way to swap which fields are listed across the horizontal axis, and which fields are listed in the legend?
559. What is the maximum number of columns allowable in an Excel worksheet?
560. What's one way of clearing the effect of a slicer that you've applied?
561. Cell A1 contains the formula =$F39. Copying that formula to cell B2 will result in:
562. How do you create a range for a sum function that anchors itself on A1, but will increase in range downwards as you drag and drop the formula?
563. How will you apply restrictions on data entry except the whole number to selected cells on the worksheet?
564. What is the Mini Toolbar used for?
565. If you have a workbook with links to another workbook, but the links haven't updated automatically, how can you update them manually?
566. What keyboard shortcut will create a chart of the data in the current range in a separate Chart sheet?
567. The formula in cell C2 is =$A$3*B3. When you copy it to D2, the formula in D2 will be:
568. Which is NOT one of the four function arguments in a VLOOKUP?
569. The Subtotals feature works best when Excel sees that the data have:
570. Which formula exists in excel, but does not appear on the formula pallet?
571. What is the formula to find the first day of the following month?
572. The shortcut for writing the number 5,000,000 in an Excel cell is by typing the following formula
573. Which function will give you TRUE as an answer if Cell A1 contains 2 & Cell A2 contains 1?
574. Let's say you have rows of names & addresses, and you want to sort by Zip code. How would you do this?
575. How can you quickly display or hide the parts of a selected chart, like gridlines, axes and legend?
576. When using Goal Seek, the cell that you're setting must be:
577. What function can be used to identify duplicate values in Column A?
578. On a worksheet, you have 12 columns showing monthly sales figures, and 15 rows, 1 row per product. How could you create 15 yearly trendline charts for each product, and fit them neatly on the page?
579. When you've created a table, what's a quick way of getting a total for the last column of numbers?
580. Which of the following is not a standard Excel cell format?
581. An .xlsx file cannot store VBA macro code or Excel 4.0 macro sheets.
582. What is the correct answer: A1 value = 10 A2 value = 0 =IFERROR(A1/COUNT(A1:A2),'Err')
583. To convert the date 12/14/2014 in cell A1 to text in the format of YYYYMMDD, which is a valid option?
584. What is the correct term for separating contents from one cell into two by a common character?
585. If there is text in cell C5 and the formula in cell F10 =SUM(B2:E6) then the formula result will...
586. Which worksheet function returns the skewness of a distribution?
587. What is the fastest way to convert an array containing unrelated formulas that begin with the equal sign, but are stored as text into real formulas?
588. What is the formula for the Mean of a set of numbers?
589. Function to find the intersection of a row & a coulmn in a given range
590. What VLOOKUP parameter provides the multicolumn range or name of the range or date table to be searched?
591. What causes the Auto Outline feature to group some columns and rows, but not others?
592. Let's say you have a PivotTable with separate rows of sales from January to December. What's a quick way to further summarize the monthly data?
593. Which feature lets you see two sheets of a workbook on screen simultaneously, so you don't have to switch back and forth?
594. To store a macro in a workbook or template, what file extension must you save the file in?
595. Which of the following is an example of how you would use a data table?
596. One column of your PivotTables lists 500 dates over 2 years. How can you interactively filter the table to show just a range of dates?
597. Which of the following is not a predefined replacement for the [format] portion of the following expression? FORMAT (expression, [format])
598. By default, all cells in a workbook are:
599. Which feature of Excel allows the user to limit the number of text characters in a cell?
600. How can you create a custom style?
601. A common nested formula that allows more flexibility than VLOOKUP/HLOOKUP is:
602. The Char() formula does the reverse of which worksheet formula?
603. How would you summarize sales data in a PivotTable by product name?
604. If a cell contains a value that does not begin with the correct operator, Excel evaluates it as...
605. Which Windows Keyboard Shortcut unhides any hidden rows within the selection.
606. What command reveals which cells must contain data for the function in the currently selected cell to work?
607. If cell A1='Smith,Joe' then =Find(',',A1) returns:
608. While you are typing data into a cell, which of these commands cannot be performed?
609. what is the maximum limit of digits in excel?
610. How do you create a dynamic drop-down menu in Excel that automatically detects if new options (strings) were added to the source list?
611. What's one method of entering headers and footers?
612. The total sales for Year 1 is in C20, and the total sales for Year 2, which is greater, is in D20. What formula will show the percentage increase?
613. In cell E2, you write the formula =$C2*E$1. You then copy that formula to cell F6. What does it update to?
614. When your chart is selected, how can you get a small pop-up of alternate chart styles to choose?
615. Which is not a date and time function?
616. Instead of using the Hide and Unhide feature for rows and columns, what feature lets you hide and unhide rows and columns interactively?
617. Cell A1 contains the formula =F39. If you copy that to cell B2 the formula in B2 will be:
618. A drop down menu contains 'Sum','Average' and 'Max', a table exists mapping these values to 1,2 and 3 respectively. What function next to the drop-down will Sum, Average or Max A1:A100 based on the drop-down input?
619. How many users can work simultaneously on a shared workbook?
620. The correct formula to generate a random number between 20 and 100 is:
621. How can you do 'SUMIFS' in Excel prior to the 2003 version?
622. Which function, other than 'transpose', can be used to transpose the contents of an array of cells?
623. To change the color of a slice in a pie chart:
624. In which tab do you find Macros in Excel 2013?
625. Which keyboard shortcut selects all cells referenced by formulas in the selection?
626. To use the Subtotals feature, the list that has numbers you want to add must be:
627. I have a price list stored in a worksheet, and I need to increase all prices by 10%. Can I do this without reentering all the prices?
628. The aggregate function extends the capability of the subtotal function. Which function calculates the variance of values in the range by examining a sample of the values?
629. What is the simplest possible way to insert picture in cell A1 which shows on Mouse Hover on cell A1?
630. What is the keyboard shortcut to copy a formula/value to the highlighted cell from the cell to the left?
631. The shortcut to highlight a row is
632. Which setting must you modify to print a worksheet using a letterhead?
633. How may criteria can the SUMIF function have?
634. How can you format one sparkline separately from all the others?
635. In print preview, what is selected/displayed?
636. Which of the following will be true to add only positive numbers in a column.
637. Which is the proper vba naming convention for a macro?
638. When I have selected a column, what is the shortcut I can use to completely delete it?
639. Imagine a leaderboard of 1000 players. Column A shows player rankings, B their names and C their points. You want to sum the points of the top X players, where X is defined in D1. What is the correct formula?
640. If A1 is '=4*2' and B1 is '=6/2', what result would appear if C1 was '=A1(#)B1
641. You've selected a range of sales data that has categories across the top row of the columns. How can you get filter buttons on this row, and alternate-row striping for the data?
642. If A1=4.33, B1=6.111, and C1=26.5, then entering =A1:C1, when will return the answer ____ .
643. A Shared Workbook will allow users to do all of the following except:
644. Suppose you wanted A1, a non-whole number, to round up to the nearest whole number. What function(s) would NOT work?
645. Suppose you enter =EOMONTH(A1,1) and the date entered in A1 is 2/14/2012. What will be the result of this function?
646. Which Group on the ribbon gives you quick access to the Sum, Average, Count, Min, and Max functions?
647. The formula =EOMONTH(2/1/2011,4) will return what date, if the cell is formatted MM/DD?
648. After generating a summary page of Scenarios, how can you refresh the summary if there are changes to the underlying data?
649. How do you change the column labels from numbers to letters?
650. Which formula will provide the same result as the following: =SUMPRODUCT(A1:A10,B1:B10)
651. Which worksheet function returns the negative binomial distribution?
652. What function do you use to find the present value of a series of annual cash flows at a specified discount rate?
653. What is the result of the formula =FLOOR(23.4, 0.5)?
654. The chart wizard term data series refers to:
655. How do you insert a blank worksheet using keyboard shortcut?
656. Which worksheet function returns the standard normal cumulative distribution?
657. What is the default shortcut to apply accounting-style cell formatting? ex: ($5,454.25) for the value -5454.25
658. What does 'Merge Cells' do?
659. Suppose you want VBA to run a loop that will continue until it finds an empty cell. Which of the following will allow you to do this?
660. The values for A1:A5 are A1=1, A2=3, A3=2, A4=5, A5=4. The formula PERCENTRANK(A1:A5,A2) returns the value:
661. I have a column of values in ranges A2:A100 that I need to concatenate with the number 2. Which of the following is not a way to do this?
662. What tab would you use to format a section of text as a table?
663. What will F11 command do?
664. Which worksheet function returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value?
665. The formula =VLOOKUP(A1,B2:D100,3,0) returns a result from column:
666. Cell A1 has the formula =5+A+6. The formula result of B1 = IFERROR(A1,22) is:
667. Which of the following is true about PivotTables?
668. When exporting with a .slk (symbolic link) format, what is preserved?
669. In Solver, the Set Objective cell
670. Which of the following formulas contains the correct syntax for a calculated field within a PivotTable?
671. Assuming Cell A1 is populated with 16.8942, which of the following formulas would result in 16?
672. If you're drawing multiple shapes, how can you keep the Shapes drop-down panel visible, so you don't have to keep clicking the Shapes button?
673. Which of the following is NOT a 'Solving Method' available in the Solver Add-in?
674. If you save a workbook with the results of a Goal Seek calculation in place what will occur?
675. What is a known bug in Excel?
676. The formula =countif(a1,a1) typed in cell b1 will result in:
677. A particular chart layout can be applied to a chart only if:
678. What does VLOOKUP formula return when the columns in an array area exceed the available columns in your table?
679. Which of the following series type is not valid for Fill Series dialog box?
680. Which worksheet function returns the probability that values in a range are between two limits?
681. Which worksheet function returns the standard error of the predicted y-value for each x in the regression?
682. Which of the following is a valid type of graph?
683. Which tab will you select to unhide and hide the sheet?
684. Which worksheet function returns the sum of squares of deviations?
685. Which of the following options is NOT located in Page Setup?
686. Which function is used to create dynamic range names?
687. Which of the following is a correct way to hide the contents of a cell?
688. Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from:
689. Which worksheet function returns the poisson distribution?
690. Which of the following terms is NOT part of pivot table terminology?
691. What is the default number for maximum iterations?
692. How does a user prevent circular references conflict errors?
693. In the formula =(B6+39)/SUM(D4:F8), which part is evaluated first?
694. To observe the change to a cell on another tab based on changes made in the current tab, use
695. Which worksheet function returns the square of the Pearson product moment correlation coefficient?
696. Does adding a password cause the excel document to be encrypted when its saved?
697. Which worksheet function returns the mean of the interior of a data set?
698. =SUMPRODUCT(--(A1:A2='z'),B1:B2,C1:C2) for the data in rows 1 and 2: A B C z 2 5 y 3 4
699. Which worksheet function returns the probability associated with a Student's t-test?
700. What does SHIFT+DELETE do?
701. Which worksheet function returns the serial number of a particular time?
702. Which worksheet function returns the inverse of the Student's t-distribution?
703. The shortcut for transpose is
704. Which of the Following is an Evolutionary Solving Method Option in Solver?
705. Which Solver Solving Method will solve non-smooth problems?
706. Which of the following is not a style of conditional formatting for value based rule for cells?
707. To print a page number on the bottom of every printed page:
708. Which menu option can be used to split a window?
709. A sales worksheet shows all sales for the year. Customer name in column A, sale status in column B and sale value in Column C. What value will the formula '=SumProduct(--(B3:B70='pending'))' return?
710. Entering =1/12/2011 into a cell with default formatting results in:
711. Suppose you enter ='$30'+10 into a cell. What will the cell display?
712. How do you begin to record a macro?
713. Which of the following is not information you can specify using the solver?
714. How do you print an Excel Workbook with the Title Row A1:A2 on each page?
715. Which worksheet function returns a normalized value?
716. How do you remove a field from a pivot table?
717. The arguments of the formula =SUMIF($G$5:$G$257,'Large',H$5:H$257) are:
718. Which worksheet function returns the slope of the linear regression line?
719. Which function checks to see that all conditions are true before returning a TRUE response?
720. When creating a vertical page break without creating a horizontal page break as well, the active cell
721. Which is true of Excel Macro-enabled templates and Excel Add-ins?
722. The status bar does which of the following:
723. Which worksheet function returns the parameters of an exponential trend?
724. The source range for a Pivot table may not contain:
725. The definition of the array formula {=SUM((C90:C93)*(D90:D93))} is:
726. What function is NOT considered a Math & Trig function?
727. In the formula '=VLOOKUP(A3,$J$3:$K$12,2,TRUE)', the 4th argument of the VLOOKUP function, 'TRUE', indicates
728. What formula permits the use of multiple lookup criteria?
729. You want to pick a winner from a set of names in A:6 to A:34. Which methodology will allow you to perform this?
730. Which worksheet function estimates standard deviation based on a sample, including numbers, text, and logical values?
731. If you add a column within the source data range of a pivot table, then the pivot table...
732. When editing an advanced filter, which choice is NOT available?
733. How do you manage range names?
734. If you enter the formula =mod(2,5) into a cell, what will the cell display?
735. Which of the following is NOT an option to erase the contents of a cell?
736. Which worksheet function Calculates standard deviation based on the entire population, including numbers, text, and logical values?
737. What additional ability does the Classic PivotTable Layout provide?
738. For a formula that calculates gross pay based on hourly wage (column A) and hours worked (column B), what are the cells in columns A and B called?
739. The formula SUMPRODUCT(a1:a4,b1:b4) is equivalent to:
740. Which of the following chart types is featured in Excel?
741. You can set Page Border in Excel from...
742. You can automatically adjust the size of text in a cell if they do not fit in width by
743. Cell A1 contains two blank spaces (eg press the space bar twice). The formula =ISBLANK(A1) returns:
744. Under the Format menu, under COLUMN, which of the following is NOT an option?
745. The formula QUARTILE(a1:a100,2) returns the same value as:
746. What is not a Excel function category?
747. In default formatting, when you preface the string '10500' with a dollar sign ($) and press enter, what is the result?
748. When does the #NAME? error occur?
749. The formula =IFISERROR(A2) returns:
750. June 6th, 2011 was a Monday. Based on the normally set week, date value 6/6/2011 is in cell A1. The formula in B1 =Weekday(A1) returns:
751. To add a comment, select the:
752. The formula =REPLACE('the cat in the hat',12,3,'red') returns:
753. Cell A1 contains the text string 'BA1740'. The formula to extract the last four characters as a value in A1 is:
754. In Excel, you can choose a picture as the background of a:
755. If you enter 'August 1, 2012' (without quotes) in cell A1 in a new worksheet, which data type would it be?
756. The list of items for a dropdown box must be on the same worksheet as the dropdown box.
757. What does the Surface chart type describe?
758. How are dates stored in Excel?
759. Which tab do you click to make paragraphs in Excel?
760. If a column is hidden, Excel will not copy the contents of the hidden cells in a copy/paste set of commands.
761. Which automation function calls a procedure in a dynamic link library or code resource?
762. In order to create a new report in Excel you have to go to:
763. Excel accepts the following range name:
764. Evaluating cell A1 based on font color:
765. If a file is saved, the actions that preceeded the save command cannot be undone.
766. What formula generates a fractional number that is greater than 0 and less than 1?
767. Which worksheet function returns values along a linear trend?
768. Which worksheet function returns the maximum value in a list of arguments, including numbers, text, and logical values?
769. Which is NOT an option for formatting a row?
770. You're writing a macro and want to add the following comment: use this code. How would you add this comment?
771. True or False: The Remove Duplicates command treats items that are spelled the same but capitalized differently as two distinct items.
772. By placing the cursor in a cell and inserting a picture, the picture is then 'attached' to that cell.
773. Which is a valid option in the Data Validation Allow settings?
774. Which of the following is an example of a conditional formatting rule?
775. What is the quickest way to highlight all of the blank cells in selected section that has both filled and blank cells?
776. A 3D reference means
777. Which of the following is NOT TRUE about scatter plot graphs?
778. If two formulas that depend on one another need to be solved at once and a circular reference is created, this can be resolved by:
779. Which option won't allow you to print an embedded chart?
780. The formula ISERR(A1) does not return TRUE if A1 is :
781. Which worksheet function estimates variance based on a sample?
782. When working in a Pivot Table, the additional menu items 'Options' and 'Design' are found:
783. Which keyboard shortcut selects cells that contain formulas that directly reference the active cell?
784. The sumif function can sum data based on multiple criteria.
785. What happens when you push F1 button
786. If you want to select margin sizes,where you should go?
787. Where in the ribbon is the 'Zoom to Selection' tool located?
788. When you are typing information,how are going to type 005 in a cell(after enter typed 005 should look the same 005)?
789. What happens when you start a formula out with a minus sign (-)?
790. The combination Ctrl+F1:
791. To build a PivotTable, how must your data be formatted?
792. What happens when you use the combination Ctrl+Space
793. When there is a big range of data (many sheets with at least 1000 rows in each),what is better regarding calculating process
794. Where on the Developer's tab is the VBA button located
795. When you have multiple sheets in an excel workbook and want to look at two of them at the same time,you should click:
796. Given an Excel spreadsheet: A B C D E ----------------------------------------------------------------------------------- | ID Lastname First name Role Birth Date 1 | 101, Davis, Sara, Sales Rep, 12/08/1968 2 | 102, Fontana, Olivier, VP Sales, 12/19/1952 3 | 103, Leal, Karina, Sales Rep, 08/30/1963 You want to find the first name of the person with the lastname = 'Fontana'
797. In Microsoft Excel 2013, the New Comment option is available under which of the following tabs?
798. Which statement is correct about Excel file protection?
799. In Excel 2013, the margin is set to which of the following values, by default, for each workbook?
800. Suppose you made some changes in Sheet1 in cell 'B13' and you want to change the same cell in Sheet2. Which of the following functions will help you for this task?
801. Peter created an Excel sheet containing the name and price of articles sold at a jewellery store; however, when he viewed the document again, he noticed that some of the cells contained pound signs as shown in the given image. What should be done to resolve this issue?
802. Keyboard shortcut for accessing the Spelling option in Microsoft Excel 2013?
803. A Pivot table enables fast and easy ... of inbuilt relationships in the data sources.
804. Difference between the .XLSX and .XLS file format?
805. In Excel 2013, what happens if you select a row heading, right-click and select the option, Insert?
806. Excel 2013 features allow sharing file with other people and working together in real time?
807. Which absolute reference should be used to ensure that on copying, neither the column nor the row changes?
808. .... helps to make a snap to filter the data of a pivot table
809. Options used for displaying all the formulas in a spreadsheet?
810. Suppose you created an Excel table as shown in the image. You applied a formula on cell D2: =B2*C2. What will happen if you select cell D2 and drag the fill handle up to cell D6?
811. What happens when the Freeze Panes option is used on a few rows and columns?
812. Which option allows us to copy content without formatting?
813. By default, after how many minutes does Excel 2013 auto save a user's workbook?
814. If we make a right click on the 'Red Square box' as shown in the given image, it opens which of the following dialog boxes?
815. If you type 'Your your' in a single cell, what will be the output?
816. While creating a new workbook or editing an existing one, some personal information might get added to the file automatically. If you want to share this workbook with others, then which of the following options will you use to remove such additional personal information?
817. Which option should be used if you want to prevent other users from opening a file? i) File encryption ii) Mark as Final
818. Keyboard shortcut used to switch between relative and absolute cell references while writing a formula in a worksheet?
819. Which of the following sorting options is NOT available under the Sort On dropdown menu in Sort dialog box while sorting the data of a table in an Microsoft Excel 2013 worksheet?
820. We can use Excel's _____________ feature to see how the pivot table would look in any style
821. Excel 2013 brings in a new method to filter data with __________ feature.
822. Correct syntax of the function used for calculating the total of all the values from cell B2 to cell B12?
823. When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2013, Excel creates new ________ with data corresponding to the pivot report value.
824. Charts button in Excel 2013 can change ________, ________ , and _________.
825. What is the function of 'Relationships' or 'Data Model'?
826. How many passwords can be set on a Microsoft Excel 2013 file?
827. Excel 2013 automatically arranges any two workbooks __________, when comparing them.
828. We can use the drag drop option to copy the content in Excel 2013.
829. Pivot tables are very useful for ___________ one set of data in your data list with another data set.
830. Which option is the miniature chart(s) that fit into a single cell and help(s) in analyzing and viewing trends in data without creating an entire chart?
831. Timelines are particularly designed for _______ fields that sort out data from a pivot table.
832. Which statements is correct about worksheet grouping?
833. VBA is used to automate tasks in Microsoft Excel 2010.
834. By using Names, data can be understood and maintained in a much easier way. Which of the followings are the correct examples of using Names in Microsoft Excel 2010?
835. Which of the following options are true about a PivotTable calculated field?
836. Mark inserts an image into a current worksheet. His client demands that the image should be attached with a cell and should resize when the cell is resized. Which of the following options is the correct Format Picture property, which will fulfil this requirement?
837. Roger upgrades from Excel 2003 to 2010. He wants to run the PivotChart Wizard but has not installed the Classic menu for 2010. Which of the following is the correct way to add the PivotTable and PivotChart Wizard?
838. Daniel groups three sheets: Q1, Q2 and Q3, containing sales data. What will happen on deleting the data of cell B2 from sheet Q1?
839. For Workbook Links in Microsoft Excel 2010, which security setting is NOT recommended?
840. What is the maximum number of users that can open and share a shared workbook at the same time?
841. If your Microsoft Excel workbook closes due to system error before you could save it, then which of the following is the correct way to recover it?
842. Laura inserts an image into a shape. She needs to make this image transparent so that the text remains visible. Which of the followings is the correct way to make the image transparent?
843. Slicers are typically associated with the PivotTable in which they are created.
844. Data of a copied cell remains on the clipboard until a cell is not edited.
845. The marketing team of XYZ Corp collects data of foods from multiple resources. If the marketing team wants to highlight the duplicate records of food, then which of the following sets of steps should be used?
846. Features available in Excel 2010?
847. Keyboard shortcut to insert a new worksheet?
848. Microsoft Excel's custom theme can be applied to content in Word, PowerPoint, Outlook and Access.
849. ScreenTips are small pop-ups that provide help when you place the mouse pointer on a UI element. Which of the following will happen on setting the ScreenTip language in an Office program?
850. Which limitation is valid in Microsoft Excel 2010?
851. John selects separate theme colors, formatting effects and theme fonts from their respective galleries. Now he wants to save the current settings for future use. In the Themes option under the Page Layout tab, which of the following is the correct option that can be used to save the current theme?
852. Kristen is working on confidential data and wants to make the Excel 2010 document password protected. Which of the following sets of steps will allow her to protect the document with a password?
853. Wilson prepares a PivotTable to summarize the month-wise sales of all the salesmen for the Fiscal year 2016-17. His boss asks him to show an additional report to showcase the difference from the previous month. Which of the following tabs in the Value Field Settings dialog box will fulfil this requirement?
854. In SharePoint Foundation 2010, co-authoring of Excel 2010 workbooks is supported by the Microsoft Excel 2010 Web App.
855. Maria needs to find unique values in a Microsoft Excel 2010 worksheet. Which of the following is correct about selecting data for finding unique values?
856. By using names, data can be understood and maintained in a much easier way. Peter creates a Named range, but he is not aware about the scope of the Name. Which of the followings is the default level of scope for a Name?
857. Mark's manager shares a report sample for preparing the sales report for the current year. He collects the data but is not able to figure out how to add trends (as shown in the last column of the image). Which of the following options should he insert into the worksheet to show the trends?
858. Ribbon can be customized by creating new tabs that house your desired commands. Which of the following statements is/are correct about Ribbon customization?
859. Robert inserts a PivotTable in Sheet 2 of a worksheet. He drags the 'Days' field from the PivotTable Fields to Values section. Which of the following options will be the default selection under Values?
860. Which of the following is NOT a valid option for language settings?
861. Which statement is correct about Microsoft Excel Online?
862. Mary wants to copy a worksheet from WorkBook1 to WorkBook2. Which of the following is correct about this scenario?
863. Which is not a type of expansion slot?
864. How can we define a name to a cell in a Microsoft Excel 2016 Worksheet?
865. Which cell reference in a formula should be used for making sure that a column value does not change when copied?
866. Keyboard shortcut used to display or hide the ribbon in Microsoft Excel 2016?
867. Sam wants to generate a Pivot table based on the data given in the image. He wants to show the count of employees for the values given in the Days column. For example, Days 5 = 3, Days 6 = 2, etc. Which of the following options will be the correct fields
868. What is the correct function of the Format Painter option?
869. The Split command enables a user to view a worksheet in how many panes?
870. What will happen if you enter XYZ1 in a cell and drag the fill handle down?
871. Which is used to avoid users to make changes to a worksheet in Microsoft Excel 2016?
872. What does the VALUE function do?
873. Default font for a new Microsoft Excel 2016 workbook?
874. Commands should NOT be removed from the Quick Access Toolbar because these commands are NOT available on the ribbon's command tabs?
875. By default, how many worksheets are there in a new Microsoft Excel 2016 workbook?
876. Keyboard shortcut pressed to switch between relative and absolute cell references while writing a formula in a worksheet?
877. Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the 'Marks Obtained' in the cell 'I4'
878. With respect to Protect Workbook in Microsoft Excel 2016, the Windows option can be used for preventing users from moving, resizing or closing the workbook window
879. Keyboard shortcut used for the 'Clear filter' command for Slicer in a Pivot table?
880. John inserts a PivotTable in Sheet 2, based on the data given in the image. He drags the 'Days' field from the list of columns to the Values section in the PivotTable Fields pane. Which of the following options will be the default selection under the Values section?
881. Correct procedure used for converting a table to a regular range?
882. By default, all cell references in Microsoft Excel 2016 are:
883. If a user specifies a print area from the backstage view, then it saves the setting with the workbook.
884. User can enable the Data Connections settings, in order to connect with external data?
885. John inserts a PivotTable in a worksheet, as shown in figure 1 of the given image. There are three columns in the data source: Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 2 of the given image. Where should he double-click on the PivotChart in figure 1, so that he should be able to select the Product column?
886. Which is NOT a command tab in Microsoft Excel 2016?
887. Default file extension(s) of a Microsoft Excel 2016 workbook?
888. Which option is NOT available under 'What-If Analysis'?
889. In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?
890. Keyboard shortcut used for achieving the strikethrough effect as shown in the given image?
891. Suppose that you have a table in a worksheet of Microsoft Excel 2016 workbook, as shown in the image. Which of the following output is obtained if you select the table and check the Total Row option under the Design tab?
892. Which tab will you click for accessing the View Macros option?
893. Which is NOT a valid option for Macro Settings under the Trust Center?
894. The CHOOSE function can be used for selecting up to how many values based on an index number?
895. What will happen when we click on the marked triangle as shown in the given image?
896. Option used for limiting or restricting the cell entries to a certain data type?
897. The Save As option can be accessed from which of the following tabs?
898. Which is correct about the customization of the Quick Access Toolbar?
899. Which is correct about the #Data constant in Microsoft Excel 2016?
900. Which filter can be created using the AutoFilter option in Microsoft Excel 2016? i) By list values. ii) By format. iii) By criteria.
901. Commands allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?
902. Which statements is correct about Track Changes in Microsoft Excel 2016?
903. Function used for providing the decimal number of the time represented by a text string?
904. Options used to access the option that is used to get data from a text file?
905. Keyboard shortcuts used for moving from any cell to the beginning of a worksheet, i.e. cell A1?
906. Which option can be locked in a worksheet? i) Ranges ii) Formulas
907. Correct syntax of the VLOOKUP command?
908. Which function is used for returning the sheet number of a reference sheet?
909. Which functions is used in order to return the serial number that is used for representing the date, which is the indicated number of months before or after a specified date?
910. Which options provides a user the access to options such as Share, Export, Account, Publish, etc.?
911. Consider the Excel sheet given in the image. What will be the output if we apply the formula, =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, '>6')?
912. While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named 'Sheet5'?
913. In Microsoft Excel 2016, the commands used for recording, creating and deleting macros is accessed from the Developer tab. Which of the following is the correct way of displaying the developer tab on the ribbon?
914. What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?
915. In Microsoft Excel 2016, which of the following statements is/are correct about dates? i) The default date format uses 4 digits for the year. ii) The dates are left-justified in the cells by default.
916. Which command is used in Microsoft Excel 2016 for totaling all the budget spreadsheets prepared by each department in an organization?
917. Which of the following keyboard shortcuts is used for displaying the Record Macro dialog box that is used for recording macros?
918. Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?
919. Which option can be used for checking the protection status of a file in Microsoft Excel 2016?
920. A PivotChart is a graphical representation for a summary of data displayed in a Pivot table.
921. How can we remove password encryption from a Microsoft Excel 2016 file?
922. While entering data in an Excel 2016 worksheet, what happens if you press the tab key in a cell?
923. Which logical function doesn't return True or False as a result in Microsoft Excel 2016?
924. In Microsoft Excel 2016, the =TODAY()command returns:
925. In Microsoft Excel 2016, which of the following arguments of the YEARFRAC function is/are optional? i) Start date. ii) End date. iii) The type of day count basis to use.
926. What does the blue triangle and border color imply in cell B4?
927. The IT security department of Mark's organization has decided that only digitally signed macros will be allowed in Microsoft Excel 2016. Which of the following is the correct way to restrict the unsigned macros?
928. Peter was working in a Microsoft Excel 2016 workbook. His workbook closed due to a system error and he couldn't save it. Which of the following is the correct way to recover an unsaved workbook?
929. How can we publish a Workbook to Power BI?
930. The 'brush' symbol indicates which of the following options?
931. What will be the output if the formula, =SKEW(A2:A11), is applied to the given content in Microsoft Excel 2016?
932. Consider the data given in the image. What will be the output if the formula, =PROPER(A1), is applied to cell A2?
933. What are ScreenTips in Microsoft Excel 2016?
934. Correct keyboard shortcut for accessing the backstage view in Microsoft Excel 2016?
935. Which is correct about macro naming rules in Microsoft Excel 2016?
936. While editing a cell's content, if you change your mind about the changes you made before pressing the enter key, which of the following keys can be pressed to restore to the original text?
937. Which function can be performed on a protected worksheet if the password is not known?
938. Correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?
939. For which of the following options, if included in a worksheet, we cannot use the Track Changes option?
940. When do we receive a '#Value!' error in the VLOOKUP function? i) When the 'lookup_value' argument is more than 255 characters. ii) When the 'col_index_num' argument contains text. iii) When the 'col_index_num' argument is equal to 0.
941. In Microsoft Excel 2016, which of the following options used for displaying or hiding formulas change(s) the state of a cell? i) Prevent formulas from displaying in the formula bar by protecting the cells that contain them. ii) Switch between displaying formulas and formula results on a worksheet. iii) Show hidden formulas by removing the protection from cells.
942. Correct method(s) of consolidating data in Microsoft Excel 2016?
943. Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?
944. Which of the following options can be copied using the format painter in Microsoft Excel 2016? 1. Alignment 2. Background color 3. Cell text
945. In Microsoft Excel 2016, which of the following statements are correct about a Pivot chart? 1. A Pivot chart is a graphical depiction of a data summary. 2. You cannot create a Pivot chart without a Pivot table. 3. You can create a Pivot table and a Pivot chart at the same time.
946. Consider the Excel sheet given in the image. If you wanted to find out the average of all the cells that meet multiple criteria which function would you use?
947. What does the Look up value function do?
948. In Excel 2016 worksheet, which shortcut is used for switching between displaying formulas and their results?
949. Which of the given page margins are available under the Page Layout tab in Excel 2016?
950. Which of the given types Of pivot charts can be used in Microsoft Excel 2016? 1. Pie chart 2. Waterfall chart 3. Treemap chart
951. Data sorting in columns can be performed on which Of the given Options? 1. Values 2. Cell Color 3. Font Color 4. Cell icon
952. In Microsoft Excel 2016, which of the following Engineering functions tests the equality Of two numbers?
953. Consolidate Option is available under which of the following tabs?
954. In Excel 2016, which function returns an aggregated value from the cube?
955. Can we change the default font size of a new workbook in Excel 2016 from the Backstage view?
956. Which of the given statements are correct about the slicers in Microsoft Excel 2016? 1. They can be used to filter data in a table. 2. They can be used to filter data in a PivotTable. 3. They can only be connected to PivotTables that share the same data source.
957. A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 workbook.
958. lf Sam wants to insert a pivot chart in his Excel worksheet, then which Of the following tabs should he use tO perform the same?
959. In order to protect your Excel data, which of the given file-level protections are available in Microsoft Excel 2016? 1. File encryption 2. Setting a password to open or modify a file 3. Digital signature
960. Correct function of the Wrap Text in Microsoft Excel 2016?
961. Can you perform a case sensitive data sorting in Microsoft Excel 2016?
962. if Sam wants to change the Office theme or background. then which of the following options will he use?
963. in relation to the Backstage view in Microsoft Excel 2016, which of the given commands! options are available under the Info tab? 1. Protect Document 2. Manage Workbook 3. Browser View Options
964. The cursor in the given image is on A3 cell. If you want to move the cursor to E8 cell, then which of the following shortcuts can be used?
965. What are the correct purposes of CEILINGMATHI) function in Microsoft Excel 2016?
966. The Lookup & Reference Option is available under which Of the following tabs?
967. In relation to the Clear option under the Home tab in Microsoft Excel 2016. which of the following options can be cleared from the cell?
968. Which of the following tabs will you use to hide the header row of the table (given in the image)?
969. While creating a PivotTable in Excel 2016, where can a user place the PivotTable report? It is always placed in a new worksheet. It is always placed in an existing worksheet. It can either be placed in a new worksheet or in an existing worksheet. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?
970. Which of the following functions checks whether all the arguments are TRUE, and returns TRUE if all the arguments are TRUE?
971. In relation to building out the PivotTable, which of the following fields are added to the COLUMNS area?
972. What formula would you use to find and replace the second occurrence of a hyphen with a colon for the cells in column A:
973. An Excel workbook is a collection of ?
974. Which of the following are advantages of range names?
975. A ___ is similar to a data bar in that it compares the relative values of cells in a range. Instead of bars in each cell, you see cell shading, where the shading color reflects the cell’s value?
976. A worksheet range is as following?
977. What are Information Functions in Excel?
978. All 2-D and 3-D charts have an x-axis known as the horizontal axis and a y-axis known as the vertical axis. Which of the following charts don't have x-axis and y-axis?
979. In Excel, the Insights panel displays online information and images about the text you highlighted. What is that specific control that hold the insights panel when you right click on your highlighted text?
980. By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Names must be no more than 255 characters long, you can also use any single letter as a range name except the following?
981. Which of the following is not a reference Operator in Excel?
982. You can use the horizontal and vertical scroll bars from?
983. Each excel file is called a workbook because?
984. What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?
985. When you work with large worksheets, you may need to use?
986. Which of the following depicts a correct range?
987. Which options reflect a correct range?
988. A special feature that is introduced for mathematical problems in which handwritten equations are converted to text for inserting into your document. How can that feature be accessed?
989. Excel, When you use group worksheets?
990. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
991. You can add an image to a template by clicking the Insert Picture From File button on the __ Toolbar?
992. You can work with a wide variety of data sources in Excel, including native data and external data. Some, but not all, of the external data sources that you can use in Excel are supported in Excel Services and Excel Web App. Which of the following data connections are not supported in Excel Services?
993. To visualize the relative values in a range, that’s where Excel’s ___ come in. __ are colored, horizontal bars that appear “behind” the values in a range?
994. Which of the following feature is correct about autofill?
995. Use___ to visualize the relative values of cells in a range. In this case, however, Excel adds a particular icon to each cell in the range, and that icon tells you something about the cell’s value relative to the rest of the range?
996. We can perform What-If Analysis in Excel with the use of Data Tables in which we can see the effect of changing an input value on the result returned by a formula as soon as we enter a new input value in the cell that feeds into the formula. Which types of Data Tables can we create to perform What-If Analysis in Excel?
997. When creating dashboards and reports in Excel, it’s often useful to have a helper table that contains a list of dates that represent business days. This kind of a helper table can assist in calculations like revenue per business day, units per business day, and so on. Which of the ways to generate easiest a list of business days is to use the following function?
998. How would you provide a Dynamic range in “Data Source” of Pivot Tables?
999. How cell reference is useful in the calculation?
1000. We can create new custom Theme in Excel 2010. To create a new style, follow these steps?
1001. Which is the following statement is True for Ribbon?
1002. Creating a Module, A VBA module can hold following types?
1003. What you could do to stop the pivot table from loosing the column width upon refreshing?
1004. What are the Report categories in Excel?
1005. Excel Services and Excel Web App all have a lot in common, but they are not exactly the same. These applications can differ in what workbook features are supported for viewing in a browser window. Which of the following feature is not supported in Excel Services?
1006. In Excel 2016, the Forecast Sheet feature can turn a worksheet which contains historical financial data in a visual forecast worksheet. What type of chart is used by default if you do not use a chart of your own choice?
1007. Microsoft does not support the automatic removal of hidden information for signed or protected documents, or for documents that use Information Rights Management (IRM). The Document Inspector has modules that help users inspect and fix specific elements of a given document. Which of the following is not Excel built-in document inspector module?
1008. Which of the following is True when #NAME, error appears in Excel cell?
1009. DGET Database Function in Excel extracts a single value from a record in the data list that matches the criteria you specify. DGET Function return error value if no record matches the specified criteria or the match criteria is greater than the specified criteria. Which of the following error values is returned if multiple records are matched?
1010. The auto calculate feature in Excel does which of the following?
1011. Which of the following command converts row data into columns?
1012. When you have many different PivotTables in one report, you can share a slicer that you created in one PivotTable with other PivotTables. Which of the following statements is not true?
1013. PivotTable and PivotChart reports provide ways to calculate and summarize your data. You can enhance the results by writing your own formulas to create calculated fields and calculated items. Which of the following is not true for Calculated items in PivotTable?
1014. Excel recognizes certain values, such as ____ and Quarter 1, as parts of larger lists. When you drag the fill handle from a cell containing one of these values, Excel fills the cells with the appropriate series?
1015. Select Home->Fill->Series. Excel displays the Series dialog box. Which of the following represent the 'Growth' type?
1016. Multiple calculations can be made in a single formula using?
1017. Which of the following statements is True Using PivotTables and Charts?
1018. Excel provides the following analysis features for instant data analysis, Choose a True statements?
1019. The following formula uses Get last name from name?
1020. Extract word that begins with specific character as following formula?
1021. How to change the number of sheets in new workbooks?
1022. Which of the following can be accomplished by Creating Highlighted Cell Rules?
1023. A Data Model integrates the tables, enabling extensive analysis using PivotTables __ , ___?
1024. Get work hours between dates custom schedule using the following formula?
1025. Which of the following formulas yields the work hours between dates on a custom schedule?
1026. Which of the following function can be used to pad a cell with characters, such as the dot?
1027. Count unique text values in a range, Choose formula?
1028. Which formula listed will count unique text values in a range?
1029. The following formula uses Extract word containing specific text?
1030. Which of the following formulas can be used to extract a word containing specific text?
1031. What is the sequence of operating mathematical operation in Excel?
1032. A formula palette is used to:
1033. Which formula yields the address of the last cell in a range?
1034. Which formula yields the address of the last cell in a range?
1035. Address of last cell in range as following formula?
1036. If the Formula cannot return a legitimate result or an inappropriate argument in a function, you will get the following error?
1037. If the Formula cannot return a legitimate result or an inappropriate argument in a function, you will get the following error?
1038. Which of the the following formulas will get the Last Name from name?
1039. Information Rights Management (IRM) allows individuals and administrators to specify access permissions to documents, workbooks, and presentations. This helps prevent sensitive information from being printed, forwarded, or copied by unauthorized people. IRM cannot help with the following though:
1040. To prevent yourself or others from accidentally deleting formulas or other critical data you can use:
1041. Which formula returns the sum of the three smallest values in a range named Data?
1042. To convert fluid ounces to milliliters you can use the following function:
1043. A ____ is essentially a dynamic summary report generated from a database.
1044. Which of the following is true for dates and times (choose all that apply)
1045. What will be displayed in the cell if the following formula is typed? =SUM({1,2,3,4}*{5,6,7,8})
1046. Which option would you to use visualize the relative value of cells in a range?
1047. A formula may return any of the following error values:
1048. Which of the following is the correct formula to refer to cell A1 on Sheet1 in a workbook named Annual Budget.xlsx?
1049. To force cell A1 to only accept the text value which of the following is correct?
1050. To create the consolidations- For example, to compute the total for cell A1 in worksheets named Sheet2 through Sheet10 you will use the following formula:
1051. How can you remove duplicate rows in Excel?
1052. How can you add a total row to an already created table?
1053. To autofill month names you need to type __ and then drag the fill handle. (choose all that apply)
1054. A #VALUE! error is very common and can occur under the following conditions:
1055. To remove all non printing characters from a cell you can use the following function?
1056. To restrict values entered in a range between 0 and 10 we can use?
1057. =WEEKDAY(A1)=2 The above validation formula ensures that:
1058. Consider the given image below
1059. Often, an error in one cell is the result of an error in a precedent cell. To trace the error to the source you would use?
1060. Referring to the figure below. If you have the ages of people and want to classify them into groups such as 17 or younger, 18–24, 25–34, and so on, you would use which formula in cell B2?
1061. What will be returned by entering the following formula? =SUM({1,0,1,0,1})
1062. Anytime when you return more than a single cell, you should be using array formula. Array formulas are special formulas that work on an array of numbers and it will work effectively if you press the following keys combination?
1063. In Excel, a data list, or database table, is a table of worksheet data that utilizes a special structure, a built-in Data Form allow the users to edit records in a data list. For smaller data list, you can use the navigation keys as well the scroll bar of the data form to locate record require editing. What type of commands can be used for locating a record if we want to make changes in it while using larger data list?
1064. Excel provides ____, which are labels applied to a single cell or to a range of cells?
1065. In most cases the PivotTable loss the column width when it is refreshed. Which of following option is true when The PivotTable is refreshed, not to lose the width of column when it is refreshed?
1066. When you force a lookup function to return an exact match and if it cannot find the one, it returns the #N/A error. Which of the following function allow you to hide errors returned by Lookup function?
1067. Some features work differently in Excel Online as compared to Excel desktop version. Which of the following is not true for Excel Online?
1068. To get the real time Web Based Co-authoring, a new component is added on the server that sends notifications to all browsers connected to a workbook. How the changes are visible to each connected browser of a workbook, if any of the cell value is been changed?
1069. Excel contains a conditional formatting preset that highlights top/bottom values. However, using a formula instead provides more flexibility. If you have a series of data with high & low magnitude values and you want to format only N number of high magnitude values in the series of data, which of the following formulas is valid?
1070. Which of the following formulas is not entered correctly?
1071. Is it possible to make Pivot table using multiple sources of data?
1072. Which of the functions listed will not work if you are looking for an exact value based on a right lookup column?
1073. If cell A2 has a full name (Fristname, Middle Initial and Lastname) like 'Karen E. McRich' which of the following formula will extract the lastname?
1074. Which one of the following get displayed if custom numeric format is set as follows and cell has 123456? 'Acct'# 00-0000;;;;'Don't enter dash'
1075. What will be displayed if custom format is [>8/15/16]'OVERDUE!';mm/dd/yy and cell contains 8/23/2016?
1076. Tables offer following advantages?
1077. To show the actual formula instead of Cell Values which function can be used?
1078. Which of the following is correct when #VALUE! error appears in cell?
1079. Which of the following returns the sum of range A1:D1?
1080. In the case of synchronizing changes between Table and model, a linked table is a live connection between the range or named table that contains the data values, and the Data Model that powers the report, by default. The Data Model is updated automatically if changes occur in _____?
1081. What could you do to stop the pivot table from losing the column width upon refreshing?
1082. Which option allows you to choose different Chart style options?
1083. To create a drop down list box which only allows you to choose the value defined in range O1:O12 you need to setup:
1084. Which table option gives you different background color for odd/even rows?
1085. To insert a chart for data in a table, select any cell in the table and then choose ____
1086. What is the setting that is the default macro security setting?
1087. How can you delete the contents of a cell and its formatting at the same time?
1088. To split a single column into multiple columns based on delimiters or fixed width you may use which option?
1089. To create an outline in Excel in order to easily expand a heading and show the summary below it, you would select from the menu:
1090. Shape Data include the following steps?
1091. What does the Excel 'Reduce file size....' option do? (choose all that apply)
1092. Which of the following function accepts a range as an input?
1093. Which of the following is/are array formulas?
1094. Which of the following function(s) accepts criteria?
1095. Statistical methods have been used for statistical analyses. A brief list of the more popular methods as following?
1096. Which formulas use absolute references?
1097. Which options are available for Auto Fill?
1098. To combine data of two or more columns into another column, you can usually use the concatenation operator _____ in a formula.
1099. Suppose that you have a worksheet that you update frequently by adding new data to columns. You may need a way to reference the last value in column A (the value most recently entered at bottom of column A). If column A contains no empty cells which of the formula returns the last value entered in column A (bottom one)?
1100. Which of the following feature correctly represents the following statement? In Excel we can use text series (such as January, February, March, or Sunday, Monday, Tuesday) and numeric series (such as 1, 3, 5, or 2014, 2015, 2016). Instead of entering these series by hand, you can use the fill handle to create them automatically.
1101. Which formula needs to be typed in B3 to increase sales by 3.5% from the cell above, and then take advantage of autofill to fill the rest of the cells in the column instead of retyping the formula for every cell?
1102. If you have values in a range named Data, you can determine the smallest value by using the following formulas?
1103. =SUM(IF(ISTEXT(A1:D5),1,0)) will return?
1104. What will be the result of calling the h() function in the following C++ code? const char* upwork[] = { 'Freelancers', 'Projects', 'Fixed', 'Hourly } const char* f(int i) { return upwork[i]; } void g(string s){} void h() { const string& r = f(0); g(f(1)); string s = f(2); cout << 'f(3): ' << f(3) << ' s: ' << s << ' r: ' << r <<
1105. Which statement is incorrect?
1106. How will you reverse the direction of a SmartArt graphic?
1107. How would you locate the last filled cell on a worksheet?
1108. Which chart displays axes but cannot display axis titles?
1109. When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.
1110. Which method will you use to update table data from a Sharepoint list?
1111. When would the data validation command be unavailable on the data tab?
1112. Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?
1113. Which is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
1114. Case-sensitive sorting of text in Excel2007 can be performed.
1115. Which type of additional information is stored within the digital signature?
1116. When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
1117. 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?
1118. When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
1119. How should blank cells be inserted on a Worksheet?
1120. 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?
1121. Which keyboard shortcut should be used to minimize or restore the ribbon?
1122. Which is not a valid file extension in which an Excel file can be saved?
1123. Where can the 'Show All Comments' command be found?
1124. Which is not true regarding column width?
1125. Which database function estimates variance based on a sample from selected database entries?
1126. A Macro project can be digitally signed.
1127. Which method would you follow to add an alternative text to a picture?
1128. Which of the following charts have no axes?
1129. Which line style should be used to specify the style used for the end of the line?
1130. When does the triangle appear in the top-left corner of the cell, as shown in the picture?
1131. What does the screen tip displaying 'Showing All' mean?
1132. Which part of the formula displays references in the given picture?
1133. Result, when =T(A4) is applied on the given table?
1134. What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?
1135. The checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?
1136. Which Chart type is displayed in the given picture?
1137. Which formula should be written on the given table to display 'Nancy Davolio'?
1138. What will be the result if the formula =B3&', '&A3 is applied on the given table?
1139. Which Document properties includes both file system properties and statistics that are maintained by Office programs for the user?
1140. Which of the following is not true about the Watch Window?
1141. For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
1142. What is the option on the Document Inspector that finds the content type information?
1143. How would you select an entire PivotTable report?
1144. How will you display the Go To dialog box?
1145. Which tab should be used to display or hide axes?
1146. Which of the following methods would you follow to remove subtotals?
1147. Which file format is typically used to remove printer corruption?
1148. Which among the following is not true regarding a calculated column?
1149. How can a chart be modified?
1150. Which is not true about an offline cube file?
1151. Which option would you choose to clear a PivotChart report?
1152. Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
1153. How will you find cells with data validation?
1154. What is the purpose of using the Keep text flat option, as shown in the picture?
1155. What is the purpose of the cell denoted as 'A' in the worksheet?
1156. When does the error, as shown in the picture, occur?
Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
1157.
This question is based upon the figure shown below
1158. Which causes the last row in the table to appear and displays the word Total in the leftmost cell?
1159. What does the red icon indicate, as shown in the given picture?
1160. Which is not true regarding the use of a pie chart?
1161. If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
1162. Which is not true regarding naming a cell?
1163. No data is deleted when an outline is hidden or removed.
1164. Which of the following wildcard characters can be used as comparison criteria for Text Filters?
1165. Which Fill options should be used to add color and transparency to a shape?
1166. Which among the following options displays Legend entries in the given picture?
1167. Which option would you choose to display a list of formula used in the current PivotTable report?
1168. When a part of a formula is replaced with its calculated value, it cannot be restored.
1169. Which of the following options is not available on the Status bar?
1170. When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
1171. Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?
1172. Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?
1173. Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.
1174. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
1175. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
1176. Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
1177. State whether following statement regarding images in Microsoft Excel 2010 is true or false: Microsoft Excel 2010 supports 3D rotation of images.
1178. Microsoft Excel Services is a component of:
1179. Deleting a PivotChart report automatically deletes the associated PivotTable report.
1180. Excel keeps the changed history of a workbook for ________ days by default
1181. 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?
1182. Which of the following statements is NOT true regarding import of data into PowerPivot?
1183. How would you assign a macro to a graphic?
1184. Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value, lookup_vector, result_vector) Which of the following arguments of the LOOKUP function is optional?
1185. 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?
1186. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
1187. 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?
1188. Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value, lookup_vector, result_vector) The values in the lookup_vector must be placed in ________ order.
1189. 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.
1190. Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?
1191. Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
1192. Which among the following settings is the default macro security setting
1193. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
1194. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
1195. Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
1196. 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?
1197. Excel can publish a workbook to the server only in ________ or ________ format.
1198. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
1199. 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?
1200. 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?
1201. 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 ($).
1202. 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
1203. 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.
1204. In the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data. Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?
1205. 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?
1206. In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?
1207. In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?
1208. 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'?
1209. What does the icon marked with a red square in the figure above signify?
1210. 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))
1211. Which of the following tools is used to format Excel worksheet data, as shown in the figure above?
1212. ____ shows you how a fill color will look before you apply it.
1213. ________ is the process of arranging data in a specific order based on the value in a field.
1214. A ____ is a reference to a cell or range of cells in another workbook.
1215. A _______ describes the location of a cell based on its column and row location.
1216. A _______ is used to analyze and summarize your data without graphical support
1217. A _______ refers to the entire excel file.
1218. A ________ identifies a worksheet in a workbook.
1219. A chart sheet can contain ____.
1220. A formula can contain ____ and mathematical operators
1221. A header contains ____ boxes.
1222. A logical function is a function that works with values that are either ____
1223. A screen ____ is a portion, usually of one object or section of a window, of the screen.
1224. An error value begins with a(n) _____ followed by an error name that indicates the type of error.
1225. Argument names that display in ________ are required; others are optional.
1226. By default, excel includes _______________ when copying or filling a series.
1227. By default, excel worksheets appear in ____________ view.
1228. Category values are usually located in the ____ of the data source.
1229. Center, left and right text justification are examples of ________.
1230. Clicking the ____ box completes an entry.
1231. Clicking the ____ opens the insert function dialog box.
1232. Columns and rows in a spreadsheet collectively are called a(n) ______.
1233. Ctrl + g is used to access the ____.
1234. Data in a form created from the primary table is contained in the ____.
1235. Error messages begin with the _____ symbol.
1236. Every ____ consists of an object that contains a button for each unique value in that field.
1237. Excel allows you to take a ____ of any open window and add it to a workbook.
1238. Excel includes ____ types of smartart graphics.
1239. Header and footer elements such as worksheet name, current date, and time are _____ elements.
1240. If a sheet tab has ________ you know that it is not selected.
1241. If all of the logical conditions are true, the and function returns the logical value _____.
1242. In excel, a number can contain the characters ____.
1243. In the figure above, fv and type are ____.
1244. In the figure above, if you only want to set one criterion for this filter, you will ____.
1245. Italic, bold, bold italic, and underline are examples of _____.
1246. Make sure the header row option button is selected to indicate ____.
1247. Most software programs can both save and retrieve data in a(n) _______ file format.
1248. On a chart created in excel, the vertical axis is also called the ____.
1249. Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.
1250. Rows are typically represented by _______ and contain data for individual records.
1251. Sheet tab names are ________ when they are grouped.
1252. The path to the sum button is ____.
1253. The percent style button formats selected cells as a percentage with ________.
1254. The path to the comma style button is ____.
1255. The ____ category of excel functions returns (true-false) values.
1256. The ____ cell on the worksheet is the one into which you can enter data.
1257. To ________ a table means to arrange all of the data in a specific order.
1258. To create smartart, switch to the insert tab and use a button in the ____ group.
1259. To design a form using the form wizard, begin by clicking on the ____ tab on the access ribbon.
1260. To enter data in a cell, you must first select the ____.
1261. To erase an entire entry in a cell and then re enter the data from the beginning press the ____ key
1262. To make data easier to understand, use a ________ instead of a table of numbers.
1263. To set a page break in excel, select the _____.
1264. To start a new line in a cell press the ____ keys
1265. Use the ____ function to enter the system date into a cell in the worksheet.
1266. Using ________ enables you to select one or more rows or columns and lock them into place.
1267. Using the _____ key allows you to select multiple items, including multiple worksheet tabs.
1268. Using the excel spell checker, you can ____.
1269. Using the mouse to move or copy cells is called ____.
1270. When you click the header & footer button on the insert tab, excel switches to _____ view.
1271. Which of the following is not an excel function category? ____
1272. You can ____ the chart title text to select it.
1273. You can access the find and replace feature by pressing the ____ key(s).
1274. You can apply the bold font style by pressing the ____ keyboard shortcut keys.
1275. You can change, or ____, the contents of an active cell at any time.
1276. You can enable or disable macros with options in the ____ dialog box
1277. You can insert a ____ at the bottom of a table.
1278. You can split the worksheet window into ____ separate panes.
1279. You insert a comment in a worksheet by using a command on the ____ tab on the ribbon.
1280. Which of the following is not a date function? ____
1281. The underline format will underline ____
1282. Tables are organized into rows, called ____.
1283. The ____ aggregate function finds the largest value.
1284. The ____ criteria filter requires the records displayed to have the current date.
1285. The ____ dialog box provides options for moving charts between worksheets and chart sheets.
1286. The ____ function is useful when you want to assign a value to a cell based on a logical test.
1287. The _____ error value means that a value is not available to a function or formula.
1288. The ________ displays the current cell mode, the page number, and the zoom buttons.
1289. The ________ group on the design tab is useful for adjusting the data source of a chart.
1290. The ________, when outlined in black, indicates it is ready to accept data.
1291. The advanced filter tool can ________.
1292. The default number format is ________.
1293. The first step in creating an effective worksheet is to make sure you ____.
1294. The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.
1295. The following sequence, 2, 4, 6, etc., is an example of a ____ series.
1296. The format painter button is found in the ____ group on the home tab of the ribbon.
1297. The if function's logical test returns _____ result.
1298. The study of human interaction with machines in general is called ____.
1299. A ________ in a pie chart identifies the pie slices.
1300. Data catalogs _____.
1301. All of the following are valid excel arithmetic operators except ____
1302. Each slice in a pie chart represents a single value from a data series. ____________
1303. _____ refers to cells not wide enough to display the entire entry.
1304. Grouping is ________.
1305. The section breaks part of the breaks menu includes all of the following breaks except ____.
1306. To open the table styles gallery from the table styles group, click the ____ button.
1307. Using ________ telephone marketing, marketers sell directly to consumers.
1308. When you create a calculated column, you can use _____ references to create the formula.
1309. Which of the following is not a comparison operator? ____
1310. A ________ displays and summarizes totals from other worksheets.
1311. Excel remembers the last ____ actions you have completed
1312. Excel's __________ can be used to construct a crosstabulation.
1313. The characters +, -, *, and / are examples of ____.
1314. The header and footer sections include a _____.
1315. The numbers, text, or cell references used by the function to return a value are called ____.
1316. The range of cells receiving the content of copied cells is called the ____.
1317. In the following formula: =if(a1=""yes"", ""done"", ""restart""), what happens if a1= no? _____
1318. A ____ total sums all of the data in a row or column.
1319. Functions can be selected by using the ________.
1320. A ________can retrieve data from multiple fields in different tables in the data model
1321. You can ____ a table field if the information stored in a field becomes unnecessary.
1322. One way to structure text files is to use a(n) _______.
1323. The general format of a 3-d cell reference is ____.
1324. A _______ is the cell containing the formula or value the selected cell refers to.
1325. A table name cannot include ____.
1326. ____ arguments may provide more control over the returned value.
1327. The ____ criteria filter requires the records displayed to have the specified text string anywhere.
1328. When you nest functions, you should have ____.
1329. Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________
1330. If is an example of a ________ function
1331. Values are evaluated using ________ operators.
1332. ###### in a cell means that the ____
1333. A(n) ____ is a built-in formula that uses arguments to calculate information
1334. A(n) ____ is a group of cells in a rectangular block
1335. A(n) ____________________ conveys a visual representation of data.
1336. All of the following are vertical alignment options except ____
1337. By default, the pivottable report uses the ____ function for numbers in the values area.
1338. Cells and ranges in a worksheet can be formatted ____.
1339. In the formula =int(average(a1:a100)), which would occur first? ____
1340. Spreadsheets are particularly useful for ____.
1341. The ____ of a cell determines how the labels and values look.
1342. The ________ function returns one value if a condition is met, and a different value if it is not.
1343. The countif function is sometimes referred to as a(n) _____ count.
1344. The general form of the vlookup function is ____
1345. The major difference between hlookup and vlookup functions is the way the lookup tables are _____.
1346. The oracle string concatenation function is _____.
1347. To hide a selected column, click the _____ button in the cells group on the home tab.
1348. When using vlookup, the _____argument is optional.
1349. Which of the following is a math & trig function? ____
1350. Which of the following is a statistical function? _____
1351. ____ is extremely useful for making large tables more manageable in size and appearance.
1352. In producing a newsletter, you should develop ____ with as few words as possible.
1353. You relate tables to one another by using _______ fields.
1354. The default format for cells that meet a condition with conditional formatting is ____.
1355. A pie chart ____.
1356. A _____ indicates a manual page break.
1357. The ____ option helps fit the data on a single page without making changes to individual margins.
1358. When you don’t want to associate a font with a particular design, you use a _____ font.
1359. When you want to reference an entire column of data in a table, you create a column _____.
1360. You reference columns individually using the ____ element.
1361. If you deselect an item from the filter menu, it is called the filter ____.
1362. The range of cells receiving copied content is called the ____ area
1363. You can use predesigned, formatted files called ____ to create new worksheets quickly.
1364. The formula used to multiply cell a1 by cell c1 is ____.
1365. To go to column a of the current row press ____
1366. When you copy a formula that contains an absolute reference to a new location, the reference ____.
1367. To create a summary sheet requires navigation of ____________.
1368. The ____ feature is especially useful when working with very large worksheets.
1369. To copy cell contents, you can select the cell and then press the ____ keys.
1370. To move the insertion point to the next cell to the right in a table, you can ____.
1371. You can use the ____ key(s) on the keyboard to navigate a worksheet.
1372. In excel, max and average are examples of ____.
1373. ____provide descriptive text for the individual data markers, such as pie slices
1374. The columns and pie slices in the charts above are ____.
1375. You should ____ a function name in the formula autocomplete list to select the function.
1376. In the formula =if(a1=b1, c1, c2), the result will be c2 if ____.
1377. Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.
1378. A constant is a value in a formula that doesn’t change. _______________
1379. ____ is the amount added to the prinicpal of a loan by the lender.
1380. _____ are an example of conditional formats in excel.
1381. _____ is a single cell that occupies more than one cell row and/or column.
1382. _____ messages appear as screentips next to the active cell.
1383. A ____ file contains data fields separated by a selected character.
1384. A ____ in excel is like a notebook.
1385. A ____ is an interactive view of worksheet data.
1386. A ____ is text and graphics that print at the bottom of every page.
1387. A ____ is used to display only certain records within a table that meet the specified criteria.
1388. A _____ is a rectangular-shape block of cells in an excel worksheet.
1389. A chart that is inserted directly in the current worksheet is called a(n) ____ chart.
1390. A combination chart can add a(n) ____ axis to chart related data.
1391. A field ____ uniquely identifies each column in a data source.
1392. A lookup table organizes numbers or text into categories. _____________
1393. A macro name can be up to ____ characters long.
1394. A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
1395. A range of cells can be converted into an excel ________ so that the data can be analyzed.
1396. A scatter chart ____.
1397. A theme can be applied using the themes button in the themes group on the ____ tab on the ribbon.
1398. A worksheet ____ is a collection of two or more selected worksheets
1399. A worksheet is made up of _____ organized in a grid of rows and columns.
1400. A(n) ____ contains little or no formatting.
1401. A(n) ____ identifies each data series in a chart, generally with a different color.
1402. A(n) ____ reference is a formula that depends on its own value.
1403. A(n) _____ chart is drawn on the same worksheet as the data.
1404. A(n) _______ is a file that stores a collection of related data.
1405. A(n) ________ is a worksheet where totals from other worksheets are summarized and displayed.
1406. A(n) ________ refers to a cell by its fixed position in the worksheet.
1407. All functions begin with the formula prefix ____.
1408. All of the following are options in the delete menu except ____.
1409. An __________ is an object in a worksheet.
1410. An absolute cell reference _____ change when copied to another cell.
1411. An adjacent range is a collection of separate ranges. _________________________
1412. An example of a(n) ____ chart is a column chart with a line chart.
1413. An excel ____ allows data to be summarized and charted easily.
1414. Apa-style papers use ________ as the title of the list of sources.
1415. Arrow a is indicating a(n) _____ protein.
1416. As a general rule, you should _____.
1417. Because a chart is _______, it can be dragged to another area of the worksheet.
1418. Cell ____ are predesigned combinations of formats
1419. Cell references in a formula are called ____.
1420. Cell references that reference other sheets behind the summary sheet are known as ____ references.
1421. Cells of the second line of defense called ________ recognize and kill virus-infected cells.
1422. Combining two or more selected cells into one cell is called ____ cells
1423. Data in date/time fields are automatically ____-aligned.
1424. Dates in excel are stored as a serial number starting with ____ as 1 and increasing sequentially.
1425. By default, excel aligns date entries at the ____ of the column.
1426. By including worksheets in a ________, you can enter or edit data on them simultaneously.
1427. Double-clicking the column line to the right of a column activates the ____ feature for the column.
1428. Referring to the figure above, the rectangular area to the right of the pie chart is the ____.
1429. A cell containing a formula that references other cells is said to have ____.
1430. Circular errors are caused by adding the cell name of a/an _______ cell to a formula
1431. The ____ error code indicates that a cell reference in a formula is not valid.
1432. The entry in cell b15 is =sum(b5:b14) which is a ____.
1433. The median function finds ________.
1434. To organize large amounts of information, it is best to use ____.
1435. To prevent round-off errors, use the ____ function.
1436. When you enter a two-digit year that is less than 30, excel changes the year to ____.
1437. PMT (rate, nper, pv, [fv=0], [type=0]
1438. An answer report shows original and final values of the target cell and changing cells plus ____.
1439. 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?
1440. Which two functions check for the presence of numerical or nonnumerical characters in cells?
1441. If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?
1442. When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?
1443. You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?
1444. What is the best way to activate the Excel Help system?
1445. Which format will display the value 27,500,000 as 27.5?
1446. When using Goal Seek, you can find a target result by varying _ at most.
1447. A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?
1448. Which formula is NOT equivalent to all of the others?
1449. Which custom format will make the cells in column A appear like the corresponding cells in column B?
1450. Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?
1451. 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?
1452. Of the four chart types listed, which works best for summarizing time-based data?
1453. To ensure shapes and other objects are an equal left-to-right distance apart, select the shapes, click Page Layout > Align, and then click _.
1454. An organization chart, which shows the hierarchy within a company or organization, is available as _ that is included with Excel.
1455. 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?
1456. To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?
1457. Which function returns the largest value amongst all values within the range H2:H30?
1458. Which chart type can display two different data series as a different series type within the same chart?
1459. Which formula returns the value in cell A1 of the worksheet named MySheet?
1460. Which formula correctly counts the number of numeric values in both B4:E4 and G4:I4?
1461. After activating a chart, which sequence adds a trendline to the chart?
1462. Which Excel add-in will help you find a target result by varying multiple inputs to a formula?
1463. What tool would you use to prevent the input in a cell of a date outside a specific range?
1464. When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _.
1465. Which format setting does not change the background appearance of a cell?
1466. In Excel, what do most formulas begin with?
1467. 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?
1468. To discover how many cells in a range contain values that meet a single criterion, use the _ function.
1469. Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?
1470. For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?
1471. 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?
1472. What does this formula do? =Sum(Sheet1:Sheet4!D18)
1473. What is the term for an expression that is entered into a worksheet cell and begins with an equal sign?
1474. How does the appearance of an array formula differ from that of a standard formula?
1475. 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?
1476. Which formula returns the value in cell A10 of the worksheet named Budget Variances?
1477. Which function returns the leftmost five characters in cell A1?
1478. Which function returns TRUE if cell A1 contains a text value?
1479. You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?
1480. The NOW() function returns the current date and time as 43740.665218. Which part of this value indicates the time?
1481. 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?
1482. In the formula =VLOOKUP(A1,D1:H30,3,FALSE), the lookup value (A1) is being looked for in _.
1483. An .xlsx workbook is saved into .csv format. What is preserved in the new .csv file?
1484. What is Colors[Inventory] referring to here? =SUMIFS(Colors[Inventory],Colors[Colors],"Orange")
1485. Which formula calculates the total value of a single row of cells across a range of columns?
1486. Which function returns the number of characters in a text string in cell A1?
1487. From which field list was the pivotTalble created?
1488. 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)
1489. What is the difference between pressing the delete key and using the clear command in the Home tab's Editing group?
1490. What is the intersection of a worksheet row and column?
1491. How can you drill down into a PivotTable to show details?
1492. How can you use Format Painter to apply the format of a single source cell to several nonadjacent destination cells?
1493. Which is a valid Excel formula?
1494. Columns D, E, and F are hidden in your worksheet. What is one way to unhide these columns?
1495. 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?
1496. How do you remove the background of an inserted image?
1497. What is the result of the formula =4&3?
1498. How do you remove everything (values, formatting, etc.) from a cell?
1499. What is the difference between a workbook and a worksheet?
1500. Which formula contains a valid absolute reference?
1501. Cell A1 contains the number 3. Which formula returns the text Apple?
1502. How would you search an entire workbook with Find & Select?
1503. To split text across cells without using Merge & Center, click Formt Cells. The, on ** Alignment** tab, click**_**.
1504. 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?
1505. Which chart type provides the best visual display of the relationship between two numeric variables?
1506. 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 _.
1507. A file extension of .xlsm indicates what type of workbook?
1508. How do you remove only the conditional formatting from a cell and leave all other formatting intact?
1509. If a range name is used in a formula and the name is deleted, what happens to the formula?
1510. You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?
1511. You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?
1512. What is one way to center text in a cell?
1513. Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can yu=ou accomplish this?
1514. To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.
1515. 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?
1516. A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?
1517. 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?
1518. By default, numbers appear in the _____ and generally display values exactly as you type them.
1519. Like other block-level elements, you can ____ tables using the same styles you've already studied.
1520. Pseudocode uses the end-structure statement ____ to clearly show where the structure ends.
1521. When you use a range check, you compare a variable to the _____ value in the range.
1522. ____ are named combinations of values that are assigned to variables in a model.
1523. The date you change a file is an example of a(n) ____ property.
1524. Viewing and printing options for forms and records are available on the ____ tab.
1525. When a cell contains a(n) ____ reference, it means that one of its defining values is itself.
1526. When a cell is part of an active formula, it is surrounded with ________.
1527. When excel opens, a new blank ________ is displayed.
1528. When formatting a worksheet to be printed, ________ show where page breaks are located.
1529. When working with a large worksheet, you can split the window into ____ panes.
1530. When you _______ data, you specify which records you want to retrieve using specific criteria.
1531. When you type text in a cell it is ________.
1532. You can add a text box using the chart tools ____ tab.
1533. You can click the ____ button to undo an automatic correction.
1534. You can customize a format code in a cell entry to specify how ____ are displayed in a cell.
1535. You can display the ____ tab to specify page setup options.
1536. You can replace a formula with its function so it remains constant.__________
1537. You can switch to page layout view by clicking the page layout button ____.
1538. You can use ____ to move around in a document that is too large to fit on the screen at once.
1539. You can use _____ to reference cells within an excel table.
1540. You should hold down the ____ key to select the nonadjacent cells.
1541. You would ________ a table if you wanted to display only data that matches specific criteria.
1542. Names are ____ to the workbook
1543. Normal view shows how the worksheet will appear when printed. _________________________
1544. Only images that are ____ are free for anyone to use without permission.
1545. Placing a chart in a ____ dlls.
1546. Print all, pages, and selected record(s) are options available from the ____ for printing forms.
1547. Select _______ to apply formatting to several cells at the same time.
1548. The ____ aggregate function finds the smallest value.
1549. The ____ button allows you to erase recent cell entries.
1550. The ____ button allows you to move through a formula step by step.
1551. The ____ identifies which data markers are associated with each data series.
1552. The ____ is the typeface used to display and print data. it is measured in
1553. The _____ sheet button allows you to add worksheets to a workbook.
1554. The accounting number format assigns a floating dollar sign. _________________________
1555. The amount of money being loaned is known as the ____.
1556. The best way to apply page setup options to multiple worksheets is to ________.
1557. The clear all option in the clear button removes the ____ from the active cell.
1558. The code _____ will display the filename of the current workbook.
1559. The conditional formatting button provides access to the _____.
1560. The default border color around a chart title is ____.
1561. The default view for a worksheet is ____.
1562. The fields you use to order your data are called sort ____.
1563. The find & select button is found in the editing group on the ____ tab on the ribbon.
1564. The formula bar displays the value or formula of the active cell. _________________________
1565. The insert function dialog box has a(n) ____ option
1566. The report layout tools tabs are ____ tabs available only when working with report objects.
1567. The worksheet is organized into individual cells. _________________________
1568. To add a blank table to a page, use the table button on the ____ tab.
1569. To add a sort field in the sort dialog box, click the ____ button.
1570. To center worksheet data horizontally and vertically on a page, use the ________ dialog box.
1571. To create range names for multiple cells at once, use the ________ tool.
1572. To keep a workbook displayed in the recent files list in backstage view, you click the ________.
1573. To perform a what-if analysis with more than two input cells, you _______.
1574. To resize an embedded chart, ____.
1575. To rotate text in a worksheet, in the format cells dialog box, you can click and drag the ________.
1576. To select nonadjacent changing cells, press and hold the _______ key as you click each cell.
1577. To split a merged cell, select the cell and click the ____ button.
1578. To switch to ____ mode, you double-click the cell.
1579. Today is an example of a(n) ____________________ function.
1580. ________ software is used to perform calculations and numerical analyses.
1581. A ____ is an individual media file, such as art, sound, animation, or a movie.
1582. Autofill will fill a series when you establish a pattern ________.
1583. Before applying a conditional format in a report, the ____ box must be selected.
1584. Cooler colors tend to pull away from the reader. _________________________
1585. Excel assigns the name ____ to the first excel table created in a workbook.
1586. Excel recognizes an entry as a value if it is a number or it begins with ____.
1587. Functions can be entered for formulas using all of the following methods except ____.
1588. In a pie chart, slices that are pulled away are said to be ____.
1589. In a worksheet the ____ is called the formula prefix
1590. The less precise way to move objects in report layout view is to ____.
1591. To quickly jump to the last cell in a worksheet press ____.
1592. A report formatted where the page is taller than it is wide is formatted in ____.
1593. A form created from two tables that have a ____ relationship creates a main form and a subform.
1594. The ____ button gives options for how to fill cells following a fill operation.
1595. In the accompanying figure, the split double arrow mouse pointer ____.
1596. When using a spreadsheet, the expression =d8-d17 is called a ________.
1597. In goal seek, the ________ box contains the formula that calculates the information you seek.
1598. Point mode allows you to ____, as shown in the accompanying figure.
1599. Elements in a smartart graphic are grouped in ____.
1600. Excel displays various ________ on the right to enable you to format different chart elements
1601. Excel measures row height in _____ and column width in _____.
1602. Excel organizes fonts into theme and non-theme fonts. _________________________
1603. Excel's ________ function retrieves the date and time from the computer's calendar and clock.
1604. Formulas created using the point-and-click method contain ____ references.
1605. Each copy of a workbook to be merged must have a different ____.
1606. Each time you create a conditional format, you are defining a conditional formatting _____.
1607. In ____ orientation, a page is taller than it is wide.
1608. Use ____ references when you want different formulas to refer to the same cell
1609. Using ________ allows a cell to change appearance based on criteria.
1610. Validation rules are entered in the ____
1611. Whenever a window contains information that is not in view, a(n) ________ will display.
1612. You can import data stored on a web site using a(n) ____.
1613. You may use the ______________ settings as an easy way to align text in columns.
1614. A chart that compares three set of values in a three-dimensional chart is _____.
1615. In a(n) _______ trend, the values change by a constant amount.
1616. PMT(rate, nper, pv [, fv=0] [, type=0]) in the figure above, pv stands for the ____.
1617. On a pie chart, the ________ determines the size of each pie slice.
1618. Placing a chart in a ____ displays only the chart and no worksheet cells.
1619. The ____ option button lists formatting options following an insertion of cells, rows, or columns.
1620. In pie charts, its best to make the slice colors as similar as possible. ___________
1621. In a clustered column chart, the names of each column are part of the ____ series.
1622. A pie slice is a data marker that represents ____ from a data series
1623. ____ order arranges labels in reverse alphabetical order, from a to z
1624. ____ format codes allow you to specify how a cell entry assigned a format will appear.
1625. A cell is referred to by its cell ____.
1626. You can apply font styles and alignment options using the ____ tab of the ribbon.
1627. A data ____ table describes the fields you plan to maintain in a table
1628. Function(argument1, argument2, ...) is ____.
1629. In a line chart, the data markers are the points connected by the line. _________________________
1630. Using autofill, what would be the extended series of the initial entry jan? ___
1631. The path to the format painter button is ____.
1632. The first sort field in a sort is called the major sort field. ____________________
1633. The following sequence, jan, feb, mar, etc., is an example of a ____ series.
1634. To paste copied cell contents, you can press the ____ keys.
1635. When excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
1636. You can drill all of the following down through a workbook except ____.
1637. Each worksheet has a sheet name that appears on a(n) ____ at the bottom of the workbook.
1638. Pressing the ____ key to complete an entry activates the adjacent cell to the right.
1639. The opposite of merging cells is splitting a merged cell. _________________________
1640. To copy the contents of a cell to the cell directly below it, click the target cell and press ____.
1641. Headers, footers, and margins are all ____ options.
1642. Setting the _____ to a1:l10 will print only data in those cells.
1643. You should create good ____ to ensure your workbooks are free of errors.
1644. Charts can either be embedded in a worksheet or placed in a separate ____.
1645. To size a chart proportionately, hold down the ________ key and ________.
1646. Excel supports all of the following types of sparklines except ____.
1647. To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key
1648. To hide an entire workbook on an unattended computer, click the hide button on the ____.
1649. With the last quarter criteria filter, quarters are defined as, for example, ____.
1650. A(n) _______ is a limit that is placed on a solver problem's solution.
1651. The ____ function calculates the number of entries in a table.
1652. ____ makes it easier to enter repetitive text in cells.
1653. Excel's __________ can be used to construct a frequency distribution for categorical data.
1654. A(n) _______ is a limit that is placed on a solver problem's solution.
1655. Click the save button on the ____ to overwrite a previously saved file.
1656. Importing ____ provides greater flexibility to manipulate text in excel.
1657. A subtotal row must contain at least one ________ function.
1658. When creating a pivottable report, the active cell should be positioned ____.
1659. ____ a shape within a smartart graphic means moving it to a lower level.
1660. By default, excel keeps a change history of ____ days for a shared workbook.
1661. Excel treats ____ as graphic objects that can be moved, resized, and formatted.
1662. Excel's ____ function is used to perform a test of independence.
1663. When a mistake of fact occurs, ______ is absent.
1664. Goal seek uses a different approach from traditional _______ analysis.
1665. If either ____ or sharing is enabled, excel enables the other by default.
1666. The _____ alert accepts the invalid data but still allows you to cancel the data entry.
1667. Text annotations are ____ that you can add to further describe the data in your chart.
1668. The ____ caption indicates a worksheet group.
1669. Viewing a pivottable report only for a subset that meets a selection criterion is known as ____.
1670. Voice and unified communications are ________ applications that use 64-byte ip packets.
1671. The goal of a ______ is to convey the maximum amount of information within a very small space.
1672. The name peter is entered in cell b4. this is a ____.
1673. One of the benefits of live preview is that it _____.
1674. A(n) ____ is an entry in a cell that contains text such as 2016 sales or travel expenses.
1675. In pivottables, ____ fields correspond to columns in the original data.
1676. The summary function that calculates the smallest data value in a pivottable report is ____.
1677. Panes created using the vertical split bar scroll together horizontally. ________________________
