Excel 2016 Lesson 4

Excel 2016 Lesson 4

9th - 12th Grade

19 Qs

quiz-placeholder

Similar activities

User Interface Design - Topic 1

User Interface Design - Topic 1

12th Grade

15 Qs

3rd week g9 summative

3rd week g9 summative

7th - 12th Grade

15 Qs

FNaF1

FNaF1

4th - 12th Grade

19 Qs

ICT

ICT

1st Grade - University

20 Qs

Debugging Challenge 2

Debugging Challenge 2

7th - 12th Grade

15 Qs

Getting Started With PowerPoint

Getting Started With PowerPoint

9th Grade

15 Qs

Understanding Compilers and Their Functions

Understanding Compilers and Their Functions

11th Grade

15 Qs

Database&Relation

Database&Relation

12th Grade

20 Qs

Excel 2016 Lesson 4

Excel 2016 Lesson 4

Assessment

Quiz

Computers

9th - 12th Grade

Medium

Created by

Jennie Phipps

Used 17+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

19 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Would the formula (5*3)/4 give the same answer as 5*3/4?

Yes

No

It depends

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A/an ____________ cell reference is one that adjusts the cell identifier automatically if you insert or delete columns or rows or if you copy the formula to another cell.

relative

absolute

neither

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where can you see formulas?

The formula bar

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

Both A and B

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of reference uses dollar signs?

Relative

Absolute

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following would make the best name when naming a range?

adv time

adv?time

adv_time

None of these

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

All of the above

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

=(A1+A2+A3) is an example of a

value

label

formula

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?