Microsoft Excels: Formulas and Functions

Microsoft Excels: Formulas and Functions

12th Grade - University

45 Qs

quiz-placeholder

Similar activities

Simulasi Digital

Simulasi Digital

12th Grade - Professional Development

40 Qs

Excel

Excel

9th - 12th Grade

48 Qs

SOAL TIK KELAS 8

SOAL TIK KELAS 8

8th Grade - University

40 Qs

ICT 201-250

ICT 201-250

University

50 Qs

Aplikasi Pengolah Angka (Spreadsheet)

Aplikasi Pengolah Angka (Spreadsheet)

9th - 12th Grade

50 Qs

Power Point – Wiputra Cendana

Power Point – Wiputra Cendana

University

46 Qs

Quiz Excel

Quiz Excel

3rd - 12th Grade

40 Qs

Neuro Foundation Final Assessment Quiz

Neuro Foundation Final Assessment Quiz

University

50 Qs

Microsoft Excels: Formulas and Functions

Microsoft Excels: Formulas and Functions

Assessment

Quiz

English, Computers

12th Grade - University

Hard

Created by

Mochammad Rizky

Used 20+ times

FREE Resource

45 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

The command used for reading the table for a particular row is?

IF

VLOOKUP

HLOOKUP

SUM

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

If we write the formula = 8 + 5 * 3 in Ms Excel, the result is?...

39

29

23

43

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

The portion of Microsoft Excel that is used as the screen scroll button is..

Ribbon

Tab Menu

Scroll

Formula Bar

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Ordering data in Ms. Excel from small to large is called...

Ascending

Descending

Fescending

Sescending

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

The command used to set the column width is ...

Row height

Column width

Insert row

Insert column

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

The document file management button on the Office Excel Microsof is round in shape with the Office logo in the middle called.… office button

Excel Options

Office Button

Ribbon

Tittle Bar

Toolbar

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

To change the unit of measure in Excel, use the command….

Start–Setting–Control Panel–Regional–Currency

Tools–Options–Print

Office Button–Open

Office Button–Excel Options–Save–Default File Location

Office Button–Excel Options–Advanced–Display–Ruler Units

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?