FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In an excel forumula it means divide
A
Forwardslash
B
Backwards
C
Skip
D
Multiply
Explanation: 

Detailed explanation-1: -To do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a cell, the cell displays 2. Important: Be sure to type an equal sign (=) in the cell before you type the numbers and the / operator; otherwise, Excel will interpret what you type as a date.

Detailed explanation-2: -In spreadsheet programs like Microsoft Excel, a forward slash is used in formulas for a division. For example, in the following formula, cell A1 is divided by cell B1. =sum(A1/B1) When not used in a formula a forward slash with only numbers is treated as a date.

Detailed explanation-3: -Single-slash-slash headers are often used when you are creating an Excel table. It is easy to add a slash by right clicking a table cell, using “Format Cells", and adding a single slash or using “Insert-Shape-Line” to manually add multiple slashed.

Detailed explanation-4: -There’s no DIVIDE function in Excel. Simply use the forward slash (/) to divide numbers in Excel.

Detailed explanation-5: -Division Math Formula The formula to calculate the division of two numbers is: Dividend ÷ Divisor = Quotient + Remainder. The remainder is the leftover number in the division operation. If 46 is divided by 5, we get the quotient as 9 and the remainder 1.

There is 1 question to complete.