MS Excel
Where is the merge and center feature in Excel located?
It is located on home tab.
In the alignment group.
Where is the Conditional Formatting feature in Excel located?
Located in the Home tab.
In the Styles group, you’ll find the Conditional Formatting button (next to “Format as Table” and “Cell Styles”).
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.
What is a function?
A function is a pre-set formula in Excel.
Where is the Bold Feature located in excel?
Located in Home tab where the font group is.
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?
Home tab → Editing group (on the far right) → Sort & Filter button.
Data tab → Sort & Filter group → Here you get more advanced options like Sort A to Z, Custom Sort, and Filter.
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?
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)
You have numbers in cells A1 to A10.
How would you quickly find the average of these numbers using an Excel function?
=AVERAGE(A1:A10)
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