TAG MSO Excel

Excel Basics

1

Normal view, Page Layout view, or Page Break view.

What are Worksheet Views?

2

This appears when you click the FILE menu

What is the Backstage (view)?

3

Do this if you frequently use the same workbook

What is Pin It?

4

A predesigned spreadsheet you can use to create a new workbook quickly.

What is a Template?

5

You do this to save a different version of a workbook while keeping the original.

What is Save As?

Working with Cells and Sheets

1

These are are the basic building blocks of a worksheet. 

What are Cells?

2

This symbol separates a cell range.

What is a colon (:)?

3

These tell your spreadsheet exactly what type of data you're using, like percentages (%), currency ($), times, and dates.

What are Number Formats?

4

When you want to edit multiple worksheets at the same time, you do this.

What is Group them?

5

You double click between columns to do this.

What is AutoFit the column width?

Formulas and Functions

1

Every formula starts with this.

What is an equals (=) sign?

2

**D4 is an example of this.**

What is a Relative Cell Reference?

3

$D$3 is an example of this.

What is an absolute reference?

4

This function ets you search for specific information in your spreadsheet and return a value.

What is VLOOKUP?

5

The correct formatting of this formula: 

=VLOOKUP(TAG, A2:A20, 2, FALSE)

What is 

=VLOOKUP("TAG",A2:A20,2,FALSE)

Will also accept Missing Quotation marks around TAG/First Argument

Working with Data

1

To stop your header row from scrolling with the rest of your data, you do this.

What is Freeze Panes?

2

When you want to organize your data in a specific way, you use this tool.

What is Sort or Sorting?

3

This tool is used to narrow down your data.

What is Filter?

4

You use this command to remove table formatting.

What is Convert to Range?

5

This allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value.

What is Conditional Formatting?

Grab Bag

1

This is the intersection of a row and a column.

What is a Cell?

2

This feature starts with a desired result, then calculates the input value that will give that result?.

What is Goal Seek?

3

This formula will calculate cells A1 through A5.

What is =SUM(A1:A5)

4

This chart type is best for viewing values across categories.

What is a Column Chart?

5

This is indicated by a red box in the lower right corner of a cell.

What is a note?