Portfolio 9_10_11 PDF

## Macro - **Question:** Macro 65° Function define ? - **Answer:** - **Step 1:** Macro 65° Function দুটি Title - **Calc files** function - **Title** 65° Calc sheet 65° Room number 65° - **Tile** 65° Column number 65° Title 65° - Calc files 65° Function 65° c...

## Macro - **Question:** Macro 65° Function define ? - **Answer:** - **Step 1:** Macro 65° Function দুটি Title - **Calc files** function - **Title** 65° Calc sheet 65° Room number 65° - **Tile** 65° Column number 65° Title 65° - Calc files 65° Function 65° calculate. ods 65° use - **Step 2:** Tools > Macros > Organize Macros > Library - "Office Basic" Click “Basic Macros” dialogue - Open - **Step 3:** Calculate. ods 65° Function New 65° Click. - "Calculate files" 65° OK button 65° Click. - **Step 4:** - For loop 65° formula 65° Function 65° - End bas Function. - Function CalcTiles (a,b,c,d,) - CalcTiles = (ab) / (cd) - End Function. - **Step 5:** - a = Room Number - b = Room Number - c = Title Number - d = Tile Number. - Calc sheet 65° "CalcTiles()" Function 65° result 65° save. ## Workbook - **Question:** Workbook 65° Sheet নান্ Reference প্রলাপা ? - **Answer:** - Sheet1 65° Sheet2 65° Sheet 2 65° Sheet1. - Data Link জাইমা - Sheet 2 65° Cell 65° Sheet 1 65° data link - "=" type 65° - Sheet 1 65° Cell 65° data 65° link - select bão Enter press 65° - "$'Sheet1'. C4" - Sheet গুণি গদ্য Data link গুচ্ছগত। ## Workbook - **Question:** Workbook 65° Sheet গান পান্থ Reference কু ছিল? - **Answer:** - abc bão xyz workbook & Sheet1 65° nyz2 Sheet 2 65° link - - abc 65° xyz workbook open 65°. - abe workbook 65° Cell 65° data link - '=' symbol type 65° - Taskbar & nyz workbook 65° xy2 Sheet2 65° Cell 65° data 65° reference - select 65° Enter 65° press 65°. - xyz file 65° সংকলন 65° - Single quotation(' ') 65° type 65° #$ - Sheet 2 65° dot (.) 65° type 65° - Enter 65° press 65°. - "'file:///C: users/Admin/Documents/nij2.ads" - Workbook 65° Sheet 65° data - Reference পন্থী