wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

How To Create a Google Spreadsheet

Total questions: 98

Worksheet time: 49mins

Name
Class
Date
1.

What is a Google spreadsheet?

a)

A) A type of chart used for presentations

b)

B) A web-based application for organizing and calculating data in worksheets

c)

C) A tool for drawing images

d)

D) A social media platform

2.

Which component of a Google spreadsheet is described as 'The input spaces holding data points are called _____. There is an infinite number of these available in a Google spreadsheet.'

a)

cells

b)

rows

c)

columns

d)

sheets

3.

Google spreadsheet cells make up horizontal rows of data, numbered from 1-1000. You may add as many rows to a sheet as you like, beginning at number 1001. What are these horizontal groups called?

a)

Columns

b)

Ranges

c)

Rows

d)

Functions

4.

Google spreadsheet cells make up vertical columns of cells, lettered A-Z. You may add as many columns to a sheet as you like, beginning at double letter AA. What are these vertical groups called?

a)

Columns

b)

Rows

c)

Sheets

d)

Cells

5.

Ranges in Google spreadsheets are groups of cells you select. A range may span columns, rows or both.

a)

True

b)

False

6.

Functions are predetermined operations built into Google spreadsheets. You can use functions to calculate values by cell, column, row or range.

a)

True

b)

False

7.

Which of the following is NOT listed as a template option when opening a new Google spreadsheet?

a)

To-do lists

b)

Calendars

c)

Budgets

d)

Presentations

8.

Fill in the blank: To save a cell's data in Google Sheets, you can press "_____" on your keyboard.

a)

enter

b)

spacebar

c)

tab

d)

shift

9.

Which of the following is NOT a way to bring existing data into your Google spreadsheet?

a)

Copy and paste text or numbers into cells

b)

Copy and paste information from an HTML table on a website into cells

c)

Import existing spreadsheet data in .csv, .xls and .xlsx files

d)

Print the spreadsheet

10.

You can move your cursor to the next cell in any direction—left, right, down or up—using the directional arrow keys on your keyboard in Google Sheets.

a)

True

b)

False

11.

Which file types are mentioned as compatible for importing data into Google Sheets?

a)

.doc, .pdf

b)

.csv, .xls, .xlsx

c)

.ppt, .txt

d)

.jpg, .png

12.

Which formatting option in Google Sheets allows you to display monetary values?

a)

Currency

b)

Date

c)

Percentage

d)

Text

13.

Which formatting option in Google Sheets is used for displaying rounded monetary values?

a)

Rounded currency

b)

Plain text

c)

Scientific notation

d)

Date format

14.

Which formatting option in Google Sheets is used to show values as a percentage?

a)

Percentages

b)

Currency

c)

Date

d)

Text

15.

Which formatting option in Google Sheets allows you to adjust the number of decimal places?

a)

Decimal manipulation

b)

Font style

c)

Cell border

d)

Text alignment

16.

Which formatting option in Google Sheets is used for text that does not require any special formatting?

a)

Plain text

b)

Currency

c)

Date

d)

Scientific

17.

Which formatting option in Google Sheets is used for general numeric values?

a)

Number

b)

Currency

c)

Date

d)

Text

18.

Which formatting option in Google Sheets is used for numbers written in scientific notation?

a)

Scientific notation

b)

Currency

c)

Date

d)

Percentage

19.

Which formatting option in Google Sheets is specifically used for accounting purposes?

a)

Accounting

b)

Currency

c)

Date

d)

Plain Text

20.

Which formatting option in Google Sheets is used for financial data?

a)

Financial

b)

Text

c)

Date

d)

Scientific

21.

Which formatting option in Google Sheets is used to display calendar dates?

a)

Date

b)

Currency

c)

Percentage

d)

Text

22.

Which formatting option in Google Sheets is used to display time values?

a)

Time

b)

Date

c)

Currency

d)

Percentage

23.

Which formatting option in Google Sheets is used to display both date and time together?

a)

Date-time

b)

Date only

c)

Time only

d)

Currency

24.

Which formatting option in Google Sheets allows you to create a custom numeric format?

a)

Custom number

b)

Conditional formatting

c)

Data validation

d)

Text wrapping

25.

Which styling action in Google Sheets allows you to reverse your last action?

a)

Undo

b)

Redo

c)

Bold

d)

Merge cells

26.

Which styling action in Google Sheets allows you to repeat your last undone action?

a)

Redo

b)

Undo

c)

Copy

d)

Paste

27.

Which styling action in Google Sheets allows you to produce a hard copy of your sheet?

a)

Print

b)

Bold

c)

Merge cells

d)

Insert chart

28.

Which styling action in Google Sheets allows you to copy formatting from one cell to another?

a)

Paint format

b)

Conditional formatting

