wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 9 Ms Excel

Total questions: 112

Worksheet time: 1hrs 22mins

Name
Class
Date
1.

What is the difference between Workbook and a worksheet?

a)

A workbook is the actual file that contains the worksheets, which turn contain the data.

b)

The worksheets contain the data and the workbook contains the tabs for each data type.

c)

A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

d)

There is no difference other than which term you prefer to use for spreadsheets.

2.

When you insert a row, where does Excel place it in relation to the cursor position?

a)

Above the current row

b)

Below the current row.

c)

You must select the row before you can insert a new row.

d)

You must copy and paste any existing data down one row to have a blank row at the cursor position.

3.

Which character automatically indicates the contents of a cell are a formula?

a)

$

b)

=

c)

‘

d)

“

4.

How can data be aligned within a cell?

a)

Horizontally

b)

Horizontal and Vertical

c)

Vertically

d)

Horizontally, vertically, or rotated

5.

Why might you want to apply borders to a cell instead of just using the gridlines on the worksheet?

a)

Borders can help to separate and identify specific cells.

b)

You can highlight a row by clicking one button for outside borders.

c)

To emphasize specific cells in the gridline.

d)

To mark the print area of the worksheet.

6.

Why might you prefer to apply a background color to a cell instead of applying a pattern

a)

There is a limited number of patterns to choose.

b)

Patterns can make it harder to read the data than using a solid color.

c)

You can choose a lighter color whereas all patterns are dark in design.

d)

Patterns should only be used with cells that have formulas.

7.

All formulas begin with a

a)

&

b)

=

c)

%

d)

-

8.
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
9.
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
10.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
11.
How can you find specific information in a list?
a)
Select Tools > Finder from the menu
b)
Click the Find button on the standard toolbar
c)
Select Insert > Find from the menu
d)
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
12.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
13.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
14.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
15.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
16.

Columns go...

a)

Across or Horizontally

b)

Down or Vertically

17.

Rows go...

a)

Across or Horizontally

b)

Down or Vertically

18.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
19.

Which of these symbols is used for divide on a computer?

a)

\

b)

*

c)

/

d)

|

20.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
21.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
22.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
23.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

24.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

25.
The name of the cell located at the intersection of column F and row 223 is:
a)
223F
b)
F223
c)
F222
d)
22F3
26.

_______________ involves creating a single cell by combining two or more selected cells.

a)

Cut and paste

b)

Merging cells

c)

Delete

d)

None of these answers

27.

A _______________, which appears when you right-click an object, is a list of frequently used commands that relate to the right-clicked object.

a)

Page layout

b)

Data

c)

Cell style

d)

Shortcut menu

28.

The horizontal and vertical lines on the worksheet itself are called.

a)

Excel window

b)

Status bar

c)

Gridlines

d)

Worksheet

29.

The ____________ presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.

a)

Page layout

b)

Status bar

c)

Page break view

d)

None of these answers

30.

How should you name a cell?

a)

Number + Letter

b)

Letter + Number

31.

What 3 types of data can be entered in a spreadsheet?

a)

Texts, numbers, charts

b)

Text, Colors, Pictures

c)

Text, numbers, formulas

32.

Which formula below finds the average of the cells?

a)

=AVERAGE(A1:A3)

b)

=AVERSGE(A1-A3)

33.
What is Microsoft Excel? 
a)
Spreadsheet Software
b)
Word Processing Software
c)
Audio Editing Software
d)
Presentation Software
34.
What is the purpose of a spreadsheet? 
a)
Store large amount of data
b)
Process and manipulate data
c)
perform calculation
d)
All of the above
35.
What is an example of a cell reference.
a)
8B
b)
B8
c)
BB
d)
88
36.
What is the term used to describe the symbols in a formula?
a)
Symbols
b)
Operators
c)
Formulas
d)
Functions
37.
What is a formula?
a)
Perform calculations in a spreadsheet.
b)
Is a predefined calculation.
c)
a tool to create a graph
d)
a tool to create a table
38.
A graph of plotted points that show the relationship between two sets of data.
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
39.
These graphs are usually used to show dependent data, and to display data which changes over time.
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
40.
With this type of graph, you can compare numbers between different categories which are independent so that if one changes it will not affect the others.
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
41.
This Graph shows a percentage of a whole. Your total is therefore 100% and the segments are proportionally sized to represent the percentage of the total. 
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
42.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
43.
Minh wanted to find the average of all of her grades, but can not get her function work. Her spreadsheet is below. What error is Min making?
a)
She has the incorrect arguments
b)
She has the wrong function name
c)
She is missing an equal sign at the beginning of her formula
d)
The colon should be replaced with a dash (-)
44.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)
=(C3+C5+C9)
45.

What is a bar graph used for?

a)

Showing differing values of data

b)

Showing parts of a whole

c)

Organizing data

46.

What is a pie chart used for?

a)

Showing differing values of data points

b)

Showing parts of a whole

c)

Organizing data points

47.

What tab do you click to find the charts and graphs?

a)

Home

b)

Insert

c)

Page Layout

d)

Formulas

48.

When creating a chart in Excel, what is the first thing you need to do?

a)

Select the data to be graphed.

b)

Select the Insert Tab

c)

Choose a chart from the ribbon

d)

Double click the active cell

49.

What does the mouse look like in a spreadsheet?

a)

Arrow

b)

Pointer

c)

Two headed arrow

d)

Selection cross

50.

The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.

a)

Autofill

b)

Copy and Paste

c)

Drag and Drop

d)

Typing

51.
Which response best completes the following statement: A formula is used to 
a)
perform calculations or other actions.
b)
find averages.
52.

Cell value references should always be used when possible to avoid having to make multiple updates when a key value changes.

a)

True

b)

False

53.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
54.

Define Formula Bar?

a)

An element in Excel or Google Sheets that appears below the grid and to the left of the zoom control that shows the deleted commands.

b)

A button or key in your keyboard to write the formulas.

c)

An element in Excel or Google Sheets that appears below the Ribbon that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

55.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

56.

When starting a formula what is the first thing you type in the cell?

a)

;

b)

?

c)

%

d)

=

57.

How would you write a cell reference formula for cell A1 subtracted from Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

58.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
59.

Which formula gets the biggest value of a range of cells?

a)

MAX

b)

MIN

c)

SHORT

d)

SUM

60.

Which formula gets the smallest value of a range of cells?

a)

MAX

b)

MIN

c)

SMALL

d)

SUM

61.

A _________ is a prewritten formula that is built into EXCEL.

a)

function

b)

problem

c)

equation

d)

equal sign

62.

A combination of numbers and symbols used to express a calculation. Always begins with an "=" sign.

a)

Cell address

b)

Worksheet

c)

Formula

63.

Which of the following formulas is not entered correctly?

a)

=10+50

b)

=B7+B8

c)

=B7+14

d)

=10+50;

64.

Which of these symbols is used to do a division on a computer?

a)

\

b)

*

c)

/

d)

|

65.

Which operator is used to multiply in Excel?

a)

+

b)

x

c)

/

d)

*

66.

Formulas can be copied to adjacent cells with the ____________.

a)

Fill handle

b)

PgDn Key

c)

Function key F4

d)

None of the above

67.

To edit a formula you

a)

A. Double-click the cell

b)

B. Click in the formula bar

c)

C. Press Esc

d)

D. Both A & B

68.

Answer =2+3*3-2

a)

9

b)

10

c)

11

d)

12

69.

Answer =3+5*(6-2)

a)

23

b)

32

c)

31

d)

64

70.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
71.
A(n) Excel ___ allows data to be easily calculated.
a)
worksheet
b)
format
c)
table
d)
display 
72.
The _____ function that adds all of the numbers in a range of cells.
a)
AutoSum
b)
minimum
c)
maximum
d)
Average
73.
Which formula appears when you click the AUTOSUM button?
a)
=AVERAGE
b)
=AUTOSUM()
c)
=SUM()
d)
=AUTOSUM
74.
Which symbol must you use to begin a formula?
a)
+
b)
=
c)
/
d)
*
75.
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
76.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
77.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
78.
The feature that allows you to quickly apply the contents of one cell to another cell or range of cells.
a)
Enter
b)
AutoFill
c)
Delete
79.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
80.
Excel workbook can contain ______ worksheets.
a)
155
b)
255
c)
355
d)
455
81.
By default, how many worksheet is displayed when you open Excel?
a)
1
b)
2
c)
3
d)
4
82.
An active cell is outline in _________.
a)
Red
b)
Blue
c)
Green
d)
Purple
83.
To accept a formula in a cell, press the _________ key.  
a)
Tab
b)
Enter
c)
Ctrl
d)
Shift
84.
1.  A selection of two or more cells is called a ________. Example A1:A4
a)
Table
b)
Range
c)
AutoFill
d)
Cell
85.
A ______________ is an equation in a worksheet.
a)
Range
b)
Argument
c)
Formula
d)
Excel
86.
What is the symbol to add in Excel?
a)
-
b)
*
c)
/
d)
+
87.
What is the to divide in Excel?
a)
/
b)
[
c)
-
d)
*
88.
What is the symbol to subtract in Excel?
a)
^
b)
/
c)
-
d)
=
89.
Numbers are aligned to the _______ in a cell.  
a)
Left
b)
Center
c)
Right
90.
Text (letters) are aligned to the _______ in a cell. 
a)
Left
b)
Center
c)
Right
91.
What tab do you click on to add a footer to your worksheet?
a)
File
b)
Home
c)
Insert
d)
Formula
92.
A footer appears at the __________  of a spreadsheet. 
a)
Top
b)
Bottom
93.
In the picture, why is D2 through D5 placed in paranthesis?
a)
So Excel knows to total the cells before performing the next operation.
b)
So the total of the cells can be multiplied rather than added.
94.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
95.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
96.
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
a)
relative
b)
relational
97.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
98.

What does the Average formula return?

a)

Returns the lowest argument.

b)

Returns the middle argument.

c)

Returns the three highest arguments.

d)

Returns the mean of all its arguments.

99.

What does the Max formula do?

a)

Returns the highest three values in a set of values and ignores text.

b)

Returns the largest value in a set of values and ignores text.

c)

Returns the text that you are searching for.

d)

Returns the smallest value in a set of values and ignores text.

100.

What does the Min formula return?

a)

Returns the smallest three numbers form a set and ignores text.

b)

Returns the smallest value in a set of values and ignores text.

c)

Returns the largest three numbers form a set and ignores text.

d)

Returns the largest value in a set of values and ignores text.

101.

What does the Countif formula return?

a)

Counts the number of cells within a range that meets the given condition.

b)

Counts the number of words within a range that meets the given condition.

c)

Counts the number of columns within a range that meets the given condition.

d)

Counts the number of letters within a range that meets the given condition.

102.

Which operator is used to multiply in Excel?

a)

+

b)

-

c)

/

d)

*

103.

All formulas begin with a(n) _______________.

a)

&

b)

=

c)

+

d)

#

104.

Excel will display _______________________ if the cell is not wide enough.

a)

******

b)

^^^^^

c)

######

d)

>>>>>

105.

Formulas can be copied to adjacent cells with the ____________.

a)

Fill handle

b)

PgDn Key

c)

Function key F4

d)

None of the above

106.

To edit a formula you

a)

Double-click the cell

b)

Click in the formula bar

c)

Press Esc

d)

Both A & B

107.

Answer =2+3*3-2

a)

9

b)

10

c)

11

d)

12

108.

Answer =3+5*(6-2)

a)

23

b)

32

c)

31

d)

64

109.

__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.

a)

Formula

b)

Calculation

c)

Cell address

d)

None of the above

110.

There are two types of references.

a)

Relative and Dependent

b)

Relative and Proportionate

c)

Absolute and Dominant

d)

Relative and Absolute

111.

A predefined formula that performs calculations using specific values in a particular order.

a)

Function

b)

Reference

c)

Chart

112.

Multiple arguments must be separated by a ______________.

a)

Space

b)

Comma

c)

= Sign

d)

!

Similar Resources on Wayground

Year 9 - Revision Quiz

112 questions

Year 9 - Revision Quiz

quiz

Worksheet

•

9th Grade

1.1 System Architecture GCSE OCR Computer Science

112 questions

1.1 System Architecture GCSE OCR Computer Science

quiz

Worksheet

•

9th - 12th Grade

Codehs 112 Internet

112 questions

Codehs 112 Internet

quiz

Worksheet

•

9th - 12th Grade

PLTW Computer Science

110 questions

PLTW Computer Science

quiz

Worksheet

•

9th - 12th Grade

General Knowledge Quiz

114 questions

General Knowledge Quiz

quiz

Worksheet

•

8th Grade - University

Computer Systems Revision

107 questions

Computer Systems Revision

quiz

Worksheet

•

9th Grade

Exercícios Teóricos de Excel — Extração para teste (9º ano)

110 questions

Exercícios Teóricos de Excel — Extração para teste (9º ano)

quiz

Worksheet

•

9th Grade

A1 Exam - C9 Algorithm design and problem Solving

107 questions

A1 Exam - C9 Algorithm design and problem Solving

quiz

Worksheet

•

9th - 12th Grade