Font size
WorksheetsExcel Revision-TR Nandar(2024)
Total questions: 50
Worksheet time: 30mins
A column is represented by ________?
Numbers
Letters
Lines
Cells
Rows are represented by ______?
Letters
Numbers
Cells
Numbers and Letters
What does a formula always begin with?
Equals symbol =
Addition symbol +
Exclamation Symbol !
Minus symbol -
A file which contains one or more worksheets is a :
Cells
Active cell
Spreadsheet
Workbook
An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form is called:
Workbook
Active cells
Cell range
Spreadsheet
The intersection of a column and a row in a table or worksheet.
cell
Chart
row
column
The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of a formula).
Formula Bar
worksheet
Name Box
formula
The cell reference area located below the Ribbon, which displays the cell reference of the active cell.
Name Box
cell
workbook
row
When a formatted number does not fit within a cell, it displays
######
#DIV/0!
#DIV/1.
#VALUE
MS Excel files have the default extension
.xls
.doc
.ppt
.txt
To calculate the average of all the numbers in the worksheet, use the formula
=AVERAGE(A1:C4)
=PRODUCT(A1:C4)/12
=AVERAGE(C1:C4)
=AVERAGE(A4:C4)
What is the cell in the worksheet in which you can type data?
Open Cell
Absolute Cell
Main Cell
Active Cell
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
worksheet
range
spreadsheet
Chart
The horizontal placement of cells in a table or worksheet.
row
range
column
cell
What is the cell reference for Red?
(a)
What is the cell reference for Green?
(a)
What is the cell reference for Yellow?
(a)
What is the cell reference for Blue?
(a)
What is the cell range for the table?
(a)
A group of selected cells is called the
Range
Cell Block
Multi-cell
Active cell
John bought 8 bags of apples. Each bag has 25 apples in it. How many apple did John buy?
(a)
There are 35 apples on the tree. 13 apples on the ground. How many apples are there in all?
(a)
How many cells are merged?
(a)
Write AutoSum formula.
(a)
Write Total (AutoSum) formula.
(a)
The ........................... function finds the largest number in the given range.
=MAX( )
MAX( )
=MIN( )
=SUM( )
If you see a series of "######" in a cell, that means the following:
The column width is not wide enough
You keyed in an incorrect number
The row height is too high
The text is incorrectly spelled
Cells are identified by the following:
Row Number Only
Column Letter followed by their Row Number
Row Number followed by their Column Letter
Column Letter Only
Microsoft Excel is what type of software?
Word Processing
Presentation
Drawing
Spreadsheet
To auto adjust column or row size, -- between the headings.
Double Click
Left Click
Right Click
Click
The location of a cell is called the cell__.
Coordinates
Reference
Location
Position
To center a title across multiple cells in the spreadsheet use
Wrap Text
Center
Split Cell and Center
Merge and Center
Information in an active cell also appears in the __.
Formula bar
Name box
Entry bar
Title bar
Which image show the pointer used to select or highlight?
Which image show the pointer used to copy the data or formula and fill information to other cells?
Which image show the pointer used to resize columns?
Which of the following would NOT be considered a basic function?
Sum
Average
Minimum
Add
Which shortcut is used to add the numbers?
Which shortcut is used to add a border around spreadsheet cells?
What function will tell you the lowest numbers in a range?
MIN
=MIN( )
=MAX( )
=SUM( )
Write a FORMULA or FUNCTION for the following:
Add cells A1 and B1
A1 + B1
=A1 + B1
=SUM(A1+B1)
SUM(A1+B1)
Write a FORMULA or FUNCTION for the following:
Add a range of cells C4 to C15
=SUM(C4:C15)
SUM(C4:C15)
=SUM C4:C15
=ADD(C4:C15)
Write a FORMULA or FUNCTION for the following:
Multiply cells A1 and B1
A1 * B
=A1 * B1
MULTIPLY(A1:B1)
=A1 x B1
Write a FORMULA or FUNCTION for the following:
Find the average of the range of cells C1 through C20.
=AVERAGE(C1:C20)
AVERAGE(C1:C20)
=AVG C1:C15
=AVERAGE C1:C15
Write a FORMULA or FUNCTION for the following:
Find the smallest number in the range of cells C1 through C20.
MAX(C1:C20)
=LARGEST(C1:C15)
=MAX C1:C15
=MIN(C1:C20)
Write a FORMULA or FUNCTION for the following:
Find the largest number in the range of cells C1 through C20.
MAX(C1:C20)
=LARGEST(C1:C15)
=MAX (C1:C20)
=MIN(C1:C20)
What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
Which of these symbols is used to do a division on a computer?
\
|
/
*
Excel file extension is
.docx
.xlsx
.pptx
.sb3
Excel is a ............................
workbook
notebook
worksheet
document
