Horizontal dimention of Google Sheets spreadsheet is called?
Anonymous Poll
78%
Row
0%
Cells
11%
Columns
11%
Field
Hello, ninepointers 😀
Share these groups with your engineering friends!
Share these groups with your engineering friends!
Why would you want to freeez rows in your spreadsheets?
Anonymous Poll
0%
To modify only frozen rows
15%
To limit the data that can be entered in the frozen row
5%
To prevent the rows to be edited by collaborators
80%
To scroll through the spreadsheet while continuing to see the frozen rowa
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
Hello, ninepointers 😀
Share these groups with your engineering friends!
Share these groups with your engineering friends!
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
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
Hello, ninepointers 😀
Share these groups with your engineering friends!
Share these groups with your engineering friends!
What is the correct formula to add cells A1 to A5?
Anonymous Poll
24%
=SUM(A1+A5)
6%
=A1+A5
6%
= A1+A2+A3
65%
=SUM(A1:A5)
Select ________ from functions drop down to find smallest numbers in a group?
Anonymous Poll
77%
min
8%
max
8%
sum
8%
average
Which item is FALSE regarding charts in Google Sheets?
Anonymous Poll
11%
You can create pie and line charts
67%
Charts can't be inserted on their own sheet
0%
You can change the chart title
22%
You can put a background color on your charts
__________ helps us to see patterns.
Anonymous Poll
26%
Charts
42%
Graphs
26%
Spreadsheets
5%
Calculations
In computer spreadsheet, to choose build in function we use:
Anonymous Poll
43%
Defined function
14%
Function finder
43%
Build in function
0%
Paste function
Hello, ninepointers 😀
Share these groups with your engineering friends!
Share these groups with your engineering friends!