Friday, 26 February 2016

MEJORES objetivos de carrera / OBJETIVOS EJEMPLOS / MUESTRAS

Tras el éxito de nuestros anteriores artículo 40 mejores metas de la carrera, nos encontramos con este nuevo artículo, por lo que hay que visitar nuestro famoso artículo: Top 40 Metas de la carrera

aspiraciones profesionales son simplemente los objetivos que ha establecido a cabo para lograr, ya sea en su profesión actual, o su profession.It deseada define claramente que lo que necesita o desea de su work.People suelen mezclar las aspiraciones profesionales con objetivos de carrera. Aspiraciones son diferentes del trabajo real que do.Aspirations ayudar a definir sus objetivos de carrera, pero no son exactamente las mismas cosas. ¿Qué es lo que necesita de su trabajo? aspiraciones profesionales son diferentes de persona a persona.

Cuando se le pide acerca de su aspiración de carrera, que se esperaría que pensar en algo relacionado con sus objetivos a largo plazo y de carrera a corto plazo, así como los objetivos, basados ​​en la planificación de su carrera. Es muy importante para uno de planificar el futuro. Por lo tanto, es el momento para que usted pueda empezar a pensar acerca de sus aspiraciones profesionales y configura su carrera road-map.One de las claves para lograr el éxito profesional es definir claramente sus aspiraciones.
Si bien la búsqueda de su carrera de aspiración debe ser claro acerca de sus fortalezas, debilidades, área de intereses, sus necesidades financieras y empezar por tomar el tiempo para sentarse en un lugar tranquilo y responder a estas preguntas:
       * ¿Cuáles eran mis deseos y sueños de carrera real de la infancia?
       * ¿Cuáles son las cosas que son preciosas o importante para mí en la vida?
       * ¿Qué soy bueno en el cumplimiento en el trabajo?
       * ¿Cuáles son las cosas de trabajo I don? T disfrutan?
       * De tres a cinco años a partir de ahora, ¿qué me gustaría estar haciendo? ¿Qué podía imaginar a mí mismo
         ¿obra? ¿Qué me gustaría haber logrado?
       * ¿Cómo puedo describir mi trabajo perfecto?

Gestión de su carrera es hasta una vez y sólo una persona que es you.and para lograr el éxito en su vida debe tener aspiraciones de carrera claras que le mantendrá motivado para trabajar duro hasta el final, pero si no tienen ningún aspiraciones de carrera hasta ahora entonces es su última vez para sentarse y pensar acerca de sus aspiraciones y escribirlo en un papel para tener una visión clara de su futuro o para prepararse a sí mismo para ponerse en una posición que realmente quiere. Una vez que has escrito aspiraciones de su carrera, el siguiente paso es identificar sus objetivos goals.Your son los peldaños que va a utilizar para llegar a su destino deseado. Tenga en cuenta que la calidad de los objetivos que establezca determinará su aspiración effectiveness.Your debe basarse en S.M.A.R.T es decir Técnica

S = específica- sus objetivos tiene que ser explícita y detallada.
metas M = medible -Sus deben tener un resultado específico contra el cual se puede medir su
        Progreso
A = alcanzables -Metas debe permitirle estirarse, pero aún así ser razonable
-Cada objetivo R = relevante debe haber significado para usted
-Metas De duración determinada T = debe definir claramente un principio y un final

aspiraciones profesionales tienen dos aspectos distintivos:
1. Las futuras oriented- objetivos que pueden ser satisfechas en algún momento futuro.
2. estímulo Motivators- para alcanzar las metas que los individuos están dispuestos a lograr.

Aspiraciones de la carrera de las personas se pueden dividir en las siguientes categorías:

1) quiere lograr el éxito de la carrera
- Te gustaría hacer uso de sus habilidades profesionales para lograr el adelanto.
- Usted busca para un trabajo que ofrece posibilidades para que usted pueda ser promovido.
- Que desea mover hacia adelante
- Para la abundancia
2) Para la sensación de seguridad
- Se busca un trabajo que le proporciona un ingreso estable.
- Usted prefiere trabajar en lugares que ofrezcan una posición asegurada a largo plazo.
3) Quiere ser Experto en particular campo
- Usted busca para el trabajo que ofrecen la mejora técnica o profesional y su interés.
- Usted quiere llegar a ser experto en un área profesional.
4) la libertad del amor
- Te encanta disfrutar de la libertad
- Se le anima por sus valores como la libertad y la independencia.
5) quiere la vida equilibrada
- Usted percibe su trabajo para ser igual o menos importantes que otros valores no son de trabajo, tales como
   la familia, la religión, la salud y la relajación.
- Prefiere puestos de trabajo que está interesado.
6) Talento
- Talento es relevante para un gran éxito.
- Las personas más consumados necesitan alrededor de diez años de duro trabajo antes de convertirse en clase mundial.


Ahora aquí están los Top 10 Aspiraciones mejor carrera de la muestra / Ejemplos:

1). satisfacción de la carrera - lo que nos hace feliz en el trabajo? Saber qué tipo de trabajo y entorno de trabajo le consigue rebotar fuera de la cama en la mañana es clave para trazar una carrera satisfactoria future.Know yourself.Learn acerca de los trabajos que son más propensos a cumplir con su expectations.Do No permita que su insatisfacción en el trabajo para ir sin resolver por long.Have expectativas realistas para work.Look por separado en el tipo de trabajo que está haciendo frente a las condiciones de work.Look en el camino a su posible carrera progress.Examine sus valores que lo que es más importante para usted.

2). Las expectativas de carrera - Cartografía sus rasgos de personalidad con career.because del dilema que gran empresa significa menos el aprendizaje y la pequeña empresa significa más aprendizaje. Las expectativas pueden ser de:
      * Tipo de trabajo * Crecimiento de la carrera
      * Seguridad * equilibrio entre trabajo y vida
      * Condiciones de Trabajo * Habilidad y Conocimiento de mejora
      * Pago * Cultura de trabajo Adaptación
      * Avance * Éxito

3). Aprender - Usted tiene la toma de riesgos son ability.You visión constante y el establecimiento de goals.Learning ofrece todo tipo de beneficios a los miembros, a la unión, y para employers.Access al aprendizaje aumenta la vida y oportunidades de empleo y puede ayudar a superar las barreras a la promoción en el trabajo de una manera que promueve diversity.It puede mejorar su salud, hacer que se sienta más feliz, y le dará la confianza para participar en más entrenamiento. También puede encontrar que se siente más seguro de la aplicación para la promoción y mirando a una gama más amplia de opciones de carrera. Esto es particularmente cierto cuando usted alcanza una calificación reconocida.

4). Filosofía de Trabajo - Es importante entender cómo se trabaja mejor. Si se inclina hacia la autonomía y prefiere ser su propio jefe, es posible aspirar a una actividad comercial o una posición que ofrece la libertad y flexibilidad Se puede incluir:
* El trabajo en equipo en el que ama trabajar con ventaja others.The de trabajar en equipo?
  Dos cabezas piensan mejor que hace one.?Teamwork funciona un sueño?
  La ventaja de tener acceso a más ideas, trabajando en armonía y ayudarse mutuamente para lograr
   objetivos mutuos.
* Visionario es una persona inspirada que trata de seguir una visión tanto como s / él puede. Lo que significa que pueden cambiar de carrera repente, empezar a aprender nuevas habilidades o iniciar su propio negocio, y en general
    preferir empleos menos lucrativas, si eso? s en los que su sueño los lleva.
