Excel Basics 8-12 GCF Introductions

Tutorial 8 Basic Excel

Number Format Basics
https://edu.gcfglobal.org/en/excel/understanding-number-formats/1/

Use the drop-down box found on the Home ribbon in the Number group
(see image for the drop-down choices)

Match

Match the following image to the format applied.

• $ 700.00

• $700.00

• Monday, February 3, 2014

• 79%

Accounting

Currency

Long Date

Percentage

Short Date

• Accounting

• Currency

• Long Date

• Percentage

• Short Date

Multiple Choice

Which dialog box and tab will open if you choose "More Number Formats" from the drop-down list on the Home ribbon?

• Alignment Box; Number Tab

• Format Cells; Number Tab

• Format Cells; Font Tab

• Alignment Box; Font Tab

Multiple Choice

If you have a column of numbers EX 5, 73, 12, 5.5, 12 and select them to format as percentage, what will happen?

• They will have 2 extra zeros 00 added to each number

• They will have a decimal

• They will look like the expected percent

• They will format to dte

Multiple Choice

How do you fix the mistake of extra zeros when you change a number to a percent?

• retype number

• reformat to no decimal

• change to currency

• delete the zeros

Multiple Choice

Let's say you want the number 4950-22 to be a label and not be used in calculations, what format is required for this?

• General

• Decemial

• Align

• Text

Match

Match the following image to its use.

Decrease Decimal places

Increase Decimal places

Decrease indent

Increase Indent

Merge Cells

• Decrease Decimal places

• Increase Decimal places

• Decrease indent

• Increase Indent

• Merge Cells

Tutorial 9 - Multiple Worksheets

Inserting,
Copying,
Moving, Renaming,
Tab Color

Multiple Choice

How to you get the shortcut menu that allows you to rename, move, copy and do other things to a worksheet's tab?

• Right Click Tab

• Double Click Tab

• Home Ribbon, Format Group

• 
  Double click any cell

Reorder

Reorder the following to move a worksheet between July and Expenses Summary

• Right Click Tab

• Choose Move or Copy

• Ensure the book is correct

• Click the sheet below desired location

• Click OK

1

2

3

4

5

• 1
• 2
• 3
• 4
• 5

Drag and Drop

When a worksheet is copied it​

Placeholder

its original name and version number along with the content.

Drag these tiles and drop them in the correct blank above

will not have

might have

will have

Hotspot

Where would you look for colors like:

dark red, yellow, orange

Hotspot

Where would you look for colors like:

Black, text 1, lighter 5% or Blue, Accent 4, lighter 40%

Hotspot

Where would you look for colors like:

Blue, Accent 2 or White, Background 1

Lesson 10 Find & Replace

CTRL+F Find, also gets you to the Replace

This lesson covers how to:
Find words, within sheets, workbook, search by rows, look in formulas and other special characters

Multiple Choice

How can you look for advanced search features in the find and replace dialog box?

• Go to the Home Ribbon

• Click Options

• Click Advanced

• You cannot do this

Reorder

What is the steps to change all occurrences of Accounting to Finance?

• Home Ribbon

• Find and Replace drop-down

• Replace Tab

• Type: Accounting and Finance in correct fields

• Click Replace All

1

2

3

4

5

• 1
• 2
• 3
• 4
• 5

Lesson 11 - Check Spelling

Review Ribbon, Proofing Group

You can add a button to the QAT.

Multiple Choice

What should you do before you share a worksheet or workbook?

• Thesaurus

• Spell Check

• Merge

• Make a Copy

Multiple Choice

Which option do you select when checking your spelling if you want to skip a word without changing it and also skip all occurrences of it.

• Ignore All

• Ignore Once

• Skip

• Add

Tutorial 12 - Layout and Printing

Heavily Tested Area!

The page layout ribbon and print settings back stage are 2 places the certification test likes to check for understanding.

Multiple Choice

Which ribbon will help you customize how you print a workbook or worksheet?

• Review

• Home

• File

• Page Layout

Multiple Choice

Where can you find the printing pane in Excel?

• Backstage

• Page Layout

• Home

• In Folders

Hotspot

Which red hot spot to the correct red hot spot allows you to choose to print the active sheets, the entire workbook, or a selection?

Hotspot

Which red hot will allow you to choose from multiple printers?

Hotspot

Which red hot will allow you to make the print landscape or portrait?

Multiple Choice

How do you set the print to only include part of a worksheet?

• Page Layout, Print Area, Set Print Area

• Review, Set Print Area, Set Print Areas

• Page Layout, Print Selection, Set Print Area

• Page Layout

This slide's images will answer the rest of the questions.

Multiple Choice

How do you set the gridlines to print?

• Page Layout Ribbon, Scale to Fit group

• Page Layout Ribbon, Page Setup group

• Page Layout Ribbon, Sheet Options

• Page Layout Ribbon. Themes

Multiple Choice

How do you choose "slipstream" colors?

• Page Layout Ribbon, Scale to Fit group

• Page Layout Ribbon, Page Setup group

• Page Layout Ribbon, Sheet Options

• Page Layout Ribbon. Themes

Multiple Choice

How do you make headings print?

• Page Layout Ribbon, Scale to Fit group

• Page Layout Ribbon, Page Setup group

• Page Layout Ribbon, Sheet Options

• Page Layout Ribbon. Themes

Multiple Choice

How do you make change the paper size?

• Page Layout Ribbon, Scale to Fit group

• Page Layout Ribbon, Page Setup group

• Page Layout Ribbon, Sheet Options

• Page Layout Ribbon. Themes