MS EXCEL - Yaquini

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