Spreadsheets Basics
What is a spreadsheet?
A digital tool used to organize, calculate, and analyze data in tabular form.
What is the formula to add two numbers in Google Sheets?
Answer: =A1+A2=A1+A2
How do you change the font size of text in a cell?
Highlight the cell, then select the font size from the toolbar.
What type of chart is best for showing parts of a whole?
A pie chart.
What is the keyboard shortcut to copy selected cells?
Ctrl + C (or Command + C on Mac).
What is the purpose of rows and columns in a spreadsheet?
Rows run horizontally and columns run vertically, allowing data to be organized in cells at their intersections.
What function would you use to find the average of a range of cells?
The AVERAGE function, e.g., =AVERAGE(A1:A10)=AVERAGE(A1:A10)
What are conditional formatting rules?
They allow you to apply formatting to cells based on specific criteria.
How do you create a chart in Google Sheets?
Select the data and click on Insert > Chart.
How do you quickly fill down a column with the same data?
Select the cell with data, then double-click the small square at the bottom right corner of the cell.
How do you rename a sheet in Google Sheets?
Right-click on the sheet tab and select "Rename."
How do you reference a cell in another sheet?
Use the format: SheetName!CellReferenceSheetName!CellReference e.g. Sheet2!A1Sheet2!A1
How can you format a number as currency in Google Sheets?
Select the cell, go to Format > Number > Currency.
What is the difference between a line chart and a bar chart?
A line chart shows trends over time, while a bar chart compares different categories.
What shortcut can you use to undo an action in Google Sheets?
Ctrl + Z (or Command + Z on Mac).
What is the default file format for Google Sheets?
gsheet
What does the function COUNTIF do?
It counts the number of cells that meet a specific criterion.
What is the purpose of merging cells?
To combine multiple adjacent cells into one larger cell for better organization.
How can you customize the colors of a chart?
Click on the chart, then use the chart editor on the right to change colors.
How do you insert a new row above the selected row?
Right-click on the row number and select "Insert 1 above."
How can you share a Google Spreadsheet with others?
Click the "Share" button and enter the email addresses of the people you want to share with.
What formula can you use to find the maximum value in a range?
MAX(A1:A10)
How do you add a border to a cell or range of cells?
Highlight the cells, then click the border icon in the toolbar.
What is the purpose of a legend in a chart?
To explain what each color or symbol in the chart represents.
What is the command to open the function list?
Type "=" in a cell to open the function list.