wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel EXPERT Lesson 2 Quiz

Total questions: 13

Worksheet time: 13mins

Name
Class
Date
1.

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?

a)

Developer

b)

Home

c)

Insert

d)

Page L

2.

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?

a)

cell values that indicate advisor names

b)

cell values that are below average

c)

cell values that are above average

d)

cell values that indicate the top three performers

3.

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?

a)

cell style

b)

conditional formatting

c)

form controls

d)

macro

4.

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:

a)

cell style.

b)

font type.

c)

form control.

d)

theme.

5.

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

a)

Calculation Options

b)

Column Width

c)

Data Validation

d)

Filter

6.

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?

a)

Modify

b)

Apply

c)

Delete

d)

Duplicate

7.

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

a)

filters.

b)

form controls.

c)

functions.

d)

styles.

8.

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

a)

Home

b)

File

c)

Page Layout

d)

View

9.

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:

a)

cell styles.

b)

form controls.

c)

macros.

d)

themes.

10.

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?

a)

Data Bars

b)

Highlight Cells Rules

c)

Icon Sets

d)

Top/Bottom Rules

11.

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

a)

cell styles.

b)

cell formatting.

c)

conditional formatting.

d)

formulas in a worksheet.

12.

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?

a)

choose Info, then Properties

b)

choose Options, then Advanced

c)

choose Options, then Language

d)

choose Save, then Change L

13.

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

a)

Align.

b)

Conditional Formatting.

c)

Merge Cells.

d)

Rules Manager.