wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Review

Total questions: 62

Worksheet time: 43mins

Name
Class
Date
1.

Which of the following indicates a proper cell address?

a)

3A

b)

:A3

c)

A3

d)

@A3

2.

Which of the following describes a column?

a)

Identified by letters; runs vertically

b)

Identified by letters; runs horizontally

c)

Identified by numbers; runs vertically

d)

Identified by numbers; runs horizontally

3.

Which of the following describes a row?

a)

Identified by letters; runs vertically

b)

Identified by letters; runs horizontally

c)

Identified by numbers; runs vertically

d)

Identified by numbers; runs horizontally

4.

What is Microsoft Excel designed for?

a)

creating presentations

b)

store formulas

c)

storing, organizing, and manipulating data using spreadsheets.

d)

create documents

5.
An Excel file that is made up of individual worksheets. 
a)
Workbook
b)
Workspace
c)
Worksheet
d)
Ebook
6.

Which command is used to insert a cut or copied selection to a cell or range of cells?

a)

Paste

b)

Document Properties

c)

Copy

d)

Range

7.

Content that has been cut or copied to the clipboard will have a marching dashed green border around it.

a)

TRUE

b)

FALSE

8.

To select cells that are not adjacent (next to) each other, use which of the following keys while clicking on each cell?

a)

Ctrl

b)

Alt

c)

Shift

d)

Fn

9.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
10.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
11.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
12.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
13.

When your mouse looks like the arrow in the following picture, what name would you use to describe this mouse pointer?

a)

Column or Row Pointer

b)

Move Pointer

c)

Fill Pointer

d)

Normal Pointer

14.

Comma format

a)

A

b)

B

c)

C

d)

D

e)

E

15.

Accounting format

a)

A

b)

B

c)

C

d)

D

e)

E

16.

Decrease decimals

a)

A

b)

B

c)

C

d)

D

e)

E

17.

Percentage format

a)

A

b)

B

c)

C

d)

D

e)

E

18.

Allows you to rotate text within a cell

a)

A

b)

B

c)

C

d)

D

e)

E

19.

Text that is too wide for the column will be put on two lines within the same cell.

a)

A

b)

B

c)

C

d)

D

e)

E

20.

Combines selected cells and applies center alignment

a)

A

b)

B

c)

C

d)

D

e)

E

21.

Middle Align

a)

A

b)

B

c)

C

22.

Top Align

a)

A

b)

B

c)

C

23.

Bottom Align

a)

A

b)

B

c)

C

24.

Which of the following is the fill color command?

a)
b)
c)
25.

Which of the following is the font color command?

a)
b)
c)
26.

Which of the following is the borders command?

a)
b)
c)
27.

Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain number signs like in the example below.


Which of the following suggestions would help Luisa?

a)

Make the column wider

b)
Change the number formatting in the cell
c)
Change the font format in the cell
d)
Delete the data and re-type it
28.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
29.

Which of the following is the proper format for a range?

a)

A1-D10

b)

A1:D10

c)

A1thruD10

d)

A1&D10

30.

Which of the following is the selection pointer?

a)
b)
c)
31.

Which of the following is the fill handle?

a)
b)
c)
32.

Which of the following is the move handle?

a)
b)
c)
33.

Which of the following is not an arithmetic operator?

a)

+

b)

-

c)

*

d)

]

34.

Which function calculates the TOTAL (adds all the cells in the range together)?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

35.

Which function calculates the MEAN of a range of cells (adds all the cells together and then divides by the number of cells)?

a)

MIN

b)

AVERAGE

c)

COUNT

d)

MAX

36.

Which function returns the highest value in a range?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

37.

Which function returns the lowest value in a range?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

38.

Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?

a)

=SUM(B1:B7)

b)

=COUNT(B1:B7)

c)

=AVERAGE(B1:B7)

d)

=MAX(B1:B7)

39.

Which function would you use instead of this formula: =(B1+B2+B3+B4)/4?

a)

=SUM(B1:B4)/4

b)

=COUNT(B1:B4)/4

c)

=AVERAGE(B1:B4)/4

d)

=MAX(B1:B4)/4

40.

Which function was used in E2?

a)

=COUNT(B1:B9)

b)

=COUNTA(B1:B9)

c)

=COUNTBLANK(B1:B9)

41.

Which function was used in E4?

a)

=SUM(B1:B9)

b)

=COUNT(B1:B9)

c)

