BUS 375 Final Exam

BUS 375 Final Exam By default, what file extension is given to Excel 2016 workbook files? - ✔✔.xlsx In Excel, which of the following keys opens the Save As dialog box? - ✔✔F12 Once you have saved a workbook for the fi ...

BUS 375 Final Exam By default, what file extension is given to Excel 2016 workbook files? - ✔✔.xlsx In Excel, which of the following keys opens the Save As dialog box? - ✔✔F12 Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you use to save it again? - ✔✔ctrl+S In the Excel window, which of the following continuously displays the buttons for switching worksheet views? - ✔✔Status Bar To select non-adjacent worksheets, which key must you press? - ✔✔Ctrl What must you do to enter a number as a label in a cell? - ✔✔Type an apostrophe before the number. Which of the following activates edit mode? - ✔✔either pressing F2 or double-clicking a cell Which of the following appears when you move your pointer over the center of a cell? - ✔✔selection pointer Which of the following characters precedes Excel functions? - ✔✔= Which of the following displays the result of a formula? - ✔✔cell Which of the following displays when you place your pointer on the border of an active cell or cells? - ✔✔move pointer Which of the following features resizes column width or row height to accommodate the width or height of the largest entry? - ✔✔AutoFit Which of the following is the name used to describe a rectangular group of cells? - ✔✔range Which of the following keyboard shortcuts cuts cells or a cell range? - ✔✔Ctrl+X Which of the following keyboard shortcuts opens the Format Cells dialog box? - ✔✔Ctrl+1 Which of the following views allows you to adjust page breaks? - ✔✔Page Break Preview Which of the following views lets you apply headers and footers and view the layout of the spreadsheet prior to distribution? - ✔✔Page Layout view True or False? Cell F6 is the intersection of row F and column 6 - ✔✔False True or False? Hiding a column or row does not delete the information in the worksheet nor does it affect the results of calculations. - ✔✔True True or False? In Excel, a worksheet is also referred to as a spreadsheet or a sheet, and you can use these terms interchangeably. - ✔✔True In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following terms describes what is going on with this formula? - ✔✔circular reference In the function =SUM(B2:B6), which part of the function is the argument? - ✔✔B2:B6 Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly? - ✔✔F4 Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula? - ✔✔Trace Precedents Which of the following contains one relative reference (either the row number or column letter) and one absolute reference (the remaining row number or column letter)? - ✔✔Mixed reference Which of the following cell addresses doesn't change when copied? - ✔✔$F$2 Which of the following functions tallies the number of cells in a range that contain numbers? - ✔✔COUNT Which of the following functions uses a lookup table that is organized in columns? - ✔✔VLOOKUP Which of the following is a color-coded editing tool that applies different colors to each cell or cell range within a formula? - ✔✔Range finder Which of the following is not a constant in the formula =45*B3-7? - ✔✔B3 Which of the following is true about the TODAY and NOW functions? - ✔✔Display the date and time that a workbook was last opened or last calculated. Which of the following references cells located in another worksheet in the same workbook? - ✔✔3D cell reference Which of the following statements is not True? - ✔✔It is best to name a range with a cell reference such as A7 True or False? An IF function can test if monthly revenue is above or below average and display "Yes" or "No" in the cell. - ✔✔True True or False? Arguments are the pieces of information within parentheses in functions that determine what value a function returns. - ✔✔True True or False? Column and row references do not change when you copy a relative cell address. - ✔✔False True or False? Excel treats any empty cell in an array as if it has a value of 1. - ✔✔False True or False? Formula auditing is the process of displaying suggestions for completing a formula. - ✔✔False True or False? To cancel a formula before it is complete, press Esc. - ✔✔True True or False? The answer to 4 + 2 * 6 is 36. - ✔✔False What can pie charts graph? - ✔✔a single data series What would you call the number values located on top of the bars in a column chart? - ✔✔data label Which of the following are miniature charts displayed in a cell or cell range with your data? - ✔✔sparklines Which of the following chart types displays the distribution of data with minimum, mean, maximum, and outlier values? - ✔✔Box & Whisker Which of the following charts displays relationships among numeric values in two or more data series? - ✔✔XY Which of the following encompasses all of the other items? - ✔✔Shape Style Which of the following is a horizontal or vertical boundary that identifies what is plotted? - ✔✔axis Which of the following is a rectangular area bounded by the horizontal and vertical axes? - ✔✔Plot area Which of the following is a requirement or condition that identifies which data is shown and which is hidden? - ✔✔Filter Which of the following is a single value or piece of data from a data series? - ✔✔Data point Which of the following is not True about filters? - ✔✔Filters alter the source data range Which of the following keys creates an automatic column chart sheet for selected data? - ✔✔F11 Which of the following might a manager use to forecast the next quarter's sales based on historical numbers? - ✔✔trendline Which of the following pie charts has a hollow center? - ✔✔doughnut chart Which of the following terms refers to the cells that contain values and labels to be graphed in the chart? - ✔✔source data True or False? There are two sparkline types: pie and area. - ✔✔False True or False? The Sunburst chart type displays a hierarchical view of data with concentric rings. - ✔✔True True or False? The Funnel chart type plots each element in a running total and displays negative and positive effects of each on the total. - ✔✔False True or False? Some chart types cannot be combined to create a combination chart. - ✔✔True True or False? If the cell range you want to use in a chart contains non-adjacent cells, hold down the Alt key to select each range. - ✔✔False How many rows must the criteria range of an Advanced Filter have? - ✔✔at least 2 In an Excel table, which of the following contains descriptive titles or labels? - ✔✔header row In an Excel table, which of the following represents a row of data? - ✔✔record What must you build to use an Advanced Filter? - ✔✔a criteria range What symbol precedes all structured referenc