Font size
WorksheetsSpreadsheet
Total questions: 60
Worksheet time: 32mins
To select multiple non-adjacent cells in a worksheet, click in the cell while holding the
Alt key
Ctrl key
Shift key
Ctrl + Alt keys
Which of the following displays the content of the active cell?
Formula bar
Menu bar
Name box
Status bar
A cell formatted to have accounting style shows negative numbers in
bold
double quotes
brackets
parenthesis
The process of identifying specific rows or columns so that these rows or columns are always visible on the screen is
fixing
freezing
locking
selecting
In a spreadsheet, which of the following is a text function?
COUNT()
DMAX()
ROUND()
UPPER()
A red triangle at the top right corner of a cell in a spreadsheet application indicates that
the value in the cell is incorrect.
the cell cannot accept formula.
there is a comment associated with the cell.
the formula entered into the cell has an error.
Which of the following displays the name of the active cell?
Name box.
Menu bar.
formular bar.
Status bar.
When a formatted number does not fit within a cell, it displays
######
#DIV/0!
#DIV/1.
#VALUE
When one attempts to divide by zero in a worksheet, the error message displayed will be
#####
#DIV/0!
#NAME?
#NULL!
The error in #VALUE! a spreadsheet means
you are performing a mathematical operation on a cell that contains text.
you typed a space instead of a comma/semi colon in a function
you typed the wrong function name
the function cannot find the referenced data.
Which error occurs when a referenced cell in a formula does not exist?
#VALUE!
#REF
#NAME?
#N/A
Which of the following symbols is used to enter a number as text in a worksheet?
'
"
=
+
Which of the following is used for concatenation in a spreadsheet?
Ampersand
Apostrophe
Exclamation mark
Hash sign
To move to a specific cell in a worksheet, enter the name of the cell into the
formula bar
name box
search box
zoom box
Which of the following symbols is required when entering a formula or function in a worksheet?
//
#
*
=
Which of the following is not a text function?
LEN
TRIM
ROUND
LOWER
Which of the following is used for concatenation?
$
!
#
&
A grid of rows and columns is called
cell
column
table
row
To view headers and footers information in a spreadsheet, use the
web layout button
normal view button
print preview button
outline layout button
To edit header and footer information in a spreadsheet, one can use the
print preview button
normal view button
page layout button
web layout button
In a spreadsheet, a user a create a relationship between cells using
numbers
formula
parenthesis
text
The most appropriate form of graphics for presenting facts and figures information is
background
chart
flow chart
legend
Which of the following formulas will spreadsheet not be able to compute?
=SUM(scales)-A3
=SUM(A1:A5)*5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
A function inside another function in a spreadsheet is called
round function
nested function
sum function
text function
Which of the following is used for absolute cell referencing?
#
!
&
$
The function key F12 will open the _______ in a spreadsheet application.
close dialogue box
font dialogue box
open dialogue box
save as dialogue box
Which of the following commands will move the cursor to the previous worksheet?
Ctrl + Page up
Ctrl + Page down
Shift + Tab
Ctrl + Tab
Which of the following commands will move the cursor to the next worksheet?
Ctrl + Page up
Ctrl + Page down
Shift + Tab
Ctrl + Tab
Which of the following commands will move the cursor to the previous cell in a worksheet?
Ctrl + Page up
Ctrl + Page down
Shift + Tab
Ctrl + Tab
MS Excel files have the default extension
.doc
.ppt
.txt
.xls
Which of the following applications uses cells?
QBASIC
Spreadsheet software
Presentation software
Communication software
Which of following terms is not a valid data type in a spreadsheet application?
Character
DATE
Number
Text
It is acceptable to let long text flow into adjacent cells on a worksheet when
there is no time to format the text.
data will be entered into the adjacent cell.
there is no data suitable abbreviation of the text.
no data will be entered into the adjacent cells.
Which of the following methods cannot be used to enter data into a spreadsheet cell?
Pressing an arrow key
Pressing the Tab Key
Pressing the Esc key
Clicking on the formula bar
The symbol that precedes a number to make it a label in spreadsheet applications is
quote sign
equal to sign
underscore
apostrophe
What will be the result of =today()+7 in a worksheet if the current date is 21 March, 2023?
14 March, 2023
28 March, 2023
21 March, 2030
21 March, 2016
To calculate the product of all the numbers in the worksheet, use the formula
=PRODUCT(A1:C1)
=PRODUCT(A1:C4)
=PRODUCT(A1,C4)
=PRODUCT(A1;C4)
To calculate the average of all the numbers in the worksheet, use the formula
=AVERAGE(A1:B4)
=AVERAGE(A4:C4)
=AVERAGE(C4:A1)
=PRODUCT(A1:C4)/12
The term "what if" analysis is associated with
database applications
desktop publishing applications
spreadsheet applications
word processing applications
Which of the following statements are true about gridlines in a spreadsheet?
select all that apply
Gridlines may be turned off for display but turned on for printing.
gridlines may be turned on or off for printing
gridlines may be turned off for display and printing
Which of the following formulas will spreadsheet not be able to compute?
=SUM(Sales)-A3
=SUM(A1:A5)*5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Which of the following formulas will display the current minutes part of the hour of the clock in a spreadsheet application?
=MINUTE()
=MINUTE(NOW())
=MINUTE(YEAR())
=MINUTE(HOUR(NOW()))
The comment function in a spreadsheet application is used to
(select all that apply)
take and attach notes to cells
remind the user of complex formulas
provide feedback to others
Which of the following formulas will display the present calender month in a spreadsheet application?
=TODAY()
=MONTH()
=MONTH(NOW())
=TODAY(MONTH())
Spreadsheet Software is a program that lets you organize data in rows and columns.
TRUE
FALSE
Which is the icon for MS Excel?
Spreadsheet is used by accountant and teacher.
TRUE
FALSE
Spreadsheet can perform calculations.
TRUE
FALSE
Which one is the FORMULA BAR?
What do you call the document created using spreadsheet program?
WORKBOOK
DOCUMENT
Match the following spreadsheet error to its description.
#NUM!
When the data in the cell is too wide to fit in the column
####
When your formula or data contain invalid numeric values .
#REF
This error arises due to a reference missing.
#Name?
It is wrong supply of the value to the required parameters.
#NULL!
When the text in the formula is not recognized
True or False.
In the IF function, you can decide both the return values and the condition.
TRUE
FALSE
True or False
If you try to divide the number by zero or vice versa it will give you a
#DIV/! error.
TRUE
FALSE
It is #DIV/0?
FALSE
It is #DIV/0!
FALSE
It is #DIV
Text values in the formula needs to be in parenthesis ( ).
True
False
in quotes " "
False
in comma ,
False
in semicolon ;
In OR Function, the result is TRUE if
all the conditions are TRUE
if one of the condition is TRUE
if all the conditions is false
Which is the correct syntax of IF Function?
IF(LOGICAL TEST,"true","false")
=(IF LOGICAL TEST,"true","false")
=IF("true","false")
=IF(LOGICAL TEST,"true","false")
True or False.
Every function in Excel requires an opening and closing parenthesis ().
TRUE
FALSE
it requires comma only
FALSE
it is not required as long as the formula have an equal sign
Which of the following best describes the Nested If?
one IF function inside of another
one logical test with multiple results
multiple logical tests with a single result
to evaluate one condition in different value
Which of the following is used when you want to reference a cell from a different worksheet in the same workbook?
#
&
!
$
