Quiz
Exam 2 (Tutorial 1)
This quiz has question types that open in the usual player.
Questions in this quiz (20)
1A [blank_start]spreadsheet[blank_end] is a collection of text and numbers laid out in a rectangular grid.
- Aspreadsheet
2 In spreadsheet term, a(n) _____ contains an Excel chart that provides a visual representation of
spreadsheet data.- AWorksheet
- BChartsheet
- CCell
- DActive Cell
3 On the ribbon, click the [blank_start]file[blank_end] tab to display backstage view.
- Afile
4A [blank_start]documentation sheet[blank_end] reminds you why you created a workbook and what it contains.
- Adocumentation sheet
5Each cell is identified by a(n) [blank_start]cell reference[blank_end] which is based on the cell’s column and row location.
- Acell reference
6What does a green triangle in a cell indicate? [blank_start]A potential error[blank_end]
- AA potential error
7[blank_start]Auto Fit[blank_end] changes the column width or row height to display the longest or tallest entry within the
column or row.- AAuto Fit
8If you increase the font size of characters, you can fit more text within a given cell.
- ATrue
- BFalse
9 To select adjacent ranges, hold down the ___________ key and then select the range.
- AHome
- BShift
- CAlternate
10A(n) [blank_start]formula[blank_end] is a mathematical expression that calculates a value.
- Aformula
11 A worksheet can contain the following type of data: text, numeric values, dates, and
calculated values.- ATrue
- BFalse
12The _____ calculates the total number of values.
- ASum
- BAverage
- CMedian
- DCount
13 Functions are used to simplify formulas.
- ATrue
- BFalse
14 New Excel workbooks contain how many worksheets?
- Aone
- Btwo
- Cthree
- Dfour
15Worksheets cannot be deleted.
- ATrue
- BFalse
16To edit a cell’s contents, you need to work in [blank_start]editing mode[blank_end].
- Aediting mode
17You can reverse more than one action by clicking on the Undo button’s list arrow.
- ATrue
- BFalse
18[blank_start]scaling[blank_end] a printout reduces the width and the height of the printout to fit the number of pages you
specify by shrinking the text size as needed.- Ascaling
19If you forget to put an = sign at the beginning of a formula, what will appear in the cell?[blank_start]The data you entered not the calculation[blank_end].
- AThe data you entered not the calculation
20 How can you correct the problem without re-keying the formula?
- APress F2 (to edit the cell
- Bpress the Home key (to move the insertion point to the beginning of the cell);
- Cpress the Equal sign; and
press Enter)
Information
- Description
- 2610 BCIS Quiz on Exam 2 (Tutorial 1), created by Chris Serrano on 30/10/2015.
- Author
- Chris Serrano
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz