Lesson on Excel Flashcards
What is an “What if Analysis”
lets you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values
Where is the ribbon located on Excel?
On the top
What group exists only on Excel and not Word?
Numbers Group
What does the Namebox show?
The Current Cell
By default you start with one Sheet, you click the ___ to add more
the + button
What is another name for a Spreadsheet?
Worksheet
What is a Chartsheet
a chartsheet is a worksheet that only contains a chart.
What is a workbook?
A collection of worksheets/spreadsheets.
How can you tell which is the active sheet?
The one that is highlighted and shown in the number box
What does Ctrl + Home do in Excel?
Brings you to Cell A1
What does Ctrl + End do in Excel?
Brings you to last cell in worksheet containing data
What does Shift + Enter in Excel
Goes up a row
What does Tab do?
Goes a column to the right
What does Shift + Tab do?
Goes a column to the left
What does Page Up/Down do?
Up or Down One Screen
What does Ctrl + Page Up/Down do?
Moves the active cell to the previous or next sheet in the workbook
What does Enter on Excel?
Moves the active cell down one row or to the start of the next row of data
What does Home do?
To column A of the current row?
What does Alt + Enter do?
Allows you enter another line within same cell
How do you re-fit row or column of cells?
To fit the cell, expand the cell then double click in between the column/row headings
What are three types of data in Excel?
Text Data, Number Data, Date and Time Data
What is Text Data?
- A text string
2. A combination of alphanumeric characters of words and string
A group of cells is called a
cell range
An adjacent range is a
single rectangular block of cells
A non-adjacent range consists of
2+ distinct adjacent ranges
A range reference indicates the
location and size of a cell range (ie. F3:I5;J4:J5)
An adjacent block is highlighted using ____ and the non-adjacent nearby can be added with ____.
Shift, Ctrl
____ is an expression that returns a value
Formula
Use F2 to enter ____
Edit Mode
____ are used to simply formulas
Functions
You can reverse things by clicking the ___
undo button
Ctrl + ` goes to
Formula View
What is a benefit of a properly formatted workbook?
Easier to read
The default theme of Excel is ____.
Office Theme
Live preview allows you to: ___________
Live preview allows you to preview changes to your document before you commit to finalizing those changes.
Live Preview comes into effect when, for example, you highlight text and open the font drop-down menu.
Why is (32) more preferred than -32, at least for accountants?
When going down with a pencil, it is harder to turn -‘s into +’s with brackets.
To format a cell, first do what?
Select
Dates and times in Excel appear as _____:
Text
T/F: Combining different cells is called aligning?
False it is merging
T/F: Text is oriented from left to right horizontally by default?
True
T/F: A style is a collection of formatting?
True
T/F: Excel has built-in styles?
True
What is the difference between a serif font and a sans serif?
A Serif Font has Serifs (Edges)
What is the general number format?
The default number format
Why are dates right aligned within a worksheet by default?
Excel store dates and times as Numeric Values.
The range A1:C5 is merged into a single cell, what is it’s reference?
A1
Where can you access all of the stored font options for cells?
Cells > Format Cells > Font
T/F: A relative ref is a cell ref that changes when it is copy and pasted in a new location?
True
T/F: Functions are organized in the function library list?
True
__ allows you to change things into absolute with the $ signs.
F4