Computer / II Semester I Partial

studied byStudied by 1 person
5.0(1)
learn
LearnA personalized and smart learning plan
exam
Practice TestTake a test on your terms and definitions
spaced repetition
Spaced RepetitionScientifically backed study method
heart puzzle
Matching GameHow quick can you match all your cards?
flashcards
FlashcardsStudy terms and definitions

1 / 37

flashcard set

Earn XP

Description and Tags

38 Terms

1
**Excel macro**
action or a set of actions that you can **record, give a name, save and run** as many times as you want and whenever you want
New cards
2
run a saved macro
the **recorded mouse clicks and keystrokes will be executed in the same sequence as they are recorded.**
New cards
3
**Visual Basic for Applications**
**VBA**
New cards
4
Excel Visual Basic Editor
VBE
New cards
5
malicious code
As with the case of any other code, macro code is also susceptible to ____ that can run when you open a workbook.
New cards
6
**Macro Security facility**
Microsoft provided the ___ **that helps you in protecting your computer from such macro viruses.**
New cards
7
Absolute references
make your macro run at the same cells where you recorded the macro
New cards
8
relative references
make your macro run at the active cell.
New cards
9
**shape, graphic, control**
You can assign a macro to an **object such as a __ or a -- or a ---.**
New cards
10
**several ways**
Excel provides ___ to run a macro
New cards
11
Form
is normally used to collect required information.
New cards
12
Debugging
stands for the process of finding and fixing errors or bugs in the source code of any software.
New cards
13
TODAY
is a function that makes the dates in your Google Sheets update automatically.
New cards
14
TEXT
is a function to convert numbers into currency or to change a date string into a MM/DD format.
New cards
15
SPLIT
is a function that is used to split or divide data from single cells into multiple cells.
New cards
16
SEARCH
This Google Sheets formula allows you to check whether a value exists in a string.
New cards
17
CONCATENATE
is a function used to combine the contents of two or more cells into a third separate cell.
New cards
18
IMPORT RANGE
is a simple yet powerful function that helps you import a range of cells from a specified spreadsheet.
New cards
19
TRue
In Excel and Google sheets , you can change the macro security settings to control which macros run and under what circumstances when you open a workbook.
New cards
20
Very High
In the __ security level all Macros are disabled without any notification.
New cards
21
Medium
In the __ security level all Macros are disabled but with a notification.
New cards
22
Low
In the __ security level all macros are run without restrictions.Enabling all macros
New cards
23
Steps Excel
To record a new Macro in Microsoft Excel do the following –
A)Click the VIEW tab on the Ribbon.
B)Click Macros in the Macros group.
C)Select Record Macro from the dropdown list.
New cards
24
Steps Google Sheets
To record a new Macro in Google Sheets do the following:

 On your computer, 

A)Open a spreadsheet at sheets.google.com.

B)At the top, click Extensions Macros. Record macro.

C)At the bottom, choose which type of cell reference you want your macro to use: ...

D)Complete the task you want to record. ...

E)Name the macro, create a custom shortcut, and click Save.
New cards
25
Dialog box steps
The Record Macro dialog box appears.
Type MyFirstMacro in the Macro name box.
Type the name of the macro(ex.Temp_Macro 2) in the Description box and click OK.
New cards
26
True
Whatever keystrokes and mouse clicks you do, will be recorded now.
New cards
27
Run macro Excel
To run the macro in Excel:
Click on a new worksheet.
Click the VIEW tab on the Ribbon.
Click Macros.
Select View Macros from the dropdown list
New cards
28
Run macro Sheets
To run a Macro in Sheets:
click Extensions and
then Macros and
then the macro you want.(ex)Macro 1 ,Temp_Macro2
New cards
29
True
Only the macro that you recorded appears in the Macros list.
New cards
30
Uniform resource locators(URL)
192\.10.1.2 or 172.10.22.1 are examples of ___,also known as web addresses.
New cards
31
Really Simple Syndication (RSS)
It is an easy way for people to keep up with news and information that is important to them.
New cards
32
GROWTH
The ___ function will help you fit an ideal exponential growth trend, and give you data about said growth trend.
New cards
33
SUBSTITUTE
The ___ function is used to change an existing text with new text in a particular string.
New cards
34
TRANSPOSE
function, lets you convert row-wise data into column-wise and vice versa.
New cards
35
Budget
A ___ is an estimate of income and expenditure for a set period of time.
New cards
36
Income
is money received, especially on a regular basis, for work or through investments.
New cards
37
expense
An ___ is the cost incurred in or required for something.
New cards
38
transaction
A ___ is an instance of buying or selling something.
New cards

Explore top notes

note Note
studied byStudied by 6 people
126 days ago
5.0(1)
note Note
studied byStudied by 10 people
171 days ago
5.0(1)
note Note
studied byStudied by 7 people
877 days ago
5.0(1)
note Note
studied byStudied by 7 people
293 days ago
4.0(1)
note Note
studied byStudied by 21 people
203 days ago
5.0(2)
note Note
studied byStudied by 3 people
728 days ago
5.0(1)
note Note
studied byStudied by 11 people
863 days ago
5.0(1)
note Note
studied byStudied by 6 people
155 days ago
5.0(1)

Explore top flashcards

flashcards Flashcard (35)
studied byStudied by 14 people
538 days ago
5.0(3)
flashcards Flashcard (296)
studied byStudied by 27 people
381 days ago
5.0(1)
flashcards Flashcard (28)
studied byStudied by 1 person
649 days ago
5.0(2)
flashcards Flashcard (41)
studied byStudied by 60 people
435 days ago
5.0(1)
flashcards Flashcard (46)
studied byStudied by 5 people
44 days ago
5.0(1)
flashcards Flashcard (77)
studied byStudied by 5 people
647 days ago
5.0(1)
flashcards Flashcard (203)
studied byStudied by 14 people
843 days ago
4.0(1)
flashcards Flashcard (192)
studied byStudied by 24 people
377 days ago
5.0(1)
robot