WorksheetsMS EXCEL - Yaquini
Total questions: 50
Worksheet time: 25mins
The Daverage function in MS Excel is a powerful tool that allows users to calculate the average of a range of cells based on specific criteria. Which of the following functions is to be execute for the Daverage function?
=DAVERAGE(database, field, criteria)
=DAVERAGE(database, criteria, field)
=DAVERAGE(data, base, field)
=DAVERAGE(criteria, database, field)
Qlyde uses spreadsheets to create art. Which of the examples below do you think is a real use of a spreadsheet?
Create a full length role playing game.
Create a sodoku
A. Convert a photo into a spreadsheet
All the of the above
What is the space within the black border?
a cell
a box
a variable
a data
Michael wants to create a Payment Type Column as a drop-down list. Which feature should we use?
Conditional formatting
Data validation
Bulleted list
Absolute cell reference
Sally wants to look up her product sale "Orange" using the VLOOKUP Function, but she accidentally typed "Ornage". What formula should she use?
=VLOOKUP(lookup_value, table array, col_index_num, 1)
VLOOKUP(lookup_value, table array, col_index_num, 0)
A and B
None of the two
Mathematical calculations in a spreadsheet are called?
words
values
formulas
labels
Where is a valid simple formula from the choices?
=(A3*T3)/100
=(AB3+Y5)*5
=A3:A10
Robert prepares a spreadsheet with his items and sales. He wants to look up the sale of one of his products; what type of lookup may he use?
Horizontal Lookup
Vertical Lookup
A and B
None of the two
Kadmiel wants to search up his product, but the product only goes in one direction. Which formula should he use?
HLOOKUP
VLOOKUP
LOOKUP
CLOOKUP
The NOW function is not categorized under excel date/time.
Agree
Disagree
Undecided
Maybe
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula.
&
#
=
*
The excel days360 function does not return the number of days between two dates on a 360-day year.
False
True
Maybe
What is the difference between the DATEVALUE function and other date conversion functions in Excel?
function in Excel converts a date stored as text into a serial number that represents the date.
function is used to calculate the difference between two dates in terms of years, months, or days. It returns the number of whole days, months, or years between two dates.
C.function in Excel is used to calculate a date that is a specified number of months before or after another date.
If we have an Excel database and need to calculate the number of non-empty cells in a specific column, which function should be utilized?
DAVERAGE
DCOUNT
DCOUNTA
DGET
Which of these options is NOT part of the VLOOKUP function?
Column number
Range to search in
Value to look up
Row number
Which function was utilized to determine the highest data value?
Min (Minimum)
Max (Maximum)
Ave (Average)
Sum (Summation)
This function is designed to retrieve a singular value from a column in a table, which aligns with a specified criterion in another column within the same table.
LOOKUP
DCOUNT
DGET
DAVERAGE
What is the purpose of the TRUE/FALSE parameter in a VLOOKUP function?
Whether to capitalize the result
Whether to use an exact or approximate match
Whether to add or subtract
Whether to multiply or divide
This function calculates the quantity of non-empty cells (comprising text, numbers, errors, etc.) in a designated field or column of a database that fulfills specific criteria.
Dcount
Dcounta
count
counta
Qlyde wants to delete all sheets except sheet 1 and 2, is it possible to do so?
Yes, it is
No, its not
Maybe, it could be
It depends
When would you use TRUE in a VLOOKUP function?
When you want an approximate match
When you want an exact match
When you want to divide the result
When you want to multiply the result
In Excel, the number of sheets is restricted by the computer's memory.
Yes, it is restricted
No, its not restricted
Maybe
What does HLOOKUP stand for?
Hidden Look up
Horizontal Look up
Hyper Look up
High Look up
A value to search for, which can be a number, text, or a logical value of TRUE or FALSE.
Array
Look up Vector
Look up Value
Result Vector
The Excel DAYS function determines the days between two dates. Can you identify the correct Days function from the list provided?
figures out what day of the month it is
calculates the number of days between two dates
figures out what is the month in the date
calculates the number of months between two dates
A single-row or single-column range should be selected for the search and sorted in ascending order.
Look up vector
Look value
array
What is the primary purpose of the DCOUNTA function in Excel?
Counting only numeric values
Counting blank cells
Counting non-blank cells
The function enables the selection of two actions depending on a specified condition.
False
True
Maybe
How does HLOOKUP differ from VLOOKUP?
HLOOKUP and VLOOKUP are the same.
HLOOKUP searches horizontally, while VLOOKUP searches vertically
HLOOKUP searches in circles, while VLOOKUP searches in squares.
HLOOKUP searches vertically, while VLOOKUP searches horizontally.
This MS Excel function makes use of something relational operators
IF
Min
Max
Count
What is the purpose of the DEVERAGE function in Excel?
The median of a dataset
The mode of a dataset
The mean of a dataset, excluding outliers
Which Excel function is used to calculate the date that is a specific number of months before or after a given date?
DATE
DATEDIF
EDATE
DATEVALUE
Fill the missing, =IF(....................., value_if_true,value_if_false)
Lookup Value
criteria
condition
logical test
This is the range you want to utilize for the lookup – either a single row or column, where the result should be situated in the same position as the lookup value. What is this all about?
array
look up value
result vector
vector
A range of cells where you want to search for the lookup value. The values in the first column or row (depending on whether you do V-lookup or H-lookup) must be sorted in ascending order. Uppercase and lowercase characters are deemed equivalent.
Array
Look up Value
Result vector
Vector
What is the function inside another function?
vlookup function
count function
if function
The _________ search for an item of data in a table and then extract the rest of information relating to that item.
if()
count()
lookup()
sumif()
What does VLOOKUP help you do in Excel?
Sort data
Create charts
Find specific information in a table
Write formulas
The secretary of Cognitech Explorers is seeking a method to promptly access a summary of members' attendance. In Microsoft Excel, which function can assist in efficiently calculating the total attendance count for each member?
=DAYS(end_date,start_date)
DAYS(end_date,start_date)
=DAYS(start_date,end_date,)
DAYS(start_date,end_date,)
How many elements comprise a VLOOKUP function?
2
3
4
5
The COUNTA function is utilized to count cells that contain data.
A1:B3
A1;B3
A1,B3
A1.B3
Which Excel function is used to find data horizontally in a table?
HINDER LOOK UP
HYPER LOOK UP
HIGH LOOK UP
HORIZONTAL LOOK UP
Which of these Vlookup functions is searching for an exact match?
=VLOOKUP (True, A2:B6, 2, C16)
=VLOOKUP (C16, A2:B6,3, TRUE)
=VLOOKUP (C16, A2:B6, 3, FALSE)
=VLOOKUP (C16, A2:B6,1, $C$4:$D$15)
In Excel, what is the purpose of using HLOOKUP?
To calculate sums horizontally
To create charts
To search for data horizontally
To search for data vertically
The primary purpose of the first argument in a VLOOKUP function is to ____.
Where to look
What to look for
to use an approximate or exact match
Which VLOOKUP formula should be applied to obtain the outcome in the highlighted cell?
.=VLOOKUP(A2:B9,2,FALSE)
=VLOOKUP(D3,A2,2,FALSE)
=VLOOKUP(D3,A2:B9,FALSE)
=VLOOKUP(D3,A2:B9,2,FALSE)
When using HLOOKUP, which of the following is the correct order of arguments?
lookup_value, table_array, row_index_num, range_lookup
range_lookup, row_index_num, lookup_value, table_array
table_array, lookup_value, range_lookup, row_index_num
row_index_num, lookup_value, table_array, range_lookup
How does the DEVERAGE function handle extreme values?
It includes them in the calculation
It replaces them with zeros
It excludes them from the calculation
It doubles their impact on the result
In Excel, the "_____________" function is a built-in tool that allows users to compute the gap between two dates in days, months, quarters, or years.
DAYS360
DATEDIF
EDATE
DATEVALUE
This Excel function belongs to the Database category and is utilized to calculate the number of cells containing solely numerical values.
Count
countif
dcount
dcounta
