Excel Program

سڵاو قوتابیانى پۆلی سێ
تكایه‌ ئه‌م بابه‌ته‌ بخوێننه‌وه‌ بۆ تاقی كردنه‌وه‌ داخله‌
6- Arrays in Visual Basic 6
An array is a collection of simple variables of the same type to which the computer can efficiently assign a list of values.

Array variables have the same kinds of names as simple variables.

An array is a consecutive group of memory locations that all have the same name and the same type.

To refer to a particular location or element in the array, we specify the array name and the array element position number.

We can declare an array of any of the basic data types including variant, user-defined types and object variables.

The individual elements of an array are all of the same data type.

6-1 Declaring arrays: Arrays may be declared as Public (in a code module), module or local. Module arrays are declared in the general declarations using keyword Dim or Private.

Fixed-Size Array: The size of array always remains the same-size doesn't change during the program ex*****on.

The array holds either all string values or all numeric values.

سلاو قوتابيانى پۆلی سێیه‌م
ده‌توانن ئه‌م خشته‌یه‌ له‌به‌ر بكه‌ن له‌جیاتى ئه‌وه‌ى مه‌لزه‌مه‌كه‌

سڵاو ئازیزان
هەر پرسیارێکتان هەیە لە ئەکسڵ ئامادەم

سلاو
قوتابیانی پولی یه ک
Mail merge
له عملي هاتوتةوة باش بخوينن

سلاو قوتابیانى پۆلی یه‌ك
تكایه‌ ئاگادار بن ئه‌م پێناسانه‌ى خواره‌وه‌ بۆ امتحان ه‌داخله‌
Status bar:
bar across the bottom of the word windows displaying information about a selected command or an operation in progress.

Chart:
is a graphic representation of data. Charts allow users to see what the results of data to better understand and predict current and future data

Pointer:
As you move the pointer , it will change its appearance according to which part of the screen it is over and what is currently selected.

Page number:
Show the number of pages displayed on the screen and the total number of pages in the document.

Context specific tabs
There are additional tabs that only appear when relevant for the task you are carrying out. These are known ac contextual tabs.

Clipboard
The Clip Board acts as a holding area for multiple copied ites, ready to paste them into your documents.

Indent Paragraph
Indenting from the left or right margins can make paragraphs stand out in your document.

Save as:
This will save the document to your default file location, with a different file name, different file location or both.

Header and footer
Headers and footers enable you to repeat the same text at the top (header) and/or bottom (footer) of each page of your document.

Check spelling
Before you send a document to print, it should be checked to ensure all the words are correctly spelt, that it is grammatically correct.

Template
A master document, from which a new document is created each time you require a copy of it using the preset document layout eg DOT.

Mail Merge
Mail merge is the process of combining a mailing list and a main document, to print a run of documents with differing information in certain parts of each document.

Fields
A lot of header and footer text can be automatically inserted, such as page numbers, date and time information, author, user information, files name and location. These are called fields.

Formatting tool
Using the format painter, it is possible to copy formatting from one part of a document and apply this formatting to other words, sentences or paragraph.

Align text
Text can be aligned with the left margin or the right margin, centered between the margins, or justified to align the text with both left and right margins.

Full screen
Maximize the space available for reading or commenting on the document.

سڵاو قوتابیانى پۆلی یه‌ك
ئاگادارتان ده‌كه‌م كه‌ امتحانى عه‌مه‌لى نوسینى ئینگلیزى تێدایه‌، تكایه‌ پراكتیك بكه‌ن له‌سه‌ر نوسینه‌وه‌ى بابه‌تى ئینگلیزى تا شاره‌زاتر بن

خشته‌ى به‌كارهاتوو بۆ Sort, Filter

بۆ قوتابيانى پۆلي يه‌كه‌م
رۆژى چوارشه‌ممه‌ سه‌عات نۆى به‌يانى له‌ مه‌عهه‌د ده‌بم، ئه‌وه‌ى پرسياري هه‌يه‌ ده‌توانێت بێت بۆ مه‌عهه‌د...
به‌هيواى سه‌ركه‌وتن
مامۆستا شيروان

سڵاو قوتابييه‌ خۆشه‌ويسته‌كانم
بۆ قوتابيانى پۆلي يه‌ك، تكايه‌ ئه‌مه‌ پرسياره‌كانه‌، به‌ وردي بيخوێننه‌وه‌و وه‌ڵامه‌كانى بدۆزنه‌وه‌، له‌گه‌ڵ هيواى سه‌ركه‌وتن.
1- Write the steps for copy paste Items
2- How we use save as?
3- How we can change file type?
4- How we can move an item from first page to the second page?
5- To select text by using direction you would hold down which key?
6- Count the type of section break
7- Count the ways for exit word.
8- Write 2 short cut key to open (open dialog box)
9- Count the way for save document.
10- Count the ways for making table.
11- Portrait and landscape are………………………….
12- The minimum row and column in table is………………………..
13- The maximum number of column in table is…………………
14- The maximum number of row in table is…………………………
15- What the smallest and largest font size are available in font size on formatting tool bar.
16- By default on which page the header is printed?
17- Which key should press to start new paragraph?
18- To bold text which short key should use.
19- Write the steps to copy text between 2 file…
20- Count the page view mode
21- What is word file extension?
22- The file tab menu known as…………………
23- What is the command in the file tab?
24- What is the managing tab in file tab
25- Count the ways for minimize ribbon
26- Count the ways for zoom
27- the maximum zoom is
28- the minimum zoom is
29- Count the type of zoom
30- Count the ways for help
31- Count 5 buttons help tool bar
32- Count the ways for change font size
33- Count the ways for change font color
34- Count the ways for change font type
35- What is the triple click job?
36- In paragraph how we change first character for each word to capital.
37- Why we use header and footer?
38- What is the redo job if we don’t use undo?
39- Count the ways for undo
40- Count the way for redo
41- To delete character to the right insertion point we use………………
42- To delete character to the left insertion point we use………………..
43- Count the ways for selecting one paragraph.
44- Count the for selection whole document.
45- Write the steps for create shortcut key for insert symbol.
46- Why we use insert symbol?
47- Count the ways for saving file.
48- Count the ways for open file.
49- Count the ways for close file.
50- Count the ways for create new file.
51- Count the ways for print file.
52- Count the ways for select column
53- Count the ways for select row
54- Count the ways for select table
55- Count the ways for select cell
56- Write the steps for convert table to text
57- Write the steps for convert text to table
58- Write the steps to draw page border
59- Write the steps to draw paragraph border
60- Write the steps to draw text border
61- What is the Ctrl+Shift+right direction job
62- What is the Ctrl+Shift+down direction
63- What the following shortcut keys job(Ctrl+Shift+C, Ctrl+Shift+V, Ctrl+Shift+D, Ctrl+Shift+W, Ctrl+Shift+D, Ctrl+Shift+A, Ctrl+Shift+K, Ctrl+Shift+H, Ctrl+R, Ctrl+L, Ctrl+E, Ctrl+J, Ctrl+1, Ctrl+2, Ctrl+S, Ctrl+N, Ctrl+P, Ctrl+B, Ctrl+U, Ctrl+I, Ctrl+W, Ctrl+O, Ctrl+W, Shift+Enter, Ctrl+Enter, Ctrl+H, Ctrl+F, Alt+Shift+T, Alt+Shift+P, Alt+Shift+K, Alt+Shift+N, Alt+Shift+F)
64- In Table what the following Shortcut keys job (Tab, Shift+Tab, Alt+End, Alt+Home, Alt+Page down, Alt+Page up)
65- What is the main document can be in mail merge?
66- What is the mailing list contain?
67- Each piece of information in the data source known as………………
68- In the merge to printer dialog box what the (all) button mean?
69- In the merge to printer dialog box what the (Current recond) button mean?
70- In the merge to printer dialog box what the (from to) button mean?
71- Write steps to save file in word 2003
72- Write steps to merge 2 cells or more in table
73- Write the steps to shading the table title
74- Write the steps for repeat header row
75- How many position we have in a cell
76- The maximum number row and column in create table by mouse is……………….
77- How many text direction we have in the cell?
78- What is the type of text direction in the cell
79- We can delete row by:
80- We can delete column by:
81- We can delete cell by:
82- We can delete table by:
83- We can insert row by:
84- We can insert column by:
85- We can insert cell by:
86- What is this symbol ¶
87- What is this symbol
88- How many Items can keep in office clipboard?
89- How we can paste item from clipboard
90- How we can empty office clipboard
91- What is the goal for using search command
92- Count the ways for opening search dialog box
93- Count the ways for delete selecting text
94- Count the for undo
95- Count the way for redo
96- What is the Ctrl+y job without using undo
97- Count the ways for switch between open document
98- Count the page view mode type
99- Count the ways for page view mode
100- How we can merge 2 paragraph
101- Count the type of line spaceing
102- The measures of the space between paragraph is…………
103- Count the type of text align
104- The indentation of paragraph is …………………, ……………………………..
105- The indentation of line is ……………………………, …………………………..
106- How we can insert line break
107- How we can remove line break
108- Count the ways for resize the objects
109- Another name for the cursor is………………………….
110- Count the type of margins
111- Count 5 type of chart
112- Count 3 type of shape
113- Count 5 type of style
114- What is the different between close and exit
115- What is the different between cut and copy
116- What is the different between print and print preview
117- What is the different between print in file menu and print in quick access tool bar
118- What is the size of A4 paper
119- What is the size of A3 paper
120- Count the type of change case
121- What type file indicate to the word 2003
122- In mail merge operation which is might represent the main document?
123- What does ctrl + = key effect?
124- What does Ctrl+(+) key effect?
125- What is the Ctrl+Shift+Enter job?
126- Which key is used to increase left indent?
127- How to use format pointer multiple times
128- Which would you choose to save a document with a new name?
129- What is the Ctrl+Space bar job?
130- What is the Ctrl+Delete job?
131- What is the Ctrl+backspace job?
132- How we can indent all lines except first line?
133- What enables you to send the same letter to different persons?
134- What is the Ctrl+Page down job?
135- What is the Ctrl+Page up job?
136- Count 4 type of table style
137- How we can change all letters to small caps?
138- How we can hide text?
139- What is the section gives us?
140- How we can show total number of words in the document?
141- What the one page display in zoom?
142- What the page width display in zoom?
143- How we can select one line by mouse
144- How we can select one sentence?
145- What type of Item can be copy?
146- How we can cancel the format painter?
147- How we can show page break position?
148- What is the buttons name that is appear on the right of title bar?
149- What is the information displayed on the status bar?
150- What happen when click at the dialog box launcher?

