From the following list of choices, select the choice that BEST describes the PRIMARY purpose of using named ranges in Excel.*They can simplify the process of referencing cell ranges in formulas.They can simplify the process of finding a particular range of cells.They can resolve the problem of circular cell address referencing in formulas.

When you define a Range Name, it can be use ——- For calculation in excel For defining a cell address As a delimiter when working on Text to Column Wrap Text Function Calculation.

The VBA code ____ refers to the collection of cells in the cell range, A1:B10.Select one:a.Names(A1:B10)b.(A1:B10)c.Range("A1:B10")d.Objects(A1:B10)

Q1. What are the basic rectangular building blocks of a spreadsheet? Cells Zoom slider Help button All of theseQ2. Another name for a pre-programmed formula in Excel is Cell Graph Function RangeQ3. Excel is a program that is used to prepare a Slide presentation Spreadsheet Text document DatabaseQ4. In which tab wrap text feature is present in MS Excel 2007? Formulas View Insert HomeQ5. Which of the following identifies a cell in Excel? Address Formula Name LabelQ6. Which term is used to join the selected cells in to one cell? Filter Wrap Pivot MergeQ7. A formula in Excel always begins with an ____ Equal sign Colon Comma SpaceQ8. What is the extension of saved file in MS Excel 2010? .xlsx .excel .xlx .xlwQ9. Which command is used to close the window of Excel? Alt+ F4 Ctrl + W Ctrl + R Ctrl + CQ10. Which bar show the used formula of selected active cell? Formula bar Ribbon Menu bar Scroll bar

Use the Create from Selection command to create named ranges for the selected data table in cells B2:E6 using the labels in row 1 as the basis for the names.

A cell range always has the _______ symbol between the cell references.*1 point; (semicolon). (fullstop), (comma): (colon)