Fill in the required functions as you saw in the video
Booking Status
Called or send for cases not Done
Done Cases not Released
Released Cases
Cancelled Cases before Operation Day
Cancelled Cases in Operation Day
Cancelled Cases after Operation Day
Not Admitted (DNA)
booked cases not called (Emergency)
Booked cases not called (Anesthesia Outside)
Booked cases not called (Private)
Boo ked cases not c alle d (Other)
as you saw in the video
10
18
25
30
45
20
20
30
45
45
20
SAR 120,000.00
نسبة الفاىدة 0.11 )($88,701.53
العدد الكلي للدفعات السنوية 5.00 )($88,701.53
قيمة الدفعة السنوية 24000.00 )($149,467.23
PV )(SAR 88,701.53 ية لمجموعة من األقساط سوف تدفع في
FV )(SAR 149,467.23 دخار 2500لاير من المال في 10سنوات
-2254.7525792895
معدل الفائدة 0.11
عدد االقساط 5.00
قيمة السيارة 100000.00 )($2,254.75
PMT )(SAR 2,254.75 هري بمعلومية عدد األقساط ومبلغ السلعة
)($149,467.23
تستخدم هذه الدالة لحساب القيمة الحالية لمجموعة من األقساط سو
المستقبل
دالة حساب قيمة المدخر ..مثال لو أردت ادخار 2500لاير من المال في
%ونسبة فاىدة 4
تستخدم هذه الدالة لحساب القسط الشهري بمعلومية عدد األقساط و
ونسبة الفاىدة
Budgete
Actual Expenses d
Expenses
$1,500 $900
$500 $900
SUCCSEED
1
65 Pass D D
70 Pass C C
78 Pass C C
66 Pass D D 0
95 Pass A A 60
48 Fail F F 70
85 Pass B B 80
25 Fail F F 90
F
D
C
B
A
Function
SUM
AVERAGE
LEN
LEFT
RIGHT
MID
REPT
UPPER
LOWER
REPLACE
PROPER
EXACT
CODE
CONCATENATE
DOLLAR
T
TRIM
MAX
MIN
COUNT
COUNTIF
ROUND
INT
MOD
SQRT
EVEN
TRUNK
SUMIF
TIME
NOW
TODAY
IF
AND
POWER
PRODUCT
SUMSQ
OR
ODD
NOT
PI
MODE
MEDIAN
ISODD
ISEVEN
ISTEXT
HYPERLINK
ABS
CELL
PV
FV
PMT
Descriptions
Totals the data in a column of cells
Produce the average of the data in a range of cells
Returns the number of characters in a text string
Returns the leftmost characters from a text value
Returns the rightmost characters from a text value
Returns a specific number of characters from a text string starting at the position you specify
Repeats text a given number of times
Converts text to uppercase
Converts text to lowercase
Replaces characters within text
Capitalizes the first letter in each word of a text value
Checks to see if two text values are identical
Returns a numeric code for the first character in a text string
Joins several text items into one text item
Converts a number to text, using the $ (dollar) currency format
Converts its arguments to text
Removes spaces from text
Returns the maximum value in a list of arguments
Returns the minmum value in a list of arguments
Counts how many numbers are in the list of arguments
Counts the number of cells within a range that meet the given criteria
Rounds a number to a specified number of digits
Rounds a number down to the nearest integer
Returns the remainder from division
Returns a positive square root
Rounds a number up to the nearest even integer
Truncates a number to an integer
Adds the cells specified by a given criteria
Returns the serial number of a particular time
Returns the serial number of the current date and time
Returns the serial number of today's date
Specifies a logical test to perform
Returns TRUE if all of its arguments are TRUE
Returns the result of a number raised to a power
Multiplies its arguments
Returns the sum of the squares of the arguments
Returns TRUE if any argument is TRUE
Rounds a number up to the nearest odd integer
Reverses the logic of its argument
Returns the value of pi
Returns the most common value in a data set(high frequency)
Returns the median of the given numbers
Returns TRUE if the number is odd
Returns TRUE if the number is even
Returns TRUE if the value is text
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Returns the absolute value of a number
Returns information about the formatting, location, or contents of a cell
Returns the present value of an investment
Returns the future value of an investment
Returns the periodic payment for an annuity
3.46
