![]() How can you quickly add a border around a set of cells covering 3 rows and 12 columns? Use Draw Border under Border on the ribbon under Home. What is the fastest way to accomplish this? Highlight the entire worksheet then double-click the boundary between any two columns. You want to change the columns in the worksheet shown below to the best fit for the data. What does this mean? The content in the cell is wider than the cell width. How would you do this so you can extend the calculation across your other products? by typing =d5-d6 One of the number cells in your worksheet shows as #. ![]() You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. What will be the result? The formula =SUM(E2:E3) will be added to the cell to add the total sales and costs. (The XLOOKUP formula will search for the ID in I2 in column B and will return the name in column A) In the worksheet shown below, you click in cell E4 and then click Autosum. Using the data in columns A and B, what formula is needed in cell J2? =XLOOKUP((I2,B:B,A:A) What formula in cell B4 will calculate the profit in January? =B2-B3 In the worksheet shown below, you want to use the XLOOKUP function to find the employee whose number appears in cell I2. You are working in the worksheet shown below. What will happen in cell C4 if you use the fill handle to drag cell B4 to C4? (Formula in cell B4 is =B2-B3) The formula =C2-C3 will appear in cell C4. Which action will Excel take with this? Excel will display it as, but it will be left-justified and just a set of numbers and dashes, not an actual date. As you are entering sales data into a new worksheet, you inadvertently type. ![]() How can you quickly enter all 12 months in columns? Type in "January," point to the lower right-hand corner of the cell, hold down the left mouse button, and drag across the next 11 rows. Which action CANNOT be reversed using the Undo command? deleting a tab in the workbook You are entering Sales data for each month in 2018. Why do you see this screen? This is a new file that has not previously been saved. The image below shows what appears on your screen. You click the Save icon at the top of an Excel workbook. ![]()
0 Comments
Leave a Reply. |