wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

REVIEW TEST – Microsoft Excel - G7

Total questions: 45

Worksheet time: 23mins

Name
Class
Date
1.

What type of software is Microsoft Excel considered?

a)

Spreadsheet

b)

Presentation

c)

Word processor

d)

Database

2.

A workbook in Excel is made up of several:

a)

Tables

b)

Worksheets

c)

Charts

d)

Slides

3.

The box formed by a row and a column is called a:

a)

Field

b)

Cell

c)

Range

d)

Group

4.

What displays the name of the Excel file and program?

a)

Formula Bar

b)

Title Bar

c)

Status Bar

d)

Ribbon

5.

Which tab do you click to save your Excel work?

a)

Home

b)

File

c)

Data

d)

Insert

6.

What shortcut key pastes copied data?

a)

Ctrl + V

b)

Ctrl + C

c)

Ctrl + X

7.

The default file format of an Excel workbook is:

a)

.xlsx

b)

.docx

c)

.pptx

d)

.xls

8.

Which bar shows the active cell’s contents?

a)

Formula Bar

b)

Status Bar

c)

Title Bar

d)

Tool Bar

9.

Which key combination redoes an action?

a)

Ctrl + Y

b)

Ctrl + X

c)

Ctrl + C

d)

Ctrl + U

10.

The long horizontal group of commands in Excel is called the:

a)

Menu

b)

Ribbon

c)

Toolbar

d)

Formula bar

11.

To adjust column width, you use:

a)

Page Layout

b)

Home tab → Format

c)

Data → Sort

d)

Review

12.

To select multiple cells together you create a:

a)

Field

b)

Range

c)

Set

d)

Record

13.

Which command combines cells into one large cell?

a)

Wrap Text

b)

Merge & Center

c)

Border

d)

Fill Color

14.

Which feature repeats your last action?

a)

Redo

b)

Undo

c)

Refresh

d)

Reset

15.

The vertical lines labeled A, B, C... are called:

a)

Columns

b)

Rows

c)

Cells

d)

Tabs

16.

In Excel, every formula starts with what character?

a)

#

b)

=

c)

+

d)

%

17.

Which function finds the largest number in a range?

a)

=MAX

b)

=MIN

c)

=AVERAGE

d)

=COUNT

18.

Which function calculates the mean value?

a)

=SUM

b)

=AVERAGE

c)

=COUNT

d)

=MAX

19.

The function =COUNT(A1:A5) returns:

a)

Total of numbers

b)

Number of numeric cells

c)

Text count

d)

Highest value

20.

A fixed cell reference is written as:

a)

A. A1

b)

B. AA

c)

C. A$1

d)

D. $A$1

21.

Which key converts a relative reference into an absolute reference?

a)

F1

b)

F4

c)

F3

d)

F10

22.

Which operator performs multiplication?

a)

/

b)

*

c)

+

d)

%

23.

Which tab provides font, alignment, and cell border options?

a)

Data

b)

Home

c)

Insert

d)

Review

24.

Which chart type shows percentages of a whole?

a)

Pie

b)

Column

c)

Line

d)

Bar

25.

The first step to make a chart is:

a)

Collect the data

b)

Draw the chart title

c)

Color the chart

d)

Print the chart

26.

A line chart is best for showing:

a)

Changes over time

b)

Category comparison

c)

Percentages

d)

Totals

27.

The function =MIN(A2:A10) will show:

a)

The highest number

b)

The lowest number

c)

The sum

d)

The average

28.

The function =SUM(A1:A4) does what?

a)

Counts data

b)

Adds data

c)

Subtracts data

d)

Divides data

29.

Which option adds a border around cells?

a)

Home → Borders

b)

Data → Filter

c)

View → Gridlines

d)

Page Layout → Margins

30.

Which tool lets you include labels and legends in a chart?

a)

Chart Tools

b)

Page Layout

c)

View

d)

Review

31.

Sorting allows you to:

a)
merge multiple datasets
b)
organize data in a specific order
c)
delete unnecessary data
d)
randomize data randomly
32.

Filtering helps you:

a)

Display only chosen data

b)

Change the font color

c)

Delete rows

d)

Add totals

33.

You can find Sort and Filter commands in which tab?

a)

Home

b)

Data

c)

Insert

d)

View

34.

Which icon appears when filtering is active?

a)

Small arrow on header

b)

Star symbol

c)

Dot

d)

Check mark

35.

To remove filters, select:

a)

Data → Clear

b)

File → Reset

c)

Home → Delete

d)

View → Options

36.

A column in a list represents a:

a)

Record

b)

Field

c)

Group

d)

Dataset

37.

A row in a database represents a:

a)

Field

b)

Record

c)

Header

d)

Filter

38.

What should the first row of a table contain?

a)

Field names

b)

Totals

c)

Filters

d)

Blank cells

39.

Which data consistency rule is correct?

a)

Each column should have the same data type

b)

Use mixed formats

c)

Leave blank rows

d)

Merge cells

40.

Data → Sort & Filter group is found in:

a)

Data tab

b)

Home tab

c)

File tab

d)

Review tab

41.

Which feature hides unwanted data temporarily?

a)

Filter

b)

Sort

c)

Merge

d)

Format

42.

Filtering and sorting are both:

a)

Data management tools

b)

Layout options

c)

Formula types

d)

Chart types

43.

Which command alphabetizes text data?

a)

Sort A to Z

b)

Count

c)

Align

d)

Merge

44.

A properly structured Excel database must not have:

a)

Blank rows

b)

Column titles

c)

Numeric data

d)

Text data

45.

Why use sorting and filtering?

a)

To analyze information quickly

b)

To delete old data

c)

To change background color

d)

To print faster