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