ilkecokay
Turkey
Excel Sheet Question
- Κατάσταση: Closed
- Βραβείο: $20
- Ληφθείσες Συμμετοχές: 2
- Νικητής: ilkecokay
Winner
Σύνοψη Διαγωνισμού
Open the file named (SecondAsg.XLSX) and perform the following questions
Q1. On excel file create a macro name it (Q1) this macro needs to perform the following operations on relative basis
a. Font name (Courier)
b. Font size (13)
c. Font color Blue
d. Alignment center
Q2. Create a procedure named (Q2) when it runs it types your name in A1, and your Student id in A2 in Sheet1
Q3. Add a button on sheet 1 , when it is clicked it will add new sheets to the current workbook, the procedure name should be (Q3)
Q4. Add a button to sheet 1, when it is clicked it will save the current workbook, The procedure name should be (Q4)
Q6. Write a procedure named Q6, when activated it will search for any value larger than 2000 and it will make its background red, This procedure is activated on Sheet 2 only
Q7.Write a procedure named Q7 , when activated it will make the values in even row number have green background , it should be applied on Sheet3 only
Q8. Write a procedure named Q8, when activated it will take the values found in Sheet 3 and will print them to the immediate window
Q9. Write a procedure named Q9, when activated it will add the value of (VBA is Easy) in Cell G9 for every sheet
Q10. Write a procedure named Q10, when activated it will close excel using Application Object
Note: Do not forget to save the file as .xlsm , otherwise no macros will be attached
Προτεινόμενες Δεξιότητες
Σχόλια Εργοδότη
“Very Faast Trustable can teach you how to make the thing work with you step by step He is the best Freelancer ever ”
Yabedullah, Jordan.
Κορυφαίες καταχωρήσεις από αυτόν τον διαγωνισμό
-
-
alaminforayaji Bangladesh
Πώς να ξεκινήσετε με τους διαγωνισμούς
-
Αναρτήστε τον διαγωνισμό σας Γρήγορα και εύκολα
-
Λάβετε Πολλές Συμμετοχές Από όλο τον κόσμο
-
Βραβεύστε την καλύτερη καταχώρηση Κατεβάστε τα αρχεία - Εύκολα!
