Práctica no1
Download as DOCX, PDF0 likes269 views
This document contains instructions and examples for using formulas and functions in Excel. It includes 3 exercises that demonstrate looking up values based on cell references and returning descriptions, quantities, names, codes, cities, phone numbers, prices and totals using Excel functions like BUSCARV, BUSCAR, and SUM. The goal is to familiarize the user with performing lookups and calculations in Excel.
1 of 4
Download to read offline
Recommended
Iformatica practica 1
Iformatica practica 1GloriaJazz95The document contains examples of using the BUSCARV and BUSCAR functions in Excel. The BUSCARV function is used to search for product descriptions and quantities in stock by product code in two examples. A third example shows using the BUSCAR function to look up a client's code, name, city, and phone number from different columns based on the client name.
PRIMEROS EJERCICIOS DEL 2ª PARCIAL 
PRIMEROS EJERCICIOS DEL 2ª PARCIAL Anita NuñezThe document contains formulas to look up information from different tables and cells. It uses the BUSCARV and BUSCAR functions to find product descriptions, client names, cities, and other details by searching ranges in tables based on codes or other criteria. The formulas will retrieve information like product descriptions, client names, cities, phone numbers, and unit prices from various tables.
PRIMEROS EJERCICIOS DEL 2ª PARCIAL 
PRIMEROS EJERCICIOS DEL 2ª PARCIAL Anita NuñezThe document contains formulas to look up information from different tables and cells. It uses the BUSCARV and BUSCAR functions to find product descriptions, client names, cities, and other details by searching ranges in tables based on codes or other criteria. The formulas will retrieve information like product descriptions, client names, cities, phone numbers, and unit prices from various tables.
EJERCICIOS DEL 2ª PARCIAL 
EJERCICIOS DEL 2ª PARCIAL Anita NuñezThe document contains formulas to look up values from different tables and ranges. It uses the BUSCARV and BUSCAR functions to find product descriptions, client names, cities, and prices from tables based on codes or other criteria. The tables and ranges referenced include PRODUCTOS, CLIENTES, and FACTURA.
Deber infor
Deber inforAngelica SaaThis document contains formulas to calculate order details like item descriptions, prices, customer information, and totals. It looks up item descriptions and unit prices from a price list. It also looks up customer address, name, and phone from a customer database. It then calculates subtotals, tax amounts, and total due for an order.
Western Art Collector Magazine | April, 2009 | State of the Art, Texas Fe...
Western Art Collector Magazine | April, 2009 | State of the Art, Texas Fe...Shannon HannaWestern Art Collector Magazine | April, 2009 | State of the Art, Texas Feature | Page 50
Painter and decorator
Painter and decoratorLisbeth RodríguezThis document provides information about tools and materials used by painters including sand blasters, undercoats, primers, solvents, sanders, heat guns, wire brushes, paint strippers, high pressure wash systems, spray guns, varnishes, scrapers, brushes, ladders, rollers. It also discusses techniques for fixing woodwork, using palm sanders, stencils, color glazes, graining, texture finishes, industrial coatings, staining walls, wallpapering and includes bibliographic references.
El patrimonioAbrahám SarcosEl documento proporciona definiciones de los elementos clave del patrimonio de una empresa: activo, pasivo y capital. Explica que el activo son los recursos económicos de la empresa, el pasivo son sus deudas, y el capital es el aporte de los dueños. Además, describe la ecuación patrimonial básica que iguala el activo con el pasivo más el capital, y cómo esta ecuación se amplía a lo largo del tiempo a medida que cambian los elementos del balance general de la empresa debido a sus operaciones.
Manual de microsft excel avanzadoAlejandro BeltranEste documento presenta una guía sobre cómo crear diferentes tipos de gráficos y tablas dinámicas en Microsoft Excel de manera avanzada. Incluye instrucciones paso a paso para crear gráficos de barras, sectores, líneas, columnas apiladas y circulares, así como tablas dinámicas y el uso de formato condicional y filtros.
Proyec informatica-ii-3 cer-semes.Alejandro BeltranEste documento presenta una introducción al curso de Informática Aplicada a la Educación para estudiantes de enfermería. Incluye secciones sobre herramientas informáticas como Word, Excel, PowerPoint, Access y Outlook. También describe otras herramientas como OpenOffice, Google Docs, redes sociales, Dropbox, YouTube y Epi Info. El documento concluye con secciones sobre tecnología, wikis, Internet y las TIC en enfermería.
FiltrosAlejandro BeltranExcel ofrece varias herramientas para organizar y visualizar datos, incluyendo filtros para seleccionar datos específicos, formato condicional para resaltar celdas, tablas dinámicas para resumir grandes conjuntos de datos, herramientas de tablas para ordenar y agrupar datos, herramientas de tablas dinámicas para actualizar automáticamente tablas, y gráficos estadísticos para representar datos numéricos de manera visual.
FiltrosAlejandro BeltranExcel ofrece varias herramientas para organizar y analizar datos, incluyendo filtros para seleccionar datos específicos, formato condicional para resaltar celdas, tablas dinámicas para resumir datos automáticamente, herramientas de tablas para ordenar y agrupar datos, herramientas de tablas dinámicas para actualizar tablas automáticamente cuando cambian los datos subyacentes, y gráficos estadísticos para visualizar y analizar tendencias en los datos.
Excel avanzado 3-aAlejandro BeltranEl documento presenta una serie de ejercicios en Excel para practicar gráficos y tablas dinámicas. Incluye instrucciones para replicar diferentes tipos de gráficos como barras, sectores, líneas y columnas utilizando datos de ventas. También incluye un ejercicio de tablas dinámicas con datos personales e información de facturas, y un ejercicio de formato condicional para resaltar rangos de gastos. Por último, presenta una tabla de ventas de vehículos con preguntas para filtrar y analizar la información
Cuestionario de InformaticaAlejandro BeltranEl documento contiene información sobre ventas de productos por meses, compras realizadas en el primer trimestre de 2014, estadísticas de estudiantes de empresariales, y tablas dinámicas creadas con datos de servicios, fecha de factura, importe, edad, sexo y localidad para aplicar formatos condicionales y filtros.
SeparadorAlejandro Beltran
Practica no 2Alejandro BeltranEste documento contiene funciones para buscar información de un estudiante como su teléfono, dirección, ciudad, correo electrónico, datos de sus padres como nombre, cédula, ocupación y teléfono. También busca datos secundarios del estudiante como colegio, ciudad, especialidad y año de graduación. Finalmente busca la cédula, nombre, edad, fecha de nacimiento y estado civil del estudiante.
Formato CondicionalAlejandro BeltranEste documento explica cómo usar formatos condicionales en Excel para dar formato a celdas en función de ciertas reglas o valores. Describe los pasos para crear reglas condicionales personalizadas, usar formatos condicionales predeterminados como barras de datos y escalas de color, y quitar las reglas de formato condicional. El documento proporciona instrucciones claras y detalladas sobre cómo aplicar y eliminar formatos condicionales en una hoja de cálculo de Excel.
South Hornsey: The Lost Local Authority that Merged with Stoke Newington by T...
South Hornsey: The Lost Local Authority that Merged with Stoke Newington by T...History of Stoke NewingtonPresented at the 24th Stoke Newington History Talks event on 27th Feb 2025
https://stokenewingtonhistory.com/stoke-newington-history-talks/
Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1...
Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1...pinkdvil200Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024
Reordering Rules in Odoo 17 Inventory - Odoo ݺߣs
Reordering Rules in Odoo 17 Inventory - Odoo ݺߣsCeline GeorgeIn Odoo 17, the Inventory module allows us to set up reordering rules to ensure that our stock levels are maintained, preventing stockouts. Let's explore how this feature works.
How to attach file using upload button Odoo 18
How to attach file using upload button Odoo 18Celine GeorgeIn this slide, we’ll discuss on how to attach file using upload button Odoo 18. Odoo features a dedicated model, 'ir.attachments,' designed for storing attachments submitted by end users. We can see the process of utilizing the 'ir.attachments' model to enable file uploads through web forms in this slide.
TLE 7 - 3rd Topic - Hand Tools, Power Tools, Instruments, and Equipment Used ...
TLE 7 - 3rd Topic - Hand Tools, Power Tools, Instruments, and Equipment Used ...RizaBedayoHand Tools, Power Tools, and Equipment in Industrial Arts
Computer Network Unit IV - Lecture Notes - Network Layer
Computer Network Unit IV - Lecture Notes - Network LayerMurugan146644Title:
Lecture Notes - Unit IV - The Network Layer
Description:
Welcome to the comprehensive guide on Computer Network concepts, tailored for final year B.Sc. Computer Science students affiliated with Alagappa University. This document covers fundamental principles and advanced topics in Computer Network. PDF content is prepared from the text book Computer Network by Andrew S. Tenanbaum
Key Topics Covered:
Main Topic : The Network Layer
Sub-Topic : Network Layer Design Issues (Store and forward packet switching , service provided to the transport layer, implementation of connection less service, implementation of connection oriented service, Comparision of virtual circuit and datagram subnet), Routing algorithms (Shortest path routing, Flooding , Distance Vector routing algorithm, Link state routing algorithm , hierarchical routing algorithm, broadcast routing, multicast routing algorithm)
Other Link :
1.Introduction to computer network - /slideshow/lecture-notes-introduction-to-computer-network/274183454
2. Physical Layer - /slideshow/lecture-notes-unit-ii-the-physical-layer/274747125
3. Data Link Layer Part 1 : /slideshow/lecture-notes-unit-iii-the-datalink-layer/275288798
Target Audience:
Final year B.Sc. Computer Science students at Alagappa University seeking a solid foundation in Computer Network principles for academic.
About the Author:
Dr. S. Murugan is Associate Professor at Alagappa Government Arts College, Karaikudi. With 23 years of teaching experience in the field of Computer Science, Dr. S. Murugan has a passion for simplifying complex concepts in Computer Network
Disclaimer:
This document is intended for educational purposes only. The content presented here reflects the author’s understanding in the field of Computer Network
CBSE Arabic Grammar - Class 10 ppt.pptx
CBSE Arabic Grammar - Class 10 ppt.pptxsuhail849886cbse arabic grammar
grade 10 cbse arabic grammar
cbse class 10 arabic grammar
arabic marathon cbse arabic 10
nominal sentences
Kaun TALHA quiz Finals -- El Dorado 2025
Kaun TALHA quiz Finals -- El Dorado 2025Conquiztadors- the Quiz Society of Sri Venkateswara CollegeFinals of Kaun TALHA : a Travel, Architecture, Lifestyle, Heritage and Activism quiz, organized by Conquiztadors, the Quiz society of Sri Venkateswara College under their annual quizzing fest El Dorado 2025.
More Related Content
More from Alejandro Beltran (11)
Manual de microsft excel avanzadoAlejandro BeltranEste documento presenta una guía sobre cómo crear diferentes tipos de gráficos y tablas dinámicas en Microsoft Excel de manera avanzada. Incluye instrucciones paso a paso para crear gráficos de barras, sectores, líneas, columnas apiladas y circulares, así como tablas dinámicas y el uso de formato condicional y filtros.
Proyec informatica-ii-3 cer-semes.Alejandro BeltranEste documento presenta una introducción al curso de Informática Aplicada a la Educación para estudiantes de enfermería. Incluye secciones sobre herramientas informáticas como Word, Excel, PowerPoint, Access y Outlook. También describe otras herramientas como OpenOffice, Google Docs, redes sociales, Dropbox, YouTube y Epi Info. El documento concluye con secciones sobre tecnología, wikis, Internet y las TIC en enfermería.
FiltrosAlejandro BeltranExcel ofrece varias herramientas para organizar y visualizar datos, incluyendo filtros para seleccionar datos específicos, formato condicional para resaltar celdas, tablas dinámicas para resumir grandes conjuntos de datos, herramientas de tablas para ordenar y agrupar datos, herramientas de tablas dinámicas para actualizar automáticamente tablas, y gráficos estadísticos para representar datos numéricos de manera visual.
FiltrosAlejandro BeltranExcel ofrece varias herramientas para organizar y analizar datos, incluyendo filtros para seleccionar datos específicos, formato condicional para resaltar celdas, tablas dinámicas para resumir datos automáticamente, herramientas de tablas para ordenar y agrupar datos, herramientas de tablas dinámicas para actualizar tablas automáticamente cuando cambian los datos subyacentes, y gráficos estadísticos para visualizar y analizar tendencias en los datos.
Excel avanzado 3-aAlejandro BeltranEl documento presenta una serie de ejercicios en Excel para practicar gráficos y tablas dinámicas. Incluye instrucciones para replicar diferentes tipos de gráficos como barras, sectores, líneas y columnas utilizando datos de ventas. También incluye un ejercicio de tablas dinámicas con datos personales e información de facturas, y un ejercicio de formato condicional para resaltar rangos de gastos. Por último, presenta una tabla de ventas de vehículos con preguntas para filtrar y analizar la información
Cuestionario de InformaticaAlejandro BeltranEl documento contiene información sobre ventas de productos por meses, compras realizadas en el primer trimestre de 2014, estadísticas de estudiantes de empresariales, y tablas dinámicas creadas con datos de servicios, fecha de factura, importe, edad, sexo y localidad para aplicar formatos condicionales y filtros.
SeparadorAlejandro Beltran
Practica no 2Alejandro BeltranEste documento contiene funciones para buscar información de un estudiante como su teléfono, dirección, ciudad, correo electrónico, datos de sus padres como nombre, cédula, ocupación y teléfono. También busca datos secundarios del estudiante como colegio, ciudad, especialidad y año de graduación. Finalmente busca la cédula, nombre, edad, fecha de nacimiento y estado civil del estudiante.
Formato CondicionalAlejandro BeltranEste documento explica cómo usar formatos condicionales en Excel para dar formato a celdas en función de ciertas reglas o valores. Describe los pasos para crear reglas condicionales personalizadas, usar formatos condicionales predeterminados como barras de datos y escalas de color, y quitar las reglas de formato condicional. El documento proporciona instrucciones claras y detalladas sobre cómo aplicar y eliminar formatos condicionales en una hoja de cálculo de Excel.
Manual de microsft excel avanzadoAlejandro Beltran
Proyec informatica-ii-3 cer-semes.Alejandro Beltran
FiltrosAlejandro Beltran
FiltrosAlejandro Beltran
Excel avanzado 3-aAlejandro Beltran
Cuestionario de InformaticaAlejandro Beltran
SeparadorAlejandro Beltran
SeparadorAlejandro Beltran
SeparadorAlejandro Beltran
Practica no 2Alejandro Beltran
Formato CondicionalAlejandro Beltran
Recently uploaded (20)
South Hornsey: The Lost Local Authority that Merged with Stoke Newington by T...
South Hornsey: The Lost Local Authority that Merged with Stoke Newington by T...History of Stoke NewingtonPresented at the 24th Stoke Newington History Talks event on 27th Feb 2025
https://stokenewingtonhistory.com/stoke-newington-history-talks/
Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1...
Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1...pinkdvil200Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024
Reordering Rules in Odoo 17 Inventory - Odoo ݺߣs
Reordering Rules in Odoo 17 Inventory - Odoo ݺߣsCeline GeorgeIn Odoo 17, the Inventory module allows us to set up reordering rules to ensure that our stock levels are maintained, preventing stockouts. Let's explore how this feature works.
How to attach file using upload button Odoo 18
How to attach file using upload button Odoo 18Celine GeorgeIn this slide, we’ll discuss on how to attach file using upload button Odoo 18. Odoo features a dedicated model, 'ir.attachments,' designed for storing attachments submitted by end users. We can see the process of utilizing the 'ir.attachments' model to enable file uploads through web forms in this slide.
TLE 7 - 3rd Topic - Hand Tools, Power Tools, Instruments, and Equipment Used ...
TLE 7 - 3rd Topic - Hand Tools, Power Tools, Instruments, and Equipment Used ...RizaBedayoHand Tools, Power Tools, and Equipment in Industrial Arts
Computer Network Unit IV - Lecture Notes - Network Layer
Computer Network Unit IV - Lecture Notes - Network LayerMurugan146644Title:
Lecture Notes - Unit IV - The Network Layer
Description:
Welcome to the comprehensive guide on Computer Network concepts, tailored for final year B.Sc. Computer Science students affiliated with Alagappa University. This document covers fundamental principles and advanced topics in Computer Network. PDF content is prepared from the text book Computer Network by Andrew S. Tenanbaum
Key Topics Covered:
Main Topic : The Network Layer
Sub-Topic : Network Layer Design Issues (Store and forward packet switching , service provided to the transport layer, implementation of connection less service, implementation of connection oriented service, Comparision of virtual circuit and datagram subnet), Routing algorithms (Shortest path routing, Flooding , Distance Vector routing algorithm, Link state routing algorithm , hierarchical routing algorithm, broadcast routing, multicast routing algorithm)
Other Link :
1.Introduction to computer network - /slideshow/lecture-notes-introduction-to-computer-network/274183454
2. Physical Layer - /slideshow/lecture-notes-unit-ii-the-physical-layer/274747125
3. Data Link Layer Part 1 : /slideshow/lecture-notes-unit-iii-the-datalink-layer/275288798
Target Audience:
Final year B.Sc. Computer Science students at Alagappa University seeking a solid foundation in Computer Network principles for academic.
About the Author:
Dr. S. Murugan is Associate Professor at Alagappa Government Arts College, Karaikudi. With 23 years of teaching experience in the field of Computer Science, Dr. S. Murugan has a passion for simplifying complex concepts in Computer Network
Disclaimer:
This document is intended for educational purposes only. The content presented here reflects the author’s understanding in the field of Computer Network
CBSE Arabic Grammar - Class 10 ppt.pptx
CBSE Arabic Grammar - Class 10 ppt.pptxsuhail849886cbse arabic grammar
grade 10 cbse arabic grammar
cbse class 10 arabic grammar
arabic marathon cbse arabic 10
nominal sentences
Kaun TALHA quiz Finals -- El Dorado 2025
Kaun TALHA quiz Finals -- El Dorado 2025Conquiztadors- the Quiz Society of Sri Venkateswara CollegeFinals of Kaun TALHA : a Travel, Architecture, Lifestyle, Heritage and Activism quiz, organized by Conquiztadors, the Quiz society of Sri Venkateswara College under their annual quizzing fest El Dorado 2025.
Blind Spots in AI and Formulation Science Knowledge Pyramid (Updated Perspect...
Blind Spots in AI and Formulation Science Knowledge Pyramid (Updated Perspect...Ajaz HussainThis presentation delves into the systemic blind spots within pharmaceutical science and regulatory systems, emphasizing the significance of "inactive ingredients" and their influence on therapeutic equivalence. These blind spots, indicative of normalized systemic failures, go beyond mere chance occurrences and are ingrained deeply enough to compromise decision-making processes and erode trust.
Historical instances like the 1938 FD&C Act and the Generic Drug Scandals underscore how crisis-triggered reforms often fail to address the fundamental issues, perpetuating inefficiencies and hazards.
The narrative advocates a shift from reactive crisis management to proactive, adaptable systems prioritizing continuous enhancement. Key hurdles involve challenging outdated assumptions regarding bioavailability, inadequately funded research ventures, and the impact of vague language in regulatory frameworks.
The rise of large language models (LLMs) presents promising solutions, albeit with accompanying risks necessitating thorough validation and seamless integration.
Tackling these blind spots demands a holistic approach, embracing adaptive learning and a steadfast commitment to self-improvement. By nurturing curiosity, refining regulatory terminology, and judiciously harnessing new technologies, the pharmaceutical sector can progress towards better public health service delivery and ensure the safety, efficacy, and real-world impact of drug products.
How to use Init Hooks in Odoo 18 - Odoo ݺߣs
How to use Init Hooks in Odoo 18 - Odoo ݺߣsCeline GeorgeIn this slide, we’ll discuss on how to use Init Hooks in Odoo 18. In Odoo, Init Hooks are essential functions specified as strings in the __init__ file of a module.
Eng7-Q4-Lesson 1 Part 1 Understanding Discipline-Specific Words, Voice, and T...
Eng7-Q4-Lesson 1 Part 1 Understanding Discipline-Specific Words, Voice, and T...sandynavergas1Understanding Discipline-Specific Words, Voice, and Technical Terms
Rass MELAI : an Internet MELA Quiz Finals - El Dorado 2025
Rass MELAI : an Internet MELA Quiz Finals - El Dorado 2025Conquiztadors- the Quiz Society of Sri Venkateswara CollegeFinals of Rass MELAI : a Music, Entertainment, Literature, Arts and Internet Culture Quiz organized by Conquiztadors, the Quiz society of Sri Venkateswara College under their annual quizzing fest El Dorado 2025.
Essentials of a Good PMO, presented by Aalok Sonawala
Essentials of a Good PMO, presented by Aalok SonawalaAssociation for Project Management APM event hosted by the South Wales and West of England Network (SWWE Network)
Speaker: Aalok Sonawala
The SWWE Regional Network were very pleased to welcome Aalok Sonawala, Head of PMO, National Programmes, Rider Levett Bucknall on 26 February, to BAWA for our first face to face event of 2025. Aalok is a member of APM’s Thames Valley Regional Network and also speaks to members of APM’s PMO Interest Network, which aims to facilitate collaboration and learning, offer unbiased advice and guidance.
Tonight, Aalok planned to discuss the importance of a PMO within project-based organisations, the different types of PMO and their key elements, PMO governance and centres of excellence.
PMO’s within an organisation can be centralised, hub and spoke with a central PMO with satellite PMOs globally, or embedded within projects. The appropriate structure will be determined by the specific business needs of the organisation. The PMO sits above PM delivery and the supply chain delivery teams.
For further information about the event please click here.
How to Configure Restaurants in Odoo 17 Point of Sale
How to Configure Restaurants in Odoo 17 Point of SaleCeline GeorgeOdoo, a versatile and integrated business management software, excels with its robust Point of Sale (POS) module. This guide delves into the intricacies of configuring restaurants in Odoo 17 POS, unlocking numerous possibilities for streamlined operations and enhanced customer experiences.
APM People Interest Network Conference - Tim Lyons - The neurological levels ...
APM People Interest Network Conference - Tim Lyons - The neurological levels ...Association for Project Management APM People Interest Network Conference 2025
-Autonomy, Teams and Tension: Projects under stress
-Tim Lyons
-The neurological levels of
team-working: Harmony and tensions
With a background in projects spanning more than 40 years, Tim Lyons specialised in the delivery of large, complex, multi-disciplinary programmes for clients including Crossrail, Network Rail, ExxonMobil, Siemens and in patent development. His first career was in broadcasting, where he designed and built commercial radio station studios in Manchester, Cardiff and Bristol, also working as a presenter and programme producer. Tim now writes and presents extensively on matters relating to the human and neurological aspects of projects, including communication, ethics and coaching. He holds a Master’s degree in NLP, is an NLP Master Practitioner and International Coach. He is the Deputy Lead for APM’s People Interest Network.
Session | The Neurological Levels of Team-working: Harmony and Tensions
Understanding how teams really work at conscious and unconscious levels is critical to a harmonious workplace. This session uncovers what those levels are, how to use them to detect and avoid tensions and how to smooth the management of change by checking you have considered all of them.
South Hornsey: The Lost Local Authority that Merged with Stoke Newington by T...
South Hornsey: The Lost Local Authority that Merged with Stoke Newington by T...History of Stoke Newington
Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1...
Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1 2024 Lesson Plan M1...pinkdvil200
Reordering Rules in Odoo 17 Inventory - Odoo ݺߣs
Reordering Rules in Odoo 17 Inventory - Odoo ݺߣsCeline George
How to attach file using upload button Odoo 18
How to attach file using upload button Odoo 18Celine George
cervical spine mobilization manual therapy .pdf
cervical spine mobilization manual therapy .pdfSamarHosni3
TLE 7 - 3rd Topic - Hand Tools, Power Tools, Instruments, and Equipment Used ...
TLE 7 - 3rd Topic - Hand Tools, Power Tools, Instruments, and Equipment Used ...RizaBedayo
Computer Network Unit IV - Lecture Notes - Network Layer
Computer Network Unit IV - Lecture Notes - Network LayerMurugan146644
Kaun TALHA quiz Finals -- El Dorado 2025
Kaun TALHA quiz Finals -- El Dorado 2025Conquiztadors- the Quiz Society of Sri Venkateswara College
Blind Spots in AI and Formulation Science Knowledge Pyramid (Updated Perspect...
Blind Spots in AI and Formulation Science Knowledge Pyramid (Updated Perspect...Ajaz Hussain
TPR Data strategy 2025 (1).pdf Data strategy
TPR Data strategy 2025 (1).pdf Data strategyHenry Tapper
Eng7-Q4-Lesson 1 Part 1 Understanding Discipline-Specific Words, Voice, and T...
Eng7-Q4-Lesson 1 Part 1 Understanding Discipline-Specific Words, Voice, and T...sandynavergas1
Rass MELAI : an Internet MELA Quiz Finals - El Dorado 2025
Rass MELAI : an Internet MELA Quiz Finals - El Dorado 2025Conquiztadors- the Quiz Society of Sri Venkateswara College
Essentials of a Good PMO, presented by Aalok Sonawala
Essentials of a Good PMO, presented by Aalok SonawalaAssociation for Project Management
How to Configure Restaurants in Odoo 17 Point of Sale
How to Configure Restaurants in Odoo 17 Point of SaleCeline George
APM People Interest Network Conference - Tim Lyons - The neurological levels ...
APM People Interest Network Conference - Tim Lyons - The neurological levels ...Association for Project Management
Práctica no1
- 1. PRÁCTICA No1 13/07/2015 EJERCICIO 1 FORMULAS Y FUNCIONES DESCRPCION DEL PRODUCTO =BUSCARV (A7; A3:D12; 2; FALSO) CANTIDAD DE PRODUCTO =BUSCARV (A7; A3:D12; 3; FALSO)
- 2. EJERCICICIO 2 FORMULAS Y FUNCIONES SEGÚN UN NUMERO DE CEDULA CODIGO DEL CLIENTE =BUSCAR (H4; B3:B12; A3:A12) NOMBRE DEL CLIENTE =BUSCARV (H4; B3:C12; 2; FALSO)
- 3. EJERCICIO 3
- 4. FORMULAS Y FUNCIONES SEGÚN LA CEDULA NOMBRE DEL CLIENTE =BUSCARV (B4; CLIENTES! B3:C12; 2; FALSO) CODIGO =BUSCAR (B4; CLIENTES! B3:B12; CLIENTES! A3:A12) CIUDAD =BUSCARV (B4; CLIENTES! B3:D12; 3; FALSO) TELEFONO =BUSCARV (B4; CLIENTES! B3:E12; 4; FALSO) DESCRIPCION =BUSCARV (A8; PRODUCTOS! A3:D12; 2; FALSO) Precio unitario =BUSCARV (A8; PRODUCTOS! A3:D12; 4; FALSO) PRECIO TOTAL =C8*D8 SUBTOTAL =SUMA (E8:F17) IVA 12% =E18*12% TOTAL =SUMA (E18:F19)