Answers the following questions:- 2 x 5 =10
1. Give any two text formula with its syntax?
2. How will you delete a work sheet?
3. Give difference between replace and substitute functions with example?
4. What is syntax? And give its order?
5. Give the shortcut keys for the following.
a. To enter current time
b. Line break
c. Insert a worksheet
d. To access the autosum command
6. Define the given terms:-.
2 x 5 =10
a. Worksheet
b. Formula bar
c. Active cell
d. Wrapping
e. Autofill
7. Solve. 2 x 5 = 10
a. 10101010 + 11100011
b. 1101011 - 110100
c. AC9 (Hexa) to Decimal
d. 2134 ( octal) to Binary
e. 259 ( Decimal) to Octal
Answers
Answer:
1.
For an example, if you want to fetch the date from cell A2 and show it into another cell in a standard date format like “February 1, 2019”, you use the Text formula as shown below: =TEXT(A2, “mmmm d, yyyy”) The result will look like as shown below:
2.
Delete a worksheet
Delete a worksheetRight-click the Sheet tab and select Delete.
Delete a worksheetRight-click the Sheet tab and select Delete.Or, select the sheet, and then select Home > Delete > Delete Sheet
3.
Excel REPLACE vs SUBSTITUTE function. In this article, we will learn the difference between SUBSTITUTE vs REPLACE function. Both functions work on TEXT editing.
4.
In linguistics, syntax (/ ˈ s ɪ n t æ k s /) is the set of rules, principles, and processes that govern the structure of sentences (sentence structure) in a given language, usually including word order.
Explanation: