wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Lesson 1 Quiz: Spreadsheets using Excel

Total questions: 45

Worksheet time: 15mins

Name
Class
Date
1.
Rio wants to create an attendance sheet for her class. The worksheet includes the names of the students, class number and dates for the school days. What data type will not be of used for the said worksheet?
a)
Numbers
b)
Texts
c)
Date and Time
d)
Currency
2.
This data type can be any type like whole integers or with decimals.
a)
Numbers
b)
Date and Time
c)
Text
d)
Currency
3.
This data type is used to label values or sometimes part of data.
a)
Numbers
b)
Texts
c)
Date and Time
d)
Currency
4.
Alfred is calculating his monthly budget for the month of October. What data type will he used for the value of money?
a)
Number
b)
Text
c)
Currency
d)
Date and Time
5.
What data type is used in the labels for the given worksheet?
a)
Number
b)
Text
c)
Currency
d)
Date and Time
6.

What is the cell address of the red cell?

a)

F6

b)

6F

c)

E6

d)

F7

7.

What is the cell address of the red cell?

a)

A1

b)

1A

c)

C3

d)

3C

8.
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
9.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
10.

A cell is the intersection of a row and column?

a)

True

b)

False

11.

Multiplication symbol in Microsoft Excel

a)

&

b)

*

c)

^

12.

Rows are__________groups of cells.

a)

Diagonal

b)

Horizontal

c)

Slant

d)

Vertical

13.

Letters and ______ are accepted as contents of the cell.

a)

Numbers

b)

Letters

c)

Words

d)

Symbols

14.

The Filter function icon can be found in _____________ tab.

a)

Home

b)

Insert

c)

Data

d)

View

15.

The ______________ function is used to determine how many pupils were able to get a passing score in a test.

a)

COUNT

b)

COUNTA

c)

IF

d)

COUNTBLANK

16.

What function Is used to find the highest data ?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

17.

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

a)

@

b)

=

c)

'

d)

#

18.

The function that lets you add up a range of cells or values

a)

AVERAGE

b)

SUM

c)

MIN

d)

MAX

19.

What's the Operation?

/

a)

Subtraction

b)

Multiplication

c)

Addition

d)

Division

20.

What's the Operation?

+

a)

Subtraction

b)

Multiplication

c)

Addition

d)

Division

21.

Which of the following shows the accurate formula to determine the total budget?

a)

=1+2

b)

=B3

c)

=A1+A2

d)

=B1+B2

22.

What cell contains an Excel formula?

a)

A4

b)

B4

c)

C4

d)

D4

23.

What is the cell range of the yellow highlighted cells?

a)

C1:C3

b)

C1:D3

c)

D3:C1

d)

D1:D3

24.

What cell contains the word Excel?

a)

A4

b)

B4

c)

C4

d)

D4

25.
What is the first operation you need to perform in the problem shown?
a)
addition
b)
subtraction
c)
parenthesis
d)
exponents
26.
In PEMDAS, what does the M stand for?
a)
Masterful
b)
Mad
c)
Math
d)
Multiplication
27.
Solve the problem shown
a)
4
b)
11
c)
24
d)
10
28.

Which is an example of a Comparison Operator?

a)

>

b)

*

c)

/

29.

Which of the formula's would output the price of the CHEAPEST item in the bakery?

a)

=MIN(B2:B7)

b)

=LOW(B2:B7)

c)

=SML(B2:B7)

d)

=BOTTOM(B2:B7)

30.

Which of the formula's would output the price of the MOST EXPENSIVE item in the bakery?

a)

=MAX(B2:B7)

b)

=HIGH(B2:B7)

c)

=LRG(B2:B7)

d)

=TOP(B2:B7)

31.

Answer =2+3*3-2

a)

9

b)

10

c)

11

d)

12

32.

Which formula will calculate the average?

a)

average

b)

countif

c)

averageif

d)

sumif

33.

What feature is particularly useful when you want to add all numbers in a row or column

a)

Autosum

b)

Product

c)

Operators

d)

Hierarchy

34.

Liam is working on a budget spreadsheet in Excel, but he encounters an issue when he tries to calculate the total expenses. What is the error value that is displayed on Excel when the formula contains invalid data?

a)

Autosum

b)

#VALUE!

c)

Arguments

d)

operators

35.
Which formula appears when you click the AUTOSUM button?
a)
=SUM
b)
=AUTOSUM()
c)
=SUM()
d)
=AUTOSUM
36.
To accept a formula in a cell, press the _________ key.  
a)
Tab
b)
Enter
c)
Ctrl
d)
Shift
37.

In Excel, columns are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

38.

Excel refers to files as

a)

Databases

b)

Workbook

c)

Document

39.

(a)   calculates the sum of the values of a range of a cell

40.

(a)   calculates the arithmetic Mean of a range of values.

41.

(a)   gives the maximum value in a range of cells or values

42.

(a)   shows a series of calculations using the same formula but a different value for each calculation to determine whether the formula is true or false.

43.

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

44.

If you want to compare parts to the whole, which type of graph/chart would work the best?

a)

Pie

b)

Bar

c)

Column

d)

Line

45.

Identify the formula for

IF

a)

=IF(logical_test, [value_if_true], [value_if_false])

b)

=IF(logical_test, [value_if_true], [value_if_true])

c)

=IF(logical_test, [value_if_false], [value_if_false])

d)

=IF([value_if_true], [value_if_false], logical_test)

Similar Resources on Wayground

OBJECT ORIENTED ANALYSIS DESIGN

50 questions

OBJECT ORIENTED ANALYSIS DESIGN

quiz

Worksheet

•

University

MSP430

40 questions

MSP430

quiz

Worksheet

•

12th Grade - Professi...

CSC 209 Graphics and Visual Computing MIDTERM EXAM

47 questions

CSC 209 Graphics and Visual Computing MIDTERM EXAM

quiz

Worksheet

•

University

server installation

40 questions

server installation

quiz

Worksheet

•

1st Grade - University

Midterm Examination (II-BINS)

50 questions

Midterm Examination (II-BINS)

quiz

Worksheet

•

University

Excel

40 questions

Excel

quiz

Worksheet

•

1st Grade - University

Neuro Foundation Final Assessment Quiz

50 questions

Neuro Foundation Final Assessment Quiz

quiz

Worksheet

•

University