CIS
Increase and decrease decimal
option to control how many digits are shown after the decimal. User must first choose the cells, then navigate to the home tab and select Increase Decimal or Decrease Decimal
Cell
perpendicular meeting of a row and column is known as a cell
Borders can be applied to
phrases or entire paragraphs by highlighting the table then going to the menu and using all borders
Font unit is
point
Active cell
purpose functions to explain what the cell's purpose is and where data input goes
Bookmarks are
reference points that you've made inside of the text
How to make line transparent ?
remove fill and remove line to make it transparent
To make lines straight use
shift and begin drawing
For yes and no modules use
small rectangle
Average
the average can be found by using the autosum function. In order to toggle autosum, choose a cell near the numbers you want to add and then click autosum
Autosum
the option to add a column or a row and Excel will calculate the answer . In order to toggle autosum, choose a cell near the numbers you want to add and then click autosum which can be found in the home tab
Function i.e. operation
the sequencing of how tasks are completed addition (+), subtraction (-), multiplication (x) and division (/)
Merge and Center
the user can select or highlight the cells they wish to be merged and centered.This option can be found in the alignment part of the menu bar.
Data types in cells
true or false, yes or no, and binary or 1 or 0
Font name is a
typeface
Text to columns converting
user must choose the cell that holds the text you want to split, Select Data > Text to Columns, select Delimited > Next and Select the Delimiters for your data
Nonadjacent selection (how to highlight nonadjacent items?)
user must hold control and individually select each cell they want
Copy area
user should select the area then press control c to copy it, and then press control v to paste
Operand
value that is involved in an operation. Operands must be performed by operators. The user must provide their own value for operands
Formula
way to add, subtract, multiply, and/or divide values in the worksheet. Simple formulas always begin with the equal sign
Concatenation
when character strings are joined end to end. To toggle concatenation, the user must first choose the cell where they want to put the formula, type =CONCATENATE (in the cell or formula bar), hold Ctrl and click every cell they want to apply the formula, and release ctrl button and close the parenthesis in the formula bar and press Enter.
Operation IF
will run a test and give the user back a binary value
To add borders to a table
you must highlight the table then go to the menu and use all borders
Range of cells
number of cells highlighted in a document
Fill handle
option for the user to complete the row of numbers by finishing the equation
Font size is one point to
72 inches
Absolute cell reference
Cell reference that does not adjust to the new cell location when copied or moved
What is >=, <=, <>
These symbols are used to denote true and false statements
Workbook
a file holding a collection of worksheets
Charts
a medium to convey data graphically
Autofit
a way for users to resize cells
Shortcuts
are a combination of keyboard keys
Hyperlinks can be
attached anywhere and are crucial for websites
Conditional formatting
can be achieved by selecting the range A1:A10 and then click Home, in Styles group, and then Conditional Formatting
Number categories (General, Currency, Date, Time, Percentage, Fraction, Text)
can be formatted in cells
Columns
can be found by going to page layout then clicking columns (also different styles of columns)
Sum
can be found by typing in the values then typing in = sum. the function works as a calculator and adds the values in a cell range
hyperlinks
can be removed by highlighting the hyperlink text, right clicking, and then clicking remove hyperlink
relative cell reference
cell reference that adjusts to a new location when copied or moved
Select text, Shift F3
changes the casing of the document
To duplicate shape
click border and press control d
In order to type in shape
click inside
You can see what alignment your paragraph has by
clicking the paragraph and looking in the home tab
When you position your cursor on the hyperlink you will see the full web address. In order to go to the link
control + click it
Format painter is used to
copy and paste character and paragraph formats to existing text
If text is dimmed
double click to interact with it
Orientation is the
form factor of the layout
Count
function that organizes the number of entries into a field that consists of a range of numbers subfeature of autosum
Operation AND
functions to combine the results of two expressions. The operation AND is a concatenation
Operation IF
functions to create logical comparisons between the actual value and the value the user expects
Worksheet
functions to let the user know the number of the sheet for a cell reference. It also gives the number of tables
Operation NOT
functions to test if a value is or is not equal to another value. The operation NOT always gives a reverse logical value
In order to change layouts
go to view and then you will have read mode, print and web layout
Borders for shapes can be found by
going to format shape then choosing solid or gradient line
You can draw shapes by
going to shapes then draw a shape
Triple click to
highlight paragraph
Not all ___ can be removed
hyperlinks
Insert shapes can be used to
insert shapes into the document
Header and footer can be
inserted in the menu bar
Formula bar
is a small bar underneath the ribbon that shows the information in the highlighted cell
Max
is a way for the user to be given the largest value of numbers listed. organized under statistical function
Min
is a way for the user to be given the smallest value of numbers listed. It is organized under statistical function
Name box
is an input box on the immediate left of the formula bar
Logical test
is when logical functions are used to assess the data of a cell location. It will check for a predetermined condition and if that condition is met then the results will be shown according to the set logic.
Cell address (Cell reference)
joining of the row number and column letter
To nudge a graphic, simply
make sure it is selected, and then use the arrow keys