wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets 02

Total questions: 69

Worksheet time: 55mins

Name
Class
Date
1.

¿Cuál es la formula que debo aplicar para obtener el resultado?

a)

=(A2 + A3)

b)

=A2+A3

c)

=B1+B2

d)

=B2+B3

2.

El resultado de la fórmula =(A2+B3)*B1 es:

a)

12

b)

9

c)

36

d)

Ninguna de las anteriores

3.

Indica cuál es el rango del área pintada:

a)

A1: D4

b)

B2:C4

c)

B4:D4

d)

B3:D4

4.

Para dibujar una tabla (hacer visibles los bordes), una ves seleccionadas las celdas se debe hacer click en:

a)
b)
c)
d)
5.

¿Cómo se convierten los nombres a mayúsculas en Google Sheets?

a)

Utiliza la función CONCATENATE para cambiar a mayúsculas.

b)

Usa la función LOWER en Google Sheets.

c)

Aplica el formato de texto en negrita.

d)

Usa la función UPPER en Google Sheets.

6.

¿Qué función se utiliza para poner los apellidos en minúscula?

a)

lower()

b)

capitalize()

c)

titlecase()

d)

uppercase()

7.

¿Qué función se utiliza para unir el primer nombre y el primer apellido?

a)

merge

b)

join

c)

combine

d)

concat

8.

¿Qué función se usa para extraer los últimos 3 dígitos de un número de teléfono?

a)

LEFT(numeroTelefono, 3)

b)

numeroTelefono.substring(0, 3)

c)

numeroTelefono.substr(-3)

d)

RIGHT(numeroTelefono, 3)

9.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
10.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
11.
Select ______________ from the functions drop-down menu to add a set of numbers together. 
a)
average
b)
count
c)
max
d)
sum
12.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
13.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
14.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
15.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
16.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
17.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
18.

To select only a few random cells, hold down the _______ key.

a)

Tab

b)

Option

c)

Shift

d)

Command

19.

Double-clicking between two columns will ____________ the column.

a)

Delete

b)

Copy

c)

Resize

d)

Fill

20.

A Sheets document is called a?

a)

Work page

b)

Work paper

c)

Spreadsheet

d)

Slide

21.

Google Sheets is used to? (Select ALL that apply?)

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

22.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
23.

What does this icon represent?

a)

Google Sheets

b)

Google Slides

c)

Google Docs

d)

Google Classroom

24.

What number should be in cell E1 (based on the formula)?

a)

1

b)

2

c)

5

d)

9

25.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
26.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
27.
You can not give an exact size for a row height or column width.
a)
True
b)
False
28.
It is possible to insert images in Google Sheets
a)
True
b)
False
29.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
30.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
31.

What formula is being used here =j2-g3 choose from the list

a)

Adding

b)

Subtraction

c)

Divide

d)

Multiply

32.

What formula is being used here =j2*g3 choose from the list

a)

Adding

b)

Subtraction

c)

Divide

d)

Multiply

33.

What formula is being used here =j2/g3 choose from the list

a)

Adding

b)

Subtraction

c)

Divide

d)

Multiply

34.

If I wanted to add more than 5 cells together I should use which formula?

a)

=MAX(A1:A6)

b)

=SUM(A1:A6)

c)

=A1+A2+A3+A4+A5+A6

d)

=SUM(A1...A6)

35.

If I wanted to to find the lowest number in a group of numbers what formula is the best for that?

a)

=MAX(A1:G5)

b)

=MIN(A1:G5)

c)

=LOW(A1:G5)

d)

=SUM(A1:G5)

36.

What number is for bordering tool?

a)

3

b)

4

c)

9

d)

8

e)

6

37.

What number is the text color tool?

a)

3

b)

4

c)

9

d)

8

e)

6

38.

What number is the bold tool?

a)

3

b)

4

c)

9

d)

8

e)

6

39.

What number is the text size?

a)

1

b)

4

c)

2

d)

8

e)

6

40.

A page within a workbook that contains columns, rows, and cells.

a)

Worksheet

b)
Workbook
c)
Cell
d)
Spreadsheet
41.

An online spreadsheet app by Google that lets you create and format spreadsheets and work with other people.

a)
Excel
b)
Sheets
c)
Spreadsheet
d)
Label
42.
 A grid of rows and columns in which you enter text, numbers, and the results of calculations.
a)
Excel
b)
Sheets
c)
Spreadsheet
d)
Label
43.
A spreadsheet is like a large calculator.
a)

True

b)

False

44.
The lines in your worksheet that separate the column and rows.
a)
Cell Grid
b)
Cell
c)
Cell Address
d)
Columns
45.

Which of the following formulas is used to find the round a number DOWN a number to the nearest integer?

a)

=FLOOR()

b)

=CEILING()

c)

=LOWER()

d)

=UPPER()

46.

Which of the following formulas is used to find the round a number UP a number to the nearest integer?

a)

=FLOOR()

b)

=CEILING()

c)

=LOWER()

d)

=UPPER()

47.

Which of the following formulas is used to make all letters lowercase in a cell?

a)

=FLOOR()

b)

=CEILING()

c)

=LOWER()

d)

=UPPER()

48.

Which of the following formulas is used to format the word in a cell so that the first letter is capitalized?

a)

=FORMAT()

b)

=PROPER()

c)

=LOWER()

d)

=UPPER()

49.

Which of the following formulas is used to find the average of set of numbers?

a)

=AVERAGE()

b)

=MAX()

c)

