Quiz: Excel Mastery Quiz


Excel Mastery QuizOnline version Test your Excel skills. by Shahzoda Rahmonaliyeva 1 What is the default Excel workbook file extension? a .csv b .xlsx c .xlsm d .xls 2 Which function returns today's date? a NOW() b CURRENTDATE() c TODAY() d DATE() 3 Which shortcut inserts AutoSum in a column or row? a Ctrl + S b Ctrl + Z c Alt + = d F2 4 Which function looks up a value in the leftmost column and returns a value from a specified column? a VLOOKUP b LOOKUP c HLOOKUP d INDEX 5 How do you freeze the top row in Excel? a Freeze Panes b Split View c Lock Row d Freeze Top Row 6 Which function calculates the average of numbers? a AVERAGE b MODE c MEDIAN d SUM 7 Which feature splits text into columns based on a delimiter? a Convert Text b Data Merge c Split Cells d Text to Columns 8 Which function concatenates two or more strings? a MID b SUM c LEFT d CONCAT 9 Pivot table is used to? a Summarize and analyze data b Create charts c Sort data only d Filter data only 10 How do you create a chart in Excel? a Home > Chart b Data > Chart c View > Chart d Insert > Chart 11 Excelda qator va ustun qavsini qanday belgilaysan? a A–Z, 1–1000 b A–Z, 1–65536 c A–Z, 1–500000 d A–Z, 1–1048576 12 SUM funktsiyasi nima uchun ishlatiladi? a Raqamlarni bo‘lish b Raqamlarni ko‘paytirish c Raqamlari yig‘indisini hisoblash d Matnni o‘zgartirish 13 A1 katakidan B2 katakigacha bo‘lgan qatorni qanday tanlaysiz? a Alt + Enter b Shift tugmasini bosib chapdan o‘ngga tortish c Ctrl + C d Tab tugmasini bosib uzaytirish 14 AVERAGE funktsiyasi nimani beradi? a Raqamlarni tartiblashni b Skladeniy o‘rtacha qiymatni c Eng katta qiymatni d Eng kichik qiymatni 15 Chizma (chart) qo‘shish uchun qaysi menyudan foydalanasiz? a Data – Sort b Insert (Janech) – Chart c Formulas – Financial d Review – Protect 16 Pivottablica nima uchun ishlatiladi? a Skrepni o‘chirish b Formulalarni yoqish c Ma’lumotlarni qisqa va tahlil ko‘rinishida guruhlash d Ma’lumotlarni o‘chirish 17 CONCATENATE funksiyasi nima qiladi? a Raqamlarni sanab chiqadi b Ikki yoki undan ko‘p matn qatorini birlashtiradi c Formulani himoyalaydi d Matnni o‘chirish 18 Ctrl + ` (apostrof) nima uchun ishlatiladi? (Excelda) a Formulani yashiradi b Formulalarni ko‘rsatadi c Ma’lumotlarni saqlaydi d Yangi varaq yaratadi 19 Absolute reference (mustahkam manzil) qanday yoziladi? a $A1 b A$1 c A1 d $A$1 20 Conditional formatting nima uchun ishlatiladi? a Raqamlarni o‘zgartiradi b Shartga mos kelgan kataklarni belgilab ko‘rsatadi c Ma’lumotlarni eksport qiladi d Sarlavhani yaratadi 21 Conditional formatting nima uchun ishlatiladi? a Raqamlarni o‘zgartiradi b Shartga mos kelgan kataklarni belgilab ko‘rsatadi c Ma’lumotlarni eksport qiladi d Sarlavhani yaratadi

1

What is the default Excel workbook file extension?

a

.csv

b

.xlsx

c

.xlsm

d

.xls

2

Which function returns today's date?

a

NOW()

b

CURRENTDATE()

c

TODAY()

d

DATE()

3

Which shortcut inserts AutoSum in a column or row?

a

Ctrl + S

b

Ctrl + Z

c

Alt + =

d

F2

4

Which function looks up a value in the leftmost column and returns a value from a specified column?

a

VLOOKUP

b

LOOKUP

c

HLOOKUP

d

INDEX

5

How do you freeze the top row in Excel?

a

Freeze Panes

b

Split View

c

Lock Row

d

Freeze Top Row

6

Which function calculates the average of numbers?

a

AVERAGE

b

MODE

c

MEDIAN

d

SUM

7

Which feature splits text into columns based on a delimiter?

a

Convert Text

b

Data Merge

