Q48) Can you create shortcuts for most frequently used formulas?
Yes, you can do it by customizing the Quick Access Toolbar. To customize it, right-click anywhere on the Quick Access Toolbar and select the Customize Quick Access Toolbar option. You will see the following window:

From here, select Formulas and then choose any formula that you wish to create a shortcut for.

Q49) What is the difference between formulas and functions in Excel?
Formulas are that are defined by the user that is used to calculate some results. Formulas either be simple or complex and they can consist of values, functions, defined names, etc.
A function, on the other hand, is a built-in piece of code that is used to perform some particular action. Excel provides a huge number of built-in functions such as SUM, PRODUCT, IF, SUMIF, COUNT, etc.

Q50) How do you use wildcards with VLOOKUP?
Wildcards can be used when you are not sure of the exact lookup value. In order to use wildcards in Excel, you should make use of the “*” symbol.
For example, in the table that you see in the image below, if you enter “erg” and then use wildcards with it, VLOOKUP will fetch the output that corresponds to “Sergio”.

 

Nudi ..

Nudi software
allows users to type in Kannada script on computers and mobile devices. The software provides a virtual keyboard layout that matches the traditional Kannada script and supports both phonetic and typewriter modes of typing.

ನುಡಿ ಅಥವಾ ಬರಹ ಉಪಯೋಗಿಸಿ ಬರೆದ ಲೇಖನ ಅಥವಾ ಪಠ್ಯವನ್ನು ಯುನಿಕೋಡ್ ಕನ್ನಡಕ್ಕೆ ಬದಲಾಯಿಸಬೇಕಿದ್ದರೆ, ಆ ಪಠ್ಯವನ್ನು ಕೆಳಗಿನ ಜಾಗದಲ್ಲಿ ಹಾಕಿ "Convert" ಬಟನ್ ಒತ್ತಿ.

Government sector work requires Kannada typing, but it is not supported on the website portal when using Nudi. Therefore, it is necessary to use Unicode (Tunga font family) for the official government website in Karnataka. Some examples of software that can be used are e-office, e-par, etc.

ಸರ್ಕಾರಿ ವಲಯದ ಕೆಲಸಗಳಿಗೆ ಕನ್ನಡ ಟೈಪಿಂಗ್ ಅಗತ್ಯವಿರುತ್ತದೆ, ಆದರೆ ನುಡಿ ಬಳಸುವಾಗ ವೆಬ್‌ಸೈಟ್ ಪೋರ್ಟಲ್‌ನಲ್ಲಿ ಅದನ್ನು ಬೆಂಬಲಿಸುವುದಿಲ್ಲ. ಆದ್ದರಿಂದ, ಕರ್ನಾಟಕದ ಅಧಿಕೃತ ಸರ್ಕಾರಿ ವೆಬ್‌ಸೈಟ್‌ಗಾಗಿ ಯುನಿಕೋಡ್ (ತುಂಗಾ ಫಾಂಟ್ ಕುಟುಂಬ) ಅನ್ನು ಬಳಸುವುದು ಅವಶ್ಯಕ. ಬಳಸಬಹುದಾದ ಸಾಫ್ಟ್‌ವೇರ್‌ಗಳ ಕೆಲವು ಉದಾಹರಣೆಗಳೆಂದರೆ ಇ-ಆಫೀಸ್, ಇ-ಪಾರ್, ಇತ್ಯಾದಿ.

How to add, use and remove Subtotals in Excel.pdf

Text Alignment in MS Word.pdf

100 Basic Computer Related G.K. Questions.pdf

Supported Microsoft Office File Types
Microsoft Word files -(*.doc, *.docx, *.rtf)

Microsoft Excel files -(*.xls, *.xlsx)

Microsoft PowerPoint files -(*.ppt, *.pptx)

PDF files -(*.pdf)

Text files -(*.txt)

Computer Literacy Exam Under Government -Sylabus.pdf

Are you ready for computer literacy test questions and answers.pdf

Find and remove duplicates.pdf

How to Convert Week Number to Date or Vice Versa in Excel.pdf

How to Add Watermark in Excel.pdf

1.Computer Literacy 21.pdf

COMPUTER LITERACY TEST.pdf

Basic Computer Skills Test Questions and Answers.pdf

How I do convert a Microsoft Word document to PDF format.pdf

*****Shortcut keys*****

MS Office Questions for Competition Exams.pdf