What does this red mark mean?

shape that was inserted in excel

Ensure that row and column headings and gridlines display when printing the worksheet. How do you do this?

page layout tab, sheet options group, check print gridlines, check print headings

view tab, show group, check gridlines

file, print, page setup, sheet tab, check gridlines

Set the labels in the fourth row to repeat on each page. How do you do this?

page layout tab, page setup group, print titles, rows repeat at top, select row 4

page layout tab, scale to fit group, repeat at top button, select row 4

page layout tab, arrange group, align button, select row 4

wrong tab you have to go to print preview

Copy the Summary worksheet from the Quarterly_Earnings_Overview.xlsx workbook, found in your Gmwtrix Templates folder, and place it as the last worksheet in the Quarterly_Earnings.xlsx workbook.

file, open, select Quarterly_Earnings_Overview.xlsx, home tab, cells group, format, move or copy worksheet, select move worksheet to end

insert tab, text button, object, create from file, Quarterly_Earnings_Overview.xlsx

insert tab, text button, object, create from file, Quarterly_Earnings_Overview.xlsx, move worksheet to the end

file, open, select Quarterly_Earnings_Overview.xlsx, home tab, cells group, format, move or copy worksheet

Can you split part of your worksheet? If so, how?

yes, click on the cell you want to split, view tab, window group, split button

no, you can put part of your worksheet on another tab

yes, click on the cell you want to split, right click, split button

What does freezing rows do?

makes it so the rows are visible when scrolling through the worksheet

makes it where another user can not edit those rows

makes it where it hides the rows

it makes your computer screen cold so it won't overheat while you are working in excel for a long period of time

How do you save a custom zoom and save as PageZoom?

view tab, workbook views group, custom views, add, name PageZoom

view tab, workbook views group, page layout, add, name PageZoom

view tab, zoom group, zoom to selection

view tab, window group, new window, add, name PageZoom

In the Top Performers worksheet, determine the highest sales number for 2010 in cell B2. Note-There is an another tab with the chart of all the top performers.

select B2, formulas tab, function library, AutoSum, Max, click on the Sales 2010 tab, select the range, press enter

select B2, formulas tab, click on the Sales 2010 tab, select the range, press enter

select B2, formulas tab, function library, AutoSum, Average, click on the Sales 2010 tab, select the range, press enter

select B2, click on the Sales 2010 tab, select the range,click back on the Top Performers worksheet, press enter

How do you calculate the sales percentage for each representative in the % Total column?

click on F3, type formula =E3/$E$8 use autofill

click on F3, use autosum formula, use autofill

click on F3, type formula =E3/E8 use autofill

click on F3, use average formula, use autofill

Save the entire workbook as a PDF file in your GmetrixTemplates folder, omitting document properties and tags. What should you do?

file tab, export, create PDF, publish as PDF, options check, check entire workbook and uncheck document properties and tags

file tab, save as, change file type to PDF, check boxes for omitting document properties and tags

In cell B28 on the Profits worksheet, insert a formula that displays the number of Sales greater than 250. What should you do?

click on B28, formulas tab, insert function, use countif, Range type D4:D26, Criteria >250

click on B28, formulas tab, insert function, use countif, Range type D4:D26, Criteria <250

click on B28, formulas tab, insert function, use countif, Range type D4:D26, Criteria =250

Modify the chart on the Profits worksheet so the Legend appears at the Top. What should you do?

click on the chart, chart tool design tab, chart layouts group, add chart element, legend, click top

chart tool design tab, chart layouts group, add chart element, legend, click top

click on the chart, chart tool design tab, data group, select data button, legend, click top

chart tool design tab, type group, change chart type button, legend, click top

In cell B4 on the Q1 Sales worksheet, insert a function that joins Description and Style from the Catalog worksheet, separated by a hyphen. Include a space on both sides of the hypen. (Example: Cross County - Hardtail). What does in Text1 field?

D4 cell on Catalog worksheet (Description column Cross country)

C4 on Catalog worksheet (Style column Hardtail)

In cell B4 on the Q1 Sales worksheet, insert a function that joins Description and Style from the Catalog worksheet, separated by a hyphen. Include a space on both sides of the hypen. (Example: Cross County - Hardtail). What does in Text2 field?

D4 cell on Catalog worksheet (Description column Cross country)

C4 on Catalog worksheet (Style column Hardtail)

In cell B4 on the Q1 Sales worksheet, insert a function that joins Description and Style from the Catalog worksheet, separated by a hyphen. Include a space on both sides of the hypen. (Example: Cross County - Hardtail). What does in Text3 field?

C4 on Catalog worksheet (Style column Hardtail)

D4 cell on Catalog worksheet (Description column Cross country)

Enable the Total Row for the table located on the Qtr 1 worksheet.

click on the table, table tools design tab, table style options group, check box the total row

click below the table and type "Total Row"

select the table, right click on the table, insert, click on total row

Insert a formula into cell G4 on the Employee Bonuses worksheet that evaluates whether the amount in Parts , Accessories , or Services exceed the Quarterly Goal . For each column that exceeds the goal, apply the Quarterly Bonus Rate . What should you do?

click on G4, use SUMIF function on formulas tab, range: B4:D4, Criteria: >100000, Sum_Range: B4:D4, click on formulas bar to multiply the Sumif function by B17, press enter

