Spreadsheet

Is this your test? Login to manage it. If not, you can generate a quiz just like it.

This is a non-interactive preview of the quiz content.

1 point

A range in Excel refers to

the distance from one cell to another

a set of cells merged together

a series of cells

the cell at the top of the sheet

1 point

Which of the following only counts numbers?

count

counta

countif

countblank

1 point

A spreadsheet program is used for

typing documents

creating websites

calculations

editing images

1 point

The intersection of a row and a column is called a

cell

sheet

range

label

1 point

Which of the following is not a type of chart in Excel?

line

column

gantt

pie

1 point

which of the following have used the comma formatting option?

$1,230

1.230

1230.00

1,230

1 point

The rows in a spreadsheet are represented by

letters

characters

rectangles

numbers

1 point

The columns in a spreadsheet are represented by

rectangles

characters

numbers

letters

1 point

How would I find the total of the values in cells D3 to D10?

=sum(D3:D10)

=D3+D4+D5+D10

=sum(D3 - D10)

=total(D3:D10)

10.

1 point

Cell A7 refers to

column A, row 7

From A1 to A7

column 7, row A

Sheet A7

11.

1 point

Which of the following represent cells A2 to A10?

A2:A10

A2-A10

A2 to A10

A2A10

12.

1 point

Which of the following formulae use absolute referencing?

= A2 + B1

=$B$1 + A2

=B1 + A2

= sum(b1:A2)

13.

1 point

Spreadsheets are divided into

rows and columns

pags

columns and numbers

rows and letters

Home Features Pricing FAQs Legal Sample Tests Build a Test Login/Sign Up