COMPUTER I K0V2Quiz 6&7. Attempt Score: 88 / 100 - 87.5 %

Question 1 2.5 / 2.5 points __________is a feature in Excel that works with alphabetic values. Question options: a) AutoComplete b) SharePoint c) AutoFit d) AutoFill Question 2 2.5 / 2.5 points In Excel, there ...

Question 1 2.5 / 2.5 points __________is a feature in Excel that works with alphabetic values. Question options: a) AutoComplete b) SharePoint c) AutoFit d) AutoFill Question 2 2.5 / 2.5 points In Excel, there are a maximum of ________ rows. Question options: a) 500 thousand b) 1 million c) 5 million d) 1 billion Question 3 0 / 2.5 points Values can be text values, number values, or _______values. Question options: a) formula b) calculation c) date and time d) empty cell Question 4 2.5 / 2.5 points Related data points represented by data markers; each ___________has a unique color or pattern represented in the chart legend. Question options: a) data series b) data value c) displayed value d) data style Question 5 2.5 / 2.5 points With Excel Online you use ___________to create, view, and edit workbooks. Question options: a) Dropbox b) your web browser c) SharePoint d) OneDrive Question 6 2.5 / 2.5 points You can insert ___________in an Excel worksheet to give a visual trend summary alongside your data. Question options: a) sparklines b) legends c) axes d) data points Question 7 2.5 / 2.5 points Excel 2016 is a tool to communicate ___________business information effectively. Question options: a) quantitative b) qualitative c) strategic d) managerial Question 8 2.5 / 2.5 points Columns are labelled with letters beginning with A and ending with ________ (16,384 columns). Question options: a) ZY b) ZXA c) XFD d) XHA Question 9 2.5 / 2.5 points Tracking total business sales in dollars along with total advertising and marketing expenditures with Excel allows you to see your __________ for each campaign. Question options: a) Return on Equity b) Return on Investment c) Cost of Capital d) Sales volume Question 10 2.5 / 2.5 points When others edit the worksheet, Excel Online shows their presence and the updates right away. This only works when: Question options: a) share folders have been set up. b) everyone is working in Excel Online. c) each Excel Online account is linked. d) workbooks are saved to Excel Online. Question 11 2.5 / 2.5 points Cell ________ refers to anything you type in a cell. Question options: a) content b) reference c) value d) entry Question 12 2.5 / 2.5 points With Excel Online you store workbooks on OneDrive or: Question options: a) Dropbox. b) SkyDrive. c) SharePoint. d) Windows Live. Question 13 2.5 / 2.5 points _______________ is a charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa. Question options: a) Move data b) Realign Row/Column c) Switch Row/Column d) Reconfigure Row/Column Question 14 2.5 / 2.5 points The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers is a(n. ______________ format. Question options: a) General b) Number c) Accounting Number d) Underlying Question 15 2.5 / 2.5 points If the first character you type matches an existing entry, Excel attempts to fill in the remaining characters using: Question options: a) SharePoint. b) AutoFit. c) AutoFill. d) AutoComplete. Question 16 0 / 2.5 points When using Google Sheets, you can download your Google file in several formats, including PDF or: Question options: a) Access. b) Excel. c) Word. d) PowerPoint. Question 17 2.5 / 2.5 points An Excel ________ contains one or more pages known as a worksheet or spreadsheet. Question options: a) workbook b) folder c) file d) document Question 18 0 / 2.5 points A specific way in which Excel displays numbers in a cell is a(n. ___________ format. Question options: a) General b) Number c) Accounting Number d) Underlying Question 19 2.5 / 2.5 points Small businesses often use Excel as a basic accounting program or: Question options: a) financial analysis tool. b) checkbook ledger. c) forecasting mechanism. d) for tracking sales volume. Question 20 2.5 / 2.5 points If you do not already have a Google account, you will need to create one before you can use Google Sheets. To do so, go to http://google.com and in the upper right corner, click: Question options: a) Start. b) Create Account. c) Sign In. d) New User. Question 21 2.5 / 2.5 points A ___________ is a picture element (a point of light measured in dots per inch). Question options: a) pixel b) operator c) label d) option tag Question 22 0 / 2.5 points The value that displays in the ___________ is the displayed value. Question options: a) Formula Bar b) Function Bar c) row calculation d) cell Question 23 2.5 / 2.5 points A __________ is two or more cells that are adjacent (next to each other) or non-adjacent (not next to each other). Question options: a) column b) width c) range d) cell cluster Question 24 2.5 / 2.5 points The default format that Excel applies to numbers is the ____________ format. Question options: a) comma b) calculating c) accounting d) general Question 25 2.5 / 2.5 points __________ is a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. Question options: a) Cell address b) Cell style c) Cell reference d) Cell content Question 26 2.5 / 2.5 points __________ is a charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa. Question options: a) Merge & Center b) Switch Row/Column c) Insert axis d) Move axis Question 27 2.5 / 2.5 points __________ is an element of the Excel window that displays the name of the selected cell, table, chart, or object. Question options: a) Cell content b) Graphic content c) Formula Bar d) Name Box Question 28 2.5 / 2.5 points An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is: Question options: a) AutoFit. b) AutoComplete. c) Quick Analysis tool. d) range finder. Question 29 2.5 / 2.5 points The symbols with which you can specify the type of calculation you want to perform in an Excel formula are: Question options: a) pixels. b) operators. c) data points. d) option tags. Question 30 2.5 / 2.5 points __________ is an equation that performs mathematical calculations on values in a worksheet. Question options: a) Formula b) AutoSum c) Operator d) AutoFill Question 31 0 / 2.5 points The data that displays in the Formula Bar is referred to as the: Question options: a) constant value. b) underlying value. c) formula. d) calculated value. Question 32 2.5 / 2.5 points A tiny chart in the background of a cell that gives a visual trend summary alongside your data and makes a pattern more obvious is a/an: Question options: a) Legend. b) Data field. c) Axis. d) Sparkline. Question 33 2.5 / 2.5 points The type of cell reference that refers to cells by their fixed position in a worksheet is: Question options: a) absolute. b) relative. c) exponentiation. d) central. Question 34 2.5 / 2.5 points __________ that refers to cells by their fixed position in a worksheet. Question options: a) Relative cell reference b) Dynamic cell reference c) Cell address d) Absolute cell reference Question 35 2.5 / 2.5 points The data that displays in the ______________ is the underlying value. Question options: a) Formula Bar b) Function Bar c) row calculation d) cell Question 36 2.5 / 2.5 points An element in the Excel window that displays the value or formula contained in the active cell is the: Question options: a) name box. b) status bar. c) formula bar. d) value box. Question 37 2.5 / 2.5 points __________ displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas. Question options: a) Insert Options button b) AutoComplete c) Quick Analysis Tool d) Data Analysis Tool Question 38 2.5 / 2.5 points On startup, Excel displays a new blank: Question options: a) document. b) workbook. c) worksheet. d) grid. Question 39 2.5 / 2.5 points The chart __________ is a combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells. Question options: a) type b) layout c) filters d) theme Question 40 2.5 / 2.5 points The area along the bottom of a chart that identifies the categories of data is the: Question options: a) data point. b) value point. c) value axis. d) category axis. Attempt Score: 88 / 100 - 87.5 %