Discussion Replies

User Generated

Ubbg1991

Writing

Description

They must be a minimum of 100 words EACH. The responses should not be generic and demonstrate thought.


1) Unite B How to copy relative cell

Hello class,

I have a simple question that deserves a thorough response.

Class, how do you copy formulas with relative cell references? Please be thorough in your responses.


2) Unit B Understanding Relative and Absolute

Lets talk about cell types. Make sure you read all of your UNIT B. Then answer the following question.

Class, please explain your perspectives on understanding relative and absolute cell references? Again, make sure you are thorough with your responses.


3) Unite C Formatting a Worksheet Cell s

This unit reading discusses how to format and style and Excel spreadsheet/worksheet. To format a the content of a worksheet you first have to select it, then use the ribbon's settings to style the cell's data (bold, italicize, increasing or decreasing font size and style, etc.). The ribbon offers many other styling settings to format an entire selection of cells or the entire worksheet. From the Home tab, there's a Format settings section, this includes a set of defined styles, which include font style, font color, cell background colors and border colors. Through this Format tool, you can also create a new custom cell style. Doing this, will make it easier to apply if you need format a worksheet with the same styles. You can also use the Table Styles formatting settings from the Tables tab to apply already defined formatting from their list and can also create new custom table styles for easier application.


4) Unit C Conditional Formatting


Lets talk about conditional formatting for a moment.

Conditional formatting allows a user to create rules to automatically format cells to emphasize certain areas of a data range. For example, you can use conditional formatting to change the color or highlight certain numbers such as the highest number or lowest number. You can also use conditional formatting to compare different values or show repeated values. To change a condition after creating a conditioning formatting rule, you can simply modify the rule using the Rules manager instead of creating a new rule. To do this you select the cells that contain the conditional formatting, click on the conditional formatting button in the styles group and then select manage rules. You can then select the rule you want to edit from the conditional formatting rules manager dialog box, click edit rule and modify the setting.

Class, what does your reading say about conditional formatting? What can you find the Internet? Thoughts? Experiences?


5) Unit C Editing Appearance

Similar to Microsoft Word, Microsoft Excel has formatting components to allow the user to alter the appearance of the data so that it is more than just words and numbers. These formatting components allow the user to alter the font features, such as color, size, bold, italicized, underlining, borders, or containing dollar signs, percent signs, commas, or the number of decimal points that you want to appear. These formatting characteristics often change the way that data is perceived or interpreted by making key components stand out. Also like Microsoft Word, Microsoft Excel has tools for creating different types of graphs and charts. The user can take the data they have entered and calculated and create visual aids that can come in handy when trying to make a point or be persuasive.


6) Unit D Creating Charts within MS Excel

When you create a chart you need to plan the information that you want your chart to show and how you want it to show the information. If you plan ahead it can help you organize the data and help you decide what type if chart you want to use to show the data you want to present. After completing the first assignment, I actually do find it easy now to create a chart. Before I honestly didn't even have a clue where to start. The videos really helped out a lot with the assignment and showed me just how easy it is to create a simple chart. Videos also showed me some great charts to use depending on the type of data that I wanted to present.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey Buddy, here are the discussion and Replies

Surname 1
Name
Tutor
Course
Date
Discussion Replies
1) How to Copy Relative Cell
The two types of cell references are; relative and absolute. This case is dealing with a
relative cell reference, and one of its distinguishing characteristics is that it changes when a
formula is copied to another cell. Since all cell references are relative by default, when copied
across many cells, they tend to change regarding the relative position of the rows and
columns. To copy formulas with relative cell references, firstly, one should select the cell that
has the formula that one intends to copy. Secondly, one should go to the Home tab, and in the
clipboard, he should click copy. Thirdly, one should paste the formula and any formatting,
using the clipboard to paste on the Home tab. The fourth step should be to verify if the cell
references in the formula generate the intended results.
2) Understanding Relative and Absolute
The two types of cell references are relative and absolute references. Both have
uni...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags