wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Introduction

Total questions: 60

Worksheet time: 33mins

Name
Class
Date
1.

The following are spreadsheet software except?

a)

Quickbooks

b)

Peachtree

c)

Microsoft Excel

d)

CorelDraw

2.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
3.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
4.
A spreadsheet is made of cells organised into horizontal rows and vertical?
a)
Columns
b)
Fields
c)
Records
d)
Blocks
5.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
6.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
7.

Which of the images below represent Microsoft Excel work environment ?

a)
b)
c)
d)
8.

Which of these options is a spreadsheet feature?

a)

Formulas

b)

Slides

c)

Pages

d)

Images

9.

The pages of a spreadsheet application is called____________

a)

slides

b)

pages

c)

sheets

d)

document

10.

Which of these options is a step to launching Microsoft Excel

a)

Locate and left click start button or press windows key on the keyboard

b)

Use the Shift + windows key

c)

Press the enter key and type Microsoft Excel

d)

Press F2 and Enter key

11.

Excel is a (a)   program that allows you to store, organize, and analyze information.

12.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
13.

A spreadsheet is a software made of cells for entering text and number to make calculations?

a)

True

b)

False

14.

Is an intersection of row and column

a)

row

b)

cell address

c)

cell

d)

column

15.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
16.
In Excel, what is this button used for? 
a)
To change the color of the background 
b)
To change the font color
c)
That button is not used in Excel
d)
To fill the cell with a color
17.

These go from top to bottom (vertically)

a)

rows

b)

columns

c)

tables

18.

These go from side to side (horizontally)

a)

rows

b)

columns

c)

tables

19.

When one open Microsoft Excel, a Workbook contains how many sheets?

a)

1

b)

2

c)

3

d)

4

20.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
21.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
22.
Classification used for cells that contain text or for numbers that will not be used in calculations
a)
Label
b)
Value
c)
Formula
d)
Function
23.
This classification indicates that the data has the potential to be used in calculations.
a)
Label
b)
Value
c)
Formula
d)
Function
24.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
25.
All formulas and functions begin with...
a)
=
b)
SUM
c)
Labels
d)
Text
26.
This function adds the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
27.
This function determines the average of the range of cells 
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
28.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
29.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
30.

If you wanted to change the size of the text inside a cell which tool would you use?

a)

Cell width

b)

Cell height

c)

Text colour

d)

Font size

31.

Something that automatically calculates something for you using the data in cells is a:

a)

Formula

b)

Formatting

32.

What do all formulae start with in a spreadsheet?

a)

+

b)

/

c)

*

d)

=

33.

Which mathematical operator (symbol) would you use if you are adding the values in cells together?

a)

/

b)

-

c)

+

d)

=

34.

Which mathematical operator (symbol) would you use to divide the values in two cells?

a)

/

b)

-

c)

*

d)

=

35.

Which mathematical operator (symbol) would you use to multiply the values in two cells together?

a)

/

b)

-

c)

*

d)

=

36.

To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?

a)

Item

b)

Price

c)

Number Sold

d)

Total

37.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta

a)

£1.25 times 12

b)

C5*D5

c)

=C5*D5

38.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Walkers salt and vinegar.

a)

£0.65 times 23

b)

C10 * D10

c)

=C10 * D10

39.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
40.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
41.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
42.
 After entering the number of sales for the first quarter, where will they align? 
a)
  Right 
b)
  Left  
c)
  Centered
d)
  Justified
43.
 A sales manager has requested the highest sale for the first quarter. Which function will be used? 
a)
  SUM 
b)
  MIN
c)
  MAX
d)
  AVG
44.
 A sales manager has requested the lowest sale for the first quarter. Which function will be used? 
a)
 SUM  
b)
  MIN
c)
 MAX
d)
  AVG
45.
Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer? 
a)
 Label
b)
 Value
c)
 Formula 
d)
 Function
46.
 Paul has to enter a unit price for a product. How will this data be classified? 
a)
 Label 
b)
 Value 
c)
  Formula 
d)
 Function
47.
 ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?   
a)
A.  Row
b)
B.  Column
c)
C.  Entry
d)
D.  Cell address
48.

A range is a -

a)

Group of cells in a powerpoint

b)

Group of cells in workbook

c)

Group of cells in a notebook

d)

Group of cells in a worksheet

49.

Cell address is a combination of -

a)

Column number and Row letter

b)

Column letter and Row number

c)

Column letter and Column number

d)

Row letter and Row number

50.

A range in a worksheet can be recognised only in that worksheet -

a)

TRUE

b)

FALSE

51.

Rules for naming a range -

a)

Names can be the same as the formula used

b)

First character must be a letter, backlash or underscore

c)

Maximum length will be 1000

d)

Spaces are allowed within the names

52.

Example of chart elements -

a)

Legend

b)

Column chart

c)

Chart area

d)

Bar chart

53.

What feature was used to center the heading “The Small Bookstore”?

a)

Center

b)

Merge and center

c)

Merge

d)

Wrap text

54.

When a Spreadsheet is printed the gridlines are not automatically printed. What feature is used to get the gridlines as seen in the Spreadsheet above?

a)

add gridlines

b)

style

c)

borders

d)

table

55.

What cell alignment feature is used so that the text looks like this?

a)

Merge and center

b)

Center

c)

Wrap Text

d)

Alignment

56.

If the table is sorted in Ascending order by Classification, state the title of the book that will appear at the top from the list given below

a)

In Touch with God

b)

Eagle and the Falcon

c)

The Dark Side

d)

Outer Plant Experience

57.

What is the number format of the values in the column Unit cost?

a)

text

b)

currency

c)

number

d)

two decimal places

58.

What is the format of the content in the column, "Title"?

a)

text

b)

currency

c)

number

d)

accounting

59.

What is the formula in Excel to calculate the Total cost of the book entitled Apocalypse using relative cell referencing?

a)

24 * $51.00 =

b)

= 24 * $51.00

c)

E5 * F5 =

d)

=E5 * F5

e)

= E5 x F5

60.

Type the formula in Excel to calculate the Total number of copies sold by the author James Brown. Use CAPS lock when typing your answer.

(a)  

Similar Resources on Wayground

Form 1 Pre-Test Computer Basics

60 questions

Form 1 Pre-Test Computer Basics

quiz

Worksheet

•

3rd - 12th Grade

COmputer CH 2

58 questions

COmputer CH 2

quiz

Worksheet

•

1st Grade - University

YUVA-TALENT HUNT 2021-GROUP A

60 questions

YUVA-TALENT HUNT 2021-GROUP A

quiz

Worksheet

•

3rd - 5th Grade

Precocious Quiz

60 questions

Precocious Quiz

quiz

Worksheet

•

3rd - 5th Grade

Tin học 11-Câu hỏi ôn tập

55 questions

Tin học 11-Câu hỏi ôn tập

quiz

Worksheet

•

1st - 5th Grade

G4 Scratch Review

64 questions

G4 Scratch Review

quiz

Worksheet

•

4th Grade

4th Computer quiz

55 questions

4th Computer quiz

quiz

Worksheet

•

4th Grade

PH INFOR KELAS X

56 questions

PH INFOR KELAS X

quiz

Worksheet

•

2nd Grade - University