BUS 375 Final Exam

Document Content and Description Below

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]

Last updated: 1 year ago

Preview 1 out of 10 pages