NEW
Font size
WorksheetsMicrosoft Excel
Total questions: 80
Worksheet time: 40mins
Microsoft Excel is an electronic __________program.
spreadsheet
word
paint
spead
The tearm worksheet refers to the row and column ______sheet
intersection
matrix
cross
many
______________is the standard Excel document with many sheets.
worksheet
workbook
spreadsheet
cell
The intersection of a row and column is a rectangular area called a _______
workbook
cell pointer
worksheet
cell
Cell address are the combination of column _______ and row _____.
Number,Letter
Number,Number
Letter ,Number
Letter,Letter
The _________shows what you are typing in a cell.
Title bar
Name box
Formula Bar
Address bar
All formulae must begin with an____
plus sign
equal sign
dollar sign
colon
To move through your worksheet,you can use the ________
arrow keys
number keys
Space bar
control + arrow
____________are used to perform all or part of a formula.
function
party
wizard
button
AutoSum button ,inserts a _____ function in the active cell.
ADD()
PLUS()
SUM()
AUTO()
A cell is _______when the border is highlighted in blue.
Good
Slow
Auto
Active
__________ helps to insert the formula step by step.
Wizard
Function
Display
Formula
A cell contains a value,____or a text entry.
a text
a formula
excel
string
Cell address of the fifth row and seventh column is
G6
E4
G5
G7
A cell is active when the border is highlighted in ____
yellow
green
red
black
Ms Excel can do calculations.
True
False
Ms Excel is a spread sheet Program.
True
false
A workbook contains Four sheets by default.
True
False
A formula starts with a @ sign.
True
False
To select the entire worksheet we can use Ctrl + O keys.
False
True
Ms -Excel saves files with .exl extension.
False
True
The term _________ will refers to the book of pages that is the stansard Excel document.
Workbook
Logbook
Spreadsheet
Ms Excel can represent data in the form of ____
Chart
Graph
Tabular Form
All of these
Ms Excel is a window based based application.
True
False
The entire worksheet is ___________in size.
very big
very small
colourful
The default name of worsheets are untitled1,untitled2 and untitled3
True
False
Worksheets can be added but cant be renamed.
True
False
A cell address starts with the ______________
column number
row number
either a or b
Intersection of each row and column creates a ______
cell
tissue
grid
The cell ______identifies the location of each cell.
address
color
pointer
A cell address starts with alphabet.
True
False
The __________toolbar gives access to commands we frequently use,
Address bar
Title bar
Quick access toolbar
Formula bar
__________Means Rollback an action and ____________ means reapply a rolled back action.
Und0,Redo
Redo,Undo
Delete ,Backspace
_______bar displays the name of the workbook.
Title
Address
Name
The _________displays the cell address of the cell you are in.
Name box
Address bar
URL
The ________________ provides quick information such as the count ,sum,average,minimum and maximum value of selected numbers.
Status bar
title bar
quick launch toolbar
The number of worksheets in a workbook can go upto
3
1048576
16384
any limit
The number of columns in a worksheets are
16386
16384
16385
16584
The number of rows in the worksheet are ______
1048876
1038576
1048576
1026576
Column runs horizontally on a worksheet.
True
False
Rows runs horizontally on a worksheet.
True
False
Pressing the ______key anchors the cursor.
F6
F5
F8
F9
By Default ,numbers are ________aligned in a cell.
left
right
center
By Default ,text data are ________aligned in a cell.
left
right
center
Formulas are usually considered to be _______
Text
Numbers
Seperate type of data
numbers or seperate type of date
To save a workbook,
Ctrl + C
Ctrl + S
Ctrl + O
Ctrl + P
To copy the cell or data,
Ctrl + V
Ctrl + X
Ctrl + C
Ctrl + O
To select an entire worksheet,
Ctrl + V
Ctrl + C
Ctrl + O
Ctrl + A
To paste data or cells
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + Y
To undo an action
Ctrl + X
Ctrl + Z
Ctrl + Y
Ctrl + V
To redo an action
Ctrl + A
Ctrl + Z
Ctrl + X
Ctrl + Y
To open Save As dialog box ,
F12
Ctrl + S
C1trl + F12
F5
To print a worksheet
Ctrl + Q
Ctrl + P
Ctrl + Pr
Ctrl + prtscr
To insert a new row
click on
Home tab->insert->insert sheet rows
right click the selected rows and the click insert
both a and b
When deleting an entire row,
other rows automatically shift up
other rows automatically shift down
no change
If we delete an entire column,then
other columns automatically shift to the right
other columns automatically shift to the left
No change
The AutoFit Column width will change the column width to automatically fit the contents,
True
False
Adding all numbers in a contiguous row,the select all cells in the rows,then click on _________button present under the Editing group
+ Add
+ Sum
Σ AutoSum
To add all the values from B4 to F4,WE neeed to type _______ in G4 cell and then press enter key.
B4+C4+D4+E4+F4
=Sum(B4:F4)
=B4+C4+D4+E4+F4
both b and c
You can undo upto ______actions in Excel.
100
1000
10
1k
You can also ________actions that have been undone.
Autosum
Undo
Redo
_______________are predefined formulas that perform calculations by using specific values.
Wizard
Functions
Formula
________Function has been used to find the average of numbers in a given range.
AVG()
AVERAGE()
RANGE()
________Function has been used to RETURN the largest value in a set of values.
MAXIMUM()
MAX()
BIG()
NONE OF THE ABOVE
________Function has been used to RETURN the smallest value in a set of values.
SMALL()
MINIMUM()
MIN()
SMALLEST()
The default font size in Excel sheet is
11
12
13
10
The default font name in Excel sheet is
Ariel
Times New Roman
Calibri
none of the above
MS-Excel can be used for data analysis.
True
False
The size of a Worksheet which is visible on the opening screen of MS-Excel is the whole worksheet,
True
False
A workbook is a collection of
worksheets
workbook
cells
When you are in the first cell,its location is __
A
1
A1
AA
In A1,location address - A represents___
Column number
row number
both
none
____________ key moves the active cell highlight to column A without changing rows
HOME
CTRL + HOME
pg up
____________ key moves the active cell highlight to cell A 1
HOME
Ctrl + HOME
pg up
____________ key moves one column right.
->
<-
pg up
pg down
____________ key moves one column left
pg up
pg dn
<-
->
________keys moves the active cell highlight to the first row of the spread sheet.
pg up
pg dn
->
<-
_____moves the active cell highlight to the next sheet.
pg dn
pg up
->
<-
Cell address is called cell reference.
True
False
__________allow us to save an existing file in a new name.
Save
Save As
Both a and B
