Computers and Technology, 10.11.2021 21:20 lerasteidl

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

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 09:30, blake2001

Which of the following tasks is an audio technician most likely to perform while working on a nature documentary? (select all that apply). eliminating potentially distracting background noise adding sound effects making sure the lighting is adequate for a particular scene changing the narration to better match the mood of the documentary

Answers: 3

continue

Computers and Technology, 23.06.2019 17:00, kyleemarie2003

Companies that implement and apply an information system effectively can create

Answers: 1

continue

Computers and Technology, 24.06.2019 06:50, emmv565628

What are the things you are considering before uploading photos on social media?

Answers: 1

continue

Computers and Technology, 24.06.2019 11:20, tiffanibell71

Colby works as a shipping clerk for a major package delivery service. some of his daily tasks include tracking shipments and entering orders. which aspect of the information technology cluster would he most likely be trained in? a. networkingb. databasesc. hardwared. software

Answers: 2

continue

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