Excel Expert 2016 - Test Bank

Daniel wants to create a custom theme color in Excel. On which tab will he find theme colors?

• File

• Home

• Page Layout

• View

Vicki wants to create a custom font format from her Excel workbook in which she changes the heading and Body fonts. Which tab should she select to create a new font format?

• Developer

• Home

• Insert

• Page L

Which file name would be used for an Excel 2016 template?

• budget.xltx

• budget.xlsx

• budget.xlsm

• budget.xlt

Tasha is working for a global company and wants to ensure the employees in another country can understand the workbook. She would like to perform a spell check in a foreign language. What is the next step she should take after selecting the File tab?

• Choose Info, then Properties

• choose Options, then Advanced

• choose Options, then Language

• choose Save then Change L

Which Excel command will allow Amarii to limit the number of characters that can be entered into a cell?

• Calculation Options

• Column Width

• Data Validation

• Filter

As the manager of a furniture store, Sally is using an Excel spreadsheet to keep track of the store sales goals. She wants to use a function that will return "True" if at least one of the two goals is reached. Which function should she use?

• AND

• IF

• NOT

• OR

The Excel Rules Manager provides the option to create, modify apply, and remove:

• cell styles

• cell formatting

• conditional formatting

• formulas in a worksheet

PMT, PV, and FV are functions found in which Function Library category?

• Financial

• Logical

• Math & Trig

• Statistical

Perry is using multiple worksheets and would like to total the numbers into one summary worksheet: Which built-in Excel tool should Perry use to accomplish his goal quickly

• Consolidate Data

• Error Checking

• Evaluate Formula

• Watch Windo

Doug wants to know how many gadgets he would have to sell to make $1,000,000. Which Excel tool will help Doug find the answer?

• Data Validation

• Existing Connections

• Goal Seek

• Scenario Manager