Mastering Google Sheets Basics

What function would you use to add numbers in Google Sheets?

• SUM

• ADD

• TOTAL

• SUMIF

How do you change the font size of text in a cell?

• Right-click the cell and select 'Increase Size'.

• Change the font size in the page settings.

• Use the keyboard shortcut Ctrl + Shift + F.

• Select the cell, then adjust the font size from the toolbar.

Which chart type is best for showing trends over time?

• Scatter plot

• Pie chart

• Line chart

• Bar chart

What formula would you use to find the average of a range of numbers?

• Average = (Sum of numbers) / (Count of numbers)

• Average = (Sum of numbers) + (Count of numbers)

• Average = (Product of numbers) / (Count of numbers)

• Average = (Largest number) - (Smallest number)

How can you sort a list of names in alphabetical order?

• Reverse the list to achieve alphabetical order.

• Use a random function to shuffle the list of names.

• Use a sorting function like 'sorted()' in Python to sort the list of names.

• Sort the names by their length instead of alphabetically.

What is conditional formatting used for in Google Sheets?

• To sort data in ascending or descending order.

• To create charts and graphs automatically.

• To protect sheets from unauthorized access.

• To visually highlight cells based on specific conditions.

Which function would you use to count the number of cells with numbers?

• SUM

• AVERAGE

• MAX

• COUNT

How do you change the background color of a cell?

• Change the font style to bold.

• Select the cell, then choose a background color from the formatting options.

• Right-click the cell and select 'Delete'.

• Insert an image into the cell.

What type of chart would you use to compare different categories?

• Line chart

• Scatter plot

• Bar chart

• Pie chart

What formula would you use to subtract one number from another?

• result = minuend + subtrahend

• result = minuend - subtrahend

• result = minuend * subtrahend

• result = minuend / subtrahend