Alamin Computer Training Center 559, Madrasah Market, Shop No-30, Kazipara, Mirpur, Dhaka-1216.
Phone: 02-9003222, E-mail: ruhulworld@yahoo.com, Website: ruhulworld.blogspot.com
Microsoft Office Excel 2007 What Is Excel (G‡·j wK) t
EXCEL k‡ãi AvwfavwbK evsjv A_© n‡”Q †kªôZ¡ jvf Kiv ev ¸‡b AwZµg Kiv| EXCEL n‡jv GKwU Windows wfwËK Application Program hv Microsoft Corporation KZ©„K evRviRvZK…Z| GwU GK cªKvi Spread Sheet Analysis Program (†¯cÖWkxU G¨vbvjvBwmm †cÖvMÖvg)| g~jZ EXCEL Gi mvnv‡h¨ hveZxq wnmve wbKvk mn Data Entry Ges Data Analysis Dfq ai‡bi KvR Kiv hvq| What Is Spreadsheet (‡¯cÖWkxU wK) t Spread Sheet k‡ãi AvwfavwbK evsjv A_© n‡jv Qov‡bv cvZv (Spread A_© Qov‡bv Ges Sheet A_© cvZv)| MÖvd KvM‡Ri b¨vq X A¶ Ges Y A¶ eivei †Lvc †Lvc
…show more content…
Phone: 02-9003222, E-mail: ruhulworld@yahoo.com, Website: ruhulworld.blogspot.com
Row Height evov‡bvt 1. cÖ‡qvRbxq †iv wm‡j± Ki‡Z n‡e 2. 3. 4. 5. Home Click Format Click Row Height Click cÖ‡qvRbxq msL¨v UvBc K‡i Ok wK¬K
Column Unhide Kiv t 1. cÖ‡qvRbxq Kjvg wm‡j± Ki‡Z n‡e 2. Home Click 3. Format Click 4. Hide & Unhide Click 5. Unhide Columns Click Row Hide Kiv t 1. cÖ‡qvRbxq ‡iv wm‡j± Ki‡Z n‡e 2. 3. 4. 5. Home Click Format Click Hide & Unhide Click Hide Rows Click
A‡UvwdU Row Height t 1. cÖ‡qvRbxq †iv wm‡j± Ki‡Z n‡e 2. Home Click 3. Format Click 4. Autofit Row Height Click Column Width evov‡bvt 1. cÖ‡qvRbxq Kjvg wm‡j± Ki‡Z n‡e 2. 3. 4. 5. Home Click Format Click Column Width Click cÖ‡qvRbxq msL¨v UvBc K‡i Ok wK¬K
Row Unhide Kiv t 1. cÖ‡qvRbxq ‡iv wm‡j± Ki‡Z n‡e 2. 3. 4. 5. Home Click Format Click Hide & Unhide Click Unhide Rows Click
A‡UvwdU Column Width t 1. cÖ‡qvRbxq Kjvg wm‡j± Ki‡Z n‡e 2. Home Click 3. Format Click 4. AutoFit Column Width Click Column Hide Kiv t 1. cÖ‡qvRbxq Kjvg wm‡j± Ki‡Z n‡e 2. 3. 4. 5. Home Click Format Click Hide & Unhide Click Hide Columns Click
Sheet Hide Kiv t 1. cÖ‡qvRbxq kx‡U wK¬K Ki‡Z n‡e 2. 3. 4. 5. Home Click Format Click Hide & Unhide Click Hide Sheets Click
Sheet Unhide Kiv t 1. 2. 3. 4. 5. Home Click Format Click Hide & Unhide Click Unhide Sheets Click
Copy and paste the left arrow ( ) into boxes to show where a unit of material ends.
The fourth pair of columns on a 10-column work sheet prepared at the end of the period would be the
Include each of the four letters of your code below. Use one line for each letter.
To delete text to the left of the insertion point, press the Backspace key on your keyboard.
Press Ctrl + Enter and all of the blank cells will be filled with a zero value.
'#>%1,8(!" # '#0%& '(222222222222222222222222222222222222222222222222222222222222222222222222222222222222(4)/,3)-a4)12(,&1-2,-01A-",43-+;030+2)3-************************************************************************************-OQL012-a4)12(,&-,&-+;030+2)3*-*****************************************************************************************************-OO2#.$")$3")044)5/#67)&/5*)***************************************************************************************************)88D42-:;02-08,42-1)+,&$03"-+;030+2)31]-***********************************************************************************-OO- ;1%:&<(A-B&(19(C"& '&(%"&(A&# '% (19(222222222222222222222222222222222222222222222222222222222222222222222222222222(45942;,3W-7 '03(11)-L0!-****************************************************************************************************************-ORF;02-+0&-",4-20A)->3,!-2;(1-B()+)-0&$-0BB '"-2,-",43-,:&-:,3A]-*****************************************-OY-
To do this, use the Week 4 Course Project Assignment Template (PROJ420_W4_PIMatrixTemplate.xlsx) in Doc Sharing.
You cannot analyze data until you have brought the relevant data that will answer the question you are asking. A new feature of Excel 2016 is the built-in function which makes getting and transforming your data much faster and easier and allows you to find and gather all your data into one place. These new capabilities were only available previously as a separate add-in called Power Query. Now they can be found built into Excel 2016. They can be accessed from the Get & Transform group located on the Data tab.
At the bottom of SPSS, there are options to look at the data in Data View or in Variable View. I clicked on Variable View to name my variables. A list of columns appeared, but I only made changes to rows in the Name column. In row 1 under Name, I typed SubjectNo (no spaces or symbols are allowed when naming variables in SPSS) for Subject Number. I clicked back to Data View. The first column was now named SubjectNo, so I typed the list of subject numbers from 1 to 96 (1 number per row) for the number of "participants" in this study. I go back to Variable View and named row 2 as GroupNo. Under the GroupNo column, within Data View, I typed 1’s in rows 1 thru 48 and typed 2’s in rows 49-96. Group 1 was high need for cognition and group 2 was low need for cognition. I labeled the next 45 rows under GroupNO, in the Variable View, as the different item numbers: Item#1 thru Item#45. In all there was a total of 47 rows in the Variable View and 47 columns in the Data View. I clicked back into random.org and highlighted all 4,320 integers not missing any and right clicked for a menu to pop up. In this menu I clicked COPY, then I went back to the SPSS datasheet in the Data View. Under the column labeled Item#1, I clicked on the cell in row 1 and right clicked for the Paste option. All 4,320 integers were placed correctly in the columns, Item#1-Item#45 in 96
3. There are a couple of display options, scroll down the page until you see:
I can still customize these columns and add many other options, or I can just click on any of the
2 3 4 5 x1________ Heading, margins, double
erahs rep 5.81$ ta erahs fo htrow 952$ kcab yub ot hsac n oillim 902$ dna tbed n oillim 05$ esu lliw IKB
Now, you need to configure your grid. For this, go to the grid setting option, select the spacing, Padding, number of columns, pagination setting, Layout style, etc, as per your specific needs. For example-
If you have not yet defined any relationships, the Show Table dialog box automatically appears. If it does not appear, on the Design tab, in the Relationships group, click Show Table.