- #MICROSOFT OFFICE 2011 FOR MAC EXCEL CHAPTER 2 LAB 3 PC#
- #MICROSOFT OFFICE 2011 FOR MAC EXCEL CHAPTER 2 LAB 3 SERIES#
- #MICROSOFT OFFICE 2011 FOR MAC EXCEL CHAPTER 2 LAB 3 WINDOWS#
What would happen if cells in the shifted rows were included in formulas? (EX 151) If the rows that shift down include cell references in formulas located in the worksheet, Excel automatically would adjust the cell references in the formulas to their new locations. Excel does not display the Insert Options button if the initial row does not contain any formatted data. The Insert Options buttonĢ remains active until you begin the next Excel operation. The Format Same as Above option is the default. Following the insertion of a row, the Insert Options button allows you to select from the following options: (1) Format Same As Above (2) Format Same As Below and (3) Clear Formatting. You can change this behavior by clicking the Insert Options button that appears immediately below the blank inserted row. What is the resulting format of the new row? (EX 151) The cells in the new row inherit the formats of the cells in the row above them. If you accidentally delete valuable data, immediately click the Undo button in the Standard toolbar. Any data contained in the destination area prior to the copy and paste is lost. What if data already existed in the destination area? (EX 147) When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the source area.
In the case of a single column range, such as A2:A6, the top cell of the destination area (cell A2) also is the upper-left cell of the destination area. Excel needs to know only the upper-left cell of the destination area. Why do I not need to select the entire destination area? (EX 146) You are not required to select the entire destination area (range A2:A6) before clicking the Paste button in the Standard toolbar. The Decrease Indent button decreases the indent by three spaces each time you click it. What happens when I click the Increase Indent button? (EX 145) The Increase Indent button on the Home tab under Alignment indents the contents of a cell to the right by three spaces each time you click it. Such behavior also occurs when typing the column heading in cell I10. Why is the word Total automatically formatted with a 45 rotation? (EX 143) Excel tries to save you time by automatically recognizing the adjacent cell format in cell G10 and applying it to cell H10. If this is the case, click the Auto Fill Options button after the range fills and then select the option you desire in the Auto Fill Options menu (Figure 3 8). With some fill operations, you may not want to copy the formats of the source cell or range to the destination cell or range.
#MICROSOFT OFFICE 2011 FOR MAC EXCEL CHAPTER 2 LAB 3 SERIES#
What if I do not want to copy the format of cell B10 during the auto fill operation? (EX 142) In addition to creating a series of values, dragging the fill handle instructs Excel to copy the format of cell B10 to the range C10:G10. You can choose Close in the File menu to close that workbook, and then choose New in the File menu to open a new workbook.
#MICROSOFT OFFICE 2011 FOR MAC EXCEL CHAPTER 2 LAB 3 PC#
zip expansion utility already, download WinZip® for your PC or Stuffit Expander® for your Mac.1 Microsoft Office 2011 for Mac: Introductory Q&As Excel Chapter 3 What if Excel automatically opens a workbook when I start Excel? (EX 139) If you had a workbook open when you last quit Excel, Excel will, by default, open that workbook when started.
You must decompress these files in order to access their contents.
#MICROSOFT OFFICE 2011 FOR MAC EXCEL CHAPTER 2 LAB 3 WINDOWS#
zip format and can be used on both Windows and MAC operating systems. The files posted have been compressed in. : Ĭlick on the links below to download the Student Data Files.
0 kommentar(er)
