Search Header Logo

MS EXCEL

Authored by Anu Prabha

Computers

7th Grade

Used 2+ times

MS EXCEL
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Referencing in =$B3+B$4 formula is

Absolute

Relative

Mixed

Proper

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It spans a cell or a group of cells adjacent to each other on a worksheet.

Reference

Sequence

Range

Collection

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are pre-designed formulas in Excel

Cell reference

Range

Relative reference

Functions

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the given cell reference can be included in relative reference?

$D6

B3

A$3

B$3

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Formulas in Excel must begin with _________________ symbol.

!

@

#

=

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

_______________ are inputs to functions, which accept values as number or text.

Arguments

Parameters

Cell reference

Range

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To arrange data in ascending order of age we will

Filter it

Sort it

Apply Conditional Formatting

Rearrange data manually

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?