Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel championship - Level 1

Total questions: 25

Worksheet time: 9mins

Name
Class
Date
1.

In Excel, what is the result of = 1 + 3 * 2 / 2 - 1 ?

a)

2

b)

3

c)

4

d)

6

2.

Which of the following shows a formula for a reference to another workbook?

a)

=SUM(C2:E12)

b)

=Q3Expenses!A19

c)

=[Media.xlsx]MasterList!$D$10

d)

=SUM(budget.summary)

3.

Which Excel feature automatically fills cells with data from another cell or range or completes a data series?

a)

Range Fill

b)

Auto Fill

c)

Data Fill

d)

Complete Fill

4.

Using the Delete key removes both text and formats from a cell

a)

True

b)

False

5.

By default, Excel starts a new workbook with four worksheets

a)

True

b)

False

6.

If you want to use a workbook in another kind of document, you have the option to save using which of the following?

a)

File format

b)

Worksheet

c)

File sheet

d)

File range

7.

What is the name of the feature that saves copies of your files at specified intervals?

a)

Protect Sheet

b)

Track Changes

c)

AutoRecover

d)

Document Recovery

8.

Page Layout view is useful when preparing your data for printing.

a)

True

b)

False

9.

Which predesigned file already has a significant amount of formatting, text, and other features?

a)

Blank workbook

b)

Preset file

c)

Text file

d)

Template

10.

How do you move a group of cells like this?

a)

point to the selection's border and drag the selected cells

b)

point to the selection's border, press Ctrl, and drag the selected cells

c)

point to the selection's border, press Alt, and drag the selected cells

d)

point to the selection's border, press Ctrl+Alt+Shift+F12+PgUp, and drag the selected cells

11.

Which of the following is not an arithmetic operator?

a)

+

b)

-

c)

*

d)

]

12.

Which feature enables you to create custom tabs and groups?

a)

View

b)

Tab

c)

Ribbon

d)

Quick Access Toolbar

13.

What will happen when you click the button highlighted above?

a)

the selected text will be bold, Calibri, 11 pt, yellow font

b)

the selected text will be bold, Calibri, 12 pt, yellow font

c)

the selected text will be bold, Calibri, 11 pt, highlighted in yellow

d)

the selected text will be bold, Calibri, 12 pt, highlighted in yellow

14.

You just hit the Print button. How many sheets will you find on the printer?

a)

4

b)

8

c)

16

d)

32

15.

Ctrl + O opens a new blank workbook

a)

True

b)

False

16.

What will happen when you click the button highlighted above?

a)

the selected text will be bold, Calibri, 12 pt

b)

the selected text will be bold, Calibri, 10 pt

c)

the selected text will be non-bold, Calibri, 12 pt

d)

the selected text will be bold, Comic Sans, 10 pt

17.

In the example above, Excel's FillSeries feature extends the series when you drag the fill handle in the lower-right corner of the selection. But what is the quickest way copy the original values?

a)

copy the original values and paste into each of the new cells

b)

copy the original values and press the Sort button

c)

drag the fill handle while pressing Ctrl

d)

use the Format Painter

18.

Dates can be displayed in only one way in Excel

a)

True

b)

False

19.

If you format a number with the following Custom formatting: hh:mm:ss d-mmm-yyyy. How might the resulting date look?

a)

01:11:31 9-Sep-20

b)

01:11:31 9-September-2020

c)

01:11:31 9-Sep-2020

d)

01:11 9-Sep-2020

20.

Use Ctrl + N to create a new workbook

a)

True

b)

False

21.

What type of chart is this?

a)

Roti

b)

Doughnut

c)

Pie

d)

Radar

22.

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

a)

Backstage

b)

Print

c)

Edit

d)

Windows

23.

Which of the following will return your worksheet to 100% with one click?

a)

A

b)

B

c)

C

d)

D

24.

Which cell would you click to freeze Rows 1-5 and Column A?

a)

A5

b)

A6

c)

B5

d)

B6

25.

Which of the following options can be used to fit the worksheet to one page?

a)

Collated

b)

Orientation

c)

Margins

d)

Scaling