![]() In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Format Painter button. Use Format Painter to copy the formatting from cell D1 and apply it to cell E1. In the Design Ribbon Tab in the Header & Footer Elements Ribbon Group, you clicked the Page Number button. In the Margins menu, you selected the Narrow option.Īdd a footer that displays the page number in the center section. In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Margins button. In the Breaks menu, you clicked the Insert Page Break menu item.Īpply the preset margin option that will add the least amount of white space around the edges of the printed page. In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Breaks button. Inside the Page Setup dialog, you selected the Fit to: Radio Button, clicked the OK button.įrom Page Break Preview view, insert a page break immediately above the selected cell. In the Page Layout Ribbon Tab in the Scale To Fit Ribbon Group, you clicked the Scale To Fit Group Dialog Launcher dialog launcher. Inside the Format Cells dialog, you clicked the dialog Close button. In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Number group dialog launcher. Without adjusting the column widths, guarantee that all columns will print on one page. Inside the Function Arguments dialog, you clicked the OK button. ![]() Inside the Function Arguments dialog, you typed – in the Pv input. Inside the Function Arguments dialog, you typed B3/12 in the Rate input. In the Financial menu, you clicked the PMT menu item. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Financial button. Inside the Function Arguments dialog, you clicked the DialogHeader view, clicked the dialog undefined button, and clicked the dialog Close button. Use a negative value for the Pv argument. Using cell references, enter a formula in cell B6 to calculate monthly payments for the loan described in this worksheet. Inside the Function Arguments dialog, you typed a3 in the Lookup_value input, typed abbreviation in the Table_array input, typed 2 in the Col_index_num input, typed false in the Range_lookup input, and clicked the OK button. Inside the Insert Function dialog, you typed vlookup in the Search for a function input, pressed the Enter key, and clicked the OK button. In the Lookup & Reference menu, you clicked the Insert Function… menu item. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Lookup & Reference button. The item names are located in column 2 of the lookup table. Use the name Abbreviation for the lookup table. ![]() ![]() ![]() Inside the Function Arguments dialog, you typed category in the Range input, typed office expense in the Criteria input, typed cost in the Sum_range input, and clicked the OK button.Įnter a formula in cell B3 using the VLOOKUP function to find the meaning for the medical abbreviation listed in cell A3. Inside the Insert Function dialog, you typed sumif in the Search for a function input, pressed the Enter key, and clicked the OK button. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the AutoSum button arrow, clicked the Lookup & Reference button. Use the range name Category for the Range argument, the text string "Office Expense" for the Criteria argument, and Cost for the Sum_range argument. You clicked cell A1, double-clicked in cell A1, double-clicked in cell A1, clicked cell A1, clicked the A1 Cell Input, typed in cell A1, clicked cell A1, double-clicked in cell A1, double-clicked in cell A1, typed in cell A1, clicked the formula bar, typed "" in the formula bar, clicked the formula bar, typed "=now()" in the formula bar, and pressed Enter.Įnter a formula in the selected cell using SUMIF to calculate the total expenses for the category Office Expense. Insert the current date and time in cell A1. Select the Slicer Style Light 5 slicer style. Set the slicer to Slicer Style Light 5.Ĭlick the Insert Slicer button. Add a slicer based on the Location column. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |