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

9th Grade

•

50 Qs

Similar activities

Sheltered Personal Finance-Semester Review

9th - 12th Grade

•

52 Qs

Spring 2025 Professional Communication Final Exam Review

8th Grade - University

•

45 Qs

UNIT 6 Practice Test

9th - 12th Grade

•

46 Qs

IGCSE BUSINESS ACTIVITY

8th - 12th Grade

•

45 Qs

Micro Enterprise 50 Questions

9th - 12th Grade

•

50 Qs

Chapter 4: Social Responsibility of Business and Government

9th - 12th Grade

•

45 Qs

Career Clusters

9th - 12th Grade

•

50 Qs

SEM I Unit 1 Review

9th - 12th Grade

•

51 Qs

Excel Review 1

Quiz

•

Business

•

9th Grade

•

Practice Problem

•

Easy

Rodney Tracy

Used 18+ times

FREE Resource

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

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

50 questions

SkillsUSA Professional Development Test

Quiz

•

9th - 12th Grade

50 questions

Business Concepts Quiz

Quiz

•

9th - 12th Grade

50 questions

MARKETING MIX

Quiz

•

9th - 12th Grade

46 questions

Concepts of Leadership (1) vh

Quiz

•

9th Grade

55 questions

Math Review 2nd Grade

Quiz

•

2nd Grade - University

50 questions

Business Essentials Unit 4-Test

Quiz

•

9th - 12th Grade

50 questions

Unit 1.5 Understanding External Influences

Quiz

•

9th Grade

50 questions

Business Information Management I - Semester 2 Exam

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for Business

5 questions

Banking Basics

Lesson

•

6th - 12th Grade

19 questions

Personal Finance: Credit Reports and Scores

Quiz

•

9th - 12th Grade

17 questions

BizInnovator Startup - Know Your Customer

Quiz

•

9th - 12th Grade

Excel Review 1

50 questions

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.

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business