Spreadsheets Major Test Retest

What does Google Sheets allow you to do with a significant amount of data?

• Analyze and work with it

• Delete it automatically

• Convert it into images

• Create automatic backups

What does sorting a sheet do?

• Deletes selected data

• Encrypts the data

• Organizes all data in the spreadsheet by one column

• Changes the color of the cells

What is the first step in the order of operations?

• Addition and Subtraction

• Multiplication and Division

• Parentheses

• Exponents

How can you create a filter view in Google Sheets?

• By right-clicking on a cell

• By clicking the drop-down arrow next to the Filter button

• Using the chart editor

• Through the sharing settings

What is the correct order of operations?

• Addition, Subtraction, Multiplication, Division, Exponents, Parentheses

• Multiplication, Division, Addition, Subtraction, Parentheses, Exponents

• Parentheses, Exponents, Multiplication, Division, Addition, Subtraction

• Exponents, Parentheses, Addition, Subtraction, Multiplication, Division

What does applying the percentage (%) format to a cell do?

• Makes the cell read-only

• Changes the cell color to green

• Displays values as percentages

• Converts the cell into an image

What does decreasing the decimal places in a cell do?

• Changes the cell's background color

• Deletes the cell's content

• Displays the value rounded to that decimal place

• Automatically applies a currency format

What is the formula example given for calculating the amount spent on food items?

(Hint: you have 5 apples that cost $0.25 each)

• =B4*C4

• =B4+C4

• =B4-C4

• =B4/C4

What is the purpose of using formulas in Google Sheets?

• To format text

• To insert images

• To calculate data

• To create graphs

What can cause the spreadsheet to treat a date as text?

• Using the fill handle

• Entering the date in a recognized format

• Typing the month name only

• Applying the date format first