أسئلة ومراجعة للحاسب الآلى الصف الثانى الاعدادى ترم ثانى لغات

Question (1): Choose the correct answer:
1- Excel Files are known as…. (Workshop-worksheet-workbook-work file).
2- Every workbook by default contain ………….. (two-three-four-five)
Sheets.
3- The default name of your Excel files until you save it with a name of
Your choice is ………….. (Workbook1-sheet1-workbook1-book1).
4- Excel is ………………. (presentations-slides-sheets-spreadsheets)
Program.
5- To edit contents of a cell, you ……………… (Single click-double click-
right click-left click) or press ……. (F1-F2-F3-F4) from the keyboard.
6- Excel worksheets contain…………… (256 rows-30256 rows-3020, 000
Rows-65,536 rows).
7- To save changes to a workbook, use ……….. (Save As Command-open
Command-save command-more workbook command).
8- We can rename the sheet by using the ……….. (Shortcut -cell-sheet-file) menu or from ……………… (File-Edit-View-Format) and formatting the cells from choosing (Cells-Sheets-Columns-Rows) from format menu in the menu bar.
9- In the 24 hour system 17:00 means ……..(4:00-7:00-5:00-5:00AM-5:00PM)

Question (2): Complete each sentence with a suitable answer:
1- Sheets are composed of ………. &………………
2- The intersection of a column and row is called a …………….
3- ………………………… can be entered into cells.
4- Examples of bars that appear by default ………,………..
5- …………is the bar which displays the contents of the active cell, but ……….displays the name of the active cell.
6- Columns are labeled with …………..but rows are labeled with………….
7- Excel contains ………columns identified for ………rows.
8- A cell is referred to by its …………which is the column ……….followed by the row …….. e.g.……….,…………,……….
9- Cells can contain one of four types of values:
• …………………………..
• …………………………..
• ………………………….
• ………………………….
10- After finishing typing the contents of the cell, you press ……. To finish or …………to cancel what you edited.
11- If you want to insert cells, rows, columns, you click on………….from the ……..bar, Insert window will be opened for four choices ………….,…………,……….,………….
12- To select a range of cells, hold down…………….key which you can choose the selected cells.
13- To choose an entire row or column, we click the row or column …………
14- We can rename the sheet by selecting ……..from………..shortcut menu.
15- You can change the height of a row by selecting ………. From ………. shortcut menu.
16- You can change the cell font style by selecting …….from …….shortcut menu.
17- You can hide a sheet from format menu by selecting …..From the menu bar and from the…………..we select……….
18- You can choose auto selection to a column from ……….menu and selecting ….and then…………from the submenu.
19- You can use operators inside the formula such as …….. ,………….. ,……. ,…….
20- To rise to the power of number or result, we use……… and the symbol for it is ………
21- If you want to know from marks table, the student's mark who had the best mark in a class in Excel. We use…….function.

Question (3): Answer the following questions:
1- What is Microsoft spreadsheet Excel?
2- When do you use spreadsheet Excel?
3- How to open Excel program?
4- What is a workbook?
5- How can you navigate in a workbook?
6- What is the action for every task you are asked to perform.
• Up one cell
• Left one cell
• Up one screen
• To go to the beginning of the current row
• To go to the first cell in the worksheet.
7- What action will happen if you press...
• [CTRL] + [Down Arrow] ↓
• [CTRL] + [Up Arrow] ↑
8- What are the steps to save your worksheet?
9- What is the difference between closing a file and exiting excel?
10- What are the benefits of using the formula?
11- What is the function to have the middle number between two numbers?

Question (4) put right (√) for the right answer or wrong (x) for the false and correct:
1- The result of 8+2 x 3 = 30 ( )
2- COUNTA Function counts the number of the cells, even if some are empty. ( )
3- To have the summation of the two cells C3, C4, we type in the formula bar Sum (C3:C4). ( )
4- If you want to know the youngest student between many students using table contain the students age, we use Min function to do so ( )
5-The result of 3*(2+5) =21 ( )
6-A workbook normally contains one worksheet ( )
7-Excel contains built in functions to enable an easy and quick work performance ( )
8-To change the height of the row select it and choose width from format menu. ( )
9-A cell is the result of the intersection of a row and column. ( )
10-To hide a work sheet select it then choose delete from the
Shortcut menu ( )
11- 734 are data of text .
12-The headers of columns are numbers ,while the headers of rows are letters. ( )
13-To move the cursor to the first cell in the column press the ctrl + ( )
14- To move the cursor to the first cell in the current row press End. ( )
15- To move the cursor to the first cell A1 in the sheet press ctrl +home ( )

