Free Printable N5 AIT - Spreadsheets Quiz

Worksheets

N5 AIT - Spreadsheets Quiz

Total questions: 15

Worksheet time: 8mins

Name

Class

Date

An individual box within a worksheet is known as?

square

range

reference

cell

What is normally used to perform calculations in a spreadsheet?

Variable

Formula

Conditional formating

Macro

In Excel, what do all formula begin with?

What must bar charts have? Tick all that apply!

Heading (in caps)

Pie chart

Axis Labels

Heading (in lower case)

We can use this function to count the number of cells containing words/letters

=COUNTA

=COUNTW

=COUNT

=COUNTN

We can use this function to perform a 'logical test' where the answer is a TRUE or FALSE outcome

=MAYBE

=WHEN

=LOGIC

=IF

We can use this function to add more than 2 cells together

=ADD

=SUM

=ANSWER

=COUNT

We can use this function to find the highest number in a range of cells

=MAX

=MIN

=HIGHEST

=LARGEST

When printing in value view we must show

Row and column headings only

Grid lines and row and column headings

Grid lines only

A blank background

10.

When printing in formula view we must show

Row and column headings only

Grid lines and row and column headings

Grid lines only

A blank background

11.

Which of the following is a valid formula?

=C7*C8

=(C7\C8)

=(C7xC8)

=AVERAGE(C7*C8)

12.

Which of the following is a valid formula?

=sum(A1:A6)

sum=(A1:A6)

=sum[A1:A6]

=sum(A1,A6)

13.

Which formula would display "Yes" if D13 is greater than 0?

=IF(D13>0,"Yes","No")

=IF(D13<0,"Yes","No")

=IF(D13>0:"Yes","No")

=IF(D13<0:"Yes","No")

14.

Which formula would subtract D12 from D13?

=D13-D12

=D12-D13

=sum(D12-D13)

=sum(D13-D12)

15.

Which is NOT a formula?

b2+b3+b4

=b1+b2+b3

=b4*c4

=b5/b7

100 %

N5 AIT - Spreadsheets Quiz

Total questions: 15

Worksheet time: 8mins

Similar Resources on Wayground