* El único que? Haciendo la diferencia en el trabajo? enfoque al añadir valor y singularidad al puesto de trabajo.
   Al ser un talent.It no es el CEO que hace la diferencia, pero los talentos de la compañía.
* 100% esfuerzo que a? Hacer lo mejor? filosofía ? Aporte sus mejores habilidades, experiencia y esfuerzo
   para la productividad óptima.


5). Situación financiera - El término se refiere a la situación financiera de las habilidades para pagar la demanda de fuera de outsider.If que aspiran a la riqueza material, la estructura de su carrera en consecuencia. El riesgo es un factor a consider.Review su relación riesgo-recompensa, examinando el grado de riesgo que está dispuesto a soportar para capturar al alza.


6). - Gestión Los gestores y los supervisors.These dos roles son críticos ya que los empleados buscan y escuchan a la persona en la parte superior de la organización y su directa supervisor.There es muy grande papel de gestor en cada organización como:
               * Comunicador - Comunicarse con los informes directos sobre el cambio
               * Abogado - Demostrar el apoyo para el cambio
               * El entrenador - empleados autobús a través del proceso de cambio
               * Enlace - comprometerse y proporcionar apoyo al equipo del proyecto
               * Administrador de Resistencia - Identificar y manejar la resistencia
               Para muchas personas, un traslado de un trabajador de personal para un puesto de trabajo en la gestión es una de las principales aspiraciones de carrera. Entrando en la gestión le permite ser más creativo, tomar más responsabilidad, mejorar su autoestima y ganar más dinero.

7). Valores - Los valores son lo que representan en la vida - que a menudo son cosas que usted está a favor o en contra - lo que usted cree adentro y está dispuesto a apoyar y defender for.And son importantes porque nos proporcionan una hoja de ruta para el tipo de vida que aspiramos lead.The más nuestras opciones se alinean con nuestros valores, mejor que por lo general se sienten acerca ourselves.In la estructuración de su trayectoria profesional, tenga en cuenta su sistema de valores.

8). La propiedad - la propiedad significa que en lugar de confiar en los demás y en espera de las respuestas que deben darse para usted, usted está buscando activamente sus objetivos. Cuando su entrenador le da una señal en la clase o un movimiento que trabajar, entonces te vas a casa y la investigación misma. Pasa tiempo practicando por su cuenta, buscar correctivos y trabajos de movilidad que le permitirá mover la forma en que? Supone que debes, y volver el tiempo better.Take para evaluar críticamente no sólo la facilidad que asista, sino también las personas que le rodean, el entrenador o entrenador personal que trabaja, y su propio progress.For muchas personas, la oportunidad de tener un negocio es la última carrera de aspiración.


9). Consultoría consultores son -Grandes idea impulsado y motivado a hacer todo lo posible para que la organización del cliente mejor. A menudo entran en situaciones complejas, ambiguas, ya veces hostiles, pero de manera competente y completamente evaluar lo que hay que ser personas done.Some tienen una personalidad Idea-Driven, una personalidad orientada a servicios que pueden ayudarles a alcanzar el éxito en el campo de la consultoría. Los que son persona son adecuados para el campo de la consultoría. Convertirse en un experto en un campo particular, le permite ofrecer a sus habilidades como consultor. Dependiendo de su área de especialización, puede ayudar a las empresas a mejorar su gestión financiera, las actividades de recursos humanos, sistemas de tecnología de la información, marketing, procesos de producción o ventas.

10). La aspiración para determinadas posiciones - Sus aspiraciones se puede basar en posiciones particulares son los siguientes
   *Profesor
    -Experienced, Educador enérgica buscando asegurar una enseñanza position.Interested en la enseñanza
      temas relacionados con Inglés o Historia a nivel de escuela primaria o secundaria.

   *Cajero
     -Friendly, Motivado, con experiencia cajera con tres años en la industria. Servicio al cliente
      orientado y tiene mucho gusto de servir al público. Bilingüe y puede funcionar bien en un ritmo rápido
      ambiente.

   * Gerente de Ventas al por menor
    -Muy Motivado, entusiasta gerente de ventas al por menor, con un rendimiento excepcional, probada voluntad
      luchar por sus objetivos de ventas. La experiencia con la supervisión de los empleados y las operaciones de venta al por menor.
      -Ajuste de grabación líder de ventas, excelentes habilidades de entrenamiento y tiene la capacidad de impulsar empleado
      moral. Comprometido a proporcionar un ambiente agradable, las ventas orientadas.

   *Analista financiero
    -Para Asegurar una posición que me permite utilizar las habilidades de los analistas financieros y de gestión de proyectos que
      han obtenido a través de mi educación y experiencia laboral.

   * Asistente Personal
     -A posición como asistente personal en el departamento de recursos humanos de la organización de servicio público
      eso me permitirá la oportunidad de utilizar mis conocimientos de administración de salarios, quejas
      procedimientos, programas benefician publicaciones, la seguridad, las relaciones laborales y el empleo.

   *Asistente de Marketing
    -motivada Graduado de la escuela de negocios que buscan un puesto de asistente de marketing para ayudar a desarrollar y
     aplicar procedimientos y proyectos de comunicación. Poseer un título de licenciatura en
     negocio / comercialización combina con la experiencia internacional de un estudio en el extranjero de prácticas.
     Prospera en ambientes de alta presión y es impulsado plazo. Honesto, ético y confiable.

   *Servicio al cliente
    -Para Obtener una posición de servicio al cliente en una empresa de primer nivel y utilizar las habilidades que he obtenido a través de la experiencia laboral previa.



NO aspiran a tener más. Aspiran a ser MÁS :-)

Thursday, 18 February 2016

Top 36 HOTEL MANAGER INTERVIEW QUESTIONS EXPERIENCE WITH DIRECTOR

Hey we come with great question answers series of an interview, this interview will be great source for hotel restaurant mangers, who want to switch their jobs. Here are 36 question answers series which asked during interview by hotel director. Mostly question are based on mission, goals and innovation. So lets go through this Interview experience.

1. What is the mission and vision of your company?
Mission : To provide services and facilities aimed at relaxation, fun and / or businesses with high quality standards. With a commitment to Mexico to generate wealth, create jobs and promote tourism development.
Vision : To be a global Mexican hotel, which has international and major destinations in Mexico presence.

2. What strategies implemented to compete in the business?
Make an action plan about what is happening in the market today, to know what the pros and cons of the competitors are hence to the strategy it is the part that is studied.
The municipality of Colima is a place of business but not beach because people confuse the proximity to Manzanillo, that's where it should work, mentioning what we offer.
We seek to treat customers well, good public relations, meet their needs, depending on what it detects the action plan.

3. How many staff account for the activities of your company? (Asked to provide the organizational structure of your company). How many maintenance, kitchen, bar ...? What is the average schooling?
In the maintenance area we have four people and an area manager; for the quarter we have five maids, a housekeeper, a supervisor; res receptionists also have a night auditor; three waiters in the morning and three in the afternoon, three chefs and two assistants. In the comptroller have an accountant, a public relations manager, one of revenues, general cashier, a manager of purchasing and warehouse.

Post
average schooling
Average age
General Manager
Bachelor's degree
47
Duty Manager
professional
40 / for all
receptionists
professional

waitresses
high school

Buttons
high school

Cook / Chef
professional

