Font size
WorksheetsMS EXCEL
Total questions: 20
Worksheet time: 11mins
Ribbon is a collection of_____________ tabs
Ten
Eight
Four
Five
Key combination to move to the adjacent cell on the left
Shift + Tab
Ctrl + Home
Ctrl + G
Tab that provides the facility for sorting
(a)
Title bar
Quick acces toolbar
Formula bar
What is IF?
Takes 3 arguments
Checks a condition takes a suitable action
Collection of unarranged facts
Task that is performed to produce a result
Evaluate condition such as x > 5 and give the result as true or false
text function
financial function
logical function
the shorthand used by Microsoft to refer to excel is
(a)
Microsoft originally marketed spreadsheet program called__________
Multiplan
Built in functions
Arguments
a formula in Excel always begins with ________symbol
=
+
#
The columns are named using the (a)
Data in a cell is a
Text
Symbol
Number
Formula
Name the Element where the mouse is pointed
worksheet
ribbon
formula bar
appears at the bottom right corner of almost every command group
tabs
command button
dialog box launcher
The command that takes existing cell entries and replicates them in other cells is called__________
cut
paste
copy
redo
In Excel, Rows are labelled as ______
1,2,3
A,B,C
A1, A2
The process of arranging the items of a column in some sequence or order is known as
database
sorting
autofill
Which one is not a Function in MS Excel ?
SUM
AVG
MAX
MIN
What is the intersection of a column and a row on a worksheet called ?
Cell
Column
Address
Statistical calculations and preparation of tables and graphs can be done using
Excel
Power point
Word
function that helps us to locate specific values in specific cells
look and reference function
information function
database function
