wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Module [5] - Excel Exams

Total questions: 75

Worksheet time: 38mins

Name
Class
Date
1.

When you remove a filter, the original data is retrieved. Select one:

a)

True

b)

False

2.

Select Landscape for vertical page. Select one:

a)

True

b)

False

3.

To run a logical test, use ………………. Select one:

a)

Sum function

b)

IF function

c)

Count function

d)

Round function

4.

Operations should be enclosed in parentheses. Select one:

a)

True

b)

False

5.

When the column isn't wide enough to display the value, …………… appears. Select one:

a)

#DIV/0! error

b)

Error #NAME?

c)

#VALUE! Error

d)

Error ######

6.

Excel displays the #DIV/0! Error when there is an empty cell. Select one:

a)

True

b)

False

7.

To organize a list of names in an alphabetical order, use ……………. Select one:

a)

Data mining

b)

Data Filtering

c)

Data sorting

d)

Data applying

8.

The worksheet direction cannot be changed. Select one:

a)

True

b)

False

9.

Use conditional formatting to apply colors on cells. Select one:

a)

True

b)

False

10.

To move one cell to left, press ………………. Select one:

a)

Tab

b)

Insert

c)

Enter

d)

Shift + Tab

11.

To delete a cell content, press ………………. Select one:

a)

remove

b)

Delete

c)

Enter

d)

Shift

12.

Error ##### means that the syntax of the formula should be corrected. Select one:

a)

True

b)

False

13.

You can find different chart types in the …………… tab. Select one:

a)

Data

b)

Design

c)

formulas

d)

View

14.

Filtering depends on the type of data. Select one:

a)

True

b)

False

15.

To write a title in a cell consisting of several cells, press ……………… button. Select one:

a)

Formulas

b)

Wrap text

c)

Merge and Center

d)

Review

16.

Excel displays the #REF! error when a formula refers to a cell that is not valid. Select one:

a)

True

b)

False

17.

There are ……………… to be used for navigating through the worksheet. Select one:

a)

eight tools

b)

two tools

c)

three tools

d)

four tools

18.

………………… means that the formula refers to a cell that is not valid. Select one:

a)

#REF! error

b)

Error #NAME?

c)

#VALUE! Error

d)

#DIV/0! error

19.

Excel contains AutoFilter submenu boxes. Select one:

a)

True

b)

False

20.

To write a title for the data, you can merge cells. Select one:

a)

True

b)

False

21.

Data sorting is different from data analysis. Select one:

a)

True

b)

False

22.

You can color the borders of the cells. Select one:

a)

True

b)

False

23.

To calculate the length of the text string, use…………… Select one:

a)

Round function

b)

Count function

c)

Sum function

d)

LEN function

24.

Excel offers different predefined margins. Select one:

a)

True

b)

False

25.

To complete a series, use the …………… Select one:

a)

autofill tool

b)

Ctrl

c)

Alt+shift

d)

immediate tool

26.

…………… refers to symbolic link Workbook. Select one:

a)

*.SLW

b)

*.txt

c)

*.prn

d)

*SYLK

27.

The error displayed when a value is not the expected type at the formula is ………… Select one:

a)

#DIV/0!

b)

#VALUE!

c)

#REF!

d)

#RUN!

28.

The error displayed when a formula tries to divide number by 0 is ………… Select one:

a)

#DIV/0!

b)

#VALUE!

c)

#REF!

d)

#RUN!

29.

The filter command is in the …………… tab. Select one:

a)

Search

b)

file

c)

layout

d)

Data

30.

To change the page orientation, Select view tab. Select one:

a)

True

b)

False

31.

When you remove sheet from tab Select…………… Select one:

a)

Delete

b)

Remove

32.

Chart must have headlines. Select one:

a)

True

b)

False

33.

Can delete sheet from workbook. Select one:

a)

True

b)

False

34.

These are Excel extension except………….. Select one:

a)

xls

b)

Dif

c)

DIFT

d)

prn

35.

You can adjacent marigin column from custom marigin. Select one:

a)

True

b)

False

36.

To adjust margins click custom margins. Select one:

a)

True

b)

False

37.

The cell is identified by column number and row header. Select one:

a)

True

b)

False

38.

Error ………… means that the syntax of the formula should be corrected. Select one:

a)

#NAME

b)

#DIV/0!

c)

#VALUE!

d)

#REF!

39.

To move one cell right press………… Select one:

a)

TAB

b)

Shift + TAB

c)

ALT + TAB

40.

