Excel Sheet Question
- Stav: Closed
- Odměna: $20
- Přijatých návrhů: 2
- Vítěz: ilkecokay
Instrukce k soutěži
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
Doporučené dovednosti
Zpětná vazba od zaměstnavatele
“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.
Nejlepší návrhy této soutěže
-
ilkecokay Turkey
-
alaminforayaji Bangladesh
Veřejná nástěnka k vyjasnění projektu
Jak začít se soutěžemi
-
Zveřejněte svou soutěž Rychlé a snadné
-
Získejte spousty návrhů Z celého světa
-
Zvolte nejlepší návrh Stáhněte si soubory - Je to snadné!