c)

Merge cells

d)

Data validation

29.

Which styling action in Google Sheets allows you to select a different font style?

a)

Choose font

b)

Insert chart

c)

Freeze row

d)

Sort sheet

30.

Which styling action in Google Sheets allows you to change the size of the font?

a)

Size font

b)

Bold text

c)

Insert row

d)

Merge cells

31.

Which styling action in Google Sheets allows you to change the appearance of the font?

a)

Format font

b)

Insert chart

c)

Sort range

d)

Protect sheet

32.

Which styling action in Google Sheets allows you to add background color to cells?

a)

Fill with color

b)

Merge cells

c)

Insert chart

d)

Sort range

33.

Which styling action in Google Sheets allows you to align text horizontally and vertically within a cell?

a)

Horizontal and vertical alignment

b)

Merge cells

c)

Conditional formatting

d)

Insert chart

34.

Which styling action in Google Sheets allows you to change the orientation of text in a cell?

a)

Rotate text

b)

Merge cells

c)

Wrap text

d)

Insert link

35.

Which styling action in Google Sheets allows you to add a hyperlink to a cell?

a)

Insert link

b)

Bold text

c)

Change cell color

d)

Merge cells

36.

Which of the following is NOT a tool embedded in Google Sheets for use in the expandable ribbon?

a)

Play music

b)

Create forms

c)

Run scripts

d)

Check spelling

e)

Record macros

37.

Google Sheets allows you to create forms using which feature?

a)

Add-ons

b)

Tools

c)

Sharing

d)

Charts

38.

Fill in the blank: Google Sheets embeds a group of tools for use in the ________ ribbon.

a)

expandable

b)

formula

c)

data

d)

insert

39.

Which of the following is NOT an add-on functionality that can be integrated with Google Sheets?

a)

Tables

b)

Forms

c)

Mail merges

d)

Inventories

e)

Video streaming

40.

You can browse, install, and manage add-ons directly from the app in the expandable ribbon in Google Sheets.

a)

True

b)

False

41.

Fill in the blank: Google Sheets allows you to control the sharing of your spreadsheets in ______ ways.

a)

two

b)

three

c)

four

d)

five

42.

Which menu contains the share option in Google Sheets?

a)

File

b)

Edit

c)

View

d)

Tools

43.

What are the two levels of access you can give to recipients when sharing your Google Sheets?

a)

Read-only and Edit

b)

View and Comment

c)

Owner and Viewer

d)

Edit and Delete

44.

Fill in the blank: You can create a link to share the spreadsheet or enter ______ addresses with which to share the spreadsheet.

a)

email

b)

home

c)

street

d)

phone

45.

Google Sheets allows you to record macros as one of its embedded tools.

a)

True

b)

False

46.

Which file type can you download your Google spreadsheet as?

a)

Portable document format (.pdf)

b)

Microsoft Excel (.xls or .xlsx)

c)

Open document format (.ods)

d)

Comma-separated values (.csv)

e)

Tab-separated values (.tsv)

47.

Fill in the blank: To select a column in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + Space

b)

Ctrl + Shift + Down Arrow

c)

Alt + C

d)

Shift + Space

48.

Fill in the blank: To select a row in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Shift + Space

b)

Ctrl + Space

c)

Alt + R

d)

Ctrl + Shift + R

49.

Fill in the blank: To select all in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + A

b)

Ctrl + S

c)

Ctrl + Shift + A

d)

Alt + A

50.

Fill in the blank: To find text in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + F

b)

Ctrl + S

c)

Alt + F4

d)

Ctrl + Shift + T

51.

Fill in the blank: To find and replace in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + H

b)

Ctrl + F

c)

Ctrl + G

d)

Ctrl + R

52.

Fill in the blank: To fill a range in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + Enter

b)

Ctrl + Shift + V

c)

Alt + F4

d)

Ctrl + Shift + L

e)

Ctrl + D

53.

Fill in the blank: To fill down in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + D

b)

Ctrl + C

c)

Ctrl + V

d)

Ctrl + X

54.

Fill in the blank: To fill right in Google spreadsheets on a PC, use the keyboard shortcut _____

a)

Ctrl + R

b)

Ctrl + Shift + R

c)

Ctrl + F

d)

Alt + R

55.

Fill in the blank: To save a Google spreadsheet on a PC, use the keyboard shortcut _____

a)

Ctrl + S

b)

Ctrl + P

c)

Ctrl + C

d)

Ctrl + V

56.

What is the keyboard shortcut for 'Print' in Google spreadsheets on Windows?

a)

Ctrl + P

b)

Ctrl + S

c)

Ctrl + Shift + P

d)

Alt + P

57.

What is the keyboard shortcut for 'Copy' in Google spreadsheets on Windows?

