Question;week 1 quizO 1) An Output Area (as it applies to Excel 2010) is defined as_______.a range of cells containing results based upon manipulation of the variables in the input areadisplays the name of a worksheet within a workbooka range of cells containing values for variables used in formulasdisplays the content of the active cellQuestion 2. Question:(TCO 1) Which of the following best describes a cell address?Identifies the electronic "neighborhood" of a spreadsheetIdentifies a cell by a column letter and a row numberSearches for and displays similar labels as you typeIs a number that represents a quantity and can be the basis of calculationsQuestion 3. Question:(TCO 1) Which of the following best describes the AutoComplete function?Adds all the numbers in the row automaticallySearches for and displays any other similar label in the current column as you begin to typeAdds all the numbers in the columns automaticallyIs a number that represents a quantity and can be the basis of calculationsQuestion 4. Question:(TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?Includes letters, numbers, and spacesControls the sequence in which Excel performs arithmetic operationsIs a software application used to create and modify business communicationsIncludes formulas, functions, and formattingQuestion 5. Question:(TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?Cannot complete a sequence of dates in a columnChanges the background color of the selected cells to yellowCopies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formulaHas two or more sub-commands related to the command: 2 of 2Comments:Question 6. Question:(TCO 1) Ribbon Commands with arrows indicate_____.a shortcut to cell A1there are two or more sub-commands related to the commandthe next step in the processdirectionalityQuestion 7. Question:(TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a:workbook.ledger.document.journal.:Question 8. Question:(TCO 1) When you paste copied data, Excel displays the Paste Options button:in the status bar at the left of the screen.in the next set of nonadjacent ranges.on the toolbar.in the bottom right corner of the pasted data.Question 9. Question:(TCO 3) Groups of related numeric values in an Excel worksheet are:data point.data roles.categories.data seriesQuestion 10. Question:(TCO 3) Which of the following best describes a column chart?Displays data comparisons vertically in columnsA horizontal line that borders the plot area to provide a frame of reference for measurementContains graphical representation of values in data seriesContains the entire chart and all of its elementsQuestion 11. Question:(TCO 3) Which of the following best describes the chart area?Contains graphical representation of values in data seriesContains the entire chart and all of its elementsA vertical line that borders the plot area to provide a frame of reference for measurementA horizontal line that borders the plot area to provide a frame of reference for measurementQuestion 12. Question:(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:stacked column chart.pie chart.3-D column chart.box diagram.Question 13. Question:(TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart.expandedexplodeddisplacedclusteredQuestion 14. Question:(TCO 3) In Excel, an area chart _______.shows the high, low, and close prices for individual stocks over timetrends using two dimensions on a continuous curveemphasizes the magnitude of changes over time by filling in the space between lines with a colorshows a relationship between two variablesQuestion 15. Question:(TCO 3) After creating a chart, you can change the chart type by using _____.Page Layout tab / Chart Options buttonDesign tab / Change Chart Type buttonData tab / Chart Changer toolYou cannot change the chart.week 2 quizTCO 2) In Excel, a relative cell reference:indicates a cell's specific location and the reference does not change when you copy the formula.contains both an absolute and a relative cell reference.indicates a cell's relative location from the cell containing the formula, the reference changes when you copy the formula.occurs when a formula directly or indirectly refers to the cell containing the formula.:Question 2. Question:(TCO 2) In Excel, a function can be defined as a _____.predefined formula that performs a calculationcell reference or a valuelist of values and defined names as you enter data into a spreadsheetset of rules that govern the structure and components for a formulaQuestion 3. Question:(TCO 2) The rules for constructing a function can be referred to as the function's _____.synthesissynergysynchronizationsyntaxQuestion 4. Question:(TCO 2) Which of the following describes the SUM function?Identifies the midpoint value in a set of values.Calculates the total of values contained in two or more cells.Calculates the arithmetic mean or average of values in a range.Displays the lowest value in a range.Question 5. Question:(TCO 2) The _____ function returns a result based on a condition.Student Answer: MAXTODAYFINDIFQuestion 6. Question:(TCO 2) Which of the following best describes the COUNT function?Tallies the number of cells in a range that are not empty.Tallies the number of blank cells in a range.Displays the current date.Tallies the number of cells in a range that contain values.Question 7. Question:(TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____.logical testlookup valuebreakpointtable array actionQuestion 8. Question:(TCO 2) If you enter an = and the first few letters of a function in the formula bar, Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.Syntax HelperFormula AutoCompleteFormula Wizard:Question 9. Question:(TCO 2) Which of the following best describes the HLOOKUP function?The periodic interest rate, such as a monthly interest rate.Calculates the periodic payment for a loan with a fixed interest rate and fixed term.Looks up a value in a lookup table where the first column contains the values to compare with the lookup value.Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value.Question 10. Question:(TCO 2) One benefit of using range names in formulas is that _____.it directly or indirectly refers to the cell containing the formulait contains both an absolute and a relative cell referenceit identifies the present value of the loanif you copy the formula, you do not have to make the cell reference absoluteQuestion 11. Question:(TCO 2) The PMT function is best described by which of the following?It is the periodic interest rate, such as a monthly interest rate.It is the total number of payment periods.It is the present value of a loan.It calculates the periodic payment for a loan with a fixed interest rate and a fixed term.:Question 12. Question:(TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks?MacrosTemplatesThemesINCORRECT BackgroundQuestion 13. Question:(TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit.formathidelockunlock:Question 14. Question:(TCO 7) Which of the following file formats can store macros?xlsmcsvxmlxlsxQuestion 15. Question:(TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.ViewDataInsertDeveloperweek 3 quizTCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet.FormattingFreezingResizingTilingQuestion 2. Question:(TCO 4) Which of the following best describes a page break?Freezes only the top rowThe sequence in which pages printIndicates where data starts on a new printed pageStops the printer from printingQuestion 3. Question:(TCO 4) To create a table from an existing range of data, _____.click within the range, click the Table Tools Design tab, and then select Convert to Tableselect any cell in the worksheet and then click Existing Range in the Tools groupclick in a cell and on the Home tab, and click the Insert arrow in the Cells groupclick the Insert tab and then click Table in the Tables groupQuestion 4. Question:(TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.a Date Filtera Text Filterthe use of a table element as a formulaa Number FilterQuestion 5. Question:(TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.a PivotTablea multiple level sortconditional formattinga range nameQuestion 6. Question:(TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____.displays a particular color based on the relative value of the cell contents to other selected cellsdisplays an icon representing a value in the top third, quarter, or fifth based on values in the selected rangehelps locate where data may be missinghelps locate errors in cells quicklyQuestion 7. Question:(TCO 4) The Subtotal command is located on the _____ tab.dataformulapage layoutinsertQuestion 8. Question:(TCO 4) _____ are created to organize and summarize data in PivotTables.CategoriesTypesTitlesLevelsQuestion 9. Question:(TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?: Column LabelsReport FilterRow LabelsValuesQuestion 10. Question:(TCO 4) To create a calculated field, select _____ located on the PivotTable Tools Options tab.CalculationsInsert Calculated Field dialog launcherToolsPivotTable CalculationQuestion 11. Question:(TCO 4) A Pivot Table Style controls all the following EXCEPT _____.boldingfont colorsnumber formatshading colorsQuestion 12. Question:(TCO 4) A quick way to display the Go to dialog box is to press the _____ key(s).F4Ctrl+HomeCtrl+EndF5Question 13. Question:(TCO 4) The PivotChart Tools contextual tab includes all the following EXCEPT _____.designlayoutformattypeQuestion 14. Question:(TCO 4) Click the _____ to sort or filter the chart representation based on the values.Axis Field arrowsReport Filter arrowsValues arrowsLegend Field arrowsQuestion 15. Question:(TCO 4) Which of the following will NOT delete a PivotChart?Go to the Home tab and click CutRight-click the chart and click CutSelect the chart and then press DeleteClick and drag the PivotChart off the worksheetweek 4 quizTCO 8) Which of the following is one of the most common file types imported into Excel?TextPowerPointWebWordQuestion 2. Question:(TCO 8) Which of the following is NOT a text file?Tab-delimitedComma-separated valueXMLFixed-widthQuestion 3. Question:(TCO 8) Which of the following is NOT a method for refreshing data?Click the Refresh All command.Save the Excel workbook.Click the Refresh All arrow, then click Refresh.Right-click in a range of data and then select Refresh.Question 4. Question:(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.FixedMixedDividedTextQuestion 5. Question:(TCO 8) Which of the following is a frequently used function to manipulate txt?CONCATENATEPMTIFDATEQuestion 6. Question:(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.: CONCATENATEPROPERUPPERLOWERQuestion 7. Question:(TCO 8) Which of the following will produce the same result as the CONCATENATE function?=A4&B4=A4+B4=A4B4=A4,B4Question 8. Question:(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers' names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.Type New ListUse Existing ListImport from ExcelSelect from Outlook ContactsQuestion 9. Question:(TCO 8) The New Comment command is located on the ________ tab.ViewReviewDataFileQuestion 10. Question:(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.Split Names WizardPivotTable featureCONCATENATE functionConvert Text to Columns WizardQuestion 11. Question:(TCO 8) The command to track changes is located on the ________ tab.FileDataReviewViewQuestion 12. Question:(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.GmailHotmailYahooOutlookQuestion 13. Question:(TCO 8) Windows can search for files by author name or keywords that have been entered into ________.a file namethe Trust Centerdocument propertiescell A1Question 14. Question:(TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text.PROPERUPPERSUBSTITUTERESPONDQuestion 15. Question:(TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.Check for IssuesProtect WorkbookManage VersionsOptionsweek 5 quizTCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT:create Pivot Charts.group worksheets together to enter data.display worksheets side by side.create links among the worksheets.Question 2. Question:(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?Click the first tab, hold Shift, and then click the last tab.Click the first tab, hold Ctrl, and then click the last tab.Right-click a worksheet tab, then select Select All Sheets.Right-click a worksheet tab, then select Group.Question 3. Question:(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window.the letter Bthe number 2the letter Athe number 1Question 4. Question:(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening the ________ file.worksheetworkspaceworkviewworklinkQuestion 5. Question:(TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?"[New.Jersey.xlsx]Qtr4!"B6'[New.Jersey.xlsx]Qtr4!'B6[New.Jersey.xlsx]Qtr4!,B6[NewJersey.xlsx]Qtr4!B6Question 6. Question:(TCO 5) Before you can create an external reference you must first __________.select the cell or cells to hold the external reference.open the destination workbook and all source workbooks.switch to the source workbooks and click the cells.click on Insert Function on the Formulas tab.:Question 7. Question:(TCO 5) Which of the following is the proper use of a 3D formula?=SUM(Yr1:Yr5!C7)=SUM(Yr1-Yr5!C7)=SUM('Yr1:Yr5'!C7)=SUM("Yr1:Yr5"!C7)Question 8. Question:(TCO 6) A one-variable data table must have at least ________ blank row(s) and ________ blank column(s) between the dataset and the data table.two, twotwo, oneone, twoone, oneQuestion 9. Question:(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?Scenario ManagerGoal SeekOne-variable data tableTwo-variable data tableQuestion 10. Question:(TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?Scenario ManagerSolverData TableGoal SeekQuestion 11. Question:(TCO 6) The Scenario Manager dialog box enables you to do all the following EXCEPT:format scenarios.add scenarios.delete scenarios.edit scenarios.Question 12. Question:(TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the:scenario names.formatting of the results.cells containing the formulas that generate the results.final result.Question 13. Question:(TCO 6) What happens when you add a new scenario and generate a new scenario summary report?The new report will be created on a new worksheet.The new scenario will be included into the old report.The new report will be added directly below the original report.The new report will replace the original report.Question 14. Question:(TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?AddFormatChangeDeleteQuestion 15. Question:(TCO 6) The initial results of a Goal Seek are:: automatically entered into the worksheet.inserted into a new worksheet.presented visually in a chart.shown in the Goal Seek Status dialog box.
Paper#36903 | Written in 18-Jul-2015Price : $52