excel 100

Which are valid Microsoft Excel functions

AVERAGE, MAX, and MIN

53. Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use?

AVERAGEIFS

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

AutoComplete

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

Error Checking

. John's workbook includes 3 worksheets. Which option should he choose to print them?

Print Entire Workbook

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?

Protect Workbook

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?

Trace Precedents

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

Unhide

14. Steve would like to print only the worksheet he is currently working on. What print option should he choose?

Active Sheet

What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen

Arrange all

In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit

AutoFit

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

AutoRecover

19. Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use

B. =D4*F4

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?

C. Edit Comment

18. Which group on the Formula Ribbon contains the command that checks for common errors found in a formula

C. Formula Auditing

Where is the spell checker feature located in Microsoft Excel

C. Review Ribbon

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

C. 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:

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

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

C. sort

. Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should she use?

COUNTIF

74. 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

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

Cell Style

On which tab is the Shape Effects command located?

Chart Tools Format tab

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

Clear Contents

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

Column

. 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

Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?

Custom Filte

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

Customize the Ribbon

76. Which process allows the user to create a custom template

D. click Save As and set the file type to .xltx

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

Data Validation

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

Delete

. Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?

Design

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

Design

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

. What area contains the command used to customize the print options in Microsoft Excel?

File Tab

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

Fill Series

64. What is the process of viewing a PivotTable report for a subset that meets the criterion only?

Filtering

David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?

Find and replace

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

Font Size drop-down list

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

Font color

2. 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

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

Format

47. 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

22. Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?

Function

Which is a prewritten formula that is built into Microsoft Excel?

Function

. Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include?

Gridlines

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

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

Home Ribbon

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

Importing data

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

Labels

Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include

Legend

. 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 Cente

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

51. James wants his spreadsheet to return true when the logical value is false. What function should he use

NOT

. 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

41. Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

New Window

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

Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet

Online Pictures

1. 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

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 layout

68. 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

3. Which Microsoft Office object would you use for quick, convenient, oneclick 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

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

Right-click on a style and choose Duplicate

. How is an exact copy of a worksheet created within the same workbook?

Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu

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?

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 change the order of the worksheets in his workbook. Which option would he choose

Scale

Which command is used to remove manual page breaks from a worksheet area?

Select Remove Page Break from the Breaks drop-down area

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

Shapes

43. 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

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select

While pointing to the Select All button, choose Move or Copy from the Shortcut Menu

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

Workbook

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

budget.xltx

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

Which is an example of a trendline option in Excel?

exponential

94. The statement that best describes the GETPIVOTDATA function is that it

extracts data stored in a PivotTable.

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

form control

83. 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

73. Changes become part of the change history only when the user

saves the workbook.

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

tables

98. 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

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

Financial

What ribbon contains the commands for creating charts in Microsoft Excel

Insert

6. What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility

Zoom to Selection

Which group on the Formulas tab enables a user to specify when a formula is computed?

. Calculation

. 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

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

Which is an example of a correctly written nested function?

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