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 18+ 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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Microsoft Office Semester Review

Quiz

•

9th - 12th Grade

45 questions

Business of Retail Practice Test 2

Quiz

•

9th - 12th Grade

50 questions

Manajemen Stategi

Quiz

•

1st - 12th Grade

50 questions

BT Logos

Quiz

•

9th Grade

48 questions

EOPA Marketing Quiz Fall 2023

Quiz

•

9th - 12th Grade

50 questions

Fast food

Quiz

•

9th - 12th Grade

50 questions

Retail Merchandising

Quiz

•

9th - 12th Grade

50 questions

Career Prep Semester Exam 2024

Quiz

•

9th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Business

25 questions

Job Interview Skills

Quiz

•

9th - 12th Grade

20 questions

Mastering Job Interview Skills

Quiz

•

9th Grade

19 questions

Types of Currency

Lesson

•

9th Grade

13 questions

BizInnovator Startup - Experience and Overview

Quiz

•

9th - 12th 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