Excel Mastery Quiz

Test

Parties jouées 0

Créer une copie

À propos de cette activité

Test your Excel skills.

Créé par

Shahzoda Rahmonaliyeva

Uzbekistan

Téléchargez la version pour jouer sur papier

Top 10 résultats

Il n'y a toujours pas de résultats pour ce jeu. Soyez le premier à apparaître dans le classement! Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

Excel Mastery Quiz


Excel Mastery QuizVersion en ligne Test your Excel skills. par 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

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

Excel Mastery Quiz

Test

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Test

Spanish Alphabet Listening

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Test

Tissues - Practice Quiz

Test

UPS 5 Seeing Habits Quiz

Excel Mastery QuizVersion en ligne

par 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?