Excel 3 – Quiz Module 3

How do you convert a range of data into a table in Ex *

Home > Format as Table

Insert > Table

Both a and b

Data > Table Tools

Which shortcut key creates a table from a selected range? *

Ctrl + T

Ctrl + P

Ctrl + C

Ctrl + V

Which of the following is NOT a conditional formatting option? *

Data Bars

Color Scales

Icon Sets

Pie Charts

How can you quickly add a total row to an Excel table? * *

Right-click and select 'Insert Total Row'

Table Tools > Design > Total Row

Home > Total

Data > Add Total

How do you apply a specific style to a table? *

Select the table and choose from Table Styles in the Design tab

Use the Format Painter tool

Right-click and choose 'Style'

Apply font color manually