True
False
Logical test and value if true, value if test is false plus formatting option
The logical test and the three possible outcomes
The Logical test plus initial outcome pus true and false
The Logical test and value if test is true, value if test is false
True
False
True
False
True
False
Rows
Cell
Column
True
False
An entire workbook
A single worksheet
A range of cells by range
All of the above
Callouts
Comments
Dialogs
Extensions
True
False
Formula returns the value "DONE"
Formula will show an error
Formula returns the value "RESTART"
Formula returns the value "YES"
* and /
- and /
* and ?
+ and -
Row F column 5
Column F row 5
Functions available in cells
Function key F4
Formula Bar
Name box
Column
View Tab
True
False
Hold down the CTRL key
Hold down the SHIFT key
Hold down the ALT key
Control + spacebar
Shift + spacebar
Alt + spacebar
Shift + Tab
True
False
Sheet Tabs
Book Tabs
Menu Bar
=ADD(J1-J8)
=SUM(J1:J8)
=J:1+J:8
=SUM J:1-8
Wait!
Here's an interesting quiz for you.