Excel Questions

Excel Questions

University

16 Qs

quiz-placeholder

Similar activities

EC8071_CR_MODELEXAM-IV (08.12.2020)_PART-B

EC8071_CR_MODELEXAM-IV (08.12.2020)_PART-B

University

15 Qs

General Safety Talk 5 Juli 2023

General Safety Talk 5 Juli 2023

University

15 Qs

sesame street best of friends

sesame street best of friends

KG - Professional Development

12 Qs

Guess the Character from the Lego Figure

Guess the Character from the Lego Figure

1st Grade - Professional Development

20 Qs

PPPK TAHAP 2 TEKNIS

PPPK TAHAP 2 TEKNIS

University

20 Qs

Pendidikan Bahasa Indonesia

Pendidikan Bahasa Indonesia

University

20 Qs

출석 확인 퀴즈

출석 확인 퀴즈

12th Grade - University

11 Qs

EXLP

EXLP

University

16 Qs

Excel Questions

Excel Questions

Assessment

Quiz

Other

University

Practice Problem

Hard

Created by

KURALAMUDHAN J

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

16 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Does Excel supports pdf files

YES

NO

Yes, but opens on an different format

I don't Know

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

How do you freeze panes in Excel (top row)

View >Freeze Top row

View > Freeze Panes > Freeze Top row

Data > Freeze Panes > Freeze Top row

View > Arrange > Freeze Panes > Freeze Top row

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What does delimiter do?

Split the Values

Merge two cells

Wrong term

Acts as a boundary

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Mention the order of operations used in Excel while evaluating formulas.

  • Parentheses

  • Exponentiation

  • Division/Multiplication 

  • Addition

  • Subtraction

  • Parentheses

    Division/Multiplication 

  • Exponentiation

  • Addition

  • Subtraction

Division/Multiplication

Addition

Subraction

Parentheses

Addition

Subraction

Division/Multiplication

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image

How will you bring out the resultant 77.5 by the following formula for the following? - Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2.

((A1*10)+5)\2

((A1*10)+5/2)

(((A1)+5)*10)/2

((A1*10)+5)/2

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What is the difference between count, counta, and countblank?

Count only numbers,

Count the blank spaces

Count only numbers,

Count all forms of input,

Count the blank spaces

Count all forms of input,

Count only numbers,

Count the blank spaces

None of the above

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

How to create dropdown?

View > Data Validation > List > Source

Data > Data Validation > Number > Source

Data > Data Validation > List > Source

Insert > Data Validation > List > Source

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?