Exam 15: Creating an Advanced Workbook

Y ou can tell rows or columns are hidden in an Excel sheet when :

The _________ is a logical function that returns one value if a statement is true and returns a different value if that statement is false. A)IF function B)DELTA function C)CELL function D)N function

In Microsoft Excel 2016, the Hide & Unhide option can be accessed by clicking the _____ on the Home tab.

Which of the following is the order of operations to calculate formulas with multiple functions in Excel?

The order of operations that Microsoft Excel follows is division, multiplication, exponentiation, and addition. ​

In a Microsoft Excel worksheet, you can add a header and footer by clicking the _____. ​

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. Frank fills eight columns and over a thousand rows of text in an Excel worksheet. He wants to collate the text in three of the columns in a single column. Frank enters the first two cells manually and then uses the Flash Fill function. Flash Fill suggests a pattern that is not the pattern Frank requires. To reject the suggested pattern, Frank should press the _____ key.

If a formula contains several functions, Excel starts with the outermost function and then moves inward. ​

The accompanying image is of a _____ dialog box in Microsoft Excel 2016.

Flash Fill enters text based on _____.

Roger, an accountant at SellDom Inc., has entered the company's expenditure, assets, profits, and debt details on an Excel sheet. Since the data are valuable, he needs to retain and save the sheet. If Roger wants to print only the details of the company's expenditure and profits from the Excel sheet, he should: ​

Which of the following indicates that an error has occurred in an Excel calculation? ​

A _________ is a value in a formula that does not change. A)constant B)derivative C)standard D)function

A row or a column in an Excel worksheet can be hidden by using the _________ button on the Home tab. A)Format B)Edit C)Alignment D)Connection

A(n) _________ is a function that works with statements that are either true or false. A)statistical function B)logical function C)text function D)information function

Explain how manual page breaks is a better option over automatic page breaks. ​

The Quick Analysis button appears when: ​

Flash Fill is a function in Microsoft Excel used to enter formulas with multiple calculations. ​

The accompanying image of Microsoft Excel 2016 shows the _____ dialog box that provides several print options. ​ ​

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