Waiter
high school

Mantenance staff
preparatory

Laundry
high school

Bartender
high school

masseurs
professional






4.  Just the municipality of Colima hire staff?
Eighty percent of the staff are people of Colima, the remaining twenty percent is out.

5.  Do you have training programs for its staff? What is the focus of the training?
Yes. Twice a year, when they are given an induction course, then it gives them training with the ISO quality system.

6.  What are the last five programs you have given ?
all apply each month.

7. How are encouraged staff to provide and improve service?
With sales commissions, the employee of the month is given a bonus; In addition, they offer tours.

8. Does it bring from elsewhere, outside of Colima, the products needed to offer their services?
Suppliers are the state of Colima, in terms of food, 98% is collimated.

9. What differentiation offered in your service / product, compared to other hotels / restaurants?
The difference difference makes the taste of the dishes, personal attention, banquets and attention of the staff.

10. What additional services do you offer? (walks, transfers by road, by air, etc).
We have massages, we offer for college, government enterprise, open to all internet, sports area, etc.

11. Does an event / distinctive product of Colima culture?
When we are asked, we go to college to request support us with the event or a certain type of dance or dance, you can be given on-site, or transport guests to the theater.

12. Do you have some kind of badge or certification? How many distinctive features or certifications? (H, M, ISO, etc.)
Yes, with the ISO 9001: 2000

13. Do you have a manual operation?
With several: a quality manual, a policy, another division of rooms, food and beverages, quality management system, other maintenance and management.

14. How important is for the hotel, meet 100% what the manual says?
It is very important, as it must submit a monthly report, not satisfied with the implemented rules, just the ISO certificate is removed, and the hotel immediately go bankrupt because they need to fulfill the foundation for development, deployment,  maintenance and improvement of the quality management system for hotels mission.

15. Are any measures that impose some kind of international regulations follow?
No, we were previously governed by SECTUR, but I missed that. Comparatively mission all hotels must be registered with the ISO 9001: 2000

16. How to measure their ability to compete with international hotel companies?
Sher is called Market, see how the hotels in the square behave, measure what we are selling and how they are selling and what we share in the market.

17. You plan short- and / or long term to expand or modernize their hotel / restaurant?
The hotel has its own style, if you lose modernized style that sets it apart, perhaps zoom yes, but not yet. Yes there is a project to grow but that depends on how the market grows.

18. How much money is needed for expansion / modernization?
It depends on the number of rooms and depending on market behavior, because prices vary until the exchange rate will not stabilize.

19. What would be your source of funding?
Own company.

20. How often are remodeled or facilities maintenance programs are made?
The  preventive maintenance is daily or monthly, we talked about what is happening in each of the departments and the maintenance that may lack, there are things that are envisaged or may deteriorate.

21. When were the last two maintenance programs?
For daily or monthly become, therefore, yesterday or a month ago were the last.

22. Do you have any agreement with another company to attract more customers?
There is a certain kinship with the Fiesta Inn hotel, we promote each other and send us groups from hotel to hotel.

23. What kind of alliance and how to supplement your service?
No, for that we have a rule that indicates what has to be done. Volumes have a tendency, each string is different depending on the type of market you have, this is a national chain hotel, like the Fiesta Inn.

24. Have you acquired knowledge or processes thanks to globalization?
Yes, as a result we have grown to levels that have the Holiday Inn, refers to several brands, including Continental, large square, to move from being a national economy, it is now a global company.

25. Have adopted international technologies? (system, process)
Yes, we have smart technology.

26. If you get a group that was not contemplated, what makes you to address them, he does so with the same staff or emerging hire staff? Do you have the capacity daily (high season / low) to absorb the demand for full quota of your hotel / restaurant?
If we are prepared for such cases and we are able to serve them, because we have areas to do so. For example, if a very large group that does not fit in the restaurant for some meals, as tables are placed in a larger area and there are addresses, are offered a welcome cocktail, and it is not necessary to hire more personal.

27. Recently, are there international phenomena that impact your industry?
Yes, the crisis in the United States by the variation of the dollar, the price increase. China, India and the United States affects worldwide phenomenon, and therefore the hotel mission.

28. How do you determine rates? What factors contemplated?
There is a comparison, occupational ranking hotels the municipality, occupied rooms, rooms available, fair market share, market share and average rate are the factors taken into account.

29. Is there an alliance between companies to determine rates?
Rather, the strategy does is to not lower prices, but rather to raise them, an alliance is made to cover the market demand for large groups and the proximity to other hotels on prices to get an average . Partnerships with the Ministry of Tourism, with the government, which make together can do something better.

30. Have you received support programs   promoting tourism public companies or private companies?
Yes, we have received support such as ballet, transportation support, VIP treatment.

31. Do you belong to any organization or association? To which?
Yes, Mission Hotel chain 100% Mexican.

32. If so, what benefits it has brought you?
To me, the benefit is that I am a director, make collimated and have a new challenge, overcoming the goals are estimated to hotel

33. Who is the person responsible for proposing and innovate?
The director, a server, Fermin Gutierrez Campos.

34. Who is the person responsible for making decisions?
Myself.

35. To what (domestic or foreign), tourism sector services are targeted?
90% to the national and only 10% abroad.

36. Finally, do you want to add something?
I am at your disposal for any questions.

Tuesday, 16 February 2016

Top 50 VMware vSphere Interview Questions Answers PDF 2016

Here are the top 50 VMware interview questions and answers of 2016.

Explain what is VMware?

VMware, Inc. is an American company that provides cloud and virtualization software and services, and claims to be the first to successfully virtualize the x86 architecture commercially. Founded in 1998, VMware is based in Palo Alto, California.

What is virtualization?
Virtualization is a proven software technology that makes it possible to run multiple operating systems and applications on the same server at the same time. It’s transforming the IT landscape and fundamentally changing the way that people utilize technology.

What do you understand by Virtual Machine?
A virtual computer systems is known as “virtual machine” (VM):  a tightly isolated software container with an operating system and application inside.
Each self-contained VM is completely independent. Putting multiple VMs on a single computer enables several operating systems and applications to run on just one physical server, or “host”.

What are the key properties of a Virtual Machine?
Partitioning
  • Run multiple operating systems on one physical machine
  • Divide system resources between virtual machines
Isolation
  • Provide fault and security isolation at the hardware level
  • Preserve performance with advanced resource controls
Encapsulation
  • Save the entire state of a virtual machine to files
  • Move and copy virtual machines as easily as moving and copying files
Hardware Independence
  • Provision or migrate any virtual machine to any physical server
What are the main advantage of VMWare Vsphere?
  • Ensure business continuity and always available IT
  • Reduce IT hardware and operating costs
  • Improve application quality
  • Enhanced security and data protection
Explain what is Data Store?
Data store represents a storage location for virtual machine files. It can be a Virtual Machine File
System (VMFS) volume, a directory on Network Attached Storage, or a local file system path.

Explain what is VMware DRS?
VMware DRS stands for Distributed Resource Scheduler; it dynamically balances resources across various host under cluster or resource pool. It enables users to determine the rules and policies which decide how virtual machines deploy resources, and these resources should be prioritized to multiple virtual machines.

When using ESXi hypervisor architecture, how to monitor hardware on vSphere host?
vSphere supports CIM API and SNMP v2, without installing agents to enable hardware monitoring. Hardware monitoring tools can monitor through vCenter console and major hardware provided by OEM vendors.

What is VMware DPM?
VMware Distributed Power Management (DPM) is a pioneering new feature of VMware DRS that continuously monitors resource requirements in a VMware DRS cluster. When resource requirements of the cluster decrease during periods of low usage, VMware DPM consolidates workloads to reduce power consumption by the cluster. When resource requirements of workloads increase during periods of higher usage, VMware DPM brings powered-down hosts back online to ensure service levels are met.

When you visit certain Web sites, the request is "connection was reset" the report, then what is the principle of connection is reset?
The nature of the connection is reset, because it has received a TCP Reset packet damage connected

VMware ESX is still providing support for the architecture?
VMware will follow VMware vSphere support policy  to continue to provide technical support for ESX architecture.

How can I evaluate VMware vSphere?
The easiest way to evaluate VMware vSphere is to download and install the free  vSphere Hypervisor  version. In addition, you can also use  vSphere assessment .

When using the ESXi architecture, Update Manager whether to repair my vSphere host? 
VMware vCenter Update Manager  will be updated to run ESXi host. In addition to VMware Update Manager environment provides not installed the update utility.

What is the ESXi Shell?
ESXi Shell is a command-line interface to run diagnostics and repair of vSphere ESXi hosts. ESXi Shell by DCUI or through vCenter Server to enable and disable, and can also be accessed remotely via SSH. For more information, see the  ESXi Management page.

How to run esxtop on the vSphere host? 
By vCLI command "resxtop" offer "esxtop" function, the same function as the command console operating system in the esxtop.

What is the use of VMWare workstation?
VMware Workstation is a powerful desktop computer virtualization software, provide users can run different operating systems simultaneously on a single desktop, and develop, test, deploy most new applications good solution. VMware Workstation can be simulated on a physical machine complete network environment, and a portable virtual machine , a better flexibility and its advanced technology available in the market other than the virtual machine software. For enterprise IT developers and system administrators, VMware virtual network, real-time snapshots, drag a shared folder , PXE ​​support other aspects of the characteristics makes it an indispensable tool.

What are the advantage and disadvantages of VMWare workstation?
Advantage:
  • VMware Workstation virtual machine capability, performance and physical isolation is very good!
  • VMware Workstation features a very comprehensive, computer professionals tend to use!
  • VMware Workstation is simple interface for users of various fields of computer!
Disadvantages:
  • VMware Workstation bulky, longer installation time-consuming!
  • VMware Workstation occupy a larger physical machine resources when using!
Explain what is vSphere?
vSphere is a product name which includes vCenter server, ESXi hypervisor and many other. ESXi is a hypervisor type included in vSphere package.


What is difference between vSphere, ESXi and vCenter?
http://www.mustbegeek.com/difference-between-vsphere-esxi-and-vcenter/

Explain the steps how you will clone VM without vCenter?
http://stackzilla.com/how-to-clone-vm-without-vcenter/

What are the differences between VMware vSphere 5.0, vSphere 5.1 VMware vSphere 5.5 and vSphere 6.0?
http://www.interviewquestionspdf.com/2016/02/difference-between-vmware-vsphere-50.html

What do you understand by VMware vSphere Web Client?
It is a Web interface that enables users to connect remotely to vCenter Server from a variety of Web browsers and operating systems.

Difference between VMware vSphere 5.0, vSphere 5.1 VMware vSphere 5.5 and vSphere 6.0

VMware vSphere 5.0 vs. vSphere 5.1 vs. vSphere 5.5 vs. vSphere 6.0

In this post we will discuss the the key differences between vSphere 5.0, vSphere 5.1, vSphere 5.5 and vSphere 6.0


Features VMWare vSphere 5.0 VMWare vSphere 5.1 VMWare vSphere 5.5 VMWare vSphere 6.0
Released gfd gfd September 2013 March 2015
VM HW Version Virtual Hardware 8 Virtual Hardware 9 Virtual Hardware 10 Virtual Hardware 11
vCPU per VM 32 64 64 128
VM Memory 1 TB 1 TB 1 TB 4 TB
Physical CPU per host 160 160 320 480
Physical RAM per host 2 TB 2 TB 4 TB 12 TB
VMDK Size 2 TB 2 TB 62 TB 62 TB
Cluster Size 32 32 32 64
FT Max vCPU 1 vCPU 1 vCPU 1 vCPU 4 vCPU
FT Supported Disk Types - - Eager-Zeroed Lazy-Zeroed Eager-Zeroed Thin Provision
FT Supported Features - - HA, DPM, SRM, VDS HA, DPM, SRM, VDS, Hot Configure FT, H/W Virtualization, Snapshot, Paravirtual Devices, Storage Redundancy
VMFS Version 5.54 5.58 5.60 5.61
Management - - vSphere Web Client,
vSphere Client (C#)
vSphere Web Client, vSphere Client (C#)
Authentication Management - Single Sign-On Single Sign-On 5.5 Platform Services Controller
vMotion Network Support - - L2 Network max.
10ms RTT
L3 Network max. 100ms RTT
Content Library NO NO NO YES
Virtual Volumes NO NO NO YES
All-Flash VSAN NO NO NO YES
Virtual SAN - - VSAN 5.5 VSAN 6.0
VSAN Scale - - 32 Nodes 64 Nodes
VSAN Fault Domains NO NO NO YES
vCenter Type Windows,Linux (vCSA) Windows,Linux (vCSA) Windows,Linux (vCSA) Windows,Linux (vCSA)
vCenter Linked Mode gfd gfd Windows only Microsoft ADAM Replication Windows & VCSA Native Replication
Features – Auto Deploy
– Storage DRS
– vSphere Storage Appliance
– Profile driven storage
– vSphere Web Client
– vCenter Server Appliance
– ESXi Firewall
– Single Sign-On
– Enhanced vMotion
– Sparse Virtual Disks
– Single-root I/O Virtualization
– vSphere Replication
– vSphere Data Protection
– vShield Endpoint
– vSphere Flash Read Cache
– Virtual SAN
– Reliable Memory Technology
– vSphere Big Data Extensions
– vCenter Single Sign-On 2.0
– vSphere App HA – 40GBps NIC Support
– Virtual Volumes
– vMotion across vSwitches
– Cross vCenter vMotion
– Native Linked Mode
– Platform Services Controller
– Certificate Authority (VMCA)
– Content Library

Top 100 MS Excel Interview Questions for Fresher and Experienced

Microsoft Excel is one of the greatest, most powerful, most important software applications of all time.Many in the industry will no doubt object. But it provides enormous
capacity to do quantitative analysis, letting you do anything from statistical analyses of databases with hundreds of thousands of records to complex estimation tools with user
-friendly front ends. And unlike traditional statistical programs, it provides an intuitive interface that lets you see what happens to the data as you manipulate them.
So there is huge requirement of MS-excel masters who are able to handle any problem related to excel .If you want to become a MS excel expert or want to apply for excel job then
you must have necessary skills.These skills are:

  • Good knowledge of all aspects of excel and more .
  • Integrating excel with other tools and optimizing excel
  • Using excel productively
  • Ability to set up dynamic & interactive charts
  • Ability to combine various charts in to one
  • Manage Data Easily With The Pivot-table Tool
  • Familiar with VBA & can write macros to automate their day to day work, thus saving countless hours of time & money
  • Ability to combine formulas with conditional formatting to highlight data that meets almost any condition
  • Able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas
  • Knowing  how to debug the formulas , audit them and how to use which formula for which occasion


Here's the top 50 Excel interview questions and answers:

1)What is Microsoft Excel?
Ans.Microsoft Excel is an Electronic Spreadsheet Program or application developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate
data with formulas using a spreadsheet system broken up by rows and columns.It features calculation, graphing tools, pivot tables, and a macro programming language called
Visual Basic for Applications.Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered in the suite of products.It has
replaced Lotus 1-2-3 as the industry standard for spreadsheets. The first software program similar to Excel was released in 1982 and was called Multiplan.

With that short answer you can also describe your computer experience in layman's terms.You might be an expert user with high proficiency with servers, operating systems,
applications and Internet use.On the other hand,be able to speak in tech-savvy terminology so the interviewer knows you understand computer technology effectively.

2)What are dashboard and why do organisations use it?
Ans.Dashboards often provide at-a-glance views of KPIs (key performance indicators) relevant to a particular objective or business process (e.g. sales, marketing, human
resources, or production).The term dashboard originates from the automobile dashboard where drivers monitor the major functions at a glance via the instrument cluster.
Dashboards give signs about a business letting the user know something is wrong or something is right.Dashboards typically are limited to show summaries, key trends,
comparisons, and exceptions. There are four Key elements to a good dashboard which help organisations to work effectively:
*Simple, communicates easily
*Minimum distractions.
*Supports organized business with meaning and useful data
*Applies human visual perception to visual presentation of information
Smart organizations are doing everything they can to find every opportunity to drive their business and helpthem stay ahead of their competition. To uncover these opportunities
,decision-makers need easy access to a very wide range of information and they need advanced visualizations to help them analyze and understand the data.One way decision-maker
get easy access to data is through dashboards. Modern dashboard technology enables dozens of reports to be combined into a single, easily-consumable, visual representation.This
ability to consolidate many reports has been the biggest breakthrough in the last five years and has redefined what we think of as a “dashboard".Dashboards are highly
interactive, self-contained environments that hold the answers to many standard questions of business operations.