c

Split Cells

d

Text to Columns

8

Which function concatenates two or more strings?

a

MID

b

SUM

c

LEFT

d

CONCAT

9

Pivot table is used to?

a

Summarize and analyze data

b

Create charts

c

Sort data only

d

Filter data only

10

How do you create a chart in Excel?

a

Home > Chart

b

Data > Chart

c

View > Chart

d

Insert > Chart

11

Excelda qator va ustun qavsini qanday belgilaysan?

a

A–Z, 1–1000

b

A–Z, 1–65536

c

A–Z, 1–500000

d

A–Z, 1–1048576

12

SUM funktsiyasi nima uchun ishlatiladi?

a

Raqamlarni bo‘lish

b

Raqamlarni ko‘paytirish

c

Raqamlari yig‘indisini hisoblash

d

Matnni o‘zgartirish

13

A1 katakidan B2 katakigacha bo‘lgan qatorni qanday tanlaysiz?

a

Alt + Enter

b

Shift tugmasini bosib chapdan o‘ngga tortish

c

Ctrl + C

d

Tab tugmasini bosib uzaytirish

14

AVERAGE funktsiyasi nimani beradi?

a

Raqamlarni tartiblashni

b

Skladeniy o‘rtacha qiymatni

c

Eng katta qiymatni

d

Eng kichik qiymatni

15

Chizma (chart) qo‘shish uchun qaysi menyudan foydalanasiz?

a

Data – Sort

b

Insert (Janech) – Chart

c

Formulas – Financial

d

Review – Protect

16

Pivottablica nima uchun ishlatiladi?

a

Skrepni o‘chirish

b

Formulalarni yoqish

c

Ma’lumotlarni qisqa va tahlil ko‘rinishida guruhlash

d

Ma’lumotlarni o‘chirish

17

CONCATENATE funksiyasi nima qiladi?

a

Raqamlarni sanab chiqadi

b

Ikki yoki undan ko‘p matn qatorini birlashtiradi

c

Formulani himoyalaydi

d

Matnni o‘chirish

18

Ctrl + ` (apostrof) nima uchun ishlatiladi? (Excelda)

a

Formulani yashiradi

b

Formulalarni ko‘rsatadi

c

Ma’lumotlarni saqlaydi

d

Yangi varaq yaratadi

19

Absolute reference (mustahkam manzil) qanday yoziladi?

a

$A1

b

A$1

c

A1

d

$A$1

20

Conditional formatting nima uchun ishlatiladi?

a

Raqamlarni o‘zgartiradi

b

Shartga mos kelgan kataklarni belgilab ko‘rsatadi

c

Ma’lumotlarni eksport qiladi

d

Sarlavhani yaratadi

21

Conditional formatting nima uchun ishlatiladi?

a

Raqamlarni o‘zgartiradi

b

Shartga mos kelgan kataklarni belgilab ko‘rsatadi

c

Ma’lumotlarni eksport qiladi

d

Sarlavhani yaratadi

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Excel Mastery Quiz

Quiz

About this activity

Created by

Download the paper version to play

Top Games

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

Spanish Alphabet Listening

Quiz

Tissues - Practice Quiz

Quiz

UPS 5 Seeing Habits Quiz

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Excel Mastery QuizOnline version

by Shahzoda Rahmonaliyeva

What is the default Excel workbook file extension?

Which function returns today's date?

Which shortcut inserts AutoSum in a column or row?

Which function looks up a value in the leftmost column and returns a value from a specified column?

How do you freeze the top row in Excel?

Which function calculates the average of numbers?

Which feature splits text into columns based on a delimiter?

Which function concatenates two or more strings?

Pivot table is used to?

How do you create a chart in Excel?

Excelda qator va ustun qavsini qanday belgilaysan?

SUM funktsiyasi nima uchun ishlatiladi?

A1 katakidan B2 katakigacha bo‘lgan qatorni qanday tanlaysiz?

AVERAGE funktsiyasi nimani beradi?

Chizma (chart) qo‘shish uchun qaysi menyudan foydalanasiz?

Pivottablica nima uchun ishlatiladi?

CONCATENATE funksiyasi nima qiladi?

Ctrl + ` (apostrof) nima uchun ishlatiladi? (Excelda)

Absolute reference (mustahkam manzil) qanday yoziladi?

Conditional formatting nima uchun ishlatiladi?

Conditional formatting nima uchun ishlatiladi?

		%
	Anonymous	%
		%
		%