Search Header Logo

Excel-Test-SGS

Authored by Ayuningtyas Tyas

Computers

9th - 12th Grade

Excel-Test-SGS
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

17 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

20 sec • 5 pts

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

Write it in each cell

Media Image
Media Image
Media Image

2.

MULTIPLE SELECT QUESTION

20 sec • 5 pts

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

Media Image
Media Image
Media Image
Media Image

3.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

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

34

33.33

33.34

33,4

4.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

=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

5.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

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

SUM

AVERAGE

MAX

IF

6.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

The main function of the Microsoft Excel program is

Word processing

Numerical data processing

Managing documents

Communicate

7.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

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)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?