MS Excel
Where is the merge and center feature in Excel located?
What is the home tab.
What is the alignment group.
Where is the Conditional Formatting feature in Excel located?
What is the Styles group?
What is the Home tab?
What are columns in excel?
Columns go up and down.
Labeled with Letters.
What does Freezing Panes Do?
Keeps Rows and columns frozen while the rest of your spreadsheet scrolls.
A function is a pre-set formula in Excel.
Where is the Bold Feature located in excel?
What is the font group?
What is the Home tab?
What is Excel?
What is a spreadsheet Program?
What are Rows in excel?
Rows go side to side.
Labeled with numbers.
What does freezing the top row do?
Keeps the top row visible while scrolling through the rest of the spreadsheet.
What are Conditional Statements?
Conditional Statements are functions on excel which check whether or not a condition is met, then it returns a value if true or another value if false.
Where is the Sort and Filter feature in excel located?
What is the editing group?
What is the home tab?
What is the difference between a workbook and a worksheet?
Workbook is a file containing related worksheets.
Worksheet is a single spreadsheet.
How do you insert a row?
Place the cursor in the row where the new row is desired
Select the insert button in the home tab and select insert rows.
Home Tab -> Insert Button -> Insert Row Above/ Below
What does freezing the first column do?
Keeps the first column visible while scrolling through the rest of the spreadsheet.
What is an if function?
The if Function returns one value when a condition is met and returns another value when the condition is not met.
What Formula would you use to find the total amount of a specific data set?
What is the SUM formula?
What is a cell?
The intersection of a row and a column.
How do you insert a Column?
Place the cursor in the column where the new column is desired.
Select the insert button in the Home Tab and select Insert Columns
Home Tab -> Insert Button -> Insert Column Left/Right
What must you include first in a function or formula?
An equal sign.
What is the Count IF Function?
Counts the number of cells within a rage that meet the given criteria (or...conditional count)
What is the set up of the IF Function?
What is (Logical Test, Value if true, value if false)
What is the cell address? Provide an example
The address of the cell is designated by column and row.
How do you delete a row/column?
Home Tab -> Delete -> *Select the Down Arrow* -> Delete sheet Columns or Delete Sheet Rows
What is a formula?
A formula refers to the actual math equation.
What is autofill?
Auto fills allows you to fill cells with data that follows a pattern or are based on data in other cells