Question

please help me to solve the following question ASAP .

Create MS Word document with the following requirements. You final out should look like the file "Formatted.docx”. Use the content of the file "Text.docx” and “Icon.png" as source files. 1) Configure the page before typing. a) Page direction b) Page border c) Water mark. 2) Insert page number 3) Insert header & footer. 4) Font size is 13 point 5) Insert the picture attached 6) Insert the table 7) In the first paragraph make indent by "1.2 cm" for the first line. 8) In the last paragraph, change the letter case to capital letter. 9) On the table delete the last column. 10) Use replace command to replace exclamation Mark " !" with"." dot. 11) Check spelling and grammar. 12) Answer the question: You can save MS word document as .pdf. (True False I) Create MS Excel document with the following requirements: 13) Create spreadsheet files with the following Contents; А в с E 1 N If Total Salary < BD 500, Promotion 4 5 6 7 8 9 10 11 12 Employee Records No. First Name Last Name Age Experience Salary 1 Ali Ebrahim 27 7 BHD 500.765 2 Eman Salah 34 13 BHD 450.000 3 Yousif Jassim 29 11 BHD 700.000 4 Ahmed Khalil 20 1 BHD 350.658 5 Fatima A Rahman 25 6 BHD 800.000 Sum: Max Average: Figure (1) - Spreadsheet structure

source files :-

Answer 1

Aswer -1: MS Word

1. As directed before typing the content into MS Word fist setting the page here in question it says to configure the following

a) Page Direction - In MS word we have page orientation we have two types Portrait and Landscape - here we are using portrait that we can se in the Layout ribbon > page setup group > Orientation > Portrait

AutoSave Off Hc Document2 - File Home Insert Draw Design Layout Refere Indent Breaks 2.- Line Numbers Margins Orientation Size Columns bc Hyphenation + Left: 0 cm + Right: 0 cm KI Portrait | 12 | 1 1.2 Landscape

b) Page Border - we can set the page border under design ribbon > background group > page border check the screen shot below

AutoSave Off H5 07 Document2 - Word Search Sign in Х File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Aa Title TITLE Title Title TITLE Title Title Title Title Paragraph Spacing v TITLE A DI Heading 1 HEADING1 1 HEADING 1 Heading 1 Heading 1 On theerth, the galleriesidade teman digned to write with the work of your document Weledes festes.be Heading 1 On the the galleries er heledonte with the overall look of your document. Effects Heading 1 Themes www HEADING 1 On these this include tertutas de este with the wall of your deve Suches ertesi the overall of your doorstrom terged to ordinate with the roof your du Heading 1 On the theaters Budged to create with the overall look of your documen che presteert table.header.foten, Heading 1 temthede with the work of your de You can use these palleriestert Colors Fonts dodhte foten om and We leader.foten, Set as Default Watermark Page Color Page Borders Page Background Document Formatting '1:1:1:21:31:41:5161:7:1:81:9: | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18 L 2,1 Borders and Shading ? х Borders Page Border Shading Select the line style Setting: Style Preview None Click on diagram below or use buttons to apply borders 4.1.3:1121111111 1111112 Box Select the box type or shadow type as per ur requirement Shadow Color: 3-D Automatic Width: TO Custom 1/2 pt 9.1.8.1:7 Apply to: Whole document Art: (none) click ok Options... OK Cancel .12 | 11: 1.10 Page 1 of 1 O words English (United Kingdom) FO C Focus 83% T 01 . W ENG 23:21

C) Water Marks - Setting water mark also in the same group check the screen shot below

