WorksheetsBrainstorming 2k17
Total questions: 20
Worksheet time: 10mins
Which function in 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
Statistical calculations and preparation of tables and graphs can be done using
Adobe Photoshop
Excel
Notepad
Power Point
Which one is not a Function in MS Excel ?
SUM
AVG
MAX
MIN
What type of chart is useful for showing trends or changes over time ?
Pie Chart
Column Chart
Line Chart
Dot Graph
The ____ feature of MS Excel quickly completes a series of data
Auto Complete
Auto Fill
Fill Handle
Sorting
In Excel, which one denoted a range from B1 through E5
B1 - E5
B1:E5
B1 to E5
B1$E5
Which of the following is not an option of the spelling dialog box?
Ignore
Ignore all
Edit
Change
A worksheet can have a maximum of _______ number of rows?
256
1024
32000
65536
A typical worksheet has ________ number of columns?
128
512
256
1024
The group which following item is called workbook?
Column
Rows
Cells
Worksheets
All Excel formulas are started with which symbol?
+
-
=
$
Which option is used as group of commands in excel?
Formatting
Goal Seek
Filter
Macro
There are how many sheets in excel by default?
1
2
3
4
Excel is example of?
System Software
Spreadsheet Package
Text Editor
Database
This function returns the current date and time.?
TODAY
NOW
TIME
DATE
What is the cell in which we work in excel??
Active Cell
Different Cell
D Active Cell
Name Box
What are the maximum number of days in a worksheet in Excel??
1048576
145623
782345
45673
What option is used in Excel if we do not want to move the data to another cell?
Lap Text
Map Text
Split Text
Wrap Text
At what bar does the true value of the cell appear??
Formula Bar
Title Bar
Menu Bar
Address Bar
