MIS Final Exam

A type of spyware known as _________ can record the individual keystrokes of a user. A. keyloggers B. ransomware C. pay-per-click D. trojans

A

Before using the Merge & Center command, what cell should contain the data? A. upper-left cell B. bottom-left cell C. upper-right cell D. bottom-right cell

A

How many charts can be combined in a combination chart? A. 2 or more B. 3 C. 4 D. 5

A

In a table which of the following must be identifies as the primary key? A. field B. record C. object D. query

A

Instead of calling a taxi company or hailing a cab on the street, apps such as ___ connect drivers who have some free time and individuals who need transportation. A. Uber B. Airbnb C. Reddit D. Tumblr

A

Suppose you are shopping for a computer and the description lists the following: Intel i7 3630QM3. Which component is being described here? A. CPU B. RAM C. SSD D. Motherboard

A

The piracy of music and movies is often evident on file-sharing services that use _________ protocol. A. BitTorrent B. VoIP C. ICMP D. Tunneling

A

To select non-adjacent worksheets, which key must you press? A. Ctrl B. Alt C. Shift D. Tab

A

What can pie charts graph? A. a single data series B. up to three data series C. up to five data series D. an unlimited number of data series

A

What must you build to use an Advanced Filter? A. a criteria range B. a data range C. an extract range D. filters

A

Which of the following characters causes characters to display in lowercase in a short text and long text field? A. < B. > C. @ D. [color]

A

Which of the following features expands or reduces a worksheet to print on a specific number of pages? A. Scale to Fit B. Zoom C. Advanced Properties D. Print Area

A

Which of the following features would you want to use to center worksheet titles over multiple cells? A. AutoFormat B. AutoFit C. Merge & Center D. Wrap Text

A

Which of the following has an answer of 14? A. 2+4*3 B. (2+4)*3 C. 3+2*4 D. (2+3)*4

A

Which of the following input mask characters requires a user to enter a number? A. 0 B. L C. ! D. "

A

Which of the following is NOT a type of memory card technology? A. Mega SD B. SD C. Mini SD D. Micro SD

A

Which of the following is NOT a type of network topology? A. Fiber B. Mesh C. Bus D. Star

A

Which of the following is a color-coded editing tool that applies different colors to each cell range within a formula? A. Range Finder B. Formula Auditing C. Evaluate Formula D. Select Method

A

Which of the following is a complete set of elements that is displayed in a chart? A. chart layout B. chart style C. Quick Layout D. none of the above

A

Which of the following is the default paste option? A. Paste B. Formulas C. Formulas & Number Formatting D. Match Destination Formatting

A

Which of the following is used to enter records into a table? A. Datasheet view B. Design view C. Lookup view D. Validation view

A

Which of the following lets you select a chart element? A. clicking B. double-clicking C. triple-clicking D. none of the above

A

Which of the following refers to the process of verifying the accuracy, or integrity, of data? A. data validation B. metadata testing C. data integrity testing D. relationship testing

A

Which of the following refers to the task of obtaining data from another software program or another file format? A. imported data B. exported data C. flash fill D. data connecting

A

Which of the following should you do to the database file when you are finished working on it? A. save B. back up C. close D. rename

A

Which of the following simplifies the process of entering the months of the year in a worksheet? A. Fill Handle too; B. AutoSum button C. Headings option D. Freeze Panes option

A

Which of the following statements is False? A. Sheet tab names cannot be more than 15 characters B. You can apply a color to a sheet tab C. There is no default color to sheet tabs D. The default names within a workbook are Sheet1, Sheet2, and so on.

A

How should you save a file if you want it to be compatible with older versions of Microsoft Excel? A. Excel Macro-Enabled Workbook B. Excel 97-2003 Workbook C. Excel Template D. Excel Macro-Enabled Template

B

On which tab would you find Access's features for formatting text? A. File B. Home C. Create D. Format

B

Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly? A. F2 B. F4 C. F6 D. F8

B

What is the actual (not approximated) value of a kilobyte? A. 1,000 bytes B. 1,024 bytes C. 1,048 bytes D. 2,048 bytes

B

What would a text file be called that uses a character, such as a comma or a tab, to separate the fields? A. formatted text file B. delimited text file C. fixed width text file D. all of the above

B

Which of the following best describes a Z to A sort? A. ascending B. descending C. rising D. sliding

B

Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied? A. F2 B. $F$2 C. $F2 D. F$2

B

Which of the following characters causes characters to display in uppercase in a short text and long text field? A. < B. > C @ D. [color}

B

Which of the following commands should you use to prevent column and row headings from scrolling off the screen? A. Zoom options B. Freeze Panes command C. Status bar view buttons D. Merge & Center command

B

Which of the following features resizes column width or row height to accommodate the width or height of the largest entry? A. AutoFormat B. AutoFit C. Fill Handle D. Wrap Text

B

Which of the following functions multiplies and then adds a series of arrays? A. SUMIF B. SUMPRODUCT C. ROUND D. none of the above

B

Which of the following input mask characters requires a user to enter a letter? A. 0 B. L C. # D. 9

B

Which of the following is NOT a popular computer programming language? A. C++ B. Xero C. Visual Basic D. Java

B

Which of the following is data that originates in a another program or format? A. imported data B. external data C. source data D. text file

B

Which of the following is helpful for inserting formulas and editing data? A. gridlines B. Formula bar C. Name box D. cell reference

B

Which of the following is the default name that Access assigns to new blank tables? A. Table01 B. Table1 C. Datasheet01 D. Datasheet1

B

