Search
Info
Warning
Danger

Study Resources (Accounting)

83) Selecting ________ from the Freeze Panes command gallery removes frozen panes form a worksheet. 84) The tab label for a worksheet that is named Total and is copied to the same workbook is ________. 85) Data in an Excel table are managed ________ from other data in the worksheet. 86) The Format.
0 Views
View Answer
  1) A ________ is a group of numbers, text, dates, or time periods that come in succession. A) chain B) sequence C) series D) succession 2) The Excel feature used to automatically adjust column width to the longest column entry is ________. A) AutoFit B) AutoComplete C) AutoAdjust D) AutoFill 3) The displayed value of a cell is replaced with.
4 Views
View Answer
81) A computer is a system of smaller ________ working together. 82) ________ is a set of instructions stored on your computer. 83) A(n) ________ computer is designed to be placed permanently at a work station. 84) A method for interacting with the computer using icons is called a(n) ________. 85) When a tile.
0 Views
View Answer
11) All of the following are options of the Clear button EXCEPT ________. A) Clear All B) Clear Formats C) Clear Contents D) Clear Error Value 12) When Clear Content is selected from the Clear button options, only the ________ is removed from the cell. A) fill B) text C) comment D) hyperlink 13) The cut and copy commands make.
1 Views
View Answer
11) The ________ format does not display commas or trailing zeros to the right of a decimal point. A) Currency B) General C) Accounting D) Percentage 12) Moving between worksheets in a workbook is done by clicking on ________. A) the title bar B) the name box C) a worksheet tab D) the new option from the Quick Access.
0 Views
View Answer
31) All prebuilt Excel functions are volatile. 32) The function COUNT returns the number of cells that are in the user selected range and have a number as the displayed value. 33) The functions TODAY and NOW have no arguments. 34) The functions TODAY and NOW are volatile. 35) The function IF is a.
0 Views
View Answer
59) Formulas with multiple operators CANNOT be entered in grouped worksheets. 60) Changes like row insertion, column insertion, and column widening are NOT made to all the worksheets in a group. 61) Selecting a row and clicking the Insert command, inserts a row above the selected row. 62) Single-clicking on a row heading.
0 Views
View Answer
  1) When Excel opens, a new blank ________ is displayed. A) presentation B) document C) workbook D) database 2) In a workbook, pages are referred to as ________. A) subworkbooks B) worksheets C) pages D) gridsheets 3) In Excel the term worksheet and ________ mean the same thing. A) spreadsheet B) datasheet C) reference sheet D) workbook 4) When identifying a cell as B5, you.
2 Views
View Answer
91) A(n) ________ converts paper images to digital images. 92) A(n) ________ is one trillion bytes. 93) If you want to project text and graphics on a screen for an audience to view, it is best to use a(n) ________. 94) ________ computing delivers services provided via the Internet. 95) If you save.
1 Views
View Answer
Match the worksheet term with its corresponding meaning. A) Data displayed in the formula bar B) Data displayed in a worksheet cell C) Two or more adjacent cells in a worksheet D) Feature that displays a portion of text content in a cell E) Area that displays active cell reference 106) Displayed value 107) Underlying value 108) Range 109).
2 Views
View Answer
21) Which of the following statements is NOT true about wired networks? A) Less expensive to install B) Transmits signals through wires C) Transmits data faster than wireless D) Is more secure than wireless 22) A ________ is a device that translates signals between a router and an ISP. A) port B) modem C) touchpad D) smartphone 23) When you.
0 Views
View Answer
51) Function keys, [PageUp] and [Print Screen], also perform commands. 52) Fingerprint scanners allow authorized users access to the computer. 53) In a Windows file system, a hard disk drive is commonly assigned the drive letter E. 54) If you were typing a report and hadn't saved it yet and the power cord.
1 Views
View Answer
71) A monitor, headphones, and printer are examples of ________ devices. 72) A(n) ________ program is a small program designed to perform routine tasks. 73) A pen-like pointing device used with a touch screen is a(n) ________. 74) Another name for a flash drive is a(n) ________ drive. 75) Applications are also referred.
0 Views
View Answer
Select the description that best matches the chart type. A) Displays part-whole relationship B) Emphasizes magnitude of change over time C) Illustrates comparisons of individual items D) Illustrates change in data over time E) Illustrates trends over time 91) Area chart 92) Bar chart 93) Column chart 94) Line chart 95) Pie chart Select the description that best matches the chart.
1 Views
View Answer
Match each paste option with its description. A) Pastes only formatting to paste area B) Pastes content and formatting to paste area C) Pastes only formulas to paste area D) Pastes all content and formatting, including column width formatting, to paste area E) Rows from original cells are pasted as columns in paste area 97) Paste 98).
1 Views
View Answer
11) Which is NOT a text rotation or angle option in the Orientation list? A) Angle Clockwise B) Angle Counterclockwise C) Vertical Text D) Reverse Vertical Text 12) What is applied to a cell when the value of the cell meets a specified condition? A) Logical formatting B) Conditional formatting C) Criteria formatting D) Provisional formatting 13) The Text That.
3 Views
View Answer
61) Wireless networks transmit signals via radio waves. 62) An unsecured network requires a password to connect to it. 63) If your files are stored on Cloud servers and you do not have an Internet connection, you won't be able to access your files. 64) Streaming media is a Cloud-based service used to.
0 Views
View Answer
31) Select the ________ option from the Auto Fill Options menu to keep numeric values unchanged when using the fill handle. A) Copy Cells B) Fill Series C) Fill Format Only D) Fill Without Formatting 32) Which number format adds commas where appropriate and displays two decimals? A) Currency B) Comma C) General D) Percentage 33) Number formats can be.
0 Views
View Answer
Match each function-related term with its description. A) Applies a logical test to see if a specific condition is true B) Placed around text values used as function arguments C) Conditions specified in a logical test D) Compares two values and returns true or false E) Placed between function arguments 95) Logical function 96) Comparison operator 97) Criteria 98).
1 Views
View Answer
  1) Each Office application's start page displays ________. A) posts B) recent documents C) home pages D) contacts 2) Click an open application's button on the ________ to make it the active window. A) Ribbon B) desktop C) Quick Access Toolbar D) taskbar 3) Which of the following is an example of editing text? A) Changing font style B) Replacing existing.
3 Views
View Answer
21) According to the rules of operator precedence, expressions using ________ are calculated first. A) parentheses B) multiplication C) division D) addition or subtraction 22) According to operator precedence, the correct order of mathematical operations is ________. A) parentheses; multiplication or division; addition or subtraction B) parentheses; addition or subtraction; multiplication or division C) addition or subtraction; multiplication.
0 Views
View Answer
  1) The prebuilt Excel function ________ returns the serial number of the current date and time. A) TODAY B) COUNT C) DATE D) NOW 2) The prebuilt Excel function ________ counts the number of cells that are in the entered range and contain numeric values. A) NOW B) COUNT C) COUNTA D) COUNTIF 3) The functions TODAY and NOW are.
4 Views
View Answer
21) Themed Cell Styles is an option in the ________. A) Conditional Formatting gallery B) Cell Styles gallery C) Format gallery D) Format as Table gallery 22) Which feature displays the formatting of the style moused over in the Cell Styles gallery on the selected cells in the worksheet? A) Print Preview B) Display Preview C) Live Preview D).
1 Views
View Answer