Basic_Excel -

Embark on your path to becoming a data analytics professional. Complete our assessment to evaluate your competencies and gain valuable insights into areas for improvement and opportunities for excellence.

Embark on Your Exclusive Quiz Experience: Share Your Details

1 / 20

What is the file extension of an Excel workbook?

.docx

.xlsx

.pptx

.txt

2 / 20

Which shortcut is used to save a workbook?

Ctrl+P

Ctrl+S

Ctrl+C

Ctrl+PV

3 / 20

Which function returns the current date in Excel?

DATE()

NOW()

TIME()

TODAY()

4 / 20

Which function is used to count numeric values only?

COUNTIF

COUNTA

COUNT

COUNTBLANK

5 / 20

Which function is used to combine text from multiple cells?

CONCATENATE()

JOIN()

TEXTJOIN()

Both A and C

6 / 20

What does the AutoSum button do?

Finds the maximum value

Adds a set of numbers

Counts the number of values

Deletes all values

7 / 20

What is the intersection of a row and a column called?

Cell

Field

Box

Data Point

8 / 20

What does the LARGE function do in Excel?

Returns the largest value in a range

Returns the k-th largest value in a range

Returns the average of the largest values

Returns the maximum text length

9 / 20

Which of the following is used to AutoFit the column width in Excel?

Double-click the column letter

Right-click and select "AutoFit"

Double-click the boundary between two column headers

Press Ctrl + A

10 / 20

What does "###" in a cell usually mean?

The formula is wrong

The column is too narrow

The data is missing

It is a text value

11 / 20

Which function checks whether a condition is true or false?

SUMIF()

IFS()

F()

TRUE()

12 / 20

What is the shortcut key to manually increase the row height in Excel?

Alt + H + O + R

Alt + H + O + H

Alt + H + O + A

Alt + H + I + R

13 / 20

The shortcut to create a chart from selected data is:

Alt + F1

Ctrl + Shift + C

F11

Ctrl + F1

14 / 20

What is the shortcut key to move to the next worksheet in Excel?

Ctrl + Tab

Ctrl + Page Down

Alt + Down Arrow

Ctrl + Shift + Right Arrow

15 / 20

What is the shortcut key to hide a column in Excel?

Ctrl + 9

Ctrl + Shift + 0

Ctrl + 0

Alt + H + C + H

16 / 20

What is the purpose of Data Validation in Excel?

To filter data based on criteria

To prevent duplicate entries

To restrict the type of data or values that users enter into a cell

To highlight empty cells

17 / 20

How many common types of error values are there in Excel?

18 / 20

What is the purpose of the "Start number" parameter in the FIND() function in Excel?

It limits the number of characters to search

It defines the number of characters to extract

It specifies the position from where the search should begin

It determines the position to insert text

19 / 20

What is the purpose of the "Instance number" parameter in the TEXTBEFORE() function in Excel?

It specifies the number of characters to return before the delimiter

It determines which occurrence of the delimiter to use

It defines the total number of delimiters allowed

It returns the index of the delimiter

20 / 20

What is the purpose of the N() function in Excel?

To count numeric values in a range

To convert a value to a number

To return the number of characters

To convert numbers to text format

Your score is

The average score is 63%

Skill Checkpoint: See Where You Stand

Category: Basic Excel