Excel-Test-SGS

In Excel, if you want to change the financial format from $ to Rp. automatically, you can use ....

• Write it in each cell

• 
• 
• 

Filling an ordered list automatically in Excel can be done by....

• 
• 
• 
• 

The result of =ROUNDUP((100/3);2) is

• 34

• 33.33

• 33.34

• 33,4

=IF(Presence!R2=14;100;(Presence!R2/14)*100);

If the value of Presence!R2=14 then the results displayed are...

• 140

• 100

• 14

• all answers are wrong

The function in Excel used calculates the average of a group of values

• SUM

• AVERAGE

• MAX

• IF

The main function of the Microsoft Excel program is

• Word processing

• Numerical data processing

• Managing documents

• Communicate

The correct formula for writing the sum in cell B2 and cell C2 is below

• +Sum(B2…C2)

• =Sum(B2:C2)

• =Sum(B2;C2)

• =Sum(B2,C2)

Function of Ms. Excel is used to calculate the number from an interval with the desired conditions

• COUNTIF

• DCOUNT

• SUMIF

• SUM

The area where Excel formulas are written is called

• menubar

• titlebar

• formulabar

• toolbar

Function used to determine the largest value of numeric data

• Sum

• Max

• Average

• Min