MISC 211 Final Exam 2024 With Complete Solutions

Use AutoSum to enter a formula in the selected cell to calculate the sum. - On the Home tab, In editing group, click the AutoSum button. Press Enter. Cut cell B7 and paste it to cell E12 - On the Home tab, in the clipboard group on the Home tab, click the cut button. Click cell E12, and click the paste button. Enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6 - Type the formulas =SUM(B2:B6) in the cell or the formula bar and press Enter. Change the font color of the selected cells to the Blue-Gray, Text 2 color. - On the Home tab, in the Font group, click the Font Color arrow, and select Blue_Gray Text 2 Set the print area so only the selected cells will print. - Click the Back button. On the page Layout tab, in the Page Setup group, click the Print Area button. Click Set Print Area. Add a new worksheet to the left of the Dec. 18 sheet - On the Home tab, in Cells group, click the Insert button arrow, and select Insert Sheet. Set row 1 to print on every page - On the Page Layout tab, in the Page Setup group, click the Print Titles button. In the Page Setup dialog, on the Sheet tab, click the Rows to repeat at the top box. Click the row selector for row 1. click OK in the dialog. Without adjusting the column widths, guarantee that all columns will print on one page. - On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page. Use Format Painter to copy the formatting from cell D1 and apply it to cell E1 - On the Home tab, in the Clipboard group, click the Format Painter button, Click cell E1. Print this worksheet. - Click the File tab to open Backstage view. Click Print. Click the Print button. Wrap the text in the selected cell - On the Home tab, in the alignment group, click the Wrap Text button. Apply the Top and Bottom Border to the selected cells with a single command. - On the Home tab, in Font group, click the Boarders button arrow, and select Top and Bottom Border. Delete the Timesheets worksheet - On the Home tab, in the Cells group, click the Delete button arrow, select Delete Sheet. Click Delete. Change font size for the selected cells to 18. - On the Home tab, in the Font group, click the Font Size arrow, and select 18. Autofit column D to best fit the data - Double-click the right column boundary for column D. Change the font for the selected cell to Cambria - On the Home tab, in the Font group, click the Font arrow, and select Cambria.