SIMNET UPDATED Exam Questions And
CORRECT Answers
Save the file to a new folder inside the Documents folder on the computer. Name the new
folder Marketing. Name the file BusinessPlanUpdated. - CORRECT ANSWER- With your
document open, click File > Save As.Under Save As, select where you wan...
Save the file to a new folder inside the Documents folder on the computer. Name the new
folder Marketing. Name the file BusinessPlanUpdated. - CORRECT ANSWER- With your
document open, click File > Save As.Under Save As, select where you want to create your
new folder. ...In the Save As dialog box that opens, click New Folder.Type the name of your
new folder, and press Enter. ...Click Save.
Click the Name Box. - CORRECT ANSWER- Small box next to large formula line
Navigate to the second sheet in the workbook. - CORRECT ANSWER- Second sheet on the
bottom
Remove the file from Protected View so you can edit it. - CORRECT ANSWER- Click
enable editing
Apply the Accounting Number Format to the selected cells. - CORRECT ANSWER- $ under
"General"
Apply the Short Date format to the selected cells. - CORRECT ANSWER- Arrow next to
general, short date
Use AutoFill to copy the formula and formatting in cell E2 to cells E3:E6. - CORRECT
ANSWER- Drag bottom right corner down
Click any of the data markers to select the entire Gross Profit data series. - CORRECT
ANSWER- Click a column
Insert a Line chart based on the first recommended chart type. - CORRECT ANSWER- You
clicked the Quick Analysis Tool button, clicked the Charts tab header, and clicked the Line
button.
, Edit the formula in cell D2 so the references to cell C2 will update when the formula is
copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to
cells D3:D6. - CORRECT ANSWER- =C2+(C2+$B$9)
Use AutoSum to enter a formula in the selected cell to calculate the total of all the contiguous
cells above. - CORRECT ANSWER- In the Home Ribbon Tab in the Editing Ribbon Group,
you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Sum menu
item. You pressed Enter.
Use the Quick Analysis tool to calculate totals for the selected cells. Insert the totals in the
empty row below the cell range. - CORRECT ANSWER- Click the Quick Analysis tool
button and then click the Totals tab. Click the first Sum button.
Apply the Double Accounting underline format to the selected cells. - CORRECT ANSWER-
Click the small arrow in the bottom right corner of the section with underline. In the
underline section, expand the Underline list, select double accounting.
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1. - CORRECT
ANSWER- Click the paintbrush, click E1
Apply conditional formatting to the selected cells using the Three Traffic Lights (Unrimmed)
icon set (the first icon set in the Shapes section). - CORRECT ANSWER- Home, conditional
formatting, icon sets, first set in shapes
Apply conditional formatting to the selected cells so cells with a value greater than 400 are
formatted using a light red fill. - CORRECT ANSWER- In the home ribbon tab in the styles
ribbon group you clicked the conditional formatting button. in the conditional formatting
menu in the highlight cells rules mine you clicked the greater than menu item. inside the
greater than dialog you typed 400 in the format cells that are greater than: input. inside the
greater than dialoging in the with drop down you selected light red fill. inside the greater than
dialog you clicked the ok button
Clear the conditional formatting rules from the worksheet. - CORRECT ANSWER- Home,
conditional formatting, clear rules, clear rules from entire sheet
Use a single command to clear everything (content and formatting) from the selected cell. -
CORRECT ANSWER- On the Home tab, in the Editing group, click the Clear button. Select
Clear All.
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 MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.