Quiz
Exam 2 Tutorial 2
This quiz has question types that open in the usual player.
Questions in this quiz (25)
1 The _____ allows you to see the effects of formatting options on the workbook’s appearance before
you apply them.- Aa. Form Wizard
- Bb. Theme
- Cc. Live Preview
- Dd. Print Preview
2True/False: The Office theme is the default theme.
- ATrue
- BFalse
3True/False: Italic and bold are examples of a font style.
- ATrue
- BFalse
4 True/False: Theme colors are the 12 colors that belong to the workbook’s theme.
- ATrue
- BFalse
5 True/False: By default, Excel does not add background color to worksheet cells.
- ATrue
- BFalse
6 True/False: You cannot change the background image of a worksheet.
- ATrue
- BFalse
7Excel stores dates and times as [blank_start]numbers[blank_end]
- Anumbers
8 Dates are actually measured from what date? [blank_start]January 1, 1900 at 12 a.m.[blank_end]
- AJanuary 1, 1900 at 12 a.m.
9What is the Short Date format? [blank_start]The abb format for dates, mm/dd/yyyy[blank_end]
- AThe abb format for dates, mm/dd/yyyy
10True/False: Combining several cells into one cell is called merging.
- ATrue
- BFalse
11True/False: Text is oriented within a cell horizontally from left to right.
- ATrue
- BFalse
12You can also open the Format Cells dialog box by [blank_start]right clicking a cell[blank_end], and then clicking Format Cells on
the shortcut menu.- Aright clicking a cell
13What value does this function return: =AVERAGE (3, 6, 7, 8)?
- AA. 3
- BB. 5
- CC. 6
- DD. 7
14What is the syntax of the Average function? Answer: [blank_start]AVERAGE[blank_end]
- AAVERAGE
15 The most efficient way for copying only formatting is to use the _______ feature.
- Aa. Copy
- Bb. Ctrl-V (Paste) keyboard shortcut
- Cc. Merge cells
- Dd. Format Painter
16True/False: The Format Painter copies data as well as formatting.
- ATrue
- BFalse
17 True/False: You can click the Transpose button to paste the column data into a row or to paste the row
data into a column.- ATrue
- BFalse
18True/False: A style is a collection of formats.
- ATrue
- BFalse
19True/False: Excel has built-in styles to format worksheet titles.
- ATrue
- BFalse
20 True/False: You can save a workbook’s theme as a file that can be used in other workbooks or Office
files.- ATrue
- BFalse
21True/False: To make a worksheet active, click on the sheet tab.
- ATrue
- BFalse
22 To merge and center text in multiple cells, click the [blank_start]Merge and Center[blank_end] button.
- AMerge and Center
23 True/False: After you apply a table style, you can choose which table elements you want included in
the style.- ATrue
- BFalse
24True/False: Conditional formatting in a worksheet is special formatting applied when certain cell
values meet one or more conditions.- ATrue
- BFalse
25 A [blank_start]legend[blank_end] is a key that shows each color used in the worksheet and what it means
- Alegend
Information
- Description
- 2610 BCIS Quiz on Exam 2 Tutorial 2 , created by Chris Serrano on 30/10/2015.
- Author
- Chris Serrano
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz