Excel shortcuts

General Program Shortcuts

First, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions.

• Ctrl+N: Create a new workbook
• Ctrl+O: Open an existing workbook
• Ctrl+S: Save a workbook
• F12: Open the Save As dialog box
• Ctrl+W: Close a workbook
• Ctrl+F4: Close Excel
• F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
• Shift+F11: Insert a new worksheet
• Ctrl+Z: Undo an action
• Ctrl+Y: Redo an action
• Ctrl+F2: Switch to Print Preview
• F1: Open the Help pane
• Alt+Q: Go to the “Tell me what you want to do” box
• F7: Check spelling
• F9: Calculate all worksheets in all open workbooks
• Shift+F9: Calculate active worksheets
• Alt or F10: Turn key tips on or off
• Ctrl+F1: Show or hide the ribbon
• Ctrl+Shift+U: Expand or collapse the formula bar
• Ctrl+F9: Minimize the workbook window
• F11: Create a bar chart based on selected data (on a separate sheet)
• Alt+F1: Create an embedded bar chart based on select data (same sheet)
• Ctrl+F: Search in a spreadsheet, or use Find and Replace
• Alt+F: Open the File tab menu
• Alt+H: Go to the Home tab
• Alt+N: Open the Insert tab
• Alt+P: Go to the Page Layout tab
• Alt+M: Go to the Formulas tab
• Alt+A: Go to the Data tab
• Alt+R: Go to the Review tab
• Alt+W: Go to the View tab
• Alt+X: Go to the Add-ins tab
• Alt+Y: Go to the Help tab
• Ctrl+Tab: Switch between open workbooks
• Shift+F3: Insert a function
• Alt+F8: Create, run, edit, or delete a macro
• Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Advanced Excel VBA Macros Training at Low cost at HB Services Call 8939273509

There are functions and advanced excel formula that can be used for complex calculations. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given particular set of data. If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.

Duration               : 40 Hrs.
Weekend Batch  : Available
Training Time      : 2 hrs per day (Mon-Fri) or 3-4 hrs per day (Sat & Sun)

Join Now At HB Services Adyar !

Other Courses: - CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | ECSA| CHFI | LPT | AWS | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | ITIL | Prince2 | CISSP | CISA | CISM & many more...!

Please call HB Educational Services @ +91-8939273509
Email your queries to sasikala@hbservices.in

Website: https://www.hbservices.in/

#VBAMACROS  #ADVANCEDEXCELMACROScourse #VBAMACROS training #ADVANCEDEXCELMACROStrainingwithexam #VBAMACROS trainingwithcertification #ADVANCEDEXCELMACROStrainingandexam #VBAMACROS trainingandcertification #VBAMACROS  #ADVANCEDEXCELMACROStraining #VBAMACROS exam #VBAMACROS certification #VBAMACROS coursewithcertification #ADVANCEDEXCELMACROScoursewithexam

Certified Information Security Manager (CISM) exam Centre in Chennai Adyar Call 8939273509

Certified Information Security Manager (CISM) is a certification offered by ISACA, a nonprofit, independent association that advocates for professionals involved in information security, assurance, risk management and governance. Benefits of CISM Certification: It enables the professionals to develop and manage the Information Security Program. Moreover, the professionals can customize the practices specific to a company. The professionals can work anywhere across the globe as it is recognized by multinational clients and organization.

Duration               : 40 Hrs.

Weekend Batch  : Available

Training Time      : 3-4 hrs per day (Sat & Sun)

Join Now At HB Services Adyar !

Other Courses: - CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | ECSA| CHFI | LPT | AWS | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | ITIL | Prince2 | CISSP | CISA | CISM & many more...!

Please call HB Educational Services @ +91-8939273509
Email your queries to sasikala@hbservices.in

Website: https://www.hbservices.in/

#CISM #CISMtraining #CISMtrainingwithexam #CISMtrainingwithcertification #CISMtrainingandexam #CISMtrainingandcertification #CISM #CISMandexam #CISMexam #CISMcertification #CISMwithcertification #CISMwithexam

CISCO CCNA security Training and Certification in Chennai Call 9884987719

A CCNA security certified professional is considered to be an expert in handling products and technologies like Cisco routers, Cisco IOS and security management. The advance curriculum of this certification ensures that the certified engineer is not only able to develop security infrastructure but also able to determine the potential threats and mitigate them accordingly. This certification is valid or active for a period of three years.

Duration               :       40  Hrs

Weekend Batch    :     Available

Training Time       :     4 day (Sat / Sun)

Other Courses :- CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | CHFI|  | LPT | AZURE | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | CHFI | Prince2 | SQL SERVER | CISA | CISM & many more...!

Please call HB Educational Services @ +91-9884987719

Email your queries to ponmani@hbservices.in         

#CCNA SECURITY #CCNA SECURITYcourse #CCNA SECURITYtraining #CCNA SECURITYtrainingwithexam #CCNA SECURITYtrainingwithcertification #CCNA SECURITYtrainingandexam #CCNA SECURITYtrainingandcertification #CCNA SECURITY #CCNA SECURITYtraining #CCNA SECURITYexam #CCNA SECURITYcertification#CCNA SECURITYcoursewithcertification #CCNA SECURITYcoursewithexam#

CCNA Security Certification at Low cost In Adyar HB Services Call 8939273509

Achieving Cisco CCNA Security certification confirms that you have the associate-level knowledge and skills required to secure Cisco networks. It validates that you have the skills to develop a security infrastructure, recognize threats and vulnerabilities to networks, and mitigate security threats.

Duration               : 40 Hrs.
Weekend Batch  : Available
Training Time      : 2 hrs per day (Mon-Fri) or 3-4 hrs per day (Sat & Sun)

                                Join Now At HB Services Adyar !

Other Courses :- CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | ECSA| CHFI | LPT | AWS | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | ITIL | Prince2 | CISSP | CISA | CISM & many more...!

Please call HB Educational Services @ +91-8939273509
Email your queries to sasikala@hbservices.in

Website: https://www.hbservices.in/

Features of JavaScript

Features of JavaScript

JavaScript is a client side technology, it is mainly used for gives client side validation, but it have lot of features which are given below;

• JavaScript is a object-based scripting language.
• Giving the user more control over the browser.
• It Handling dates and time.
• It Detecting the user's browser and OS,
• It is light weighted.
• JavaScript is a scripting language and it is not java.
• JavaScript is interpreter based scripting language.
• JavaScript is case sensitive.
• JavaScript is object based language as it provides predefined objects.
• Every statement in javascript must be terminated with semicolon (;).
• Most of the javascript control statements syntax is same as syntax of control statements in C language.
• An important part of JavaScript is the ability to create new functions within scripts. Declare a function in JavaScript using function keyword.

Limitations of JavaScript

JavaScript have some limitation which are given below;

• Client-side JavaScript does not allow the reading or writing of files.
• It cannot be used for networking applications because there is no such support available.
• It doesn't have any multithreading or multiprocessor capabilities.

CCNA Certification at Low cost In Adyar HB Services Call 8939273509

CCNA (Cisco Certified Network Associate) is an associate-level Cisco Career certification program; you can consider it to be the primary or beginner level of networking certification. This certificate is a proof on behalf of the professional that he/she has the ability to install, manage, and support medium-sized networks. CCNA training helps you establish your career as network engineers and system administrators.

Duration               : 40 Hrs.

Weekend Batch  : Available

Training Time      : 2 hrs per day (Mon-Fri) or 3-4 hrs per day (Sat & Sun)

Join Now At HB Services Adyar !

Other Courses: - CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | ECSA| CHFI | LPT | AWS | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | ITIL | Prince2 | CISSP | CISA | CISM & many more...!

Please call HB Educational Services @ +91-8939273509
Email your queries to sasikala@hbservices.in

Java Interview Questions

What do you know about Java?

Java is a high-level programming language originally developed by Sun Microsystems and released in 1995. Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX.

What are the supported platforms by Java Programming Language?

Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX/Linux like HP-Unix, Sun Solaris, Redhat Linux, Ubuntu, CentOS, etc.

List any five features of Java?

Some features include Object Oriented, Platform Independent, Robust, Interpreted, Multi-threaded

Why is Java Architectural Neutral?

It’s compiler generates an architecture-neutral object file format, which makes the compiled code to be executable on many processors, with the presence of Java runtime system.

How Java enabled High Performance?

Java uses Just-In-Time compiler to enable high performance. Just-In-Time compiler is a program that turns Java bytecode, which is a program that contains instructions that must be interpreted into instructions that can be sent directly to the processor.

Why Java is considered dynamic?

It is designed to adapt to an evolving environment. Java programs can carry extensive amount of run-time information that can be used to verify and resolve accesses to objects on run-time.

What is Java Virtual Machine and how it is considered in context of Java’s platform independent feature?

When Java is compiled, it is not compiled into platform specific machine, rather into platform independent byte code. This byte code is distributed over the web and interpreted by virtual Machine (JVM) on whichever platform it is being run.

List two Java IDE’s?

Netbeans, Eclipse, etc.

List some Java keywords(unlike C, C++ keywords)?

Some Java keywords are import, super, finally, etc.

What do you mean by Object?

Object is a runtime entity and it’s state is stored in fields and behavior is shown via methods. Methods operate on an object's internal state and serve as the primary mechanism for object-to-object communication.

Define class?

A class is a blue print from which individual objects are created. A class can contain fields and methods to describe the behavior of an object.

What kind of variables a class can consist of?

A class consist of Local variable, instance variables and class variables.

What is a Local Variable?

Variables defined inside methods, constructors or blocks are called local variables. The variable will be declared and initialized within the method and it will be destroyed when the method has completed.

What is a Instance Variable?

Instance variables are variables within a class but outside any method. These variables are instantiated when the class is loaded.