AutoSave Off 5 Document2 - Word O Search Sign in 0 x File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Аа TITLE Title Title TITLE Title Title Title Title TITLE Title Heading 1 On tieteesee terthute denigsed to coordinate with the wood of your document Paragraph Spacing Effects HEADING 1 Heading Heading 1 On Feeder σε αυτη ταινια Heading 1 On the users the galleriesindade terlaget with the overall look at your rent Heading 1 А Colors Fonts HEADING 1 On the inertia, the parkerindude tentang tower with the real look of your doorst Themes testet wees.codiste with The overall of your doors.com 1 HEADING 1 On the others the Samuter.de You can use the gallerbeste bort Heaven On the inters, there that are designed to coordinate with the wake of your document Scheresteert table, henden.footen, cover terthute denigsed to coordinate with the wall of your dren Toucheriestart Heading 1 Wheader.foten, That reed to wards with the Set as Default Watermark Page Page Color Borders Document Formatting | 21:11 11:1:1 2:1 3:1 14:15:1:61:7:18:1:9. | 10 | 11 | 12 | 13 | 14 | Confidential L when u click this confidential watermark will appear WILNEGIANO CONFIDENTIAL DO NOT COPY CONFIDENTIAL 4.1.3.1.2.1.1.1. 11111112 CONFI CONFIDENTIAL 1 DO NOT COPY 1 "CONFIDENTIAL" watermark with gray diagonal text DO NOT COPY DO NOT COPY 2 More Watermarks from Office.com If you need custom water mark click here and type as per your requirement you can also upload image as custom watermark Custom Watermark... 0 Remove Watermark 12. 11. 1.10 Save Selection to Watermark Gallery... Page 1 of 1 O words English (United Kingdom) EO C Focus + 83% 朗 T Q Ax 1 ENG 23:26

2) Insert Page Number - check the screen shot below

AutoSave Off 5 07 Document2 - Word Search Sign in Х File Home Insert Draw Design Layout References Mailings Review View Help Header & Footer Share Comments To Shapes Header SmartArt l Chart Get Add-ins Cover Page Blank Page Page Break A W Wikipedia Link Bookmark Cross-reference TT Equation Symbol Icons Footer V 시 Table Pictures Comment My Add-ins Online Video Text Box V 3D Models Page Number Screenshot 0 Pages Tables illustrations Add-ins Media Links Comments Top of Page Symbols L 2:1:1:11 1:1:1:4 Simple Bottom of Page Plain Number 1 #Page Margins 1. Go to Insert Ribbon 2. Header and Footer Group 3. Click Page Number 4. Selet Bottom of Page 5. Click the Plain Number 3 Current Position > Format Page Numbers... Remove Page Numbers Plain Number 2 2:111111111111121113111411511611171118111911110111111 | 12 | Plair Number 3 Plain Numbers More Page N Number with no formatting or accents Footer Save Selection as Page Number (Bottom) 1 Page 1 of 1 O words English (United Kingdom) EO C Focus 83% 朗 T ENG 23:30 .

3) Insert Header & Footer:

First Will insert Header at the center

AutoSave Off HD v Document2 - Word Search Sign in Х File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Shapes SmartArt V Header v W Get Add-ins TT Equation Cover Page Blank Page Page Break Icons la Chart Link Bookmark El Cross-reference Builta Table Pictures Wikipedia Comment My Add-ins Online Video 3D Models Screenshot Blank Pages Tables illustrations Add-ins Media Links Comments L 2:1:1 11111 2:13 4:15:16:17:18:1:9 | 10 | 11 | 12 | 13 | 14 | [Type here] Blank (Three Columns) 1. Go to Insert Ribbon 2. Click Header drop down 3. Click Edit Header 4. Type the header at center alignment Bahrain Kingdom BIT MS Word L-1 111211111111111112 [Type here) [Type here) [Type here] Austin (Document title] More Headers from Office.com Edit Header 0 Remove Header @ Save Selection to Header Gallery... 12: | .11. | .10 1.9.1.8: 1.7 Page 1 of 1 O words D English (United Kingdom) EO Focus + 83% ENG 23:35 Q

Then will insert Footer

AutoSave Off 07 Document2 - Word Search Sign in Х File Home Insert Draw Design Layout References Mailings Review View Help Header & Footer Share Comments o Shapes V e Cover Page » Blank Page Page Break SmartArt l Chart Get Add-ins W Wikipedia Link Bookmark Cross-reference TT Equation 2 Symbol Icons Footer A- Table Pictures Comment Taut My Add-ins Online Video 3D Models Screenshot Built-in Pages Tables Illustrations Blank Add-ins Media Links Comments 1.1.1.2.1.3 | .4 | .5 || 6:|:7:18:1:9: | 10 | 11 | 12 | 13 | 14 | | 2:1:1:1 [Type here) 8111911.10., 11., 12., 13 Blank (Three Columns) Insert Ribbon Footer Edit Footer [Type here) [Type here) [Type here) Here already there is page number at the right alignment so first you have to make that to left align - select page number - Ctr+L - tab - tab Austin then use arrow key to come to the left section to type the footer needed More Footers from Office.com Edit Footer 111111111111121113111411.5.11. E Remove Footer Footer Save Selection to Footer Gallery ... 1 Exam © - 01/01/2010 (+973-17000000) Page 1 of 1 O words English (United Kingdom) EO C Focus 朗 83% T ENG 23:42 .

