wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel summary

Total questions: 64

Worksheet time: 34mins

Name
Class
Date
1.

Making a change in the default settings

a)

Formai

b)

Error

c)

Average

d)

Chart

2.

A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.

a)

Pie Chart

b)

Bar Chart

c)

Line Chart

d)

Graphs

3.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
4.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
5.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
6.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
7.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
8.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
9.
When entering numbers in  Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
10.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
11.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
12.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
13.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
14.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
15.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
16.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
17.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums 
18.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
19.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
20.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
21.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
22.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
23.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
24.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
25.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow
26.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
27.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
28.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
29.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
30.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
31.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells 
32.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
33.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
34.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
35.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
36.
Numbers in Excel is automatically aligned  ____.
a)
Right
b)
Left
c)
Center
d)
Justify
37.

What is the tool used for?

a)

Change colour of Text

b)

Change colour of the Cell (Box)

c)

Fill the whole sheet

38.

What Cell have I selected

a)

A4

b)

B5

c)

C5

d)

D5

e)

B6

39.

What does the formula do?

a)

Times everything together you select

b)

Add everything together you select

40.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

41.

What is a cell in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

42.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

43.

What symbol comes first when using a function?

a)

:

b)

*

c)

(

d)

=

44.

How are cells named?

a)

By row (number) and column (letter)

b)

By column (letter) and row (number)

c)

By the contents of the cell

d)

Names are randomly assigned

45.

What is a cell in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

46.

What is a function in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

47.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

48.

What symbol comes first when using a function?

a)

:

b)

*

c)

(

d)

=

49.

How are cells named?

a)

By row (number) and column (letter)

b)

By column (letter) and row (number)

c)

By the contents of the cell

d)

Names are randomly assigned

50.

To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?

a)

=SUM(C1-C5)

b)

=SUM(C1,C5)

c)

=SUM(C1:C5)

d)

=SUM(C1*C5)

51.

What function finds the mean of a data set?

a)

There is no function to calculate mean

b)

MEAN

c)

MEDIAN

d)

AVERAGE

52.

What is a histogram?

a)

Another name for a bar graph

b)

A line graph of a function

c)

A graph showing the frequency of values in a data set

d)

A calculation

53.

What is the correct absolute cell reference format?

a)

=D4*F3$$

b)

=D3*$R$3

c)

=$D£3*$F$3

d)

=$L3*F4$

54.

What is the correct symbol to add something in excel?

a)

+

b)

/

c)

*

d)

-

55.

What is the correct absolute cell reference format?

a)

=D4*F3$$

b)

=D3*$R$3

c)

=$D£3*$F$3

d)

=$L3*F4$

56.

What is the correct symbol to add something in excel?

a)

+

b)

/

c)

*

d)

-

57.

What is the correct sum for addition?

a)

=D3*D4

b)

=D3/D4

c)

D2-D1

d)

=D3+D12

58.

What would you use if you wanted to find the minimum of a set of numbers.

a)

=MIN

b)

=MAX

c)

=Average

d)

=CountIF

59.

fill in the blank for the sum to work

5 (a)   6= 30

60.

what are the two non excel functions?

a)

insert a new slide

b)

insert a new column

c)

Insert Table

d)

animations/transitions

61.

If you make a business and you need to total up your earnings what way would you do it?

a)

make a table

b)

make a chart

c)

make a spreadsheet

d)

make a graph

62.

how do you select more than one column

a)

hold shift

b)

hold CTRL

c)

hold alt

d)

alt and F4

63.

If I want to organise some names in alphabetical order, how would you do that,

a)

Filter A to Z

b)

Filter Z to A

c)

Sort

d)

Count

64.

Which two options are existing functions?

a)

Currency £

b)

Percentage %

c)

text

d)

paragraph

Similar Resources on Wayground

Storia - Hardware 1_ Tallini

63 questions

Storia - Hardware 1_ Tallini

quiz

Worksheet

•

1st Grade - University

Guía de examen - Herramientas para el trabajo colaborativo

69 questions

Guía de examen - Herramientas para el trabajo colaborativo

quiz

Worksheet

•

University

UTS Elektronika Dasar

65 questions

UTS Elektronika Dasar

quiz

Worksheet

•

University

la madera

60 questions

la madera

quiz

Worksheet

•

10th Grade

Micro:bit

60 questions

Micro:bit

quiz

Worksheet

•

11th Grade

Quis SMA Part II

65 questions

Quis SMA Part II

quiz

Worksheet

•

9th - 12th Grade

Repàs Electricitat 2ESO

60 questions

Repàs Electricitat 2ESO

quiz

Worksheet

•

10th Grade

Basic Electric-E Learning BUMA

60 questions

Basic Electric-E Learning BUMA

quiz

Worksheet

•

10th Grade - University