قوتابييه‌ خۆشه‌ويسته‌كانى پۆلي يه‌ك، تكايه‌ ئه‌م بابه‌تانه‌ بۆ امتحانى كۆرسي دووه‌م بخوێنن

قوتابييه‌ خۆشه‌ويسته‌كانى پۆلي يه‌ك، تكايه‌ ئه‌م بابه‌تانه‌ بۆ امتحانى كۆرسي دووه‌م بخوێنن

قوتابيانى پۆلى يه‌ك نموونه‌ى بۆ دروست كردنى Mail Merge

سڵاو
ته‌واوى قوتابيانى پۆلي يه‌ك ئه‌م خشته‌يه‌ دروست بكه‌ن

سڵاو هاوڕێیان
ده‌تانه‌وێ بزانن ته‌مه‌نتان چه‌ند رۆژه‌؟ ئاسانه‌..
ته‌نها برۆ به‌رنامه‌ ئه‌كسل بكه‌وه‌، له‌خانه‌یه‌ك مێژووى ئه‌و رۆژه‌ داخل بكه‌، بۆ نموونه‌ ئه‌مڕۆ (8/2/2015)، له‌خانه‌كه‌ى ژێر ئه‌ویش رۆژى له‌دایك بوونت داخل بكه‌ بۆ نموونه‌ ئه‌وه‌ى خۆم (26/7/1968) هه‌ردوو خانه‌كه‌ Select بكه‌و بچۆ Format Cell، له‌وێ حاڵه‌ته‌كه‌ بگۆڕه‌ بۆ سه‌ر General، هه‌ردوو مێژووه‌كه‌ ده‌گۆڕێن بۆ ژماره‌.
به‌ هاوكێشه‌یه‌ك (مێژووى له‌دایك بوونت-مێژووى ئه‌مڕۆ=) ئه‌نجامه‌كه‌ى ژماره‌یه‌ك ده‌بێت كه‌ بریتییه‌ له‌ ژماره‌ى رۆژه‌كانى ته‌مه‌نت

