Search
Products meeting the search criteria
BIS 155 Week 1 | Quiz
Quiz 1 1. Question: (TCO 1) An Output Area (as it applies to Excel 2016) is defined as _____.2. Question: (TCO 1) In Excel 2016, a cell is best described by which of the following?3. Question: (TCO 1) Which of the following best describes the AutoComplete function?4. Question: (TCO 1) In Excel a formula _____.5. Question: (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a form..
$5.00
BIS 155 Week 2 | Quiz
Quiz 2: Excel's Advanced Formulas, Functions, and Charts 1. Question: (TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false.2. Question: (TCO 2) Which of the following steps can be used to insert a SUM function?3. Question: (TCO 2) The _____ function displays the current date in a cell.4. Question: (TCO 2) The PMT function is best described by which of the following?5. Question: (TCO 3) A data series is a gr..
$5.00
BIS 155 Week 3 | Quiz
Quiz 3: Data Analysis Functions 1. Question: (TCO 4) How many possibilities exist when thinking about the freeze options?2. Question: (TCO 4) In Excel, a table is defined as _____.3. Question: (TCO 4) To create a table from an existing range of data, _____.4. Question: (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.5. Question: (TCO 4) To apply a red background color to..
$5.00
BIS 155 Week 4 | Quiz
Quiz 4: Consolidating Data 1. Question: (TCO 5) Excel's multiple worksheet abilities can do all of the following except2. Question: (TCO 5) In Excel, which of the following would you perform to group nonadjacent worksheets?3. Question: (TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes.4. Question: (TCO 5) In Excel, which of the following is not a method for r..
$5.00
BIS 155 Week 5 | Quiz
Quiz 5: Excel's Advanced Functions and Statistical Functions 1. Question: (TCO 9) Which of the following is a nested function?2. Question: (TCO 9) If there are four possible outcomes, how many logical tests are required?3. Question: (TCO 9) When using the MATCH function looking for the largest value that is less than or equal to the match lookup_value, the match type must be set to _____.4. Question: (TCO 9) Which of the following functions will return the interest paym..
$5.00
BIS 155 Week 6 | Quiz
Quiz 6: What-If Analysis 1. Question (TCO 6) Which of the following tools is an add-in? 2. Question (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? 3. Question (TCO 6) In a data table, the _____ number format is used to disguise the formula references in thefirst row as labels. 4. Question (TCO 6) A series of ______ indicates that which of a column is too narrow to display the complete number 5. ..
$5.00
BIS 155 Week 7 | Quiz
Quiz 7: Importing and Macros 1. Question (TCO 8) Which of the following is a file type that cannot be imported into Excel? (Points : 2) 2. Question (TCO 8) Which of the following file types uses tabs to separate data into columns? (Points : 2) 3. Question (TCO 8) Where are web query tools and options located? (Points : 2) 4. Question (TCO 8) Which of the following are settings that control how imported data in cells connect to their source data..
$5.00