[go: up one dir, main page]
Scribd
Upload
406 views2 pages

Business Unit 4 Assignment - Critical Thinking Questions

A user may want to manipulate page setup options in a spreadsheet to visually present abstract data in an appealing and understandable way for people unfamiliar with tables and worksheets. Knowing how to set up and explain graphs and charts is important for working with business data. To count male and female students by age while ignoring outliers like ages of 0, -42 or 100, one could sort ages in ascending order, use a filter to exclude values outside of 0-22, then sort alphabetically to group females together for counting. Using filters in a shared data analysis spreadsheet makes the information easier to understand by clearly sorting it out in an organized manner. Customizing the ribbon tabs and groups in Excel, like in Word,

Uploaded by

Bảo Ngọc Nguyễn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
406 views2 pages

Business Unit 4 Assignment - Critical Thinking Questions

A user may want to manipulate page setup options in a spreadsheet to visually present abstract data in an appealing and understandable way for people unfamiliar with tables and worksheets. Knowing how to set up and explain graphs and charts is important for working with business data. To count male and female students by age while ignoring outliers like ages of 0, -42 or 100, one could sort ages in ascending order, use a filter to exclude values outside of 0-22, then sort alphabetically to group females together for counting. Using filters in a shared data analysis spreadsheet makes the information easier to understand by clearly sorting it out in an organized manner. Customizing the ribbon tabs and groups in Excel, like in Word,

Uploaded by

Bảo Ngọc Nguyễn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1.

Why might a user want to manipulate the page set up options for a spreadsheet
(as compared to a Word document)? For example, what is the point of changing
orientation in a spreadsheet’s page setup?

A user might want to manipulate page set up options for spreadsheet to present
abstract data in a visually appealing way that also makes it easier to be
understood by people who can’t necessarily read tables and
worksheets. Knowing how to set up and explain graphs and charts is absolutely
key when it comes to working with data in business.

2. Imagine you are working with a word document that is meant to track the ages of
all students in a high school. The sheet contains their name, age, sex, and a few
other pieces of information. You want to know how many male students there
are for each age group and how many female students there are. However,
some students didn’t provide their ages (and thus a “0” is entered for their age),
and others gave unusual answers (like “-42” or “100”). Using a basic COUNT
function, sorting, and/or filtering how could you use conditional formula logic to
get an approximate count of student sex by age, ignoring these outliers?

I would sort their ages by order, then use a filter to count out the digits that are
larger than twenty two order smaller than 0. Then separate male and female by
sorting A->Z, the females would appear first.

3. When does it make sense to use a filter in a spreadsheet that’s being used for
data analysis, particularly one being shared with others?

Using a filter in a spreadsheet that is being used for data analysis that is
particularly shared with others is useful because it sorts out information in a
clear and concise way.

4. Excel, like Word, allows users to customize the ribbon tabs and groups (Data,
Home, Insert, etc.), hiding, re-organizing, or even allowing the creation of
entirely new groups. Why might a user be interested in this feature?
It keeps data organized, visually pleasing. Personally I use this function as it
separates lines from each other, making the sheet look organized, every piece
of data clearly shown.

5. You are looking at a spreadsheet that shows the results of two surveys: The first
survey indicates that 10.5 percent of all people surveyed were 25 years old.
There were 581 people in the survey, and there is a slight margin of error in
answers. The second survey included responses from about the same number
of people and produced 60 respondents who claimed to be 25. Rounding to the
nearest whole number, write the full mathematical formula that would take the
raw numbers and show how many people total (across both surveys) are aged
25. And assuming all future surveys sought responses from the same general
group, how many more people would you need to survey to identify 300 total 25-
year-olds?

The mathematical formula:


(581*10.5%) + 60 -~ 121 people
Assuming every survey includes approximately the same about of people
participating, it would take three more surveys as such to identify 300 25 year
olds.

You might also like