infotech exam

1. Which of the following is the correct syntax when using the AND function within the IF function?. • IF(AND(B3<5 OR C1>7), "PASS", "FAIL"). • IF((B3<5 AND C1>7), "PASS", "FAIL"). • =AND(IF(B3<5,C1>7), "PASS," "FAIL"). • =IF(AND(B3<5,C1>7), "PASS", "FAIL").

Question 34: A 3-D reference has the following structure: • ="worksheet name!cell reference". • =worksheet name!cell reference. • ='worksheet name'!cell reference. • =worksheet name?cell reference.

3. Question 33: ________ worksheets allow users to enter data on multiple worksheets at one time. • Grouping. • Merging. • Linking. • Bridging.

4. Question 14: Gender and dates are two examples of PivotTable ________ variables. • category. • grouping. • summary. • aggregate.

5. Question 15: ________ allows a user to select an individual piece of data in a PivotTable and then create a copy of individual records that were used to get that summary data on another worksheet. • Data linking. • Content relating. • Drilling down. • PivotChart Data connection.

6. Question 25: Which of the following would NOT be a function to use as the first argument in the SUBTOTAL function?. • COUNT. • AVERAGE. • FIND. • SUM.

7. Question 24: A structured reference is beneficial when working with tables because it ________. • creates a visual toolbox that can be used to filter data. • automatically sets ranges within the table that will adjust as columns or rows are added or deleted. • automatically makes a backup of the data to preserve its integrity. • consolidates data using SUM and AVERAGE.

8. Question 6: Which of the following is NOT a common logical function?. • OR. • NOT. • COUNT. • IF.

9. Question 8: When the message "#NAME?" appears in cell, this tells the user that ________. • Excel requires another argument for the function to work. • you must type someone's name in the formula for the message to be corrected. • the columns are too narrow to display the text. • Excel does not recognize text in a formula.

10. Question 12: The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted. • COUNTIFS. • COUNTIF. • COUNT. • COUNTA.

11. Question 26: To save an existing workbook as a template, ________. • leave the workbook in its original form. • share the workbook. • create a change history log. • remove any specific data before saving.

12. Question 7: The symbols (<) and (>) are examples of logical operators. • True. • False.

13. Question 28: Press ________ to group contiguous worksheet tabs. • Home. • F4. • Shift. • Alt.

14. Question 3: The ________ function is a useful tool for detecting an error and displaying a more user friendly message. • ISMISTAKE. • IFMISTAKE. • IFERROR. • IS ERROR.

15. Question 5: In the VLOOKUP function below, which of the following statements is NOT true? =VLOOKUP(A6,Shifts,5,FALSE). • Shifts is the name assigned to the table array being used by the function. • The content of A6 is compared to the contents of first column of the table array. • The number in the third argument stands for how many columns exist in the table array. • The contents of the fourth argument requires an exact match with the first argument.

16. Question 2: If the VLOOKUP range_lookup argument has the ________ value entered, an exact match with the lookup_value argument is required. • NO. • YES. • TRUE. • FALSE.

17. Question 4: Data that is manually calculated is known as ________ data. • static. • generated. • dynamic. • retrieved.

18. Question 22: The SUBTOTAL function includes hidden records when making a calculation. • True. • False.

• Question 17: What part of the following formula is considered the structured reference? =GolfReport!$B$3*[@Food_Order]. • !$B$3*[@Food_Order]]. • [@[Food_Order]]. • $B$3. • =GolfReport!.

Question 9: What is the limitation of the VLOOKUP and HLOOKUP functions?. • They require a TRUE or FALSE argument. • They require a named range for the table array. • They must be used within an IF statement. • They can only "look" to the right or down to retrieve a value.

• Question 10: The OR function is used when any combination of logical tests has at least one TRUE outcome. • True. • False.

1.⁠ ⁠Which of the following is NOT a formula auditing tool?. A. Trace Precedents. B. Trace Dependents. C. Evaluate Relationships. D. Error Checking.

