اسئله الاكسل الفرقه الثانيه

للتجميل اضغط هنــــــــــــــــــــــــــــــــــــــــا

1- Create a new, blank work book
2- Open the ECDL.xls workbook that is in My Document folder
3- Save this workbook (which is currently a Microsoft Excel 2000 file) in a format suitable for users with a previous version of Excel
Note: Don't change the file location
4- Use Microsoft Excel help to access information on advanced filter
5- Change the user name of this application to Sangor
6- Enter the value 416 in cell E58 Click any other cell when you finish
7- Click on the location that selects all the cells in row 5
8- You wish to reverse the last changes that you have made to this work sheet Choose the appropriate command to do this.
9- Automatically adjust the height of row 94 to fit its tallest content.
10- Change the content of cell D114 to the word Cost Press Enter when you have finished.
11- Copy the selected range and past it cell A1 in the worksheet entitled Osman in this work book
12- Clear the content of cell B3 without deleting the cell
13- Use the replacement tool to replace all words ECDL with ICDL
14- Automatically sort this list so that the highest mark displays at the top of the list
15- Insert a new work sheet into this workbook
16- Move the Osman worksheet into Elsangary workbook so it will displays after the other worksheet
17- Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?
a. =B5+B11
b. =SUM(B5:D5)-SUM(B11:D11)
c. =B5-B11
d. =AVERAGE(B5:D5)-AVERAGE(B11:D11)

18- If the enter key was pressed to accept the formula in cell B9 which of the following would be the result:
a. A #REF! Error message
b. A #VALUE! Error message
c. A #NAME? Error message
19- Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco Company and if it copied down automatically calculate the Total Cost for all the other customers.
a. =B3*C1
b. =B3*$C$1
c. =$B$3*$C$1
d. =$B$3*C1
20- Which formula entered into B5 will calculate the total Cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?
a. =Sum($B$2:$B$4)+B8
b. =Sum(B2:B4)+$B$8
c. =Sum(B2:B5)+$B$8
d. =Sum(C2:C4)+$C$8
21- Type a function into cell B7 that smallest value in the highlighted range. Press the enter key when you have finished.
22- Which formula entered into B10 would calculate the total amount of a rainfall that fell in the seven days?
a. =SUMB3:B9
b. =SUM(B3:B9)
c. =(SUM)B3:B9
d. SUM=(B3:B9)

23- Which formula would display into Pass in cell C2 if the mark is over 74, and Fail if not.
a. =IF(B2>74,Pass,Fail)
b. =IF(C2>74,”Pass”,”Fail”)
c. =IF(B2>74,”Pass”;”Fail”)
d. =IF(B2>74,”Pass”,”Fail”)
24- Add a border round the selected range. Note: Don't change the default line style
25- Change the white background of the chart to yellow
26- Use click and drag to select the range A2:C6
27- Change the display of the numbers in the selected range from no decimal place to one decimal place.
28- Apply the pound (£) currency symbol to the selected range
29- Format the content of the selected cell into Bold.
30- Copy all the formatting from cell C3 to the cell E3
31- Change the orientation of the text to in the selected cells to vertical (90 degree)
32- Select the range from cell A1 to D5 Launch the chart wizard, and choose the pie chart Click Finish to Submit your answer
33- Duplicate the selected chart into cell A1 of the Marketing worksheet
34- Change the column chart into pie chart.
35- Increase the measurement of the top page margin from 2.5 to 3 centimeters
36- Adjust the page setup so that the entire content of this worksheet will fit on one page wide by 3 pages tall
37- Insert the file name into the center section of the header for this worksheet.
38- Change the settings for this worksheet so that the gridlines will print
39- Print the selected chart
40- Save a copy of this workbook with the new name account
note: Don't change the file location.
41- Delete row 4 from that worksheet
42- Change the name of the worksheet from sheet1 to Costs
43- Enter the formula in cell D4 that would calculate the pre-tax Salary for Cathy Miller Press Enter when you have finished.
44- If the enter key was pressed to accept the formula in cell E9, Which of the following would be the result:
a. A #REF error message
b. A #Name error message
c. A #VALUE error message
d. A #Circular Reference error message
45- If row 4 was deleted, Which formula will then be in cell B6
a. =SUM(B3:B6)
b. =SUM(B3:B5)
c. =SUM(B3:B7)
d. =B3+B4+B5
46- Which formula entered into cell E2 would calculate the total cost (including delivery) of the Barbados garden suite and, if copied down, would automatically calculate the total cost for the other two garden suites
a. =SUM(B2:D2)+$B$6
b. =SUM(B3:D3)+$B$6
c. =SUM($B$2:$D$2)+B6
d. =SUM(B2:B4)+$B$6
47- Drag each x to a cell in this worksheet that contains an error.
48- Print just the range D2:G5 selected in this worksheet.
Note: This is a simulation - You don't need to have printer.
49- Type a formula into cell G8, which uses an appropriate function to calculate the total of the highlighted range.
50- Which formula entered into cell E12 would calculate the number of recorded rainfall reading taken over 3 weeks?
a. =NUMBER(B4:D10)
b. =COUNT(B4:B10)+(C4:C10)+(D4:D10)
c. =COUNT(B4:D10)
d. =NUM(B4:D10)