=SUM()

d)

=MODE()

50.

Which of the following formulas is used to find the most common value in a set of numbers?

a)

=AVERAGE()

b)

=MAX()

c)

=SUM()

d)

=MODE()

51.

Which of the following formulas is used to find the most common value in a set of numbers?

a)

=AVERAGE()

b)

=MAX()

c)

=SUM()

d)

=MODE()

52.

Which function finds the list of different values within a range of cells?

a)

=UNIQUE()

b)

=FLOOR()

c)

=SUM()

d)

=MODE()

53.

Using Google Drive, the sharing settings are the same in Docs, Sheets and Slides

a)

TRUE

b)

FALSE

54.

Where would you go if you wanted to add a theme, border, font or change a number type in a sheet?

a)

Insert

b)

Format

c)

Data

d)

None of the above.

55.

Using this picture, what would the formula be to find the average in B16 for the given set of data?

a)

+AVERAGE(B2:B13)

b)

=AVERAGE(B2:B13)

c)

=AVERAGE(B1:B13)

d)

+AVERAGE(A2:A13)

56.

True or False: You share Google Sheets the same way you share Docs.

a)

True

b)

False

57.

¿Qué es una función en Hojas de Cálculo?

a)

Una imagen insertada en la hoja de cálculo

b)

Un formato de texto aplicado a las celdas

c)

Una fórmula predefinida que realiza cálculos o manipula datos en las celdas.

d)

Un tipo de gráfico utilizado para representar datos

58.

¿Por qué es importante la organización de filas y columnas en una hoja de cálculo?

a)

No es importante, la organización aleatoria es más efectiva

b)

La organización de filas y columnas no afecta la visualización de datos

c)

Es importante para facilitar la visualización y manipulación de datos de manera estructurada y ordenada.

d)

Es irrelevante, los datos se pueden colocar en cualquier orden

59.

¿Cuál es la importancia de la función IF en una hoja de cálculo?

a)

La función IF en una hoja de cálculo es importante porque permite realizar evaluaciones lógicas y condicionales, devolviendo un valor específico si la condición es verdadera y otro valor si es falsa.

b)

La función IF en una hoja de cálculo es importante para realizar operaciones matemáticas complejas

c)

La función IF en una hoja de cálculo solo se utiliza para cambiar el formato de las celdas

d)

IF es una función obsoleta en las hojas de cálculo modernas

60.

¿Qué es la función CONCATENATE y cómo se aplica en Google Sheets?

a)

La función CONCATENATE en Google Sheets se utiliza para dividir celdas en múltiples partes

b)

La función CONCATENATE en Google Sheets se utiliza para combinar o unir múltiples cadenas de texto en una sola celda. Para aplicarla, simplemente se escribe =CONCATENATE(texto1, texto2, ... textoN) en la celda donde se desea que aparezca la concatenación de los textos.

c)

La función CONCATENATE en Google Sheets se utiliza para realizar cálculos matemáticos entre celdas

d)

Para aplicar la función CONCATENATE, se escribe =COMBINE(texto1, texto2, ... textoN) en la celda

61.

Google Sheets saves your changes automatically.

a)

True

b)

False

62.

I want to merge cells together. Which button do I press?

a)

b)

c)

d)

63.

I want to change the fill color of a cell. Which button do I press?

a)

b)

c)

d)

64.

I want to have borders, but only on the outside edge of my cells.

I highlighted my cells, now which option should I choose?

a)

b)

c)

d)

65.

What is the easiest way to refer to these highlighted cells?

a)

C1:C6

b)

C1-C6

c)

C1, C2, C3, C4, C5, C6

d)

C1"C6

66.

What is the easiest way to refer to these highlighted cells?

a)

A1:A5

b)

A:E, 3

c)

A3, B3, C3, D3, E3

d)

A3:E3

67.

Which of the following can I type in a cell to find the answer to 3x7?

a)

=3*7

b)

=3x7

c)

=MULTIPLY(3, 7)

d)

3x7

68.

Here's my data set.

Which of the following can I type in a cell to find the answer to 3x5?

a)

3x5

b)

A3*B2

c)

=A3*B2

d)

=MULTIPLY(A3, B2)

69.

Which of the following can I type in a cell to find the average of these 3 numbers?

a)

=AVERAGE(A1, A2, A3)

b)

=AVERAGE(A1:A3)

c)

=(3+5+7)/3

Similar Resources on Wayground

IC3 GS6 Tổng hợp 1

70 questions

IC3 GS6 Tổng hợp 1

quiz

Worksheet

•

6th - 8th Grade

REVIEW FOR UNIT TEST #1

70 questions

REVIEW FOR UNIT TEST #1

quiz

Worksheet

•

7th - 12th Grade

Informática I

74 questions

Informática I

quiz

Worksheet

•

8th Grade

Analisis Data Kelas 7

70 questions

Analisis Data Kelas 7

quiz

Worksheet

•

7th Grade

Visual Basic Applications VBA

74 questions

Visual Basic Applications VBA

quiz

Worksheet

•

3rd Grade - University

DAMPAK SOSIAL INFORMATIKA

70 questions

DAMPAK SOSIAL INFORMATIKA

quiz

Worksheet

•

7th Grade

Introduction to Programming Bank

68 questions

Introduction to Programming Bank

quiz

Worksheet

•

6th Grade

SOAL PERSIAPA JKI DAN AD

65 questions

SOAL PERSIAPA JKI DAN AD

quiz

Worksheet

•

7th Grade