3)What is your process for creating a dashboard??
Ans.Excel Dashboard reports are the new buzz word employers are looking for, and for good reason. Dozens of dashboard building solutions have sprung up to meet the demand. Yet
in the ?urry of technology and enthusiasm, little attention has been paid to how to design focused, thoughtful, and user-friendly dashboards.
Smart and effective answers will your your interviewer more.So you may say that you:
1.Will first  ?nd the speci?c reasons why your dashboard will be useful to your organization.This section offers exercises to de?ne and re?ne the purpose for your dashboard.
2.Decide that what type of dashboard you are creating?
3.Information discrimination ( select important data from raw data)
4.Choose tha perfect Metric
5.Framing the dashboard
  *Form
  *Structure
  *Design principles
  *Functionality
6.Information design
  *Interface design
   1. Organize the dashboard page like a web design expert
   2. Choose the appropriate use of color to enhance your dashboard
   3. Make the right typography decisions to ensure  attractive, readable
  *Information display
   1. Pick the chart type that best ?ts your data
   2. Style charts to be attractive and effective
   3. Learn about advanced visualization and features for your dashboard
And before you fire up Excel grab a scrap of paper and mock up your dashboard layout also.

4)Do you use VBA to automate your work in Excel.If yes, how often do you use it? 
Ans.You may say that yes, you use Visual Basic for Applications(VBA) to automate your tasks in Excel by writing so called macros.And then share the process of using VBA with
your interviewer smartly that you use VBA by step by step i.e

  • STEP-1 Enabling VBA(To enable VBA you have to use the File, Options and select Customise the Ribbon.You then have tick the Developer box to allow the Developer icon to appear).
  • STEP-2 Insert a module(To insert a module you use the command Insert,Macro,Module).
  • STEP-3 Entering text.
  • STEP-4 Each module you create is given a default name(Module1, Module2 and so on - but you can rename it quite easily by typing a new name into the Properties box at the
  •        bottom left)
  • STEP-5 The beginning and the end(All programs in VBA have to start and end in a particular way. The first line has to read Sub name() where name is the name you want to give
  •        your program.Sub is short for Subroutine but more of this later).
  • STEP-6 Getting the message.
  • STEP-7 Running the program(To run the program you can simply click on the green “play” arrow in the Visual Basic toolbar).
  • STEP-8 Input(to find out how to get information back from the user - i.e. let them input something.This makes use of another VBA command, InputBox, but pay attention because it is a little more tricky than MsgBox).


5)How to create a Data list in Excel?
Ans.The process of creating datalist is :

  • STEP-1 Keeping track of data (Data can be entered easily into the spreadsheet, and, with just a few clicks of the mouse you can sort through your data and find what you want).
  • STEP-2 Tables of data (The basic format for storing data in Excel is a table. In a table, data is entered in rows.Each row is known as a record and  the easiest way of doing
  •        so is, to create what's known as a list from the data in a table).
  • STEP-3 Entering data correctly (The first step in creating a table is to enter the data. When doing so, it is important to ensure that it is entered correctly.Incorrect data
  •        can cause many serious problems).
  • STEP-4 Rows are records (to create a list, a table of data needs to contain at least two data records).
  • STEP-5 Columns are fields (Each column needs a heading to identify the data it contains. These headings are called field names).
  • STEP-6 Create the list

       *Select any one cell in the table.
       *Choose List > Create List from the menu to open the Create List dialog box.
       *The dialog box shows the range of cells to be included in the list. If the table was created properly, Excel will usually select the correct range.
       *If the range selection is correct, click OK.
FINAL STEP- The list (A blank row containing an asterisk is added to the bottom of the list. Additional data can be added to the list using this new row)
   
6)What is the most unusual thing you have used Excel for?
Ans.Here you need to mention those things which helped you for exploration and learning new things.You may some points in your answer like :

  • I used excel to create stunning screen mockups and wowed my clients.
  • I have used excel to generate and clean a list of tags for the blog i write(if).
  • I wrote a small macro to send updates to twitter.


7)Can you tell me about some of the newer enhancements to Excel recently?
Ans.Some of the new enhancements you can mentions in your answer are as follows are:

  • Powerpivot
  • Tables
  • Slicers
  • Sparklines
  • IFERROR

With the names, you also need to add some details of particular enhancements

8)How do you provide Dynamic Range in 'Data Source' of Pivot Tables?
Ans.A Dynamic Range of data perhaps should use a Dynamic Rangename as the source for the pivot tables.Thus, when you add new rows of data, the dynamic range reference
automatically includes the added rows.
Suppose the data extends from say column [A] to column [P], and starts in row 1 to row whatever.
Suppose that column [B] always contains an entry for a data row (for example, col [B] might be say, ItemRef, which is never blank or empty.
Then you could create a rangename say, sourceBlock, and in the name "refers to" box use the formula
="a1" & counta("b1:b16536")

9)Is it possible to display the text in the data area of Pivot Table?
Ans.No its not possible to dislplay the text in data area of pivot table.You could display the text fields in the Row and Column areas, and show a count of the records in the
data area or we can combine Custom Number Formats with the Pivot Table to produce Text based answers.

10)How do you make two data fields appear side-by-side, instead of in separate rows?
Ans.After adding the two fields to the pivot table's data area, drag the Data field button to the right, onto the cell that contains the word 'Total'. There's a picture here
that shows the 'Total' cell.

  • Change pivot table data to horizontal layout.And to keep related data from spreading horizontally off of the screen and to help minimize scrolling,click Show in Compact Form.
  • In compact form, fields are contained in one column and indented to show the nested column relationship.
  • To outline the data in the classic PivotTable style, click Show in Outline Form.
  • To see all data in a traditional table format and to easily copy cells to another worksheet, click Show in Tabular Form.


11)How to debug a VBA code?
Ans.To start to debug a Visual Studio project, attach to a process, break into code, step through code, run to the cursor, run to a function on the call stack, set the next
statement,step through Just My Code, stop debugging, restart debugging, or detach from a debugged process.

  • Specify the configurations for the debug and release versions of a program.
  • Set start options (command-line arguments, working directory, remote machine).
  • Debug at design time.
  • Enable just-in-time debugging, which launches the Visual Studio debugger when a program running outside Visual Studio encounters a fatal error.
  • Set breakpoints for source lines, assembly instructions, and call stack function. Specify conditions, hit counts, and execution location.


12)Which are the 2 macro languages and which do you use ?
Ans.First is XLM and second is VBA(visual basic applications).So for answering effectivel you may say that early versions of Excel used a macro language called XLM.The VBA
language was introduced in Excel 5, and is vastly superior in every way.So for new macro development you should use VBA.You can also add the more  benefits of using VBA like:

  • The Visual Basic Application is the user friendly program that you will use to talk with Excel.
  • To develop analysis and reporting programs downstream from large central databases such as Sybase, SQL Server, and accounting, financial and production programs such as
  •  Oracle, SAP, and others.
  • Probide the ability to do what you normally do in Excel, but a thousand times faster. ETC


13)How can you increase the number of rows and columns in a worksheet?
Ans.The amount of rows in a worksheet is fixed i.e 1,048,576 , so you cannot increase the amount of rows. What you can do is insert rows into part of a spreadsheet. It will
have the effect of pushing rows down, but it will not increase the amount of rows in the worksheet.And same with columns they are also fixed(16384) its not possible to increase
,you can start a new Excel workbook and transfer your data.

14)What is Excel Dependency tree?
Ans.Excel Dependency Tree is an internal structure which is used to build calculation change and informs Excel which cells should be recalculated when something is changed in
the spreadsheet.Recalculation may be triggered in such cases:
*User entered new data into cell
*Excel commands are used which instructs Excel to recalculate all workbook or only a specific range
*When workbook is saved, if Recalculate Before Save option is turned on.
Dependency Tree is not shown by Excel, you can one use Formula Auditing commands to work with it. Show Precedents and Show Dependents commands point you to list of dependent
cells in the spreadsheet.Dependency Auditor adds its own set of formula auditing commands to work with Dependency Tree and research the calculations. It provides you set of
very helpful graphical and navigation tools to go through dependency list.

15)What are keyboard shortcuts and their equivalent VBA methods for Formulae calculation and building Excel dependency trees?
Ans.Keyboard Shortcut keys with their equivalent VBA methods are:

  1.  F9 - Recalculates all worksheets in all open workbooks.
  2. Shift+F9 - Recalculates the active worksheet.
  3. Ctrl+Alt+F9 - Recalculates all worksheets in all open workbooks (Full recalculation).
  4.  Shift+Ctrl+Alt+F9 - Rebuilds the dependency tree and does a full recalculation


 16)What is the ribbon and when would you use it?
Ans.The Ribbon is the strip of buttons and icons located above the work area beginning with Excel 2007.The Ribbon replaces the menus and toolbars found in earlier versions of
Excel.Above the Ribbon are a number of tabs, such as Home, Insert, and Page Layout. Clicking on a tab displays the options located in this section of the ribbon.

17)How can you hide or show the ribbon?
Ans.To Hide and show the ribbon you can press the CTRL+F1 key or Double click on one of the ribbon tabs-such as Home, Insert, or Page Layout.

18)What is IF function in excel?
Ans.The IF statement is a simple function in Excel that is one of the building blocks you need when you are working with large spreadsheets. You may not know you need it yet,
but once you know how to use it, you won't want to live without it.

IF() Function Syntax
The IF() function has the following syntax:
=IF(logical test, value if true, value if false)

The IF function works by performing a logical test that can only have one of two outcomes - TRUE or FALSE. It then outputs a result based on the outcome of that test.

19)Why does excel have two macro languages?
Ans.Early version of Execl used a macro language called XLM.The VBA language was introduced in Excel 5 and its vastly superior in every way.XLM has been phased out , so you
should use VBA for new macro development.

20)What types of workbook protection are available?
Ans.Excel provides three ways to protect a workbook:

  • Require a password to open the workbook.
  • Prevent users from adding sheets, deleting sheets, hiding sheets, and unhidingsheets.
  • Prevent users from changing the size or position of windows.


To protect protect a workbook you can activate the workbook to be protected, then choose Tools - Protection - Protect Sheet. You will be asked to provide a password (optional)
.If you do provide a password, that password will be required to unprotect the workbook.

21)What are worksheets ?
Ans.A worksheet is a collection of cells where you keep and manipulate the data. A worksheet begins with row number one and column A.Each cell can contain a number, text or
formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. By default, each Excel workbook contains three worksheets.When
you open Excel, Excel automatically selects Sheet1 for you.The name of the worksheet appears on its sheet tab at the bottom of the document window.To select one of the other
two worksheets,simply click on the sheet tab of Sheet2 or Sheet3.

22)How can you add, rename or remove worksheets?
Ans.To add a worksheet: Touch + next to the last worksheet tab
    To remove a workshhet: Touch the sheet's tab, then touch x to delete the worksheet
    To rename a worksheet: Touch twice on the name of a worksheet

23)What are comments and how do you add comments to a cell?
Ans.Commenst are a verbal or written remark expressing an opinion or reaction.Using comments can help you make a worksheet easier to understand by providing additional context
for the data it contains. For example, you can use a comment as a note that provides information about data in an individual cell. You can also add a comment to a column
heading to provide guidance on data that a user should enter.
To add comments ta a cell:

  • Step-1 Select the cell that you want to add a comment to.
  • Step-2 On the Review tab, in the Comments group, click New Comment.
  • Step-3 In the body of the comment, type the comment text.
  • Step-4 Click outside the comment box.The comment box disappears, but the comment indicator remains.


24)What does a red triangle at the top right of a cell indicates?
Ans.Thew red triangle at the top of right of a cell indicates that:

  • There is an error in the cell
  • There is a comment associated with the cell
  • The font color of the text in cell is red
  • The cell can't accet formula


25)How can you prevent someone from copying your worksheets?
Ans.In order to protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect sheet > Password. By entering password,you can secure your worksheet
from getting copied by others.
     
26)What does a look up function searches in in the MS Excel?
Ans.The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array. There are 2 different syntaxes for the LOOKUP function:
*LOOKUP FUNCTION (SYNTAX #1)
-In Syntax #1, the LOOKUP function searches for value in the lookup_range and returns the value in the result_range that is in the same position.
-The syntax for the Microsoft Excel LOOKUP function is:
   LOOKUP( value, lookup_range, [result_range] )
*LOOKUP FUNTION (SYNTAX #2)
-In Syntax #2, the LOOKUP function searches for the value in the first row or column of the array and returns the corresponding value in the last row or column of the array.
-The syntax for the Microsoft Excel LOOKUP function is:
   LOOKUP( value, array )

27)How can we sum up the rows and column number quickly in the excel sheet?
Ans.We can sum up the rows and column number quickly in the excel sheet by the Excel SUM Function.The SUM function provides a quick and easy way to carry out this task in an
Excel worksheet.The syntax for the SUM function is:

=SUM ( Number1, Number2, ... Number255 )

28)What is Macro in Excel ?
Ans.A macro can be defined as the recording of a series of tasks. It’s the simplest form of automation – show a software program the steps you follow to get something done, and
the software will follow along. When used right, macros can save you hours by automating simple, repetitive tasks.Marcos in Excel are written in Excel VBA (Visual Basic for
Applications). This is a version of Visual Basic (a prominent Microsoft programming language) developed specifically for use in Office-like applications.

29)How can we create an Excel Macro?
Ans.To create Excel Macro :

  • Step-1 Turn on the Developer tab.
  • Step-2 Right click anywhere on the ribbon, and then click Customize the Ribbon.
  • Step-3 Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).
  • Step-4 Check the Developer check box.Click OK.
  • Step-5 On the Developer tab, in the Code group, click Visual Basic.
  • Step-6 If needed, in the Visual Basic Editor, on the Insert menu, click Module.
  • Step-7 In the code window of the module, type or copy the macro code that you want to use.
  • Step-8 To run the macro from the module window, press F5.


30)How can you resize the column and rows?
Ans.The width of columns and height of rows can be adjusted to better fit your data in a few different ways.

  1. Use the format button- The Format button in the cells group under the Home tab can also be used to adjust widths and heights. Simply select the cells that need to be adjusted,then click on the Format button and choose either Row Height or Column Width. Type in your desired number, and the cells will adjust.
  2. Drag the border- Hover your arrow over the border between the column or row labels. Then click and drag the border to widen or narrow the size of each cell.The columns to theright or rows below will adjust to make room for your changes.
  3. You can make several columns or rows the same width or height. Select your desired columns or rows by clicking on the labels while holding down either the shift key or control key. Then use any of the methods described above, and all of the columns will be made the same width or rows the same height.


31)What is the quick way to return to a specific area of spreadsheet?
Ans.By typing in Name Box you can return to a specific area of spreadsheet in quick way.

32)Tell me about the benefit of using formula in Excel?
Ans.Formulas in spreadsheet programs such as Excel are used to perform calculations on values entered and stored in the program.Excel's main function is to interlink cells,
through the use of formulas, so that the formula cell changes when data is inputted into linked cells. The best way to store information in spreadsheets is through the use of
formulas.Formulas can range from basic mathematical operations-such as addition and subtraction-to complex engineering and statistical calculations.

33)How can you format data in Excel?
Ans.To format data in Excel you van:

  • Use column labels to identify data
  • Use cell borders to distinguish data
  • Extend data formats and formulas
  • Avoid leading or trailing spaces to avoid errors
  • Use an Excel table format to work with related data


34)What is the function of sumif in Microsoft excel?
Ans.You would use it when you only want to total some values from a list. So say you had values in A1 to A15 and you only wanted to total up the ones that were over 100, you
could use a formula like this:
=SUMIF(A1:A15,">100")

Say you had the names of people in A1 to A15, and some of the names were there more than once, and you had values in B1 to B15. Then say you want to add values that are beside
only one particular name that occurs a few times in the list and that name was John. You could do that with this formula:
=SUMIF(A1:A15,"John",B1:B15)
So anywhere John is found in the cells from A1 to A15, it will total the corresponding values in B1 to B15.

35)How can you combine different chart types into your Excel spreadsheet?
Ans.Excel offers a wide range of chart types: Line Charts, Column Charts, Area Charts, Bar Charts, Scatter Charts, and Pie Charts, to name but a few. You can even mix different
types on a single chart by assigning different chart types to different series on the chart. These mixtures are called Combination Charts, and Excel provides a small number of
these on the Custom Types tab of the Chart Type dialog box.To combine different charts:
Step-1 Enter or copy/paste your data into an Excel worksheet.
Step-2 Select the data that you want included in the chart. Open the Insert tab on the Excel ribbon, and click on the arrow under Column in the Charts section to expand the
       selection panel. Choose the column chart type that you want to use.
Step-3 Next, right-click on the column representing the data that you want to convert to a line.
Step-4 In the Change Chart Type window that appears, select what type of chart you want to use for this variable.Click OK to continue.

36)How can you change the colour and font of the Worksheet tabs?
Ans.To change colour of the worksheets:

  • Step-1 Right-click on the worksheet tab you want to change. Excel displays a Context menu.
  • Step-2 Choose Tab Color from the Context menu. Excel displays the Format Tab Color dialog box.
  • Step-3 Select a color to use for the tab.
  • Step-4 Click on OK.

To change the font :

  • Step-1 Minimize all open applications by pressing Windows button + M, and right-click the desktop.
  • Step-2 Select Properties, and then select the Appearance tab.
  • Step-3 Click Advanced (skip this step if using Windows 98).
  • Step-4 From the Item dropdown list, choose Scrollbar.
  • Step-5 Change the Size and click OK twice.


37)How to protect the Macros you create so people cannot see or alter them?
Ans.To protect the Macros:
In the Visual Basic Editor, go to Tools > VBAProject properties, lock the project for viewing, and enter a password.

38)How to perform lock operation in an cell?
Ans.To lock the cells:

  • Step-1 Select all cells.
  • Step-2 Right click, and then click Format Cells.
  • Step-3 On the Protection tab, uncheck the Locked check box and click OK.
  • Step-4 Right click cell(you want to lock), and then click Format Cells.
  • Step-5 On the Protection tab, check the Locked check box and click Ok.Now your cell will be  is locked .


39)How can convert existing Excel worksheet data and charts to HTML document?
Ans.You can convert existing Excek worksheet data and charts to HTML document by using the Internet Assistant Wizard.With the Internet Assistant Wizard,you can leverage
existing Microsoft Excel spreadsheet data to create and distribute documents that can be viewed online with popular browsers. By clicking a series of buttons in the wizard, you
can convert spreadsheet data to HTML format either as a separate Web document or into an existing Web document.

40)How are array formulas useful?
Ans.Array formulas may be Excel's most powerful feature for summarizing data.You can use array formulas to do complex
tasks, such as:

  1. Count the number of characters that are contained in a range of cells.
  2. Sum only numbers that meet certain conditions, such as the lowest values in a range or numbers that fall between an upper and lower boundary.
  3. Sum every nth value in a range of values.
  4. Counting Values Based on Multiple Criteria.
  5. Multiple Sums Simultaneously
  6. Counting Unique Values


41)What is the difference between SUBSTITUTE and REPLACE in Excel?
Ans.In simple words the Replace function replaces part of a text string, based on the number of characters you specify, with a different text string. The Substitute function
substitutes new text for old text in a text string. You use Substitute when you want to replace specific text in a text string and you use Replace when you want to replace any
text that occurs in a specific location in a text string.

42)What is the difference between in COUNT and COUNTA in Excel?
Ans.The COUNT function is generally used to count a range of cells containing numbers or dates excluding blanks.COUNTA, on the other hand will count everything numbers, dates,
text or a range containing a mixture of these items, but does not count blank cells. COUNTA stands for count all.Although you can use COUNTA to generate the number of clients
or employees in a list, it counts each entry, not unique entries. To count unique entries you would have to use the SUM function together with the COUNTIF function.