Will type the content into the newly created ms word document and then format the rest

4) Font size is 13 - chk the screen shot

AutoSave Off HU Document2 - Worc File Home Insert Draw Design Layout References X Cut Times New Romat 13AA Aav po Paste Copy Format Painter BI U v ab X, X APA- 12 Clipboard Font | 2:1:1:11 11

5) Insert the Image - Go to insert ribbon > Cilck Picture button > click This device > select the file

AutoSave Off ni 07 Document2 - Word Search Sign in Х File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Header E Get Add-ins A Cover Page Blank Page Page Break Shapes v Icons 3D Models SmartArt Chart Screenshot W Wikipedia Link Bookmark El Cross-reference TT Equation Symbol Footer Table Pictures Comment Online Video My Add-ins A- AE Text Box Page Number Pages Tables Add-ins Media Links Comments Header & Footer Text Insert Picture From Symbols L 11:1:1 1.1.1 2 3. | 14: | .5 || 6:17:18|| 9: | 10 | 11 | 12 | 13 | 14 | 15 | | 17 | 18 E This Device... Ed. Stock From File to Online Bahrain Kingdom BIT MS Word L-1 3.1.2.1.1111 11111112 Insert pictures from your computer or from other computers that you're connected to. olan Tell me more ck Road! Newton, MA 02158 February 27,2003 25.h Anniversary Dear Ms! Nolan, Thank you for inquiring about a Burke listing! The goal of OGC Properties is to provide the best customized and diverse service to our clients! We realize that quality service is the key to our success! We strive ti earn your respect through an honest, fair, and direct approach to your estate needs! Here's what a realtor does for you: Works to get the top dollar for your property Locates pre-screened prospects Arranges marketing expertise at no extra cost Makes your home more sellable Arrange financial assistance for the buyer 12 | .11. | .10 You will receive a “Next Steps” packet in the mail shortly, outlining our services! I hope you find this information useful as you plan your home purchase! Please stop by the Boston office when you are ready to proceed! I look forward to meeting you! Page 1 of 1 227 words BY English (United Kingdom) EO C Focus 83% ENG 23:53 Q

6) Insert Table

AutoSave Off ni 07 Document2 - Word Search File Home Insert Draw Design Layout References Mailings Review View Help Cover Page » Blank Page To Shapes Header SmartArt l Chart Icons Get Add-ins W My Add-ins v Wikipedia Link Bookmark El Cross-reference Footer Table Pictures Comment Page Break Online Video 3D Models Screenshot 0 Page Numbe Pages ns Links Insert Table Comments Header & Foote 9: | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18 Add-ins Media 12:1:1:1:1:1:1:21:31:41:51:61:7:1:8 Arranges marketing expertise at no extra cost Makes your home more sellable Arrange financial assistance for the buyer 13. 1.12 | 11 | 10:1:9 OND You will receive a "Next Steps” packet in the mail shortly, outlining our services! I hope you find this information useful as you plan your home purchase! Please stop by the Boston office when you are ready to proceed! I look forward to meeting you! Your truly, 14 Insert Table... 1 Draw Table Gl Convert Text to Table... Cindy Bradley Executive Property Manager OGC Properties, Inc! Boston Branch | 19 | 18 | 17 | 16 | 15. E Excel Spreadsheet Quick Tables > Work Time: Sunday 8 am - 5 Monday 8 am - 5 pm Tuesday 8 am - 5 pm Wednesday Thursday 8 am - 5 8 am - 5 pm pm Friday 8 am - 5 pm pm "11 1 1

7) First Line making indent of 1.2 cm

