Module 4: Assignment 1 - Excel Formatting

Excel Module 3 QuestionsLabel each element of the excel worksheet window shown in figure 3-27Format painterFind & selectComma styleAccounting number formatMerge and centerIncrease indentCenter textMatch each command or button with the statement that best describe itSpelling button – a. checks for apparent misspellings in a worksheet$ - b. Adds a dollar sign and a 2 decimal places to selected data[] - c. Display fill color options for a cell[Ctrl][Home] - d. Moves cell pointer to cell A1; - e. Centers cell contents across multiple cells Conditional formatting –f. changes formatting of a cell that meets a certain rule?Which of the following is an example of an accounting number format? d. $5,555.55What is the name of the feature used to resize a column to accommodate its widest entry?b. Autofit Which button copies multiple formats from selected cells to other cells?d. Format PainterWhich button increases the number of decimal places in a selected cells?a Increase decimals Which button removes italic font style from selected cells?a . ItalicWhat feature is used to delete a conditional formatting rule?b. Conditional formatting