Q&A Hero

Management

Q: The function that returns the specified number of characters from the start of a text string is: A) LETTER() B) INDEX() C) LEFT() D) IF()
Q: To reduce the chance of messing up range specifications, and minimize the likelihood that errors will creep in when columns and rows are added later: A) manually inspect all formulas on the spreadsheet B) do not hide columns in the spreadsheet C) always use absolute cell references in all formulas D) apply names in the spreadsheet
Q: The IF function specifies a(n): A) action on true outcome B) condition C) action on false outcome D) all of the above
Q: What symbol is used to denote absolute cell references? A) equal sign (=) B) dollar sign ($) C) percent sign (%) D) tilde (~)
Q: The Advanced Filter feature includes a: A) List range B) Criteria range C) Copy to option D) All of the above
Q: Place descriptive information: A) on the top and left B) on the top and right C) on the bottom and left D) on the bottom and right
Q: The first guideline of setting up effective spreadsheets is to: A) make them visually interesting B) focus on form C) avoid explanations that clutter the spreadsheet D) explain all processes
Q: Filtering is a process (especially in spreadsheets) for selecting items based on one or more criteria.
Q: "What if" analysis is a spreadsheet tool that temporarily recomputes entries based on alternative cell values.
Q: In a spreadsheet, names can only be applied to cell references, not individual cells.
Q: Excel provides automatic currency conversion with no need to write special formulas.
Q: In a spreadsheet, conditional formatting allows you to specify a format for cells that meet certain criteria.
Q: Use the File menu to insert comments in Excel.
Q: Fonts should be clear in a spreadsheet, and possibly differentiated for headings and data.
Q: Summary information should be placed at the top of a spreadsheet.
Q: Flexibility is an important characteristic of a spreadsheet.
Q: To help us create a list, spreadsheets give us an array of ________ that we fill in to set up our list.
Q: To change the way contents of a cell appears, you change its ________.
Q: A file with a .txt extension is an ASCII ________ file.
Q: The Min function is used to display the ________ item in a list.
Q: Cell references that do not change when copied from one cell to another are called ________ references.
Q: In a spreadsheet, a(n) ________ is a naming scheme that allows the user to refer to a group of cells by naming the first cell and the last cell and placing a colon (:) in between.
Q: The process of copying from one cell to many others by simply dragging is called ________.
Q: An absolute cell reference makes use of the ________ symbol in its formula.
Q: Data from another application that one wants to import into a spreadsheet is called ________.
Q: The ________ at the beginning of a cell entry determines whether a spreadsheet cell contains a formula or data.
Q: The rows of a spreadsheet are designated with ________.
Q: Spreadsheet columns are labeled with ________.
Q: What is another word that describes "pulling" the formula into other cells? A) dropping B) creating C) filling D) duplicating
Q: We can see spreadsheet results graphically by creating: A) complex formulas B) hidden columns C) charts D) absolute cell references
Q: To select a range of cells: A) double-click the first and last cells B) drag the cursor across the cells C) click Select on the Edit menu D) click the Add icon
Q: An example of conditional formatting is: A) applying a font color, e.g., green, to values over 500 B) applying currency format to cells that refer to money values C) applying italics to one column and bold to another column D) formatting a spreadsheet with alternate colors for each row
Q: A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n): A) date copy B) auto-increment C) conditional fill D) series fill
Q: Which of the following is used for computing common summary applications in a spreadsheet? A) formulas B) functions C) tables D) formatting
Q: In Microsoft Excel, all of the contents of the spreadsheet's cells, including the formulas, can be displayed by using the keyboard shortcut: A) Ctrl+Alt+Tab B) Ctrl+F1 C) Ctrl+` Note: grave accent (`) is on the same key with tilde (~) D) Ctrl+C
Q: The main purpose of a spreadsheet is to: A) display numerical results B) process numerical data C) organize factual data D) graphically present data
Q: Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it: A) is truncated B) is abbreviated C) is hyphenated D) cannot be entered into a cell
Q: A range of cells can include: A) cells from more than one row B) cells from more than one column C) the entire spreadsheet D) all of the above
Q: Spreadsheets: A) can only be sorted by column A B) can be sorted by any column provided the column is named C) are sorted by rows then columns D) can be sorted by any column
Q: The basic unit of a spreadsheet is a: A) box B) cube C) cell D) grid
Q: What is the most common application of a spreadsheet? A) as a journal B) to process text data C) to process numerical data D) as a drawing application
Q: Because there are two dimensions in spreadsheetscolumns and rowsthere are actually two ways a formula can be relative.
Q: The fill handle can be used to copy values but not formulas.
Q: Tables from a Web page can be pasted into a spreadsheet.
Q: A text file is the same thing as a tab-delimited file.
Q: Conditional formatting is used to format a range of cells; each cell is formatted depending on the value in the cell.
Q: Hidden columns cannot be referenced in a formula.
Q: By default, a formula in a spreadsheet will automatically recalculate if the value contained in any of the formula's cell references change.
Q: You cannot mix absolute and relative references in the same cell reference.
Q: Spreadsheets can only display time as military time.
Q: Functions and column letters in a spreadsheet are not case sensitive.
Q: Data can be copied from one cell to another, but formulas cannot.
Q: A formula in a cell always starts with an equal sign.
Q: All cells of a spreadsheet are always visible.
Q: Column widths in a spreadsheet must be set manually.
Q: A group of cells is called a range.
Q: Spreadsheets can only sort in ascending order.
Q: Cell entries in spreadsheets can be formatted similarly to formatting in word processors.
Q: A program which creates an access path by which attackers can run any program they want is called a ________ .
Q: A benign-sounding software download which performs malicious activities is called a ________ .
Q: The right to block or limit on-line information regarding long-ago offenses or dis-proven accusations is called ________ .
Q: Information that is recorded to hide its true meaning uses ________.
Q: Recovery after a disaster involves installing the most recent ________ backup copy.
Q: In computer security, compromised computers that act under the direction of an external master computer, often to send spam, are called ________.
Q: The ________ public key cryptosystem, invented by Rivest, Shamir, and Adelman, is one of the popular PKC algorithms.
Q: ________ is software intended to do harm to a computer connected to the Internet.
Q: Computer scientists have not yet proved the invincibility of the RSA scheme, but it can be "made more secure" simply by ________ the size of the key.
Q: A(n) ________ is published by the receiver and used by the sender to encrypt messages.
Q: ________, the practice of a Web site automatically sending details about your visit to other content providers, is an emerging problem of concern to privacy experts.
Q: ________ is the choice of approving to a use of information.
Q: ________ is the choice of disapproving to a use of information.
Q: The ________ principle of the OECD Fair Information Practices states that personal data gathered should be relevant to the purposes for which it is used, and should be accurate, complete, and up-to-date.
Q: ________ is the crime of posing as someone else for fraudulent purposes.
Q: ________ communication involves message exchange in which the content is encrypted to keep it private.
Q: Malware that directly manipulates operating system tables to hide its presence is known as ________.
Q: ________ is the process of recovering encrypted cipher text.
Q: In electronic privacy, tracking is used in two different ways, online tracking and ________.
Q: A(n) ________ is information stored on a Web client computer by an HTTP server computer.
Q: ________ and ________ entities are the two biggest threats to privacy.
Q: Most Americans wrongly assume that their privacy regarding business information is restricted to ________.
1 2 3 … 1,015

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts