Excel 2010 Formula Bar
Introduction:
Purpose:
The Formula Bar
allows users display the active cell. Users can use the Formula Bar to create functions as well as enter
data and formulas into the Formula Bar.
Location:
The Formula
Bar is located below the Ribbon,
to the right of the Name Box.
Parts:
Cancel Command:
The Cancel command allows
users to remove any data or function from within the Formula Bar Text Box
and
Excel returns the focus of the keyboard back to the active cell. The Cancel command is located on the left side of the Formula Bar. If the keyboard
cursor is not within the Formula Bar Text Box the Cancel Command is not visible.
Enter Command:
The Enter command allows
users to apply the data or function within the Formula Bar Text Box
to
the active cell. The Enter command is located
on the left side of the Formula Bar, to the right of the Cancel
command and to the left of the Insert Function
Command. If the keyboard cursor is not within the Formula Bar Text Box the
Cancel Command is
not visible.
Insert Function
Command:
The Insert Function command allows users to search for
pre-created Excel functions. Once clicked the Excel opens the Insert Function Window. The Insert Function command is located
on the left side of the Formula Bar, to the right of the Enter
command and to the left of the Formula Bar Text Box.
Formula Bar Text Box:
The Formula Bar Text Box allows users to enter data or functions they want to
apply to the active cell. The Formula Bar Text Box is located
in the middle of the Formula Bar, to the
right of the Insert Function Command and
to the left of the Expand Formula Bar Command.
Expand Formula Bar
Command:
The Expand Formula Bar command allows users expand the Formula Bar Text Box. The Expand
Formula Bar command is located on the right of the Formula Bar. If the Formula
Bar Text Box is expanded, the Expand
Formula Bar command is hidden.
Collapse Formula Bar
Command:
The Collapse Formula Bar command allows users to collapse the Formula Bar Text Box. The Collapse
Formula Bar command is located on the right of the Formula Bar. If the Formula
Bar Text Box is collapsed, the Collapse
Formula Bar command is hidden.
No comments:
Post a Comment