click on G4, use average function on formulas tab, range: B4:D4, Criteria: >100000, Sum_Range: B4:D4, click on formulas bar to multiply the Sumif function by B17, press enter

click on G4, use concentrate function on formulas tab, range: B4:D4, Criteria: >100000, Sum_Range: B4:D4, click on formulas bar to multiply the Sumif function by B17, press enter

click on G4, use IF function on formulas tab, range: B4:D4, Criteria: >100000, Sum_Range: B4:D4, click on formulas bar to multiply the Sumif function by B17, press enter

Remove the table functionality from PreOrders . Retain the font and cell formatting.

click on name box, select PreOrders, click on table tools design tab, tools group, click convert to range, click yes

click on PreOrders table, click delete

formulas tab, defined names group, name manager, click on preorders, check font and cell formatting

click on PreOrders table, home tab, format painter drop down, retain the font and cell formatting

On the Home-Made Pet Food worksheet, in cell A9, import New Flavors.txt located in the GMetrixTemplates folder as a tab-delimited file without headers.

click on A9 in the correct worksheet, data tab, get external data group, from text, click next then finish

click on A9 in the correct worksheet, insert tab, text, object, create from file, click on New Flavors.txt

How do you unhide a sheet?

home tab, cells group, format, hide and unhide, click unhide sheet

right click on the plus sign next to the worksheets, click unhide sheets

home tab, editing group, find and select, hide and unhide, click unhide sheet

click and hold down the plus sign next to the worksheets, click unhide sheets

On the Sold worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.

click somewhere in the table, table tools design tab, table styles options group, check banded rows

click somewhere in the table, table tools design tab, table styles group, click any of the options with every other row shaded

hold down Ctrl key to select a row, select every other row throughout the table, home tab, font group, paint bucket

Display the formulas that are in the cells of the Qtr 2 worksheet. How do you do this?

formulas tab, formula auditing group, show formulas

select the worksheet, right click, show formulas

What does the Proper function do?

first letter is upper case and the remaining letters are lower case

Excel Quiz 2 Quiz

39 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What would you type in the Criteria box? Use the COUNTIF function to count the number of times that the values in cell rand B6:B15 "exceed 5000".

<5000

>5000

=5000

/5000

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What would you type in the Range box? Insert a COUNTIF formula to count the data in cell range D43:D51 that is greater than 0.

D43:D51

0

>0

D43:D59

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the concatenate function do?

allows you to combine text from different cells into one cell.

allows you to delete text from different cells into one cell.

used for counting cells within a specified range that meet a certain criterion, or condition.

perform a logical test and return one value for a TRUE result, and another for a FALSE result.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do you put in the Logical Test Box? Use the IF function to show Close if the SUM of C9:D9 is greater than 22500 and Not Close if it is less than or equal to 22500.

SUM(C9:D9)>22500

Close

Not Close

SUM(C9:D9)<22500

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the formulas tab, what button do you click on to insert an IF formula?

insert function

autosum

define name

more funtions

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What would you type in the Criteria box? In cell G5 create an AVERAGEIF formula to calculate the average Amount if the Truck Type if General.

General

Amount

Truck Type

G5

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do you type in the Text box? Create a formula in cell C2 of the Trucks worksheet that returns the first three letters of the Truck column.

A2

3

Truck

C2

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

35 questions

Photoshop ACA

Quiz

•

9th - 12th Grade

35 questions

98-367 PT3

Quiz

•

9th - 12th Grade

37 questions

Excel Gmetrix Quiz

Quiz

•

10th - 12th Grade

36 questions

EarSketch/Python Programming

Quiz

•

9th - 12th Grade

44 questions

Movies

Quiz

•

2nd Grade - Professio...

36 questions

Chapter Nine Elements of art and Design Hierarchy

Quiz

•

9th - 12th Grade

40 questions

year 3 QUIZ 3 2nd term

Quiz

•

3rd Grade - University

40 questions

ANIMATION / Principles of Animation

Quiz

•

6th - 12th Grade

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

20 questions

-AR -ER -IR present tense

Quiz

•

10th - 12th Grade

21 questions

Presidents Day Trivia

Quiz

•

6th - 12th Grade

10 questions

Valentine's Day: History and Modern Celebration

Interactive video

•

9th - 12th Grade

11 questions

Valentine's Day Trivia

Quiz

•

8th - 12th Grade

10 questions

Factor Quadratic Expressions with Various Coefficients

Quiz

•

9th - 12th Grade

10 questions

Evaluating Piecewise Functions Practice

Quiz

•

11th Grade

18 questions

Success Strategies

Quiz

•

9th - 12th Grade

Excel Quiz 2

What would you type in the Criteria box? Use the COUNTIF function to count the number of times that the values in cell rand B6:B15 "exceed 5000".

What would you type in the Range box? Insert a COUNTIF formula to count the data in cell range D43:D51 that is greater than 0.

What does the concatenate function do?

What do you put in the Logical Test Box? Use the IF function to show Close if the SUM of C9:D9 is greater than 22500 and Not Close if it is less than or equal to 22500.

In the formulas tab, what button do you click on to insert an IF formula?

What would you type in the Criteria box? In cell G5 create an AVERAGEIF formula to calculate the average Amount if the Truck Type if General.

What do you type in the Text box? Create a formula in cell C2 of the Trucks worksheet that returns the first three letters of the Truck column.

What does this red mark mean?

What is this called?

What is this button called?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers