MISC 211 Final Exam with Complete Verified Answers 2023 Update
3 views 0 purchase
Course
NU1426
Institution
NU1426
MISC 211 Final Exam with Complete & Verified Answers 2023 Update.
Use AutoSum to enter a formula in the selected cell to calculate the sum.
Cut cell B7 and paste it to cell E12
Enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6
Change the f...
MISC 211 Final Exam with Complete & Verified
Answers 2023 Update.
1). Use autosum to enter a formula in the selected cell to calculate the sum.
Ans: On the Home tab, In editing group, click the AutoSum button. Press Enter.
2). Cut cell b7 and paste it to cell e12
Ans: On the Home tab, in the clipboard group on the Home tab, click the cut button.
Click cell E12, and click the paste button.
3). Enter a formula in the selected cell using the sum function to calculate the total of cells b2
through b6
Ans: Type the formulas =SUM(B2:B6) in the cell or the formula bar and press Enter.
4). Change the font color of the selected cells to the blue-gray, text 2 color.
Ans: On the Home tab, in the Font group, click the Font Color arrow, and select
Blue_Gray Text 2
5). Set the print area so only the selected cells will print.
Ans: Click the Back button. On the page Layout tab, in the Page Setup group, click the
Print Area button. Click Set Print Area.
6). Add a new worksheet to the left of the dec. 18 sheet
Ans: On the Home tab, in Cells group, click the Insert button arrow, and select Insert
Sheet.
7). Set row 1 to print on every page
Ans: 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.
PaperStoc.com Page 1 of 42
, 8). Without adjusting the column widths, guarantee that all columns will print on one page.
Ans: On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page.
9). Use format painter to copy the formatting from cell d1 and apply it to cell e1
Ans: On the Home tab, in the Clipboard group, click the Format Painter button, Click
cell E1.
10). Print this worksheet.
Ans: Click the File tab to open Backstage view. Click Print. Click the Print button.
11). Wrap the text in the selected cell
Ans: On the Home tab, in the alignment group, click the Wrap Text button.
12). Apply the top and bottom border to the selected cells with a single command.
Ans: On the Home tab, in Font group, click the Boarders button arrow, and select Top
and Bottom Border.
13). Delete the timesheets worksheet
Ans: On the Home tab, in the Cells group, click the Delete button arrow, select Delete
Sheet. Click Delete.
14). Change font size for the selected cells to 18.
Ans: On the Home tab, in the Font group, click the Font Size arrow, and select 18.
15). Autofit column d to best fit the data
Ans: Double-click the right column boundary for column D.
16). Change the font for the selected cell to cambria
Ans: On the Home tab, in the Font group, click the Font arrow, and select Cambria.
17). Print the entire workbook.
PaperStoc.com Page 2 of 42
, Ans: Click the File tab to open Backstage. Click Print. Click the Print Active Sheets
button. Click Print Entire Workbook. Click the Print button.
18). Merge the cells so the text appears centered across the merged cells
Ans: On the Home tab, in the Alignment group, click the Marge & Center button.
19). Apply the accent1 cell style to the selected cell.
Ans: On the Home tab, in the Styles group, click the Cell Styles button. Click the
Accent1 style.
20). Use autofill to copy the formula and the formatting in cell e2 to cels e3:e6
Ans: Click the Fill Handle tool in the selected cell and drag across to cell E6. Release
the mouse button.
21). Delete this row.
Ans: On the Home tab, in the Cells group, click the Delete button arrow and select
Delete
22). Add a footer that displays the page number in the center section.
Ans: On the Header & Footer Tools Design tab, in the Header and Footer Elements
group, click the Page Number button.
23). Apply the accounting number format to the selected cells.
Ans: On the Home tab, in the Number group, click the Accounting Number Format
button.
24). Hide the column showing 2016 data and the bonus rate.
Ans: Click the column selector for Column B. On the Home tab, in the Cells group,
click the Format button. Point to Hide & Unhide, and click Hide Columns.
25). Modify the worksheet so the first row is always visible when you scroll the worksheet
down.
PaperStoc.com Page 3 of 42
, Ans: On the View tab, in the Windows group, click the Freeze Panes button. Click
Freeze top Row.
26). From page break preview view, insert a page break immediately above the selected cell.
Ans: On the Page Layout tab, in the Page Set up group click the Breaks button. Click
Insert Page Break.
27). Select column b
Ans: Click the column selector at the top of column B
28). Select cells a5:d8
Ans: Click cell A5 and drag to cell D8. Release the mouse button.
29). Cell f4 has been copied. paste the formula only into the selected cell ( cell f5). do not
include the cell formatting.
Ans: Click the Paste button arrow, and then click the Formulas button
30). Apply bold and italic formatting to the selected cell.
Ans: On the Home tab in the Font group, click the Bold button and the italic button.
31). Modify the number format do no decimal places are visible after the decimal point.
Ans: On the Home tab, in the Number group, click the Decrease Decimal button twice.
32). Use the spelling checker to find and change all instances of any misspelled words.
Ans: Click the Review tab and click the Spelling button. click the Change All button.
Click OK.
33). Rename sheet1: dec 26
Ans: Right-click the sheet1 worksheet tab, and click Rename. Type Dec 26 and press
enter
PaperStoc.com Page 4 of 42
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Academik001. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
