100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
MISY Exam 2 Question and answers 100% correct 2023/2024 $12.49   Add to cart

Exam (elaborations)

MISY Exam 2 Question and answers 100% correct 2023/2024

 20 views  1 purchase
  • Course
  • MISY
  • Institution
  • MISY

MISY Exam 2 Question and answers 100% correct 2023/2024Roadmap - correct answer Enter formulas in the worksheet•Enter functions in the worksheet•Verify formulas in the worksheet•Format the worksheet•Check spelling•Print the worksheet Selecting a Cell - correct answer Make the cel...

[Show more]

Preview 2 out of 7  pages

  • November 9, 2023
  • 7
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
  • misy exam 2
  • MISY
  • MISY
avatar-seller
Academia199
MISY Exam 2
Roadmap - correct answer Enter formulas in the worksheet•Enter functions in the worksheet•Verify formulas in the worksheet•Format the worksheet•Check spelling•Print the worksheet
Selecting a Cell - correct answer Make the cell active
Use the mouse
Use the arrow keys
Cell is active when a heavy border surrounds the cell
Calculating a Sum (1 of 2) - correct answer To Sum a Column of Numbers•
Click the first empty cell below the column of numbers to sum
Click the Sum button on the HOME tab to display a formula in the formula bar and in the
active cell
Click the Enter box in the formula bar to enter a sum in the active cell
Repeat above steps to enter the SUM function in other locations
Adding a Pie Chart to the Worksheet - correct answer To Add a 3-D Pie Chart•
Select the range for the 3-D pie chart
Click the 'Insert Pie or Doughnut Chart' button on the INSERT tab to display the Insert Pie or Doughnut Chart gallery Click the Insert Pie or Doughnut Chart gallery to insert the chart•
Click the chart title to select it
AutoCalculate - correct answer Using the AutoCalculate Area to Determine a Maximum
Select the range of which you wish to determine a maximum, and then right-click the status bar to display the Customize Status Bar shortcut menu Click Maximum on the shortcut menu to display the Maximum value in the range in the AutoCalculate area of the status bar
Correcting Errors - correct answer Correcting Errors after Entering Data into a Cell•
If the entry is short, select the cell, retype the entry correctly
If the entry is long, use the EDIT mode using in-cell editing•
To Clear the Entire Worksheet•
Click the Select All button on the worksheet
Flash Fill part 1 - correct answer To Use Flash Fill•Click a cell•
Type desired text and then press the DOWN ARROW to select the next cell•
Type desired text again following the same pattern (for example an email address)•
Click Data on the ribbon to select the Data tab•
Click Flash Fill to enter similarly formatted text
Flash Fill part 2 - correct answer Select a cell in the A column• Type desired text and then press the DOWN ARROW key to enter a row header. Continue until all Rows have a header
To Change the Sheet Tab Name and Color
Double-click the Sheet1 tab and enter the desired text as the sheet tab name and then press the ENTER key
Right-click the sheet tab to display the shortcut menu
Point to Tab Color on the shortcut menu to display the Tab Color gallery Click desired color
Save the workbook
Verifying Formulas using Range Finder - correct answer Verify a Formula Using Range Finder
Double-click a cell to activate Range Finder
Press the ESC key to quit Range Finder and then click anywhere in the worksheet to deselect the current cell
Formatting the Worksheet - correct answer To Change the Workbook Theme
Click the Themes button on the PAGE LAYOUT tab to display the Themes gallery
Click the desired theme in the Themes gallery to change the workbook theme
Inserting and Deleting Cells in a Worksheet part 1 - correct answer Right-click the row
heading below where you want to insert a row to display the shortcut menu and the Mini
toolbar
Click Insert on the shortcut menu to insert a new row in the worksheet by shifting the selected row and all rows below it down one row
Inserting and Deleting Cells in a Worksheet part 2 - correct answer To Enter and Format the System Date•
Select the cell in which you want to insert the date, and then click the Insert Function box in the formula bar to display the Insert Function dialog box•
Click the 'Or select a category' box arrow and then select Date & Time in the list to populate the 'Select a function' list with date and time functions
Adding and Formatting Sparkline Charts - correct answer To Enter and Format the System Date•
Select the cell in which you want to insert the date, and then click the Insert Function box in the formula bar to display the Insert Function dialog box
Click the 'Or select a category' box arrow and then select Date & Time in the list to populate the 'Select a function' list with date and time functions
Adding and Formatting Sparkline Charts - correct answer To Change the Sparkline Type•
Select the range of the sparkline charts and if necessary, click the SPARKLINE TOOLS DESIGN tab to make it the active tab•
Click the 'Convert to Column Sparkline' button to change the Sparkline charts in the selected range to the column type

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 Academia199. 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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

72042 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.49  1x  sold
  • (0)
  Add to cart