43)How do i find a feature that i used in Excel 2003 or Excel 2007?
Ans.Microsoft has developed an interactive referencing guide to help you find your favorite Excel 2003 or Excel 2007 commands in Excel 2010. With this guide, you can point your
mouse to an Excel 2003 or Excel 2007 menu or button and see where that feature is now located. You can also use the HELP feature to find out how to do a specific task in Excel
2010.

44)How can you protect formulas for being deletd or changed?
Ans.To protect formulas :

  1. Step-1 Select the whole worksheet with Ctrl + A, and right click, choose Format Cells from the context menu.
  2. Step-2 And a Format Cells dialog box will pop out. Click Protection, and unchecked the Locked option. Click OK. The whole worksheet has been unlocked.
  3. Step-3 Then click Home > Find & Select > Go To Special, and a Go To Special dialog box will appear. Check Formulas from Select option, and then click OK.
  4. Step-4 All of the cells which contain formulas will be selected.
  5. Step-5 Then go to lock the select cells.Right click on the selected cells,and choose Format Cells from the context menu,and a Format Cells dialog box will display.Click Protection,
  6.        check the Locked checkbox.
  7. Step-6 And then click Review > Protect Sheet, and a Protect Sheet dialog box will pop out, you can enter the password in the Passwordto unprotect sheet box .


45)The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called?
Ans.Answer is Freezing panes .When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet.For example, you might want to keep row and
column labels visible as you scroll. A solid line indicates that row 1 is frozen to keep column labels in place when you scroll.

46)How to use VLook up?
Ans.VLOOKUP is a great tool for pulling data from tables, but it has a handicap: it can only work with one criteria for matching information. If there are multiple rows in your
sheet with the same information, you’ll only get the first one. If you need to use two or more conditions to match a specific piece of data, you’re out of luck. Fortunately,
Excel has a pair of functions called INDEX and MATCH that can help produce the same results as VLOOKUP with multiple criteria.
VLOOKUP() Function Syntax-The VLOOKUP() function has the following syntax:
=VLOOKUP(lookup_value, lookup_table_range, column, exact)
VLOOKUP() works by taking the value you are looking up (lookup_value) and looking for it in the first column of the table you are searching in (lookup_table_range).
Once the function finds the matching value in the lookup_table_range, it then reads across that row the table to the column you chose and returns the value it finds there.

47)How to apply the same formatting and data to every sheet in a workbook in excel?
Ans.To apply the same formatting to every sheet in a workbook click CTRL+ click the tabs of the sheets that you want to group together,and the grouped tabs will all turn white.
(Normally, only the current sheet has a white tab, while the others are gray.) While sheets are grouped, anything you enter in one sheet also gets entered into the others.After
formatting grouped sheets, and perhaps entering the same headings in each, remember to click on the tabs to ungroup them, so that you don't accidentally insert or remove data
in multiple sheets when you insert or remove data in one.

48)Is there any way to create shortcuts to Excel functions?
Ans.Yes.Just above the HOME button is the QUICK ACCESS TOOLBAR. You can customize this toolbar to display the shortcuts that you most frequently use from the list provided.
If you click on the small down arrow on the edge of the toolbar, a list of the most common shortcuts are displayed. You can choose shortcuts from this list or if you want a
more in-depth selection, click on the MORE COMMANDS option. You can then add more shortcuts from the window that pops up.

49)Is cell reference is useful in the calculation? If yes, then how?
Ans.Yes cell reference is very useful in the calculation.Most of the time in Excel,you will be using a cell's address in the formula.This is called using a cell reference.The
advantage of using cell references is that you can change a value in a referenced cell and the formula will automatically recalculate.Using cell references in your formulas
will make sure the values in your formulas are accurate.

50)What is the role of AND function in excel?
Ans.One common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then
returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the AND function as the logical_test argument of the IF function, you
can test many different conditions instead of just one.
The AND function syntax has the following arguments:
*logical1    Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
*logical2   Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

All The Best!!

Think Big, Think Differently :-)

Monday, 15 February 2016

Top 60 AWS Interview Questions Answers for Fresher and Experienced PDF Free Download

Hey guys this time we coming with latest technology going popular these days, if you want to make career in AWS then be happy because it has great future. This set is for both fresher and experienced developers.


AWS INTERVIEW QUESTIONS ANSWERS

1). Explain what is AWS(Amazon Web Service)?

2). Explain what are the key components of AWS( Amazon Web Service )?

3). Explain what is IAM service?

4). What is AWS Certificate Manager?


5). Explain what is S3?

6). Explain what is AMI ( Amazon Machine Image )?

7). Mention what is the relation between an instance and AMI?

8). Explain what is Redshift?

9). What Is Amazon EC2?

10). Explain what Is Amazon EC2 instance?

11). Exmplain some features of Amazon EC2?
12). Mention what are the differences between Amazon S3 and EC2 ?

13). How many buckets can you create in AWS by default?

14). Explain what is T2 instances?

15). Explain what is C4 instances?

16). Explain how the buffer is used in Amazon web services?

17). Explain what is DynamoDB?

18). Explain what is ElastiCache?

19). What is the AWS Key Management Service?

20). What is AWS WAF? What are the  potential benefits of using WAF?

21). What is Amazon EMR?

22). What is AWS Data Pipeline? and what are the components of AWS Data Pipeline?
23). What is Amazon Kinesis Firehose?

24). What Is Amazon CloudSearch and its features?
25). Explain what is Regions and Endpoints in AWS?

26). How to find your regions and Availability Zones using the Amazon EC2 CLI?

27). What is Amazon AppStream and advantage of using AppStreaming?

28). Which AWS responsible for managed email and calendaring?

29). What are the benefits of EBS vs. instance-store?

30). How you will find out the instance id from within an ec2 machine?

31). How do you pass custom environment variable on Amazon Elastic Beanstalk (AWS EBS)?

32). Is it possible to use AWS as a web host? What are the way of using AWS as a web host? 

33). How step you follow to make 10,000 files as public in S3?

34). How do you see how much disk space is using by S3 bucket?


42). What is the maximum length of a file-name in S3?

43.) What is Amazon RDS?

44.) In RDS, what is the maximum value you can set for my backup retention period?

45.) In RDS, Automated backups are enabled by default for new DB Instance, true or false?

46.) What is MFA in AWS?

47.) What is Amazon VPC?

48.) If you want to run a database on an EC2 instance, which is the most recommended Amazon storage option, S3, RDS or EBS?

49.) In S3, what does RRS stand for? 

50.) What are the 4 level of AWS premium support?

51.) What is the underlying Hypervisor for EC2?

52.) What is the difference between Elastic Beanstalk and CloudFormation?

53.) What action is required to establish an Amazon Virtual Private Cloud (VPC) VPN?

54.) Suppose that you are working with a customer who has 10 TB of archival data that they want to migrate to Glacier. The customer has a 1-Mbps connection to the internet. Which service or feature provides the fastest method of getting data into Amazon Glacier?

55.) Example, how you will create a VPC and Subnets using the AWS CLI?

56.) Why we use VPC in AWS?

57.) Can you descrive the steps of create default VPC in AWS?

58.) What are the three features provided by Amazon that you can use to increase and monitor the security?

59.) What is the difference between Network ACLs and Security Groups in AWS?

60.) What benefits to VPC security groups give you that EC2 security groups do not?

Read new post TOP 95 AWS VPC INTERVIEW QUESTIONS

Find job here...