MGT334 Chp 4: Google Sheets

MGT334 Chp 4: Google Sheets

University

35 Qs

quiz-placeholder

Similar activities

midfinal exam basic keyboarding

midfinal exam basic keyboarding

University

40 Qs

Quizz

Quizz

University

32 Qs

Sumatif Kelas VIII

Sumatif Kelas VIII

8th Grade - University

35 Qs

computers

computers

University

40 Qs

H-5 PAS GENAP informatika X-E s/d X-L

H-5 PAS GENAP informatika X-E s/d X-L

12th Grade - University

40 Qs

G Suite Quiz

G Suite Quiz

10th Grade - Professional Development

30 Qs

Google Docs & Google Suite

Google Docs & Google Suite

University - Professional Development

32 Qs

Soal DDK Kelas 11

Soal DDK Kelas 11

11th Grade - University

40 Qs

MGT334 Chp 4: Google Sheets

MGT334 Chp 4: Google Sheets

Assessment

Quiz

Other

University

Medium

Created by

NAZATUL SUTRISNO

Used 1+ times

FREE Resource

35 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the default file extension for a Google Sheets document?

.xlsx

.gsheet

.ods

.xls

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you freeze the top row in Google Sheets?

Click "View" and select "Freeze" > "1 row"

Right-click and select "Freeze"

Click "Data" and select "Freeze"

Drag the line between rows 1 and 2

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula in Google Sheets is used to calculate the sum of a range of cells?

=SUM()

=TOTAL()

=ADD()

=SUMIF()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you add a new sheet to an existing Google Sheets document?

Click the " + " icon at the bottom of the screen

Go to "File" > "New" > "Sheet"

Right-click any sheet tab and select "Add Sheet"

Both A and C

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the formula =A1+B1 do in Google Sheets?

Adds the values of cells A1 and B1

Subtracts the values of B1 from A1

Multiplies the values of A1 and B1

Divides the value of A1 by B1

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function in Google Sheets would you use to find the average of a range of numbers?

=MEAN()

=AVERAGE()

=AVG()

=SUM()

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the =IF() function in Google Sheets?

To check if a condition is true or false and return a result based on that condition

To perform a logical comparison

To filter data based on specific conditions

Both A and B

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?