Average function is used for summation. Select one:

a)

True

b)

False

41.

You can hide worksheets from workbook. Select one:

a)

True

b)

False

42.

Min value use mean function. Select one:

a)

True

b)

False

43.

You can change the colour of cell using conditional formatting. Select one:

a)

True

b)

False

44.

To delete object in Excel sheet….. Select one:

a)

Select it and then press the Delete key

b)

Press Backspace without selecting the object

c)

Right‑click the object and choose Format Cells

d)

Use AutoSum to clear the object

45.

The spreadsheet is used for the organization and the storage of data in tabular form. Select one.

a)

True

b)

False

46.

To insert a column, right‑click on the column letter that is after the column you want to insert. Select one.

a)

True

b)

False

47.

The Autofill tool mouse pointer at the bottom‑left center of the cell appears as what shape? Select one.

a)

Plus sign (+)

b)

Crosshair

c)

Arrow pointer

d)

Hand icon

48.

To select a range, select a cell then, with the left mouse button pressed, drag over the other cells. Select one.

a)

True

b)

False

49.

When all the numbers between 1000 and 2000 in a range should be displayed in green, you can use which feature? Select one.

a)

Conditional formatting

b)

IF function

50.

To write data on a new line within the same cell, enter a line break by pressing ALT + Enter. Select one.

a)

True

b)

False

51.

How can you reach a cell in a quick way? Select one.

a)

Write the cell name in the Name box

b)

Scroll to the cell with the mouse

c)

Open Find and replace

d)

Change the worksheet zoom level

52.

The worksheet tab color can't be changed. Select one.

a)

True

b)

False

53.

The Autofill tool is used only to copy content, increment, or complete a series. Select one.

a)

True

b)

False

54.

To move a chart to a new sheet or another file, use the Move Chart option on which tab? Select one.

a)

Chart Design tab

b)

View tab

c)

Insert tab

d)

Home tab

55.

You can see the cell content at the: Select one.

a)

Formula bar

b)

Title bar

56.

Protection tab changes the alignment of the data within a cell. Select one.

a)

True

b)

False

57.

To select non‑adjacent rows or columns, hold Control and select the row or column numbers/letters. Select one.

a)

True

b)

False

58.

Name box is a bar that appears at the left corner of the formula bar and usually includes the name of the active cell. Select one.

a)

True

b)

False

59.

Excel displays the error #DIV/0!\#DIV/0! when a formula tries to divide a number by 100. Select one.

a)

True

b)

False

60.

To color a worksheet tab, which action should you use? Select one.

a)

Right‑click the worksheet name, choose Tab Color, select a color

b)

Use Conditional formatting

c)

Change the Status bar color

d)

Open Page Layout and set Theme Colors

61.

Which element consists of tab groups and commands? Select one.

a)

Ribbon

b)

Status bar

c)

Title bar

d)

Formula bar

62.

Maximize and minimize are considered what? Select one.

a)

Control buttons

b)

Command tabs

c)

Toolbar items

d)

Status indicators

63.

Press which key to move one cell to the right? Select one.

a)

Tab

b)

Enter

c)

Spacebar

d)

Right Arrow

64.

When we open a new workbook, Excel gives it a default name. Select one.

a)

True

b)

False

65.

You can move a chart to a new sheet or another file using the Move Chart option from the View tab. Select one.

a)

True

b)

False

66.

Conditional formatting allows automatic application of colors on one or more cells based on the cell value. Select one.

a)

True

b)

False

67.

Spreadsheet is a powerful analysis tool for large amounts of data. Select one.

a)

True

b)

False

68.

To temporarily hide rows that we do not want to display, we can use which feature? Select one.

a)

Data filtering

b)

Conditional formatting

c)

Data sorting

d)

Freeze panes

69.

You can hide the headings of the Excel sheet when printing. Select one.

a)

True

b)

False

70.

You can select an entire column by selecting the column number. Select one.

a)

True

b)

False

71.

A bar located at the bottom of the program window is called what? Select one.

a)

Status bar

b)

Title bar

c)

Menu bar

d)

Formula bar

72.

Which interface element contains three options (Save, Undo, and Redo) by default? Select one.

a)

Quick Access Toolbar

b)

Status bar

c)

Ribbon

d)

Formula bar

73.

Press Delete on the keyboard to delete values from cells. Select one.

a)

True

b)

False

74.

The SUM function is used to get values summation. Select one.

a)

True

b)

False

75.

What is the total of values divided by the number of values? Select one.

a)

Average

b)

Sum