2. A(n) ________ appears when a user makes a validated cell active and prompts a user before data is entered. A. Error Alert. B. Input message. C. Validation Summary. D. Tooltip.

3. ________ is a type of data validation used to limit the number of characters that can be entered in a cell. A. Character Count. B. String Limit. C. Text length. D. Whole number.

4. ________ a workbook keeps users from being able to change parts or inadvertently delete formulas. A. Protecting. B. Encrypting. C. Formatting. D. Validating.

5. When you choose to trace dependents and trace precedents, Excel puts arrows on the workbook. True. False.

6. A dependent cell is a cell that supplies a value to the formula in the active cell. True. False.

7. If you make a mistake when recording a macro, you can delete the macro and record a new one. True. False.

8. What are the three steps involved in creating validation guidelines in a document?. A. Set a password, lock cells, and hide formulas. B. Create the rule, add input text, and provide an error alert. C. Identify data, sort data, and filter data. D. Trace precedents, trace dependents, and remove arrows.

9. A ________ Location is a folder that has been identified in the Microsoft Office Trust Center as a safe place to store files with macros. A. Secure. B. Verified. C. Trusted. D. Private.

10. A ________ reference is a single formula that references itself or multiple formulas that reference each other. A. Relative. B. Circular. C. Absolute. D. Dynamic.

11. ________ macro references affect exactly the same cell address every time the referencing macro is run. A. Absolute. B. Relative. C. Static. D. Constant.

12. The input message and Error Message for a data validation rule are required when creating the rule. True. False.

13. The inclusion of ________ in a workbook allows you to easily move from worksheet to worksheet or to external files. A. Shortcuts. B. PivotTables. C. Hyperlinks. D. Slicers.

14. An Excel ________ is a workbook that provides a starting point for building similar workbooks. A. Masterfile. B. Preset. C. Template. D. Theme.

15. In the following formula, what does 'TotalCharges3D' represent? =SUM(TotalCharges3D). A. A cell reference. B. A sheet name. C. A named range. D. A function name.

16. A template is a special file type that identifies multiple workbooks and remembers the manner in which they are arranged on the screen. True. False.

______ are interactive tables that extract, organize, and summarize data. VariableTables. ValueTables. DataTables. PivotTables.

Which of the following is NOT an area in the Fields areas within a PivotTable?. ROWS. LIST. FILTERS. COLUMNS.

Where can original templates be found?. for purchase on Amazon. in their own tab on the ribbon. online at Office.com and locally on your hard drive. saved in your Home directory.

When applying the Advanced Filter, the criteria entered on one row creates a(n) ____ function where records must meet all the specified criteria. NOT. OR. AND. ALL.

What type of worksheet is useful when you have different months' worth of data and you want to consolidate it into one report?. consolidated. summary. 3-D. linked.

As columns or rows are added to a table formatted with a banded style, the new columns and rows are automatically formatted to match the banded style. True. False.

When creating a PivotTable, fields from the PivotTable Field list entries can be dragged and dropped to each of the following quadrant areas EXCEPT: Column Labels. Values. Row Labels. Variables.

The IF function provides two outcomes, one when its logical test is true and one when its logical test is false. True. False.

When an Excel table is created all of the following events happen EXCEPT. a new tab appears on the ribbon for table formatting. Table sort and filter arrows appear. a new worksheet is automatically created for the new table. The Excel table appears with banded coloring.

Which of the following features of Excel is available when worksheets are grouped?. Sparklines. Charts. Functions. Shapes.

A _______ is a window that is used to quickly filter data in an Excel table. grouping variable. summary variable. slicer. structured reference.

Ungrouping worksheets is accomplished by clicking the [Group] tag on the title bar. True. False.

Which of the following CANNOT be performed on grouped worksheets sharing similar structures?. Entering formulas. Entering functions. Applying conditional formatting. Entering column and row headings.