AutoSave Off UZ Document2 - Word Search Sign in File Home Insert Draw Design Layout References Mailings Review View Help Share Comments of Cut Paragraph ? Х Times New Roma 13 ~A Ň Aar po Evvv E >पा पार AL 1 Aa [Copy Paste BI U vab x, XA PA Indents and Spacing Editor ne and Page Breaks V Format Painter General Clipboard Font Editor Paragraph 3: | 14:15:16:17:18:19: 110 | 11 Alignment L Left | 2 1 1:1:: 2 Outline level: Body Text Collapsed by default Direction: Right-to-left Left-to-right Ms! Beth Nolan 150 Frederick Road! Newton, MA 02158 February 27,2003 Indentation · 4.1:31:2:1:1:|| Before text: 0 cm Special: ву: Dear Ms! Nolan, After text: 0 cm First line 1.2 cm Mirror indents Keep the cursor here Thank you for inquiring about a Burke listing! The go provide the best customized and diverse service to our client service is the key to our success! We strive ti earn your respe and direct approach to your estate needs! Spacing Before: O pt Line spacing: At: After: Opt Single Don't add space between paragraphs of the same style Here's what a realtor does for you: Works to get the top dollar for your property Locates pre-screened prospects Arranges marketing expertise at no extra cost Makes your home more sellable Arrange financial assistance for the buyer Preview Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph Previous Paragraph 15. 1.14 1.13| .121.11 | 10:119:1:8 You will receive a "Next Steps” packet in the mail shortly, o hope you find this information useful as you plan your home the Boston office when you are ready to proceed! I look forw Thank you for inquiring about a Burke listing! The goal of OGC Properties is to provide the best customized and diverse service to our clients! We realize that quality service is the key to our success! We strive ti earn your respect through an honest, fa Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Following Paragraph Your truly, Tabs... Set As Default OK Cancel Cindy Bradley Executive Property Manager Page 1 of 1 227 words BY English (United Kingdom) EO C Focus DO 83% 1 Q e ENG 00:00

8) Last Paragraph capital letter case

AutoSave Off ni U7 Document2 - Word Search Sign in x File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Times New Roma 13 ~An AC Aar) Po Ev E >99 AL X Cut Lo Copy Format Painter AaBbccDc AaBbCcDc AaBbcc Aabbccc AaB 1 No Spac... Heading 1 Heading 2 Find Sc Replace W Select Paste B I U v ab x, x? A Sentence case. 1 Normal Editor Title v lowercase Clipboard Font Editing Editor Paragraph Styles 1:51:6:17:|:81:9 | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18 L | 2:1:1 UPPERCASE Capitalize Each Word TOGGLE CASE Newton, IVIA UZIJO February 27,2003 25ch .4.1:31:2:1:11|| Anniversary Dear Ms! Nolan, 1.6.1.5 Thank you for inquiring about a Burke listing! The goal of OGC Properties is to provide the best customized and diverse service to our clients! We realize that quality service is the key to our success! We strive ti earn your respect through an honest, fair, and direct approach to your estate needs! Here's what a realtor does for you: Works to get the top dollar for your property Locates pre-screened prospects Arranges marketing expertise at no extra cost Makes your home more sellable Arrange financial assistance for the buyer 10. 1:9 11. Select the paragraph and then You Will Receive A “Next Steps” Packet In The Mail Shortly, Outlining Our Services! I Hope You Find This Information Useful As You Plan Your Home Purchase! Please Stop By The Boston Office When You Are Ready To Proceed! I Look Forward To Meeting You! - 15. | .14. | .13. | 12 Your truly, Cindy Bradley Page 1 of 1 45 of 227 words K English (United Kingdom) EO C Focus DO 83% 1 Q E о ENG 00:02

9) Delete last column of table

AutoSave Off bi 07 Document2 - Word Search Sign in х File Home Insert Draw Design Layout References Mailings Review View Help Table Design Layout Share Comments A Draw Table Eraser 10 0.64 cm h Select View Gridlines Properties of Distribute Rows Merge Cells Split Cells Split Table À J Repeat Header Rows Convert to Text fx Formula Delete AutoFit Sort Insert Insert Insert Insert Above Below Left Right 2.65 cm Distribute Columns Text Cell Direction Margins Alignment Table Draw DX Delete Cells... Data 116 | 17 | 18 х Delete Columns Merge Cell Size |:|:1:1:21:31|14|| | .6 | .7 | 8 | 9 | 10 11 | 12 | 1 .14: | 15 Services! I Hope You Find This Information Useful As You Plan Your Home Purchase! Please Stop By The Boston Office When You Are Ready To Proceed! I Look Forward To Meeting You! 2x Delete Rows Delete Table Your truly, Cindy Bradley Executive Property Manager OGC Properties, Inc! Boston Branch 1.26.1.25., 24.1.23.1 22.1.21.1.20 19 18.1.17. 1.16: 1.15.1.14.1.13. 1.12.1 + Work Time: Sunday! 8 am - 5 pm Monday 8 am - 5 Tuesday 8 am - 5 pm Wednesday Thursday 8 am - 5 8 am - 5 pm pm Friday 8 am - 5 pm Select the Column of table pm we are sure that you will be pleased with how oge properties handles your real estate needs that we unconditionally guarantee your complete satisfaction with al our services, or your money back...no questions asked! 1 Exam © - 01/01/2010 (+973-17000000) Page 1 of 1 232 words English (United Kingdom) EO C Focus 83% 朗 Q ENG 00:05

