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
Which of the following format you can deside to apply or not in AutoFormate dialog box ?
Anonymous Poll
35%
Number Format
0%
Font Format
6%
Border Format
59%
All of the above options
In Spreadsheet, letters are used to represent?
Anonymous Poll
62%
Columns
5%
Blocks
19%
Rows
14%
Cells
A spreadsheet cell is highlighted with a heavy border is a ?
Anonymous Poll
25%
Cell cointaining a formula
50%
Active Cell
5%
Cell
20%
Locked Cell
The process of arranging the items of a column in some sequence or order is known as ?
Anonymous Poll
26%
Arranging
0%
Autofill
58%
Sorting
16%
Filtering
An Google Sheet file is generally called a/an_______,
Anonymous Poll
5%
Sheet
38%
Worksheet
0%
Workbook
57%
E- Spreadsheet
Horizontal dimention of Google Sheets spreadsheet is called?
Anonymous Poll
78%
Row
0%
Cells
11%
Columns
11%
Field
Google Sheets saves your changes automatically.
Anonymous Poll
80%
TRUE
20%
FALSE
Which of the following symbols are recognised as mathematical operators?
Anonymous Poll
8%
'
8%
|
29%
=
54%
+
Which of the following would you use to add values in several cells?
Anonymous Poll
56%
SUM
22%
NUM
15%
ADD
7%
TOTAL
Which symbol is used to show absolute cell reference.
Anonymous Poll
28%
?
16%
#
52%
$
4%
@
Most Function cointain one or more?
Anonymous Poll
35%
Sub-function
53%
Arguments
6%
Plus sign
6%
Sentences
Which of the following is not a valid function in Google Sheets?
Anonymous Poll
12%
SUM()
59%
ADD()
29%
COUNTA()
0%
COUNT()
A group of cells is called a ________
Anonymous Poll
9%
Chart
4%
Multicell
70%
Cell Range
17%
Cell Cluster
Which of the following is an absolute cell reference?
Anonymous Poll
15%
A2
65%
$A$2
0%
A:2
According to the order of operations, which calculation comes first in the following formula? 5*2+2-3(10-1)
Anonymous Poll
6%
2-3
67%
10 - 1
28%
5*2
0%
2+2