دایکێک لەگەڵ 4 کوڕی دژی داعش شەڕدەکەن

ژنە ئەنفالكراوێك بۆ یارمەتیدانی هێزەكانی پێشمەرگەی كوردستان و كوڕەكانی وەكو پێشمەرگەیەكی خۆبەش دەچێتە بەرەكانی شەڕ.

ناسكە كاكەمین ژنێكی تەمەن 60 ساڵە، رۆژی 30ی كانوونی یەكەمی 2015 بە خۆی و چەك و تفاقەكانی دەچێتە بەرەكانی شەڕ بۆ یارمەتیدانی 3 كوڕە پێشمەرگەكەی، كە لە بەرەكانی پێشەوەی رووبەڕوونەوەی چەكدارانی داعشن لە تەللوەرد و مەلا عەبدوڵڵا.

ناسك كاكەمین ده‌ڵێت : "كڵاشینكۆفێكم بە پارەی خۆم كڕیوە بۆ شەڕی داعش، دوێنێ كە هەواڵی چەكدارانی داعشم بۆ نێو كەركووك بیست، خۆمم بەست و چەکەكەم هەڵگرت و چوومە نێو كەركووك بۆ شەڕكردن دژی داعش، بەڵام لە رێگا برایەكم منی گەڕاندەوەو هەواڵی كوشتنی هەموو چەكدارانی داعشی پێدام".

ئەو ژنە کە 30 ئەندامی خێزانەکەی ئەنفالن و یەکێکیان هاوسەرەکەی بووە، وەكو خۆی باسی دەكات ئێستا 4 كوڕ و 2 زاوای پێشمەرگەن، كە سیانیان لەبەرەكانی پێشەوەی شەڕی چەكدارانی داعشن و دەڵێ:" دوو كوڕم لە خەرابەڕووتن و دانەیەكی دیكەشیان لە مەلا عەبدولڵایە". ناسک کاکەمین دەشڵێ "لەگەڵ عەمید شێركۆ بووم زۆر دڵم سووتا كاتێك هەواڵی شەهیدبوونیم بیست، بۆیە خۆم نەگرت و بەرەو كەركووك بەڕێكەوتم".

http://www.milletpress.com/kurdistan/post_detail.php?id=8100

بەڤیدیۆ : پێشمەرگەیەك دوای رزگاربونی: دژەتێرۆر بەراستی بەراستی شەرێكی زۆر قارەمانانەیان كرد بێ... بەڤیدیۆ : پێشمەرگەیەك دوای رزگاربونی: دژەتێرۆر بەراستی بەراستی شەرێكی زۆر قارەمانانەیان كرد بێ وێنەبوو

وه‌كه‌ ئه‌مه‌كێك با هه‌مموان به‌شدار بین له‌یارمه‌تى دانى خێزانى ئه‌م شه‌هیده‌ سه‌ربه‌رزه‌

سڵاو
به‌كار هێنانى Ctrl+F9 ئه‌و فایله‌ى كارى تێدا ده‌كه‌ین، minimize ده‌بێت وه‌ك ئایكۆنێك