10) Replace "!" with "."

AutoSave Off HD Document2 - Word Search Sign in - Х File Home Insert Draw Design Layout References Mailings Review View Help Share Comments A A Aa A Eve v EE >Iq« AL I of Cut Le Copy Format Painter AaBbCcDc AaBbCcDc AaBb Cc Aabbccc AaB I No Spac... Heading 1 Heading 2 Find Cc Replace Select Paste B IU v ab x, x? A ora 1 Normal Editor Title v Clipboard Font Editing Editor Paragraph Styles 41:5:16:1:71:81:9 | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18. L | .2 1:1:1 2:1 3 | Find and Replace ? Х Ms. Beth Nolan 150 Frederick Road. Newton, MA 02158 February 27,2003 Find Replace Go To .4.1:31:2:1:11|| Find what: v Options: Search Down Dear Ms. Nolan, 7.1.6.1.5 Replace All Find Next Cancel 15. 1.14 1.13| .121.11 | 10:119:1:8 Thank you for inquiring about a Bui Replace with provide the best customized and diverse se service is the key to our success. We strive and direct approach to your estate needs. More >> Replace Here's what a realtor does for you: Works to get the top dollar for your property Locates pre-screene Microsoft Word Х Arranges marketing Makes your home m We made 13 replacements. Arrange financial as ? Do you want to continue searching from the beginning? You will receive a rvices. I hope you find this in Yes se stop by the Boston office whitır you art itawy IV CU. I IUUN IUI Waru w mecug you. No Your truly, Cindy Bradley Executive Property Manager Page 1 of 1 227 words BY English (United Kingdom) EO C Focus 83% 1 Q e ENG 00:09

11) Check for spelling and grammer - under review ribbon - editor

AutoSave Off ni UZ Document2 - Word Search Sign in Х File Home B Share Comments Editor BE Thesaurus A) 뺥 가 Next Insert Draw Design Layout References Mailings Review View Help Previous Es All Markup ai Show Markup Read Check Translate Language New Delete Track Aloud Show Comments Accessibility Comment Changes Reviewing Pane Speech Accessibility Language Comments Tracking | 2:1:1:1 11:1:12:13:14 1:51 6:|:7:|:8:19: | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18 Accept Compare Protect Hide Ink Resume Assistant Linked Notes =723 Word Count Proofing Changes Compare Ink Resume OneNote L Editor X Your truly, Total Suggestions 3 Cindy Bradley Executive Property Manager OGC Properties, Inc. Boston Branch Corrections Work Time: Sunday 8 am - 5 pm Monday2 8 am - 5 pm Tuesday 8 am - 5 pm Wednesday 8 am - 5 pm Thursday 8 am - 5 pm Friday 8 am - 5 pm Spelling 1 27.1.26.1.25.1.24., 23.1.221.21.1.20.1.19. 1.18.1.17. 1.16. | .15.1.14. 1.13.1. Grammar 1 We Are Sure That You Will Be Pleased With How Ogc Properties Handles Your Real Estate Needs That We Unconditionally Guarantee Your Complete Satisfaction with Al Our Services, Or Your Money Back...No Questions Asked. Refinements Clarity Conciseness Formality 1 Exam © - 01/01/2010 (+973-17000000) Punctuation Conventions Vocabulary Page 1 of 1 1 of 233 words B English (United Kingdom) EO D. Focus 83% ENG 00:15

12 : Yes we can save MS Word as PDF

