HOSP 187 Study Guide - Spring 2018, Comprehensive Midterm Notes - Dialog Box, Computer Mouse, Decimal
HOSP 187
MIDTERM EXAM
STUDY GUIDE
Fall 2018
Hospitality 187 – Unit 1 In-Class Notes
What can you do with Excel?
o Common task performed using excel
▪ Business documents
▪ Scientific data
▪ Personal documents
o Helps ou aalze a spreadsheet’s data ill thik for ou
Creating a basic worksheet
o Grid of rows and columns
o Cells: smallest unit, address C6, hold up to 32,000 characters
o Worksheet: up to 16,000 columns (a-z, aa-zz,… ad ,
rows
Adding column titles
o The most common and useful way to arrange your information is
as a table, with headings for each column
o The deisio aout hat’s goig to go i eah olu a hae a
big effect on how easy it is to manipulate your information
o Add your headings in the row of cells at the top of the
worksheet (row 1). Adding information is easy – just click (select)
the cell you want and start typing
o Whe ou’re fiished, hit ta to oplete our etr ad oe
to the next cell to the right (or event to head to the cell just
underneath)
Let’s start ith a Purhases Worksheet
find more resources at oneclass.com
find more resources at oneclass.com
o Create the folloig olu titles”
▪ Date purchased stores the date when you spent the
oe epad the olu if it does’t fit – double click to
expand)
▪ Item stores the name of the product that you bought
▪ Price records how much it costs
Editing Data
o To edit data (instead of replacing it), put the cell in edit mode:
▪ Move to the cell you want to edit
▪ Put the cell in edit mode by pressing F2 or double clicking
the cell
▪ Complete your edit
▪ Oe ou’e odified the ell otet, press eter to
make your change or ESC to cancel your edit and leave the
old value in the cell
Moving Around the Grid:
o Use the arrow keys on the keyboard.
o Tab → moves one cell to the right
o Shift/tab → moves one cell to the left
o Arrow up → moves one cell up
o Arrow down or enter → moves one cell down
o Page up → moves up one screen.
o Page down → moves down one screen
o Home → moves to the first cell of the current row (column A)
o Control/Home → moves to the first cell in the top row, which is
A1
find more resources at oneclass.com
find more resources at oneclass.com