FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In cells D2, D3, D4, D5, and D6 consecutively contain the numbers 73, 78, 60, 85, 70, and 68. If in cell D7 contains the function = MAX(D2:D6), then it will produce a number.. ____
A
60
B
73
C
85
D
78
E
70
Explanation: 

Detailed explanation-1: -Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.

Detailed explanation-2: -In this case we will let A = Actual Price and B = Budget Price, so our formula will be: A/B-1. This formula will be entered in cell D2. To execute the formula all we need to do is press Enter.

Detailed explanation-3: -For the first item listed below (pencils), this could be done by making the value of the total price (cell D2), the value of the unit price (held in cell C2) multiplied by the number of items ordered (held in D2). This formula would be written “=B2*C2".

Detailed explanation-4: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

There is 1 question to complete.
Previous
Next