Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click Done.Save As.csv.htmlWorksheet tabFormat CellsSUMFunctionDestination cellHome tabAutoFitAApplies a border or shading to selected cellsBWhere cut or copied data is pastedCSaves workbook with a different nameDThe extension for a web page workbookEA function that adds the values in a selected rangeFWhere the Clipboard group is foundGA common file format that can be opened by many applicationsHDisplays the name of the worksheet near the bottom leftIResizes column width or row height to accommodate the largest entryJA built-in formula

From the following list of choices, select the choice that BEST describes the purpose of using the Paste Special feature in Excel.*It allows you to paste special characters, such as the trademark symbol, into a worksheet.It allows you to copy cells and then paste only selected elements into a new locationIt allows you to copy data from a Microsoft Word table and paste it into Excel worksheet.

You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.1 pointYou can’t do this. You have to format each of the new cells individually.Cells must be formatted before data is entered into them.You can use the Format cells option after right-clicking a cell, to copy the formats from the old cells to the new cells.You must copy the cells over the new cells, then type the data back in.You can use the Format Painter to copy only the formats from the old cells to the new cells.

You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.1 pointYou must copy the cells over the new cells, then type the data back in.Cells must be formatted before data is entered into them.You can use the Format Painter to copy only the formats from the old cells to the new cells.You can use the Format cells option after right-clicking a cell, to copy the formats from the old cells to the new cells.You can’t do this. You have to format each of the new cells individually.

Create a table in HTML table of marksheet and enter marks

To copy highlighted data that has hidden rows and/or columns in it, press this keystroke shortcut to select Visible Cells Only.