Rural Electrification Corporation Executive Accountant Interview Questions, Process, and Tips

Short cut keys for MS Word and Excel

• Ctrl + C: Copy

• Ctrl + V: Paste

• Ctrl + X: Cut

• Ctrl + Z: Undo

• Ctrl + Y: Redo

• Ctrl + B: Bold

• Ctrl + I: Italic

• Ctrl + U: Underline

• Ctrl + S: Save

• Ctrl + P: Print

The question asks to draw a table with 6 rows and 4 columns.

• Draw a rectangle with 6 horizontal lines and 4 vertical lines

• Label the rows and columns if necessary

• Ensure the table is neat and organized

• Use a ruler or straight edge for straight lines

Use the VLOOKUP formula to retrieve data from a table based on a specified value.

• VLOOKUP is a function in Excel used to search for a value in the first column of a table and retrieve a corresponding value from another column.

• The formula syntax is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value is the value to search for, table_array is the range of cells that contains the data, col_index...read more

The pivot table formula is used to summarize and analyze data in a spreadsheet.

• The formula starts with the 'PivotTable' function.

• Specify the range of data to be analyzed.

• Define the rows, columns, and values to be displayed in the pivot table.

• Apply any necessary filters or calculations.

• Refresh the pivot table when the source data changes.