151Tutorial-1-Excel-Primer-Function-Average-Median _1_ Sp24
.xlsx
keyboard_arrow_up
School
Virginia Commonwealth University *
*We aren’t endorsed by this school
Course
BIOZ-151
Subject
Mathematics
Date
Feb 20, 2024
Type
xlsx
Pages
18
Uploaded by CorporalKoalaMaster1044
Yellow highlights mark locations referred to in boxes.
Version 1.02
10/6/2015
Minor typo fixed
In this tutorial, information is presented in blue boxes.
An Excel file usually consists of multiple pages (called Worksheets
) that can be accessed by clicking on tabs that appear at the bottom of the window.
Instructions are in purple boxes.
Click on the worksheet tabs from left to right to follow the tutorials on each page.
Exercises are presented in red boxes.
You can also use Excel's built-in help function by pressing F1. Depending on the Excel version and configuration, this may require an internet connection.
This tutorial was developed in Excel 2010. Not all features and functions may work the same way in earlier or later versions of Excel.
Data
This Cell is E8. Each cell has an address based on the row and column. This is column E.
At the bottom, you see tabs for different pages (called Worksheets). Click on different tabs to look at other pages. This is an Excel Worksheet.
It's basically a big table. Each cell can contain data like text and numbers.
You can click on a cell to select it, or use arrow keys to move around the sheet.
The space above the column hea
the right of "
fx", is the formula b
the selected cell is displayed her
This is row 8.
adings (A, B, C...), to bar
. The content of re.
Plant No.
1
2
3
4
5
6
7
8
Height (cm
7.5
10.1
8.3
9.8
5.7
10.3
9.2
8.7
Plant NumHeight (cm)
Plant NumHeight (cm
1
7.5
1
7.5
2
10.1
2
10.1
3
8.3
3
8.3
4
9.8
4
9.8
5
5.7
5
5.7
6
10.3
6
10.3
7
9.2
7
9.2
8
8.7
8
8.7
1. When you enter data in Excel, think about how you'd like it organized. Do you want to display it horizontally like this?
2. Or vertically like this?
3. You can work either way, but it's usually easier to manage the data if you enter them vertically.
Color
yellow
green
yellow
green
yellow
green
green
yellow
4. If your data has more than one attribute, you can add another column.
Plant Number
Height (cm)
1
7.50
###
2
10.1
3
8.3
4
9.8
5
5.7
6
10.3
PI
Format
7
9.2
3.14159265 General
8
8.7
314.16% Percentage
$3.14 Currency
3 No decimal
3.13E+00 Scientific
Table Column width and Row height can be changed by dragging the border of the columns and rows in the header areas at the top or the left that have A, B, C, D,... and 1, 2, 3, 4...
Font style/size can be changed, and cells can be shaded.
These values are all the same (Pi) but shown in different formats. Change format either by right-
clicking the cell and selecting "
Format Cells
" or from the Home -> Number
section of the ribbon above.
Use an
the ce
signifi
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help