Technology in Business - MS Chapter 1 & MS Excel Lab 1 Quiz Review
In each of the years between 1999 and 2019, capital investment in information technology, consisting of IT equipment, software, and research and development (R&D), accounted for over ________ percent of U.S. total capital spending (in nominal GDP).
40%
The _________ displays the columns and rows that intersect to form the worksheet's cells.
A) Quick Access Toolbar B) Formula Bar C) Worksheet grid area D) name box Answer: C) worksheet grid area
_________ are streams of raw facts.
Data
Selling not only physical products, but also services.
E-commerce expansion
A continuing stream of information technology innovation is transforming the traditional business world.
IT Innovations
______ converts raw data into a meaningful form.
Information
________ consists of all the hardware and software that a firm uses to achieve its business objects.
Information technology (IT)
Emergence of online video services for streaming or downloading.
New business models
_______transfers the information to the people.
Output
All excel formulas begin with a(n) _________.
a) # sign b) % sign c) = sign d) + sign Answer: c) = sign
Hold down the. _________ key to select nonadjacent cells.
a) Ctrl b) spacebar c) f2 d) alt Answer: a) Ctrl
In Excel, row headings are identified by ___________.
a) Roman numerals b) numbers c) uppercase letters d) lowercase letters Answer: b) numbers
TIny charts embedded in a cell that display a visual trend summary alongside your data are called ____________.
a) data series b) data labels c) sparklines d) data markers. Answer: c) sparklines
A cell address is also referred to as a(n) __________.
a) label b) cell reference c) active cell d) value Answer: b) cell reference
Where is the fill handle located?
a) on the Home tab b) on the Quick Access toolbar c) in the lower right corner of a selected cell d) in the top right corner of an active cell Answer: c) in the lower right corner of a selected cell
Managers use social networks and _____________
collaboration tools
More emphasis on employees taking on multiple roles/tasks and collaborating with others on a team. Use __________ to listen to customers.
social media