NEW
Font size
WorksheetsQuiz_Adv
Total questions: 20
Worksheet time: 10mins
What is the intersection of a column and a row on a worksheet called ?
Column
Value
Address
Cell
What type of chart is useful for comparing values over categories ?
Pie Chart
Column Chart
Line Chart
Dot Graph
Which functionin Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
CHKNUM
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Filtering
Pivot
Which one is not a Function in MS Excel?
SUM
AVG
MAX
MIN
Functions in MS Excel must begin with ___
An () sign
An Equal Sign
A Plus Sign
A > Sign
Which functionin Excel checks whether a condition is true or not ?
SUM
COUNT
IF
AVERAGE
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
The process of arranging the items of a column in some sequence or order is known as :
arranging
autofill
sorting
filtering
It is a collection of data that is stored electronically as a series of records in a table
spreadsheet
presentation
database
word processing
What type of chart will you use to compare performance of sales of two products
Column Chart
Line Chart
Pie Chart
Both A and B
Which bar show the used formula of selected active cell?
Formula Bar
Ribbon
Menu Bar
Scroll Bar
formulas are mathematical statements used to calculate values
True
False
When pasting a range of cells, any existing cell contents at the new location are automatically moved to make room for the pasted data
True
False
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
The auto calculate feature
can only add values in a range of cells
provides a quick way to view the result of an arithmetic operation on a range of cells
automatically creates formulas and adds them to a worksheet
a and c
You can use drag-and-drop to embed excel worksheet data in a word document
by dragging a range of excel data to the word button on the taskbar while pressing the CTRL key
by dragging a range of excel data to the word button on the taskbar while pressing Shift Key
by dragging a range of excel data to the word button on the taskbar while pressing Alt key
none of the above
Which of the following formulas is not entered correctly?
=10+50
=B7*B1
=B7+14
10+50
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