Question 5 complete the following:

Question 6 Match column (A) with column (B):
( A ) (B)
1-SUM to find the” average”
2-AVERAGE to find the “Minimum value”
3-MAX to find the “Sum”
4-MIN to find the number of cells not empty
5-COUNTA to find the “ Maximum value “

Question 7 to format cells,choose the appropriate tab from the format cells window.
Match column (A) with column (B):
( A ) (B)
Number to change the “font” format
Alignment to set a pattern in a cell
Font to change the “time” format
Border to merge and center cells
Pattern to add “borders”
Question 8:
In the previous figure:
1-which cell is activated?
2-Write the formula of the sum of Mohamed’s total marks.
3-what is the name of the activated worksheet?
Question (1):
1- workbook
2- three
3- book1
4- spreadsheet
5- double click - F2
6- 65,536 Rows
7- Save Command
8- Shortcut - Format -Cells
9- 5:00 PM
Question (2): Complete each sentence with a suitable answer:
1. Rows-Columns
2. Cell
3. Text, Number, Date, time
4. Menu bar, title bar
5. Formula bar - Name box
6. letters - numbers
7. 256 - 65,536
8. address – letter - number - A1,B5,Q37
9. text – numbers- date & time- formulas
10. Enter Esc (Escape button)
11. Insert menu - shift cells right, shift cells down, Entire row, Entire column.
12. shift
13. header
14. rename sheet
15. row height row
16. formatting cells cells
17. format hide
18. format column auto selection
19. + , _ , / , *
20. exponential , ^
21. MAX
Question (3): Answer the following questions:
1. Excel is a popular spreadsheet program designed for use on a personal computer.
2. a) whenever we're doing work that involves calculation with rows or columns of numbers
b) Excel makes the tasks easier
C) We can automatically generate charts in a variety of formats from date in an Excel spreadsheet.
3. a) Click the start icon button on the taskbar.
b) From programs menu select Microsoft Excel.
4. The excel desktop has a multitude of taskbars .there are certain toolbars such as: menu bar, standard bar, formatting bar, and formula (function) bar.
5. At the bottom of the workbook window where the sheet tabs are located are a number of controls you can use to move from worksheet to worksheet within a workbook.
6. a- [Up Arrow] ↑ b- [Left Arrow] ← c- [Pg Up] d-[Home]
e- [CTRL]+[Home]
7. a) Go to the last cell in the current column.
b) Go to the first cell in the current column.
8. a) Click on save icon button on the standard bar.
b) Select the disk drive and folder you wish to store your files in.
c) Type a file name
d) Click save button (the name appears in the title bar).
9. To close a file : 1- click file on the menu bar and select close .OR
Pressing on x button on the upper right corner of the worksheet.

To close Excel
- Click on close button on the Excel program.
- Or Click File from menu bar and click Exit.
10 - When using a formula in your spreadsheet, the function will be shown and calculated automatically, the formula must begin with equal sign (=). And the results will be changed according to any change to the data.
11- The green check mark in the formula bar indicates if the function (formula) is accepted and applied. But if we pressed on the red checkmark that will cancel the formula.
12- AVERAGE.
Question (4): put (√) for the right answer, and correct the
Wrong one.
1- (X) =14
2- (X) COUNTA function doesn't count the empty cells.
3- (X) =Sum (C3:C4)
4- (√)
5- (√)
6-(X) A workbook normally contains three worksheets by default
7-(√)
8-(X) To change the height of the row select it and then choose row from format menu, then choose Height
9- (√)
10--(X) To hide a work sheet select it then choose hide from the
Shortcut menu.
11- (X) 734 are data of numbers .
12-(X) The headers of columns are letters, while the headers of rows are numbers.
13-(√)
14- (X) To move the cursor to the first cell in the current row press home
15-(√)
Question 5 write what are those numbers refer to

Question 6 Match column (A) with column (B):
(A) (B)
1-SUM to find the” average”
2-AVERAGE to find the “Minimum value”
3-MAX to find the “Sum”
4-MIN to find the number of cells not empty
5-COUNTA to find the “ Maximum value “


Question 7 to format cells,choose the appropriate tab from the format cells window.
Match column (A) with column (B):
( A ) (B)
Number to change the “time” format
Alignment to merge and center cells
Font to change the “font” format
Border to add “borders” to cells
Pattern to set a pattern in a cell
Question 8
1- G3
2- SUM ( C4:E4)
3- Third week