2016 Microsoft Excel Final review-FALL 2019

Which statement is true about slicers?

A user can select multiple buttons within a slicer

Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?

Design

Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?

Edit Comment

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

Entry

Mrs. Perry is troubleshooting formulas and functions in her Excel workbook. Which feature would she use to check for common mistakes in formulas?

Error Checking

Michelle is trying to correct a formula error in cell B7. Which command will help her identify the cells that affect the value of B7?

Evaluate Formula

James wants to use an advanced function to search his spreadsheet for a specific string in a text string. What function should he use?

FIND

Which Excel term, denoted with [square brackets], can be found in the header row of a table and refers to the set of all cells that comprise the named column in the table?

FieldName

Which command on the Fill options dialog box is the default option if a month or day is entered?

Fill Series

Which Excel group in the PivotTable Tools, Analyze tab contains the option to insert a timeline once a PivotTable is created?

Filter

Which Excel group on the PivotTable Tools, Analyze tab has the option to insert a slicer in a PivotTable?

Filter

Damon wants to be able to view test scores for one subject area at a time in his PivotChart. Where should he drag the "Subject" field in the PivotChart Fields Task Pane Options?

Filters

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

Financial

On the Home Ribbon, what is used to change the font size of characters in a cell?

Font Size drop-down list

Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?

Format

Which command on the Home Ribbon is used to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

Format

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?

Format as Table

In Microsoft Excel, what is used to emphasize certain entries and make the worksheet easier to read and understand?

Formatting

John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?

Freeze Panes

IF, AND, OR and NOT are all part of which category of functions?

Logical

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

Merge and Center

Chris wants to update the default Title Style by changing the font color and font style. To accomplish this, on the Home tab, in the Styles Group, Chris should click on the Cell Styles icon, right-click the Title Style, and select which option?

Modify

Which function takes three separate values and combines them to form a date-time code?

NOW

In order to change the name of a range of cells, the user must first click the Formulas tab. What feature should the user click next?

Name Manager

Which Excel feature keeps track of defined ranges and cell addresses?

Name Manager

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?

OR

Jill would like to use a function that will return "True" when only one of the arguments in the function is true. What function should she use?

OR

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?

Open

Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?

Orientation

Which financial function allows Robyn to determine the amount she must pay each month on her car loan?

PMT

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

Page L

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

Page Layout

Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this?

Picture Styles

Which is the name of an interactive graphical representation of data that allows a user to change the groupings?

PivotChart

Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories for grouping?

PivotTable

A PivotChart is normally based on an existing:

PivotTable.

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?

Quick Access Toolbar

The FBLA Advisor at Hilltop High School would like to create random ID numbers for FBLA members. Which function would be used to have Excel pick a random number between 1,000 and 5,000 for the new member ID numbers?

RAND BETWEEN(1000,5000)

Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?

Range

Where is the spell checker feature located in Microsoft Excel?

Review Ribbon

How can a table style be quickly modified to meet user preferences?

Right-click on a style and choose Duplicate

Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?

Row

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?

SUMIF

John would like to add a banner at the top of his spreadsheet. Which object should he insert?

Shapes

Naming ranges or an individual cell is a time-saving technique. Range names may include a letter, an underscore, and:

a backslash.

Allison is working with a PivotTable in Excel, but the PivotTable Fields Pane has disappeared. In order to make the PivotTable Fields Pane reappear, she must click on:

any active cell with showing data.

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

budget.xltx

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

cell formatting.

Leah and her fellow FBLA officers want to analyze scores from the most recent competitive events. Which of the cell values would least likely be determined by using the Conditional Formatting feature of Excel?

cell values that indicate advisor names

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 Options, then Language

Which process allows the user to create a custom template?

click Save As and set the file type to .xltx

Which PivotChart tool limits the amount of data being displayed?

filter

Carol has created a worksheet that employees in her company will access to input data. To make it user-friendly and reduce input errors, Carol can insert a:

