NEW
Font size
WorksheetsICT EXAM REVIEW
Total questions: 25
Worksheet time: 13mins
A spreadsheet application used to perform complex calculations is called
Microsoft Excel
Microsoft Word
Microsoft PowerPoint
Microsoft Access
Microsoft Excel was created to do all the following to data except?
Store/ save
Manipulate/ change
Organize/ sort
Corrupt/ hid
The area on the worksheet where data is entered is referred to as a
Square
box
Cell
rectangle
Microsoft Excel can be used to complete which of the following tasks?
Statistics
Budgeting
Stock-keeping
All of the above
Which of the following is not a part of the Microsoft Excel screen?
Ribbon
Status bar
Start button
Formula bar
In a Microsoft Excel spreadsheet, a cell is formed when…………
columns and scroll bars meet
rows and numbers meet
columns and letters meet
columns and rows meet
The formula bar shows.....
Common icons used in the spreadsheet
Document name
Activities being performed in the spreadsheet
The content of the active cell
A row is identified using.......
Letters
Numbers
Letters and numbers
All of the above
Which direction are columns listed in the spreadsheet?
Horizontally
Vertically
Diagonally
All of the above
A cell reference/ name is made up of……...
column number and row letter
rows only
column letter and row number
columns only
Which of the following is NOT an ADVANTAGE of using Microsoft Excel?
The ability to format so it looks professional
The ability to create graphs and charts
The ability to insert a video
The ability to perform error-free calculations
Which of the following is NOT a DISADVANTAGE of Microsoft Excel?
Training is needed to use the program
Data can be e-mailed
Data may be lost
Data may be corupted
An example of a cell reference is
A22
22A
22AB
AB
An electronic spreadsheet can be secured with passwords.
True
False
An advantage of an electronic spreadsheet is that it can't be sent through e-mail
True
False
Computer viruses can cause you to lose your data in an electronic spreadsheet.
True
False
Microsoft Excel is used to create posters.
True
False
Microsoft Excel is used to create charts and graphs.
True
False
Microsoft Excel is used to only store and delete data
True
False
A ___________ is a mathematical equation used to perform calculations on spreadsheet data.
module
subtraction
function
average
A function is a type of _________ used in Microsoft Excel.
Module
Formula
spreadsheet
Worksheet
Which of the following is an example of a function?
=(A4*B4)
=Count(A4*B4)
=(C3:D3)
=Sum(A4:B4)
Which of the following is a correct example using the SUM function?
Sum(D14:D19)
=Sum(D14:D19)
=D14:D19
=D14+D15+D16+D17+D18+D19
Which function finds the smallest number in a range of cells F4 to H7?
=MIN(F4:H7)
=COUNT(F4:H7)
=MAX(F4:H7)
=SUM(F4:H7)
=MAX (B8:D10) will perform which of the following functions?
Find the lowest number in a range
Find the value of the range
Find the number of cells with a value
Find the biggest number in a range
