BUS 375 exam 3 SIMnet practice
in cell E2 enter a formula using TEXTJOIN to combine the text from cells B2:D2 into a single text string use the # character as the delimiter. ignore blank cells. use a cell range as the text1 argument
click on formulas tab--text-TEXTJOIN--enter # in delimiter--enter B2:D2 in text1--click ok
group together Dec 18 and Dec 11 worksheets
hold down shift and click on Dec 11
in cell F8 enter a formula using the MATCH function to return the row number of the payment date listed in cell C8. use the named range PayDates to reference the cell range for the payment date column.
lookup value:C8 lookup array: PayDates match type: 0
add a hyperlink from the selected cell to link to cell B4 in the social media worksheet. use b4 as the cell reference.
select insert tab. click on links group. click place in this document then select social media. type B4 as cell reference
Enter a formula using a database function to calculate the average value in the Cost column for expenses that meet the criteria in the criteria range A2:E3. The database is defined by the named range Expenses.
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Insert Function button. Inside the Insert Function dialog in the Or select a category drop-down, you selected Database. Inside the Insert Function dialog, you clicked the OK button. Inside the Function Arguments dialog, you typed Expenses in the Database input, pressed the Tab key, typed Cost in the Field input, pressed the Tab key, typed A2:E3 in the Criteria input, and pressed the Enter key.
use consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets BOB, Cathy, and Mario. include links to the source data to display subtotals
On the Data tab, in the Data Tools group, click the Consolidate button. Click the Bob worksheet tab. Click and drag to select B3:D8. Click the Add button. Click the cathy worksheet tab. Click Add. Click the mario worksheet tab. Click Add. click include links to source data. Click OK.
n cell A10, enter a formula using OR to display TRUE if net profit before tax in 2014 (cellB5) aregreater than 750000(seven hundred, fifty thousand)ornet profit before tax in 2015 (cellC5) aregreater than 750000(seven hundred, fifty thousand). Use cell references where appropriate and enter the arguments exactly as described in thisquestion.
On the Formulas tab, in the Function Library group, click the Logical button. Click OR. In the Logical1argument box,enter B5>750000. In the Logical2argument box, enter C5>750000. Click OK.
