MSIS Excel Study Guide

The first cell in EXCEL worksheet is labeled as _________. 1. AA 2. A1 3. A0 4. Ab

A1

An example of a range is 1. A1;B3 2. A1-B3 3. A1=B3 4. A1:B3

A1:B3

Which area in an Excel window allows entering values and formulas? Title Bar Menu Bar Formula Bar Standard Tool Bar

Formula Bar

"#####" in a cell means: 1. You've entered a number wrong 2. You've misspelled something 3. The cell is not wide enough 4. The formula is incorrect

The cell is not wide enough

=FUNCTION(argument1,argument2, ...) is ________. The syntax of writing optional arguments. An example of a formula. The general syntax of all functions. The general syntax of all formulas.

The general syntax of all functions.

What happens when dollar signs ($) are entered in this address, $B$2:$B$10? An absolute cell address is created. Cell address will change when it is copied to another cell. The range address is absolute. The status bar does not display the cell address.

The range address is absolute.

How do you know a range is active? It is highlighted on the screen. It has a bold solid line around it. The data changes to Bold to let me know it's active I'm psychic & I just Know!! Two of the above are correct.

Two of the above are correct.

If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to: Type the data in C1 Type the data in A1 and Merge cells A1:E1, then center text Choose Center from the Format menu Type the data in A1 and Merge cells A1:A5, then center text.

Type the data in A1 and Merge cells A1:E1, then center text

A __________ is a grid with labeled columns and rows. Worksheet Dialog box Clipboard Toolbar

Worksheet

An Excel Workbook is a collection of _______. Workbooks Worksheets Charts Charts and Worksheets Pivot Tables

Worksheets

Is it possible to insert a jpeg image from a file into an Excel spreadsheet? 1. Yes 2.No 3. It depends on the image

Yes

The order of operations in Math, which Excel follows, is? * / ^ () - + ^ () + - * / () * / ^ + - () ^ * / + - - + / * ^ ()

() ^ * / + -

In order to multiply items in Excel you would use_____. ^ # * @

*

What is the result of the following formula? =27/3+5-2^3+ (17-8)/3^2 9 6 7 11 14

7

What is the result of the following formula: =8+(7/(2+5)^2-1/7)*3 - 8 - 15 - 9 -29 -7

8

What is the result of the following formula: =(5-3)^2/1*2? - 2 -4 -6 -8 -1

8

A formula begins with: + # - = \ @

=

If cells are: A1=90, A2=85, A3=80, A4=75, and A5=75. What will be your formula if you are going to get the average? A1+A2+A3+A4+A5/5 + (A1+A2+A3+A4+A5)/5 +SUM(A1+A2+A3+A4+A5)/5 =SUM(A1:A5) =AVERAGE(A1:A5)

=AVERAGE(A1:A5)

A Range in Microsoft Excel refers to... A group of cells A calculation that describes the relationship between cells A way of arranging data in a particular order A place where you graze cattle.

A group of cells

What is the function of the autofit? A symbol that represents a specific action A way of arranging data in a particular order Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font Spandex

Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

In EXCEL, you can sum a large range of data by simply selecting a tool button called _____? Autosum Autofill Autocorrect Autoformat

Autosum

In"=SUM(number 1 (number 2,) number 3 ....) number 1, number 2, and number 3 may be numbers or 1. Letters 2. Cell references 3. Symbols 4. Formulas

Cell references

Which of the following is not a valid data type in Excel? 1. Character 2. Label 3. Number 4. Date/Time

Character

If you have columns that are truncating your content (not showing all the content), but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to: Abbreviate all text Reduce the font size to 8 pt Click Wrap text Delete one column

Click Wrap Text

A fast way to add up this column of numbers is to click in the cell below the numbers and then: 1. Click Subtotals on the Data menu 2. View the sum in the formula bar 3. Click the Autosum button on the Standard toolbar, then press ENTER 4. Use the Sum function from the Math Functions

Click the Autosum button on the Standard toolbar, then press ENTER

If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next? Click the Paste button on the Standard toolbar. Click the arrow on the Paste button on the Standard toolbar, then click Formulas. Click the arrow on the Paste button on the Standard toolbar, then click Values. Right click on the cell and select Paste from the dropdown menu.

Click the arrow on the Paste button on the Standard toolbar, then click Values.

Which is not the function of "Edit, Clear" command? Delete contents Delete notes Delete cells Delete formats

Delete cells

Which of the following is one way to change column width to fit the contents? Single-click the boundary to the left of the column heading. Double-click the boundary to the right of the column heading. Press ALT and single-click anywhere in the column. Press Tab + S

Double-click the boundary to the right of the column heading.

You can complete a cell formula entry that contains cell references by pressing _______. 1. Enter key 2. Any Arrow Key 3. Tab 4. All of the above

Enter key

A Formula and a function are the same thing. True False

False

There are three worksheets with every new workbook. You can change that automatic number if you want to. True False

False

To add a new row, click a cell in the row immediately above where you want the new row, right click, select insert and press enter. -True -False

False

To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. -True -False

False

What is represented by the small, black square in the lower-right corner of an active cell or range? 1. Repeat handle 2. Fill handle 3. Insert handle 4. Border

Fill handle

Which button allows you to copy cell formats from one cell to another? Enter Autofit Format Painter Esc

Format painter

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____. B1-G10 G10:B1 G10;B1 B1.G10

G10:B1

To select several cells or ranges that are not touching each other, you would _____ while selecting. Hold down the CTRL key Hold down the SHIFT key Hold down the ALT key None of these. You cannot select cells that are not touching each other.

Hold down the CTRL key

Labels are aligned at the ________ edge of the cell. 1. Bottom 2. Top 3. Left 4. Right

Left

The name of the active cell appears in the ___________. Formula Bar Name box Column Row Nowhere

Name box

On an Excel sheet the active cell is indicated by ____. A dotted border A blinking border A red border None of the above

None of the above

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before? Ribbon Formula Bar Tab Baskstage

Ribbon

What are the tabs that appear at the bottom of each worksheet called? Reference tabs Position tabs Location tabs Sheet tabs

Sheet tabs

To sort data in an Excel worksheet you can use the ______. 1. Sort A to Z and Sort Z to A buttons 2. Quicksort Options 3. Sort Command on the Formulas tab 4. Any of the above

Sort A to Z and Sort Z to A buttons

Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell? Count Average Sum Median CountIF

Sum

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons. True False

True

Formatting data only changes the appearance of data, it does not affect the data itself. True False

True

If a formula contains several nested functions, Excel starts with the outermost function and then moves inward. True False

True

If you choose a larger font size, the height of the row is automatically made taller. True False

True

A_______ is a group of cells that form a rectangle on the screen. Label Workbook Range Column Two of the above are correct

Two of the above are correct

Which menu option can be used to split windows into two? Format -> Window View -> Window-> Split Window -> Split View -> Split

View -> Split