Hamad International - Doha -Pre -MS Excel - Basic Intermediate

Hamad International - Doha -Pre -MS Excel - Basic Intermediate

Professional Development

20 Qs

quiz-placeholder

Similar activities

Evaluacion de resultados - 1er ciclo

Evaluacion de resultados - 1er ciclo

Professional Development

20 Qs

Outing Quiz

Outing Quiz

Professional Development

15 Qs

Think it through

Think it through

University - Professional Development

16 Qs

EXCEL 2016

EXCEL 2016

1st Grade - Professional Development

15 Qs

Java Fundamentals

Java Fundamentals

Professional Development

20 Qs

Installing and Configuring Computer Systems 2

Installing and Configuring Computer Systems 2

Professional Development

20 Qs

CÂU LỆNH WHILE

CÂU LỆNH WHILE

Professional Development

21 Qs

SMR-RL-UT8-VLAN (nivel I)

SMR-RL-UT8-VLAN (nivel I)

Professional Development

16 Qs

Hamad International - Doha -Pre -MS Excel - Basic Intermediate

Hamad International - Doha -Pre -MS Excel - Basic Intermediate

Assessment

Quiz

Computers

Professional Development

Practice Problem

Hard

Created by

Shakeel Ahmed

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1.     Ctrl + D shortcut key in Excel will

Open the font dialog box

Apply double underline for the active cell

Fill down in the selection  

None

Not Aware

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

One of these references will keep the column constant but changes the row while copying the formulas

A1

$A$1

$A1

All of these

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can display formulas on Entire Worksheet by pressing

Ctrl + F2

Ctrl + ` (Back Quote)

F2

We cannot display formulas of Entire Worksheet

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Keyboard shortcut to insert Row or Column in Excel Sheet

Ctrl + Shift + Plus(+)

Ctrl + I

Ctrl + N

Ctrl + Minus (-)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

COUNTIF function of excel can count the number of cells that meet 1 or multiple criteria’s

True

False

Don't Know

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In COUNTIFS function while writing the condition to count values which are more than 5000, following syntax has to be followed.

>5000

“>5000"

“Greater than 5000”

5000

Not Used COUNTIFS

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The Function =ROUNDUP(5671.389,-1) returns

5671

5675

5680

5672

Never Used This Function

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?