Navigate to the cell B10 and use the appropriate function to display the text YES, if the price...

Navigate to the cell B10 and use the appropriate function to display the text YES, if the price of the item SCREEN is less than 115. Otherwise, the function returns the text NO.

Want more? Then download our TEST4U demo from

TEST4U provides an innovative approach to learning. Ignore the boring e-courses and use a new, interactive tool like 700 000 satisfied users did.

TEST4U is an automated test which cooperates with the actual applications and can be used to prepare the students for certification exams (e.g. Microsoft-Certiport, ECDL/ICDL, DIPLOMA etc.) and train and assess employees.

More on



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

Related TEST4U products:



TEST4U Microsoft Excel 365, 2019, 2016, 2013, 2010, 2007, 2003 - English version





TEST4U 3 in 1: MS Word, Excel, Internet 365, 2019, 2016, 2013, 2010, 2007, 2003 - English version





TEST4U Google Sheets - English version





TEST4U Microsoft Excel Expert 365, 2019, 2016, 2013, 2010, 2007, 2003 - English version





Data Analysis - English version





TEST4U Excel Advanced Features and Functions - English version





77-727 Microsoft Office Specialist Excel Core 2016 - English version





MO-200 Excel Associate - Office 365 & Office 2019 - English version





ECDL Base Spreadsheets - English version

test4u,infolearn,diploma,certification,education,microsoft,office,microsoft office,spreadsheet,excel,sheet,table,chart,excel 365,365,microsoft excel 365,Functions,1742,