Exam 15: Creating an Advanced Workbook

The IF function is an example of a text function in Microsoft Excel. ​

Lidya, a Mathematics student, solves the formula "=5^6(306/44)*(122/55) - 1000" manually. She uses an Excel sheet to cross-check the answer. The function that Excel will perform last is _____.

In the context of logical functions, a(n) _________ operator is a symbol that indicates the relationship between two values. A)comparison B)arithmetic C)reference D)text concatenation

While using Flash Fill, make sure that:

Case 15-1 Frank, a business analyst at Pro-White Technologies, deals with vast amount of data and analysis. Since Frank uses Excel worksheets for most of his work, he uses several advanced functions of Excel that eases and speeds up his work. Using an Excel worksheet, Frank creates a list of the cities where his company's business could possibly thrive. He also includes the names of the states the cities belong to and the average revenue of the residents in the sheet. Frank wants to collate the whole data in a single column (for example, Boston, Massachusetts - $75667). In this scenario, Frank should use _____ as the data he needs to collate follows a pattern. ​

In Microsoft Excel, the error value message #NAME? appears when a value is not available to a function or formula. ​

​ The header and footer entered in an Excel sheet are static and do not get updated automatically when the worksheet"s name is changed.

In Microsoft Excel, _________ is a page break that Excel inserts when no more content will fit on the page. A)manual page break B)automatic page break C)portable page break D)final page break

An _________ is a small green triangle that appears in the upper-left corner of a cell with a possible error. A)error marker B)error indicator C)error detector D)error signature

In Microsoft Excel, _________ is a page break that you insert to specify where a page break should occur. A)manual page break B)automatic page break C)portable page break D)final page break

In the accompanying image of Microsoft Excel 2016, box A points to an:

Case 15-2 Zelda, the Human Resource (HR) manager at ProfDot Technologies, creates a database on an Excel sheet of the names of potential candidates for a job. In addition, she enters the work experience, current salary, and expected salary against each name. Zelda wants to change the background color of the cell with the names of candidates whose expected salary is in the range of $6000 to $7000 per month. In this scenario, Zelda should use the _____ option in conditional formatting.

Conditional formatting is dynamic-if a cell's value changes, the cell's format also changes as needed. ​

In Microsoft Excel, you can use multiple IF functions in the same formula to test for several conditions. ​

In Microsoft Excel, the error value message #NUM! appears when the wrong type of argument is used in a function or formula. ​

In Microsoft Excel, the Page Break Preview button is available on the _____.

Victor, a population analyst, has the following data on an Excel sheet: month-wise population of a city in 2014 in column A and month-wise population of the same city in 2015 in columnB)He wants to calculate the change in population in 2015 compared to 2014 and check if the change is more or less than 2 million. Victor uses multiple functions, including the IF function, within a single formula for this analysis. In this scenario, Victor uses a _____.

Explain the uses of conditional formatting. ​

In the accompanying image of Microsoft Excel 2016, box A points to an _____.

Case 15-2 Zelda, the Human Resource (HR) manager at ProfDot Technologies, creates a database on an Excel sheet of the names of potential candidates for a job. In addition, she enters the work experience, current salary, and expected salary against each name. Zelda previously highlighted the cells with the names of candidate who have over two years of work experience using conditional formatting. If Zelda wants to remove the condition from the worksheet, she should use the _____ option.