Excel Questions For Work Test Part 2

In this video we will learn to solve the Excel Work Test questions, especially in the Admin section.
We will also explore the Vlookup and Hlookup formulas in Excel problems.

There are several formulas that are explained, including:
IF
Vlookup
Hlookup
SUM
AVERAGE
SUMIF
SUMIFS

Happy watching, hopefully useful.

----------------------------------

Timestamps :
00:00 Intro
01:50 Customer Name Column (HLOOKUP)
03:58 Product Name Column (VLOOKUP)
05:35 Unit Price Column (VLOOKUP)
07:06 Total Sales Column (Multiplication Formula)
08:47 Discount Column (IF)
12:03 Net Sales Column (Deduction Formula)
12:33 Total and Average (SUM and AVERAGE) Rows
14:23 Total Net Sales Per Product (SUMIF)
18:10 Total Net Sales Per Product For Brilliant Stores (SUMIFS)

----------------------------------

Please subscribe to the "Jendela Tutorial" channel to get updated tips and tutorials about computer applications.
   / jendelatutorial  

CONNECT WITH US - JENDELA TUTORIAL :
Website : https://jendelatutorial.blogspot.co.id/
HP / WA : 085 399 065 706
Instagram : zulkifli_latif92



Tags (Ignore):
job test excel questions
excel question
village device excel questions
excel questions for admin
excel vlookup and hlookup questions and answers
shopee excel questions
excel question if vlookup hlookup
difficult excel questions
employee salary excel question
village device test excel questions
company entrance exam questions
excel test questions for admin
shopee excel test questions
excel test questions for work
village device excel test questions
admin excel test questions
shopee data analyst excel test questions
administrative excel test questions
excel test questions and answers
excel vlookup test questions
job test excel questions
excel question if vlookup hlookup
employee salary excel question
village device test excel questions