51- Dragging the fill handle up to cell B3 with:
52- Which two of the following would calculate the amount left to spend for March?
a. =D8-D11
b. =D12-D8
c. =SUM(D4:D7)-SUM(D10:D11)
d. =(D10:D11)-SUM(D4:D7)
e. =SUM(D10:D11)-SUM(D4:D7)
53- Change the alignment of the selected titled El-Ahly is the best team so that it is centered horizontally over B , C and D
54- If the formula in B7 is copied into cell D7, which formula will display in the formula bar when D7 is selected?
a. =SUM(B3:B5) - B6
b. =SUM(C3:C5) - C6
c. =SUM(D3:D5) - B6
d. =SUM(D3:D5) - D6
55- Which formula entered into cell B10 would find the heaviest rainfall in seven days?
a. =MAXIMUM(B3:B9)
b. =(MAXB3:B9)
c. =MAXIMUM(B3:B9)
d. =MAX(B3:B9)
56- If the enter key was pressed to accept the formula in cell E8, What would appear in the cell?
a. A #REF!
b. A #DIV/0!
c. A #VALUE?
d. A #NAME?
57- Apply the percentage style to the selected cells
58- Delete the selected chart from this worksheet.
59- Preview the worksheet to see how it will look when printed.
60- View the above worksheet at 75% of it full size.
61- Insert a blank row above row 4.
62- Automatic adjust the width of column B so that it's width cell contend’s fully visible.
63- Dragging the fill handle down to cell A4 will fill A4 with:
a. HH 2
b. HH 4
c. HH 7
d. HH 5
64- Which one of these combinations is used to indicate that cell C1 has an absolute reference?
a. #C#1
b. $C$1
c. /C/1
d. @C@1
65- Which formula entered into B10 would find the average amount of sun shine for March to September.
a. AVERAGE=B4
b. =AVE(B3:B9)
c. =AVERAGE(B3:B9)
d. =(AVE)B3:B9
66- Change the formatting for the selected range so the dated will display in this format: 04-Jan-01
67- Change the formatting so the selected text automatically wraps into the second line within the cell.
68- Change the page orientation so that this worksheet will print on a page that is wider than it's tall.
69- Save this workbook as text file.
Note: Don't change any other setting.
70- Freeze both the column A and row 1 in this worksheet OR Make column A and row 1 showing all of the time in this worksheet
71- Insert a new column between column C, D
72- Close the workbook without closing the application.
73- Display the drawing toolbar in the Microsoft excel application window.
74- Change setting to make row 1 printed in all of the page
75- Cut selected range and past it in cell A1 in workbook entitled sangor which ready