WorksheetsLevel-9-Adult
Total questions: 10
Worksheet time: 20mins
តើកម្មវិធី Microsoft Office ប្រើសម្រាប់ធ្វើអ្វីខ្លះ?
ជាសំនុំកម្មវិធីសម្រាប់ដោះស្រាយលើការងាររដ្ឋបាល
ជាសំនុំកម្មវិធីសម្រាប់ដោះស្រាយលើការងារ Design
ជាសំនុំកម្មវិធីសម្រាប់ដោះស្រាយលើការងារគូសប្លង់
Syntax for the RANK function in Excel is
=RANK(number,[order] )
=RANK(number, reference, [order] )
=RANK( Number1, Number2,…….)
Syntax for the VLOOKUP function in Excel is
=VLOOKUP(lookup_value, table_array, row_index_num)
=VLOOKUP(lookup_value, table_array, col_index_num)
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Syntax for the IF function in Excel is
=IF(logical_test, value_if_true, value_if_false)
=IF(logical_test, value_if_false, value_if_false)
=IF(logical_test, value_if_false, value_if_false)
=IF(logical_test, value_if_false, value_if_true)
Syntax for SUMIF function in Excel is
=SUMIF(range, criteria)
=SUMIF(criteria, range, [sum_range])
=SUMIF(range, criteria, [sum_range])
=SUMIF(range, criteria, [sum_range])
Order cost
=PRODUCT(order_quanlity, price)
=PRODUCT(order_quanlity, discount_applied)
=SUM(order_quanlity, price)
=AVERAGE(order_quanlity, discount_applied)
Discount Applied
=IF(order_quantity<threshold, order_cost*high_discount, order_cost*low_discount)
=IF(order_quantity>threshold, order_cost*high_discount, order_cost*low_discount)
=IF(order_quantity>threshold, order_cost*low_discount, order_cost*low_discount)
=IF(order_quantity>threshold, order_cost*high_discount, order_cost*high_discount)
Final Order Cost
=order_cost - price
=order_quantity - discount_applied
=order_cost - final_order_cost
=order_cost - discount_applied
What is data validation?
Data Validation is the process of setting rules for volume that entered in a cell to ensure that it meets specific criteria such as text length, date, or number format.
Data Validation is the process of setting rules for data that entered in a cell to ensure that it meets specific criteria such as text length, date, or number format.
Data Validation is the process of setting rules for keyboard that entered in a cell to ensure that it meets specific criteria such as text length, date, or number format.
Data Validation is the process of setting rules for laptop that entered in a cell to ensure that it meets specific criteria such as text length, date, or number format.
What is browser?
A web browser is a villain in Mario game.
A web browser is a laptop for game.
A web browser is a phone.
A web browser is an application for accessing websites.
