Step 1 of 21 - Question 1 4% Name* First Last Address* City State / Province / Region ZIP / Postal Code AfghanistanÅland IslandsAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBonaire, Sint Eustatius and SabaBosnia and HerzegovinaBotswanaBouvet IslandBrazilBritish Indian Ocean TerritoryBrunei DarrussalamBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos IslandsColombiaComorosCongo, Democratic Republic of theCongo, Republic of theCook IslandsCosta RicaCôte d'IvoireCroatiaCubaCuraçaoCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEswatini (Swaziland)EthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHeard and McDonald IslandsHoly SeeHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsle of ManIsraelItalyJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKuwaitKyrgyzstanLao People's Democratic RepublicLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacauMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth KoreaNorthern Mariana IslandsNorwayOmanPakistanPalauPalestine, State ofPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarRéunionRomaniaRussiaRwandaSaint BarthélemySaint HelenaSaint Kitts and NevisSaint LuciaSaint MartinSaint Pierre and MiquelonSaint Vincent and the GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSint MaartenSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth GeorgiaSouth KoreaSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan Mayen IslandsSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks and Caicos IslandsTuvaluUgandaUkraineUnited Arab EmiratesUnited KingdomUnited StatesUruguayUS Minor Outlying IslandsUzbekistanVanuatuVenezuelaVietnamVirgin Islands, BritishVirgin Islands, U.S.Wallis and FutunaWestern SaharaYemenZambiaZimbabwe Country Company NameEmail* Question 1.*If you see ###### in a cell, it means:You have a circular reference formula.You've entered a number incorrectly.The cell is not wide enough.You've misspelled something. Question 2.*Which key do you press (while clicking the mouse) to select two or more nonadjacent cells?CTRLALTSHIFTFn Question 3.*Which function would you use to change text in a cell so the first letters are capitalized? CONCATENATEPROPERUPPERCAPITAL Question 4.*I would like my cell contents to change to red every time a value drops below a certain value. What feature do I use?AutoPaintConditional FormattingAutoFillAutoSum Question 5.*To quickly delete an entire column from a spreadsheet you can:Select all of the data in that column's cells and press Delete on your keyboard.Use AutoDelete button.Right–click on column letter and choose Delete.Consolidate button. Question 6.*To insert an entire row into your spreadsheet, you can:Double-click on a cell and type: "Insert"Cut and paste all of your data to move them down one row. This leaves an empty row where you need the inserted row.Highlight the entire row by clicking the row number. Click the Home tab and select Insert from the Cells group.Right-click at the bottom of your spreadsheet on a cell, and select Insert. Question 7.*In Microsoft® Excel, Save, Save As, Print Preview, Print, Options, and Recent, can be found:Under the Tools menu.Under the Page Layout tab.In the Status Bar.Under the File Tab. Question 8.*I can customize the ribbon in Excel to create my own Tabs and command buttons.TRUEFALSE Question 9.*This graphic is called:The Font dialog box.The Font tab.The Font a group of commands.The Edit Menu. Question 10.*When working with Charts, what is a Data Table?The table of data that appears with details, when you click on an item in your chart.A PivotTable of data that is tied to your chart.A diagram linked to your chart that displays data from another document.A Table that appears at the bottom of your chart that displays the numerical data represented in the chart. Question 11.*I have created a long, detailed worksheet. I would like my first row and my first column to repeat on every page when I print. What feature do I use?View Headings checkbox, in the Sheet Options.Set Print Area in Page Setup.Print Titles in Page Setup.Header & Footer, add headers button. Question 12.*I would like to quickly populate a series of cells with the months of the year without typing all twelve months. What feature do I use?Copy and Paste.AutoFormat.Click-and-drag using the AutoFill handle.Select the cells, right-click and select Insert Months. Question 13.*I would like to create an invoice worksheet that calculates the total price of products sold, shipping and handling, and sales tax in the highlighed cell B5? What Function do I use?AutoSum.The SumProduct function.The Subtotal feature.The If/Then function. Question 14.*I would like to create a drop-down list, where people can select an item from options I have provided. What feature do I use to do this?A Signature Line.A List type Data Validation.Conditional Formatting.Macro. Question 15.*When inserting a header and/or footer, Excel actually takes my spreadsheet into which View?Page Break Preview.Page Layout.Normal.Print Preview. Question 16.*A quick way to visually map what cells are being used in a specific formula, is to select the cell with the formula and:Click the Filter Button.Click the Trace Precedents button.Press CTRL + F on your keyboard.Open the Watch Window. Question 17.*I have created a spreadsheet that lists all of the sales for all of the sales regions for XYZ company. I would like to subtotal these values by region. How can I most efficiently do this.Beneath every region, insert a row. On the Data tab, click the Group button. Highlight the cells you want to group. Then, add an Autosum to calculate the values by region.Highlight the regions and use the Consolidate feature in the Data Tools.On the Data tab, click the Subtotal button. Set your preferences by region and click OK's.Beneath every region, insert a row. Then, add an AutoSum to calculate the values by region. Question 18.*I need to change the layout of my spreadsheet so that it is landscape. How do I do this?Go to Edit > Page Setup and under Orientation, click Landscape.Click the view tab and select Arrange All.Click the View tab and select Landscape.Click the Page Layout tab, and click the Orientation button. Click Landscape. Question 19.*I inherited a spreadsheet from a colleague and when I print it, it sends 586 pages to the printer. However, it only has one page of data. How do I fix this so that it only prints on page?Click the File tab, and traced down to Print Preview. Click Clear Print Area.Highlight the entire spreadsheet and click the Page Layout tab. Click Print Area and Clear Print Area.Insert Page Breaks around the area you would like to print.Click the Page Layout tab, and click the Page Setup button. Click Clear Print Area. Question 20.*How do I enable a cell to display the current date, that is updated automatically every time I open the spreadsheet?=TODAY()= CurrentDatePress F9 on your keyboardPress CTRL + D This iframe contains the logic required to handle Ajax powered Gravity Forms.