To create a formula, you first:

Select the cell you want to place the formula into

Type the equals sign (=) to tell Excel that you're about to enter a formula

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

Choose the new command from the file menu

How do you select an entire column?

Click the column heading letter

Select Edit > Select > Column from the menu

Hold down the shift key as you click anywhere in the column.

Hold down the Ctrl key as you click anywhere in the column

A "page" within an Excel workbook that contains columns rows and cells

What is the function of the mouse pointer in the image?

It allows you to widen the column

It allows you to select more than one cell

It allows you to move the contents of a cell

1) Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:

d) The cell reference for the selected cells is B15:F15

a) The cell reference for the selected cells is B:21, C:28, D:22, E:26 and F:25.

b) The cell reference for the selected cells is row 15, column F

c) The cell reference for the selected cells is F4:F5

4) Study the orange circled area of the worksheet in the image below. Which of the following best describes the function of this area?

a) The Name Box displays a name given to a cell or set of cells.

b) The Name Box reflects the contents of the first cell that is selected in a range.

c) The Name Box gives you options for duplicating the selected cells.

d) All of the above options are correct.

5) The Formula Bar is the block located above the grid in a worksheet and preceded by the letters fx. Which of the following comments about the Formula Bar is NOT correct:

a) The Formula Bar is only used to create formulas by pressing the fx located to the left of the box.

b) The Formula Bar contains the contents of the cell you have selected.

c) You can type numbers or text directly into the formula bar.

d) You can edit words or numbers contained in selected cells in the Formula Bar.

7) Study the image below this question. What is the purpose of the two words circled in orange?

c) These represent worksheets that have been created in the workbook. If you click on them they will take you to the different sheets.

a) These represent the names of the individual workbooks you have saved. If you click on the "Sales 2" tab it will open this workbook.

b) These reflect a selected range of cells in the worksheet. If you click on "Sales 2" it will take you to the selected cell.

d) This is the Name Box and represents named ranges in the worksheet. If you click on "Sales 2", you can rename the range.

What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

Copy using the Quick Access Toolbar

How is a cell reference in a formula and its corresponding location in a worksheet identified?

Cell reference and cell location are outlined in matching colors

Arrows pointing from the formula to the location

Cell reference and cell location are circled

Lines connect from the formula to the location

Excel Review 1

Authored by Rodney Tracy

Business

9th Grade

Used 24+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To create darkened, bold grid lines around your cells, what must you select?

All Borders

All Grids

Outer Borders

Bold Grids

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Microsoft Excel is what kind of software?

Word Processing Software

Spreadsheet Software

Database Software

Presentation Software

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The set of data that runs up and down in a spreadsheet

column

row

cell

active cell

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The set of data that runs left to right in a spreadsheet

column

row

cell

active cell

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The numbers in Excel represent the...

Rows

Columns

Cells

Data

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The letters in Excel represent the...

Rows

Columns

Cells

Data

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Excel refers to files as...

Presentations

Databases

Workbooks

Documents

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

45 questions

Enterprise and Marketing - Learning Outcome 2: Understand what makes a product or service financially viable

Quiz

•

9th - 11th Grade

50 questions

Business Management I Standard 3.00 Review (v.2019)

Quiz

•

9th - 12th Grade

46 questions

Stocks and Bonds (B12&13)

Quiz

•

KG - 12th Grade

50 questions

Business Management I Mid Term Review (v.2019)

Quiz

•

9th - 12th Grade

50 questions

RRHS DECA Finance Cluster Exam

Quiz

•

9th - 12th Grade

50 questions

Navigate Career Planning and Paying for College

Quiz

•

9th - 12th Grade

45 questions

BIM I - Quiz 1 Review

Quiz

•

9th - 12th Grade

53 questions

PAT BAHASA INGGRIS XI T.A.2023

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

10 questions

HCS SCI 03 Summer School Assessment 1

Quiz

•

3rd Grade

15 questions

HCS SCI 05 Summer School Assessment 1 Review

Quiz

•

5th Grade

22 questions

Day 9 Equations and Inequalities Review

Quiz

•

9th Grade

10 questions

Writing and Identifying Ratios Practice

Quiz

•

5th - 6th Grade

7 questions

PYRAMID PERSPECTIVES part 1

Presentation

•

9th - 12th Grade

12 questions

Understanding the Fourth of July

Quiz

•

9th Grade

15 questions

Soccer World Cup Quiz Questions

Quiz

•

7th Grade

Discover more resources for Business

22 questions

Day 9 Equations and Inequalities Review

Quiz

•

9th Grade

7 questions

PYRAMID PERSPECTIVES part 1

Presentation

•

9th - 12th Grade

12 questions

Understanding the Fourth of July

Quiz

•

9th Grade

Excel Review 1

To create darkened, bold grid lines around your cells, what must you select?

Microsoft Excel is what kind of software?

The set of data that runs up and down in a spreadsheet

The set of data that runs left to right in a spreadsheet

The numbers in Excel represent the...

The letters in Excel represent the...

Excel refers to files as...

The intersection of a row and column.

What is the cell in the worksheet in which you can type data?

_____ are vertical.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business