In the picture, why is D2 through D5 placed in paranthesis?

So Excel knows to total the cells before performing the next operation.

So the total of the cells can be multiplied rather than added.

Where can you see formulas?

The cell that contains the answer to the formula if you double click on it.

You can name a cell or a cell range by

Selecting the cell(s) to be named, click in the name box, type the name in and press enter

Click on Define Name on the Formulas tab

Select text to be named and click on Create from Selection

=(January!B3) is a reference of

an external reference (a different worksheet)

How do you insert a new row?

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

Select the row heading where you want to insert the new row and select Edit >Row from the menu

Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

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

How can you find specific information in a list?

Click the Find button on the standard toolbar

Select Tools > Finder from the menu

Select Insert > Find from the menu

Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

To copy formatting from one area in a worksheet and apply it to another area you would use:

The Format Painter button on the standard toolbar

The Edit>Copy Format and Edit>Paste Format commands form the menu.

The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.

There is no way to copy and apply formatting in Excel � You have to do it manually

Each Excel file is called a workbook because

It can contain many sheets including worksheets and chart sheets

You have to work hard to create it

You can edit a cell by...

Selecting Edit>Edit Cell from the menu

Excel Review #1

Authored by Whitney Hasenyager

Computers

9th - 12th Grade

Used 9+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

57 questions

Show all answers

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Which of the following is a mixed cell reference with a fixed column address?

G$9

$K356

$F$8

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

A1-J15

A1;J15

A1:J15

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What symbol prepares a cell for the entry of a formula?

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

The 4 arguments used in the VLookUp function are: look up value, _________, column number, range lookup

table array containing data

Price of the item being looked for

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

The LookUp function has 3 arguments. First ___________ then table array and finally, results column

Value to Look Up

Value to Calculate

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

What tab would you find a list of functions and formulas on in Excel?

Home

Insert

Page Layout

Formulas

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Is the information below in the right order for an IF statement?
Cell to look for, True, False

Yes

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

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

Already have an account?

Similar Resources on Wayground

55 questions

basis data

Quiz

•

12th Grade

61 questions

JavaScript - teoria - pytnia egzaminacyjne

Quiz

•

11th Grade

55 questions

K11 - Giữa HK II - CS Cánh diều

Quiz

•

11th Grade

60 questions

UNIT 4 TEST OS, Hardware and Software Systems

Quiz

•

5th - 9th Grade

53 questions

The Internet - AP CSP Unit 4

Quiz

•

9th - 12th Grade

54 questions

eSkill-8

Quiz

•

12th Grade

60 questions

CSEC IT- Past Paper MCQ- 2020

Quiz

•

12th Grade

53 questions

Intro To Networking 123

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

6 questions

Rule of Law

Quiz

•

6th - 12th Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

10 questions

Movie Trivia

Quiz

•

KG - 2nd Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

Discover more resources for Computers

16 questions

Module 1 Topic 2 Vocabulary Test

Quiz

•

9th - 12th Grade

25 questions

Unit 1 Quiz #1

Quiz

•

9th Grade

10 questions

Navigating Digital Citizenship and Online Safety

Interactive video

•

6th - 10th Grade

18 questions

[AP CSP] Python Coding: Conditionals + List + Algo Dev

Quiz

•

9th - 12th Grade

20 questions

Early Computing

Quiz

•

7th - 12th Grade

Excel Review #1

Which of the following is a mixed cell reference with a fixed column address?

The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

What symbol prepares a cell for the entry of a formula?

The 4 arguments used in the VLookUp function are: look up value, _________, column number, range lookup

The LookUp function has 3 arguments. First ___________ then table array and finally, results column

What tab would you find a list of functions and formulas on in Excel?

Is the information below in the right order for an IF statement?
Cell to look for, True, False

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

A graphical representation of data is a

James has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Excel Review #1

Which of the following is a mixed cell reference with a fixed column address?

The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

What symbol prepares a cell for the entry of a formula?

The 4 arguments used in the VLookUp function are: look up value, _________, column number, range lookup

The LookUp function has 3 arguments. First ___________ then table array and finally, results column

What tab would you find a list of functions and formulas on in Excel?

Is the information below in the right order for an IF statement?Cell to look for, True, False

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

A graphical representation of data is a

James has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Is the information below in the right order for an IF statement?
Cell to look for, True, False