computer skills (EXEL) Flashcards
Enter text in cells
Click on a cell and type your text. Press Enter to confirm
Inserting and deleting cells
To insert rows or columns, select a cell and use the “Insert” option. To delete cells, use the “Delete” option in the Home tab.
Selecting rows and columns
Click on a row or column heading to select it.
For multiple rows or columns, hold down the mouse button and drag over adjacent headings.
Showing and hiding rows and columns:
Right-click on selected rows or columns and choose “Hide” to hide them.
To unhide, select surrounding rows or columns, right-click, and choose “Unhide”.
Freezing rows and columns:
Select a cell below or to the right of the rows or columns you want to freeze. Go to the View tab, and choose “Freeze Panes”.
Freezing the top row or first column:
Go to the View tab and select “Freeze Top Row” or “Freeze First Column”.
Specifying column width or row height:
Right-click on a column or row header, select “Column Width” or “Row Height”, and specify the size.
Changing column width or row height with the mouse:
double-click the border between column or row headers or drag it to adjust.
Releasing locked cells in a protected worksheet:
Remove protection by going to the Format menu, selecting “Unprotect Sheet”, entering the password, and choosing “Lock Cell” for unlocked cells.
Merging cells:
Select cells, and choose “Merge & Center” from the toolbar.
Copying and Pasting Content:
Highlight the content, click “Copy”, choose destination cell, click “Paste”, select paste option.
Applying a table style:
Highlight cells, Click “Format as Table”, Select preferred style, click “OK”.
Using the Auto Fill function:
Using the Auto Fill function:
Sorting tables:
Select a column, and use the “Sort” option in the Data tab.
Adding additional sorting levels:
Use the “Add Level” button in the Sort dialog box.
sorting data records by cell color:
Use the “Sort” button and select “Cell Color” as the sorting criteria.
Showing and hiding decimal places:
Use the Increase or Decrease Decimal buttons in the Number group.
Formatting numbers as text:
Select cells, and choose “Text” from the Number Format dropdown.
Custom number format:
Use the “Custom” category in the Format Cells dialog box.
Structure and Entry of Formulas:
Begin by selecting the cell where you want the result. Start the formula with “=”.
Enter the numbers or select cells for calculation.
Use operators like +, -, *, / for arithmetic operations.
Complete the formula by pressing Enter.
Calculating with Formulas and Cell References:
Choose the cell for the formula.
Start with “=”.
Click on the first cell or input its reference.
Enter the operator for the desired calculation
Click on the second cell or input its reference.
Press Enter to compute the result.
Using Names in Formulas:
Double-click the cell to assign a name.
Remove the cell reference and input the assigned name in the formula.
Deactivating Table Names in Formulas:
Access the Options menu.
Navigate to Formulas.
Disable the option for using table names in formulas.
Copying Formulas with Relative References:
Select the cell containing the formula to copy
Click and drag the fill handle to adjacent cells.
External Cell Reference
Begin the formula with “=”.
Open the external workbook.
Navigate to the desired cell to reference.
Press Enter to include the external reference.
Updating External References Automatically:
Open the file with external references.
Click on the “Update” button to refresh references automatically.
Updating External References Manually:
Navigate to the Data tab.
Select Edit Links and then Update Values.
Absolute References:
Choose the cell containing the formula.
Press F4 to toggle between relative and absolute references.
Absolute References on Functions:
Add “$” before row/column references to make them absolute.
Finding Circular References:
Access the Error Checking options.
Select Circular References to identify them. Trace precedents to locate the circular reference.
Subtract, Multiply, Divide: formula
Start with “=”.
Use “-“ for subtraction, “*” for multiplication, and “/” for division operations. Input the numbers or cell references for the calculation.
Press Enter to compute the result.
Entering a Function:
Begin with “=”.
Enter the function name followed by an open parenthesis. Input the parameters or cell references.
Close the parenthesis and press Enter.
Using the Function Wizard:
Click on “Insert Function” in the formula bar.
Choose the desired function from the list.
Follow the wizard’s prompts to input
parameters.
Using the Function SUM, AVERAGE, IF, SUMIF, ROUND, COUNT, COUNTIF:
Start with “=”.
Enter the specific function name followed by an open parenthesis. Input the arguments or cell references.
Close the parenthesis and press Enter to compute.