a)

Ctrl + C

b)

Ctrl + V

c)

Ctrl + X

d)

Ctrl + Z

58.

What is the keyboard shortcut for 'Cut' in Google spreadsheets on Windows?

a)

Ctrl + X

b)

Ctrl + C

c)

Ctrl + V

d)

Ctrl + Z

59.

What is the keyboard shortcut for 'Paste' in Google spreadsheets on Windows?

a)

Ctrl + V

b)

Ctrl + C

c)

Ctrl + X

d)

Ctrl + Z

60.

What is the keyboard shortcut for 'Paste values only' in Google spreadsheets on Windows?

a)

Ctrl + Shift + V

b)

Ctrl + V

c)

Ctrl + Alt + V

d)

Ctrl + Shift + C

61.

What is the keyboard shortcut for 'Insert new sheet' in Google spreadsheets on Windows?

a)

Shift + F11

b)

Ctrl + N

c)

Alt + Shift + S

d)

Ctrl + Shift + T

62.

What is the keyboard shortcut for 'Search the menus' in Google spreadsheets on Windows?

a)

Alt + /

b)

Ctrl + Shift + F

c)

Ctrl + /

d)

Alt + Shift + S

63.

What is the keyboard shortcut for 'Clear formatting' in Google spreadsheets on Windows?

a)

Ctrl + \

b)

Ctrl + Shift + Z

c)

Ctrl + Alt + F

d)

Ctrl + /

64.

What is the keyboard shortcut for 'Move to beginning of row' in Google spreadsheets on Windows?

a)

Home

b)

Ctrl + End

c)

Alt + Shift + Left Arrow

d)

Ctrl + Home

65.

What is the keyboard shortcut for 'Move to beginning of sheet' in Google spreadsheets on Windows?

a)

Ctrl + Home

b)

Ctrl + End

c)

Ctrl + Shift + Home

d)

Alt + Home

66.

What is the keyboard shortcut for 'Move to end of row' in Google spreadsheets on Windows?

a)

End

b)

Ctrl + Home

c)

Shift + Tab

d)

Alt + Right Arrow

67.

What is the keyboard shortcut for 'Move to end of sheet' in Google spreadsheets on Windows?

a)

Ctrl + End

b)

Ctrl + Shift + Arrow Down

c)

Alt + End

d)

Ctrl + Home

68.

What is the keyboard shortcut for 'Scroll to active cell' in Google spreadsheets on Windows?

a)

Ctrl + Backspace

b)

Ctrl + Shift + Arrow Down

c)

Alt + Enter

d)

Ctrl + Space

69.

What is the keyboard shortcut for 'Move to next sheet' in Google spreadsheets on Windows?

a)

Alt + Down Arrow

b)

Ctrl + Shift + Tab

c)

Ctrl + Page Up

d)

Shift + F11

70.

What is the keyboard shortcut for 'Move to previous sheet' in Google spreadsheets on Windows?

a)

Alt + Up Arrow

b)

Ctrl + Page Up

c)

Ctrl + Shift + Tab

d)

Ctrl + Left Arrow

71.

What is the keyboard shortcut for 'Display list of sheets' in Google spreadsheets on Windows?

a)

Alt + Shift + K

b)

Ctrl + Shift + S

c)

Ctrl + Alt + L

d)

Shift + F11

72.

What is the keyboard shortcut for 'Quick sum' in Google spreadsheets on Windows?

a)

Alt + Shift + Q

b)

Ctrl + Shift + S

c)

Alt + =

d)

Ctrl + Alt + Q

73.

What is the keyboard shortcut for 'Select column' in Google spreadsheets on Mac?

a)

Ctrl + Space

b)

Cmd + Shift + Down Arrow

c)

Cmd + Space

d)

Ctrl + Shift + C

74.

What is the keyboard shortcut for 'Select row' in Google spreadsheets on Mac?

a)

Shift + Space

b)

Command + Space

c)

Control + R

d)

Option + Shift + R

75.

What is the keyboard shortcut for 'Select all' in Google spreadsheets on Mac?

a)

⌘ + a

b)

⌘ + s

c)

⌘ + z

d)

⌘ + c

76.

What is the keyboard shortcut for 'Find' in Google spreadsheets on Mac?

a)

⌘ + F

b)

⌘ + Shift + F

c)

⌘ + G

d)

⌘ + Option + F

77.

What is the keyboard shortcut for 'Find and replace' in Google spreadsheets on Mac?

a)

⌘ + Shift + H

b)

⌘ + F

c)

⌘ + R

d)

⌘ + Shift + F

78.

What is the keyboard shortcut for 'Fill range' in Google spreadsheets on Mac?

a)

⌘ + Enter

b)

⌘ + Shift + V

c)

⌘ + Option + F

