wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Quizzes Collection

Total questions: 59

Worksheet time: 30mins

Name
Class
Date
1.

Which key combination is used to copy in Excel?

a)

Ctrl + C

b)

Ctrl + X

c)

Ctrl + V

d)

Ctrl + A

2.

Which function adds numbers together?

a)

SUM

b)

ADD

c)

TOTAL

d)

COMBINE

3.

Which function counts the number of numeric entries in a range?

a)

COUNTA

b)

COUNT

c)

MIN

d)

MAX

4.

Which function counts both text and numbers?

a)

COUNT

b)

COUNTA

c)

COUNTIF

d)

SUM

5.

The function that gives the smallest value in a dataset is:

a)

SMALL

b)

MIN

c)

LOWEST

d)

BOTTOM

6.

The function that gives the largest value in a dataset is:

a)

MAX

b)

TOP

c)

HIGH

d)

LARGE

7.

Which formula calculates the average of A1:A10?

a)

=SUM(A1:A10)/10

b)

=AVG(A1:A10)

c)

=AVERAGE(A1:A10)

d)

=MEAN(A1:A10)

8.

In the formula `=IF(B2>=50,"Pass","Fail")`, if B2 = 40, the result is:

a)

Pass

b)

Fail

c)

Error

d)

Blank

9.

Which function rounds a number up or down?

a)

ROUND

b)

APPROX

c)

LIMIT

d)

FIX

10.

What is the difference between relative and absolute referencing?

a)

Relative references stay fixed, absolute changes

b)

Relative changes when copied, absolute stays fixed

c)

Both stay fixed

d)

Both change when copied

11.

Which shortcut inserts a new worksheet?

a)

Shift + F11

b)

Ctrl + N

c)

Ctrl + T

d)

F2

12.

Which function checks if a condition is true or false?

a)

CHECK

b)

IF

c)

TRUE

d)

VERIFY

13.

What does COUNTA exclude?

a)

Numbers

b)

Text

c)

Blanks

d)

Dates

14.

The symbol `$` in cell references is used for:

a)

Currency formatting

b)

Absolute reference

c)

Error checking

d)

Shortcut

15.

To sort data A-Z, you use:

a)

Data → Sort → Z-A

b)

Data → Sort → A-Z

c)

Insert → Sort

d)

Review → Sort

16.

Which function removes leading and trailing spaces?

a)

CLEAN

b)

TRIM

c)

REPLACE

d)

SUBSTITUTE

17.

Which function capitalizes the first letter of each word?

a)

UPPER

b)

PROPER

c)

TITLE

d)

FORMAT

18.

Which function converts all text to lowercase?

a)

LOWER

b)

DOWN

c)

SMALL

d)

LCASE

19.

Which tool removes duplicates?

a)

Data → Sort

b)

Data → Remove Duplicates

c)

Insert → Table

d)

Review → Delete

20.

The shortcut for Flash Fill is:

a)

Ctrl + D

b)

Ctrl + E

c)

Ctrl + L

d)

Ctrl + Shift + E

21.

Text to Columns is used to:

a)

Join two columns

b)

Split data into columns

c)

Remove blanks

d)

Format numbers

22.

VLOOKUP searches for a value in:

a)

The first row

b)

The first column

c)

Any row

d)

Any cell

23.

HLOOKUP searches for a value in:

a)

The first row

b)

The first column

c)

The last row

d)

The last column

24.

XLOOKUP can replace which functions?

a)

VLOOKUP only

b)

HLOOKUP only

c)

Both VLOOKUP & HLOOKUP

d)

None

25.

Which error means a lookup value is missing?

a)

N/A

b)

REF!

c)

VALUE!

d)

NAME?

26.

INDEX function returns:

a)

Row number

b)

Value from a row/column

c)

Column number

d)

Error

27.

MATCH function returns:

a)

The value itself

b)

The position of the value

c)

The average

d)

None

28.

VLOOKUP requires the lookup value to be in:

a)

Any column

b)

The last column

c)

The first column

d)

The middle column

29.

Which function replaces text within a string?

a)

SUBSTITUTE

b)

REPLACE

c)

CHANGE

d)

EDIT

30.

Which function removes all non-printable characters?

a)

CLEAN

b)

TRIM

c)

DELETE

d)

REMOVE

31.

PivotTables are used to:

a)

Enter data

b)

Summarize and analyze data

c)

Format text

d)

Draw charts only

32.

To insert a PivotTable, go to:

a)

Data → Table

b)

Insert → PivotTable

c)

View → Pivot

d)

Review → Insert

33.

Which section of PivotTable contains items like "Region" or "Month"?

a)

Values

b)

Rows/Columns

c)

Filters

d)

All of the above

34.

Pivot Charts are linked to:

a)

Tables

b)

PivotTables

c)

Formulas only

d)

Worksheets

35.

Which chart is best for comparing parts of a whole?

a)

Pie chart

b)

Line chart

c)

Column chart

d)

Bar chart

36.

Which chart is best for showing changes over time?

a)

Pie chart

b)

Line chart

c)

Column chart

d)

Scatter chart

37.

Conditional formatting is found under:

a)

Insert → Chart

b)

Home → Styles

c)

Data → Tools

d)

View → Layout

38.

Conditional formatting can:

a)

Delete duplicates

b)

Highlight top 10% values

c)

Insert shapes

d)

Split text

39.

A slicer is used in PivotTables to:

a)

Filter data visually

b)

Split columns

c)

Format numbers

d)

Merge cells

40.

Sparklines are:

a)

Charts inside cells

b)

Macros

c)

PivotTables

d)

Functions

41.

Which chart best shows correlation?

a)

Scatter plot

b)

Pie chart

c)

Bar chart

d)

Line chart

42.

Which option groups PivotTable data by month or year?

a)

Group function

b)

Filter

c)

Sort

d)

Chart

43.

Which button refreshes PivotTable data?

a)

Update

b)

Refresh

c)

Recalculate

d)

Reset

44.

Which chart is best for ranking data?

a)

Column/Bar chart

b)

Line chart

c)

Pie chart

d)

Scatter chart

45.

PivotTable values can be summarized using:

a)

Sum

b)

Average

c)

Count

d)

All of the above

46.

Goal Seek is used to:

a)

Change formatting

b)

Find input for a desired output

c)

Add totals

d)

Sort values

47.

Scenario Manager is found under:

a)

Data → What-If Analysis

b)

Insert → Charts

c)

Review → Manager

d)

View → Scenarios

48.

A dashboard in Excel is:

a)

A colorful sheet

b)

A summary report with charts & tables

c)

A single formula sheet

d)

A PivotTable only

49.

To add a trendline:

a)

Right-click chart → Add Trendline

b)

Insert → Trend

c)

Review → Forecast

d)

View → Chart

50.

Forecasting is useful for:

a)

Cleaning data

b)

Predicting future values

c)

Formatting cells

d)

Merging tables

51.

Which tool allows multiple outcomes testing?

a)

Scenario Manager

b)

Goal Seek

c)

Filter

d)

Sort

52.

A dashboard differs from a normal sheet because:

a)

It contains raw data only

b)

It visualizes key insights

c)

It has no charts

d)

It uses only text

53.

Which feature allows testing multiple input values in a formula?

a)

Data Tables

b)

Filters

c)

VLOOKUP

d)

COUNTIF

54.

Which What-If tool finds a missing interest rate for a loan payment?

a)

Goal Seek

b)

Scenario Manager

c)

Solver

d)

Forecast

55.

A good dashboard should be:

a)

Overloaded with text

b)

Clear and concise

c)

Without charts

d)

Only one color

56.

Which chart is best for showing a forecast with historical data?

a)

Line chart

b)

Pie chart

c)

Column chart

d)

Scatter plot

57.

What does DIV/0! error mean?

a)

Cell is empty

b)

Dividing by zero

c)

Formula missing

d)

Lookup not found

58.

Dashboards often use:

a)

PivotTables

b)

Charts

c)

Conditional Formatting

d)

All of the above

59.

A scenario in Scenario Manager is:

a)

A set of different input values

b)

A PivotChart

c)

A formula

d)

A worksheet

Similar Resources on Wayground

Common test 01

60 questions

Common test 01

quiz

Worksheet

•

Professional Development

Data Cloud Cert Prep 2

64 questions

Data Cloud Cert Prep 2

quiz

Worksheet

•

Professional Development

Cyber Security Quiz

55 questions

Cyber Security Quiz

quiz

Worksheet

•

Professional Development

Συνδυαστικό Quiz 60 Ερωτήσεων 1.1-1.4

60 questions

Συνδυαστικό Quiz 60 Ερωτήσεων 1.1-1.4

quiz

Worksheet

•

Professional Development

LMS-Infosyte Test-13

60 questions

LMS-Infosyte Test-13

quiz

Worksheet

•

Professional Development

Basic Troubleshooting Skills Quiz

59 questions

Basic Troubleshooting Skills Quiz

quiz

Worksheet

•

Professional Development

(TEST) AF #1

62 questions

(TEST) AF #1

quiz

Worksheet

•

Professional Development

DUMSA_3.1

57 questions

DUMSA_3.1

quiz

Worksheet

•

Professional Development