form control.

Logan wants to insert check boxes and command buttons in her worksheet to limit choices and make it easier for her employees to use. Check boxes and command buttons are types of:

form controls

Combo boxes, check boxes, scroll bars, text boxes, and labels are all examples of:

form controls.

Mary is editing a worksheet and has updated the formatting of a cell. She wants to copy the formatting to several cells throughout the worksheet. Which will reduce the time it takes to complete the task?

macro

When using Excel, which refers to placing one function within another function?

n

The statement that best describes the GETPIVOTDATA function is that it:

pulls data from a PivotTable and creates a new chart.

Which Excel term refers to a selection of cells?

range

Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:

range.

Amy is currently viewing a chart she recently created and would like to make a chart template from it. To complete this task, Amy should:

right-click in the Chart Area and select Save As Template.

Changes become part of the change history only when the user:

saves the workbook.

Mark has selected the sheet that contains a line chart. To add a trendline, Mark would:

select the trendline style in the chart styles gallery on the Chart Tools Design tab.

What does Emma need to do before she can group the data in her PivotTable?

sort

Which is an example of a trendline option in Excel?

stock

An Excel table of text, numbers, or values that can be used in a formula is referred to as a/an:

table array

To create a PivotTable from Power Pivot data, the data must be in:

tables.

Sarah knows she has chosen the best type of trendline for the data on her chart because:

the R2 value is closest to 1.

Which is a graphical representation that fails to depict all of the exact data in the worksheet?

trendline

An advantage of using the Power Pivot model over standard PivotTables is the ability to:

use data in multiple related tables.

Alicia needs to delete the data in cell B5. Which command would she select?

Clear Contents

What defines the color of the characters in a Microsoft Excel worksheet?

Cell color

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

Labels

How is a cell reference in a formula and its corresponding location in a worksheet identified?

Cell reference and cell location are outlined in matching colors

Which is an example of a correctly written nested function?

=PROPER(RIGHT(B4,LEN(B4)-FIND(" ",B4)))

Which is an example of a function that extracts the year from a date that is typed in cell B9?

=YEAR(B9)

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?

AutoComplete

Which Excel command allows Susan to automatically save her workbook every 15 minutes?

AutoRecover

A spreadsheet contains 50 rows with pet records. Column A is "Breed", column B is "Name", and column C is "Gender". To determine the number of animals that are female, what is the range when using the COUNTIF function?

C2:C50

Katie wants to calculate the total dues collected from FBLA members. She notices the total is not being updated as she changes the data. Which option on the Formula tab would allow her to fix this problem?

Calculation Options

Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?

Cell Style

An Excel feature that enables the user to specify how to display cells that meet certain requirements is known as:

Conditional Formatting

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

What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

Copy using the Fill Handle

Which Excel command allows a user to display hidden ribbon tabs?

Customize the Ribbon

Coach Morgan wanted his team members to visualize and compare how scores related among team members. Which Conditional Formatting feature would best accomplish this goal?

Data Bars

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

Data Validation

Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?

Delete

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

Goal Seek

Tyrone would like to use a function that returns a value that meets criteria in the second row of a table in his spreadsheet. Which function should he use?

HLOOKUP

Where is the command to apply a fill color to a cell or range of cells in a worksheet?

Home Ribbon

On which tab is the Shape Effects command located?

Home tab

What is the process of bringing data containing text fields separated by commas into Excel called?

Importing data

What ribbon contains the commands for creating charts in Microsoft Excel?

Insert

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

Sort & Filter

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?

Text

Which is true about trendlines?

They can be used to predict future values

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?

Unhide

Kash is working with a large, complex worksheet and would like to to see what is going on in different cells in different parts of the workbook. What built-in tool would Kash use to make monitoring various cell values much simpler?

Watch Window

Which notebook-like feature organizes the sheets for use in Excel?

Workbook