EXCEL PRACTICAL QUESTION WITH ANSWER COMPUTER SKILL TEST EXAM UDC 2022 ESIC UDC PHASE 3 EXAM

ESIC UDC PHASE 3 NOTES PREVIOUS YEAR MODEL PRACTICE SET 45 SETS - https://imojo.in/895DDg


playlist for esic
   • COMPUTER SKILL TEST UDC AND SSO EXAM ...  

whats app number - 7028069132

Use AutoSum
You can use AutoSum to quickly sum a column or row or numbers. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter (Windows) or Return (Mac), and that's it

When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Note: You can also type ALT+= (Windows) or ALT+COMMAND+= (Mac) into a cell, and Excel automatically inserts the SUM function.


The percentage formula in Excel is = Numerator/Denominator (used without multiplication by 100). To convert the output to a percentage, either press “Ctrl+Shift+%” or click “%” on the Home tab's “number” group. Let us consider a simple example.

Computer proficiency test to evaluate a candidate's basic computer competency

Basic Computer Skills/Awareness (50 marks)
MS Windows: Introduction of Windows
MS Office: MS Word, MS PowerPoint, MS Excel & MS Access



MS Excel
A problem in MS Excel related to some of the tools given below to be tested during the examination.
Formatting cells and data
Functions and Formulae (Relative, absolute and Mixed reference.