What is a Class Variable?

These are variables declared with in a class, outside any method, with the static keyword.

What is Singleton class?

Singleton class control object creation, limiting the number to one but allowing the flexibility to create more objects if the situation changes.

What do you mean by Constructor?

Constructor gets invoked when a new object is created. Every class has a constructor. If we do not explicitly write a constructor for a class the java compiler builds a default constructor for that class.

List the three steps for creating an Object for a class?

An Object is first declared, then instantiated and then it is initialized.

What is the default value of byte datatype in Java?

Default value of byte datatype is 0.

What is the default value of float and double datatype in Java?

Default value of float and double datatype in different as compared to C/C++. For float its 0.0f and for double it’s 0.0d

When a byte datatype is used?

This data type is used to save space in large arrays, mainly in place of integers, since a byte is four times smaller than an int.

What is a static variable?

Class variables also known as static variables are declared with the static keyword in a class, but outside a method, constructor or a block.

What do you mean by Access Modifier?

Java provides access modifiers to set access levels for classes, variables, methods and constructors. A member has package or default accessibility when no accessibility modifier is specified.

What is protected access modifier?

Variables, methods and constructors which are declared protected in a superclass can be accessed only by the subclasses in other package or any class within the package of the protected members' class.

What do you mean by synchronized Non Access Modifier?

Java provides these modifiers for providing functionalities other than Access Modifiers, synchronized used to indicate that a method can be accessed by only one thread at a time.

According to Java Operator precedence, which operator is considered to be with highest precedence?

Postfix operators i.e () [] . is at the highest precedence.

Variables used in a switch statement can be used with which datatypes?

Variables used in a switch statement can only be a string, enum, byte, short, int, or char.

When parseInt() method can be used?

This method is used to get the primitive data type of a certain String.

Why is String class considered immutable?

The String class is immutable, so that once it is created a String object cannot be changed. Since String is immutable it can safely be shared between many threads ,which is considered very important for multithreaded programming.

Why is StringBuffer called mutable?

The String class is considered as immutable, so that once it is created a String object cannot be changed. If there is a necessity to make alot of modifications to Strings of characters then StringBuffer should be used.

What is the difference between StringBuffer and StringBuilder class?

Use StringBuilder whenever possible because it is faster than StringBuffer. But, if thread safety is necessary then use StringBuffer objects.

Six Sigma Greenbelt Training and Examination @ low cost in Adyar Call 9884987719

Getting your Lean Six Sigma certification is a sound investment in your career. A recent salary study shows many Six Sigma Green Belts earn more than 100k with the lean six sigma credential. Earning your six sigma certificate is a quick way to energize your career and create new opportunities for professional advancement.

Duration               :      16 Hrs

Weekend Batch    :     Available

Training Time       :     8 hrs Weekdays and Weekend  (8hrs-Sat / Sun)

Other Courses :- CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | CHFI|  | LPT | AZURE | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | CHFI | Prince2 | SQL SERVER | CISA | CISM & many more...!

Please call HB Educational Services @ +91-9884987719

Email your queries to ponmani@hbservices.in

#GREENBELTcourse #GREENBELTtraining #GREENBELTtrainingwithexam #GREENBELTtrainingwithcertification #GREENBELTtrainingandexam #GREENBELTtrainingandcertification #GREENBELT #GREENBELTcourseandexam #GREENBELTexam #GREENBELTcertification #GREENBELTcoursewithcertification #GREENBELTcoursewithexam#

Six Sigma Training with Certification in HB Services Call 8939273509

The term, 6 sigma, is used as it describes a target of 3.4 defects per million opportunities which is considered to be world class. Sigma is the term given to a measure of deviation in a data set. Six Sigma can improve new or existing processes using its defined methodology. DMAIC – This method improves existing processes. DMADV – This acronym stands for define, measure, analyze, design and verify.

Duration               :  16 Hrs.
Weekend Batch  : Available
Training Time      : 8 hrs per day ( Sat & Sun)

Join Now At HB Services Adyar !

Other Courses: - CCNA| CCNP| MCSA| Hardware and Networking | Ethical Hacking (In Collaboration with EC-Council) CEH | ECSA| CHFI | LPT | AWS | SysOps | DevOps | Azure | C | C++ | JAVA| DOTNET | PHP| HTML |CSS | JS| PYTHON | Macros & VBA | Six Sigma | ITIL | Prince2 | CISSP | CISA | CISM & many more...!

Please call HB Educational Services @ +91-8939273509
Email your queries to sasikala@hbservices.in

Website: https://www.hbservices.in/

#sixsigmacourse #sixsigmatraining #sixsigmatrainingwithexam #sixsigmatrainingwithcertification #sixsigmatrainingandexam #sixsigmatrainingandcertification #sixsigma #sixsigmacourseandexam #sixsigmaexam #sixsigmacertification #sixsigmacoursewithcertification #sixsigmacoursewithexam