Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
MS Excel Review
MS Excel
| Question | Answer |
|---|---|
| How do you know a range is active? | It is highlighted on a screen. |
| An example of a range address is | A1:B3 |
| When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________. | Selection Pointer |
| Which area in an Excel window allows entering values and formulas? | Formula Bar |
| A fast way to add up a column of numbers is to click in the cell below the numbers and then: | Click the Auto Sum button on the standard toolbar, then press enter |
| How do you change column width to fit the contents? | Double-click the boundary to the right of the column heading |
| ###### means: | The cell is not wide enough |
| 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 ? | Sum |
| On an Excel sheet the active cell is indicated by ____. | A dark wide border |
| In order to multiply items in Excel you would use: | * |
| If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average? | =AVERAGE(A1:A5) |
| If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total? | =SUM(A1:A5) |
| You want to join together 3 cells to make a heading in your worksheet. What is this process called? | Merge |
| _________, ________, and _______may be contained in worksheet cells in Excel? | Formulas, numbers, text |
| The intersection of a row and a column is called a | Cell |
Created by:
kbarnett1