-
question_answer1)
Which one of the following is NOT a function of MS-Excel?
A)
AVERAGE done
clear
B)
ADD done
clear
C)
MAX done
clear
D)
MIN done
clear
View Solution play_arrow
-
question_answer2)
Which of these icons of MS Excels standard tool bar depicts Auto sum function?
A)
B)
C)
D)
View Solution play_arrow
-
question_answer3)
The spreadsheet given is used for recording (he rental fee for each student in the middle school band.
How is the total cost per year for all the instruments calculated?
A)
By adding cells C7 through E7 done
clear
B)
By adding cells C2 through C6 done
clear
C)
By adding cells E2 through E6 done
clear
D)
By adding cells D2 through D6 done
clear
View Solution play_arrow
-
question_answer4)
Observe the excel worksheet given.
Which of the following gives the average of rekha?s marks?
A)
Average (B3 : F3) done
clear
B)
Average (B3 : F5) done
clear
C)
Average (G1 : G3) done
clear
D)
Average (B1 : B3) done
clear
View Solution play_arrow
-
question_answer5)
What action is performed in window 1 to get window 2?
A)
Deleted the selected cells done
clear
B)
Moved the selected cells done
clear
C)
Copied the selected cells done
clear
D)
Inserted new row a column done
clear
View Solution play_arrow
-
question_answer6)
Find the correct order of precedence.
A)
^, *, /, ( ) done
clear
B)
^, +, /, ( ) done
clear
C)
( ), ^, *, t done
clear
D)
*, ^, ( ), - done
clear
View Solution play_arrow
-
question_answer7)
What is the function of Max ( )?
A)
It finds the average value of the given cell range. done
clear
B)
It finds the minimum value of the given cell range. done
clear
C)
It finds the maximum value of the given cell range. done
clear
D)
It finds the total value of the given cell range. done
clear
View Solution play_arrow
-
question_answer8)
How do you insert today's date in the document while working with MS-Excel?
A)
Ctrl + ?(single quote) done
clear
B)
Ctrl +; (semi colon) done
clear
C)
Ctrl +. (Dot) done
clear
D)
Ctrl +! (Exclamation) done
clear
View Solution play_arrow
-
question_answer9)
Which function returns min value of the given cell range?
A)
Max ( ) done
clear
B)
Sum ( ) done
clear
C)
Average ( ) done
clear
D)
Min ( ) done
clear
View Solution play_arrow
-
question_answer10)
To find Max value of the total marks of all the 4 students, which of these functions will you apply?
A)
Max (E2 : E5) done
clear
B)
Max (B5 : E5) done
clear
C)
Min (E2 : E5) done
clear
D)
Min (B5 : E5) done
clear
View Solution play_arrow
-
question_answer11)
What are predefined formulae in MS-Excel called?
A)
Range done
clear
B)
Parentheses done
clear
C)
Operators done
clear
D)
Function done
clear
View Solution play_arrow
-
question_answer12)
What is the icon of MS Excel marked X called?
A)
Paste function done
clear
B)
Auto sum done
clear
C)
Auto fill done
clear
D)
Insert function done
clear
View Solution play_arrow
-
question_answer13)
What is the default row height in an MS-Excel worksheet?
A)
12.75 points done
clear
B)
10.75 points done
clear
C)
11.75 points done
clear
D)
13. 75 points done
clear
View Solution play_arrow
-
question_answer14)
What is the default column width of an MS-Excel worksheet?
A)
8.25 points done
clear
B)
12.75 points done
clear
C)
8.43 points done
clear
D)
12.83 points done
clear
View Solution play_arrow
-
question_answer15)
What are the steps to change the column width of an MS-Excel worksheet?
A)
Format \[\to \] Column \[\to \] Width done
clear
B)
View \[\to \] Column \[\to \] Width done
clear
C)
Tools \[\to \] Column \[\to \] Width done
clear
D)
Inserts \[\to \] Column \[\to \] Width done
clear
View Solution play_arrow
-
question_answer16)
Command allows the user to reverse the last action.
A)
Redo done
clear
B)
Undo done
clear
C)
Repeat done
clear
D)
Copy done
clear
View Solution play_arrow
-
question_answer17)
Which of the following icons of the standard tool bar is X?
A)
Redo done
clear
B)
Undo done
clear
C)
Cut done
clear
D)
Paste done
clear
View Solution play_arrow
-
question_answer18)
What is the function of redo command?
A)
It can redo the previously undone actions. done
clear
B)
It can undo the redone actions. done
clear
C)
It can clear the desired data. done
clear
D)
It can open the previously closed document. done
clear
View Solution play_arrow
-
question_answer19)
What is the shortcut key combination of redo function?
A)
Ctrl + Z done
clear
B)
Ctrl + X done
clear
C)
Ctrl + Y done
clear
D)
Ctrl + V done
clear
View Solution play_arrow
-
question_answer20)
Using menu options, what are the steps used to perform copy and paste function?
A)
Edit \[\to \] Copy and Edit \[\to \] Paste done
clear
B)
File \[\to \] Copy and Edit \[\to \] Paste done
clear
C)
Edit \[\to \] Copy and Insert \[\to \] Paste done
clear
D)
Edit \[\to \] Copy and Format \[\to \] Paste done
clear
View Solution play_arrow
-
question_answer21)
Which icons will you click to perform copy and paste function?
A)
B)
C)
D)
View Solution play_arrow
-
question_answer22)
Which of these pairs of icons will you click to perform cut and paste function?
A)
B)
C)
D)
View Solution play_arrow
-
question_answer23)
What is the shortcut key combination to copy and paste?
A)
Ctrl + C and Ctrl + X done
clear
B)
Ctrl + V and Ctrl + X done
clear
C)
Ctrl + Z and Ctrl + C done
clear
D)
Ctrl + C and Ctrl + V done
clear
View Solution play_arrow
-
question_answer24)
Look at the given two figures and find out which function has been performed?
i. copy ii. paste iii. cut |
A)
Only I done
clear
B)
Both I and II done
clear
C)
Only III done
clear
D)
Both II and III done
clear
View Solution play_arrow
-
question_answer25)
Observe these two Excel windows carefully and find out what has been done to the data.
A)
Overwritten done
clear
B)
Cleared done
clear
C)
Copied done
clear
D)
Moved done
clear
View Solution play_arrow
-
question_answer26)
Which feature of MS Excel helps you enter the series of data automatically?
A)
Auto sum done
clear
B)
Function done
clear
C)
Auto fill done
clear
D)
Chart done
clear
View Solution play_arrow
-
question_answer27)
Observe the two given windows and identify which action has been performed.
A)
New row has been inserted. done
clear
B)
Column width has been increased. done
clear
C)
Copy and paste action has been performed. done
clear
D)
Cut and paste action has been performed. done
clear
View Solution play_arrow
-
question_answer28)
What does the changing in the appearance of the text refer to?
A)
Sort done
clear
B)
Formatting done
clear
C)
Functions done
clear
D)
Copying done
clear
View Solution play_arrow
-
question_answer29)
What does the icon
represent?
A)
Sort \[\to \] Ascending done
clear
B)
Sort \[\to \] Descending done
clear
C)
Sort \[\to \] Justified done
clear
D)
Conditional sort done
clear
View Solution play_arrow
-
question_answer30)
The first step to format your spreadsheet data is to ___.
A)
Type '=' sign done
clear
B)
Insert a new row done
clear
C)
Select the cell range done
clear
D)
Insert a new column done
clear
View Solution play_arrow
-
question_answer31)
What is the function of the icon
of standard tool bar?
A)
It changes the font colour. done
clear
B)
It changes the font style. done
clear
C)
It underlines the font. done
clear
D)
It fills colour into the selected cells. done
clear
View Solution play_arrow
-
question_answer32)
Which of these icons has been used to sort a given data with respect to "Name" column in descending order?
A)
B)
C)
D)
View Solution play_arrow
-
question_answer33)
Name the icon of standard tool bar indicated with an arrow mark.
A)
Fill colour done
clear
B)
Font style done
clear
C)
sort done
clear
D)
font colour done
clear
View Solution play_arrow
-
question_answer34)
What is the icon indicated with an arrow mark called?
A)
Sort - Descending done
clear
B)
Sort ? Ascending done
clear
C)
Upper case font done
clear
D)
Lower case font done
clear
View Solution play_arrow
-
question_answer35)
Which of these icons will you use for right alignment of data?
A)
B)
C)
D)
View Solution play_arrow
-
question_answer36)
Which of the following statements is false?
A)
You cannot format a number to currency in MS Excel. done
clear
B)
Steps to align contents of the cell are: Format
Cells
Alignment tab
done
clear
C)
Font style can be changed by using
and
buttons of standard tool bar.
done
clear
D)
You can print any worksheet of the workbook irrespective of its position. done
clear
View Solution play_arrow
-
question_answer37)
What do you mean by arrangement of data in a specified order in MS-Excel?
A)
Sorting done
clear
B)
Inserting done
clear
C)
Filtering done
clear
D)
Formatting done
clear
View Solution play_arrow
-
question_answer38)
What is the shortcut key to popup 'Format cells' dialogue box in MS-Excel?
A)
Ctrl + 1 done
clear
B)
Ctrl + 2 done
clear
C)
Ctrl + T done
clear
D)
Ctrl + 3 done
clear
View Solution play_arrow
-
question_answer39)
In MS-Excel, what is the pictorial representation of data in a worksheet called?
A)
Pictograph done
clear
B)
Chart done
clear
C)
Graph done
clear
D)
Pivot done
clear
View Solution play_arrow
-
question_answer40)
What is the shortcut key to apply border around selected cells?
A)
Ctrl + Shift + Plus (+) done
clear
B)
Ctrl + Shift + Ampersand (b) done
clear
C)
Ctrl + Shift + Asterisk (*) done
clear
D)
Ctrl + Shift + Minus (-) done
clear
View Solution play_arrow
-
question_answer41)
Which of the following chart is referred to as scatter chart?
A)
Pie chart done
clear
B)
Bar chart done
clear
C)
XY chart done
clear
D)
Radar chart done
clear
View Solution play_arrow
-
question_answer42)
Which error is obtained when a formatted number does not fit within a cell?
A)
##### done
clear
B)
#DIV/0 done
clear
C)
#DIV@ done
clear
D)
#VALUE! done
clear
View Solution play_arrow
-
question_answer43)
What does the tool indicated with an arrow mark in the chart toolbar of MS-Excel represent?
A)
Legend done
clear
B)
Data table done
clear
C)
Chart objects done
clear
D)
Chart types done
clear
View Solution play_arrow
-
question_answer44)
The formula bar displays what was entered in cell F2. Why did the error message #NAME? Appear in cell F2?
A)
There should be parenthesis around B2:E2. done
clear
B)
The equal to sign should be deleted from the formula. done
clear
C)
There should be a plus sign in the formula instead of a colon. done
clear
D)
You can only use the count function to count down a column. done
clear
View Solution play_arrow
-
question_answer45)
What is the given tool bar called?
A)
Formatting tool bar done
clear
B)
Menu bar done
clear
C)
Standard tool bar done
clear
D)
Drawing tool bar done
clear
View Solution play_arrow
-
question_answer46)
What is button P in the given tool bar in the picture?
A)
Percent style button done
clear
B)
Increase decimal button done
clear
C)
Decrease decimal button done
clear
D)
Currency style button done
clear
View Solution play_arrow
-
question_answer47)
What is the purpose of
button in the toolbar of MS-Excel?
A)
Merge and center done
clear
B)
Lower case letters done
clear
C)
Align center done
clear
D)
Italic and sentence case done
clear
View Solution play_arrow
-
question_answer48)
Which features of MS-Excel is used in window 1 for obtaining the drop-down control as shown in window 2?
A)
Auto sum done
clear
B)
Auto fill done
clear
C)
Auto function done
clear
D)
Auto filter done
clear
View Solution play_arrow
-
question_answer49)
Which feature in MS-Excel allows you to apply different formatting options, such as colour, to a cell based on the data in the cell?
A)
Auto filter done
clear
B)
Conditional formatting done
clear
C)
Font colour done
clear
D)
Sorting done
clear
View Solution play_arrow
-
question_answer50)
Which is the shortcut key that will hide the entire row in excel?
A)
Ctrl+9 done
clear
B)
Ctrl + H done
clear
C)
Ctrl + R done
clear
D)
Ctrl + - done
clear
View Solution play_arrow
-
question_answer51)
What is the Auto complete feature of Excel?
A)
It automatically completes abbreviated words. done
clear
B)
It completes text and numeric entries that match an existing entry in the same column. done
clear
C)
It completes text entries that match an existing entry in the same column. done
clear
D)
It completes text entries that match an existing entry in the same worksheet. done
clear
View Solution play_arrow