WorksheetsSpreadsheets
Total questions: 25
Worksheet time: 14mins
The term used to describe text in a spreadsheet that is aligned towards left by default is ________
value formulate
headings
labels
values
Which of the following is the default justification of numbers in spreadsheets?
Left
Full
Center
Right
When a cell from a spreadsheet is absolute referenced
its value become constant
its cell address becomes constant
its label becomes constant
its cell value changes automatically
Spreadsheet formulae use
values, labels or cell addresses
values, mathematical operators or cell addresses
labels or cell addresses
values or cell addresses
Which formula is written correctly?
C2-D2=
=C2-F2
=D2-2C
=2F-D2
All of the following tabs can be found in a spreadsheet EXCEPT
home
data
create
Insert
Select the three (3) types of data that can be enter in a spreadsheet
label
formula
reference
value
cell
What is represented by letters in a spreadsheet?
row
column
workbook
sheets
What is represented by numbers in a spreadsheet?
row
column
workbook
sheets
Which symbol is used to represent absolute addressing?
#
@
%
$
What does the following symbols mean in a spreadsheet : #####
the figure are incorrect
there is not enough space to display the figure in the cell
the formula is incorrect
none of the responses
B2:F4 is considered a/an
combination
cell range
function
equation
An active cell can be define as the
cell that has been deleted
cell that is not included in the formula
cell that is currently being edited or worked on
All of the other responses
Every formula MUST begin with a/an
equal sign (=)
number sign (#)
dollar sign ($)
comma (,)
Charts can be found in which tab in a spreadsheet?
page layout
insert
home
review
What is the formula for a VLOOKUP function?
=VLOOKUP( value, table, index_number, [approximate_match] )
=VLOOKUP( table,value, index_number, [approximate_match] )
( table,value, index_number, [approximate_match] )= VLOOKUP
=( table,value, index_number, [approximate_match] )
What does the V stands for in VLOOKUP?
volume
value
vertical
vibrate
=If(S4>70, "Accepted","Denied" ). Using the following formula, if Mykal received 80 points on his College Diagnostic Test what would he see for his results?
Denied
80 Points
Accepted
=If(S4>70, "Accepted","Denied" )
A cell is
an active cell
an intersection between a column and a row
a border around a cell
a relative cell
A cell address/reference is made up of
formula
built-in functions
built-in functions
column heading and row number
SUM, MAX, MIN, AVERGAE are all:
formula
functions
equations
cell addresses
Spreadsheets are used for? Select all that applies
prepare budgets
creating queries
typing documents
prepare financial statements
analyze and calculate numbers
The following symbol in spreadsheet is called:
sum
calculator
autosum
function
If data in one area of the spreadsheet is changed, the adjustments are made automatically to the other area. This feature is called
automatic re-calculation
autosum
adjustment
none of these responses
What would be the name of the feature used to fill column C and D in the diagram?
addition
autofill
function
SUM
