NEW
Font size
WorksheetsExcel EXPERT Lesson 2 Quiz
Total questions: 13
Worksheet time: 13mins
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?
Developer
Home
Insert
Page L
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
cell values that are below average
cell values that are above average
cell values that indicate the top three performers
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?
cell style
conditional formatting
form controls
macro
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:
cell style.
font type.
form control.
theme.
Which Excel command will allow Amarii to limit the number of characters that can be entered into a cell?
Calculation Options
Column Width
Data Validation
Filter
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
Apply
Delete
Duplicate
Combo boxes, check boxes, scroll bars, text boxes, and labels are all examples of:
filters.
form controls.
functions.
styles.
Daniel wants to create a custom theme color in Excel. On which tab will he find theme colors?
Home
File
Page Layout
View
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:
cell styles.
form controls.
macros.
themes.
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
Highlight Cells Rules
Icon Sets
Top/Bottom Rules
The Excel Rules Manager provides the option to create, modify, apply, and remove:
cell styles.
cell formatting.
conditional formatting.
formulas in a worksheet.
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 Info, then Properties
choose Options, then Advanced
choose Options, then Language
choose Save, then Change L
An Excel feature that enables the user to specify how to display cells that meet certain requirements is known as:
Align.
Conditional Formatting.
Merge Cells.
Rules Manager.
