I need help for those problems :

1.Which of the following responses best defines the notation A1:B15?

Select one:

a.The contents in cell A1 are identical to the contents in cellB15

b.The cells between A1 and B15 are hidden.

c.AcellrangeorcontiguousgroupofcellsthatbeginswithcellA1andincludeallcellsuptoand including cellB15

d.A cell link that connects cell A1 toB15.

Question2

HoldingdowntheCTRLkeyandpressingtheF1keyonyourkeyboardisusedto

Select one:

a.minimize the Ribbon

b.open the Excel Help window

c.save a workbook

d.switch between open workbooks

Question3

Which of the following statements is true with respect to editing the content in a cell location

Select one:

a.ActivatethecelllocationandpresstheF2keyonyourkeyboardtoeditthedatainthecell

b.Double click the cell location to edit the data in a celllocation

c.Activatethecelllocation,click theFormulaBar,andmakeanyeditsforthecelllocationinthe FormulaBar

d.All of the above aretrue

Question4

Whichofthefollowingwillenableyoutoidentifyhiddencolumnsinaworksheet?

Select one:

a.Thecolumnletterappearsin atipboxwhenthemousepointerismovedoverahiddencolumn

b.ClickingthePageLayoutViewbuttonintheViewtaboftheRibbonshowsallcolumnsinthe worksheet and shades hiddencolumns

c.The column letters that appear above the columns in a worksheet will be missing forhidden columns

d.Click the Hidden Columns indicator in the Status Bar.

Question5

Whichofthefollowingistruewithrespecttoinsertingblankrowsintoaworksheet?

Select one:

a.Blank rows are inserted above the activated cell or cell range in aworksheet

b.Blank rows are always inserted in the center of a cell range. At least two or more cells ina worksheet must be highlighted before a row can beinserted

c.ThecommandforinsertingblankrowsandcolumnscanbefoundbyclickingtheFormatbutton in the Home tab of theRibbon

d.When inserting blank rowsinto a worksheet, the Undo button is disabled. You must use the Delete button in the Home tab of the Ribbon to remove unwanted blank rows

6.

The pound signs (####) that appear in a cell location indicatethat:

Select one:

a.A computational error hasoccurred

b.TheAutoSumfeaturewasappliedtotextdatainsteadofnumericdata

c.A number is too long for the current width of acolumn

d.YoumustclicktheCalculateSheetcommandintheFormulastaboftheRibbon

Question7

Which of the following is true with respect to deleting worksheets?

Select one:

a.You cannot use the Undo button to bring back a worksheet once it hasbeen deleted

b.ClicktheSelectAllbuttonandpresstheDELETEkeyonyourkeyboardtodeleteaworksheet from aworkbook

c.HoldingdowntheSHIFTkey whilepressingtheF11keyon yourkeyboardwilldeleteaworksheet from yourworkbook

d.Excelwillnotletyoudeleteaworksheetthatcontainsdata.Alldatamustberemoved fromthe worksheet before the worksheet can be deleted

Question8

Which of the following commands is used to print the column headings in a worksheet at the top of each printed page for a worksheet that contains 100 rows ofdata?

Select one:

a.the Header & Footer command in the Insert tab of theRibbon

b.the Print Titles command in the Page Layout tab of the Ribbon

c.the Insert command in the Home tab of theRibbon

d.theConditional Formattingcommand in the Home tab of the Ribbon