1. Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the ____________ ?

cell's column label

cell's column label and worksheet tab name

cell's row label

cell's row and column labels

Answer: cell's row and column labels

Explanation:

Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the option (4) cell's row and column labels. The cell address in Excel consists of a combination of the column label and the row label. The column label represents the column letter, and the row label represents the row number. These labels are combined to form a unique identifier for each cell in the spreadsheet. For example, cell A1 refers to the cell in the first column and the first row, while cell C5 refers to the cell in the third column and the fifth row. Therefore, the correct answer is option (4) cell's row and column labels.


2. Which area in an excel window allows entering values and formulas ?

Title bar

Menu bar

Formula bar

Standard toolbar

Answer: Formula bar

Explanation:

The area in an Excel window that allows entering values and formulas is (3) the Formula bar. The Formula bar is located just below the menu bar and typically spans across the width of the Excel window. It displays the contents of the currently selected cell, allowing you to enter or edit values and formulas. When you select a cell, the contents of that cell are shown in the Formula bar, whether it's a numeric value, text, or a formula. You can directly type or edit the desired value or formula in the Formula bar and press Enter to apply it to the selected cell.


3. Excel files have a default extension of ?

Xls

Xlw

Wkl

123

Answer: Xls

Explanation:

Excel files have a default extension of (1) Xls. The default file extension for Excel files in older versions of Microsoft Excel, such as Excel 97-2003, is .xls. This extension is commonly used to indicate that a file is in the Excel binary file format. However, it's worth noting that with the introduction of newer versions of Excel, such as Excel 2007 and onwards, the default file extension has been changed to .xlsx for Excel workbook files and .xlsm for Excel macro-enabled workbook files. These newer file formats are based on the Office Open XML (OOXML) standard. Therefore, while .xls is the traditional default extension for Excel files, it's essential to consider the specific version of Excel being used, as it may utilize different default file extensions.


4. When you insert an Excel file into a Word document, the data are ?

Hyperlinked

Placed in a word table

Linked

Embedded

Answer: Placed in a word table

Explanation:

Placed in a word table


5. An excel workbook is a collection of ?

Workbooks

Worksheets

Charts

Worksheets and charts

Answer: Worksheets

Explanation:

Excel workbook is a collection of (2) worksheets. An Excel workbook is a file that contains one or more worksheets, which are the primary components of the workbook. Each worksheet consists of a grid of cells where you can enter, manipulate, and analyze data. By default, a new Excel workbook typically contains one worksheet, but you can add or delete worksheets as needed.


6. You can create hyperlinks from the Excel workbook to ?

A webpage on company internet

A web page on the internet

Other Office 97 application documents

All

Answer: All

Explanation:

You can create hyperlinks from an Excel workbook to option (4) All of the mentioned destinations. In Excel, you can create hyperlinks to various destinations, including: A webpage on the company's intranet or internal network (option 1: A webpage on company internet). A webpage on the internet, which includes any public website (option 2: A web page on the internet). Other Office 97 application documents, such as Word documents, PowerPoint presentations, or other Excel workbooks (option 3: Other Office 97 application documents). Therefore, the correct answer is option (4) All. Excel allows you to create hyperlinks to all of these mentioned destinations and more


7. Two common wildcard characters that Excel recognizes are ?

* and ?

< and >

^ and /

+ and -

Answer: * and ?

Explanation:

The two common wildcard characters that Excel recognizes are the asterisk (*) and the question mark (?). Asterisk (): The asterisk is used as a wildcard to represent any number of characters. It can be used within a text string or as part of a search criteria in functions like COUNTIF or SUMIF. For example, if you have a list of names and want to find all names starting with "J", you can use the formula =COUNTIF(A:A, "J") to count the occurrences. Question Mark (?): The question mark is used as a wildcard to represent a single character. It can be used within a text string or as part of a search criteria. For example, if you have a list of words and want to find all four-letter words starting with "A", you can use the formula =COUNTIF(A:A, "A???") to count the occurrences. These wildcard characters provide flexibility in searching and matching text patterns in Excel.


8. When you link data maintained in an excel workbook to a word document ?

The word document can not be edit

The word document contains a reference to the original source application

The word document must contain a hyperlink

The word document contains a copy of the actual data

Answer: The word document contains a reference to the original source application

Explanation:

When you link data maintained in an Excel workbook to a Word document, the correct option is (2) The Word document contains a reference to the original source application. When you link data from an Excel workbook to a Word document, the Word document maintains a reference or connection to the original Excel file. This means that any changes made to the data in the Excel file will be reflected in the Word document when it is updated.


9. To create a formula in Excel, you can use ?

Values but not cell references

Cell references but not values

Values or cell references although not both at the same time

Value and cell references

Answer: Value and cell references

Explanation:

To create a formula in Excel, you can indeed use (4) values and cell references simultaneously. Formulas in Excel allow you to perform calculations and manipulate data based on values and cell references. You can combine numeric values, mathematical operators, and cell references within a formula to perform calculations and obtain results dynamically.


10. The intersection of a row and column is called ?

data

a field

a cell

an equation

Answer: a cell

Explanation:

The intersection of a row and column in a spreadsheet is called option (3) a cell. A cell in a spreadsheet is the basic unit of data storage and is formed by the intersection of a row and a column. Each cell can hold data, formulas, and other types of information. Therefore, the correct term for the intersection of a row and column in a spreadsheet is a cell.