Exam 15: Creating an Advanced Workbook

The accompanying image illustrates the _____ dialog box in the File tab of Microsoft Excel 2016. ​ ​

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 uses conditional formatting to make the following changes: change the background color of the cells with current salary of $3000 to $4000 to yellow, change the font color, generate data bars on each cell, and highlight the cells containing the names with blue color. In this scenario, which of the following changes will be applied first?

While printing a complete workbook, Excel also prints the hidden rows and columns in the workbook. ​

Steve, a sales manager, maintains a worksheet for sales details, which includes his target, the number of sales achieved, the clients, etc. in the past two years. If Steve wants to print these details for just the last quarter, Steve should use the _____. ​

In Microsoft Excel, the Print Titles button is found on the _________ tab. A)Design B)Review C)View D)Page Layout

In the context of logical functions, the _________ symbol in the logical test argument is a comparison operator. A)& B)/ C): D)=

If a row is hidden in an Excel sheet, _____. ​

Which of the following is true of printing the data in an Excel sheet? ​

Explain with examples the different ways in which the IF function can be used. ​

Damien, an accountant, needs to calculate the following: 8^12*(124+1344+176)/100. He uses an Excel worksheet for the calculation. Which of the following functions will Excel perform first?

The Error Checking button appears on an Excel sheet when:

Identify a true statement about conditional formatting.

Conditional formatting can be used to:

John, a researcher, collects a large amount of data to perform statistical analysis and saves them using Excel. He wants to print the data and bind the pages to submit as a thesis. In this scenario, John has to _____ to accommodate the page binding . ​

Which of the following is an example of conditional formatting? ​

An _________ is a message that appears in a cell indicating that some part of a formula is preventing Excel from returning a calculated value. A)error indicator B)error marker C)error value D)error message

The Conditional Formatting button is available on the Home tab in Microsoft Excel. ​

In Microsoft Excel 2016, the formula '=IF(G5=L5,"Yes", "No")' is a _____ function.

To access conditional formatting on Microsoft Excel, click the Conditional Formatting button on the _________ tab. A)Insert B)Review C)File D)Home

The error value " #N/A" indicates that: