CIT121 Assignment 1

-

 1. Copy the table below









2. How do you compute the number of males in excel?
'' failed to upload. Invalid response: Error code = 7, Path = /_/BloggerUi/data/batchexecute, Message = There was an error during the transport or processing of this request., Unknown HTTP error in underlying XHR (HTTP Status: 0) (XHR Error Code: 6) (XHR Error Message: ' [0]')


Uploading: 39024 of 39024 bytes uploaded.





                   4. Place a border around the table                                                                                               
                                           

                                                                                                                                                                                                                    







5. Make the headers uppercase letters









6. Make the college lowercase letters
Uploading: 33869 of 33869 bytes uploaded.






7. Number of student in each college




8. Auto complete the s/n



9. Identify the names that have no duplicates in the last name column


































                




Comments

Post a Comment

Popular posts from this blog

CIT121 Assignment 2

-
Image
Create the table shown in the image 1.   Give the sum of the total scores of Ashok, Pooja, Anil, and Prem in Physics using the Excel formula. 2. Give the sum of all the students in English, Maths, and chemistry.  3. what is the sum of the scores in Hindi? 4. Give the missing Totals in the table for the students apart from RAM.   5. Give the missing average scores for the students apart from RAM. 
Read more