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