Font size
WorksheetsИКТ
Total questions: 180
Worksheet time: 2hrs 30mins
A publicly-accessible personal journal posted on the Web. It is often reflect the personality of the author and is typically updated daily:
BLOB (binary large object)
Big data
Blu-ray
Blog
BL(Business Intelligence)
Which is not included into human computer interaction framework?
operating system
user
output
computer
input
WIMP interface stands for:
windows, icons, menus, pointers
wide, intuitive, mental, perceptual
windows, interaction, menus, principles
windows, internet, modern, protocol
windows, interface, man, printer
What is the primary aim of the human computer interaction research?
improve human-computer interaction by improving computer power
improve human-computer interaction by using different languages
improve human-computer interaction by improving screen resolution
improve human-computer interaction by improving sustainability of PCs
improve human-computer interaction by improving the usability of computer interfaces
Which of the following could be considered as user-centered designing process?
improving the life-time of a battery
simply adding new features into a program
improving screen sizes
fixing bags
allowing users from countries with unstable internet speed to download a program even if connection is lost
The root directory of a disk should be placed __
in flash memory
at a fixed address in main memory
in a clipboard
at a fixed location on the system disk
anywhere on the disk
Which year the virus was first detected?
1956
1917
1970
1980
2016
Computer networks operating within the same of any premises, enterprise, institution, are called ______networks
local
regional
industry
global
urban
The main task of any computer networks is …
to gather soft copies of documents
to regulate all the components of each computer
set of equations
to receive and send correspondence
the exchange of information between computers
Computer network are mainly characterized by
printing speed
the data transfer rate
the type of information being transmitted
the capacity of the memory
the cost of the network equipment
Network servers are _______
communication nodes based on powerful computers that provide ongoing transmission of information
the type of information being transmitted
standard decoding device by which any computer can connect to the wide area network
data transfer rat
various personal computers associated with various organizations
Communication nodes on the basis of powerful computers that provide ongoing transmission of information are _______
network servers
the standard decoding devices
local desktop computers
network printers
any personal computers
Address network adapter is ____
drawing up a numeric
the address of hardware
user name
city or country
symbolic address
What is the LAN?
nets that integrate geographically dispersed computers that may be located in different cities, areas, regions or countries
hardware address
network computers, placed in a small area and are used for high-quality communication link
symbolic address
nets computers that serve the metropolitan area
The concept, which defines the exchange in the network, the information flow:
ІR-routing
computer network
symbolic address
hardware address
traffic
The global network is
symbolic address
the unique network address of a node in a computer network
hardware address
the information received no later than pre-scheduled time agreed with the time of the task.
the networks covering a large area that includes large number of computers
The most common way of finding information on the Internet is to use a ___
reference system
hyperlink
text files
search engine
web browser
The extension of the the web-page:
htm
avi
com
exe
doc
The computer which is always connected to the network is
a host computer (host)
network adapter
provider
network card
router
Software that provides services to a variety of the network information services:
basic software
рrogram server
network card
browser
router
Modem provides ____
information transmission over telephone communication channels
information removing
information storage
data printing
information processing in a given time
Server is ___
a single user computer that is connected to the general network
standard that defines the presentation and method of sending messages
a powerful computer that other computers connects to
information removing
the network program, which connects one user to another
Local computer networks are -
standard that defines the presentation and method of sending messages
the networks to which all the computers in the same building is connected
networks to which the all computers of the country are connected
network to which all the computers are connected
networks to which all the computers of the settlement are connected
The e-mail address on the Internet is set as “user_name@mtu-net.ru”. What is the name of the owner of the e-mail address
mtu-net.ru
ru
user_name
mtu-net
@mtu-net
The doman is ...
the name of the program for communication between computers
speed unit of information exchange
application for creating text documents
the name of the device in communication between computers
the part of the address that defines the user's computer address on the network
What is a hypertext?
speed unit of information exchange
a method of organizing the text information, which are installed inside the semantic relation between its different fragments
the name of the device in communication between computers
application for creating text documents
it is the easiest way to organize the data in a computer, consisting of a character encoding code table
What is the terminal?
the server computer
the user's computer
device that connects a computer unit to the telephone network
web browser
external memory device
What is the web-browser
a device for transmitting information over a telephone network
english name e-mail
telecommunication network
the application for retrieving and representing the information resources on the Web
internet server
What is the Mailbox?
the computer that is used for sending e-mails
specific technical agreements for networking
telecommunication network
external memory section of the mail server
the name of the program to send e-mails
What is the protocol?
telecommunication network
means for converting information
a special program that helps the user to find the information on the web
communication line that connects the computers in the network
specific technical agreements for networking
What is the Web-site?
telecommunications network that store its own information
a special program that helps the user to find the information on the web
pages that belong to a single user or organization
search engine
specific technical agreements for networking
What is the WWW:
pages that belong to a single user or organization - Web totality
specific technical agreements for networking
the name of the e-mail address
an information space where web resources are identified by URLs
telecommunications network located in its information
What is the hyperlink:
specific technical agreements for networking
the text, which can make the transition between the different instruments, using dedicated labels
reference to go to another document
pages that belong to a single user or organization
information - search the Internet system
Addressing is ________
an information space where web resources are identified by URLs
reference to go to another document
a method of identifying the subscribers in the network
the address of the server
the address of the user network
What is network adapter:
a special program, through which multiple computers are connected
special hardware for effective interaction of personal computers in the network
device for storing information
is a special system of shared network resource management
the system of information exchange between computers on the local network
What is the Internet?
a structured collection of records or data
the structure organized like an inverted tree
a global system of interconnected computer networks
a set of instructions that tells computer hardware what to do
the scientific and practical approach to computation and its applications
What is TCP/IP?
a database model based on relations
a computer software designed for the purpose of managing databases based on a variety of data models
product with no owner
the communication protocol for the Internet
a kind of software to organize the storage of data
What is Simple Mail Transfer Protocol (SMTP)
a protocol for sending e-mail messages between servers
database management system which data is stored in tables
a number of advantages as compared to traditional computer file-based processing approach
protocol for controlling the data redundancy the and data consistency
non-database systems which application program has its own private files
FTP (File Transfer Protocol) is __________
a column or group of columns in a relational database table that provides a link between data in two tables
hypermedia information system
a functionality that lets users see the pages that are about to print, allowing the users to see exactly how the pages will look when they are printed
an application protocol that uses the internet’s TCP/IP protocols
the top level identification string for a particular server
Hyper text transfer protocol secure (HTTPS) is:
the protocol that enables people to use the internet as the transmission medium for telephone calls
the protocol that transfer the data electronically encrypted and that is why cannot be accessed by unauthorized people
standard address format that constitutes a reference to an internet resource
the top level identification string for a particular server
the simplest way to exchange files between computer on the internet
Node is __________
an attached device that is capable to communicate with other network devices
a device or application that uses the services provided by a server
a device used to extend a network that can attach additional workstations
a piece of computer hardware designed to allow computers to communicate over computer network
a computer that makes access to files, printing, communications, and other services available to users
Network interface card is …
the device or application that uses the services provided by a server
a computer that can share files, printing, communications, and other services and make it available to users
an attached device that is capable to communicate with other network devices
the device used to extend a network that can attach additional workstations
a piece of computer hardware designed to allow computers to communicate over a computer network
Hub is …
a piece of computer hardware designed to allow computers to communicate over a computer network
an attached device that is capable to communicate with other network devices
a computer that can share files, printing, communications, and other services and make it available to users
the device or application that uses the services provided by a server
the device used to extend a network that can attach additional workstations
Server is …
the device or application that uses the services provided by a server
the device used to extend a network that can attach additional workstations
piece of computer hardware designed to allow computers to communicate over a computer network
a computer that can share files, printing, communications, and other services and make it available to users
an attached device that is capable to communicate with other network devices
Client is …
a computer that can share files, printing, communications, and other services and make it available to users
the device or application that uses the services provided by a server
the device used to extend a network that can attach additional workstations
an attached device that is capable to communicate with other network devices
a piece of computer hardware designed to allow computers to communicate over a computer network
What category following terms are related to: Optical fiber Ethernet Wireless LAN Home PNA
the connection method
the PAN
functional relationship (Network Architectures)
the scale
the network topology
What can be defined as “ the description scheme of the network arrangement including the nodes, connecting lines, and other devices.
scheme
network nodes
connecting lines
interface
network topology
LAN covers ____
communicated through wireless network technologies such as Wireless USB, Bluetooth, Z-Wave, and IrDA
small geographic area, like a home, office, or group of buildings
large physical areas such as states or countries
the immediate town, city, or metropolitan area
communicating computerizes devices such as telephones and PDAs
Which of the following TCP/IP protocols is used for transferring electronic mail messages from one machine to another?
SNMP
SMTP
RPC
Z-Wave
FTP
Which digits of the DNIC (Data Network Identification Code) identify the country?
first three
first six
past three
first four
first five
Which of the following devices is used to connect two systems, especially if the systems use different protocols?
gateway
repeater
hub
bridge
web
Which of the following is separated by a subnet mask?
domains
network ID and host ID
subnets
DHCP scopes
Browser
Messages from one computer terminal can be sent to another by using data networks. The message to be sent is converted to an electronic digital signal, transmitted via a cable, telephone or satellite and then converted back again at the receiving end. This system of sending messages is called_______
electronic newspaper
paperless office
electronic mail
global network
local network
Which protocol is used between E-Mail servers?
POP3
HTTP
FTP
SNMP
SMTP
The device that converts computer output into a form that can be transmitted over a telephone line is_____
teleport
adapter
multiplexer
concentrator
modem
Modem transmitting information at the rate of 28800 bits / sec., 1 sec. can transmit two pages of text (3600 bytes) in_________
one second
a week
a day
an hour
one minute
Which of the following provides a storage mechanism for incoming mail but does not allow a user to download messages selectively?
POP3
HTTP
SMTP
DHCP
IMAP
Standard set of protocols used by the Internet, intranets, extranets, and some other networks:
internetwork processor
TCP/IP
protocol
open systems
operation system
Business meeting and conferences are held connecting people in distance through the computer network. Participants exchange information and are able to see each other. This type of meeting is called ___
teletalking
teleconferencing
telemeeting
telephone
telemailing
Which of the following allows a simple email service and is responsible for moving messages from one mail server to another?
DHCP
IMAP
FTP
POP3
SMTP
The model of providing ubiquitous and convenient network of on-demand access to the shared pool of configurable computing resources
Internet
cloud computing
online technology
local resources
virtual resources
Types of clouds:
private and public
shared and public
standard and public
standard
shared and private
User of cloud internet service can:
change data
change data of other users
manage service
change the structure of the service
view your own data
What does Database system aim to achieve?
explaining meanings
a highly organized collection of data
further growth
constantly self-updating software
explaining meanings of life-events
What is the most popular example of DBMS (СУБД)?
Microsoft Access
relational database management system
hard drive
iCloud.
delphi
What does DBMS stand for?
driver bites microsoft software
duke of boston mike sir
digital browser monitorising shelf
derivative binomial mirroring scan
database managment system
Outline examples of DB:
library book fund, the staff of the enterprise, the educational journal in the school, etc.
hard drive, internal memory, etc.
Oracle, Microsoft SQL Server, MySQL.
books, writings, other kinds of literature.
book shelves, libraries.
What is the basic unit of information (ACCESS) ?
sentence
database table
ordinary Table
standard key
cells
What must be defined for each database_table?
foreign key
associative assistant
database table
primary key
ordinary table
A variety of interrelated tables refers to…
standard key
plural-database
shapes and charts
multiple-database
connective table
What are the structural components of the table?
shapes and charts
records and columns
records and fields
columns and strokes
windows and fields
What is the definition of API?
associative preference interface
application programming interface
apple programming department
application parametric interface
automatic plague of internet
Since 1980’s what is the most popular language of database systems?
SQRL language
Basic language
SQCL language
Pascal language
SQL language
Which software are we implementing into database course?
Microsoft Outlook
Microsoft Access
Adobe Acrobat
Adobe Sync
Microsoft Excel
The software that is designed to work with databases is called…
records and fields opener
table evaluating system
database
Microsoft Access
Evaluator
What does the term Data Base refer to?
reading and writing books
table evaluating system
organised collection of data
monitorising
explaining meanings of life-events
What does DB stand for?
derivative binomial
driver bite
Duke of Boston
data base
digital browser
Is there any difference between Database and DBMS?
no correct answer
no there is not
yes there is
partly
only by the coverage of network
The function of the Internet Control Message Protocol (ICMP):
provides communication between the Internet Protocol Software on one machine and the Internet Protocol Software on another
to allow gateways to send error control messages to other gateways or hosts
reports error conditions to the original source, the source must relate errors to individual application programs and take action to correct the problem
controls the communication and transfer of messages
all the answers are correct
What is the alternative name for relational database?
discrete database
connective database
reciprocal database
cooperative database
tabular database
What must be defined for each database table?
primary key
associative assistant
ordinary table
database table
foreign key
SMART technology develops very fast on some fields:
Decision query, GeForce
DrWeb, Decision support systems
Invest manager, Help Desc
Operating system, Linux
Internet of things, Big data, Technology Block Chain
Convert 1100 binary to decimal:
12
6
10
24
18
Convert decimal number 15 into binary system
110
1010
1100
1101
1111
Convert 10 from decimal to binary.
1101
1010
1100
110
1011
Convert 5 from decimal to binary.
111
101
100
1011
110
Convert decimal number 255 to an octal numeral system.
340
501
256
355
377
Convert 12 from decimal to Hexadecimal
C
F
E
B
A
Convert 45 from decimal to Hexadecimal
A2
1F
2B
7E
2D
Convert 1A from hexadecimal to decimal
A1
144
25
36
26
Convert 1010100 from binary to octal
125
124
123
101
114
Convert 10101111000 from binary to hexadecimal.
541
154
101
578
123
Theoretical foundations for Data mining need to know basic concepts of some subjects:
Business to business approach
Probability theory, Microeconomic view
No correct answer
Middle term equation
Atanasov profit model
Which of the following is the system used for storing, retrieving, processing and transmitting data?
information & communication technology
internet
internet & information technology
information & computer technology
internet & communication technology
Which of the following does measure the speed of CPU?
megabytes (MB)
kilobyte (KB)
gigabytes (GB)
bits per second (Bps)
gigahertz (GHz)
Which of the following is NOT realized through electronic commerce?
processing transactions quickly
goods advertisement and comparison of prices
services that are available 24 hours a day
physical contact between buyer and seller
no correct answer
Online education platforms from top universities are very flexible?
HTML, Scopus
Denver, Quebec platform
PHP, Thomson Reuters
Go, Springer
Edx, Coursera, Code Academy, Udacity
Which of the following statements about the Internet is TRUE?
the Internet is a network operating system
the Internet is a visual representation of linked documents
the Internet is a private company network and visual representation of linked documents
the internet is a private company network
the internet is a global network that links many computer networks together
Which of the following should be carried out to secure files from loss in case the main copy is damaged?
install password security and a firewall
install a firewall
backup files to a new location on your computer
backup the files regularly and store offsite
iinstall password security
Data mining is?
a process of analyzing numerical data about economic systems
a process of automatic extraction of textual information from large data banks
a process of automatic extraction of numerical information from large data banks
a process of automatically converting weakly structured data and obtaining an array of data of optimal structure
a process of performing automated extraction and generating predictive information from large data banks
Which software is used to access the Internet?
system
presentation
interface
browser
word
Which of these is an example of an e-commerce activity?
checking theatre availability
viewing a travel timetable and checking theatre availability
downloading a screen saver
booking a flight
viewing a travel timetable
What is the main factor in the growth of the ‘Information Society’?
faster processors
multimedia computers
modems
PC
Internet
Who first introduced the term “Knowledge Discovery in Databases”?
D. McLennen
U. Fayyad
G. Piatetsky – Shapiro
F. Galton
R. Uthurusam
A hybrid computer uses _____ to convert digital signals from computer into analog signals.
decoder
demodulator
modulator
web
modem
The organization and interconnection of the various components of the computer system is called the_________
graphics
architecture
designing
networks
operation systems
What kind of file usually refers to ’.JPG’ extension?
text file
animation/movie file
MS Encarta document
system file
image file
Which year the "@" symbol was chosen for its use in e-mail addresses?
1976
1980
1984
1972
1988
International ISO standards ensure that products and services are:
safe, reliable, but has a poor quality
unsafe, reliable and of a good quality
safe, reliable and of a good quality
safe, unreliable and of a good quality
unsafe, unreliable, but has a good quality
What is the web browser?
a computer that stores WWW files
a person who likes to look at websites
copy disc
a kind of spider
a software program that allows you to access web-sites on the World Wide Web
Which of these is a valid e-mail address?
professor.at.learnthenet
www.learnthenet.com
professor@learnthenet.com
professor@learnthenet
professor. learnthenet.com
Binary IPv4 address 10101100000100000000010000010100 in decimal number system is?
154.76.8.87
172.67.7.15
172.16.4.20
186.67.8.54
234.65.2.12
Which of the following is not a valid domain name?
WWW.yahoo.com
WWW.yahoo.co.uk
WWW.fr.yahoo
WWW.yahoo.fr
WWW.yahoo.kz
The "http" that is at the beginning of any site’s address stands for...
HTML transfer technology process
hyperspace terms and tech protocol
hyperspace techniques & tech progress
hyper text transfer protocol
POP3
. What is the URL?
a computer software program
a type of UFO
the address of a document or "page" on the World Wide Web
an acronym for Uniform Resources Learning
hyper text transfer protocol
. The Provider is:
an organization connecting the consumer to the Internet
electronic help system
a mistake of a programmer
server
the device for connection to the Internet
Telecommunication network is the __________network
global
regional
local
industry
PAN
Which tag of the HTML sets a running text?
behavior
run
marquee
string
TR
Which tag of the HTML sets the top index?
SUB
UP
SUP
DOWN
TR
Which tag of the HTML inserts the picture?
SUB
JPEG
IMG
A
PICTURE
The network that connects computers within one room is called ___ network
global
regional
local
administrative
room
Which of the following is not the characteristic of the local network?
exchange of information on big distances
high speed of information transfer
existence of the high-speed channel of information transfer binding in the digital form
existence of channel for information transfer for graphics
possibility of exchange of information in small distances
The network which computers have equal rights are called______
peer network
on the basis of the server
the local
the global
The Modem is ____
the device of transformation of digital signals into analog domain, and back
transport basis of a network
information storage
the device which operates information transfer process
network card
. What does the letter "e" stands for in the word e-learning
educational events held by electronic means
the training takes place in the classroom
training takes place individually with a student
economic training
accelerated learning
What methods of knowledge transfer does not apply to e-learning
Internet
satellite TV
audio
video material
conventional teaching
Types of e-Learning
non-traditional eLearning, traditional training
traditional eLearning, Rapid eLearning
effective eLearning
traditional training
rapid eLearning, effective eLearning
E-government is ________
information system "Electronic government procurement"
the use of new multimedia technologies and the Internet to improve the quality of education by improving access to resources and services as well as remote exchange of knowledge and collaboration
software and provision of information, used to represent the educational materials in the form required for computer-based training systems
a set of IT services that are used during the distance learning
the electronic document management system of governance, based on the total automation of management processes across the country and targets significantly increase the efficiency of public administration and reduce the costs of social communications for each member of society
e-Learning tools are ____
information system "Electronic government procurement"
the use of new multimedia technologies and the Internet to improve the quality of education by improving access to resources and services as well as remote exchange of knowledge and collaboration
software and provision of information, used to represent the educational materials in the form required for computer-based training systems
a set of IT services that are used during the distance learning
the electronic document management system of governance, based on the total automation of management processes across the country and targets significantly increase the efficiency of public administration and reduce the costs of social communications for each member of society
The idea of developing e-government in Kazakhstan was announced in the annual Message of the President of the Republic of Kazakhstan on___
March 1, 2004
March 19, 2004
March 19, 2007
March 19, 2005
March 17, 2004
When the infrastructure of Kazakhstani e-government was formed?
2007-2009
2004-2007
2007-2010
2000-2002
2002-2005
Which of these can be classified as personal information?
date of birth
online nickname
gender
IP address
your OS
. What should be done to filter spam?
change your email address every six months.
always tick the 'don't pass on my details' box when filling forms in.
never give your email address to anyone
online nicknamer
gender
What term describes the act of winding up someone online?
trolling
spam
posting
malware
phishing
What software should be used to avoid getting viruses?
disk cleanup software
browser software
firewall software
anti-virus software
WinRar
. The email attachment that may harm your computer is called ___
phishing
trolling
malware
posting
spam
. A ____________ can be added to your presentation and then used to go to the variety of locations for example, a web address, an e-mail address, a custom show or document, just to name a few.
menulink
hyperlink
toolink
sidelink
TP link
Notes that include the slide as well as key comments and points you may want to emphasis while you present your slide show are know as:
speaker handouts
speaker notes
student notes
cheat sheet
student sheet
The process of planning your multimedia presentation is known as the:
design
storyboard
development
layout
timeline
Which is the input device of the computer:
keyboard
musical columns
printer
plotter
system block
Which of the following is the basic components the personal computer:
keyboard, system block, display, mouse
display, monitor, joystick
display, scanner, digitizer, system block
modem, CDROM, keyboard, printer
network payment, keyboard, system block
Which element was the primary element of the second generation computers?
lamps
transistors
integrated chips
microprocessors
mechanical devices
Which element was the primary element of the first generation computers?
lamps
transistors
chips
microprocessor
mechanical devices
Which year the first PC was created?
1949
1941
1946
1951
1972
the First operating computer was called ______
Mark-1
IBM
Ural
ЕNIАС
Minsk
Who invented the first operating summarizing car:
Newton
Pascal
Virt
Neumann
Kant
Which of the system s of coding is used in computer facilities:
the Roman
binary
the decimal
the Arab
the alphanumeric
Multiprogramming systems allow to user:
execute more jobs in the same time period
are easier to develop than single programming systems
execute each job faster
are used only by one user
are used only one large mainframe computers
The Signal will be continuous if
the signal accepts any value from the set range
the parameter of a signal accepts consecutive in time final number of values
the source of information sends only one bps
information is transferred by means of a wave
the source develops discretely the message
The Signal will be discrete if:
the parameter of a signal accepts consecutive in time final number of values
information is transferred consistently
the source develops the continuous message
information is transferred by means of a wave
the source sends only one bps
____________ refers to any type of application or presentation that involves more than one type of media, such as text, graphics, video, animation, and sound
an executable file
desktop publishing
multimedia
hypertext
graphic
. Images included in many software titles are called____
cliparts
popups
.jpg files
.tiff files
bitmap
What is a vector graphic?
an image comprised of a series of colored pixels
an image drawn or printed on paper
an image represented with use of polygons
an image where all lines are curved
an image formed of a series of colored pixels
Color printing is done in _____ color format:
RGB
RYB
CMYK
CMBK
RBG
Which of the following file formats is not a piece of video?
AVI
MOV
MPEG
PNG
MP4
When items (graphics, audio and video) are imported to Movie Maker, they appear in _______section of the interface:
collections
library
storyboard
timeline
bank
In the storyboard mode of Windows Movie Maker, you can insert _________ effects that smoothly move the film from one graphic or film clip to another.
sound
title
transition
enhancement
prezentation
To use an Illustrator file in another application, you must save it in another format not AI, but another file type. To accomplish this, you must do this function
export
save as
save to file
place
finish
What are some examples of multimedia?
video games, movies, and television
television series
computer-generated graphics
digital pictures
clipart pictures
What is multimedia?
moving images and text
images and audio
integration of still and moving images, text and sounds by means of computer technology
programs that combine text and images on a television screen
computer-generated graphics
The slide ________ controls text characteristics, background color and special effects, such as shadowing and bullet style
presentation
master
show
sorter
view
One gigabyte of information is:
100 mbytes
1 million bytes
1024 mbytes
10th billion bytes
1024 kilobytes
1 Kilobyte is equal to____
1 bit
1000 bytes
8 bits
24 bits
1024 bytes
What does the informatics aim to study?
forms of movement of a matter
ways of collecting, storage, processing and information transfer by means of the computer
programming languages
business games, technical characteristics of peripherals
computer device
The message is:
data transferred between objects of a material world
information
material data carrier
set of codes or the signs displaying this or that information
the set of symbols or signals conveying some information
. Information is:
messages transferred between objects of a material world
data transferred between objects of a material world
the general scientific concept including an exchange of signals between objects of a material world
the general scientific concept including storage of data on objects of a material world
the scientific concept including an exchange of data between objects of a material world
The Term "Informatics" occurs from two words:
information and automatic
science and automatic
information and equipment
information and cybernetics
Excel usually identifies cells within a worksheet with a
cell locator coordinates
column letter and row number
column numbers and row letters
cell names
Getting data from a cell located in the different sheet is called…
accessing
referencing
updating
functioning
formatting
. A worksheet range is
a command used for data modeling
a range of values such as from 23 to 234
a group of cells
a group of worksheets
a different sheets
Data series in the chart wizard refers to_____. (MS Excel)
the chart legend
the collection of chart data markers
the set of values you plot in a chart
the data label
the symbol
The text color in the presentation should contrast with the color of the ________
CPU
frame
stack
background
RGB
One of the disadvantages of multimedia is its:
cost
adaptability
usability
relativity
activity
When you copy a formula
excel erases the original copy of the formula
excel edits cell references in the newly copied formula
excel adjusts absolute cell references
excel doesn’t adjust relative cell references
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
%A%1
Which symbol is used before a number to make it a label (MS Excel)?
quote
= equal
underscore
apostrophe
==duble equal
Which of the following is not an example of a value? (MS Excel)
350
May 10, 2016
0.57
1024
=Serial Number 50771
Which of the following formulas Excel will not be able to calculate (MS Excel)?
=SUM(A1:A5)-10
=SUM(A1:A5)/(10/10)
=SUM(A1:A5)*5
A) =SUM(sales)-A3
=SUM(A1:A5)
Which of the following formulas is not written correctly (MS Excel)?
=10+50
=B7*B1
= B7+14
10+50
=B7/B1
Which symbol should be used to start the formula (MS Excel)?
=
+
(
@
#
