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))