Which of the following must you do before adding a field between existing fields? A. enter a field name B. enter a data type C. select a primary key D. insert a new row

B

Which of the following options allows you to copy formatting attributes and styles from one cell to another cell or group of cells? A. Fill Handle B. Format Painter C. Paste Special D. Format Cells

B

Which of the following paste options copies the data and formulas from the source cell(s), but not the formatting? A. Paste B. Formulas C. Formulas & Number Formatting D. Keep Source Formatting

B

Which of the following paste options is the same as the "Paste" option? A. Merge Conditional Formatting B. Match Destination Formatting C. Formulas & Number Formatting D. Keep Source Formatting

B

Which of the following should you do to the database file when you are finished working on it? A. save B. back up C. Datasheet01 D. Datasheet1

B

Which of the following statements is true? A. You cannot import a data table or query directly from an Access database into an Excel worksheet. B. Access database files have a .txt extension. C. When a database includes many tables and queries, the select table box opens so that you can choose the table query you want to import. D. If a database has a single table or query, it is automatically imported into Excel.

B

Which of the following tabs must you use to initially create all the objects you use in a database? A. file B. create C. Databsae Tools D. External data

B

Which of the following views lets you apply headers and footers and view the layout of the spreadsheet prior to distribution? A. Normal view B. Page Layout view C. Page Break Preview D. Full Screen view

B

In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following terms desribes what is going one with this formula? A. absolute reference B. mixed reference C. circular reference D. none of the above

C

What is a collection of related fields called? A. field B. record C. table D. database

C

What must you do to enter a number as a label in a cell? A. Press spacebar before typing the number B. Type an open parenthesis before the number C. Type an atmosphere before the number D. Format the number as a label

C

What would you call a table added to the bottom of your chart that contains the values of each data series? A. trendline B. data label C. data table D. source data

C

Where can you view each object in your database? A. Navigation pane B. File tab C. datasheet D. Navigation menu

C

Which of the following displays the result of a formula? A. cell B. range C. Formula bar D. Fill Handle

C

Which of the following functions counts the number of cells in a range based on specified criteria? A. COUNTA B. COUNTBLANK C. COUNTIF D. DCOUNT

C

Which of the following has an answer of 11? A. 2+4*3 B. (2+4)*3 C. 3+2*4 D. (2+3)*4

C

Which of the following is NOT one of the specifications of Wi-Fi technology? A. 802.11g B. 802.11n C. 802.11x D. 802.11ac

C

Which of the following is a set of predefined formatting you can apply to titles, subtitles, column headings, row totals, and other areas of your worksheet? A. cell style B. range style C. worksheet style D. Format Painter

C

Which of the following lets you create your own conditional formatting rule as well as edit existing rules? A. Data Bar command B. Conditional Formatting Command C. Manage Rules command D. Rules command

C

Which of the following must you press to enter a manual line break in a cell? A. Ctrl+Enter B. Ctrl+F4 C. Alt+Enter D. Ctrl+F5

C

Which of the following occurs when a formula includes the cell address of a formula? A. absolute reference B. relative reference C. circular reference D. mixed reference

C

Which of the following tabs provides information about your database and additional functions to help you manage the database? A. file B. create C. database tools D. external data

C

Wi-Fi radio signals operate on either the 2.4 GHz or ___ GHz bands. A. 3 B. 4.7 C. 5 D. 7

C

Which of the following displays when you place your pointer on the border of an active cell or cells? A. selection pointer B. fill pointer C. move pointer D. resize pointer

C. move pointer

What do you call a row in a table that has exactly the same information in one or more columns? A. identical row B. matching row C. equal row D. duplicate row

D

What does Access do when data is entered that violates rule? A. displays the lookup tab B. zooms in on error C. switches to datasheet view D. displays a message box

D

What name does Excel automatically assign to a new workbook that you open? A. Book1 B. Sheet1 C. Workbook1 D. Worksheet1

D

Which of the following Formula Auditing tools displays arrows to all cells that use the active cell directly or indirectly in a formula? A. Trace Precedents B. Trace Dependents C. Error Checking D. Evaluate Formula

D

Which of the following best describes the size of an Excel 2016 worksheet? A. over 8,000 columns B. over 500,000 rows and 8,000 columns C. over 16,000 columns and 1 million rows D. over 1 million columns and 16,000 rows

D

Which of the following can be built from a PivotTable? A. PivotFormats B. PivotFills C. PivotFiters D. PivotCharts

D

Which of the following is NOT one of the three questions that potential whistleblowers should ask themselves should ask themselves? A. Have I alerted my supervisor and, if needed, the top level managers of the organization? B. Is the activity in question illegal or likely to cause harm to the public? C. Do I have documented proof of the activities that will cause this alleged harm? D. Can the exposure of this information put the organization's reputation at risk?

D

Which of the following is a rectangular area bounded by the horizontal and vertical axes? A. axis B. chart area C. legend D. plot area

D

Which of the following is not True about filters? A. A filter is criteria that specifies which data is shown B. A filter is criteria that specifies which data is hidden C. Filters let you switch between several scenarios for your data D. Filters alter the source data range

D

Which of the following statements is True? A. A chart filter does not change the source data range. B. Editing the data source changes the source data range in the worksheet. C. Adding a series to the data source changes the data range in the worksheet. D. all of the above

D

Which of the following tabs provides functionality for linking to other applications and data files? A. file B. create C. database tools D. External data

D

While storms could be a cause, power ________ are more likely to be caused by disturbances from high-demand equipment in a home or building. A. fluctuations B. failures C. vulnerabilities D. redundancies

D