Excel exam
What is the result of the following formula? =27/3+5-2^3+ (17-8)/3^2
7
The first cell in EXCEL worksheet is labeled as _________.
A1
An example of a range is
A1:B3
What happens when dollar signs ($) are entered in this address, $B$2:$B$10?
An absolute cell address is created.
The name of the active cell appears in the ___________.
Name box
To sort data in an Excel worksheet you can use the ______.
Sort A to Z and Sort Z to A buttons
=FUNCTION(argument1,argument2, ...) is ________.
The general syntax of all functions.
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 A1 and Merge cells A1:E1, then center text
Which menu option can be used to split windows into two?
View -> Split
A __________ is a grid with labeled columns and rows.
Worksheet
Once data is entered into a cell, can it be edited after saving the file?
Yes, even after saving the file, double click on the cell where data is to be changed to edit.
Which of the following is not a valid data type in Excel?
character
Which is not the function of "Edit, Clear" command?
delete cells
You can complete the entry of a cell formula that contains cell references by pressing _______.
enter key
A Formula and a function are the same thing.
false
There are three worksheets with every new workbook. You can change that automatic number if you want to.
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.
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.
false
Which button allows you to copy cell formats from one cell to another?
format printer
Which area in an Excel window allows entering values and formulas?
formula bar
How do you know a range is active?
it has a bold solid line around it
On an Excel sheet the active cell is indicated by ____.
none of the above
A_______ is a group of cells that form a rectangle on the screen.
range
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
###### in a cell means:
the cell is not wide enough
If you choose a larger font size, the height of the row is automatically made taller.
true
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: =(5-3)^2/1*2?
2
What is the result of the following formula: =8+(7/(2+5)^2-1/7)*3?
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?
=AVERAGE(A1:A5)
A Range in Microsoft Excel refers to...
A group of cells
What is the function of the autofit?
Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
In "=SUM(number1 [,number2][,number3], ...])" number 1, number 2, and number 3 may be numbers or __________.
Cell references
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:
Click Wrap text
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
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 arrow on the Paste button on the Standard toolbar, then click Values.
Which of the following is one way to change column width to fit the contents?
Double-click the boundary to the right of the column heading.
What is represented by the small, black square in the lower-right corner of an active cell or range?
Fill handle
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 _____.
G10:B1
To select several cells or ranges that are not touching each other, you would _____ while selecting.
Hold down the CTRL key
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
What are the tabs that appear at the bottom of each worksheet called?
Sheet tabs
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
Formatting data only changes the appearance of data, it does not affect the data itself.
True
If a formula contains several nested functions, Excel starts with the outermost function and then moves inward.
True
In EXCEL, you can sum a large range of data by simply selecting a tool button called _____?
autosum
Labels are aligned at the ________ edge of the cell.
left
An Excel Workbook is a collection of _______.
worksheets
Is it possible to insert a jpeg image from a file into an Excel spreadsheet?
yes
