Google Sheets for Beginners freeCodeCamp

• What is the difference between functions and formulas?

  Functions are predefined, formulas are custom
• How can you navigate to a specific cell?

  By clicking or using arrow keys
• What shortcut takes you to the top left corner of the spreadsheet?

  Control + Home
• How do you insert a column in Google Sheets?

  Right-click and select insert column
• What is the naming convention for a Google Sheets file?

  It is called a workbook
• How can you rename a sheet in Google Sheets?

  Double-click the sheet name
• What does the blue share button do?

  Allows sharing with others
• What happens when you share a Google Sheet?

  You can control access permissions
• What is the purpose of the table sidebar in Google Sheets?

  To select and format tables automatically
• What are the basic navigation shortcuts in Google Sheets?

  • Control + Home: Top left corner
  • Control + End: Bottom right corner
  • Control + Arrow: Next active cell
• What are the differences between Google Sheets and Microsoft Excel?

  • Google Sheets: Cloud-based, easy sharing
  • Microsoft Excel: Desktop application, more features
• What are the advantages of using Google Sheets for collaboration?

  • Real-time editing
  • Easy sharing options
  • Access control for users
• How do you delete a row in a spreadsheet?

  Right-click the row and select delete
• What does pressing Control + A do in a spreadsheet?

  Selects everything in the sheet
• What keys can be used to delete the contents of a cell?

  Delete button or backspace button
• How can you paste values without formatting in Google Sheets?

  Use Control + Shift + V
• How do you resize columns in a spreadsheet?

  Double-click the column header
• What is the shortcut to create bold text?

  Control + B
• What does converting a range to a table allow you to do?

  Reference items in the budget easier
• How do you rename a table in Google Sheets?

  Double-click the table name
• How do you lock the header row in Google Sheets?

  Drag the gray bar down in the corner
• What is the purpose of generating fake data for the budget?

  To fill out the budget sheet
• What site is mentioned for generating fake data?

  Macaroo
• How do you import data from your desktop to Google Sheets?

  Select file and upload the data
• What should you do if an extra header row appears after importing data?

  Delete the extra header row
• How can you sort data by date in Google Sheets?

  Click the triangle in column A and sort
• What is a function in Google Sheets?

  A built-in operation to perform calculations
• What does the SUM function do?

  Adds values together
• How do you use the SUM function with specific cells?

  Type =SUM and select the cells
• What does the average function do in Google Sheets?

  Finds the numerical average of a dataset
• How many functions are available in Google Sheets?

  Over 400 functions
• What does the COUNT function return?

  Number of numeric values in a dataset
• How do you reference a cell in a formula?

  Type the cell's column and row
• What is the IF function used for?

  To perform conditional logic in formulas
• How do you create an IF statement in Google Sheets?

  Type =IF and provide logical expression
• What does the COUNTA function do?

  Counts all non-empty values in a range
• How can you make a formula more user-friendly in Google Sheets?

  Reference a cell for criteria instead of hardcoding
• How does using a cell reference improve a formula?

  It allows for dynamic updates when values change
• What happens when you copy and paste in Google Sheets?

  It may bring in unwanted formatting
• Why is formatting important in spreadsheets?

  It improves readability and organization