WCSD SC&A Excel Basics

Elan needs to ensure that he can control the order of operations in his formulas. Which characters are used to provide the highest precedence?

• parentheses

• exponents

• multiplication and division

• addition and subtraction

Which method is an easy way to find a short description of a function?

• In the Insert Function dialog box, click the function name to get a short description.

• Open Help from the Backstage view to find a list of functions. 

• Insert the function and right-click it in the cell to access a description.

• Use the Search tool to find a list of functions and their descriptions. 

Which function category is not in Excel 2016?

• Financial

• Text

• Date and Time

• Conditional Formatting

Seneca needs to combine multiple cells into a single column heading. Which option should she use?

• Wrap Text

• Align Center

• Merge and Center

• Align Right

Which item is used in Excel to identify the row of a particular cell?

• letter

• number

• type

• sheet

Which formatting group would commonly be used for monetary figures?

• number

• general

• accounting

• currency

Which function is used to add a range of cells?

• =SUM

• =AVERAGE

• =MAX

• =ADD

Which ribbon tab is home to the Function library used to insert functions into worksheets? 

• Home

• Insert

• Formulas

• Data

Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

• =SUM(F2:F5,Sheet2A10)

• =SUM(F2:F5,Sheet2!A10)

• =SUM(F2:F5,!Sheet2A10)

• =SUM(F2:F5,_Sheet2A10)

In addition to the format commands that are found in the ribbon, which option is available for more extensive formatting?

• Fix Cells dialog box

• Format Cells dialog box

• Format dialog box

• Quick Access tool bar