Intro to Data Analytics 1.2: Introduction to Excel

Question 1

Files in Excel are referred to as ?

Answer 1

Workbooks

Question 2

each workbook can contain one or multiple worksheets?

Answer 2

True

Question 3

collections of data or called what?

Answer 3

data sets

Question 4

data sets, are represented in a table of

Answer 4

Columns and rows

Question 5

Columns run vertically and are labeled

Answer 5

Alphabetically

Question 6

rows run horizontally and are labeled

Answer 6

numerically

Question 7

How to reach the last cell in the arrow key’s direction?

Answer 7

Ctrl (PC) or Command (Mac) with an arrow key to quickly reach the last cell in the arrow key’s direction.

Question 8

Hold Shift + Ctrl/Command and an arrow key to select an entire

Answer 8

column, row or range in that specific direction

Question 9

Draw

Answer 9

includes options for drawing in your worksheet, such as the pen.

Question 10

Page layout

Answer 10

is used to set margin widths and print areas.

Question 11

Formulas

Answer 11

provides many helpful functions grouped together by type (e.g., functions for dealing with dates or text)

Question 12

Review

Answer 12

allows you to edit your spreadsheet and collaborate with coworkers.

Question 13

View

Answer 13

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.

Question 14

CSV Files

Answer 14

(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.

Question 15

In data files, the discrete values in each field are separated by a character known as a

Answer 15

delimeter

Question 16

In data files, the discrete values in each field are separated by a character known as a

Answer 16

delimiter

Question 17

CSV files, the _____ is typically a comma, though you may sometimes see semicolons or tabs used instead.

Answer 17

delimter

Question 18

How to sort data in excel?

Answer 18

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.)

Question 19

Name and locate where you can find the two ways to check for typos

Answer 19

manually or using Excel’s spellchecker, which can be found in the Tools menu.

Question 20

Ehat does Filtering do?

Answer 20

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!