MS  Excel

MS Excel

University

63 Qs

quiz-placeholder

Similar activities

Numpy

Numpy

University

66 Qs

IT101-1_FINALS_MULTIPLECHOICE

IT101-1_FINALS_MULTIPLECHOICE

University

62 Qs

NETWORKING

NETWORKING

University

61 Qs

Final Exam in Data Structures and Algorithm

Final Exam in Data Structures and Algorithm

University

65 Qs

Information storage

Information storage

University

65 Qs

FDBS - Final Examination

FDBS - Final Examination

University

60 Qs

สอบปลายภาค เทคโนโลยีโรงแรม

สอบปลายภาค เทคโนโลยีโรงแรม

University

60 Qs

IAS2 QUIZ CH 4-6

IAS2 QUIZ CH 4-6

University

60 Qs

MS  Excel

MS Excel

Assessment

Quiz

Information Technology (IT)

University

Practice Problem

Medium

Created by

Lee Tamparega

Used 28+ times

FREE Resource

AI

Enhance your content in a minute

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

63 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following is NOT a type of cell reference in Excel?

Relative Reference
Absolute Reference
Fixed Reference
Mixed Reference

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What happens when you copy a formula with a relative reference?

The reference remains unchanged
The reference adjusts based on its new location
It converts to an absolute reference
It removes all references

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What symbol is used to indicate an absolute reference in Excel?

#
$
@
&

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

If a formula in A1 is =B1+C1 and is copied to D1, what will the new formula be?

="=B1+C1"
="=D1+E1"
="=B2+C2"
="=E1+F1"

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

A mixed reference means:

Both row and column are absolute
One is absolute, the other is relative
Both row and column are relative
The reference is invalid

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

If you enter =$A$1+B1 and copy it down, how does it change?

It remains =$A$1+B1
It changes to =$A$1+B2
It changes to =$A$2+B2
It remains unchanged for all cells

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

How do you quickly toggle through reference types (absolute, relative, mixed)?

Press F4
Press Ctrl + A
Press Alt + R
Right-click the formula

Create a free account and access millions of resources

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?