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
[Show More]
