Intro to Data Analytics 1.2: Introduction to Excel Flashcards
Files in Excel are referred to as ?
Workbooks
each workbook can contain one or multiple worksheets?
True
collections of data or called what?
data sets
data sets, are represented in a table of
Columns and rows
Columns run vertically and are labeled
Alphabetically
rows run horizontally and are labeled
numerically
How to reach the last cell in the arrow key’s direction?
Ctrl (PC) or Command (Mac) with an arrow key to quickly reach the last cell in the arrow key’s direction.
Hold Shift + Ctrl/Command and an arrow key to select an entire
column, row or range in that specific direction
Draw
includes options for drawing in your worksheet, such as the pen.
Page layout
is used to set margin widths and print areas.
Formulas
provides many helpful functions grouped together by type (e.g., functions for dealing with dates or text)
Review
allows you to edit your spreadsheet and collaborate with coworkers.
View
contains options for adjusting the view of your worksheet, such as Zoom In/Out and “Freeze Panes,” which keeps rows or columns visible as you scroll.
CSV Files
(Comma Separated Value), which are plain text files that contain a list of data. It’s a useful format for moving complex data from one application to another.
In data files, the discrete values in each field are separated by a character known as a
delimeter
In data files, the discrete values in each field are separated by a character known as a
delimiter
CSV files, the _____ is typically a comma, though you may sometimes see semicolons or tabs used instead.
delimter
How to sort data in excel?
First, select the column you want to sort, in this case column A, by placing your cursor in row 1 of that column.
Open the Home tab, click Sort and Filter, then select Sort A to Z. (Note: To sort in reverse alphabetical order, you could select Sort Z to A, but for now, let’s stick with Sort A to Z.)
Name and locate where you can find the two ways to check for typos
manually or using Excel’s spellchecker, which can be found in the Tools menu.
Ehat does Filtering do?
allows you to focus on a portion of your data that meets some defined criteria and hides the rest. If you were working with a data set containing voter information, for example, you might want to focus on the data for voters within a specific age range or from one political party. Alternatively, if you had a company’s national sales data, you might want to look at sales for a particular region or store. All types of data can be filtered, including text, numbers, and even dates!