Document2 - Word Sign in ? - Х Save As. A Home 个 Desktop New Recent Enter file name here Save B Open Word Document (*.docx) OneDrive Info This PC Save ified Add a Place Save As Browse 12:21 Print Word Document (*.docx) Word Macro-Enabled Document (*.docm) Word 97-2003 Document (*.doc) Word Template (*.dotx) Word Macro-Enabled Template (*.dotm) Word 97-2003 Template (*.dot) PDF (*.pdf) XPS Document (*.xps) Single File Web Page (*.mht, *.mhtml) Web Page (*.htm, *.html) Web Page, Filtered (*.htm, *.html) Rich Text Format (*.rtf) Plain Text (*.txt) Word XML Document (*.xml) Word 2003 XML Document (*.xml) Strict Open XML Document (*.docx) OpenDocument Text (*.odt) Share 18:41 Export 18:39 Transform Close Account Feedback Options E o 4x ENG 00:17

Here is the final Document

Bahrain Kingdom BIT MS Word L-1 25 Ms. Beth Nolan 150 Frederick Road. Newton, MA 02158 February 27,2003 Anniversary Dear Ms. Nolan Thank you for inquiring about a Burke listing. The goal of OGC Properties is to provide the best customized and diverse service to our clients. We realize that quality service is the key to our success. We strive it to earn your respect through an honest, fair, and direct approach to your estate needs. Here's what a realtor does for you: 1. Works to get the top dollar for your property 2. Locates pre-screened prospects 3. Arranges marketing expertise at no extra cost 4. Makes your home more sellable 5. Arrange financial assistance for the buyer You will receive a "Next Steps” packet in the mail shortly, outlining our services. I hope you find this information useful as you plan your home purchase. Please stop by the Boston office when you are ready to proceed. I look forward to meeting you. Your truly, Cindy Bradley Executive Property Manager 0GC Properties, Inc. Boston Branch Work Time: Sunday! Monday Tuesday 8 am - 5 8 am - 5 8 am - 5 pm pm pm Wednesday Thursday 8 am - 5 8 am - 5 pm pm We Are Sure That You Will Be Pleased With How Ogs Properties Handles Your Real Estate Needs That We Unconditionally Guarantee Your Complete Satisfaction with Al Our Services, Or Your Money Back...No Questions Asked. 1 Exam-01/01/2010 (+973-17000000)

Creating MS Excel with the formula inserted as required and the final screen shot is as below

AutoSave Off Book1 - Excel Search Sign in х File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments Insert V Century Gothic - 10 Α' Α' > ale Wrap Text General 5 DX Delete v Paste 翻盃雄 6000 B I U Ideas A Merge & Center Conditional Format as Cell Formatting Table Styles g - %. O Format Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas 114 X fic A B C D E F G Н K M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Employee Records No. First Name Last Name Age Experience If Total Salary < BD Salary 500, Promotion 1 Ali Ebrahim 27 7 BHD 500.765 No Promotion 2 Eman Salah 34 13 BHD 450.000 Promotion 3 Yousif Jassim 29 11 BHD 700.000 No Promotion 4 Ahmed Khalil 20 BHD 350.658 Promotion 5 Fatima A Rahman 25 6 BHD 800.000 No Promotion Sum BHD 2,801.423 Max BHD 800.000 Average BHD 560.285 Sheet1 + Ready EO 140% E ENG 00:28

Formulas used check the screen shot below

AutoSave Off Book1 - Excel Search Sign in X File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments Insert V Century Gothic 10 Α' Α' > ab Wrap Text General 國留 A o 3 Delete Paste Ideas B IU • Merge & Center 6000 .00 Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas H16 X fic A B С E F G J 1 2 Employee Records Experience Salary No. First Name Last Name Age 3 2 Ali Eman Yousif Ahmed Fatima 3 4 5 Ebrahim 27 Salah 34 Jassim 29 Khalil 20 A Rahman 25 If Total Salary < BD 500, Promotion =IF(H4<500,"Promotion",''No Promotion"'). =IF(H5<500,"Promotion","No Promotion") =IF(H6<500,"Promotion","No Promotion") =IF(H7<500,"Promotion","No Promotion") =IF(H8<500,"Promotion","No Promotion") 4 5 6 7 8 9 10 11 12 13 14 15 16. 17 7 500.765 13 450 11 700 350.658 6 800 Sum =SUM(H4:48) Max =MAX(H4:H8) Average =AVERAGE(H4:H8) Sheet1 + Ready . o FO 140% E ENG 00:29