d)

⌘ + /

79.

What is the keyboard shortcut for 'Fill down' in Google spreadsheets on Mac?

a)

⌘ + D

b)

⌘ + C

c)

⌘ + V

d)

⌘ + Shift + D

80.

What is the keyboard shortcut for 'Fill right' in Google spreadsheets on Mac?

a)

⌘ + R

b)

⌘ + Shift + R

c)

⌘ + E

d)

⌘ + Option + R

81.

What is the keyboard shortcut for 'Save' in Google spreadsheets on Mac?

a)

⌘ + S

b)

⌘ + C

c)

⌘ + V

d)

⌘ + Z

82.

What is the keyboard shortcut for 'Print' in Google spreadsheets on Mac?

a)

⌘ + P

b)

⌘ + S

c)

⌘ + C

d)

⌘ + V

83.

What is the keyboard shortcut for 'Copy' in Google spreadsheets on Mac?

a)

⌘ + C

b)

⌘ + V

c)

⌘ + X

d)

⌘ + Z

84.

What is the keyboard shortcut for 'Cut' in Google spreadsheets on Mac?

a)

⌘ + X

b)

⌘ + C

c)

⌘ + V

d)

⌘ + Z

85.

What is the keyboard shortcut for 'Paste' in Google spreadsheets on Mac?

a)

⌘ + V

b)

⌘ + C

c)

⌘ + X

d)

⌘ + Z

86.

What is the keyboard shortcut for 'Paste values only' in Google Spreadsheets?

a)

⌘ + Shift + V

b)

⌘ + V

c)

⌘ + Shift + C

d)

⌘ + Option + V

87.

What is the keyboard shortcut to 'Insert new sheet' in Google Spreadsheets?

a)

Shift + Fn + F11

b)

Ctrl + Shift + N

c)

Alt + Shift + S

d)

Ctrl + Alt + F11

88.

What is the keyboard shortcut to 'Search the menus' in Google Spreadsheets?

a)

Option + /

b)

Command + Shift + F

c)

Control + Alt + S

d)

Shift + /

e)

Alt + M

89.

What is the keyboard shortcut to 'Clear formatting' in Google Spreadsheets?

a)

⌘ + \

b)

⌘ + /

c)

⌘ + Shift + F

d)

⌘ + Option + Z

90.

What is the keyboard shortcut to 'Move to beginning of row' in Google Spreadsheets?

a)

Fn + Left Arrow

b)

Ctrl + Right Arrow

c)

Alt + Up Arrow

d)

Shift + Down Arrow

91.

What is the keyboard shortcut to 'Move to beginning of sheet' in Google Spreadsheets?

a)

⌘ + Fn + Left Arrow

b)

⌘ + Shift + Right Arrow

c)

⌘ + Option + Up Arrow

d)

⌘ + Shift + Down Arrow

92.

What is the keyboard shortcut to 'Move to end of row' in Google Spreadsheets?

a)

Fn + Right Arrow

b)

Ctrl + Left Arrow

c)

Alt + Down Arrow

d)

Shift + Up Arrow

93.

What is the keyboard shortcut to 'Move to end of sheet' in Google Spreadsheets?

a)

⌘ + Fn + Right Arrow

b)

⌘ + Shift + Right Arrow

c)

Ctrl + Shift + Down Arrow

d)

Alt + Right Arrow

94.

What is the keyboard shortcut to 'Scroll to active cell' in Google Spreadsheets?

a)

⌘ + Backspace

b)

⌘ + Shift + Z

c)

⌘ + Enter

d)

⌘ + /

95.

What is the keyboard shortcut to 'Move to next sheet' in Google Spreadsheets?

a)

Option + Down Arrow

b)

Command + Shift + K

c)

Control + Tab

d)

Alt + Right Arrow

96.

What is the keyboard shortcut to 'Move to previous sheet' in Google Spreadsheets?

a)

Option + Up Arrow

b)

Ctrl + Shift + Tab

c)

Alt + Left Arrow

d)

Command + Down Arrow

97.

What is the keyboard shortcut to 'Display list of sheets' in Google Spreadsheets?

a)

Option + Shift + K

b)

Ctrl + Shift + S

c)

Alt + Shift + L

d)

Cmd + Shift + N

98.

What is the keyboard shortcut to 'Quick sum' in Google Spreadsheets?

a)

Option + Shift + Q

b)

Ctrl + Shift + S

c)

Alt + =

d)

Cmd + Shift + T

Similar Resources on Wayground

2024 NYS FBLA Human Resource Management

100 questions

2024 NYS FBLA Human Resource Management

quiz

Worksheet

•

9th - 12th Grade

MaWD Final Exam

100 questions

MaWD Final Exam

quiz

Worksheet

•

9th - 12th Grade