=AVERAGE(B1:B9)

42.

Which function was used in E5?

a)

=SUM(B1:B9)

b)

=COUNT(B1:B9)

c)

=AVERAGE(B1:B9)

43.

Which function was used in E6?

a)

=SUM(B1:B9)

b)

=MIN(B1:B9)

c)

=MAX(B1:B9)

44.

Which function was used in E7?

a)

=SUM(B1:B9)

b)

=MIN(B1:B9)

c)

=MAX(B1:B9)

45.

Which sort option would showing increasing values or alphabetical order?

a)

Ascending

b)

Descending

46.

Referring to the table above, what is the quickest method of filtering so that only Oklahoma (OK) is shown?

a)

Uncheck every state or province except OK

b)

Uncheck Select All and then check OK

c)

Sort A to Z and then check OK

d)

Sort Z to A and then check OK.

47.

What option should you choose to remove a table's functionality?

a)

Remove Duplicates

b)

Resize Table

c)

Convert to Range

d)

Summarize with PivotTable

48.

Referring to the table above, which Table Style Option should be enabled so that every other row is filled with a shading color as shown in the 2nd picture?

a)

First Column

b)

Last Column

c)

Banded Columns

d)

Banded Rows

49.

How do you add a Total Row to a table?

a)

Enable the Total Row table style option

b)

Insert a blank row at the bottom of the table and then type "Total Row" as its heading

c)

Enable the Total Row conditional formatting option

d)

Use the Insert ribbon, then check Total Row

50.
What tool applies formatting to cells only when the cells meet some criteria?
a)
Special formatting
b)
Criteria formatting
c)
Conditional formatting
d)
Specific formatting
51.
Which tool is used to only show data that meets specific criteria and hides the rest of the data?
a)
Hide
b)
Sort
c)
Filter
d)
AutoFilter
52.

If you want to sort a column of numbers from largest to smallest, which option should you select?

a)

Sort A to Z

b)

Sort Z to A

c)

Filter by Color

d)

Clear Filter

53.

What is the purpose of the Icon Sets conditional formatting?

a)

To format the cells holding the highest or lowest values in a range

b)

To apply specified formatting to cells that meet a certain rule or criterion

c)

To create filled background bars in cells

d)

To include a set of icons reflecting the values in cells

54.
A visual representation of worksheet data.
a)
Column
b)
Data
c)
Chart
d)
Legend
55.
Part of a pie chart that represents one value from the series.
a)
axis
b)
data
c)
slice
d)
chart
56.
Corresponds to the category labels in a pie chart and series names in other charts.
a)
Plot area
b)
Legend
c)
Gridelines
d)
Slice
57.
This describes what is charted. It can be placed above or below the chart.
a)
Chart title
b)
chart area
c)
bar chart
d)
pie chart
58.
a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

59.
a)

BAR CLUSTER

b)

COMBO

c)

STOCK

d)

RADAR

60.
a)

LINE

b)

CIRCLE

c)

PIE

d)

COMBO

61.
a)

Area

b)

Stock

c)

Sunburst

d)

Radar

62.

Which chart type shows values as parts of a whole?

a)

Column

b)

Bar

c)

Area

d)

Pie

Similar Resources on Wayground

Non Standardize

65 questions

Non Standardize

quiz

Worksheet

•

9th - 10th Grade

UNIT 4 TEST OS, Hardware and Software Systems

60 questions

UNIT 4 TEST OS, Hardware and Software Systems

quiz

Worksheet

•

5th - 9th Grade

Microsoft Word/Powerpoint M1:L1-6

60 questions

Microsoft Word/Powerpoint M1:L1-6

quiz

Worksheet

•

9th - 12th Grade

KIỂM TRA EXCEL CB

58 questions

KIỂM TRA EXCEL CB

quiz

Worksheet

•

10th Grade

Output devices and their uses

60 questions

Output devices and their uses

quiz

Worksheet

•

9th - 11th Grade

DIT Unit 3 Study Guide

61 questions

DIT Unit 3 Study Guide

quiz

Worksheet

•

6th - 12th Grade

R093 SAM 22 - iMedia

66 questions

R093 SAM 22 - iMedia

quiz

Worksheet

•

9th - 12th Grade

AQA Computer Science GCSE - 3.4 Computer systems

63 questions

AQA Computer Science GCSE - 3.4 Computer systems

quiz

Worksheet

•

10th - 12th Grade