BUS 1350 Exam 1
on the top of the workbook
Files, Home, Insert, Page Layout, Formulas... - ✔✔Ribbon
contain commands specific to whatever object you are currently working on - ✔✔Tabs and
Contextual Tabs
A small arrow in the lower-right corner of the group
this provides more options related to the group on the ribbon - ✔✔Dialog Box Launcher
Control C - ✔✔Shortcut to copy
Control A - ✔✔Shortcut to select all objects in a range
Control V - ✔✔Shortcut to Paste
Control X - ✔✔Shortcut to Cut
Control S - ✔✔Shortcut to save
Control P - ✔✔Shortcut to Print
Control Z - ✔✔Shortcut to undo
F1 - ✔✔Shortcut to open Excel Help Window
F5 - ✔✔Shortcut to open the Go To Dialog Box
F2 - ✔✔Shortcut to Edit a Cell
Alt = - ✔✔SUM Function
Workbook - ✔✔Excel is a
Worksheets - ✔✔Excel contains multiple
intersection of a row and a column - ✔✔Cell
cell address - ✔✔each cell has its own name or
it is highlighted or outlines
it is the insertion point - ✔✔how to know when you are on an active cell
Formula Ribbon - ✔✔Which ribbon contains the Function Library
, shows you contents of cell before the calculation was made - ✔✔Formula Bar
reflects current location and can take you to a symbol - ✔✔Name Box
selecting a group of cells at one time
symbol is a colon (E5:E10)
you can make a range using the name box and name it to make it easier to access - ✔✔Range
The small black square in the lower right corner of a selected cell
it allows you to fill the formula or number in the active cell either up, down, to the left, or to the right -
✔✔Fill handle
right click it and click rename - ✔✔To rename a worksheet
Normal, Page Layout, Page Break and Custom View
all found in the bottom right of the workbook - ✔✔Worksheet views
text
values (constant)
formulas (functions) - ✔✔different values that can go into a cell
the left - ✔✔text aligns on which side of the cell
make it an active cell and type over old text
edit in formula bar
double click cell to move the insertion point into the text
use F2 function key to edit - ✔✔4 ways to edit a cell
the cell will cut off the word if it overlaps the space provided - ✔✔Truncated Text
move mouse pointer onto dividing line between columns and drag
double click dividing line for auto-fit
right click column and specify column width - ✔✔3 ways to widen a column
forces the text to move down to the next line in the active cell rather than being truncated -
✔✔wrap text
Alt Enter - ✔✔how to insert a line break
the right - ✔✔numbers align on which side of the cell
over 15 digits - ✔✔how many digits converts to scientific notation
#### - ✔✔if a value is too long for the width of the column, it will not spill over like the text does
because you cannot truncate numbers, instead it converts to
widen the column using one of the three ways described before - ✔✔how to fix ###
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller AnswersCOM. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £9.12. You're not tied to anything after your purchase.
