Module 4 Flashcards
(17 cards)
Is an integrated software package that enables you to share information between several applications.
Microsoft Office
Replaced the menus and toolbars and was first introduced with Excel 2007.
Ribbon
What are the three types of data in cells?
Labels - Values - Formulas
Is a predefined formula that performs calculations using values indicated in a particular order.
Function
The specific way in which a function is written is referred to as?
Syntax
This is the name denoting a particular mathematical, logical or statistical function.
Formula Name
Supply the information for the function to calculate, such as a range of cell references.
Arguments
You can include a maximum of ____ arguments in a function.
1024
Arguments must be enclosed within what?
Parentheses
They apply the formula to the indicated range of cells.
Colon
This is used when you want to apply a function to specific cells, but not over a range of cells.
Comma
This group contains the buttons that are used to change the font style, size, and color of the contents of a cell.
Font Group
This group also holds the buttons to boldface, italicize, and underline cell contents, as well as the button to apply/remove the border and fill color to cells.
Font Group
This group contains the buttons used to format the vertical and horizontal alignment, text direction, wrap text, merge & center, and indentions of the contents of selected cells.
Alignment Group
This group contains buttons that are used to format cell contents as currency, date, time, percentage, or into other number formats.
Number Group
This group contain buttons that are used to format cells with the default settings in MS Excel. Conditional formatting, format as table, and cell styles are parts of this group.
Styles Group
What are the three parts of a function?
Formula name, equal sign, arguments
