computer skills (EXEL)

Question 1

Enter text in cells

Answer 1

Click on a cell and type your text. Press Enter to confirm

Question 2

Inserting and deleting cells

Answer 2

To insert rows or columns, select a cell and use the “Insert” option. To delete cells, use the “Delete” option in the Home tab.

Question 3

Selecting rows and columns

Answer 3

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.

Question 4

Showing and hiding rows and columns:

Answer 4

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”.

Question 5

Freezing rows and columns:

Answer 5

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”.

Question 6

Freezing the top row or first column:

Answer 6

Go to the View tab and select “Freeze Top Row” or “Freeze First Column”.

Question 7

Specifying column width or row height:

Answer 7

Right-click on a column or row header, select “Column Width” or “Row Height”, and specify the size.

Question 8

Changing column width or row height with the mouse:

Answer 8

double-click the border between column or row headers or drag it to adjust.

Question 9

Releasing locked cells in a protected worksheet:

Answer 9

Remove protection by going to the Format menu, selecting “Unprotect Sheet”, entering the password, and choosing “Lock Cell” for unlocked cells.

Question 10

Merging cells:

Answer 10

Select cells, and choose “Merge & Center” from the toolbar.

Question 11

Copying and Pasting Content:

Answer 11

Highlight the content, click “Copy”, choose destination cell, click “Paste”, select paste option.

Question 12

Applying a table style:

Answer 12

Highlight cells, Click “Format as Table”, Select preferred style, click “OK”.

Question 13

Using the Auto Fill function:

Answer 13

Using the Auto Fill function:

Question 14

Sorting tables:

Answer 14

Select a column, and use the “Sort” option in the Data tab.

Question 15

Adding additional sorting levels:

Answer 15

Use the “Add Level” button in the Sort dialog box.

Question 16

sorting data records by cell color:

Answer 16

Use the “Sort” button and select “Cell Color” as the sorting criteria.

Question 17

Showing and hiding decimal places:

Answer 17

Use the Increase or Decrease Decimal buttons in the Number group.

Question 18

Formatting numbers as text:

Answer 18

Select cells, and choose “Text” from the Number Format dropdown.

Question 19

Custom number format:

Answer 19

Use the “Custom” category in the Format Cells dialog box.

Question 20

Structure and Entry of Formulas:

Answer 20

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.

Question 21

Calculating with Formulas and Cell References:

Answer 21

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.

Question 22

Using Names in Formulas:

Answer 22

Double-click the cell to assign a name.

Remove the cell reference and input the assigned name in the formula.

Question 23

Deactivating Table Names in Formulas:

Answer 23

Access the Options menu.

Navigate to Formulas.

Disable the option for using table names in formulas.

Question 24

Copying Formulas with Relative References:

Answer 24

Select the cell containing the formula to copy

Click and drag the fill handle to adjacent cells.

Question 25

External Cell Reference

Answer 25

Begin the formula with “=”.

Open the external workbook.

Navigate to the desired cell to reference.

Press Enter to include the external reference.

Question 26

Updating External References Automatically:

Answer 26

Open the file with external references.

Click on the “Update” button to refresh references automatically.

Question 27

Updating External References Manually:

Answer 27

Navigate to the Data tab.

Select Edit Links and then Update Values.

Question 28

Absolute References:

Answer 28

Choose the cell containing the formula.

Press F4 to toggle between relative and absolute references.

Question 29

Absolute References on Functions:

Answer 29

Add “$” before row/column references to make them absolute.

Question 30

Finding Circular References:

Answer 30

Access the Error Checking options.
Select Circular References to identify them. Trace precedents to locate the circular reference.

Question 31

Subtract, Multiply, Divide: formula

Answer 31

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.

Question 32

Entering a Function:

Answer 32

Begin with “=”.
Enter the function name followed by an open parenthesis. Input the parameters or cell references.
Close the parenthesis and press Enter.

Question 33

Using the Function Wizard:

Answer 33

Click on “Insert Function” in the formula bar.

Choose the desired function from the list.

Follow the wizard’s prompts to input
parameters.

Question 34

Using the Function SUM, AVERAGE, IF, SUMIF, ROUND, COUNT, COUNTIF:

Answer 34

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.