Notes

Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and project or hide cells in a worksheet?
Correct Answer
Format
Form
You Answered
Insert
Sort & Filter

Question 2
1 / 1 pts
John would like to remove a worksheet from his workbook. Which option should he choose?
Correct!
Delete
Move
Copy
Insert

Question 3
0 / 1 pts
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
Split
You Answered
Hide
Page Break
Correct Answer
Freeze

Question 4
0 / 1 pts
Jack would like to force the data in his spreadsheet to fit one page when printed. Which option should he select?
Correct Answer
Scale
Header
You Answered
Hide
Freeze

Question 5
0 / 1 pts
Which ribbon includes the commands to apply a quick table style to a range of cells?
Correct Answer
Home
Data
Page Layout
You Answered
Insert

Question 6
0 / 1 pts
Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?
Customer Filter
Correct Answer
Ascending
Primary Sort
You Answered
Descending

Question 7
0 / 1 pts
James wants to use an advanced function to search his spreadsheet for a specific string in a text string?
You Answered
VLOOKUP
SUBSTITUTE
REPLACE
Correct Answer
FIND

Question 8
1 / 1 pts
Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?
OR
Correct!
AND
NOT
IF

Question 9
0 / 1 pts
Tom wants to convert all text to lowercase. Which function should he use?
Trim
You Answered
Proper
Upper
Correct Answer
Lower

Question 10
0 / 1 pts
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
Correct Answer
VLOOKUP
SEARCH
You Answered
HLOOKUP
LOOKUP

Question 11
1 / 1 pts
SUMIF and SUMIFS are in which category of functions?
Correct!
Math & Trig
Text
Lookup & Reference
Logical

Question 12
0 / 1 pts
James wants his spreadsheet to return true when the logical value is false. What function should he use?
AND
OR
You Answered
IF
Correct Answer
NOT

Question 13
0 / 1 pts
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?
You Answered
COUNTIFS
Correct Answer
AVERAGEIFS
TOTALIFS
SUMIFS

Question 14
0 / 1 pts
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?
Correct Answer
SUMIF
COUNTIF
You Answered
TOTALIF
AVERAGEIF

Question 15
1 / 1 pts
IF, AND, OR, and NOT are all part of which category of functions?
Lookup & Reference
Correct!
Logical
Text
Math & Trig

Question 16
0 / 1 pts
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?
You Answered
Ascending
Filter
Correct Answer
Custom Filter
Descending

Question 17
1 / 1 pts
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
Cell Style
Correct!
Format as Table
Fill Color
Conditional Formatting

Question 18
1 / 1 pts
What is the process of bringing data containing text fields separated by commas into Excel called?
Data integration
Correct!
Importing data
Data Collection
Data migration

Question 19
0 / 1 pts
All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made?
Track Changes
Correct Answer
Change History
History
You Answered
Names Manager

Question 20
0 / 1 pts
What ribbon contains the commands for creating charts in Microsoft Excel?
Correct Answer
Insert
Data
You Answered
Page Layout
Home

Question 21
1 / 1 pts
Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?
Correct!
Layout
Format
Style
Design

Question 22
0 / 1 pts
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
Correct Answer
Design
You Answered
Layout
Options
Format

Question 23
0 / 1 pts
John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?
Axis Fields
Report Filter
You Answered
Values
Correct Answer
Legend Fields

Question 24
0 / 1 pts
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
You Answered
Screenshot
Picture Cropping
Shapes
Correct Answer
Screen Clipping

Question 25
0 / 1 pts
Ken has inserted a picture into his spreadsheet and would like it to standout with a fram or 3D effect. Which tool would he use to achieve this?
Correct Answer
Picture Styles
You Answered
Artistic Effects
Corrections
WordArt Styles

Question 26
1 / 1 pts
Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
Correct!
Clip Art
SmartArt
Picture
Instant Art