شه‌هید (ئامارا ) ئەو کچە ﮔﻪﺭﯾﻼﯾﻪکە کەوتە ﻧﺎﻭ ﻛﻪﻣﯿﻨﯽ ﺗﻮﺭﻛﻪﻛﺎﻧﻪﻭﻩ ﺑﻪ ﺗﻪﻧﻬﺎ ﺧﯚﯾﯽ ﻭ ﺗﻔﻪﻧﮕﻪﻛﻪﯼ ﺩﻩﺳﺘﯽ ﺑﻮﻭ ، ﺭﻭوﺑﻪﺭوﻭﯼ 10 ﭘﯿﺎﻭﯼ ﺗﻮﺭﻙ ﺑﯚﻭﻩﻭ ﺳﯿﺎﻧﯿﺎﻧﯽ ﻛﻮﺷﺖ ﻭ ﺩﻭﺍﻧﯿﺎﻧﯽ ﺑﺮﯾﻨﺪﺍﺭ ﻛﺮﺩ ﺑﻪﻻﻡ ﻟﻪ
ﻛﯚﺗﺎﺩﺍ ﮔﻮﻟﻪﯾﻪﻙ ﺑﻪﺭ ﺳﻪﺭﯼ ﺋﻪﻛﻪﻭێت ﻭ ﺋﻪﭼﯿﺘﻪ ﻛﺎﺭﻭﺍﻧﯽ ﺷﻪﻫﯿﺪﺍﻧﯽ ﺭێگاﯾﯽ ﺋﺎﺯﺍﺩﯼ ﻭ
ﺭﺯﮔﺎﺭﯾﯽ ﻛﻮﺭﺩﺳﺘﺎﻥ
ﯾﻪﻛێك ﻟﻪﻭ ﺳﻪﺭﺑﺎﺯﻩ ﺑﺮﯾﻨﺪﺍﺭﻩ ﺗﻮﺭﻛﺎﻧﻪ ﺑﻪ ﺭﯙﮊﻧﺎﻣﻪﯼ ﺗﻮﺭﻛﯽ ﺩﻩﯾﻠﯽ ﻧﯿﻮﺯﯼ ﺭﺍﮔﻪﯾﺎﻧﺪﻭﻩ :
ﺳﻪﯾﺮﻡ ﭘﺊ ﺋﻪﻫﺎﺕ ﻛﻪ ﺋﻪﻭ ﻛﭽﻪ 17 ﺳﺎڵە ﺑﻪﻭ ﺷﯿﻮﻩﯾﻪ ﺭﻭوﺑﻪﺭﻭﻣﺎﻥ ﺑﯚﻭﻩ ﻟﻪ ﻛﺎﺗێكدا ئێمە دڵنیا ﺑﻮﯾﻦ ﻛﻪ ﺑﻪﺱ ﺗﻔﻪﻧﮕﯽ لێ‌ ﺭﺍﺑكێشین ﺩﻩﺳﺖ ﻭ ﺋﻪﮊﻧﯚﯼ ﺋﻪﺷكێت ﺑﻪﻻﻡ
ﺯﯙﺭ ﺷێرانە ﺭﻭﻭﺑﻪﺭﻭﻣﺎﻥ ﺑﯚﻭﻩ ﻟﻪ ﻛﭽﯽ ﻧﻪ ﺋﻪﻛﺮﺩ ﭼﻮﻧﻜﻪ ﻛﭽﻪﻛﻪﯼ ﻣﻦ ﺑﻪ ﺑﯿﻨﯿﻨﯽ
ﺳﯿﺴﺎﺭﻛێك ﺷﻪﻭ ﻫﻪﺗﺎ ﺑﻪﯾﺎﻧﯽ ﺩﻩﺳﺖ ﺋﻪﻛﺎﺕ ﺑﻪ ﮔﺮﯾﺎﻥ

ياخوائه وه‌ى ئه‌م كاره‌ى كردووه ريسواى دنياو قيامه‌تى كه‌يت ؟ئه‌گه‌ر تۆش خۆت
به‌موسڵمان ئه‌زانى بڵێ ئامين .. ... ... .. .

پارێزه‌رانى وڵات

قوتابییه‌ خۆشه‌ویسته‌كانم له‌ پۆلی یه‌ك
ده‌توانن لێره‌ هه‌رچى پرسیارتان هه‌یه‌ ده‌توانن بیكه‌ن و وه‌ڵامتان ده‌ده‌مه‌وه‌

قوتابییه‌ خۆشه‌ویسته‌كانم
دووشه‌ممه‌ تاقی كردنه‌وه‌ى عه‌مه‌لىه‌، تكایه‌ به‌ته‌ركیز بخوێنن و هه‌وڵ بده‌ن ته‌واوى لایه‌نه‌كانى پرسیاره‌كان تێبگه‌ن بۆ ئه‌وه‌ى سه‌ركه‌وتوو بن.

تكایه‌ هاوڕ‍ێیان و قوتابیانى خۆشه‌ویستم تكایه‌ لایكى بابه‌ته‌كانى ئه‌م په‌یجه‌ بكه‌ن و گه‌ر ده‌توانن كۆمێنت بنووسن بۆ ئه‌وه‌ى بتوانن بابه‌ته‌كانى ببینن، ئێستا ئه‌م په‌یجه‌ زۆر ئه‌كتیف نیه‌و پێویستى به‌ یارمه‌تى ئێوه‌یه‌