.
Control + Home
Control + F4 key
Name box
Control + A1
Control + Tab key
1 worksheet
2 worksheets
3 worksheets
4 worksheets
No worksheets
Cell style
Fill handle or Autofill
Page layout
Find
Replace
Justified
Left aligned
Centered
Bottom aligned
Right aligned
Mixed reference
Absolute reference
Relative reference
Additional reference
Money reference
Addition
Subtraction
Division
Percentage
Multiplication
Landscape
Portrait
Form
Demonstration
Template
Cell styles
Page Layout
Tools
Format
F4
F2 or double-click cell
Find and replace
Tools, Columns, Styles
Data bars, Color scales, Icon sets
Cell styles, Bold, Italics
Home, Edit, Fill
Shapes, Arrows, Clip art
Average()
Count()
Mean()
SumIF()
Round
Min()
Avg()
Max()
Most()
Sum()
NOT function
False function
Nper function
Sum function
PMT function
NPER function
Sum function
FV function
PMT function
Today function
Conditional
Argument
Nested
Double
Hyperlink
Adds another argument
Displays a website
Formats worksheet
Hides worksheets
Now()
Days()
DDYYMM
TODAY()
1
2
1.57
1.6
Renames the workbook
Closes the program
Recaculates it based on the computer where it is opened
Nothing changes
Looks up text that contain ‘v’
Checks whether text is the same in one cell as in the next
Finds related records
All of above
Lines and spaces
Layers and planes
Rows and columns
Height and width
Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Graphic program
None of these
Word processor
A spreadsheet
Go to File-Save As – Save As Type – Excel worksheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select Insert – Entire Column
None of above