BCIS Review 1
What could cause an external drive, like a USB flash drive, to not be recognized when plugged into a computer?
A faulty port
Jodi is traveling to San Francisco for a conference. She has stored her Powerpoint slides on Microsoft's web app. What could be of concern to her while presenting her slides?
A poor internet connection
If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.
Alt+Enter
in which format is data finally stored in computers?
Binary digits
Which of these is an optical medium of storage?
Blu-ray Discs
You can move to the previous or next sheet by pressing the ____ keys.
Ctrl+Page Up or Ctrl+Page Down
Speed Fill enters text based on patterns it finds in the data.
False
The name of the active workbook appears in the status bar of the Excel window.
False
The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.
False
The sidebar of a webpage typically contains information about when the site was last updated.
False
Juan is interested in getting a job In technology field. He is interested in protecting data from threats, and stopping backers and viruses. Which job would should Juan apply for?
Information Security
The ___________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.
Insert Function Dialogue Box
Which of the following would be considered a professional networking website?
Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.
Lookup Function
Which category of excel functions returns information about the format, location, or contents of worksheet cells?
Reference
Which of the following is the science that combines technology and engineering?
Robotics
AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.
True
Each header and footer has three sections-a left section, a center section, and a right section.
True
Functions are organized in the Function Library group on the FORMULAS tab.
True
Information literacy helps us to identify the tool most suited to elicit the kind of information we need
True
Numeric data is any number that can be used in a mathematical calculation.
True
Your smartphone can be used to connect to your television or cable service and record a show even if you are not home because both devices are smart devices.
True
Amelie lists her dishwasher for sale on eBay. Ryan , who lives in another city, bids for the best price and uses his credit card to pay for the dishwasher. Is this transaction an example of e-commerce?
Yes; it is a business transaction on a consumer-to-consumer website
TODAY is an example of a(n) ___ function.
date
_____________ removes the data from the row or column as well as removes the row or column itself.
deleting
one of the benefits of conditional ______________ is that it helps you analyze data by highlighting significant trends in data.
formatting ( conditional formatting)
One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.
merge
A(n) ________________ reference contains both relative and absolute references.
mixed reference (mixed)
The active cell is highlighted with a thick green border, its cell reference appears in the ________ the corresponding column and row headings are highlighted.
name box
Ten ____________________ colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—are always available regardless of the workbook's theme.
standard
