Froggy Jumps: Excel Mastery Quiz


Froggy Jumps Excel Mastery QuizVersion en ligne Test your knowledge of Microsoft Excel with this fun quiz game! par Wulan Purnama sari 1 What is the default file extension for Excel workbooks? a .docx b .xls c .xlsx 2 Which function is used to sum a range of cells in Excel? a TOTAL b SUM c ADD 3 What feature allows you to analyze data visually in Excel? a Forms b Charts c Tables 4 What does the VLOOKUP function do? a Looks up a value in a table b Counts cells c Calculates average 5 Which shortcut opens the 'Format Cells' dialog in Excel? a Ctrl + F b Alt + F1 c Ctrl + 1 6 What is the maximum number of rows in an Excel worksheet? a 65,536 b 1,048,576 c 2,048,576 7 Which function would you use to find the average of a range? a AVG b MEAN c AVERAGE 8 What does the CONCATENATE function do in Excel? a Calculates length b Joins text strings together c Splits text strings 9 What is the purpose of the 'Freeze Panes' feature? a Keep rows/columns visible while scrolling b Sort data c Hide rows/columns 10 Which of the following is NOT a data type in Excel? a Text b Number c Image 11 What function is used to sum a range of cells in Excel? a SUM b COUNT c AVERAGE 12 Which shortcut opens the 'Format Cells' dialog in Excel? a Alt + F b Ctrl + F c Ctrl + 1 13 What does the VLOOKUP function do? a Finds the average of a range b Counts the number of cells c Looks up a value in a table 14 In Excel, what symbol is used to start a formula? a $ b = c # 15 What is the maximum number of rows in Excel 2019? a 2,048,576 b 1,048,576 c 65,536 16 Which function would you use to find the average of a set of numbers? a AVERAGE b MAX c SUM 17 What is the purpose of the CONCATENATE function? a Join two or more text strings b Split text into cells c Count characters in a string 18 What feature allows you to analyze data visually in Excel? a Comments b Tables c Charts 19 Which Excel feature helps to manage large datasets? a Hyperlinks b Filters c Comments 20 What does the IF function do in Excel? a Calculates the sum b Creates a chart c Performs a logical test

1

What is the default file extension for Excel workbooks?

a

.docx

b

.xls

c

.xlsx

2

Which function is used to sum a range of cells in Excel?

a

TOTAL

b

SUM

c

ADD

3

What feature allows you to analyze data visually in Excel?

a

Forms

b

Charts

c

Tables

4

What does the VLOOKUP function do?

a

Looks up a value in a table

b

Counts cells

c

Calculates average

5

Which shortcut opens the 'Format Cells' dialog in Excel?

a

Ctrl + F

b

Alt + F1

c

Ctrl + 1

6

What is the maximum number of rows in an Excel worksheet?

a

65,536

b

1,048,576

c

2,048,576

7

Which function would you use to find the average of a range?

a

AVG

b

MEAN

c

AVERAGE

8

What does the CONCATENATE function do in Excel?

a

Calculates length

b

Joins text strings together

c

Splits text strings

9

What is the purpose of the 'Freeze Panes' feature?

a

Keep rows/columns visible while scrolling

b

Sort data

c

Hide rows/columns

10

Which of the following is NOT a data type in Excel?

a

Text

b

Number

c

Image

11

What function is used to sum a range of cells in Excel?

a

SUM

b

COUNT

c

AVERAGE

12

Which shortcut opens the 'Format Cells' dialog in Excel?

a

Alt + F

b

Ctrl + F

c

Ctrl + 1

13

What does the VLOOKUP function do?

a

Finds the average of a range

b

Counts the number of cells

c

Looks up a value in a table

14

In Excel, what symbol is used to start a formula?

a

$

b

=

c

#

15

What is the maximum number of rows in Excel 2019?

a

2,048,576

b

1,048,576

c

65,536

16

Which function would you use to find the average of a set of numbers?

a

AVERAGE

b

MAX

c

SUM

17

What is the purpose of the CONCATENATE function?

a

Join two or more text strings

b

Split text into cells

c

Count characters in a string

18

What feature allows you to analyze data visually in Excel?

a

Comments

b

Tables

c

Charts

19

Which Excel feature helps to manage large datasets?

a

Hyperlinks

b

Filters

c

Comments

20

What does the IF function do in Excel?

a

Calculates the sum

b

Creates a chart

c

Performs a logical test

Excel Mastery Quiz

Froggy Jumps

Téléchargez la version pour jouer sur papier

Créé par

Top 10 résultats

Top Jeux

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

The Integumentary System

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

pizza