CENG
5.0(1)
Studied by 7 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt PlayCard Sorting
1/29
Earn XP
Last updated 2:56 PM on 3/30/23
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
30 Terms
1
New cards
data organized in rows and columns
spreadsheet
2
New cards
3 uses of Excel
store, manipulate, and present data
3
New cards
collection of worksheets
workbook
4
New cards
spreadsheet
worksheet
5
New cards
group of cells
range
6
New cards
piece of data with address; object (complex data type)
cell
7
New cards
$A$1:$A$1 (has $ sign)
absolute
8
New cards
A1:C3 (no $ sign)
auto increments
9
New cards
list at least four data types we worked with in excel
text, currency, date, time
10
New cards
what is an example of an IF formula in excel
=IF(A1>10, “Yes” , “No”)
11
New cards
in =IF(A1>10, “Yes” , “No”), the yes is outputted if the statement is….
true
12
New cards
in =IF(A1>10, “Yes” , “No”)the no is outputted if the statement is….
false
13
New cards
what is an example of an AND formula in excel
=AND(A1>10, B1>10)
14
New cards
what has to qualify for an AND formula in excel to be true?
=AND(x,y)
=AND(x,y)
both x and y have to be true
15
New cards
what is an example of an OR formula in excel
=OR(A1>10, A1
16
New cards
what has to qualify for an OR formula in excel to be true?
=OR(x,y)
=OR(x,y)
either x or y has to be true
17
New cards
what is an example of a FIND formula?
=FIND(“.”,A1,1)
18
New cards
what goes in each of these blanks in a FIND formula?
=FIND(“ *__ “ ,* __ , ___ )
=FIND(“ *__ “ ,* __ , ___ )
find this, cell number, start number
19
New cards
what is an example of a RIGHT formula?
=RIGHT(find, 2)
20
New cards
what goes in each of these blanks in a FIND formula?
=RIGHT( *__ ,* __ )
=RIGHT( *__ ,* __ )
text to look for, number of characters
21
New cards
basics of VBA
writing programs to process data in excel
22
New cards
what are pivot tables useful for?
analyzing data and automating the storage of data
23
New cards
write how the syntax to input and output a String in Arduino
string myName;
serial.println(“Enter your name”);
while (serial.available == 0){ //wait}
myName= seral.readString
serial.println(“Enter your name”);
while (serial.available == 0){ //wait}
myName= seral.readString
24
New cards
write the arduino code to count the number of button presses that occur in a given time frame
pinMode (12, INPUT_PULLUP); //reads LOW when pressed
int state = digitalRead(12);
delay (50);
if (state == LOW){ //pressed down
while (digitalRead(12) ==LOW){ count++;}
int state = digitalRead(12);
delay (50);
if (state == LOW){ //pressed down
while (digitalRead(12) ==LOW){ count++;}
25
New cards
symbol for XOR in C++
^
26
New cards
symbol for OR in C++
||
27
New cards
symbol for NOT in C++
\~
28
New cards
symbol for AND in C++
&
29
New cards
symbol for LS in C++
<<
30
New cards
symbol for RS in C++
>>
