Databases and Graphs
How to download an excel file/database to Google Sheets
What is "Open with Google Sheets"?
A function used to make logical comparisons between values
A Pivot Table
What is a powerful data summarization tool that can automatically sort, count, and sum up data stored in tables and display the summarized data?
A groups of cells
What is a cell range?
Difference between a Worksheet and a Workbook
What is A workbook is a spreadsheet file that contains one or more worksheets. A worksheet consists of cells (organized into columns and rows) in which you can enter and calculate data ?
Two examples of types of graphs/charts
What are line graphs, area graphs, pie charts, column chart, bar chart, scatter plot, and/or maps?
=AVG(C4:C7) with C3=8, C4=12, C5=16, C6=20, C7=24, C8= 28, C9=32
What is 18?
What is:
Insert -> Pivot Table -> Select correct range -> Create in New Sheet ?
The steps to arrange a range in alphabetical order
What is: select range -> data -> sort range -> sort column by alphabetical order (A to Z)?
A process that makes it easy to highlight certain values or make particular cells easy to identify. It changes the appearance of a cell range based on a condition.
What is conditional formatting?
The 7 aspects of a good DBMS
What is massive, persistent, safe, multi-user, convenient, efficient, and reliable?
=5-8*2+SUM(E17:E20)
What is 25?
The 4 parts of a Pivot Table
What are filters, rows, columns, and values?
What *Image 1* represents
What is the "merge cells" button?
Select the cells that you want to contain the lists.
On the ribbon, click DATA > Data Validation.
In the dialog, set Allow to List.
Click in Source, type the text or numbers that you want in it, and click OK.
What are the steps to create a dropdown list?
Steps to create a presentation in which data is being shared (7 total steps)
What is:
1. Organize your Data
2. Identify your audience
3. Choose a presentation type
4. Label your Data
5. Introduce your research
6. Focus on main data points
7. Summarize ?
=SQRT("23+2")
What is an error (#VALUE!)?
Prevent subtotals and grand totals from being displayed in a pivot table
What is
“Options” tab -> Uncheck the “Show subtotals” and “Show grand totals” options?
*Image 3* Some of the contents in column B are cut-off. This is how to fix this so the whole text appears.
What is selecting column B and drag the divider line on the right-hand side to the right, to resize the column?
The different types of number data formats available in Excel
What are Number, Percent, Scientific, Accounting, Financial, Currency + rounded, Date, Time, Date + Time, and Duration?
Analyze *Image 4*
We will talk about it
Turn this into an IFS Function:
=IF(B2>150, 10%, IF(B2>=101, 7%, IF(B2>=51, 5%, IF(B2>=1, 3%, ""))))
What is =IFS(B2>150, "10%", B2>=101, "7%", B2>=51,"5%", B2>=1, "3%")
The different aspects of *Image 2*
We will talk about the answer
Reference a cell from another worksheet
What is:
Select a cell -> Type = sheet name, an exclamation point, and the cell being copied( =Sheet1!A1 or ='Sheet number two'!B4) ?
VLOOKUP formula
What is =VLOOKUP (What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE) ?