USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Value
|
|
|
Variable
|
|
|
Constant
|
|
|
Scope
|
Detailed explanation-1: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.
Detailed explanation-2: -The four types of data are text, number, logical and error. You may perform different functions with each type, so it’s important to know which ones to use and when to use them.
Detailed explanation-3: -Boolean operators, which Excel calls logical functions, include AND, OR, NOT, and a new function called XOR. These operators are used between search terms to narrow, expand, or exclude your results in databases, spreadsheets, search engines, or any situation where you’re seeking specific information.