Deck 1: Creating a Worksheet and a Chart

Question 1

To print a worksheet,you begin by going to Backstage view.

Answer 1

True

Question 2

To print worksheet contents across the length of a page,you can use portrait orientation.

Answer 2

False

Question 3

To print more than one copy of your worksheet,which tab would you go to?

A) View
B) Page Layout
C) Insert
D) File

Answer 3

D

Question 4

You can use the I-beam pointer to copy cell contents into adjacent cells.

Question 5

You can use the DELETE key to clear cell contents.

Question 6

When you enter a value in a worksheet cell,it is automatically left-aligned.

Question 7

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

A) The formula =B6+B7+B8+B9+B10.
B) The formula =TOTAL(B6-B10)
C) The formula =SUM(B6:B10)
D) The formula +SUM(B6-B10)

Question 8

To print your worksheet on a piece of paper larger than 8-1/2 x 11",which Excel tab would you use?

A) Home
B) Page Layout
C) Insert
D) View

Question 9

Which of the following lets you edit the contents of a cell?

A) Click the cell,click the status bar,and press Enter.
B) Click the cell and click in the status bar.
C) Double-click the cell,click in the status bar,or just start typing.
D) Double-click the cell or click in the formula bar.

Question 10

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

Question 11

Which of the following tabs lets you see exactly how your worksheet looks before printing?

A) Insert
B) View
C) Formulas
D) File

Question 12

Which of the following functions would you use to calculate the arithmetic mean of a price list?

A) MAX
B) COUNT
C) SUM
D) AVERAGE

Question 13

In the formula =SUM(A6:A9),which of the following best describes A6?

A) argument
B) function
C) label
D) active cell

Question 14

Where can you see a preview of how your worksheet will look when printed,including headers?

A) Print tab in Backstage view
B) Page Break preview
C) Normal view
D) File preview

Question 15

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

Question 16

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

A) mode indicator
B) Page Break Preview
C) scroll bar
D) Fill handle

Question 17

You can edit cell contents in the Formula bar or in the cell itself.

Question 18

To fit all worksheet content on one page,you can set page scaling in Backstage view.

Question 19

To have Excel enter the lowest price from a range of prices,which of the following would you use?

A) MAX function
B) COUNT function
C) MIN function
D) COUNTA function

Question 20

To see a preview of how a pasted value will look,which of the following would you use?

A) Fill button
B) AutoFill Options button
C) Paste button
D) Paste List arrow

Question 21

Your worksheet is too wide to fit on one portrait page.What is the best way to fix this problem?

A) Hide the column headings.
B) Insert a function.
C) Copy columns to the next page.
D) Change the page orientation to landscape.

Question 22

If you discover an error immediately after you have confirmed a cell entry,what of the following would you use next?

A) The Undo button on the Quick Access toolbar
B) The Cancel button on the Formula bar
C) The Enter button on the Formula bar
D) The Save button on the Quick Access toolbar

Question 23

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

Question 24

When you cut or copy a cell,it is cut or copied to which of the following?

A) Neither the Windows or Office Clipboard
B) Both the Windows and Office Clipboard
C) Only the Office Clipboard
D) Only the Windows Clipboard

Question 25

To select a single worksheet cell so you can work with it,which of the following would you do?

A) Click the cell.
B) Move the cell pointer over the cell.
C) Click the status bar.
D) Click the Name box.

Question 26

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

A) Clipboard
B) Backstage
C) Name box
D) Worksheet window

Question 27

How many actions does the Undo button let you reverse?

A) 24
B) 50
C) 75
D) 100

Question 28

On which tab and button are document properties located for editing?

A) File tab,Info Button
B) View tab,Show button
C) Review tab,Changes button
D) Home tab,Alignment button

Question 29

To insert an equation,click on the Object in the Text group on the Insert tab,then click Microsoft Equation 3.0 in the Object type box,and then click OK.

Question 30

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?

A) Insert Column Chart
B) Insert Combo Chart
C) Insert Pie or Doughnut Chart
D) Insert Stock,Surface or Radar Chart

Question 31

Which of the following is a built-in formula that helps you perform complex calculations?

A) clipboard
B) mode indicator
C) named range
D) function

Question 32

Which of the following tabs lets you set worksheet print options?

A) File
B) Home
C) Page Layout
D) View

Question 33

Which of the following lets you search for a function or select one from a category?

A) Function Arguments dialog box
B) clipboard
C) formula bar
D) Insert Function dialog box

Question 34

The Comma Style format adds a comma and a dollar sign to a cell value.

Question 35

Which of the following functions inserts the total of a range?

A) ROUND
B) AUTOSUM
C) AVERAGE
D) SUM

Question 36

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

A) Normal pointer
B) I-beam pointer
C) Move pointer
D) Copy pointer

Question 37

To customize the status bar,right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.

Question 38

Binay wants to create an X-Y scatter plot.To do so,he should select the data he wants to plot in the scatter chart,then click the Insert tab,and then click Insert Scatter (X,Y)or Bubble Chart.

Question 39

Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?

A) Style
B) Color
C) Border
D) Shape

Question 40

To print your worksheet at its actual size,which of the following would you select?

A) Fit to
B) No scaling
C) Fit sheet to one page
D) Scale to fit

Question 41

The default worksheet text is _____-point Calibri.

A) 10
B) 11
C) 12
D) 14

Question 42

To apply a cell style,you would use the Cell Styles command on the _____ tab.

A) Layout
B) Insert
C) View
D) Home

Question 43

To align currency symbols and decimal points in a column of numbers,you can apply the ____ number format.

A) Currency
B) Accounting
C) Percentage
D) General

Question 44

When you double-click a cell's right column border,which of the following occurs?

A) The column is deleted.
B) AutoFit resizes the column to 8.43 characters wide.
C) A column is added to the right of the column's border.
D) AutoFit resizes the column to the widest cell entry.

Question 45

When you underline cell content,you are using _____.

A) a font style
B) an orientation setting
C) an indent setting
D) a centering style

Question 46

A _______ refers to a collection of characters with a similar,specific design.

A) symbol
B) font
C) point
D) keyword

Question 47

To combine multiple cells into one combined cell,which of the following do you use?

A) Column Width command
B) Center button
C) Merge and Center button
D) Increase Indent button

Question 48

To change the color of cell content,you use the ________ color list arrow.

A) Cell
B) Text
C) Pattern
D) Font

Question 49

To return cell contents to its default font and style,you can use the _____ command.

A) Clear Formats
B) Clear Contents
C) Clear All
D) Clear Comments