Font size
WorksheetsICT FS Exam
Total questions: 25
Worksheet time: 13mins
which of these are needed on every page you print in FS exam
Your Name
Your Candidate Number
Date
File name
To fit more on a page in Excel you should
Turn the page upside down
Turn the page to portrait
Turn the page to landscape
Turn the page clockwise
In Excel you should
page numbers
Turn on print grid lines
change the page colour to red
Turn the page clockwise
For the first question you normally need to
Screenshot your evidence and put it in a Word document
send your email
Find an email that has been sent
Create a Powerpoint
In the FS exam, you need to
not open the paper
send your email
Read the questions carefully
close your eyes and hope for the best
How many times do you need to print your Excel spreadsheet?
1
3
2 (One needs to show formulas)
4
When creating a chart in excel its important to include?
A description of the chart
Axis Titles
Different colours
Chart Title
Where on the Ribbon will you be able to add a chart
Data
File
Insert
Review
Why do you start a formula with an = sign?
to tell Excel you are entering a formula
just because
you are entering text
Which arithmetic operator is being used in the following formula: =T75- AA45
addition
multiplication
subtraction
format
What is the answer if the value in cell A5 is 10; and C10 is 20 and the formula is: =C10+A5
10
20
30
40
What does the / symbol do in Excel?
Divides
Multiplys
Adds
Takes away
Will this formula work D4*D6
Yes
No
Maybe
Will this formula work =E43/D64
Yes
No
Maybe
What is missing from this chart?
Numbers
Text
Axis Titles
X Axis
What is missing from this chart?
Axis Titles
Numbers
A Chart Title
Words
Which error is obtained when a formatted number does not fit within a cell?
#####
#DIV/0
#DIV@
#VALUE!
This function adds all of the values of the cells in the argument
SUM
AVERAGE
MAX
MIN
What does the AVERAGE function do?
Returns the median number in a set of values
Returns the average number in a set of values
Which functioning Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
None of these
B2:B6 is called?
cell address
sum formula
cell range
SUM, AVERAGE, IF, MIN and MAX are examples of _______.
user-defined functions
online functions
table functions
predefined functions
Function used to find the smallest number in the cell range B2 through H4
=MIN(B2:H4)
@MIN(B2:H4)
=SMALLEST(B2:H4)
=MIN(B2-H4)
Function used to find the average of the cell range H2 through J2.
@AVE(H2:J2)
=AVE(H2:J2)
=AVERAGE(H2:J2)
=AVERAGE(H2+J2)
Function used to find the average of the cell range H2 through J2.
@AVE(H2:J2)
=AVE(H2:J2)
=AVERAGE(H2:J2)
=AVERAGE(H2+J2)
