subject

You are supposed to create an excel sheet consisted to 20 records in it. The data file should not match other students’ data. (10 marks) You need to perform the following Excel options on your data
1. Calculate percentage in one column
2. Apply nested If Function on one column
3. Apply conditional formatting on one column
4. Calculate working days in one column
5. Apply countIf on one column
6. Concatenate the strings ( first name last name in one column)
7. Apply data validation rules ( string, numeric and list) on 3 columns
8. Apply group and un-group data option
9. Apply text to column option on data
10. Make line, pie and bar graph from the data

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 14:30
The “rule of 72” is used to approximate the time required for prices to double due to inflation. if the inflation rate is r%, then the rule of 72 estimates that prices will double in 72/r years. for instance, at an inflation rate of 6%, prices double in about 72/6 or 12 years. write a program to test the accuracy of this rule. for each interest rate from 1% to 20%, the program should display the rounded value of 72/r and the actual number of years required for prices to double at an r% inflation rate. (assume prices increase at the end of each year.)
Answers: 1
question
Computers and Technology, 22.06.2019 22:30
I'll mark brainliest if answered right! with which feature or menu option of a word processing program can you make an image like this? you can get this image using the option of a word processing program.
Answers: 1
question
Computers and Technology, 23.06.2019 10:50
The volume v and paper surface area a of a conical paper cup are given by where r is the radius of the base of the cone and h is the height of the cone. a. by eliminating h, obtain the expression for a as a function of r and v. b. create a user-de ned function that accepts r as the only argument and computes a for a given value of v. declare v to be global within the function. c. for v ! 10 in.3 , use the function with the fminbnd function to compute the value of r that minimizes the area a. what is the corresponding value of the height h? investigate the sensitivity of the solution by plotting v versus r. how much can r vary about its optimal value before the area increases 10 percent above its minimum value?
Answers: 1
question
Computers and Technology, 24.06.2019 17:00
Aman travel 200m towards east< br /> from his house then takes left< br /> to turn and moves 200 m north< br /> find the displacement & distance.< br />
Answers: 3
You know the right answer?
You are supposed to create an excel sheet consisted to 20 records in it. The data file should not ma...
Questions
question
Biology, 18.03.2021 02:30
question
Health, 18.03.2021 02:30
question
Mathematics, 18.03.2021 02:30
question
English, 18.03.2021 02:30
question
Mathematics, 18.03.2021 02:30
question
Social Studies, 18.03.2021 02:30
question
Law, 18.03.2021 02:30
Questions on the website: 13722360