Excel/Google Sheets - ninepointer
121 subscribers
8 photos
2 videos
10 links
One of the best channel for learning Excel/Google Sheets tricks and tips.
Some of our top mentors and creators are from IIT Bombay, IIT Delhi, IIT Kharagpur, IIT Roorkee, NIT Rourkela, NIT Bhopal, NIT Jaipur.
Download Telegram
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
Anonymous Poll
57%
TRUE
43%
FALSE
You can have multiple sheets within the same Google Sheet document.
Anonymous Poll
79%
TRUE
21%
FALSE
You can not give an exact size of a row height and column width.
Anonymous Poll
25%
TRUE
75%
FALSE
Merging cells automatically centers the text within the merged cells.
Anonymous Poll
67%
TRUE
33%
FALSE
It is possible to insert images in Google Sheets.
Anonymous Poll
100%
TRUE
0%
FALSE
In a spreadsheet, which is true if current or active cell is B4 and you press Entre key ?
Anonymous Poll
7%
You will be in cell A1
13%
You will be in cell B4
80%
You will be in cell B5
0%
You will be in cell B3
In computer spreadsheet ,a workbook is a group of __________
Anonymous Poll
6%
Rows
6%
Columns
88%
Worksheet
0%
Least number of columns
The little triangle in the top right corner of a cell means there is a ________ with that cell.
Anonymous Poll
46%
formula
13%
number
0%
letter
42%
note
Spreadsheets work much like the game ________________.
Anonymous Poll
33%
Monopoly
33%
Minecraft
22%
Battelship
11%
Yahtzee
Rows are labeled by __________.
Anonymous Poll
77%
numbers
19%
alphabets
4%
colors
0%
symbols
Which of the following is a correctly named cell?
Anonymous Poll
4%
8-B
91%
B8
0%
8B
4%
BB-8
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere.
Anonymous Poll
32%
Skinny Plus sign
21%
Hand
42%
Arrow
5%
Fat Plus Sign
Which symbol tells the computer you want to create an equation or formula?
Anonymous Poll
9%
$
0%
+
91%
=
0%
-
Select ______________ from the functions drop-down menu to add a set of numbers.
Anonymous Poll
22%
average
43%
count
35%
sum
0%
min
Which is used to calculate and analyze a set of numbers?
Anonymous Poll
5%
Improve
33%
StarCalc
52%
Spreadsheet
10%
Database
Which bars have shortcut icons for frequently done tasks in the Spreadsheet?
Anonymous Poll
36%
Main Tool bar
9%
Object bar
27%
Formula bar
27%
Menu bar
Which is used to print the worksheet with grid lines?
Anonymous Poll
56%
Grid Check Box
22%
Check Box
11%
Text Box
11%
Dialog Box
Which shortcut icon is used to select and insert functions?
Anonymous Poll
50%
Functional Auto pilot
7%
File series
36%
Function wizard
7%
Category